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",
},
{
"id": 2,
"email": "dev-marketing-user-2@example.com",
"external_id": "sme-dna|3po0091d6c91ty670fe6ftryf",
"name": "dev-marketing-user-2",
"phone": "67589838844",
},
],
"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": 4,
"budget": 66666,
"allocation": 12000.0,
"prs_project_code": 297123,
"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_claimed": True,
"end_date": "2020-10-11",
"gras_title": "DJ GRAS feat. 100 id",
"prs_title": "DJ GRAS feat. 100 id from PRS",
"updated_by_import_at": "2021-02-22 16:14:35.748032",
"gras_project_code": "GRAS_100",
},
{
"id": 501,
"name": "test_project_1",
"label_id": 4,
"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_claimed": True,
"end_date": "2020-10-11",
"gras_title": "DJ GRAS feat. 100 id",
"prs_title": "DJ GRAS feat. 100 id from PRS",
"updated_by_import_at": "2021-02-22 16:14:35.748032",
"gras_project_code": "GRAS_10012",
"budget": 66666,
"allocation": 12000.0,
"prs_project_code": 29712323,
},
],
"Campaign": [
{
"id": 7180,
"uuid": "34ed4c22-e1f9-4184-a06d-f04cbdb97455",
"name": "Outdoor Ads | Traditional Outdoor",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 0.00,
"edit_user_id": 1,
"objective_id": 2,
"notes": "",
"created_at": "2021-03-06 07:45:56.879041",
"updated_at": "2021-03-06 07:45:56.879041",
"start_date": "2021-03-05",
"end_date": "2021-03-05",
"age_range": "[13,66)",
"provider_id": 1,
"budget_spend": 1000.00,
"metainfo": {
"fields": {
"destinations": True,
"startDate": True,
"audienceAge": True,
"spend": True,
"objective": True,
"budget": True,
"provider": True,
"campaignTypes": True,
"endDate": True,
"name": True,
"genders": True,
"countries": True,
"notes": True,
}
},
"type_id": 10,
},
{
"id": 7179,
"uuid": "aa1490b5-832c-4852-9d28-7a96884ff399",
"name": "Retail Marketing | Live",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 0.00,
"edit_user_id": 1,
"is_deleted": False,
"objective_id": 2,
"notes": "",
"created_at": "2021-03-06 07:43:00.027422",
"updated_at": "2021-03-06 07:43:00.027422",
"start_date": "2021-03-05",
"end_date": "2021-03-05",
"age_range": "[13,66)",
"provider_id": 1,
"budget_spend": 0.00,
"metainfo": {
"fields": {
"destinations": True,
"startDate": True,
"audienceAge": True,
"spend": True,
"objective": True,
"budget": True,
"provider": True,
"campaignTypes": True,
"endDate": True,
"name": True,
"genders": True,
"countries": True,
"notes": True,
}
},
"type_id": 7,
},
{
"id": 7178,
"uuid": "c40fe4e8-58ce-4ba6-ab10-4932e685a389",
"name": "Influencer Marketing | Pinterest",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 900.00,
"edit_user_id": 1,
"is_deleted": False,
"objective_id": 1,
"notes": "",
"created_at": "2021-03-05 15:34:51.827071",
"updated_at": "2021-03-05 15:34:51.827071",
"start_date": "2021-03-04",
"end_date": "2021-03-04",
"age_range": "[13,66)",
"provider_id": 1,
"budget_spend": 0.00,
"metainfo": {
"fields": {
"destinations": True,
"startDate": True,
"audienceAge": True,
"spend": True,
"objective": True,
"budget": True,
"provider": True,
"campaignTypes": True,
"endDate": True,
"name": True,
"genders": True,
"countries": True,
"notes": True,
}
},
"type_id": 9,
},
{
"id": 7177,
"uuid": "2dd6f9b4-42f5-48e8-a01f-c7bb9dc6434d",
"name": "Display Ads | Amazon",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 1050.00,
"edit_user_id": 1,
"is_deleted": False,
"objective_id": 1,
"notes": "",
"created_at": "2021-03-05 15:33:43.001879",
"updated_at": "2021-03-05 15:33:43.001879",
"start_date": "2021-03-06",
"end_date": "2021-03-06",
"age_range": "[13,66)",
"provider_id": 1,
"budget_spend": 0.00,
"metainfo": {
"fields": {
"destinations": True,
"startDate": True,
"audienceAge": True,
"spend": True,
"objective": True,
"budget": True,
"provider": True,
"campaignTypes": True,
"endDate": True,
"name": True,
"genders": True,
"countries": True,
"notes": True,
}
},
"type_id": 8,
},
{
"id": 7176,
"uuid": "55e87545-a3b3-4bd1-9357-a5373df46270",
"name": "Contests | Other",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 200.00,
"edit_user_id": 1,
"is_deleted": False,
"objective_id": 1,
"notes": "",
"created_at": "2021-03-05 15:32:50.606227",
"updated_at": "2021-03-06 07:28:00.445656",
"start_date": "2021-03-05",
"end_date": "2021-03-05",
"age_range": "[13,66)",
"provider_id": 1,
"budget_spend": 0.00,
"source": "facebook",
"metainfo": {
"fields": {
"destinations": True,
"startDate": True,
"audienceAge": True,
"spend": True,
"objective": True,
"budget": True,
"provider": True,
"campaignTypes": True,
"endDate": True,
"name": True,
"genders": True,
"countries": True,
"notes": True,
}
},
"type_id": 15,
},
{
"id": 7175,
"uuid": "20618d97-5190-4589-8fed-9e109e5ac5b5",
"name": "Organic Post | Reddit",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 190.00,
"edit_user_id": 1,
"is_deleted": False,
"objective_id": 1,
"notes": "",
"created_at": "2021-03-05 15:31:56.070611",
"updated_at": "2021-03-06 07:28:00.445656",
"start_date": "2021-03-06",
"end_date": "2021-03-06",
"age_range": "[13,66)",
"provider_id": 1,
"budget_spend": 0.00,
"source": "facebook",
"metainfo": {
"fields": {
"destinations": True,
"startDate": True,
"audienceAge": True,
"spend": True,
"objective": True,
"budget": True,
"provider": True,
"campaignTypes": True,
"endDate": True,
"name": True,
"genders": True,
"countries": True,
"notes": True,
}
},
"type_id": 17,
},
{
"id": 7174,
"uuid": "0b70c231-1997-417b-a23f-9a89ffa4f6bf",
"name": "Email Marketing | Sony CRM",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 4000.00,
"edit_user_id": 1,
"is_deleted": False,
"objective_id": 1,
"notes": "",
"created_at": "2021-03-05 15:30:24.558554",
"updated_at": "2021-03-06 07:28:10.585431",
"start_date": "2021-03-06",
"end_date": "2021-03-06",
"age_range": "[13,66)",
"provider_id": 1,
"budget_spend": 0.00,
"source": "google",
"metainfo": {
"fields": {
"destinations": True,
"startDate": True,
"audienceAge": True,
"spend": True,
"objective": True,
"budget": True,
"provider": True,
"campaignTypes": True,
"endDate": True,
"name": True,
"genders": True,
"countries": True,
"notes": True,
}
},
"type_id": 25,
},
{
"id": 7173,
"uuid": "9d6211cf-1e47-487d-bb01-e08f6472d71e",
"name": "DJ Promo | Satellite Radio",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 1230.00,
"edit_user_id": 1,
"is_deleted": False,
"objective_id": 1,
"notes": "",
"created_at": "2021-03-05 15:29:16.365886",
"updated_at": "2021-03-05 15:29:16.365886",
"start_date": "2021-03-05",
"end_date": "2021-03-05",
"age_range": "[13,66)",
"provider_id": 1,
"budget_spend": 0.00,
"metainfo": {
"fields": {
"destinations": True,
"startDate": True,
"audienceAge": True,
"spend": True,
"objective": True,
"budget": True,
"provider": True,
"campaignTypes": True,
"endDate": True,
"name": True,
"genders": True,
"countries": True,
"notes": True,
}
},
"type_id": 27,
},
{
"id": 7172,
"uuid": "df9a3dc8-c3d3-440c-bc3c-cee1c3c2dd67",
"name": "Connected TV Ads | Crackle",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 1000.00,
"edit_user_id": 1,
"is_deleted": False,
"objective_id": 1,
"notes": "",
"created_at": "2021-03-05 15:28:52.479926",
"updated_at": "2021-03-05 15:28:52.479926",
"start_date": "2021-03-05",
"end_date": "2021-03-05",
"age_range": "[13,66)",
"provider_id": 1,
"budget_spend": 0.00,
"metainfo": {
"fields": {
"destinations": True,
"startDate": True,
"audienceAge": True,
"spend": True,
"objective": True,
"budget": True,
"provider": True,
"campaignTypes": True,
"endDate": True,
"name": True,
"genders": True,
"countries": True,
"notes": True,
}
},
"type_id": 28,
},
{
"id": 17,
"uuid": "85f802d2-1296-49e8-a12f-7d11d46acdca",
"name": "Other Digital | PRS",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 2376.67,
"edit_user_id": 1,
"is_deleted": False,
"objective_id": 4,
"notes": "Appreciation Engine/FB ad credits campaign",
"created_at": "2021-03-05 08:51:24.799092",
"updated_at": "2021-03-05 17:08:33.191349",
"start_date": "2019-08-11",
"end_date": "2021-03-11",
"age_range": "[0,66)",
"provider_id": 1,
"budget_spend": 2376.67,
"source": "PRS",
"metainfo": {
"fields": {
"notes": False,
"genders": True,
"campaignTypes": True,
"spend": False,
"destinations": True,
"audienceAge": True,
"provider": False,
"budget": False,
"name": False,
"endDate": True,
"startDate": False,
"objective": True,
"countries": True,
}
},
},
{
"id": 18,
"uuid": "e91d5585-f454-4bdd-9420-c995a7fbcee3",
"name": "Other Digital | PRS",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 2376.67,
"edit_user_id": 1,
"is_deleted": False,
"objective_id": 2,
"notes": "Appreciation Engine/FB ad credits campaign",
"created_at": "2021-03-05 08:51:24.873802",
"updated_at": "2021-03-05 13:33:46.022663",
"start_date": "2019-08-12",
"end_date": "2021-03-11",
"age_range": "[0,66)",
"provider_id": 1,
"budget_spend": 2376.67,
"source": "PRS",
"metainfo": {
"fields": {
"notes": False,
"genders": True,
"campaignTypes": True,
"spend": False,
"destinations": True,
"audienceAge": True,
"provider": False,
"budget": False,
"name": False,
"endDate": True,
"startDate": False,
"objective": True,
"countries": True,
}
},
},
{
"id": 16,
"uuid": "796b6f6d-d1af-4d45-a481-f5ed47207d9e",
"name": "Other Digital | PRS",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 220.00,
"edit_user_id": 1,
"is_deleted": False,
"notes": "John Mayer paid video assets - CTA updates",
"created_at": "2021-03-05 08:51:24.720401",
"updated_at": "2021-03-05 13:29:48.085300",
"start_date": "2019-06-06",
"age_range": "[0,66)",
"provider_id": 1,
"budget_spend": 220.00,
"source": "PRS",
"metainfo": {
"fields": {
"notes": False,
"genders": True,
"campaignTypes": True,
"spend": False,
"destinations": True,
"audienceAge": True,
"provider": False,
"budget": False,
"name": False,
"endDate": True,
"startDate": False,
"objective": True,
"countries": True,
}
},
},
{
"id": 15,
"uuid": "14de4467-b04d-4fb4-b02e-5ab802e02608",
"name": "Other Digital | PRS",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 905.00,
"edit_user_id": 1,
"is_deleted": False,
"notes": "revisions of the John Mayer assets currently running.On & Off Platform Playlist Marketing",
"created_at": "2021-03-05 08:51:24.624066",
"updated_at": "2021-03-05 13:29:48.085300",
"start_date": "2019-04-01",
"age_range": "[0,66)",
"provider_id": 1,
"budget_spend": 905.00,
"source": "PRS",
"metainfo": {
"fields": {
"notes": False,
"genders": True,
"campaignTypes": True,
"spend": False,
"destinations": True,
"audienceAge": True,
"provider": False,
"budget": False,
"name": False,
"endDate": True,
"startDate": False,
"objective": True,
"countries": True,
}
},
},
{
"id": 14,
"uuid": "209a0924-5627-4b45-83cf-f0a38c4dfd24",
"name": "Other Digital | PRS",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 2520.00,
"edit_user_id": 1,
"is_deleted": False,
"notes": "John Mayer ?I Guess I Just Feel Like? post-single off platform playlist marketing campaign.",
"created_at": "2021-03-05 08:51:24.458749",
"updated_at": "2021-03-05 13:29:48.085300",
"start_date": "2019-03-29",
"age_range": "[0,66)",
"provider_id": 1,
"budget_spend": 2520.00,
"source": "PRS",
"metainfo": {
"fields": {
"notes": False,
"genders": True,
"campaignTypes": True,
"spend": False,
"destinations": True,
"audienceAge": True,
"provider": False,
"budget": False,
"name": False,
"endDate": True,
"startDate": False,
"objective": True,
"countries": True,
}
},
},
{
"id": 13,
"uuid": "209a0924-5627-4b45-83cf-f0a38c4dfd25",
"name": "Other Digital | PRS",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 3627.09,
"edit_user_id": 1,
"is_deleted": False,
"notes": "John Mayer post-single-release campaign",
"created_at": "2021-03-05 08:51:24.229033",
"updated_at": "2021-03-05 13:29:48.085300",
"start_date": "2019-03-21",
"age_range": "[0,66)",
"provider_id": 1,
"budget_spend": 3627.09,
"source": "PRS",
"metainfo": {
"fields": {
"notes": False,
"genders": True,
"campaignTypes": True,
"spend": False,
"destinations": True,
"audienceAge": True,
"provider": False,
"budget": False,
"name": False,
"endDate": True,
"startDate": False,
"objective": True,
"countries": True,
}
},
},
{
"id": 12,
"uuid": "209a0924-5627-4b45-83cf-f0a38c4dfd26",
"name": "Other Digital | PRS",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 2520.00,
"edit_user_id": 1,
"is_deleted": False,
"notes": "John Mayer ? playlist campaign assets (video- and image-based creatives) (Gupta)",
"created_at": "2021-03-05 08:51:24.165907",
"updated_at": "2021-03-05 13:29:48.085300",
"start_date": "2019-02-26",
"age_range": "[0,66)",
"provider_id": 1,
"budget_spend": 2520.00,
"source": "PRS",
"metainfo": {
"fields": {
"notes": False,
"genders": True,
"campaignTypes": True,
"spend": False,
"destinations": True,
"audienceAge": True,
"provider": False,
"budget": False,
"name": False,
"endDate": True,
"startDate": False,
"objective": True,
"countries": True,
}
},
},
{
"id": 10,
"uuid": "209a0924-5627-4b45-83cf-f0a38c4dfd27",
"name": "Other Digital | PRS",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 12600.00,
"edit_user_id": 1,
"is_deleted": False,
"notes": 'John Mayer facebook ads to support "I Guess I Just Feel Like" release',
"created_at": "2021-03-05 08:51:23.923555",
"updated_at": "2021-03-05 13:29:48.085300",
"start_date": "2019-02-22",
"age_range": "[0,66)",
"provider_id": 1,
"budget_spend": 12600.00,
"source": "PRS",
"metainfo": {
"fields": {
"notes": False,
"genders": True,
"campaignTypes": True,
"spend": False,
"destinations": True,
"audienceAge": True,
"provider": False,
"budget": False,
"name": False,
"endDate": True,
"startDate": False,
"objective": True,
"countries": True,
}
},
"purchase_order_id": 475,
},
{
"id": 11,
"uuid": "209a0924-5627-4b45-83cf-f0a38c4dfd28",
"name": "Other Digital | PRS",
"project_id": 500,
"create_user_id": 1,
"planned_budget": 100.00,
"edit_user_id": 1,
"is_deleted": False,
"notes": 'John Mayer facebook ads to support "I Guess I Just Feel Like" release',
"created_at": "2021-03-05 08:51:23.923555",
"updated_at": "2021-03-05 13:29:48.085300",
"start_date": "2019-02-22",
"age_range": "[0,66)",
"provider_id": 1,
"budget_spend": 50.00,
"source": "PRS",
"metainfo": {
"fields": {
"notes": False,
"genders": True,
"campaignTypes": True,
"spend": False,
"destinations": True,
"audienceAge": True,
"provider": False,
"budget": False,
"name": False,
"endDate": True,
"startDate": False,
"objective": True,
"countries": True,
}
},
"purchase_order_id": 474,
},
],
"PRSPurchaseOrder": [
{
"id": 474,
"name": "Jesse Rutherford indie fees Q1 F20 | PO 1092858000",
"po_number": 1092858000,
"total_amount": 9000.00,
"paid_amount": 7000.00,
"group_id": 1,
"category_id": 1,
"created_date": "2019-04-03",
"last_modified_date": "2019-10-01",
"is_blanked": True,
"is_deleted": False,
"description": "Jess Rutherford indie press",
"status": 10,
"project_id": 500,
"provider_id": 1,
"is_under_uncommited_blanket": True,
},
{
"id": 475,
"name": "ORIENTEER GROUP LLC | PO 1092858001",
"po_number": 1092858001,
"total_amount": 3000.00,
"paid_amount": 2500.00,
"group_id": 1,
"category_id": 1,
"created_date": "2019-04-03",
"last_modified_date": "2019-10-01",
"is_blanked": False,
"is_deleted": False,
"description": "Jess Rutherford indie press April fee - $3,000",
"status": 10,
"parent_po_number": 1092858000,
"project_id": 500,
"provider_id": 2,
"is_under_uncommited_blanket": False,
},
],
"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": "{}",
},
],
"UserLabel": [{"user_id": 1, "label_id": 1}, {"user_id": 2, "label_id": 2}],
"ProjectTargetItem": [
{"project_id": 500, "entity_id": 10, "entity_type": 0},
{"project_id": 501, "entity_id": 10, "entity_type": 0},
],
"Artist": [{"id": 10, "external_id": "GRAS_124267", "name": "TestAtrist", "is_sony": True}],
"Polymorphable": [{"id": 10, "type": "Artist"}],
"Playlist": [],
"Image": [],
"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},
],
"CampaignPlatformsLinks": [
{"campaign_id": 7180, "platform_id": 1},
{"campaign_id": 7179, "platform_id": 2},
{"campaign_id": 7178, "platform_id": 3},
{"campaign_id": 7177, "platform_id": 4},
{"campaign_id": 7176, "platform_id": 6},
{"campaign_id": 7175, "platform_id": 8},
{"campaign_id": 7174, "platform_id": 8},
{"campaign_id": 7173, "platform_id": 9},
{"campaign_id": 7172, "platform_id": 9},
],
"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},
],
}