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", }, ], "UserProject": [ {"project_id": 500, "user_id": 1, "shared_by": 1, "editable": True, "role": 1}, {"project_id": 500, "user_id": 2, "shared_by": 1, "editable": True, "role": 3}, {"project_id": 501, "user_id": 1, "shared_by": 1, "editable": True, "role": 1}, {"project_id": 502, "user_id": 3, "shared_by": 1, "editable": True, "role": 1}, {"project_id": 503, "user_id": 3, "shared_by": 1, "editable": True, "role": 1}, {"project_id": 504, "user_id": 3, "shared_by": 1, "editable": True, "role": 1}, ], "Project": [ { "id": 500, "name": "test_project_1", "label_id": 4, "is_claimed": True, "end_date": "2020-10-11", "created_at": "2019-07-22 16:14:35.748032", "currency": "GBP", "create_user_id": 1, "updated_at": "2019-07-22 16:14:55.446196", "edit_user_id": 1, "is_confidential": False, "budget": 66666, "allocation": 66666, "initial_start_date": "2018-10-11", "gras_title": "New Frontline Release", "gras_project_code": "12345510", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345510", "updated_by_import_at": "2020-10-11", }, { "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", "currency": "GBP", "create_user_id": 1, "updated_at": "2019-07-22 16:14:55.446196", "edit_user_id": 1, "is_deleted": True, "is_confidential": False, "budget": 34399, "allocation": 34399, "initial_start_date": "2018-10-11", "gras_title": "New Frontline Release", "gras_project_code": "12345511", "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": 4, "is_claimed": True, "end_date": "2020-10-11", "created_at": "2019-07-22 16:14:35.748032", "currency": "GBP", "create_user_id": 1, "updated_at": "2019-07-22 16:14:55.446196", "edit_user_id": 1, "notes": "Some notes", "is_confidential": False, "budget": 88899, "allocation": 88899, "initial_start_date": "2018-10-11", "gras_title": "New Frontline Release", "gras_project_code": "12345512", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345512", "updated_by_import_at": "2020-10-11", }, { "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", "currency": "GBP", "create_user_id": 1, "updated_at": "2019-07-22 16:14:55.446196", "edit_user_id": 1, "is_confidential": False, "budget": 88899, "allocation": 88899, "initial_start_date": "2018-10-11", "gras_title": "New Frontline Release", "gras_project_code": "12345513", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345513", "updated_by_import_at": "2020-10-11", }, { "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", "currency": "GBP", "edit_user_id": 1, "is_confidential": False, "budget": 88899, "allocation": 88899, "initial_start_date": "2018-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", }, ], "ProjectPhase": [ {"id": 450, "name": "Phase For Test", "project_id": 500, "order": 1}, {"id": 550, "name": "Phase For Test [Empty]", "project_id": 501, "order": 1}, {"id": 555, "name": "Phase For Test [All Deleted]", "project_id": 502, "order": 1}, {"id": 600, "name": "Phase For Test [All Deleted]", "project_id": 503, "order": 1}, {"id": 655, "name": "Phase For Test [All Deleted]", "project_id": 504, "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": "{}"}, ], "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}, ], "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}, {"id": 2, "name": "USA", "code": "USA", "territory_type_id": 1}, ], "ProjectTargetItem": [ {"project_id": 500, "entity_id": 10, "entity_type": 0}, {"project_id": 500, "entity_id": 20, "entity_type": 0}, {"project_id": 501, "entity_id": 10, "entity_type": 0}, {"project_id": 502, "entity_id": 20, "entity_type": 0}, {"project_id": 503, "entity_id": 20, "entity_type": 0}, {"project_id": 504, "entity_id": 10, "entity_type": 0}, {"project_id": 504, "entity_id": 20, "entity_type": 0}, ], "Artist": [ {"id": 10, "external_id": "GRAS_2036", "name": "TestAtrist", "is_sony": True}, {"id": 20, "external_id": "GRAS_2037", "name": "TestingUpdate", "is_sony": True}, {"id": 30, "external_id": "GRAS_2038", "name": "artist2", "is_sony": True}, {"id": 40, "external_id": "GRAS_2039", "name": "artist01", "is_sony": True}, {"id": 50, "external_id": "GRAS_2040", "name": "UpdateArtist", "is_sony": True}, {"id": 60, "external_id": "GRAS_2041", "name": "artist2e", "is_sony": True}, {"id": 130, "external_id": "GRAS_2030", "name": "Petruccho", "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": 130, "type": "Artist"}, ], "Image": [ {"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", "create_user_id": 1, "start_date": "2007-02-02", "end_date": "2008-10-10", "planned_budget": 222, "budget_spend": 1000, "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, "is_deleted": False, "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, "source": "facebook", }, { "id": 2, "uuid": "aa1490b5-832c-4852-9d28-7a96884ff399", "name": "test_campaign_2", "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, "age_range": "(0, 60)", "objective_id": 1, "source": "facebook", }, { "id": 3, "uuid": "c40fe4e8-58ce-4ba6-ab10-4932e685a389", "name": "test_deleted_campaign_3", "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, "source": "tiktok", }, { "id": 4, "uuid": "2dd6f9b4-42f5-48e8-a01f-c7bb9dc6434d", "name": "test_campaign_4", "external_id": "ghfjdkls", "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, "source": "google", }, { "id": 5, "uuid": "20618d97-5190-4589-8fed-9e109e5ac5b5", "project_id": 500, "name": "campaign_5", "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, "source": "facebook", }, { "id": 6, "uuid": "0b70c231-1997-417b-a23f-9a89ffa4f6bf", "project_id": 500, "name": "campaign_6", "external_id": "jrvnvfvfffvw22", "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, "source": "facebook", }, { "id": 7, "uuid": "9d6211cf-1e47-487d-bb01-e08f6472d71e", "name": "rejected_campaign_for_500_project", "external_id": "cfnjxkml674945", "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, "source": "dec", }, { "id": 8, "uuid": "9d6211cf-1e47-487d-bb01-e08f6472d333", "name": "campaign_approved_to_another_project", "project_id": 501, "external_id": "zdkjhfsldk2", "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, "source": "dec", }, { "id": 9, "uuid": "9d6211cf-1e47-487d-bb01-e08f6472d777", "name": "already_rejected_campaign_for_500_project", "external_id": "cfnjxkml67494556", "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, "source": "dec", }, ], "Currency": [{"id": 1, "name": "United States Dollar", "code": "USD"}, {"id": 2, "name": "Hryvnya", "code": "UAH"}], "ProjectCampaign": [ {"id": 50, "project_id": 500, "campaign_id": 3, "status": 0}, {"id": 100, "project_id": 500, "campaign_id": 5, "status": 0}, {"id": 150, "project_id": 500, "campaign_id": 6, "status": 0}, {"id": 200, "project_id": 501, "campaign_id": 4, "status": 0}, {"id": 250, "project_id": 501, "campaign_id": 8, "status": 1}, {"id": 300, "project_id": 500, "campaign_id": 9, "status": 2}, ], }