--liquibase formatted cypher

--changeset jmarais:controlled_writers:1

MATCH (v:Vendor {uuid: "ce08a34f-8ad0-451c-be7b-626a661cc580"})
MERGE (i:IncrementId {nodeName: "PubWriterIDCounter"})
ON MATCH SET i.id = i.id + 1

CREATE (sw:PublishingSongWriter {
    id: apoc.create.uuid(),
    pubWriterID: i.id,
    legalName: "Vincent Ricky Manalo",
    pro: '',
    ipi: '',
    createdAt: datetime(),
    lastModifiedAt: datetime(),
    lastModifiedBt: 'database/PUB-1432_create_controlled_writers',
    createdBy: 'database/PUB-1432_create_controlled_writers'
})
MERGE (v)-[vendorRel:HAS_SIGNED_WRITER]->(sw)
ON CREATE SET
    vendorRel.createdAt = datetime(),
    vendorRel.lastModifiedAt = datetime(),
    vendorRel.lastModifiedBt = 'database/PUB-1432_create_controlled_writers',
    vendorRel.createdBy = 'database/PUB-1432_create_controlled_writers'

WITH sw
CREATE (a:PublishingAgreement {
    id: apoc.create.uuid(),
    controlled: true,
    excludedTerritories: [],
    labelUUID: "ce08a34f-8ad0-451c-be7b-626a661cc580",
    createdAt: datetime(),
    lastModifiedAt: datetime(),
    lastModifiedBt: 'database/PUB-1432_create_controlled_writers',
    createdBy: 'database/PUB-1432_create_controlled_writers',
    pubPublisherID: "NONE",
    pubWriterID: sw.pubWriterID
})
MERGE (sw)-[agreementRel:HAS_AGREEMENT]->(a)
ON CREATE SET
    agreementRel.createdAt = datetime(),
    agreementRel.lastModifiedAt = datetime(),
    agreementRel.lastModifiedBt = 'database/PUB-1432_create_controlled_writers',
    agreementRel.createdBy = 'database/PUB-1432_create_controlled_writers'

--changeset jmarais:controlled_writers:2

MATCH (v:Vendor {uuid: "ce08a34f-8ad0-451c-be7b-626a661cc580"})
MERGE (i:IncrementId {nodeName: "PubWriterIDCounter"})
ON MATCH SET i.id = i.id + 1

CREATE (sw:PublishingSongWriter {
    id: apoc.create.uuid(),
    pubWriterID: i.id,
    legalName: "Elizabeth Staehler",
    pro: '',
    ipi: '',
    createdAt: datetime(),
    lastModifiedAt: datetime(),
    lastModifiedBt: 'database/PUB-1432_create_controlled_writers',
    createdBy: 'database/PUB-1432_create_controlled_writers'
})
MERGE (v)-[vendorRel:HAS_SIGNED_WRITER]->(sw)
ON CREATE SET
    vendorRel.createdAt = datetime(),
    vendorRel.lastModifiedAt = datetime(),
    vendorRel.lastModifiedBt = 'database/PUB-1432_create_controlled_writers',
    vendorRel.createdBy = 'database/PUB-1432_create_controlled_writers'

WITH sw
CREATE (a:PublishingAgreement {
    id: apoc.create.uuid(),
    controlled: true,
    excludedTerritories: [],
    labelUUID: "ce08a34f-8ad0-451c-be7b-626a661cc580",
    createdAt: datetime(),
    lastModifiedAt: datetime(),
    lastModifiedBt: 'database/PUB-1432_create_controlled_writers',
    createdBy: 'database/PUB-1432_create_controlled_writers',
    pubPublisherID: "NONE",
    pubWriterID: sw.pubWriterID
})
MERGE (sw)-[agreementRel:HAS_AGREEMENT]->(a)
ON CREATE SET
    agreementRel.createdAt = datetime(),
    agreementRel.lastModifiedAt = datetime(),
    agreementRel.lastModifiedBt = 'database/PUB-1432_create_controlled_writers',
    agreementRel.createdBy = 'database/PUB-1432_create_controlled_writers'