--liquibase formatted cypher

--changeset aoshomoji:1 runOnChange:true
-- Add correct Spotify ID to LabelParticipant
MATCH (lp:LabelParticipant {uuid: 'd85eee46-4a65-44a7-bb5d-7af6f3e5490e'})
SET lp.spotifyId = '32gWxeDN3ZzMUNfoiKWGEr'
    , lp.updatedAt = datetime()
    , lp.updatedBy = 'database/IN-16805_add_spotifyId_and_link_to_gp';

--rollback MATCH (lp:LabelParticipant {uuid: 'd85eee46-4a65-44a7-bb5d-7af6f3e5490e'})
--rollback REMOVE lp.spotifyId, lp.updatedAt, lp.updatedBy;


--changeset aoshomoji:2 runOnChange:true
-- Create REPRESENTS relationship between LabelParticipant and correct GlobalParticipant
MATCH (lp:LabelParticipant {uuid: 'd85eee46-4a65-44a7-bb5d-7af6f3e5490e'})
MATCH (gp:GlobalParticipant {spotifyId: '32gWxeDN3ZzMUNfoiKWGEr'})
MERGE (gp)-[r:REPRESENTS]->(lp)
    ON CREATE SET r.createdAt = datetime()
        , r.createdBy = 'database/IN-16805_add_spotifyId_and_link_to_gp';

--rollback MATCH (lp:LabelParticipant {uuid: 'd85eee46-4a65-44a7-bb5d-7af6f3e5490e'})
--rollback MATCH (gp:GlobalParticipant {spotifyId: '32gWxeDN3ZzMUNfoiKWGEr'})
--rollback MATCH (gp)-[r:REPRESENTS]->(lp)
--rollback DELETE r;