LABELS = [
    {"labels": ['Vendor', 'Label', 'Orchard']},
    {"labels": ['Subaccount', 'Label']},
    {"labels": ['NrContributor', 'NrOwnership']},
    {"labels": ['NrContributor', 'NrPerformance'], 'exclude': ['AccountParticipant']},
    {"labels": ['NrContributor', 'NrPerformance', 'AccountParticipant']},
    {"labels": ['NrContribution', 'NrOwnership']},
    {"labels": ['NrContribution', 'NrPerformance']},
    {"labels": ['NrProduct', 'NrOwnership']},
    {"labels": ['NrTrack', 'NrOwnership']},
    {"labels": ['NrSoundRecording', 'NrOwnership']},
    {"labels": ['NrSoundRecording', 'NrPerformance'], 'exclude': ['Orchard']},
    {"labels": ['NrSoundRecording', 'NrPerformance', 'Orchard']},
    {"labels": ['NrOwnershipService', 'NrOwnership']},
    {"labels": ['NrParticipant', 'NrPerformance']},
    {"labels": ['NrParticipant', 'NrOwnership']}
]


RELATIONS = [
    ['NrContribution', 'CONTRIBUTED_TO', 'NrSoundRecording'],
    ['NrSoundRecording', 'HAS_FEATURED_ARTIST', 'NrParticipant'],
    ['Vendor', 'HAS_NR_CONTRIBUTOR', 'NrContributor'],
    ['NrSoundRecording', 'HAS_OWNERSHIP_RULE_CARVEOUT', 'NrOwnershipService'],
    ['NrSoundRecording', 'HAS_OWNERSHIP_RULE_MONETIZE', 'NrOwnershipService'],
    ['NrSoundRecording', 'HAS_PRIMARY_ARTIST', 'NrParticipant'],
    ['NrProduct', 'INCLUDES', 'NrTrack'],
    ['NrProduct', 'HAS_PRIMARY_ARTIST', 'NrParticipant'],
    ['NrProduct', 'HAS_FEATURED_ARTIST', 'NrParticipant'],
    ['NrContributor', 'IS_FEATURING_PERFORMER', 'NrContribution'],
    ['NrContributor', 'IS_MAIN_PERFORMER', 'NrContribution'],
    ['NrTrack', 'IS_PLACEMENT_OF', 'NrSoundRecording'],
    ['NrContributor', 'IS_SESSION_MUSICIAN', 'NrContribution'],
    ['Vendor', 'OWNS', 'Subaccount']
]

INDEXABLE_LABELS = sorted(list(set([e[0] for e in RELATIONS] + [e[2] for e in RELATIONS])))

DB_PR_TEMPLATE = """<?xml version="1.0" encoding="UTF-8"?>
<changelog xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://www.liquigraph.org/schema/1.0/liquigraph.xsd">
    {changesets}
</changelog>
"""

DB_CHANGESET_TEMPLATE = """
    <changeset 
        id="{id}:{i}" 
        author="ssavva" 
        run-always="true"
    >
        <query>
        <![CDATA[
            {query}
        ]]>
        </query>
    </changeset>"""

EXPORT_FILES_PREFIX = 'NrExport__'

S3_LOCATION_PREFIX = 's3://qa-neighbouring-rights/nr-aura/dump2'

PRESIGNED_LINK_EXPIRES_IN = 36000



NODES_TO_CHECK = [
    # {'labels': ':NrContribution', 'table': 'NR_CONTRIBUTION'},
    {'labels': ':NrContribution:NrOwnership', 'table': 'OWNERSHIP_NR_CONTRIBUTION'},
    {'labels': ':NrContribution:NrPerformance', 'table': 'PERFORMANCE_NR_CONTRIBUTION'},
    # {'labels': ':NrContributor', 'table': 'NR_CONTRIBUTOR'},
    {'labels': ':NrContributor:NrOwnership', 'table': 'OWNERSHIP_NR_CONTRIBUTOR'},
    {'labels': ':NrContributor:NrPerformance', 'table': 'PERFORMANCE_NR_CONTRIBUTOR'},
    {'labels': ':NrOwnershipService', 'table': 'NR_OWNERSHIP_SERVICE'},
    # {'labels': ':NrParticipant', 'table': 'NR_PARTICIPANT'},
    {'labels': ':NrParticipant:NrOwnership', 'table': 'OWNERSHIP_NR_PARTICIPANT'},
    {'labels': ':NrParticipant:NrPerformance', 'table': 'PERFORMANCE_NR_PARTICIPANT'},
    {'labels': ':NrProduct:NrOwnership', 'table': 'NR_OWNERSHIP_PRODUCT'},
    # {'labels': ':NrSoundRecording', 'table': 'NR_SOUND_RECORDING'},
    {'labels': ':NrSoundRecording:NrOwnership', 'table': 'OWNERSHIP_NR_SOUND_RECORDING'},
    {'labels': ':NrSoundRecording:NrPerformance', 'table': 'PERFORMANCE_NR_SOUND_RECORDING'},
    {'labels': ':NrTrack', 'table': 'NR_OWNERSHIP_TRACK'},
    {'labels': ':Subaccount', 'table': 'SUBACCOUNT'},
    {'labels': ':Vendor', 'table': 'VENDOR'}
]

RELATIONS_TO_CHECK = [
    ['NrContribution', 'CONTRIBUTED_TO', 'NrSoundRecording', ''],
    ['NrSoundRecording', 'HAS_FEATURED_ARTIST', 'NrParticipant', ''],
    ['Vendor', 'HAS_NR_CONTRIBUTOR', 'NrContributor', ''],
    ['NrSoundRecording', 'HAS_OWNERSHIP_RULE_CARVEOUT', 'NrOwnershipService', 'NR_SOUND_RECORDING_HAS_CARVEOUT_RULE_OWNERSHIP_SERVICE'],
    ['NrSoundRecording', 'HAS_OWNERSHIP_RULE_MONETIZE', 'NrOwnershipService', 'NR_SOUND_RECORDING_HAS_MONETIZE_RULE_OWNERSHIP_SERVICE'],
    ['NrSoundRecording', 'HAS_PRIMARY_ARTIST', 'NrParticipant', ''],
    ['NrProduct', 'INCLUDES', 'NrTrack', ''],
    ['NrProduct', 'HAS_PRIMARY_ARTIST', 'NrParticipant', 'NR_OWNERSHIP_PRODUCT_HAS_PRIMARY_ARTIST_NR_PARTICIPANT'],
    ['NrProduct', 'HAS_FEATURED_ARTIST', 'NrParticipant', 'NR_OWNERSHIP_PRODUCT_HAS_FEATURED_ARTIST_NR_PARTICIPANT'],
    ['NrContributor', 'IS_FEATURING_PERFORMER', 'NrContribution', ''],
    ['NrContributor', 'IS_MAIN_PERFORMER', 'NrContribution', ''],
    ['NrTrack', 'IS_PLACEMENT_OF', 'NrSoundRecording', ''],
    ['NrContributor', 'IS_SESSION_MUSICIAN', 'NrContribution', ''],
    ['Vendor', 'OWNS', 'Subaccount', '']
]


# INCLUDES, IS_PLACEMENT_OF, OWNS