from tests.root_fixture import root_fixture fixture = { **root_fixture, "User": [ *root_fixture["User"], { "id": 2, "email": "dev-marketing-user-2@example.com", "external_id": "sme-dna|3po0091d6c91ty670fe6ftryf", "name": "dev-marketing-user-2", "phone": "67589838844", }, { "id": 1, "email": "dev-marketing-user-1@example.com", "external_id": "sme-dna|5cf0091d6c91d310fe6fcdc6", "name": "dev-marketing-user-1", "phone": "18156567589", "manager_id": 2 }, { "id": 3, "email": "dev-marketing-user-3@example.com", "external_id": "sme-dna|9op0091d6cuhjp30fe6ffth34", "name": "dev-marketing-user-3", "phone": "09876445666", }, { "id": 4, "email": "dev-marketing-user-4@example.com", "external_id": "sme-dna|4rr0091d6cuhjp30fe6opth00", "name": "dev-marketing-user-4", "phone": "09976447888", }, { "id": 5, "email": "dev-marketing-user-5@example.com", "external_id": "sme-dna|1mk0091d6cuhjp30fe6optiii", "name": "dev-marketing-user-5", "phone": "09176447546", }, ], "UserProject": [ {"project_id": 501, "user_id": 1, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 502, "user_id": 1, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 502, "user_id": 4, "shared_by": 1, "editable": False, "role": 3}, {"project_id": 502, "user_id": 100, "shared_by": 1, "editable": True, "role": 1}, {"project_id": 503, "user_id": 1, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 504, "user_id": 1, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 506, "user_id": 1, "shared_by": 1, "editable": False, "role": 1}, ], "HistoryUser": [ { "id": "sme-dna|5cf0091d6c91d310fe6fcdc6", "email": "dev-marketing-user-1@example.com", "created_at": "2019-05-31 15:25:24.741493", }, { "id": "sme-dna|5cf00941324d9210f79221b8", "email": "dev-marketing-user-2@example.com", "created_at": "2019-06-04 09:36:51.626068", }, { "id": "sme-dna|5cf125b197dfce0fdfe66f7e", "email": "dev-marketing-user-3@example.com", "created_at": "2019-05-31 14:39:37.725492", }, { "id": "sme-dna|5cf12c2e29248910e0288cca", "email": "darya.biryukova@dataart.com", "created_at": "2019-05-31 14:40:57.680983", }, {"id": "system", "email": "system@example.com", "created_at": "9999-12-31 23:59:59.999999"}, ], "Project": [ { "id": 500, "name": "test_project_1", "label_id": 4, "end_date": "2020-10-11", "created_at": "2019-07-22 16:14:35.748032", "create_user_id": 1, "updated_at": "2019-07-22 16:14:55.446196", "edit_user_id": 1, "is_confidential": True, "budget": 2000, "allocation": 66666, "initial_start_date": "2007-02-02", "gras_title": "New Frontline Release", "gras_project_code": "12345510", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345510", "updated_by_import_at": "2020-10-11", }, { "id": 501, "name": "test_project_2", "label_id": 4, "is_claimed": True, "end_date": "2020-10-11", "created_at": "2019-07-22 16:14:35.748032", "create_user_id": 1, "updated_at": "2019-07-22 16:14:55.446196", "edit_user_id": 1, "is_deleted": True, "is_confidential": False, "budget": 34399, "allocation": 34399, "initial_start_date": "2007-02-02", "gras_title": "New Frontline Release", "gras_project_code": "12345511", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345511", "updated_by_import_at": "2020-10-11", }, { "id": 502, "name": "test_project_3", "label_id": 6, "is_claimed": True, "end_date": "2020-10-11", "created_at": "2019-07-22 16:14:35.748032", "create_user_id": 1, "updated_at": "2019-07-22 16:14:55.446196", "edit_user_id": 1, "notes": "Some notes", "is_confidential": False, "budget": 88899, "allocation": 88899, "initial_start_date": "2007-02-02", "gras_title": "New Frontline Release", "gras_project_code": "12345512", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345512", "updated_by_import_at": "2020-10-11", }, { "id": 503, "name": "test_project_3", "label_id": 6, "is_claimed": True, "end_date": "2020-10-13", "created_at": "2019-07-22 16:14:35.748032", "create_user_id": 1, "updated_at": "2019-07-22 16:14:55.446196", "edit_user_id": 1, "is_confidential": False, "budget": 88899, "allocation": 88899, "initial_start_date": "2007-02-02", "gras_title": "New Frontline Release", "gras_project_code": "12345513", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345513", "updated_by_import_at": "2020-10-11", }, { "id": 504, "name": "test_project_4", "label_id": 6, "is_claimed": True, "end_date": "2020-09-11", "created_at": "2020-07-24 16:14:35.748032", "create_user_id": 1, "updated_at": "2020-07-24 16:14:55.446196", "edit_user_id": 1, "is_confidential": False, "budget": 88899, "allocation": 88899, "initial_start_date": "2007-02-02", "gras_title": "New Frontline Release", "gras_project_code": "12345514", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345514", "updated_by_import_at": "2020-10-11", }, { "id": 505, "name": "test_project_ccp", "label_id": 4, "end_date": "2020-10-11", "created_at": "2019-07-22 16:14:35.748032", "create_user_id": 1, "updated_at": "2019-07-22 16:14:55.446196", "edit_user_id": 1, "is_confidential": True, "budget": 2000, "allocation": 66666, "initial_start_date": "2007-02-02", "gras_title": "New Frontline Release", "gras_project_code": "12345515", "prs_title": "", "ccp_project_code": "2456799876543", "updated_by_import_at": "2020-10-11", "source": "CCP", }, { "id": 506, "name": "test_project_with_one_user_in_project_team", "label_id": 4, "is_claimed": True, "end_date": "2020-10-11", "created_at": "2019-07-22 16:14:35.748032", "create_user_id": 1, "updated_at": "2019-07-22 16:14:55.446196", "edit_user_id": 1, "is_confidential": True, "budget": 2000, "allocation": 66666, "initial_start_date": "2007-02-02", "gras_title": "New Frontline Release", "gras_project_code": "12345515", "prs_title": "", "ccp_project_code": "91865312", "updated_by_import_at": "2020-10-11", "source": "CCP", }, ], "MediaPlan": [ {"id": 43, "name": "Untitled For Test", "project_id": 501, "order": 0}, {"id": 44, "name": "Untitled For Test", "project_id": 502, "order": 0}, {"id": 45, "name": "Untitled For Test", "project_id": 503, "order": 0}, {"id": 46, "name": "Untitled For Test", "project_id": 504, "order": 0}, ], "MediaPlanPhase": [ {"id": 101, "name": "Phase 1", "media_plan_id": 43, "order": 1}, {"id": 102, "name": "Phase 1", "media_plan_id": 44, "order": 1}, {"id": 103, "name": "Phase 1", "media_plan_id": 45, "order": 1}, {"id": 105, "name": "Phase 2", "media_plan_id": 45, "order": 2}, {"id": 104, "name": "Phase 1", "media_plan_id": 46, "order": 1}, ], "Label": [ { "id": 1, "name": "Columbia Records", "rep_owner_key": "123456", "external_name": "Columbia Records", "child_rep_owner_keys": "{}", }, { "id": 2, "name": "Epic Records", "rep_owner_key": "223456", "external_name": "Epic Records", "child_rep_owner_keys": "{}", }, { "id": 3, "name": "RCA Records", "rep_owner_key": "323456", "external_name": "RCA Records", "child_rep_owner_keys": "{}", }, {"id": 4, "name": "CMG", "rep_owner_key": "423456", "external_name": "CMG", "child_rep_owner_keys": "{}"}, { "id": 5, "name": "Nashville", "rep_owner_key": "523456", "external_name": "Nashville", "child_rep_owner_keys": "{}", }, {"id": 6, "name": "Nash", "rep_owner_key": "623456", "external_name": "Nash", "child_rep_owner_keys": "{}"}, ], "UserLabel": [ {"user_id": 1, "label_id": 1}, {"user_id": 1, "label_id": 2}, {"user_id": 1, "label_id": 3}, {"user_id": 1, "label_id": 4}, {"user_id": 1, "label_id": 6}, {"user_id": 5, "label_id": 4}, {"user_id": 2, "label_id": 6}, ], "Territory": [ {"id": 1, "name": "Ukraine", "code": "UA", "territory_type_id": 1}, {"id": 38, "name": "USA", "code": "US", "territory_type_id": 1}, ], "ProjectCampaign": [ {"project_id": 500, "campaign_id": 100, "status": 1}, {"project_id": 500, "campaign_id": 110, "status": 1}, # PRS Campaign {"project_id": 500, "campaign_id": 102, "status": 2}, {"project_id": 500, "campaign_id": 101, "status": 0}, {"project_id": 502, "campaign_id": 107, "status": 1}, {"project_id": 502, "campaign_id": 108, "status": 1}, {"project_id": 504, "campaign_id": 105, "status": 0}, {"project_id": 506, "campaign_id": 106, "status": 0}, ], "Campaign": [ { "id": 100, "uuid": "34ed4c22-e1f9-4184-a06d-f04cbdb97455", "name": "test_campaign_1", "external_id": "253678", "project_id": 500, "create_user_id": 1, "start_date": "2020-02-02", "end_date": "2020-10-10", "planned_budget": 15000, "budget_spend": 1000, "currency_id": 1, "created_at": "2019-07-22 16:14:55.355226", "updated_at": "2019-07-22 16:14:55.355226", "source": "facebook", "edit_user_id": 1, "is_deleted": False, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, "type_id": 8, "gratis": False, }, { "id": 101, "uuid": "aa1490b5-832c-4852-9d28-7a96884ff399", "name": "test_campaign_2", "external_id": "6378939", "project_id": 500, "create_user_id": 1, "start_date": "2020-04-02", "end_date": "2020-11-10", "planned_budget": 90000, "budget_spend": 1000, "currency_id": 1, "created_at": "2019-07-22 19:14:55.355226", "updated_at": "2019-07-22 20:14:55.355226", "source": "google", "edit_user_id": 1, "is_deleted": False, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 1, "type_id": 8, "gratis": False, }, { "id": 102, "uuid": "c40fe4e8-58ce-4ba6-ab10-4932e685a389", "name": "test_campaign_3", "external_id": "330303", "project_id": 500, "create_user_id": 1, "start_date": "2007-02-02", "end_date": "2008-10-10", "planned_budget": 10000, "budget_spend": 1000, "currency_id": 1, "created_at": "2019-07-22 19:14:55.355226", "updated_at": "2019-07-22 20:14:55.355226", "edit_user_id": 1, "provider_id": 1, "age_range": "(0, 60)", "source": "dec", "objective_id": 2, "type_id": 8, "gratis": False, }, { "id": 103, "uuid": "2dd6f9b4-42f5-48e8-a01f-c7bb9dc6434d", "name": "test_deleted_campaign_4", "project_id": 501, "create_user_id": 1, "start_date": "2007-02-02", "end_date": "2008-10-10", "planned_budget": 15000, "budget_spend": 1000, "currency_id": 1, "created_at": "2019-07-22 19:14:55.355226", "updated_at": "2019-07-22 20:14:55.355226", "edit_user_id": 1, "is_deleted": False, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, "type_id": 8, "gratis": False, }, { "id": 104, "uuid": "55e87545-a3b3-4bd1-9357-a5373df46270", "name": "test_deleted_campaign_4", "project_id": 502, "create_user_id": 1, "start_date": "2007-02-02", "end_date": "2008-10-10", "planned_budget": 10005, "budget_spend": 1000, "currency_id": 1, "created_at": "2019-07-22 19:14:55.355226", "updated_at": "2019-07-22 20:14:55.355226", "edit_user_id": 1, "is_deleted": False, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, "type_id": 8, "gratis": False, }, { "id": 105, "uuid": "20618d97-5190-4589-8fed-9e109e5ac5b5", "name": "test_campaign_6", "external_id": "123456797", "create_user_id": 1, "start_date": "2015-07-02", "end_date": "2015-10-10", "planned_budget": 7000, "budget_spend": 1000, "currency_id": 1, "source": "google", "created_at": "2019-07-22 19:14:55.355226", "updated_at": "2019-07-22 20:14:55.355226", "edit_user_id": 1, "is_deleted": False, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, "type_id": 8, "gratis": False, }, { "id": 106, "uuid": "20618d97-5190-4589-8fed-9e109e5ac5cc", "name": "test_campaign_7", "external_id": "0123456797", "create_user_id": 1, "start_date": "2015-07-02", "end_date": "2015-10-10", "planned_budget": 7000, "budget_spend": 1000, "currency_id": 1, "source": "google", "created_at": "2019-07-22 19:14:55.355226", "updated_at": "2019-07-22 20:14:55.355226", "edit_user_id": 1, "is_deleted": False, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, "type_id": 8, "gratis": False, "project_id": 506 }, { "id": 107, "uuid": "0b70c231-1997-417b-a23f-9a89ffa4f6bf", "name": "test_campaign_8", "external_id": "123456789", "project_id": 502, "create_user_id": 1, "start_date": "2020-02-02", "end_date": "2020-10-10", "planned_budget": 6000, "budget_spend": 1000, "currency_id": 1, "source": "facebook", "created_at": "2019-07-22 19:14:55.355226", "updated_at": "2019-07-22 20:14:55.355226", "edit_user_id": 1, "external_marketing_account_id": "8653387137", "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, "metainfo": { "fields": { "budget": True, "spend": True, "startDate": True, "endDate": True, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, "type_id": 8, "gratis": False, }, { "id": 108, "uuid": "9d6211cf-1e47-487d-bb01-e08f6472d71e", "name": "test_campaign_9", "external_id": "654783978", "project_id": 502, "create_user_id": 1, "start_date": "2019-09-12", "end_date": "2019-10-10", "planned_budget": 5000, "budget_spend": 1000, "currency_id": 1, "source": "facebook", "created_at": "2019-07-22 19:14:55.355226", "updated_at": "2019-07-22 20:14:55.355226", "edit_user_id": 1, "external_marketing_account_id": "3029121817", "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, "type_id": 8, "gratis": False, }, { "id": 110, "uuid": "df9a3dc8-c3d3-440c-bc3c-cee1c3c2dd67", "name": "test_campaign_1", "project_id": 500, "create_user_id": 1, "start_date": "2020-02-02", "end_date": "2020-10-10", "planned_budget": 15000, "budget_spend": 1000, "currency_id": 1, "created_at": "2019-07-22 16:14:55.355226", "updated_at": "2019-07-22 16:14:55.355226", "source": "PRS", "edit_user_id": 1, "is_deleted": False, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, "type_id": 8, "gratis": False, }, { "id": 111, "uuid": "85f802d2-1296-49e8-a12f-7d11d46acdca", "name": "test_campaign_1", "external_id": "253780", "project_id": 505, "create_user_id": 1, "start_date": "2020-02-02", "end_date": "2020-10-10", "planned_budget": 15000, "budget_spend": 1000, "currency_id": 1, "created_at": "2019-07-22 16:14:55.355226", "updated_at": "2019-07-22 16:14:55.355226", "source": "facebook", "edit_user_id": 1, "is_deleted": False, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, "type_id": 8, "gratis": False, }, ], "CampaignPlatformsLinks": [ {"campaign_id": 100, "platform_id": 1}, {"campaign_id": 101, "platform_id": 1}, {"campaign_id": 102, "platform_id": 1}, {"campaign_id": 103, "platform_id": 1}, {"campaign_id": 104, "platform_id": 1}, {"campaign_id": 105, "platform_id": 1}, {"campaign_id": 107, "platform_id": 1}, {"campaign_id": 108, "platform_id": 1}, {"campaign_id": 110, "platform_id": 1}, ], "MarketingAccount": [ {"id": 1, "label_id": 1, "type": 0, "external_id": "8653387137", "provider_id": 1}, {"id": 4, "label_id": 6, "type": 0, "external_id": "3029121817", "provider_id": 1}, {"id": 5, "label_id": 2, "type": 0, "external_id": "5457858855", "provider_id": 2}, ], "ProjectTargetItem": [ {"project_id": 500, "entity_id": 10, "entity_type": 0, "add_type": 2}, {"project_id": 500, "entity_id": 20, "entity_type": 0}, {"project_id": 501, "entity_id": 70, "entity_type": 3}, {"project_id": 502, "entity_id": 10, "entity_type": 0, "add_type": 2}, {"project_id": 502, "entity_id": 20, "entity_type": 0}, {"project_id": 503, "entity_id": 10, "entity_type": 0}, {"project_id": 504, "entity_id": 10, "entity_type": 0}, ], "Artist": [ {"id": 10, "external_id": "GRAS_562122", "name": "TestAtrist", "is_sony": True}, {"id": 20, "external_id": "GRAS_562126", "name": "Adele", "is_sony": True}, ], "Polymorphable": [{"id": 10, "type": "Artist"}, {"id": 20, "type": "Artist"}, {"id": 70, "type": "Playlist"}], "Playlist": [{"id": 70, "external_id": "01", "name": "TestAtrist", "owner_name": "Owner1", "provider": "spotify"}], "Image": [ {"id": 13, "url": "http://test.com", "width": 200, "height": 250, "related_object_id": 10}, {"id": 14, "url": "http://test.com/1", "width": 200, "height": 250, "related_object_id": 20}, {"id": 15, "url": "http://test.com/2", "width": 300, "height": 250, "related_object_id": 70}, {"id": 16, "url": "http://test.com/3", "width": 400, "height": 250, "related_object_id": 70}, ], "ProjectHistoryItem": [ {"project_id": 500, "created_at": "2019-01-01 00:00:00", "user_id": 1, "action_id": 1}, {"project_id": 501, "created_at": "2019-01-01 00:00:01", "user_id": 1, "action_id": 1}, {"project_id": 502, "created_at": "2019-01-01 00:00:02", "user_id": 1, "action_id": 1}, ], "ProjectGenre": [ {"project_id": 502, "genre_id": 15}, {"project_id": 502, "genre_id": 16}, {"project_id": 500, "genre_id": 17}, ], "CampaignGender": [ {"campaign_id": 100, "gender_id": 1}, {"campaign_id": 101, "gender_id": 1}, {"campaign_id": 102, "gender_id": 1}, {"campaign_id": 103, "gender_id": 1}, {"campaign_id": 104, "gender_id": 1}, ], "ProductTrack": [ { "id": 1, "product_id": 1, "isrc": "FR7U62000001", "title": "Test Track 1", "title_supplementary": "Album Version", "type": "Simple Track", "release_date": "2002-01-01 00:00:00", } ], "ProductFamily": [ {"id": 1, "external_id": "1", "title": "Test Family 1", "type": "Digital Singles ( One Track Link )"} ], "ProjectProductFamily": [{"id": 1, "project_id": 500, "product_family_id": 1}], "RawPRSProjects": [ { "sub_project_cd": "012345512", "sub_project_description": "SONY MUSIC DISTRIBUTION", "recording_project_no": 12345510, "recording_project_artist_tx": "Test Artist", "recording_project_title_tx": "New Frontline Release(PRS) 1", "recording_project_artist_num": 562122, "rep_owner_key": "E008", "admin_group_cd": "25", "admin_group_name_tx": "Sony Music Distribution", }, { "sub_project_cd": "088397", "sub_project_description": "EPIC MARKETING DEPTS", "recording_project_no": 1008453, "recording_project_artist_tx": "VARIOUS", "recording_project_title_tx": "DUMMY", "rep_owner_key": "E008", "recording_project_artist_num": 99999, "admin_group_cd": "68", "admin_group_name_tx": "Epic Records Group", }, ], "RawPRSPurchaseOrders": [ { "po_num": 532914033, "item_no": 1, "mps_form_id": 100, "mps_budget_phase_id": 0, "budget_group": 2, "budget_category": 216, "po_created_on": "2020-09-18", "po_modified_on": "2020-10-05", "po_status": "Payable", "po_total": 1100, "sub_project_cd": "012345512", "vendor_name": "US SECURITY ASSOCIATES INC", "is_req_under_blanket": "Y", "blanket": "N", "blanket_po_id": 532914000, "item_desc": "Artist events at Sony Square prior to the pandemic.", "is_unknown_vendor": "N", "is_under_uncommited_blanket": "N", }, { "po_num": 1086239001, "item_no": 1, "mps_form_id": 101, "mps_budget_phase_id": 1, "budget_group": 2, "budget_category": 216, "po_created_on": "2019-02-05", "po_modified_on": "2019-03-21", "po_status": "Paid", "po_total": 6500, "po_total_paid": 6500, "sub_project_cd": "088397", "vendor_name": "PHANTOM STUDIOS LIMITED", "is_req_under_blanket": "N", "blanket": "N", "item_desc": "Our portion of the cost for the building of the Tune", "is_unknown_vendor": "N", "is_under_uncommited_blanket": "N", }, ], "RawPRSBudgets": [ { "sub_project_cd": "012345512", "form_id": 100, "phase_id": 0, "phase_short_desc_tx": "Migration", "inactive_in": "Y", "group_id": 2, "category_id": 216, "proposed_am": 9999999.99, "created_user": "Mikhail Lurye", "created_at": "05/21/2007", "updated_user": " ", "updated_at": "06/24/2009", }, { "sub_project_cd": "088397", "form_id": 2, "phase_id": 0, "phase_short_desc_tx": "Migration", "inactive_in": "Y", "group_id": 2, "category_id": 7, "proposed_am": 9106.24, "created_user": "Mikhail Lurye", "created_at": "05/21/2007", "updated_user": "JAMEL STOUT", "updated_at": "04/17/2012", }, ], "Connector": [ { "id": 10, "name": "google_ads_1", "external_id": "new_mount", "label_id": 1, "status": 2, "owner_id": 1, "platform": "google_ads", "created_at": "2022-04-01 00:00:00", "last_synced_at": "2022-04-01 00:00:00" }, ], "AdAccount": [ { "connector_id": 10, "ad_account_id": 454567 } ], }