MERGE (i:Identity {email: 'cypress_qa@theorchard.io'}) SET i.id = '33fafa64-b64f-4390-a98e-137c02c2c1ae', i.name = 'cypress_qa', i.auth0UserId = '64b4ff33923cb30747ba26c4', i.defaultBrand = "orchard" MERGE (p:Profile {profileId: 100002, profileType: 'OrchAdminProfile', fullCatalogAccess: true}) SET p.profileName = 'cypress qa', p.roles = [], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p); MERGE (i1:Identity {email: 'cypress_qa@theorchard.io'}) SET i1.id = '33fafa64-b64f-4390-a98e-137c02c2c1ae', i1.name = 'playwright_qa', i1.auth0UserId = '64b4ff33923cb30747ba26c4' MERGE (p1:Profile {profileId: 100002, profileType: 'LabelProfile'}) SET p1.profileName = 'automation_contact', p1.roles = ['administrator'], p1.uuid = randomUUID() MERGE (i1)-[:HAS_PROFILE]->(p1) WITH p1 MATCH (v1:Vendor {id: '*'}) MERGE (p1)-[:HAS_ACCESS_TO]->(v1); MERGE (i1:Identity {email: 'mlorenz+frenchkiss@theorchard.com'}) SET i1.id = '07fab3ef-565d-45d9-9c2e-366f2398f2d7', i1.name = 'Syd Butler', i1.auth0UserId = '5c799feabec43b2e754422c3' MERGE (p1:Profile {profileId: 6918, profileType: 'LabelProfile'}) SET p1.profileName = 'Syd Butler', p1.roles = ['administrator'], p1.uuid = randomUUID() MERGE (i1)-[:HAS_PROFILE]->(p1) WITH p1 MATCH (v1:Vendor {id: '*'}) MERGE (p1)-[:HAS_ACCESS_TO]->(v1); MERGE (i:Identity {email: 'cypress_qa+1@theorchard.io'}) SET i.id = 'b39ec0ed-2d2a-45bb-a9ae-15de9f822d1a', i.name = 'cypress_qa_1', i.auth0UserId = '657960eadcb67aa16c839f13', i.defaultBrand = "orchard" MERGE (p:Profile {profileId: 100003, profileType: 'OrchAdminProfile', fullCatalogAccess: true}) SET p.profileName = 'cypress qa 1', p.roles = [], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p); MERGE (i:Identity {email: 'cypress_qa+2@theorchard.io'}) SET i.id = 'a4ed20f3-3acb-4234-b0c8-d6b5949eb7e1', i.name = 'cypress_qa_2', i.auth0UserId = '65a68086b448ead3192ed118', i.defaultBrand = "orchard" MERGE (p:Profile {profileId: 100004, profileType: 'OrchAdminProfile', fullCatalogAccess: true}) SET p.profileName = 'cypress qa 2', p.roles = [], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p); MERGE (i:Identity {email: 'cypress_qa+3@theorchard.io'}) SET i.id = 'e15314a9-310d-42d4-a6bb-7c68f6c8f7e7', i.name = 'cypress_qa_3', i.auth0UserId = '65a680bcf4acafacad265ee8', i.defaultBrand = "orchard" MERGE (p:Profile {profileId: 100005, profileType: 'OrchAdminProfile', fullCatalogAccess: true}) SET p.profileName = 'cypress qa 3', p.roles = [], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p); MERGE (i:Identity {email: 'cypress_qa+4@theorchard.io'}) SET i.id = '8027036b-8a5d-4132-aab1-69c7de540f36', i.name = 'cypress_qa_4', i.auth0UserId = '65a680e72abe6450e6e88b30', i.defaultBrand = "orchard" MERGE (p:Profile {profileId: 100006, profileType: 'OrchAdminProfile', fullCatalogAccess: true}) SET p.profileName = 'cypress qa 4', p.roles = [], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p); MERGE (i:Identity {email: 'tmoin+automationtest@sonymusic-pde.com'}) SET i.id = 'cc87450a-527b-47d1-88ac-9b1a55417556', i.name = 'tmoin automationtest', i.auth0UserId = '67802d31d8e35b1f2aa33309', i.defaultBrand = "orchard" MERGE (p:Profile {profileId: 100071, profileType: 'OrchAdminProfile', fullCatalogAccess: true}) SET p.profileName = 'tmoin automationtest', p.roles = [], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p); MERGE(i:Identity{id:'6308b40a-9f56-450c-95ce-f982b4e8ca8f', active: 'Y', auth0UserCreatedBy: 'invitation', auth0UserId: '67a5e8bd54b782dfee677823', defaultBrand: 'theorchard', email: 'abacusar+tester@sonymusic-pde.com', firstName: 'Abacus', lastName: 'ARTester', localization: 'en', name: 'Abacus ARTester', numberFormat: 'us', userTypes: ['label']}) WITH i MERGE (p:Profile {profileId: 89910, profileType: 'AbacusProfile', brand: 'orchard', fullCatalogAccess: true, profileName: 'Abacus ARTester', roles: ['administrator']}) ON CREATE SET p.uuid = '12792197-a63e-451d-987e-44e41e0d8b4f' WITH p, i match(v:Vendor {id: '*'}) MERGE (i)-[:HAS_PROFILE]->(p)-[:HAS_ACCESS_TO]->(v); // Test user: insightsreal+1@sonymusic-pde.com MATCH (i:Identity {id: '455625f8-7c05-4523-80c7-68a193e57150'})-[:HAS_PROFILE]->(p:Profile {profileType: 'InsightsProfile'}) SET p.fullCatalogAccess = true, i.auth0UserId = '67a382932786bbe00342af75' WITH p MATCH (v:Vendor {id: '*'}) MERGE (p)-[:HAS_ACCESS_TO]->(v); // igorqa.9+1@awal.com does not exist in prod, so keep the original fixture id on create. MERGE (i:Identity {email: 'igorqa.9+1@awal.com'}) ON CREATE SET i.id = 'd2e7da45-d9f5-4614-ab8b-d62decb0b985' SET i.active = 'Y', i.auth0UserCreatedBy = 'invitation', i.auth0UserId = '67adc48f2931e240a722f211', i.defaultBrand = 'theorchard', i.firstName = 'Igor', i.lastName = 'Vladymyrov', i.localization = 'en', i.name = 'Test User IgorV', i.numberFormat = 'us', i.userTypes = ['label'] WITH i MERGE (p:Profile {profileId: 504367, profileType: 'InsightsProfile', brand: 'theorchard', fullCatalogAccess: true, profileName: 'Test Insights IgorV', roles: ['administrator']}) ON CREATE SET p.uuid = randomUUID() WITH p, i match(v:Vendor {id: '*'}) MERGE (i)-[:HAS_PROFILE]->(p)-[:HAS_ACCESS_TO]->(v); // insightsperformance+1@awal.com does not exist in prod, so keep the original fixture id on create. MERGE (i:Identity {email: 'insightsperformance+1@awal.com'}) ON CREATE SET i.id = '5fd01b40-97d7-4d52-8d04-e22dcf97f97c' SET i.active = 'Y', i.auth0UserCreatedBy = 'invitation', i.auth0UserId = '67e142854f47dfb1a9db81c2', i.defaultBrand = 'theorchard', i.firstName = 'Insights', i.lastName = 'Performance', i.localization = 'en', i.name = 'Insights Performance', i.numberFormat = 'us', i.userTypes = ['label'] WITH i MERGE (p:Profile {profileId: 511198, profileType: 'InsightsProfile', brand: 'theorchard', fullCatalogAccess: true, profileName: 'Insights Performance', roles: ['analytics']}) ON CREATE SET p.uuid = randomUUID() WITH p, i match(v:Vendor {id: '*'}) MERGE (i)-[:HAS_PROFILE]->(p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity{ id:'e315a2c3-345f-4877-aabf-79063117474d', active: 'Y', auth0UserCreatedBy: 'invitation', auth0UserId: '683072101a03670e51e1371b', defaultBrand: 'theorchard', email: 'songwhip+e2e-test-user@sonymusic-pde.com', firstName: 'Songwhip E2E', lastName: 'Test User', localization: 'en', name: 'Songwhip E2E Test User', numberFormat: 'us', userTypes: ['label'], organizationId: 'org_vdEfyCAGWYnTkX6G'}) WITH i MERGE (p:Profile { profileId: 540092, profileType: 'SongwhipProfile', brand: 'orchard', fullCatalogAccess: true , profileName: 'Songwhip E2E', roles: ['songwhip'] }) ON CREATE SET p.uuid = randomUUID() WITH p, i MATCH (v:Vendor { id: 7123 }) MERGE (i)-[:HAS_PROFILE]->(p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email:'graphqlAccountE2ETestMachine@sonymusic-pde.com', active: 'Y', auth0UserId: 'fa0e433c-8220-43c5-8faa-b8ef83b2526b', defaultBrand: 'theorchard', id: 'fa0e433c-8220-43c5-8faa-b8ef83b2526b', firstName: 'gqlaccount', lastName: 'testMachine', localization: 'en', name: 'gqlaccount testmachine'}) MERGE (p:Profile {profileId: 100078, profileType: 'OrchAdminProfile', fullCatalogAccess: true}) ON CREATE SET p.uuid = randomUUID(), p.profileName = 'gqlaccount testmachine' MERGE (i)-[:HAS_PROFILE]->(p); MERGE (i:Identity {email: 'evlastos+automationmfa@sonymusic-pde.com'}) SET i.id = '9591b0b0-1480-46e7-845c-99b095d2c0b9', i.name = 'evlastos automation mfa', i.auth0UserId = '685bfec7ae3b16002c99d74e', i.defaultBrand = "orchard" MERGE (p:Profile {profileId: 100079, profileType: 'OrchAdminProfile', fullCatalogAccess: true}) SET p.profileName = 'evlastos automation mfa', p.roles = [], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p); MERGE (i:Identity {email:'graphqlAccountPlaywrightE2ETestMachine@sonymusic-pde.com', active: 'Y', auth0UserId: '243c1692-fcc2-47b4-a353-6f16f586984b', defaultBrand: 'theorchard', id: '243c1692-fcc2-47b4-a353-6f16f586984b', firstName: 'gqlaccount', lastName: 'playwrightTestMachine', localization: 'en', name: 'gqlaccount playwrighttestmachine'}) MERGE (p:Profile {profileId: 100080, profileType: 'OrchAdminProfile', fullCatalogAccess: true}) ON CREATE SET p.uuid = randomUUID(), p.profileName = 'gqlaccount playwright testmachine' MERGE (i)-[:HAS_PROFILE]->(p); MERGE (i:Identity {email: 'insights_single_label+1@sonymusic-pde.com'}) SET i.id = '9cc00e44-8027-499c-beb2-1ae60a3f1c5d', i.name = 'Insights Single Label', i.auth0UserId = '68de5763fc5a1fd94f167f7b', i.defaultBrand = "orchard" MERGE (p:Profile {profileId: 646944, profileType: 'InsightsProfile', fullCatalogAccess: true}) ON CREATE SET p.profileName = 'Insights Single Label', p.roles = ['analytics'], p.uuid = randomUUID() WITH p, i MATCH (v:Vendor {id: 6971}) MERGE (i)-[:HAS_PROFILE]->(p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'e2etestnrcontributionview@theorchard.io'}) SET i.id = 'e757465d-30b0-4ac1-8f66-d19639b425e2', i.name = 'NR Contribution View Only Test', i.auth0UserId = '69160eb2f70ca72776e0095b', i.defaultBrand = "theorchard" MERGE (p:Profile {profileId: 985231, profileType: 'ContentProfile', fullCatalogAccess: true}) ON CREATE SET p.profileName = 'NR Contribution View Only Test', p.uuid = randomUUID(), p.roles = ["manage_nr_repertoire"] WITH p, i MATCH (v:Vendor {id: "*"}) MERGE (i)-[:HAS_PROFILE]->(p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'e2etestnrcontributionviewcreate@theorchard.io'}) SET i.id = '2d900e19-9985-4a62-8520-c5e597c4faa5', i.name = 'NR Contribution View Create Test', i.auth0UserId = '69170b2f9771881e565e7fcb', i.defaultBrand = "theorchard" MERGE (p:Profile {profileId: 985232, profileType: 'ContentProfile', fullCatalogAccess: true}) ON CREATE SET p.profileName = 'NR Contribution View Create Test', p.uuid = randomUUID(), p.roles = ["manage_nr_repertoire"] WITH p, i MATCH (v:Vendor {id: "*"}) MERGE (i)-[:HAS_PROFILE]->(p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'e2etestnrcontributionviewcreatemanage@theorchard.io'}) SET i.id = 'c5db0926-f5c8-4966-9dfd-65e8edf8c693', i.name = 'NR Contribution View Create Manage Test', i.auth0UserId = '69170cae9771881e565e808f', i.defaultBrand = "theorchard" MERGE (p:Profile {profileId: 985233, profileType: 'ContentProfile', fullCatalogAccess: true}) ON CREATE SET p.profileName = 'NR Contribution View Create Manage Test', p.uuid = randomUUID(), p.roles = ["manage_nr_repertoire"] WITH p, i MATCH (v:Vendor {id: "*"}) MERGE (i)-[:HAS_PROFILE]->(p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'e2etestnrcontributionviewcreatemanagedelete@theorchard.io'}) SET i.id = 'a3c6983b-fb19-4b47-b2a2-de2ff7b53cbb', i.name = 'NR Contribution View Create Manage Delete Test', i.auth0UserId = '69170e2deaf3446dfbf8d760', i.defaultBrand = "theorchard" MERGE (p:Profile {profileId: 985234, profileType: 'ContentProfile', fullCatalogAccess: true}) ON CREATE SET p.profileName = 'NR Contribution View Create Manage Delete Test', p.uuid = randomUUID(), p.roles = ["manage_nr_repertoire"] WITH p, i MATCH (v:Vendor {id: "*"}) MERGE (i)-[:HAS_PROFILE]->(p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'awaladmin+v1@theorchard.io'}) SET i.id = '51d0b1da-128a-4e2f-8ac1-05de7da6b55a', i.name = 'Awal Admin' MERGE (p:Profile {profileId: 345485, profileType: 'SettingsProfile'}) SET p.profileName = 'settings awaladmin profile', p.brand = 'awal', p.uuid = randomUUID() WITH i,p MATCH (v1:Vendor {id: 35974}) MATCH (v2:Vendor {id: 35972}) MATCH (v3:Vendor {id: 35968}) MATCH (v4:Vendor {id: 6971}) MATCH (v5:Vendor {id: 67130}) MERGE (i)-[rel:HAS_PROFILE]->(p) MERGE (p)-[:HAS_ADMIN_ACCESS_TO]->(v1) MERGE (p)-[:HAS_ADMIN_ACCESS_TO]->(v2) MERGE (p)-[:HAS_ADMIN_ACCESS_TO]->(v3) MERGE (p)-[:HAS_ADMIN_ACCESS_TO]->(v4) MERGE (p)-[:HAS_ADMIN_ACCESS_TO]->(v5); MERGE (i:Identity {email: 'knradmin+v1@theorchard.io'}) SET i.id = '0a05c46a-fda7-4119-96ed-13833a661bc1', i.name = 'KNR Admin' MERGE (p:Profile {profileId: 345522, profileType: 'SettingsProfile'}) SET p.profileName = 'settings knradmin profile v1', p.brand = 'knr', p.uuid = randomUUID() WITH i,p MATCH (v1:Vendor {id: 67130}) MATCH (v2:Vendor {id: 6971}) MATCH (v3:Vendor {id: 72374}) MATCH (v4:Vendor {id: 35968}) MERGE (i)-[rel:HAS_PROFILE]->(p) MERGE (p)-[:HAS_ADMIN_ACCESS_TO]->(v1) MERGE (p)-[:HAS_ADMIN_ACCESS_TO]->(v2) MERGE (p)-[:HAS_ADMIN_ACCESS_TO]->(v3) MERGE (p)-[:HAS_ADMIN_ACCESS_TO]->(v4); MERGE (i:Identity {email: 'tester+v1@settingstesting.com'}) SET i.id = '5c0145b4-e7d4-4e9b-a794-56c1807d73fc', i.auth0UserId = '691efd9f5117ec765ed8da7b' MERGE (p:Profile {profileId: 36036, profileType: 'InsightsProfile'}) SET p.profileName = 'e2e test profile v1', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[rel:HAS_PROFILE]->(p) WITH p,i MATCH (v:Vendor {id: '*'}) MERGE (p)-[:HAS_ACCESS_TO]->(v) WITH v,i MERGE (p3:Profile {profileId: 71799, profileType: 'SettingsProfile'}) SET p3.profileName = 'e2e test settings profile v1', p3.fullCatalogAccess = true, p3.uuid = '44656247-f5d6-474d-a7a9-4230929a51e1' MERGE (i)-[rel:HAS_PROFILE]->(p3) MERGE (p3)-[:HAS_ACCESS_TO]->(v) WITH i MERGE (p2:Profile {profileId: 60836, profileType: 'LabelProfile'}) SET p2.profileName = 'settings test label profile v1', p2.roles = ['analytics'], p2.uuid = randomUUID() MERGE (i)-[rel2:HAS_PROFILE]->(p2) WITH p2,i MATCH (v2:Vendor {id: 6971}) MERGE (p2)-[:HAS_ACCESS_TO]->(v2); MERGE (i:Identity {email: 'qa_workstation_e2etest+label18805@sonymusic-pde.com'}) SET i.id = '6d2ff3d4-e25e-4767-80a4-6452ef7ef170', i.auth0UserId = '697a267df457235fbda8659c', i.name = 'Iwan Shields' MERGE (p:Profile {profileId: 985234, profileType: 'LabelProfile'}) SET p.profileId = 985234, p.profileName = 'qa_workstation_e2etest+label18805', p.roles = ['catalog'], p.uuid = 'b5375340-53cb-47c2-a009-f066295266c1' MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 18805}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label15063_1@sonymusic-pde.com'}) SET i.id = '7c56ced2-d64f-4b97-b0b4-7c939cf6d87a', i.auth0UserId = '697b3f84fe72cc1d041c01b7', i.name = 'Chase Knobbe' MERGE (p:Profile {profileId: 985235, profileType: 'LabelProfile'}) SET p.profileId = 985235, p.profileName = 'qa_workstation_e2etest+label15063_1', p.roles = ['catalog'], p.uuid = 'b6873b1c-2be2-4317-b247-e9824b5dffd0' MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 15063}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label15063_2@sonymusic-pde.com'}) SET i.id = '934cc184-c8fe-4f3b-9465-1c3ddb6e2da8', i.auth0UserId = '69833b31af94daafaccedee4', i.name = 'Matt Ebert' MERGE (p:Profile {profileId: 985236, profileType: 'LabelProfile'}) SET p.profileId = 985236, p.profileName = 'qa_workstation_e2etest+label15063_2', p.roles = ['advertising','analytics','catalog','manage_rights','marketing'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 15063}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label15063_3@sonymusic-pde.com'}) SET i.id = 'f996b2fa-72cd-4176-9f1e-be6d932a8207', i.auth0UserId = '69833a7a32c503550bc6cbb8', i.name = 'Barry Johnson' MERGE (p:Profile {profileId: 985237, profileType: 'LabelProfile'}) SET p.profileId = 985237, p.profileName = 'qa_workstation_e2etest+label15063_3', p.roles = ['advertising','analytics','catalog','manage_rights','marketing'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 15063}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_7482@sonymusic-pde.com'}) SET i.id = '07360dc9-7b6a-4cc4-8dc2-11653790b169', i.auth0UserId = '698c596e5b32029674472bd6', i.name = 'Brendon Hale' MERGE (p:Profile {profileId: 985238, profileType: 'LabelProfile'}) SET p.profileId = 985238, p.profileName = 'qa_workstation_e2etest+label_7482', p.roles = ['catalog'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 7482}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_15063_admin@sonymusic-pde.com'}) SET i.id = 'aa6377f9-d269-4aae-ab6c-dce71433915e', i.auth0UserId = '698cb5b7e3d8aa9c36fab98d', i.name = 'Keiran Stuart' MERGE (p:Profile {profileId: 985239, profileType: 'LabelProfile'}) SET p.profileId = 985239, p.profileName = 'qa_workstation_e2etest+label_15063_admin', p.roles = ['administrator','catalog','analytics','marketing','manage_rights','advertising'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 15063}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label16055_d3@sonymusic-pde.com'}) SET i.id = 'caf9db5b-87fc-4127-a167-dba14ae67f55', i.auth0UserId = '699447fceb80e78ad0665be9', i.name = 'Roberta Logan' MERGE (p:Profile {profileId: 985240, profileType: 'LabelProfile'}) SET p.profileId = 985240, p.profileName = 'qa_workstation_e2etest+label16055_d3', p.roles = ['manage_rights','catalog','administrator','analytics','advertising','marketing'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 16055}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_25824_catalog_only@sonymusic-pde.com'}) SET i.id = '03b48ba4-b208-4330-929d-2c345dcd2eaf', i.auth0UserId = '69945b11454bb7b4803b3c74', i.name = 'Jackson Beltran' MERGE (p:Profile {profileId: 985241, profileType: 'LabelProfile'}) SET p.profileId = 985241, p.profileName = 'qa_workstation_e2etest+label_25824_catalog_only', p.roles = ['catalog'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 25824}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_25824_accounting_only@sonymusic-pde.com'}) SET i.id = 'bddee9a4-92da-4193-9bef-29c3425df0fa', i.auth0UserId = '6994a0f7454bb7b4803b765e', i.name = 'Richie Spence' MERGE (p:Profile {profileId: 985242, profileType: 'LabelProfile'}) SET p.profileId = 985242, p.profileName = 'qa_workstation_e2etest+label_25824_accounting_only', p.roles = ['accounting'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 25824}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_25824_analytics_only@sonymusic-pde.com'}) SET i.id = 'e869680f-2824-4517-9ab9-92c21b227428', i.auth0UserId = '699594aa4058a38b0b5959d0', i.name = 'Ronald Owen' MERGE (p:Profile {profileId: 985243, profileType: 'LabelProfile'}) SET p.profileId = 985243, p.profileName = 'qa_workstation_e2etest+label_25824_analytics_only', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 25824}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_25824_manage_rights_only@sonymusic-pde.com'}) SET i.id = '1c92aae2-1f15-4834-9682-9633beba8032', i.auth0UserId = '69959bf69f13feea550ea0b5', i.name = 'Marshall Shelton' MERGE (p:Profile {profileId: 985244, profileType: 'LabelProfile'}) SET p.profileId = 985244, p.profileName = 'qa_workstation_e2etest+label_25824_manage_rights_only', p.roles = ['catalog', 'manage_rights'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 25824}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_25824_marketing_only@sonymusic-pde.com'}) SET i.id = 'd75d1f60-f132-42fc-ab55-5086526267ea', i.auth0UserId = '6995a15073a497db6d441d99', i.name = 'Charley Cherry' MERGE (p:Profile {profileId: 985245, profileType: 'LabelProfile'}) SET p.profileId = 985245, p.profileName = 'qa_workstation_e2etest+label_25824_marketing_only', p.roles = ['marketing'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 25824}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_6971_admin@sonymusic-pde.com'}) SET i.id = '458c62ae-38e6-416b-a417-8e6827d7eef7', i.auth0UserId = '6995aecd6999c2eae6da5283', i.name = 'Natalia Petty' MERGE (p:Profile {profileId: 985246, profileType: 'LabelProfile'}) SET p.profileId = 985246, p.profileName = 'qa_workstation_e2etest+label_6971_admin', p.roles = ['catalog', 'marketing', 'analytics', 'administrator', 'manage_rights', 'advertising'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 6971}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_9808_admin@sonymusic-pde.com'}) SET i.id = '7eea8499-01e2-4b5d-87be-9870386094f7', i.auth0UserId = '6995c8927489794c8ef06151', i.name = 'Glenn Norman' MERGE (p:Profile {profileId: 985247, profileType: 'LabelProfile'}) SET p.profileId = 985247, p.profileName = 'qa_workstation_e2etest+label_9808_admin', p.roles = ['catalog', 'marketing', 'analytics', 'administrator', 'manage_rights', 'advertising'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 9808}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_16155_admin@sonymusic-pde.com'}) SET i.id = '65bcf298-7878-40fc-b927-25cd323b69a3', i.auth0UserId = '6995cda59be030d1a0403043', i.name = 'Jemima Mitchell' MERGE (p:Profile {profileId: 985248, profileType: 'LabelProfile'}) SET p.profileId = 985248, p.profileName = 'qa_workstation_e2etest+label_16155_admin', p.roles = ['catalog', 'marketing', 'analytics', 'administrator', 'manage_rights', 'advertising'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 16155}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_16156_admin@sonymusic-pde.com'}) SET i.id = '2ae1103a-629c-4f01-ba35-be295f1448b3', i.auth0UserId = '6995d99d64535b0727545f20', i.name = 'Jayden Dotson' MERGE (p:Profile {profileId: 985249, profileType: 'LabelProfile'}) SET p.profileId = 985249, p.profileName = 'qa_workstation_e2etest+label_16156_admin', p.roles = ['catalog', 'marketing', 'analytics', 'administrator', 'manage_rights', 'advertising'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 16156}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_17194_admin@sonymusic-pde.com'}) SET i.id = '8e2c48c6-c213-4f83-90a0-409ba350889d', i.auth0UserId = '6995ddb46f5ef1ad20f9ad7d', i.name = 'Esha Haas' MERGE (p:Profile {profileId: 985250, profileType: 'LabelProfile'}) SET p.profileId = 985250, p.profileName = 'qa_workstation_e2etest+label_17194_admin', p.roles = ['catalog', 'marketing', 'analytics', 'administrator', 'manage_rights', 'advertising'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 17194}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+subaccount_10182_user@sonymusic-pde.com'}) SET i.id = '97047d2f-d1a2-4e01-b084-cfd829c65ac4', i.auth0UserId = '6995da68b0a71aaf34bb1365', i.name = 'Tabitha Knowles' MERGE (p:Profile {profileId: 985251, profileType: 'LabelProfile'}) SET p.profileId = 985251, p.profileName = 'qa_workstation_e2etest+subaccount_10182_user', p.roles = ['catalog'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (s:SubAccount {id: 10182}) MERGE (p)-[:HAS_ACCESS_TO]->(s); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_21989_admin@sonymusic-pde.com'}) SET i.id = 'c93e785b-98ad-4c8e-bb67-fec7929ec179', i.auth0UserId = '6995e14c68385301888006a2', i.name = 'Carmen Clayton' MERGE (p:Profile {profileId: 985252, profileType: 'LabelProfile'}) SET p.profileId = 985252, p.profileName = 'qa_workstation_e2etest+label_21989_admin', p.roles = ['catalog', 'marketing', 'analytics', 'administrator', 'manage_rights', 'advertising'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 21989}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+label_7123_admin@sonymusic-pde.com'}) SET i.id = '0c8cd261-f335-4298-9dd3-e389abc5e842', i.auth0UserId = '6996f0460ad4e8ddd75b3990', i.name = 'Katherine Rice' MERGE (p:Profile {profileId: 985253, profileType: 'LabelProfile'}) SET p.profileId = 985253, p.profileName = 'qa_workstation_e2etest+label_7123_admin', p.roles = ['catalog', 'marketing', 'analytics', 'administrator', 'manage_rights', 'advertising'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 7123}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MERGE (i:Identity {email: 'qa_workstation_e2etest+subaccount_1_user@sonymusic-pde.com'}) SET i.id = 'cf31201d-a66a-479d-b6c9-39b03d690833', i.auth0UserId = '69970c19761c7c749a7adfd7', i.name = 'Aarav Solomon' MERGE (p:Profile {profileId: 985254, profileType: 'LabelProfile'}) SET p.profileId = 985254, p.profileName = 'qa_workstation_e2etest+subaccount_1_user', p.roles = ['catalog', 'marketing', 'analytics', 'administrator', 'manage_rights', 'advertising'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (s:SubAccount {id: 1}) MERGE (p)-[:HAS_ACCESS_TO]->(s); MERGE (i:Identity {email: 'qa_workstation_e2etest+subaccount_7584_user@sonymusic-pde.com'}) SET i.id = 'f16acd4f-3c4e-433b-8f22-061882a737ea', i.auth0UserId = '699710fc761c7c749a7ae358', i.name = 'Kallum Ayers' MERGE (p:Profile {profileId: 985255, profileType: 'LabelProfile'}) SET p.profileId = 985255, p.profileName = 'qa_workstation_e2etest+subaccount_7584_user', p.roles = ['catalog', 'manage_rights', 'analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (s:SubAccount {id: 7584}) MERGE (p)-[:HAS_ACCESS_TO]->(s); // Test user: qa_moneyhub_e2etest+26760_d3@sonymusic-pde.com MERGE (i:Identity {email: 'qa_moneyhub_e2etest+26760_d3@sonymusic-pde.com'}) SET i.id = 'c07a8ddc-c520-4b9e-9866-44ff7644b1f0', i.auth0UserId = '69b1847db3610517067a9569', i.name = 'd3 Tester' MERGE (p:Profile {profileId: 9900003, profileType: 'MoneyhubProfile'}) SET p.profileId = 9900003, p.profileName = 'qa_moneyhub_e2etest+26760_d3', p.roles = ['accounting'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v:Vendor {id: 26760}) MERGE (p)-[:HAS_ACCESS_TO]->(v); // Test user: qa_abacus_e2etest+7123@sonymusic-pde.com MERGE (i:Identity {email: 'qa_abacus_e2etest+7123@sonymusic-pde.com'}) SET i.id = '462a2fd4-89db-47f0-aac6-e96df9e7cdae', i.auth0UserId = '69c129ce8d142af04c1a6806', i.name = 'abacus playwright user 1 abacus playwright user 1' MERGE (p:Profile {profileId: 9900004, profileType: 'AbacusProfile'}) SET p.profileId = 9900004, p.profileName = 'qa_abacus_e2etest+7123', p.roles = ['administrator'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: '*'}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Test user: qa_collaborators_e2etest+collaborators_test@sonymusic-pde.com MERGE (i:Identity {email: 'qa_collaborators_e2etest+collaborators_test@sonymusic-pde.com'}) SET i.id = 'aebdec09-14c5-4c75-92fd-3d8f2b7b23a3', i.auth0UserId = '69ce88951db849f885d4c789', i.name = 'Collaborators Tester', i.numberFormat = "us", i.active = "Y" MERGE (cp:Profile {profileId: 9900005, profileType: 'CollaboratorsProfile'}) SET cp.profileId = 9900005, cp.profileName = 'qa_collaborators_e2etest+collaborators_test', cp.roles = ['royalties'], cp.uuid = randomUUID() MERGE (sp:Profile {profileId: 685247, profileType: 'SettingsProfile'}) SET sp.profileName = 'Collaborators Tester', sp.roles = [], sp.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(cp) MERGE (i)-[:HAS_PROFILE]->(sp) WITH cp, sp MATCH (v25153:Vendor {id: 25153}) MATCH (v35598:Vendor {id: 35598}) MATCH (v6971:Vendor {id: 6971}) MERGE (cp)-[:HAS_ACCESS_TO]->(v25153) MERGE (cp)-[:HAS_ACCESS_TO]->(v35598) MERGE (cp)-[:HAS_ACCESS_TO]->(v6971) MERGE (sp)-[:HAS_ADMIN_ACCESS_TO]->(v6971) MERGE (sp)-[:HAS_ADMIN_ACCESS_TO]->(v25153); // Test user: qa_e2e_test+seat@sonymusic-pde.com // SEAT E2E test admin - can login to SEAT and administer employees across both parent companies MERGE (i:Identity {email: 'qa_e2e_test+seat@sonymusic-pde.com'}) SET i.id = '05b63ee6-e6ee-4384-bfdf-3556658e4779', i.name = 'SEAT E2E Test Admin', i.auth0UserId = '69de16c159e8158cff2f04e8', i.active = 'Y', i.defaultBrand = 'theorchard', i.createdBy = 'python-neo4j-cypher-scheduler/queries/qa-refresh/12_e2e_test_users.cypher', i.lastModifiedBy = 'python-neo4j-cypher-scheduler/queries/qa-refresh/12_e2e_test_users.cypher', i.createdAt = datetime(), i.lastModifiedAt = datetime() MERGE (i)-[:HAS_PROFILE]->(sp:Profile {profileId: 9900006, profileType: 'SettingsProfile'}) SET sp.profileName = 'SEAT E2E Test Admin settings profile', sp.fullCatalogAccess = true, sp.uuid = '3d281764-c438-4ea2-be27-7c80044fff74', sp.createdAt = datetime(), sp.lastModifiedAt = datetime(), sp.createdBy = 'python-neo4j-cypher-scheduler/queries/qa-refresh/12_e2e_test_users.cypher', sp.lastModifiedBy = 'python-neo4j-cypher-scheduler/queries/qa-refresh/12_e2e_test_users.cypher' WITH sp MATCH (v:Vendor {id: '*'}) MERGE (sp)-[:HAS_ADMIN_ACCESS_TO]->(v); // Test user: qa_workstation_e2etest+label_7482_25870_multi@sonymusic-pde.com // One LabelProfile node per vendor so ows-users `linked_accounts` can resolve // the workstation account-switch dropdown (the dropdown is keyed off distinct // profileIds joined to MySQL vend_contact rows). MERGE (i:Identity {email: 'qa_workstation_e2etest+label_7482_25870_multi@sonymusic-pde.com'}) SET i.id = '041986fd-4a04-426f-87cc-81b90c399673', i.auth0UserId = '69f32bd6bc2e25d1111559a6', i.name = 'MultiVendor Tester'; MATCH (i:Identity {id: '041986fd-4a04-426f-87cc-81b90c399673'}) MERGE (p0:Profile {profileId: 9900007, profileType: 'LabelProfile'}) SET p0.profileName = 'qa_workstation_e2etest+label_7482_25870_multi', p0.roles = ['catalog', 'marketing', 'analytics'], p0.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p0) WITH p0 MATCH (v0:Vendor {id: 7482}) MERGE (p0)-[:HAS_ACCESS_TO]->(v0); MATCH (i:Identity {id: '041986fd-4a04-426f-87cc-81b90c399673'}) MERGE (p1:Profile {profileId: 9900008, profileType: 'LabelProfile'}) SET p1.profileName = 'qa_workstation_e2etest+label_7482_25870_multi_25870', p1.roles = ['catalog', 'marketing', 'analytics'], p1.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p1) WITH p1 MATCH (v1:Vendor {id: 25870}) MERGE (p1)-[:HAS_ACCESS_TO]->(v1); // Test user: qa_insights_e2etest+AWAL_ANDROID@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+AWAL_ANDROID@sonymusic-pde.com'}) SET i.id = '232b387c-6904-400d-bd13-d1948eebfdd0', i.auth0UserId = '69faf994c78356649dda21a0', i.name = 'Igor Vladymyrov' MERGE (p:Profile {profileId: 9900009, profileType: 'InsightsProfile'}) SET p.profileId = 9900009, p.profileName = 'qa_insights_e2etest+AWAL_ANDROID', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 83526}) MERGE (p)-[:HAS_ACCESS_TO]->(v0) WITH p MATCH (v1:Vendor {id: 7123}) MERGE (p)-[:HAS_ACCESS_TO]->(v1) WITH p MATCH (v2:Vendor {id: 6971}) MERGE (p)-[:HAS_ACCESS_TO]->(v2); // Test user: qa_workstation_e2etest+label_21989@sonymusic-pde.com // One LabelProfile node per vendor so ows-users `linked_accounts` can resolve // the workstation account-switch dropdown (the dropdown is keyed off distinct // profileIds joined to MySQL vend_contact rows). MERGE (i:Identity {email: 'qa_workstation_e2etest+label_21989@sonymusic-pde.com'}) SET i.id = 'f924d403-4fc7-4740-875f-df10aebcc4f1', i.auth0UserId = '69fd9ef6484159cbd12206c5', i.name = 'Darren Test User'; MATCH (i:Identity {id: 'f924d403-4fc7-4740-875f-df10aebcc4f1'}) MERGE (p0:Profile {profileId: 9900010, profileType: 'LabelProfile'}) ON CREATE SET p0.uuid = randomUUID() SET p0.profileName = 'qa_workstation_e2etest+label_21989', p0.roles = ['catalog', 'marketing', 'analytics', 'administrator', 'manage rights', 'advertising'] MERGE (i)-[:HAS_PROFILE]->(p0) WITH p0 MATCH (v0:Vendor {id: 21989}) MERGE (p0)-[:HAS_ACCESS_TO]->(v0); MATCH (i:Identity {id: 'f924d403-4fc7-4740-875f-df10aebcc4f1'}) MERGE (p1:Profile {profileId: 9900011, profileType: 'LabelProfile'}) ON CREATE SET p1.uuid = randomUUID() SET p1.profileName = 'qa_workstation_e2etest+label_25824', p1.roles = ['catalog', 'marketing', 'analytics', 'administrator', 'manage rights', 'advertising'] MERGE (i)-[:HAS_PROFILE]->(p1) WITH p1 MATCH (v1:Vendor {id: 25824}) MERGE (p1)-[:HAS_ACCESS_TO]->(v1); // Test user: qa_workstation_e2etest+PORT_admin@sonymusic-pde.com MERGE (i:Identity {email: 'qa_workstation_e2etest+PORT_admin@sonymusic-pde.com'}) SET i.id = '25a35480-ff7c-4d85-9ab8-a6043f773c3c', i.auth0UserId = '69fdae595ce8384188c106cb', i.name = 'Port Admin' MERGE (p:Profile {profileId: 9900012, profileType: 'LabelProfile'}) SET p.profileId = 9900012, p.profileName = 'qa_workstation_e2etest+PORT_admin', p.roles = ['catalog', 'marketing', 'analytics', 'administrator', 'manage rights', 'advertising'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 7123}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Additional profiles for PORT admin MATCH (i:Identity {id: '25a35480-ff7c-4d85-9ab8-a6043f773c3c'}) MERGE (p:Profile {profileId: 9900013, profileType: 'InsightsProfile'}) SET p.profileName = 'qa_workstation_e2etest+PORT_admin', p.roles = ['administrator', 'analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH i, p MATCH (v:Vendor {id: '*'}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MATCH (i:Identity {id: '25a35480-ff7c-4d85-9ab8-a6043f773c3c'}) MERGE (p:Profile {profileId: 9900014, profileType: 'MoneyhubProfile'}) SET p.profileName = 'qa_workstation_e2etest+PORT_admin', p.roles = ['administrator', 'accounting'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH i, p MATCH (v:Vendor {id: '*'}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MATCH (i:Identity {id: '25a35480-ff7c-4d85-9ab8-a6043f773c3c'}) MERGE (p:Profile {profileId: 9900015, profileType: 'ContentProfile'}) SET p.profileName = 'qa_workstation_e2etest+PORT_admin', p.roles = ['administrator', 'review_digital_audio', 'manage_nr_repertoire', 'manage_nr_ownership', 'view_orchard_sound_recording'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH i, p MATCH (v:Vendor {id: '*'}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MATCH (i:Identity {id: '25a35480-ff7c-4d85-9ab8-a6043f773c3c'}) MERGE (p:Profile {profileId: 9900016, profileType: 'AbacusProfile'}) SET p.profileName = 'qa_workstation_e2etest+PORT_admin', p.roles = ['administrator'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH i, p MATCH (v:Vendor {id: '*'}) MERGE (p)-[:HAS_ACCESS_TO]->(v); // Test user: qa_workstation_e2etest+PORT_destination_account@sonymusic-pde.com MERGE (i:Identity {email: 'qa_workstation_e2etest+PORT_destination_account@sonymusic-pde.com'}) SET i.id = '4ded9eb9-7d94-4386-bf0b-b720aacc8131', i.auth0UserId = '6a01b505c030ba436f85523d', i.name = 'Port Destination' MERGE (p:Profile {profileId: 9900017, profileType: 'LabelProfile'}) SET p.profileId = 9900017, p.profileName = 'qa_workstation_e2etest+PORT_destination_account', p.roles = ['catalog', 'marketing', 'analytics', 'administrator', 'manage rights', 'advertising'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 7123}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Additional profiles for PORT destination account user MATCH (i:Identity {id: '4ded9eb9-7d94-4386-bf0b-b720aacc8131'}) MERGE (p:Profile {profileId: 9900018, profileType: 'InsightsProfile'}) SET p.profileName = 'qa_workstation_e2etest+PORT_destination_account', p.roles = ['administrator', 'analytics'], p.fullCatalogAccess = true, p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH i, p MATCH (v:Vendor {id: 7123}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MATCH (i:Identity {id: '4ded9eb9-7d94-4386-bf0b-b720aacc8131'}) MERGE (p:Profile {profileId: 9900019, profileType: 'MoneyhubProfile'}) SET p.profileName = 'qa_workstation_e2etest+PORT_destination_account', p.roles = ['administrator', 'accounting'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH i, p MATCH (v:Vendor {id: 7123}) MERGE (p)-[:HAS_ACCESS_TO]->(v); MATCH (i:Identity {id: '4ded9eb9-7d94-4386-bf0b-b720aacc8131'}) MERGE (p:Profile {profileId: 9900020, profileType: 'AbacusProfile'}) SET p.profileName = 'qa_workstation_e2etest+PORT_destination_account', p.roles = ['administrator'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH i, p MATCH (v:Vendor {id: 7123}) MERGE (p)-[:HAS_ACCESS_TO]->(v); // Test user: qa_moneyhub_e2etest+collaborator_user@sonymusic-pde.com MERGE (i:Identity {email: 'qa_moneyhub_e2etest+collaborator_user@sonymusic-pde.com'}) SET i.id = 'ae8cfe6e-ce68-49fa-a67e-f9d728c64818', i.auth0UserId = '6a0306244f2e074f254d97f3', i.name = 'Collaborator testuser' MERGE (p:Profile {profileId: 9900021, profileType: 'MoneyhubProfile'}) SET p.profileId = 9900021, p.profileName = 'qa_moneyhub_e2etest+collaborator_user', p.roles = ['accounting'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (c:Collaborator {id: 37355}) MERGE (p)-[:HAS_ACCESS_TO]->(c); // Test user: qa_insights_e2etest+awal_ios_20260513@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+awal_ios_20260513@sonymusic-pde.com'}) SET i.id = '2a41de35-17f8-4c29-80a4-3af7beb7020b', i.auth0UserId = '6a04584031d6c92bae8ebde2', i.name = 'Igor Vladymyrov' MERGE (p:Profile {profileId: 9900026, profileType: 'InsightsProfile'}) SET p.profileId = 9900026, p.profileName = 'qa_insights_e2etest+awal_ios_20260513', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 83526}) MERGE (p)-[:HAS_ACCESS_TO]->(v0) WITH p MATCH (v1:Vendor {id: 7123}) MERGE (p)-[:HAS_ACCESS_TO]->(v1) WITH p MATCH (v2:Vendor {id: 6971}) MERGE (p)-[:HAS_ACCESS_TO]->(v2); // Test user: qa_insights_e2etest+orchardgo_android_20260513@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+orchardgo_android_20260513@sonymusic-pde.com'}) SET i.id = 'e403b40c-687d-465b-b8e8-9eb274955f42', i.auth0UserId = '6a04553562af8247acd02376', i.name = 'Igor Vladymyrov' MERGE (p:Profile {profileId: 9900025, profileType: 'InsightsProfile'}) SET p.profileId = 9900025, p.profileName = 'qa_insights_e2etest+orchardgo_android_20260513', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 6971}) MERGE (p)-[:HAS_ACCESS_TO]->(v0) WITH p MATCH (v1:Vendor {id: 7123}) MERGE (p)-[:HAS_ACCESS_TO]->(v1); // Test user: qa_insights_e2etest+orchardgo_ios_20260513@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+orchardgo_ios_20260513@sonymusic-pde.com'}) SET i.id = '610a2a69-cc34-4261-9537-c873f5e36e02', i.auth0UserId = '6a04548bdfc5a988963dbe9d', i.name = 'Igor Vladymyrov' MERGE (p:Profile {profileId: 9900024, profileType: 'InsightsProfile'}) SET p.profileId = 9900024, p.profileName = 'qa_insights_e2etest+orchardgo_ios_20260513', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 6971}) MERGE (p)-[:HAS_ACCESS_TO]->(v0) WITH p MATCH (v1:Vendor {id: 7123}) MERGE (p)-[:HAS_ACCESS_TO]->(v1); // Test user: qa_insights_e2etest+sme_android_20260513@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+sme_android_20260513@sonymusic-pde.com'}) SET i.id = 'd77a0450-36a7-41e1-a360-8a03071325f9', i.auth0UserId = '6a0450631e234ebc3b39db38', i.name = 'Igor Vladymyrov' MERGE (p:Profile {profileId: 9900023, profileType: 'InsightsProfile'}) SET p.profileId = 9900023, p.profileName = 'qa_insights_e2etest+sme_android_20260513', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 22395}) MERGE (p)-[:HAS_ACCESS_TO]->(v0) WITH p MATCH (v1:Vendor {id: 6971}) MERGE (p)-[:HAS_ACCESS_TO]->(v1) WITH p MATCH (v2:Vendor {id: 7123}) MERGE (p)-[:HAS_ACCESS_TO]->(v2); // Test user: qa_insights_e2etest+sme_ios_20260513@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+sme_ios_20260513@sonymusic-pde.com'}) SET i.id = '8a137f3e-2e61-4b0b-8845-15a1584c3b2a', i.auth0UserId = '6a044e1ba552caef460d4be8', i.name = 'Igor Vladymyrov' MERGE (p:Profile {profileId: 9900022, profileType: 'InsightsProfile'}) SET p.profileId = 9900022, p.profileName = 'qa_insights_e2etest+sme_ios_20260513', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 22395}) MERGE (p)-[:HAS_ACCESS_TO]->(v0) WITH p MATCH (v1:Vendor {id: 6971}) MERGE (p)-[:HAS_ACCESS_TO]->(v1) WITH p MATCH (v2:Vendor {id: 7123}) MERGE (p)-[:HAS_ACCESS_TO]->(v2); // Test user: qa_insights_e2etest+subaccount_7645@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+subaccount_7645@sonymusic-pde.com'}) SET i.id = '2776cad6-b091-41a9-8ec2-75797b517037', i.auth0UserId = '6a0714444a8304a1641267ea', i.name = 'Port Subaccount' MERGE (p:Profile {profileId: 9900027, profileType: 'InsightsProfile'}) SET p.profileId = 9900027, p.profileName = 'qa_insights_e2etest+subaccount_7645', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (s:SubAccount {id: 7645}) MERGE (p)-[:HAS_ACCESS_TO]->(s); // Test user: qa_insights_e2etest+subaccount_7645_2@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+subaccount_7645_2@sonymusic-pde.com'}) SET i.id = '6e2bb814-67be-443a-8569-4a83b197caad', i.auth0UserId = '6a071561d72ba3c98fd4ed82', i.name = 'Port SubaccountTest' MERGE (p:Profile {profileId: 9900028, profileType: 'InsightsProfile'}) SET p.profileId = 9900028, p.profileName = 'qa_insights_e2etest+subaccount_7645_2', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (s:SubAccount {id: 7645}) MERGE (p)-[:HAS_ACCESS_TO]->(s); // Test user: qa_insights_e2etest+label_21786@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+label_21786@sonymusic-pde.com'}) SET i.id = '9a62ee0d-2df5-4a7e-aa8f-0a756629e633', i.auth0UserId = '6a0716a57349d7fdf0d9465e', i.name = 'Port Tester' MERGE (p:Profile {profileId: 9900029, profileType: 'InsightsProfile'}) SET p.profileId = 9900029, p.profileName = 'qa_insights_e2etest+label_21786', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 21786}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Test user: qa_insights_e2etest+label_21786_2@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+label_21786_2@sonymusic-pde.com'}) SET i.id = '9063a2bf-4575-429a-ae95-4aeb7bdc1eed', i.auth0UserId = '6a0717ca4a8304a164126b0e', i.name = 'Port Tester' MERGE (p:Profile {profileId: 9900030, profileType: 'InsightsProfile'}) SET p.profileId = 9900030, p.profileName = 'qa_insights_e2etest+label_21786_2', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 21786}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Test user: qa_insights_e2etest+label_15063_port@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+label_15063_port@sonymusic-pde.com'}) SET i.id = '07e8c6f0-49d1-4349-980b-d07a67d4a65f', i.auth0UserId = '6a071861746b7e2feaeacf71', i.name = 'Port Tester' MERGE (p:Profile {profileId: 9900031, profileType: 'InsightsProfile'}) SET p.profileId = 9900031, p.profileName = 'qa_insights_e2etest+label_15063_port', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 15063}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Test user: qa_insights_e2etest+label_15063_port_2@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+label_15063_port_2@sonymusic-pde.com'}) SET i.id = '7c297eb7-c60a-4305-9fd7-22c5df9c7c29', i.auth0UserId = '6a07194ab1a2457f6c3ba27b', i.name = 'Port Tester' MERGE (p:Profile {profileId: 9900032, profileType: 'InsightsProfile'}) SET p.profileId = 9900032, p.profileName = 'qa_insights_e2etest+label_15063_port_2', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 15063}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Test user: qa_insights_e2etest+awal_android_employee@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+awal_android_employee@sonymusic-pde.com'}) SET i.id = 'a4cdb1f0-7b1c-4b1c-9b60-979372910980', i.auth0UserId = '6a1415d895c2a960faeffdd4', i.name = 'Igor Vladymyrov' MERGE (p:Profile {profileId: 9900033, profileType: 'InsightsProfile'}) SET p.profileId = 9900033, p.profileName = 'qa_insights_e2etest+awal_android_employee', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: '*'}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Test user: qa_collaborators_e2etest+label_25153@sonymusic-pde.com MERGE (i:Identity {email: 'qa_collaborators_e2etest+label_25153@sonymusic-pde.com'}) SET i.id = 'cacf9e95-e7e1-433d-bf49-0b01c74f7732', i.auth0UserId = '6a14551bd8a08ad75063e9ef', i.name = 'Payment TestUser' MERGE (p:Profile {profileId: 9900034, profileType: 'CollaboratorsProfile'}) SET p.profileId = 9900034, p.profileName = 'qa_collaborators_e2etest+label_25153', p.roles = ['royalties'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 25153}) MATCH (v1:Vendor {id: 35598}) MATCH (v2:Vendor {id: 6971}) MERGE (p)-[:HAS_ACCESS_TO]->(v0) MERGE (p)-[:HAS_ACCESS_TO]->(v1) MERGE (p)-[:HAS_ACCESS_TO]->(v2) MERGE (p)-[:HAS_ADMIN_ACCESS_TO]->(v2) MERGE (p)-[:HAS_ADMIN_ACCESS_TO]->(v0); // Test user: qa_collaborators_e2etest+label_25153_quote_payment@sonymusic-pde.com MERGE (i:Identity {email: 'qa_collaborators_e2etest+label_25153_quote_payment@sonymusic-pde.com'}) SET i.id = 'e244bcb6-3b91-464d-a7c7-2ec09014eb7c', i.auth0UserId = '6a1455c0ad56830dc62d5339', i.name = 'Quote Payment Test User' MERGE (p:Profile {profileId: 9900035, profileType: 'CollaboratorsProfile'}) SET p.profileId = 9900035, p.profileName = 'qa_collaborators_e2etest+label_25153_quote_payment', p.roles = ['royalties'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 25153}) MATCH (v1:Vendor {id: 35598}) MATCH (v2:Vendor {id: 6971}) MERGE (p)-[:HAS_ACCESS_TO]->(v0) MERGE (p)-[:HAS_ACCESS_TO]->(v1) MERGE (p)-[:HAS_ACCESS_TO]->(v2) MERGE (p)-[:HAS_ADMIN_ACCESS_TO]->(v2) MERGE (p)-[:HAS_ADMIN_ACCESS_TO]->(v0); // Test artist user: qa_insights_e2etest+artist_sued_nunes_81790@sonymusic-pde.com (artist: Sued Nunes) MERGE (i:Identity {email: 'qa_insights_e2etest+artist_sued_nunes_81790@sonymusic-pde.com'}) SET i.id = '5d38cf51-afef-48c5-b508-32f79e9c1084', i.auth0UserId = '6a15caedbf4f73b11fe2bdea', i.name = 'Artist User 81790' MERGE (p:Profile {profileId: 9900036, profileType: 'InsightsProfile'}) SET p.profileId = 9900036, p.profileName = 'qa_insights_e2etest+artist_sued_nunes_81790', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (lp:LabelParticipant {uuid: '37779419-d8c6-4706-a4c5-0ece67c04f5d'}) MERGE (p)-[:HAS_ACCESS_TO]->(lp); // Test artist user: qa_insights_e2etest+artist_sued_nunes_797716@sonymusic-pde.com (artist: Sued Nunes) MERGE (i:Identity {email: 'qa_insights_e2etest+artist_sued_nunes_797716@sonymusic-pde.com'}) SET i.id = '5309c40b-0499-4088-911f-2b54ba1cbad7', i.auth0UserId = '6a1680ff1d0d0c3743eedf13', i.name = 'Artist User 797716' MERGE (p:Profile {profileId: 9900037, profileType: 'InsightsProfile'}) SET p.profileId = 9900037, p.profileName = 'qa_insights_e2etest+artist_sued_nunes_797716', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (lp:LabelParticipant {uuid: '69f11d3e-216e-4dc6-b3ff-c84a21d76626'}) MERGE (p)-[:HAS_ACCESS_TO]->(lp); // Test user: qa_insights_e2etest+label_81790@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+label_81790@sonymusic-pde.com'}) SET i.id = 'ff11f165-fce2-479d-a1f7-08ea087b9f40', i.auth0UserId = '6a168e4e85401beb6782a92b', i.name = 'Label User 81790' MERGE (p:Profile {profileId: 9900038, profileType: 'InsightsProfile'}) SET p.profileId = 9900038, p.profileName = 'qa_insights_e2etest+label_81790', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 81790}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Test user: qa_insights_e2etest+label_81790_no_ff@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+label_81790_no_ff@sonymusic-pde.com'}) SET i.id = '32342b0b-90b1-46b7-aae5-c6aed0ee1c03', i.auth0UserId = '6a1696951eefdb40c2b8b580', i.name = 'Label User 81790 NO FF' MERGE (p:Profile {profileId: 9900039, profileType: 'InsightsProfile'}) SET p.profileId = 9900039, p.profileName = 'qa_insights_e2etest+label_81790_no_ff', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 81790}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Test artist user: qa_insights_e2etest+artist_sued_nunes_81790_no_ff@sonymusic-pde.com (artist: Sued Nunes) MERGE (i:Identity {email: 'qa_insights_e2etest+artist_sued_nunes_81790_no_ff@sonymusic-pde.com'}) SET i.id = '92209577-4318-415b-8446-05007bce2060', i.auth0UserId = '6a169789846410dedae5d852', i.name = 'Artist User 81790 NO FF' MERGE (p:Profile {profileId: 9900040, profileType: 'InsightsProfile'}) SET p.profileId = 9900040, p.profileName = 'qa_insights_e2etest+artist_sued_nunes_81790_no_ff', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (lp:LabelParticipant {uuid: '37779419-d8c6-4706-a4c5-0ece67c04f5d'}) MERGE (p)-[:HAS_ACCESS_TO]->(lp); // Test artist user: qa_insights_e2etest+artist_sued_nunes_797716_no_ff@sonymusic-pde.com (artist: Sued Nunes) MERGE (i:Identity {email: 'qa_insights_e2etest+artist_sued_nunes_797716_no_ff@sonymusic-pde.com'}) SET i.id = 'b9bf37d9-7080-44d5-8b50-56820c14a890', i.auth0UserId = '6a1698cc846410dedae5d8f4', i.name = 'Artist User 797716 NO FF' MERGE (p:Profile {profileId: 9900041, profileType: 'InsightsProfile'}) SET p.profileId = 9900041, p.profileName = 'qa_insights_e2etest+artist_sued_nunes_797716_no_ff', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (lp:LabelParticipant {uuid: '69f11d3e-216e-4dc6-b3ff-c84a21d76626'}) MERGE (p)-[:HAS_ACCESS_TO]->(lp); // Test user: qa_insights_e2etest+label_797716@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+label_797716@sonymusic-pde.com'}) SET i.id = '7f6b2577-4bcf-4e33-babb-8360b6c60239', i.auth0UserId = '6a16af68fca7bfa385a99bcd', i.name = 'Label User 797716' MERGE (p:Profile {profileId: 9900042, profileType: 'InsightsProfile'}) SET p.profileId = 9900042, p.profileName = 'qa_insights_e2etest+label_797716', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 797716}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Test user: qa_insights_e2etest+label_797716_no_ff@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+label_797716_no_ff@sonymusic-pde.com'}) SET i.id = 'd38698da-065e-4c74-95ae-f34aca66e189', i.auth0UserId = '6a16b0b356008937c1d0f745', i.name = 'Test 797716 NO FF' MERGE (p:Profile {profileId: 9900043, profileType: 'InsightsProfile'}) SET p.profileId = 9900043, p.profileName = 'qa_insights_e2etest+label_797716_no_ff', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 797716}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Test user: qa_insights_e2etest+insights_search@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+insights_search@sonymusic-pde.com'}) SET i.id = 'dcfdea87-6586-452c-8fbb-1a3e4e76696a', i.auth0UserId = '6a26cab74959fea60a40c0b7', i.name = 'Insights Search' MERGE (p:Profile {profileId: 9900044, profileType: 'InsightsProfile'}) SET p.profileId = 9900044, p.profileName = 'qa_insights_e2etest+insights_search', p.roles = ['analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: 6971}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Test user: qa_insights_e2etest+ios_orchard_employee@sonymusic-pde.com MERGE (i:Identity {email: 'qa_insights_e2etest+ios_orchard_employee@sonymusic-pde.com'}) SET i.id = 'e45d167f-3473-49bf-98b3-73b2a5548106', i.auth0UserId = '6a30e927a23f8bc9febf0363', i.name = 'Igor Vladymyrov' MERGE (p:Profile {profileId: 9900045, profileType: 'InsightsProfile'}) SET p.profileId = 9900045, p.profileName = 'qa_insights_e2etest+ios_orchard_employee', p.roles = ['administrator', 'analytics'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (v0:Vendor {id: '*'}) MERGE (p)-[:HAS_ACCESS_TO]->(v0); // Test user: qa_moneyhub_e2etest+label_84084@sonymusic-pde.com MERGE (i:Identity {email: 'qa_moneyhub_e2etest+label_84084@sonymusic-pde.com'}) SET i.id = 'bd38d4b5-7e0d-4339-9ab1-ee07e889fa89', i.auth0UserId = '6a4d2b0f047ebe71152ea994', i.name = 'Test Subaccount' MERGE (p:Profile {profileId: 9900046, profileType: 'MoneyhubProfile'}) SET p.profileId = 9900046, p.profileName = 'qa_moneyhub_e2etest+label_84084', p.roles = ['accounting'], p.uuid = randomUUID() MERGE (i)-[:HAS_PROFILE]->(p) WITH p MATCH (s:SubAccount {id: 84084}) MERGE (p)-[:HAS_ACCESS_TO]->(s);