--liquibase formatted cypher

--changeset {author}:{changesetcount}

-- {date} PUB-{jira}_touch_composition_node_{song_id_count}_pub_song_ids
;

MATCH(c:PublishingComposition)-[ha1:HAS_AGREEMENT]->
    (a:PublishingAgreement)<-[ha2:HAS_AGREEMENT]-
    (w:PublishingSongWriter)
    WHERE c.id = '{pcid}'
    WITH c, a, w, ha1, ha2
    OPTIONAL MATCH (a)<-[ha3:HAS_AGREEMENT]-(p:PublishingPublisher)
SET ha1.lastModifiedAt = datetime(),
    ha1.lastModifiedBy = '{uuid}',
    w.lastModifiedAt = datetime(),
    w.lastModifiedBy = '{uuid}',
    a.lastModifiedAt = datetime(),
    a.lastModifiedBy = '{uuid}',
    ha2.lastModifiedAt = datetime(),
    ha2.lastModifiedBy = '{uuid}',
    c.lastModifiedAt = datetime(),
    c.lastModifiedBy = '{uuid}',
    ha3.lastModifiedAt = datetime(),
    ha3.lastModifiedBy = '{uuid}',
    p.lastModifiedAt = datetime(),
    p.lastModifiedBy = '{uuid}'
RETURN c, a, w, p, ha3
;