"""Cypher for ACRID operations."""

UPSERT = """
MATCH
    (a:OrchardAsset {id: $asset_id})
MERGE
    (c:ACRID {id: $acr_id})
ON CREATE SET
    c.createdAt = datetime(),
    c.lastModifiedAt = datetime(),
    c.createdBy = $by
MERGE
    (c)<-[y:FINGERPRINTED_AS]-(a)
ON CREATE SET
    y.createdAt = datetime(),
    y.createdBy = $by,
    y.lastModifiedAt = datetime(),
    y.lastModifiedBy = $by
WITH *
OPTIONAL MATCH
    (old:ACRID)<-[z:FINGERPRINTED_AS]-(a)
WHERE
    old.id <> $acr_id
RETURN
    a, COLLECT(old.id) AS old_ids
"""