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", }, { "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", }, { "id": 6, "email": "dev-marketing-user-6@example.com", "external_id": "sme-dna|phn0091d6cuhjp30fe6opttml", "name": "dev-marketing-user-6", "phone": "09179947668", }, { "id": 7, "email": "dev-marketing-user-7@example.com", "external_id": "sme-dna|phn0077d6cuhjp30fe6opttml", "name": "dev-marketing-user-7", "phone": "091799477777", }, { "id": 8, "email": "dev-marketing-adminuch@example.com", "external_id": "sme-dna|phn0077d6cuhjp30fe6oadmin", "name": "Perfect admin", "phone": "091799477666", "is_admin": True, }, { "id": 9, "email": "dev-marketing-adminuch9@example.com", "external_id": "sme-dna|phn0077d6cuhjp30fe6oadmi9", "name": "NextPerfect admin", "phone": "091799477669", "is_admin": True, }, { "id": 10, "email": "dev-marketing-10@example.com", "external_id": "sme-dna|phn0077d6cuhjp30fe6oadm10", "name": "User 10", "phone": "091799477129", "is_admin": False, }, { "id": 42, "email": "answer@universe.com", "external_id": "sme-dna|phn0077d6cuhjp30fe6oadm42", "name": "Classic Approver", "phone": "091799474242", "is_admin": False, } ], "UserProject": [ {"project_id": 420, "user_id": 1, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 500, "user_id": 1, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 500, "user_id": 5, "shared_by": 1, "editable": True, "role": 1, "id": 90}, {"project_id": 500, "user_id": 4, "shared_by": 1, "editable": True, "role": 1, "id": 100}, {"project_id": 500, "user_id": 6, "shared_by": 1, "editable": True, "role": 3}, {"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": 6, "shared_by": 1, "editable": True, "role": 1, "id": 80}, {"project_id": 503, "user_id": 2, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 504, "user_id": 2, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 505, "user_id": 1, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 505, "user_id": 42, "shared_by": 1, "editable": False, "role": 4}, {"project_id": 505, "user_id": 8, "shared_by": 1, "editable": False, "role": 4}, {"project_id": 506, "user_id": 6, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 506, "user_id": 5, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 506, "user_id": 7, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 507, "user_id": 10, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 507, "user_id": 10, "shared_by": 1, "editable": False, "role": 4}, {"project_id": 508, "user_id": 2, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 508, "user_id": 2, "shared_by": 1, "editable": False, "role": 4}, {"project_id": 508, "user_id": 3, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 508, "user_id": 6, "shared_by": 1, "editable": False, "role": 4}, {"project_id": 509, "user_id": 1, "shared_by": 1, "editable": False, "role": 2}, ], "UserProjectCampaignTypeGroup": [ {"user_project_id": 100, "campaign_type_group_id": 1}, {"user_project_id": 80, "campaign_type_group_id": 1}, {"user_project_id": 80, "campaign_type_group_id": 2}, {"user_project_id": 80, "campaign_type_group_id": 3}, {"user_project_id": 90, "campaign_type_group_id": 1}, {"user_project_id": 90, "campaign_type_group_id": 2}, {"user_project_id": 90, "campaign_type_group_id": 3}, ], "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, "budget": 1402.41, "allocation": 1000.0, "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, "gras_title": "New Frontline Release", "gras_project_code": "GRAS_101", "prs_title": "DJ GRAS feat. 101 id from PRS", "updated_by_import_at": "2021-02-22 16:14:35.748032", "initial_start_date": "2007-01-01", "prs_project_code": 29713, }, { "id": 420, "name": "test_project_420", "label_id": 4, "budget": 1402.41, "allocation": 4242.0, "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, "gras_title": "New Frontline Release", "gras_project_code": "GRAS_42", "prs_title": "DJ GRAS feat. 42 id from PRS", "updated_by_import_at": "2021-02-22 16:14:35.748032", "initial_start_date": "2007-01-01", "prs_project_code": 29742, }, { "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, "budget": 45678.41, "allocation": 87654.0, "prs_project_code": 29714, "gras_title": "DJ GRAS feat. 102 id", "prs_title": "DJ GRAS feat. 102 id from PRS", "updated_by_import_at": "2021-02-22 16:14:35.748032", "initial_start_date": "2009-02-02", "gras_project_code": "GRAS_102", }, { "id": 502, "name": "test_project_3", "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, "notes": "Some notes", "gras_project_code": "GRAS_100", "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", "initial_start_date": "2007-02-02", "budget": 31402.41, "allocation": 9000.0, "prs_project_code": 29712, }, { "id": 503, "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, "gras_project_code": "GRAS_103", "gras_title": "DJ GRAS feat. 103 id", "prs_title": "DJ GRAS feat. 103 id from PRS", "updated_by_import_at": "2021-02-22 16:14:35.748032", "initial_start_date": "2015-02-02", "budget": 31402.41, "allocation": 12000.0, "prs_project_code": 29715, }, { "id": 504, "name": "test_project_3", "label_id": 6, "is_claimed": True, "end_date": "2020-10-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, "gras_project_code": "GRAS_104", "gras_title": "DJ GRAS feat. 104 id", "prs_title": "DJ GRAS feat. 104 id from PRS", "updated_by_import_at": "2021-02-22 16:14:35.748032", "initial_start_date": "2015-02-02", "budget": 31402.41, "allocation": 12000.0, "prs_project_code": 29716, }, { "id": 505, "name": "test_project_4", "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, "gras_project_code": "GRAS_105", "gras_title": "DJ GRAS feat. 105 id", "prs_title": "DJ GRAS feat. 105 id from PRS", "updated_by_import_at": "2021-02-22 16:14:35.748032", "initial_start_date": "2007-02-03", "budget": 31402.41, "allocation": 12000.0, "prs_project_code": 2971504, }, { "id": 506, "name": "test_project_6", "label_id": 6, "is_claimed": True, "end_date": "2020-10-11", "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": 3, "gras_project_code": "GRAS_106", "gras_title": "DJ GRAS feat. 106 id", "prs_title": "DJ GRAS feat. 106 id from PRS", "updated_by_import_at": "2021-02-22 16:14:35.748032", "initial_start_date": "2007-02-02", "budget": 31402.41, "allocation": 12000.0, "prs_project_code": 2971504, }, { "id": 507, "name": "test_project_7", "label_id": 6, "is_claimed": True, "end_date": "2020-10-11", "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": 3, "gras_project_code": "GRAS_106", "gras_title": "DJ GRAS feat. 106 id", "prs_title": "DJ GRAS feat. 106 id from PRS", "updated_by_import_at": "2021-02-22 16:14:35.748032", "initial_start_date": "2007-02-02", "budget": 31402.41, "allocation": 12000.0, "prs_project_code": 2971504, }, { "id": 508, "name": "test_project_8", "label_id": 7, "is_claimed": True, "is_confidential": True, "end_date": "2020-10-11", "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": 3, "gras_project_code": "GRAS_106", "gras_title": "DJ GRAS feat. 106 id", "prs_title": "DJ GRAS feat. 106 id from PRS", "updated_by_import_at": "2021-02-22 16:14:35.748032", "initial_start_date": "2007-02-02", "budget": 31402.41, "allocation": 12000.0, "prs_project_code": 2971504, }, { "id": 509, "label_id": 7, "is_claimed": False, "is_confidential": True, "end_date": "2020-10-11", "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": 3, "gras_project_code": "GRAS_106", "gras_title": "DJ GRAS feat. 106 id", "source": "PRS", "prs_title": "test_unclaimed_project_9", "updated_by_import_at": "2021-02-22 16:14:35.748032", "initial_start_date": "2007-02-02", "budget": 31402.41, "allocation": 12000.0, "prs_project_code": 2971504, }, ], "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}, {"id": 45, "name": "Untitled For Test", "project_id": 503, "order": 0}, {"id": 46, "name": "Untitled For Test", "project_id": 504, "order": 0}, ], "MediaPlanPhase": [ {"id": 450, "name": "Phase For Test", "media_plan_id": 42, "order": 1}, {"id": 451, "name": "Phase For Test 2", "media_plan_id": 42, "order": 2}, {"id": 452, "name": "Phase For Test 3", "media_plan_id": 42, "order": 3}, {"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}, {"id": 600, "name": "Phase For Test [All Deleted]", "media_plan_id": 45, "order": 1}, {"id": 655, "name": "Phase For Test [All Deleted]", "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": "{}"}, { "id": 7, "name": "NeNash", "rep_owner_key": "6234567", "external_name": "NeNash", "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}, {"user_id": 5, "label_id": 4}, {"user_id": 2, "label_id": 6}, {"user_id": 7, "label_id": 4}, {"user_id": 8, "label_id": 4}, {"user_id": 8, "label_id": 1}, {"user_id": 9, "label_id": 1}, {"user_id": 9, "label_id": 3}, {"user_id": 10, "label_id": 6}, {"user_id": 10, "label_id": 7}, {"user_id": 6, "label_id": 7}, ], "RecordType": [{"id": 1, "name": "Album"}, {"id": 2, "name": "Track"}, {"id": 3, "name": "Playlist"}], "TerritoryType": [{"id": 1, "name": "Global type"}], "Territory": [{"id": 1, "name": "Ukraine", "code": "UA", "territory_type_id": 1}], "ProjectTargetItem": [ {"project_id": 500, "entity_id": 70, "entity_type": 3}, {"project_id": 500, "entity_id": 80, "entity_type": 3}, {"project_id": 500, "entity_id": 90, "entity_type": 3}, {"project_id": 500, "entity_id": 100, "entity_type": 3}, {"project_id": 501, "entity_id": 10, "entity_type": 0}, {"project_id": 502, "entity_id": 20, "entity_type": 0, "add_type": 2}, {"project_id": 502, "entity_id": 30, "entity_type": 0}, {"project_id": 502, "entity_id": 40, "entity_type": 0}, {"project_id": 503, "entity_id": 60, "entity_type": 0}, {"project_id": 504, "entity_id": 120, "entity_type": 3}, {"project_id": 505, "entity_id": 140, "entity_type": 0}, {"project_id": 506, "entity_id": 150, "entity_type": 0, "add_type": 2}, {"project_id": 420, "entity_id": 42, "entity_type": 0, "add_type": 2}, {"project_id": 507, "entity_id": 10, "entity_type": 0}, {"project_id": 508, "entity_id": 10, "entity_type": 0, "add_type": 2}, {"project_id": 509, "entity_id": 10, "entity_type": 0, "add_type": 2}, ], "Artist": [ {"id": 10, "external_id": "GRAS_123421", "name": "TestAtrist", "is_sony": True, "is_unknown": False}, {"id": 20, "external_id": "GRAS_1234212", "name": "TestingUpdate", "is_sony": True, "is_unknown": False}, {"id": 30, "external_id": "GRAS_1234213", "name": "artist2", "is_sony": True, "is_unknown": False}, {"id": 40, "external_id": "GRAS_1234214", "name": "artist01", "is_sony": True, "is_unknown": False}, {"id": 50, "external_id": "GRAS_1234215", "name": "UpdateArtist", "is_sony": True, "is_unknown": False}, {"id": 60, "external_id": "GRAS_1234216", "name": "artist2e", "is_sony": True, "is_unknown": False}, {"id": 130, "external_id": "GRAS_2030", "name": "Petruccho", "is_sony": True, "is_unknown": False}, {"id": 140, "external_id": "GRAS_12426", "name": "Various feat. Bobul", "is_sony": True, "is_unknown": True}, {"id": 150, "external_id": "GRAS_124267", "name": "Various1 feat. Bobul", "is_sony": True, "is_unknown": True}, {"id": 42, "external_id": "GRAS_42422", "name": "Various feat. Universe", "is_sony": True, "is_unknown": True}, ], "ArtistTeam": [ { "artist_id": 10, "label_id": 1 }, { "id": 100, "artist_id": 10, "label_id": 6 }, { "id": 111, "artist_id": 20, "label_id": 4 }, { "id": 112, "artist_id": 130, "label_id": 7 }, { "id": 113, "artist_id": 150, "label_id": 6 }, ], "ArtistTeamUser": [ { "artist_team_id": 111, "user_id": 7, "role": 1 }, { "artist_team_id": 112, "user_id": 10, "role": 1 }, { "artist_team_id": 100, "user_id": 10, "role": 1 }, { "artist_team_id": 113, "user_id": 10, "role": 1 }, ], "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"}, {"id": 42, "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"}, ], "PRSProjectBudget": [ { "id": 81, "project_id": 502, "group_id": 2, "category_id": 8, "value": 23402.41, "is_deleted": False, "external_key": "29712-1-1-2-19-04/01/2019", }, { "id": 82, "project_id": 502, "group_id": 1, "category_id": 1, "value": 7000.00, "is_deleted": False, "external_key": "29712-1-1-1-1-04/01/2019", }, { "id": 84, "project_id": 502, "group_id": 3, "category_id": 1, "value": 1000.00, "is_deleted": False, "external_key": "29712-1-1-1-1-04/02/2019", }, ], "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": 502, "provider_id": 1, }, { "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": 502, "provider_id": 2, }, ], "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}, ], "Campaign": [ { "id": 1, "uuid": "34ed4c22-e1f9-4184-a06d-f04cbdb97455", "name": "test_campaign_1", "project_id": 500, "media_plan_phase_id": 450, "create_user_id": 1, "start_date": "2007-02-02", "end_date": "2008-10-10", "planned_budget": 222, "budget_spend": 1000, "currency_id": 1, "ecpm": 400, "created_at": "2019-07-22 16:14:55.355226", "updated_at": "2019-07-22 16:14:55.355226", "edit_user_id": 1, "is_deleted": False, "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, } }, }, { "id": 2, "uuid": "aa1490b5-832c-4852-9d28-7a96884ff399", "name": "test_campaign_2", "project_id": 500, "media_plan_phase_id": 451, "create_user_id": 1, "start_date": "2007-02-02", "end_date": "2008-10-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", "edit_user_id": 1, "is_deleted": False, "provider_id": 1, "ecpm": 5000, "age_range": "(0, 60)", "objective_id": 1, "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_deleted_campaign_3", "project_id": 501, "media_plan_phase_id": 550, "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, "is_deleted": True, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, }, { "id": 4, "uuid": "2dd6f9b4-42f5-48e8-a01f-c7bb9dc6434d", "name": "test_deleted_campaign_4", "project_id": 501, "media_plan_phase_id": 550, "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, }, { "id": 5, "uuid": "20618d97-5190-4589-8fed-9e109e5ac5b5", "name": "test_deleted_campaign_4", "project_id": 502, "media_plan_phase_id": 555, "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, }, { # draft campaign "id": 42, "uuid": "55e87545-a3b3-4bd1-9357-a5373df46270", "project_id": 502, "media_plan_phase_id": 555, "workflow_status": "Draft", "is_deleted": False }, { # draft campaign with relationship (not count like draft) "id": 43, "uuid": "55e87545-a3b3-4bd1-9357-a5373df46272", "project_id": 502, "media_plan_phase_id": 555, "workflow_status": "Draft", "planned_budget": 200, "ecpm": 4, "is_deleted": False }, { "id": 6, "uuid": "0b70c231-1997-417b-a23f-9a89ffa4f6bf", "name": "test_external_campaign_1", "project_id": 502, "media_plan_phase_id": 555, "external_id": "56748393", "create_user_id": 1, "start_date": "2007-02-02", "end_date": "2008-10-10", "planned_budget": 0, "budget_spend": 0, "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, "source": "facebook", "is_deleted": False, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, }, { "id": 7, "uuid": "9d6211cf-1e47-487d-bb01-e08f6472d71e", "name": "test_external_campaign_2", "project_id": 502, "media_plan_phase_id": 555, "external_id": "094875838", "create_user_id": 1, "start_date": "2007-02-02", "end_date": "2008-10-10", "planned_budget": 0, "budget_spend": 0, "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, "source": "google", "is_deleted": False, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, }, { "id": 8, "uuid": "df9a3dc8-c3d3-440c-bc3c-cee1c3c2dd67", "name": "test_campaign_prs", "project_id": 502, "media_plan_phase_id": 555, "create_user_id": 1, "start_date": "2007-02-02", "end_date": "2008-10-10", "planned_budget": 0, "budget_spend": 0, "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, "source": "PRS", "is_deleted": False, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, }, { "id": 9, "uuid": "85f802d2-1296-49e8-a12f-7d11d46acdca", "name": "test_campaign_media_plan_export", "project_id": 500, "media_plan_phase_id": 452, "create_user_id": 1, "start_date": "2010-02-02", "end_date": "2010-10-10", "planned_budget": 0, "budget_spend": 0, "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, "source": "PRS", "is_deleted": False, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, }, { "id": 10, "uuid": "e91d5585-f454-4bdd-9420-c995a7fbcee3", "name": "test_deleted_campaign_10", "project_id": 505, "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, "is_deleted": True, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, }, { "id": 11, "uuid": "796b6f6d-d1af-4d45-a481-f5ed47207d9e", "name": "pending_campaign", "create_user_id": 1, "start_date": "2007-02-02", "end_date": "2008-10-10", "planned_budget": 0, "budget_spend": 0, "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, }, { "id": 30, "uuid": "14de4467-b04d-4fb4-b02e-5ab802e02608", "external_id": "asdfghjkl", "name": "test_campaign_30", "project_id": 500, "media_plan_phase_id": 450, "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, "is_deleted": True, "provider_id": 1, "source": "facebook", "age_range": "(0, 60)", "objective_id": 2, "metainfo": { "fields": { "budget": True, "spend": True, "startDate": False, "endDate": False, "genders": True, "audienceAge": True, "countries": True, "destinations": True, "notes": True, } }, }, ], "ProjectCampaign": [ { "campaign_id": 1, "project_id": 500, "status": 1, }, { "campaign_id": 2, "project_id": 500, "status": 1, }, { "campaign_id": 3, "project_id": 501, "status": 1, }, { "campaign_id": 4, "project_id": 501, "status": 1, }, { "campaign_id": 5, "project_id": 502, "status": 1, }, { "campaign_id": 6, "project_id": 502, "status": 1, }, { "campaign_id": 7, "project_id": 502, "status": 1, }, { "campaign_id": 8, "project_id": 502, "status": 1, }, { "campaign_id": 9, "project_id": 500, "status": 1, }, { "campaign_id": 10, "project_id": 505, "status": 1, }, { "campaign_id": 11, "project_id": 502, "status": 0, }, { "campaign_id": 11, "project_id": 500, "status": 0, }, { "campaign_id": 30, "project_id": 500, "status": 1, }, ], "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": 30, "platform_id": 30}, ], "CampaignTerritory": [ {"campaign_id": 5, "territory_id": 1, "budget_spend": 5000}, {"campaign_id": 43, "territory_id": 1, "budget_spend": 5000}, {"campaign_id": 4, "territory_id": 1, "budget_spend": 5000}, ], "ArtistLevel": [{"id": 1, "name": "New"}, {"id": 2, "name": "Developing"}, {"id": 3, "name": "Established"}], "Currency": [{"id": 1, "name": "United States Dollar", "code": "USD"}, {"id": 2, "name": "Hryvnya", "code": "UAH"}], "Genre": [ {"id": 1, "name": "2-step"}, {"id": 2, "name": "20s"}, {"id": 3, "name": "30s"}, {"id": 4, "name": "40s"}, {"id": 5, "name": "4x4"}, {"id": 6, "name": "50s"}, {"id": 7, "name": "60s"}, {"id": 8, "name": "70s"}, {"id": 9, "name": "80s"}, {"id": 10, "name": "90s"}, {"id": 11, "name": "A Capella"}, {"id": 12, "name": "Acid"}, {"id": 13, "name": "Acid Jazz"}, {"id": 14, "name": "Acoustic"}, {"id": 15, "name": "Adult Contemporary"}, {"id": 16, "name": "African"}, {"id": 17, "name": "Afro-Cuban"}, {"id": 18, "name": "Afrobeat"}, {"id": 19, "name": "Algerian"}, ], "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}, {"project_id": 503, "created_at": "2019-01-01 00:00:02", "user_id": 1, "action_id": 1}, {"project_id": 508, "created_at": "2019-01-01 00:00:02", "user_id": 1, "action_id": 1}, {"project_id": 509, "created_at": "2019-01-01 00:00:00", "user_id": 1, "action_id": 1}, ], "RecentSearchItem": [ {"project_id": 500, "searched_at": "2019-01-01 00:00:00", "user_id": 1, "type": 4}, {"project_id": 505, "searched_at": "2019-01-01 00:00:01", "user_id": 1, "type": 4} ], "ProjectProductFamily": [{"id": 1, "project_id": 502, "product_family_id": 1}], "ProductFamily": [ {"id": 1, "external_id": "1", "title": "Test Family 1", "type": "Digital Singles ( One Track Link )"} ], "ProductTrack": [ { "id": 1, "product_id": 1, "isrc": "FR7U62000001", "title": "Track 1", "title_supplementary": "Album Version", "type": "Simple Track", "release_date": "2002-01-01 00:00:00", } ], "CampaignGender": [ {"campaign_id": 1, "gender_id": 1}, {"campaign_id": 2, "gender_id": 1}, {"campaign_id": 3, "gender_id": 1}, {"campaign_id": 4, "gender_id": 1}, {"campaign_id": 5, "gender_id": 1}, ], "LinkfireProject": [ {"project_id": 502, "linkfire_id": 1}, {"project_id": 502, "linkfire_id": 2}, {"project_id": 502, "linkfire_id": 3}, ], "LinkfireCampaign": [{"campaign_id": 5, "linkfire_id": 4}], "Linkfire": [ {"id": 1, "link_id": "afe36ac9-121b-4f23-a2f5-02417491828d", "link_url": "lnk.to/blink182_NACS"}, {"id": 2, "link_id": "9dcb0346-6c8f-45d7-b229-93f859238721", "link_url": "Blink182.lnk.to/NACS"}, {"id": 3, "link_id": "2b190f7c-cf68-4741-9c06-2718c473f6e5", "link_url": "lnk.to/Blink_182"}, {"id": 4, "link_id": "ca98fcdd-61ae-43df-b973-765c1ed9143f", "link_url": "lnk.to/blink-182_BIOMY"}, {"id": 5, "link_id": "90708787-46a8-4d38-8f5f-4b730951e395", "link_url": "Blink182.lnk.to/Quarantine"}, ], }