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": "", }, ], "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", }, ], "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": 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": 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": 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": 4, "uuid": "2dd6f9b4-42f5-48e8-a01f-c7bb9dc6434d", "name": "test_campaign_1", "create_user_id": 2, "start_date": "2007-10-11", "end_date": "2007-11-10", "workflow_status": "Booked", "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": 5, "uuid": "55e87545-a3b3-4bd1-9357-a5373df46270", "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": 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": 6, "uuid": "20618d97-5190-4589-8fed-9e109e5ac5b5", "name": "test_campaign_1", "create_user_id": 2, "start_date": "2007-10-11", "workflow_status": "Booked", "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": 7, "uuid": "0b70c231-1997-417b-a23f-9a89ffa4f6bf", "name": "test_campaign_1", "create_user_id": 2, "start_date": "2007-10-11", "workflow_status": "Booked", "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": 8, "uuid": "9d6211cf-1e47-487d-bb01-e08f6472d71e", "name": "test_campaign_1", "start_date": "2007-10-11", "workflow_status": "Booked", "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, "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": "df9a3dc8-c3d3-440c-bc3c-cee1c3c2dd67", "name": "test_campaign_1", "start_date": "2007-10-11", "workflow_status": "Booked", "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, "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": "85f802d2-1296-49e8-a12f-7d11d46acdca", "name": "test_campaign_1", "start_date": "2007-10-11", "end_date": "2007-11-10", "workflow_status": "Booked", "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, } }, }, ], "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": 3, "user_id": 1, "role": 1, "shared_by": 2}, {"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": 2, "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"}, {"id": 2, "name": "Gupta Media"}], "CampaignPlatforms": [ {"id": 1, "name": "Apple TV"}, {"id": 2, "name": "Sling TV"}, {"id": 3, "name": "High Society"}, {"id": 4, "name": "Live"}, {"id": 5, "name": "Appreciation Engine"}, {"id": 6, "name": "HypeBeast"}, {"id": 7, "name": "Pandora"}, {"id": 8, "name": "Megaphone"}, {"id": 9, "name": "Snapchat"}, {"id": 10, "name": "Spot Cable"}, ], "CampaignPlatformsLinks": [ {"campaign_id": 1, "platform_id": 1}, {"campaign_id": 2, "platform_id": 2}, {"campaign_id": 3, "platform_id": 3}, {"campaign_id": 4, "platform_id": 4}, {"campaign_id": 5, "platform_id": 5}, {"campaign_id": 6, "platform_id": 6}, {"campaign_id": 7, "platform_id": 7}, {"campaign_id": 8, "platform_id": 8}, {"campaign_id": 9, "platform_id": 9}, {"campaign_id": 10, "platform_id": 10}, ], }