--liquibase formatted cypher
--changeset mmoy:PLATFORM-4984_clean_up_double_service_tier_edges_2
--comment: Remove duplicate HAS_SERVICE_TIER edges resulting from lack of proper deletion sync from AR
--comment: This time takes into account createdAt properties being either datetime or localdatetime

MATCH (st1:ServiceTier)-[r1:IN_SERVICE_TIER]-(v:Vendor)-[r2:IN_SERVICE_TIER]-(st2:ServiceTier)
WHERE st1 <> st2 AND toString(r1.createdAt) < toString(r2.createdAt)
SET r1.lastModifiedAt = datetime(), r1.lastModifiedBy = 'database/PLATFORM-4984', r1.deletedAt = datetime(), r1.deletedBy = 'database/PLATFORM-4984'
WITH r1
CALL apoc.refactor.setType(r1, 'DELETED_IN_SERVICE_TIER')
YIELD input, output
RETURN input, output