--liquibase formatted cypher

--changeset mklypalskyi:1
-- Add correct Spotify ID to LabelParticipant
MATCH (lp:LabelParticipant {uuid: '1ea7804b-2998-47de-a499-b35bc3849ce3'})
SET lp.spotifyId = '29oAnuHTt0nstMUpXooF6R'
    , lp.updatedAt = datetime()
    , lp.updatedBy = 'database/IN-17233_add_spotifyId_and_link_to_gp';

--rollback MATCH (lp:LabelParticipant {uuid: '1ea7804b-2998-47de-a499-b35bc3849ce3'})
--rollback REMOVE lp.spotifyId, lp.updatedAt, lp.updatedBy;


--changeset mklypalskyi:2
-- Create REPRESENTS relationship between LabelParticipant and correct GlobalParticipant
MATCH (lp:LabelParticipant {uuid: '1ea7804b-2998-47de-a499-b35bc3849ce3'})
MATCH (gp:GlobalParticipant {spotifyId: '29oAnuHTt0nstMUpXooF6R'})
MERGE (gp)-[r:REPRESENTS]->(lp)
    ON CREATE SET r.createdAt = datetime()
        , r.createdBy = 'database/IN-17233_add_spotifyId_and_link_to_gp';

--rollback MATCH (lp:LabelParticipant {uuid: '1ea7804b-2998-47de-a499-b35bc3849ce3'})
--rollback MATCH (gp:GlobalParticipant {spotifyId: '29oAnuHTt0nstMUpXooF6R'})
--rollback MATCH (gp)-[r:REPRESENTS]->(lp)
--rollback DELETE r;