--liquibase formatted cypher

--changeset aoshomoji:1 runOnChange:true
-- Add correct Spotify ID to LabelParticipant
MATCH (lp:LabelParticipant {uuid: 'c93b0560-7fe0-44c7-8692-9f933cd347bc'})
SET lp.spotifyId = '6ZGwdAmu91r8mpA6SXodzd'
    , lp.updatedAt = datetime()
    , lp.updatedBy = 'database/IN-16771_add_spotifyId_and_link_to_gp';

--rollback MATCH (lp:LabelParticipant {uuid: 'c93b0560-7fe0-44c7-8692-9f933cd347bc'})
--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: 'c93b0560-7fe0-44c7-8692-9f933cd347bc'})
MATCH (gp:GlobalParticipant {spotifyId: '6ZGwdAmu91r8mpA6SXodzd'})
MERGE (gp)-[r:REPRESENTS]->(lp)
    ON CREATE SET r.createdAt = datetime()
        , r.createdBy = 'database/IN-16771_add_spotifyId_and_link_to_gp';

--rollback MATCH (lp:LabelParticipant {uuid: 'c93b0560-7fe0-44c7-8692-9f933cd347bc'})
--rollback MATCH (gp:GlobalParticipant {spotifyId: '6ZGwdAmu91r8mpA6SXodzd'})
--rollback MATCH (gp)-[r:REPRESENTS]->(lp)
--rollback DELETE r;