from tests.root_fixture import root_fixture from datetime import datetime, timedelta fixture = { **root_fixture, "User": [ { "id": 1, "email": "dev-marketing-user-1@example.com", "external_id": "sme-dna|5cf0091d6c91d310fe6fcdc6", "name": "user-1", "is_admin": True, "phone": "+1234234", }, { "id": 2, "email": "dev-marketing-user-2@example.com", "external_id": "sme-dna|5cf0091d6c91d310fe6fcdc7", "is_admin": False, "name": "user-2", "phone": "", }, { "id": 3, "email": "dev-marketing-user-3@example.com", "external_id": "sme-dna|5cf0091d6c91d310fe6fcdc8", "name": "user-3", "phone": "", }, { "id": 4, "email": "dev-marketing-user-4@example.com", "external_id": "sme-dna|5cf0091d6c91d310fe6fcd42", "is_admin": False, "name": "user-4", "phone": "", }, ], "Artist": [ {"id": 10, "external_id": "GRAS_10", "name": "TestAtrist1", "is_sony": True}, {"id": 20, "external_id": "GRAS_20", "name": "TestArtist2", "is_sony": True}, {"id": 30, "external_id": "GRAS_30", "name": "TestArtist3", "is_sony": True}, {"id": 40, "external_id": "GRAS_40", "name": "TestArtist4", "is_sony": True}, {"id": 50, "external_id": "GRAS_50", "name": "TestArtist5", "is_sony": True}, {"id": 60, "external_id": "GRAS_60", "name": "TestArtist6", "is_sony": True}, {"id": 70, "external_id": "GRAS_70", "name": "TestArtist7", "is_sony": True}, {"id": 80, "external_id": "GRAS_80", "name": "TestArtist8", "is_sony": True}, {"id": 90, "external_id": "GRAS_90", "name": "TestArtist9", "is_sony": True}, {"id": 100, "external_id": "GRAS_100", "name": "TestArtist9", "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": 70, "type": "Artist"}, {"id": 80, "type": "Artist"}, {"id": 90, "type": "Artist"}, {"id": 100, "type": "Artist"}, ], "ArtistTeam": [ {"id": 1, "artist_id": 10, "label_id": 1}, {"id": 2, "artist_id": 20, "label_id": 1}, {"id": 3, "artist_id": 30, "label_id": 1}, {"id": 4, "artist_id": 40, "label_id": 2}, {"id": 5, "artist_id": 50, "label_id": 3}, {"id": 6, "artist_id": 60, "label_id": 3}, {"id": 8, "artist_id": 80, "label_id": 3}, {"id": 9, "artist_id": 90, "label_id": 3}, {"id": 10, "artist_id": 100, "label_id": 3}, ], "UserLabel": [ {"user_id": 1, "label_id": 1}, {"user_id": 2, "label_id": 1}, {"user_id": 4, "label_id": 1}, {"user_id": 2, "label_id": 2}, {"user_id": 2, "label_id": 3}, {"user_id": 1, "label_id": 3}, {"user_id": 1, "label_id": 4}, {"user_id": 4, "label_id": 3}, ], "ArtistTeamUser": [ { "artist_team_id": 1, "user_id": 1, "role": 1 }, { "artist_team_id": 8, "user_id": 1, "role": 1 }, { "artist_team_id": 4, "user_id": 2, "role": 1 }, { "artist_team_id": 5, "user_id": 2, "role": 1 }, { "artist_team_id": 6, "user_id": 3, "role": 1 }, { "artist_team_id": 2, "user_id": 1, "role": 1 }, { "artist_team_id": 1, "user_id": 4, "role": 1 }, ], "Project": [ { "id": 500, "name": "test_project_1", "label_id": 1, "budget": 66666, "allocation": 66666, "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, "is_deleted": False, "is_confidential": False, "initial_start_date": datetime.now() - timedelta(days=10), "end_date": datetime.now() + timedelta(days=10), "gras_title": "New Frontline Release", "gras_project_code": "12345567", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345567", "updated_by_import_at": "2020-10-11", }, { "id": 501, "name": "test_project_2", "label_id": 1, "budget": 66666, "allocation": 66666, "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_confidential": False, "is_claimed": True, "initial_start_date": datetime.now() + timedelta(days=10), "end_date": datetime.now() + timedelta(days=20), "gras_title": "New Frontline Release 2", "gras_project_code": "12345568", "prs_title": "New Frontline Release(PRS) 2", "prs_project_code": "012345568", "updated_by_import_at": "2020-10-11", }, { "id": 502, "name": "test_project_3", "label_id": 3, "budget": 66666, "allocation": 66666, "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_confidential": True, "is_claimed": True, "initial_start_date": datetime.now() - timedelta(days=10), "end_date": datetime.now() + timedelta(days=10), "gras_title": "New Frontline Release 3", "gras_project_code": "12345569", "prs_title": "New Frontline Release(PRS) 3", "prs_project_code": "012345569", "updated_by_import_at": "2020-10-11", }, { "id": 503, "name": "test_project_4", "label_id": 3, "budget": 66666, "allocation": 66666, "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_confidential": False, "is_claimed": True, "initial_start_date": datetime.now() + timedelta(days=10), "end_date": datetime.now() + timedelta(days=20), "gras_title": "New Frontline Release 4", "gras_project_code": "12345560", "prs_title": "New Frontline Release(PRS) 4", "prs_project_code": "012345560", "updated_by_import_at": "2020-10-11", }, { "id": 504, "name": "test_project_5", "label_id": 1, "budget": 66666, "allocation": 66666, "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_confidential": False, "is_claimed": True, "initial_start_date": datetime.now() - timedelta(days=40), "end_date": datetime.now() - timedelta(days=2), "gras_title": "New Frontline Release 4", "gras_project_code": "12345561", "prs_title": "New Frontline Release(PRS) 4", "prs_project_code": "012345561", "updated_by_import_at": "2020-10-11", }, { "id": 505, "name": "test_project_6", "label_id": 1, "budget": 66666, "allocation": 66666, "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_confidential": False, "is_claimed": False, "initial_start_date": datetime.now() - timedelta(days=40), "end_date": datetime.now() - timedelta(days=10), "gras_title": "New Frontline Release 4", "gras_project_code": "12345562", "prs_title": "New Frontline Release(PRS) 4", "prs_project_code": "012345562", "updated_by_import_at": "2020-10-11", }, { "id": 506, "name": "test_project_7", "label_id": 1, "budget": 66666, "allocation": 66666, "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_confidential": False, "is_claimed": True, "initial_start_date": datetime.now() - timedelta(days=60), "end_date": datetime.now() - timedelta(days=1), "gras_title": "New Frontline Release", "gras_project_code": "12345563", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345563", "updated_by_import_at": "2020-10-11", }, { "id": 507, "name": "test_project_8", "label_id": 1, "budget": 66666, "allocation": 66666, "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_confidential": True, "is_claimed": True, "initial_start_date": datetime.now() - timedelta(days=10), "end_date": datetime.now() + timedelta(days=10), "gras_title": "New Frontline Release", "gras_project_code": "12345564", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345564", "updated_by_import_at": "2020-10-11", }, { "id": 508, "name": "test_project_9", "label_id": 1, "budget": 66666, "allocation": 66666, "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_confidential": True, "is_claimed": True, "initial_start_date": datetime.now() - timedelta(days=10), "end_date": datetime.now() + timedelta(days=10), "gras_title": "New Frontline Release", "gras_project_code": "12345565", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345565", "updated_by_import_at": "2020-10-11", }, { "id": 509, "name": "test_project_10", "label_id": 3, "budget": 66666, "allocation": 66666, "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_confidential": True, "is_claimed": True, "initial_start_date": datetime.now() + timedelta(days=10), "end_date": datetime.now() + timedelta(days=20), "gras_title": "New Frontline Release", "gras_project_code": "12345565", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345566", "updated_by_import_at": "2020-10-11", }, { "id": 510, "name": "test_project_10", "label_id": 1, "budget": 66666, "allocation": 66666, "created_at": "2019-07-22 16:14:35.748032", "create_user_id": 3, "updated_at": "2019-07-22 16:14:55.446196", "edit_user_id": 1, "is_deleted": False, "is_confidential": False, "is_claimed": True, "initial_start_date": datetime.now() - timedelta(days=10), "end_date": datetime.now() + timedelta(days=10), "gras_title": "New Frontline Release", "gras_project_code": "12345535", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "01234535", "updated_by_import_at": "2020-10-11", }, { "id": 511, "name": "test_project_11", "label_id": 1, "budget": 66666, "allocation": 66666, "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_confidential": False, "is_claimed": False, "initial_start_date": datetime.now() - timedelta(days=20), "gras_title": "New Frontline Release", "gras_project_code": "12345563", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345563", "updated_by_import_at": "2020-10-11", }, { "id": 512, "name": "test_project_12", "label_id": 3, "budget": 66666, "allocation": 66666, "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_confidential": False, "is_claimed": True, "initial_start_date": datetime.now() - timedelta(days=20), "end_date": datetime.now() - timedelta(days=1), "gras_title": "New Frontline Release", "gras_project_code": "12345563", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345563", "updated_by_import_at": "2020-10-11", }, { "id": 513, "name": "test_project_13", "label_id": 3, "budget": 66666, "allocation": 66666, "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_confidential": False, "is_claimed": True, "initial_start_date": datetime.now() - timedelta(days=20), "end_date": datetime.now() - timedelta(days=1), "gras_title": "New Frontline Release", "gras_project_code": "12345563", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345563", "updated_by_import_at": "2020-10-11", }, { "id": 514, "name": "test_project_14", "label_id": 3, "budget": 66666, "allocation": 66666, "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_confidential": False, "is_claimed": True, "initial_start_date": datetime.now() - timedelta(days=20), "end_date": datetime.now() - timedelta(days=1), "gras_title": "New Frontline Release", "gras_project_code": "12345563", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345563", "updated_by_import_at": "2020-10-11", }, ], "MediaPlan": [ {"id": 42, "name": "Untitled", "project_id": 500, "order": 0}, {"id": 43, "name": "Untitled", "project_id": 501, "order": 0}, {"id": 44, "name": "Untitled", "project_id": 502, "order": 0}, {"id": 45, "name": "Untitled", "project_id": 503, "order": 0}, {"id": 46, "name": "Untitled", "project_id": 504, "order": 0}, {"id": 47, "name": "Untitled", "project_id": 505, "order": 0}, {"id": 48, "name": "Untitled", "project_id": 506, "order": 0}, {"id": 49, "name": "Untitled", "project_id": 507, "order": 0}, {"id": 499, "name": "Untitled", "project_id": 508, "order": 0}, {"id": 488, "name": "Untitled", "project_id": 509, "order": 0}, {"id": 477, "name": "Untitled10", "project_id": 510, "order": 0}, ], "MediaPlanPhase": [ {"name": "Phase For Test", "media_plan_id": 42, "order": 0}, {"name": "Phase For Test", "media_plan_id": 43, "order": 0}, {"name": "Phase For Test", "media_plan_id": 44, "order": 0}, {"name": "Phase For Test", "media_plan_id": 45, "order": 0}, {"name": "Phase For Test", "media_plan_id": 46, "order": 0}, {"name": "Phase For Test", "media_plan_id": 47, "order": 0}, {"name": "Phase For Test", "media_plan_id": 48, "order": 0}, {"name": "Phase For Test", "media_plan_id": 49, "order": 0}, {"name": "Phase For Test", "media_plan_id": 499, "order": 0}, {"name": "Phase For Test", "media_plan_id": 488, "order": 0}, {"name": "Phase For Test10", "media_plan_id": 477, "order": 0}, ], "ProjectTargetItem": [ {"project_id": 500, "entity_id": 10, "entity_type": 0, "add_type": 0}, {"project_id": 512, "entity_id": 80, "entity_type": 0, "add_type": 2}, {"project_id": 501, "entity_id": 30, "entity_type": 0, "add_type": 1}, {"project_id": 502, "entity_id": 50, "entity_type": 0, "add_type": 2}, {"project_id": 503, "entity_id": 60, "entity_type": 0, "add_type": 2}, {"project_id": 504, "entity_id": 20, "entity_type": 0, "add_type": 2}, {"project_id": 505, "entity_id": 20, "entity_type": 0, "add_type": 2}, {"project_id": 506, "entity_id": 10, "entity_type": 0, "add_type": 2}, {"project_id": 507, "entity_id": 10, "entity_type": 0, "add_type": 2}, {"project_id": 508, "entity_id": 10, "entity_type": 0, "add_type": 2}, {"project_id": 509, "entity_id": 50, "entity_type": 0, "add_type": 2}, {"project_id": 500, "entity_id": 70, "entity_type": 0, "add_type": 2}, {"project_id": 510, "entity_id": 70, "entity_type": 0, "add_type": 2}, {"project_id": 511, "entity_id": 20, "entity_type": 0, "add_type": 2}, {"project_id": 513, "entity_id": 90, "entity_type": 0, "add_type": 2}, {"project_id": 514, "entity_id": 100, "entity_type": 1}, ], "UserProject": [ {"project_id": 500, "user_id": 1, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 501, "user_id": 1, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 502, "user_id": 1, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 503, "user_id": 1, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 504, "user_id": 1, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 505, "user_id": 1, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 506, "user_id": 1, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 507, "user_id": 1, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 508, "user_id": 2, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 509, "user_id": 1, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 510, "user_id": 3, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 511, "user_id": 1, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 513, "user_id": 1, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 513, "user_id": 4, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 514, "user_id": 1, "shared_by": 1, "editable": False, "role": 2}, {"project_id": 514, "user_id": 4, "shared_by": 1, "editable": False, "role": 2}, ], "Image": [ {"id": 13, "url": "http://test.com", "width": 200, "height": 250, "related_object_id": 10}, {"id": 14, "url": "http://test.com/1", "width": 200, "height": 250, "related_object_id": 10}, {"id": 16, "url": "http://test.com/3", "width": 400, "height": 250, "related_object_id": 30}, {"id": 17, "url": "http://test.com/4", "width": 400, "height": 250, "related_object_id": 40}, {"id": 18, "url": "http://test.com/5", "width": 400, "height": 250, "related_object_id": 50}, {"id": 23, "url": "http://test.com", "width": 200, "height": 250, "related_object_id": 60}, {"id": 24, "url": "http://test.com/1", "width": 200, "height": 250, "related_object_id": 70}, {"id": 25, "url": "http://test.com/2", "width": 300, "height": 250, "related_object_id": 80}, ], }