--liquibase formatted cypher

--changeset aoshomoji:1 runOnChange:true
-- Rollback: Remove REPRESENTS relationship between LabelParticipant and GlobalParticipant
MATCH (lp:LabelParticipant {uuid: '22ae814f-b75d-4ab3-9a50-9ffbf9c36e9e'})
MATCH (gp:GlobalParticipant {spotifyId: '0LyfQWJT6nXafLPZqxe9Of'})
MATCH (gp)-[r:REPRESENTS]->(lp)
DELETE r;

--rollback MATCH (lp:LabelParticipant {uuid: '22ae814f-b75d-4ab3-9a50-9ffbf9c36e9e'})
--rollback MATCH (gp:GlobalParticipant {spotifyId: '0LyfQWJT6nXafLPZqxe9Of'})
--rollback MERGE (gp)-[r:REPRESENTS]->(lp)
--rollback     ON CREATE SET r.createdAt = datetime()
--rollback         , r.createdBy = 'database/IN-16846_rollback';


--changeset aoshomoji:2 runOnChange:true
-- Rollback: Remove spotifyId from LabelParticipant
MATCH (lp:LabelParticipant {uuid: '22ae814f-b75d-4ab3-9a50-9ffbf9c36e9e'})
REMOVE lp.spotifyId, lp.updatedAt, lp.updatedBy;

--rollback MATCH (lp:LabelParticipant {uuid: '22ae814f-b75d-4ab3-9a50-9ffbf9c36e9e'})
--rollback SET lp.spotifyId = '0LyfQWJT6nXafLPZqxe9Of'
--rollback     , lp.updatedAt = datetime()
--rollback     , lp.updatedBy = 'database/IN-16846_rollback';