fixture = { "User": [ { "id": 1, "email": "dev-marketing-user-1@example.com", "external_id": "sme-dna|5cf0091d6c91d310fe6fcdc6", "name": "user-1", "phone": "", }, { "id": 2, "email": "dev-marketing-user-2@example.com", "external_id": "sme-dna|5cf0091d6c91d310fe6fcdc7", "name": "user-2", "phone": "", }, ], "CampaignStatus": [ { "id": 1, "name": "Booked" }, { "id": 2, "name": "Live" }, { "id": 3, "name": "Completed" }, { "id": 4, "name": "Draft" }, { "id": 5, "name": "Pending Approval" }, { "id": 6, "name": "Approved" }, { "id": 7, "name": "Disapproved" }, { "id": 8, "name": "Paused" } ], "Project": [ { "id": 1, "name": "test_project_1", "label_id": 1, "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": False, "is_claimed": True, "end_date": "2020-10-11", "is_confidential": False, "budget": 10000, "allocation": 1000000, "initial_start_date": "2022-10-11", "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": 2, "name": "test_project_1", "label_id": 2, "created_at": "2019-07-22 16:14:35.748032", "create_user_id": 2, "updated_at": "2019-07-22 16:14:55.446196", "edit_user_id": 2, "is_deleted": False, "is_claimed": True, "end_date": "2020-10-11", "is_confidential": False, "budget": 200, "allocation": 20000, "initial_start_date": "2022-10-11", "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": 3, "name": "test_project_1", "label_id": 2, "created_at": "2019-07-22 16:14:35.748032", "create_user_id": 2, "updated_at": "2019-07-22 16:14:55.446196", "edit_user_id": 2, "is_deleted": False, "is_claimed": True, "end_date": "2020-10-11", "is_confidential": False, "budget": 200, "allocation": 20000, "initial_start_date": "2022-10-11", "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": 4, "name": "test_project_4", "label_id": 1, "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_claimed": True, "end_date": "2020-10-11", "is_confidential": False, "budget": 0, "allocation": 0, "initial_start_date": "2022-10-11", "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", }, ], "Campaign": [ { "id": 1, "uuid": "34ed4c22-e1f9-4184-a06d-f04cbdb97455", "name": "test_campaign_1", "project_id": 1, "create_user_id": 1, "workflow_status": "Booked", "start_date": "2007-10-11", "end_date": "2007-11-10", "planned_budget": 222, "budget_spend": 12, "created_at": "2021-07-22 16:14:55.355226", "updated_at": "2021-07-22 16:14:55.355226", "provider_id": 1, "age_range": "[0, 60]", "notes": "Lorem Ipsum", "metainfo": { "fields": { "budget": True, "spend": True, "startDate": True, "endDate": True, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, }, { "id": 2, "uuid": "aa1490b5-832c-4852-9d28-7a96884ff399", "name": "test_campaign_1", "create_user_id": 1, "workflow_status": "Booked", "start_date": "2007-10-11", "end_date": "2007-11-10", "planned_budget": 222, "budget_spend": 12, "created_at": "2021-07-22 16:14:55.355226", "updated_at": "2021-07-22 16:14:55.355226", "provider_id": 2, "age_range": "[0, 60]", "notes": "Lorem Ipsum", "metainfo": { "fields": { "budget": True, "spend": True, "startDate": True, "endDate": True, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, }, { "id": 3, "uuid": "c40fe4e8-58ce-4ba6-ab10-4932e685a389", "name": "test_campaign_1", "create_user_id": 2, "project_id": 2, "workflow_status": "Booked", "start_date": "2007-10-11", "end_date": "2007-11-10", "planned_budget": 222, "budget_spend": 12, "created_at": "2021-07-22 16:14:55.355226", "updated_at": "2021-07-22 16:14:55.355226", "provider_id": 3, "age_range": "[0, 60]", "notes": "Lorem Ipsum", "metainfo": { "fields": { "budget": True, "spend": True, "startDate": True, "endDate": True, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, }, { "id": 4, "uuid": "2dd6f9b4-42f5-48e8-a01f-c7bb9dc6434d", "name": "test_campaign_1", "create_user_id": 2, "workflow_status": "Booked", "start_date": "2007-10-11", "end_date": "2007-11-10", "planned_budget": 222, "budget_spend": 12, "created_at": "2021-07-22 16:14:55.355226", "updated_at": "2021-07-22 16:14:55.355226", "provider_id": 2, "age_range": "[0, 60]", "notes": "Lorem Ipsum", "metainfo": { "fields": { "budget": True, "spend": True, "startDate": True, "endDate": True, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, }, { "id": 5, "uuid": "20618d97-5190-4589-8fed-9e109e5ac5b5", "name": "test_campaign_1", "create_user_id": 2, "project_id": 3, "workflow_status": "Booked", "start_date": "2007-10-11", "end_date": "2007-11-10", "planned_budget": 222, "budget_spend": 12, "created_at": "2021-07-22 16:14:55.355226", "updated_at": "2021-07-22 16:14:55.355226", "provider_id": 4, "age_range": "[0, 60]", "notes": "Lorem Ipsum", "metainfo": { "fields": { "budget": True, "spend": True, "startDate": True, "endDate": True, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, }, { "id": 6, "uuid": "0b70c231-1997-417b-a23f-9a89ffa4f6bf", "name": "test_campaign_1", "create_user_id": 2, "start_date": "2007-10-11", "end_date": "2007-11-10", "planned_budget": 222, "budget_spend": 12, "workflow_status": "Booked", "created_at": "2021-07-22 16:14:55.355226", "updated_at": "2021-07-22 16:14:55.355226", "provider_id": 1, "age_range": "[0, 60]", "notes": "Lorem Ipsum", "metainfo": { "fields": { "budget": True, "spend": True, "startDate": True, "endDate": True, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, }, { "id": 7, "uuid": "9d6211cf-1e47-487d-bb01-e08f6472d71e", "name": "test_campaign_1", "create_user_id": 2, "start_date": "2007-10-11", "end_date": "2007-11-10", "planned_budget": 222, "budget_spend": 12, "workflow_status": "Booked", "created_at": "2021-07-22 16:14:55.355226", "updated_at": "2021-07-22 16:14:55.355226", "provider_id": 4, "age_range": "[0, 60]", "notes": "Lorem Ipsum", "metainfo": { "fields": { "budget": True, "spend": True, "startDate": True, "endDate": True, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, }, { "id": 8, "uuid": "df9a3dc8-c3d3-440c-bc3c-cee1c3c2dd67", "name": "test_campaign_1", "start_date": "2007-10-11", "end_date": "2007-11-10", "planned_budget": 222, "budget_spend": 12, "workflow_status": "Booked", "created_at": "2021-07-22 16:14:55.355226", "updated_at": "2021-07-22 16:14:55.355226", "provider_id": 5, "external_marketing_account_id": "8653387137", "age_range": "[0, 60]", "notes": "Lorem Ipsum", "metainfo": { "fields": { "budget": True, "spend": True, "startDate": True, "endDate": True, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, }, { "id": 9, "uuid": "85f802d2-1296-49e8-a12f-7d11d46acdca", "name": "test_campaign_1", "start_date": "2007-10-11", "end_date": "2007-11-10", "planned_budget": 222, "budget_spend": 12, "workflow_status": "Booked", "created_at": "2021-07-22 16:14:55.355226", "updated_at": "2021-07-22 16:14:55.355226", "provider_id": 6, "external_marketing_account_id": "2333825793", "age_range": "[0, 60]", "notes": "Lorem Ipsum", "metainfo": { "fields": { "budget": True, "spend": True, "startDate": True, "endDate": True, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, }, { "id": 10, "uuid": "e91d5585-f454-4bdd-9420-c995a7fbcee3", "name": "test_campaign_1", "start_date": "2007-10-11", "end_date": "2007-11-10", "planned_budget": 222, "budget_spend": 12, "workflow_status": "Booked", "created_at": "2021-07-22 16:14:55.355226", "updated_at": "2021-07-22 16:14:55.355226", "provider_id": 7, "age_range": "[0, 60]", "notes": "Lorem Ipsum", "metainfo": { "fields": { "budget": True, "spend": True, "startDate": True, "endDate": True, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, }, { "id": 11, "uuid": "796b6f6d-d1af-4d45-a481-f5ed47207d9e", "name": "test_campaign_11", "start_date": "2007-10-11", "end_date": "2007-11-10", "planned_budget": 222, "budget_spend": 12, "workflow_status": "Booked", "created_at": "2021-07-22 16:14:55.355226", "updated_at": "2021-07-22 16:14:55.355226", "provider_id": 8, "is_deleted": True, "age_range": "[0, 60]", "notes": "Lorem Ipsum", "external_marketing_account_id": "8653387137", "metainfo": { "fields": { "budget": True, "spend": True, "startDate": True, "endDate": True, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, }, { "id": 12, "uuid": "14de4467-b04d-4fb4-b02e-5ab802e02608", "name": "test_campaign_12", "project_id": 4, "start_date": "2007-10-11", "end_date": "2007-11-10", "planned_budget": 222, "budget_spend": 12, "workflow_status": "Booked", "created_at": "2021-07-22 16:14:55.355226", "updated_at": "2021-07-22 16:14:55.355226", "provider_id": 9, "age_range": "[0, 60]", "notes": "Lorem Ipsum", "metainfo": { "fields": { "budget": True, "spend": True, "startDate": True, "endDate": True, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, }, ], "ProjectCampaign": [ {"project_id": 1, "campaign_id": 1, "status": 1}, {"project_id": 1, "campaign_id": 2, "status": 0}, {"project_id": 2, "campaign_id": 3, "status": 1}, {"project_id": 2, "campaign_id": 4, "status": 0}, {"project_id": 3, "campaign_id": 5, "status": 1}, {"project_id": 3, "campaign_id": 6, "status": 2}, {"project_id": 3, "campaign_id": 7, "status": 0}, {"project_id": 1, "campaign_id": 10, "status": 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": "{}", }, ], "UserLabel": [{"user_id": 1, "label_id": 1}, {"user_id": 2, "label_id": 2}], "UserProject": [ {"project_id": 1, "user_id": 1, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 2, "user_id": 2, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 3, "user_id": 1, "shared_by": 2, "editable": False, "role": 1}, {"project_id": 3, "user_id": 2, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 4, "user_id": 1, "shared_by": 1, "editable": False, "role": 1}, ], "MarketingAccount": [ {"id": 1, "label_id": 1, "type": 0, "external_id": "8653387137", "provider_id": 1}, {"id": 2, "label_id": 2, "type": 0, "external_id": "2333825793", "provider_id": 2}, ], "CampaignProvider": [ {"id": 1, "name": "Sony Music", "is_prs_vendor": False}, {"id": 2, "name": "Gupta Media", "is_prs_vendor": False}, {"id": 3, "name": "BOBBY LEWIS", "is_prs_vendor": True}, {"id": 4, "name": "ENTERCOM BUFFALO LLC", "is_prs_vendor": True}, {"id": 5, "name": "ZEEDA M DANIELE", "is_prs_vendor": True}, {"id": 6, "name": "SAVAGE MEDIA HOLDINGS LLC", "is_prs_vendor": True}, {"id": 7, "name": "PRS BCD TRAVEL", "is_prs_vendor": True}, {"id": 8, "name": "PRS BCD TRAVEL TEST", "is_prs_vendor": True}, {"id": 9, "name": "PRS BCD TRAVEL TEST 2", "is_prs_vendor": True}, ], }