from tests.root_fixture import root_fixture fixture = { **root_fixture, "User": [ { "id": 1, "email": "dev-marketing-user-1@example.com", "external_id": "sme-dna|5cf0091d6c91d310fe6fcdc6", "name": "dev-marketing-user-1", "phone": "18156567589", } ], "HistoryUser": [ {"id": "sme-dna|5cf0091d6c91d310fe6fcdc6", "email": "user-1@example.com", "created_at": "2019-05-31 15:25:24"} ], "Project": [ { "id": 500, "name": "test_project_1", "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, "is_confidential": False, "budget": 500, "allocation": 500, "initial_start_date": "2021-12-04", "gras_title": "Chris Brown feat. 400 id", "gras_project_code": "GRAS_000", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345512", "updated_by_import_at": "2020-10-11", }, { "id": 501, "name": "test_project_2", "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, "is_deleted": True, "is_confidential": False, "budget": 500, "allocation": 500, "initial_start_date": "2020-03-04", "gras_title": "DJ KHALEED feat. 200 id", "gras_project_code": "GRAS_200", "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": 500, "allocation": 500, "initial_start_date": "2020-02-03", "gras_title": "DJ GRAS feat. 100 id", "gras_project_code": "GRAS_100", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345509", "updated_by_import_at": "2020-10-11", }, { "id": 503, "name": "test_project_4", "label_id": 47, "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": True, "budget": 500, "allocation": 500, "initial_start_date": "2020-02-03", "gras_title": "DJ GRAS feat. 100 id", "gras_project_code": "GRAS_100", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "0123455029", "updated_by_import_at": "2020-10-11", }, ], "MediaPlan": [ {"id": 42, "name": "Untitled For Test", "project_id": 500, "order": 0}, {"id": 43, "name": "Untitled For Test", "project_id": 501, "order": 0}, {"id": 44, "name": "Untitled For Test", "project_id": 502, "order": 0}, ], "MediaPlanPhase": [ {"id": 450, "name": "Phase For Test", "media_plan_id": 42, "order": 1}, {"id": 550, "name": "Phase For Test [Empty]", "media_plan_id": 43, "order": 1}, {"id": 555, "name": "Phase For Test [All Deleted]", "media_plan_id": 44, "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": "US Label", "rep_owner_key": "523458", "external_name": "Nash US Label", "child_rep_owner_keys": "{}", }, { "id": 47, "name": "UK Label", "rep_owner_key": "523457", "external_name": "Nash UK Label", "child_rep_owner_keys": "{}", }, { "id": 800, "name": "UK test Label", "rep_owner_key": "523434", "external_name": "UK test Label", "child_rep_owner_keys": "{}", }, { "id": 900, "name": "US test Label", "rep_owner_key": "523459", "external_name": "US test Label", "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": 5}, ], "TerritoryType": [{"id": 1, "name": "Global type"}], "Territory": [{"id": 1, "name": "Ukraine", "code": "UA", "territory_type_id": 1}], "ProjectTargetItem": [ {"project_id": 500, "entity_id": 50, "entity_type": 0, "add_type": 0}, {"project_id": 501, "entity_id": 10, "entity_type": 0, "add_type": 1}, {"project_id": 502, "entity_id": 140, "entity_type": 1, "add_type": 1}, {"project_id": 502, "entity_id": 20, "entity_type": 0, "add_type": 0}, {"project_id": 503, "entity_id": 150, "entity_type": 0, "add_type": 0}, {"project_id": 502, "entity_id": 30, "entity_type": 1, "add_type": 0}, {"project_id": 502, "entity_id": 40, "entity_type": 0, "add_type": 0, "is_deleted": True}, {"project_id": 502, "entity_id": 130, "entity_type": 1, "add_type": 0, "is_deleted": True}, {"project_id": 502, "entity_id": 60, "entity_type": 1, "add_type": 1, "is_deleted": True}, ], "Artist": [ {"id": 10, "external_id": "GRAS_10", "name": "TestAtrist", "is_sony": True}, {"id": 20, "external_id": "GRAS_20", "name": "Ched", "is_sony": True}, {"id": 30, "external_id": "GRAS_30", "name": "Terry", "is_sony": True}, {"id": 40, "external_id": "GRAS_40", "name": "Norman", "is_sony": True}, {"id": 50, "external_id": "GRAS_50", "name": "UpdateArtist", "is_sony": True}, {"id": 60, "external_id": "GRAS_60", "name": "artist2e", "is_sony": True}, {"id": 130, "external_id": "GRAS_130", "name": "Petruccho", "is_sony": True}, {"id": 140, "external_id": "GRAS_140", "name": "Fibonacci", "is_sony": True}, {"id": 150, "external_id": "GRAS_150", "name": "Fibonacci2", "is_sony": True}, ], "Polymorphable": [ {"id": 10, "type": "Artist"}, {"id": 20, "type": "Artist"}, {"id": 30, "type": "Artist"}, {"id": 40, "type": "Artist"}, {"id": 50, "type": "Artist"}, {"id": 60, "type": "Artist"}, {"id": 70, "type": "Playlist"}, {"id": 80, "type": "Playlist"}, {"id": 90, "type": "Playlist"}, {"id": 100, "type": "Playlist"}, {"id": 110, "type": "Playlist"}, {"id": 120, "type": "Playlist"}, {"id": 130, "type": "Artist"}, {"id": 140, "type": "Artist"}, {"id": 150, "type": "Artist"}, ], "Playlist": [ {"id": 70, "external_id": "01", "name": "TestAtrist", "owner_name": "Owner1", "provider": "spotify"}, {"id": 80, "external_id": "02", "name": "TestingUpdate", "owner_name": "Owner1", "provider": "spotify"}, {"id": 90, "external_id": "03", "name": "artist2", "owner_name": "Owner1", "provider": "spotify"}, {"id": 100, "external_id": "04", "name": "artist01", "owner_name": "Owner3", "provider": "apple"}, {"id": 110, "external_id": "05", "name": "UpdateArtist", "owner_name": "Owner2", "provider": "apple"}, {"id": 120, "external_id": "06", "name": "artist2e", "owner_name": "Owner1", "provider": "spotify"}, ], "Image": [ {"id": 13, "url": "http://test.com", "width": 200, "height": 250, "related_object_id": 70}, {"id": 14, "url": "http://test.com/1", "width": 200, "height": 250, "related_object_id": 70}, {"id": 15, "url": "http://test.com/2", "width": 300, "height": 250, "related_object_id": 20}, {"id": 16, "url": "http://test.com/3", "width": 400, "height": 250, "related_object_id": 50}, {"id": 17, "url": "http://test.com/4", "width": 400, "height": 250, "related_object_id": 130}, {"id": 18, "url": "http://test.com/5", "width": 400, "height": 250, "related_object_id": 130}, ], "Currency": [{"id": 1, "name": "United States Dollar", "code": "USD"}, {"id": 2, "name": "Hryvnya", "code": "UAH"}], "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}, ], "UserProject": [ {"project_id": 500, "user_id": 1, "shared_by": 1, "editable": False, "role": 1}, {"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}, ], "Campaign": [ { "id": 100, "uuid": "34ed4c22-e1f9-4184-a06d-f04cbdb97455", "name": "test_campaign_1", "project_id": 500, "create_user_id": 1, "workflow_status": "Booked", "external_marketing_account_id": 2333825793, "start_date": "2007-10-11", "external_name": "external name", "end_date": "2007-11-10", "planned_budget": 222, "budget_spend": 12, "currency_id": 1, "created_at": "2019-07-22 16:14:55.355226", "updated_at": "2019-07-22 16:14:55.355226", "edit_user_id": 1, "provider_id": 1, "age_range": "[0, 60]", "objective_id": 1, "notes": "Lorem Ipsum", "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": 200, "uuid": "aa1490b5-832c-4852-9d28-7a96884ff399", "external_marketing_account_id": 2333825794, "name": "test_campaign_2", "project_id": 500, "create_user_id": 1, "start_date": "2008-02-02", "end_date": "2008-10-10", "workflow_status": "Booked", "planned_budget": 190000, "budget_spend": 90000, "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": "[18, 35]", "objective_id": 2, "metainfo": { "fields": { "budget": False, "spend": True, "startDate": True, "endDate": False, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, "type_id": 8, "gratis": False, }, { "id": 300, "uuid": "c40fe4e8-58ce-4ba6-ab10-4932e685a389", "name": "test_deleted_campaign_3", "external_marketing_account_id": 2333825795, "project_id": 500, "create_user_id": 1, "workflow_status": "Booked", "start_date": "2007-02-02", "end_date": "2008-10-10", "planned_budget": 1000, "budget_spend": 10000, "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": True, "provider_id": 1, "age_range": "[0, 60]", "objective_id": 1, "type_id": 8, "gratis": False, }, { "id": 400, "uuid": "2dd6f9b4-42f5-48e8-a01f-c7bb9dc6434d", "name": "test_deleted_campaign_4", "external_marketing_account_id": 2333825796, "project_id": 500, "create_user_id": 1, "workflow_status": "Booked", "start_date": "2015-02-02", "end_date": "2016-10-10", "planned_budget": 12000, "budget_spend": 15000, "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": True, "provider_id": 1, "age_range": "[0, 60]", "objective_id": 1, "type_id": 8, "gratis": False, }, { "id": 401, "uuid": "55e87545-a3b3-4bd1-9357-a5373df46270", "external_marketing_account_id": 2333825797, "name": "test_401", "project_id": 500, "create_user_id": 1, "workflow_status": "Booked", "start_date": "2007-01-01", "end_date": "2015-02-02", "planned_budget": 12000, "budget_spend": 15000, "currency_id": 1, "source": "tiktok", "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]", "objective_id": 1, "type_id": 8, "gratis": False, }, { "id": 500, "uuid": "20618d97-5190-4589-8fed-9e109e5ac5b5", "name": "test_campaign_5", "external_marketing_account_id": 2333825798, "project_id": 503, "create_user_id": 1, "workflow_status": "Booked", "start_date": "2015-02-02", "end_date": "2015-03-10", "planned_budget": 15000, "budget_spend": 15000, "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]", "objective_id": 1, "type_id": 8, "gratis": False, }, { "id": 600, "uuid": "20618d97-5190-4589-8fed-9e109e5ac5bb", "name": "test_campaign_6", "external_marketing_account_id": 2333825799, "create_user_id": 1, "workflow_status": "Booked", "start_date": "2015-02-02", "end_date": "2015-03-10", "planned_budget": 15000, "budget_spend": 15000, "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]", "objective_id": 1, "type_id": 8, "gratis": False, }, { "id": 700, "uuid": "20618d97-5190-4589-8fed-9e109e5ac5cc", "name": "test_campaign_7", "external_marketing_account_id": 2333825700, "create_user_id": 1, "workflow_status": "Booked", "start_date": "2015-02-02", "end_date": "2015-03-10", "planned_budget": 15000, "budget_spend": 15000, "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]", "objective_id": 1, "type_id": 8, "gratis": False, }, ], "ProjectCampaign": [ {"project_id": 500, "campaign_id": 100, "status": 1}, {"project_id": 500, "campaign_id": 200, "status": 1}, {"project_id": 500, "campaign_id": 300, "status": 1}, {"project_id": 500, "campaign_id": 400, "status": 1}, {"project_id": 500, "campaign_id": 401, "status": 1}, {"project_id": 503, "campaign_id": 500, "status": 1}, ], "MarketingAccount": [ {"label_id": 6, "source": "facebook", "external_id": "2333825793", "currency": "USD"}, {"label_id": 6, "source": "facebook", "external_id": "2333825794", "currency": "USD"}, {"label_id": 6, "source": "facebook", "external_id": "2333825795", "currency": "USD"}, {"label_id": 6, "source": "facebook", "external_id": "2333825796", "currency": "USD"}, {"label_id": 6, "source": "facebook", "external_id": "2333825797", "currency": "USD"}, {"label_id": 47, "source": "facebook", "external_id": "2333825798", "currency": "USD"}, {"label_id": 6, "source": "facebook", "external_id": "2333825799", "currency": "USD"}, {"label_id": 6, "source": "facebook", "external_id": "2333825700", "currency": "USD"}, ], "PRSPurchaseOrder": [ { "id": 3654, "name": "MC UK Interview | PO 1125247000", "po_number": 1125247000, "total_amount": 5850.00, "paid_amount": 5750.00, "group_id": 2, "category_id": 6, "created_date": "2019-12-06", "last_modified_date": "2020-06-30", "is_blanked": True, "is_deleted": False, "description": "MC interview shoot on 12/2 in LA", "status": 10, "provider_id": 1, "is_under_uncommited_blanket": False, "project_id": 500, }, { "id": 3655, "name": "WILLIAM D BOATMAN | PO 1125247001", "po_number": 1125247001, "total_amount": 2000.00, "paid_amount": 2000.00, "group_id": 2, "category_id": 6, "created_date": "2019-12-09", "last_modified_date": "2019-12-13", "is_blanked": False, "is_deleted": False, "description": "MC interview shoot on 12/2 in LA", "status": 10, "parent_po_number": 1125247000, "provider_id": 2, "is_under_uncommited_blanket": True, "project_id": 500, }, { "id": 3656, "name": "MARVIN DOYLE BORDEN | PO 1125247002", "po_number": 1125247002, "total_amount": 3000.00, "paid_amount": 3000.00, "group_id": 2, "category_id": 6, "created_date": "2019-12-09", "last_modified_date": "2019-12-13", "is_blanked": False, "is_deleted": False, "description": "MC interview shoot on 12/2 in LA", "status": 10, "parent_po_number": 1125247000, "provider_id": 3, "is_under_uncommited_blanket": True, "project_id": 500, }, { "id": 3657, "name": "PRS CONCUR T&E | PO 1125247003", "po_number": 1125247003, "total_amount": 850.00, "paid_amount": 850.00, "group_id": 2, "category_id": 6, "created_date": "2019-12-16", "last_modified_date": "2020-03-20", "is_blanked": False, "is_deleted": False, "description": "MC interview shoot on 12/2 in LA", "status": 8, "parent_po_number": 1125247000, "provider_id": 4, "is_under_uncommited_blanket": True, "project_id": 500, }, { "id": 1794, "name": "SHOT BY SHOMI CORPORATION | PO 1108477001", "po_number": 1108477001, "total_amount": 4150.00, "paid_amount": 4150.00, "group_id": 1, "category_id": 2, "created_date": "2019-08-12", "last_modified_date": "2019-09-24", "is_blanked": False, "is_deleted": False, "description": "Mariah xmas shoot", "status": 0, "provider_id": 3, "is_under_uncommited_blanket": False, "project_id": 503, }, { "id": 1799, "name": "MIRAGE ENTERTAINMENT INC | PO 1108596001", "po_number": 1108596001, "total_amount": 20000.00, "paid_amount": 20000.00, "group_id": 5, "category_id": 6, "created_date": "2019-08-13", "last_modified_date": "2020-01-22", "is_blanked": False, "is_deleted": False, "description": "Mariah Carey Christmas Tour photo shoot", "status": 10, "provider_id": 2, "is_under_uncommited_blanket": False, "project_id": 503, }, { "id": 1875, "name": "WORDSMART TRANSCRIPTION AND | PO 1109217001", "po_number": 1109217001, "total_amount": 128.00, "paid_amount": 128.00, "group_id": 5, "category_id": 6, "created_date": "2019-08-15", "last_modified_date": "2019-10-21", "is_blanked": False, "is_deleted": False, "description": "LP transcription to create label copy", "status": 10, "provider_id": 4, "is_under_uncommited_blanket": False, "project_id": 503, }, { "id": 1876, "name": "WORDSMART TRANSCRIPTION AND | PO 1109217001", "po_number": 1109457001, "total_amount": 130.00, "paid_amount": 130.00, "group_id": 5, "category_id": 6, "created_date": "2019-08-15", "last_modified_date": "2019-10-21", "is_blanked": True, "is_deleted": False, "description": "LP transcription to create label copy", "status": 10, "provider_id": 4, "is_under_uncommited_blanket": False, "project_id": 500, } ], }