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": "user-1", "is_admin": True, "phone": "+1234234", }, { "id": 2, "email": "dev-marketing-user-2@example.com", "external_id": "sme-dna|5cf0091d6c91d310fe6fcdc7", "name": "user-2", "phone": "", }, { "id": 3, "email": "dev-marketing-user-3@example.com", "external_id": "sme-dna|5cf0091f6c91d310fe6fcdc6", "name": "user-3", "phone": "", }, { "id": 4, "email": "dev-marketing-user-4@example.com", "external_id": "sme-dna|5cf0091f6c91d310fe6fcdc7", "name": "user-4", "phone": "", }, { "id": 5, "email": "dev-marketing-user-5@example.com", "external_id": "sme-dna|5cf0091f6c91d310fe6fcdc8", "name": "user-5", "phone": "", }, ], "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_deleted": False, "is_confidential": False, "is_claimed": True, "initial_start_date": "2007-01-01", "end_date": "2022-10-11", "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_1", "label_id": 3, "budget": 11111, "allocation": 11111, "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_confidential": False, "is_claimed": True, "initial_start_date": "2009-02-02", "end_date": "2021-11-11", "gras_title": "New Frontline Release", "gras_project_code": "12345568", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345568", "updated_by_import_at": "2020-10-11", }, { "id": 502, "name": "test_project_2", "label_id": 2, "budget": 123466, "allocation": 123466, "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, "is_confidential": False, "is_claimed": True, "initial_start_date": "2015-02-02", "end_date": "2021-10-11", "gras_title": "New Frontline Release", "gras_project_code": "12345569", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345569", "updated_by_import_at": "2020-10-11", }, { "id": 503, "name": "test_project_gras_1", "label_id": 1, "budget": 2222, "allocation": 2222, "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_confidential": False, "is_claimed": True, "initial_start_date": "2015-02-02", "end_date": "2021-10-11", "gras_title": "New Frontline Release", "gras_project_code": "12345570", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345570", "updated_by_import_at": "2020-10-11", }, { "id": 504, "name": "test_project_504", "label_id": 3, "budget": 1000, "allocation": 1000, "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_confidential": False, "is_claimed": True, "initial_start_date": "2016-02-02", "end_date": "2021-10-11", "gras_title": "New Frontline Release", "gras_project_code": "12345571", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345571", "updated_by_import_at": "2020-10-11", }, { "id": 505, "name": "test_project_505", "label_id": 1, "budget": 1000, "allocation": 1000, "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_confidential": False, "is_claimed": True, "initial_start_date": "2016-02-02", "end_date": "2021-10-11", "gras_title": "New Frontline Release", "gras_project_code": "12345572", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345572", "updated_by_import_at": "2020-10-11", }, { "id": 506, "name": "test_project_confidential_506", "label_id": 2, "budget": 1000, "allocation": 1000, "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_confidential": True, "is_claimed": True, "initial_start_date": "2016-02-02", "end_date": "2021-10-11", "gras_title": "New Frontline Release", "gras_project_code": "12345572", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345572", "updated_by_import_at": "2020-10-11", }, ], "UserLabel": [ {"user_id": 1, "label_id": 1}, {"user_id": 2, "label_id": 3}, {"user_id": 3, "label_id": 1}, {"user_id": 4, "label_id": 1}, {"user_id": 1, "label_id": 2}, {"user_id": 1, "label_id": 3}, {"user_id": 1, "label_id": 4}, {"user_id": 2, "label_id": 1}, {"user_id": 3, "label_id": 2}, ], "ProjectTargetItem": [ {"project_id": 500, "entity_id": 10, "entity_type": 0, "add_type": 2}, {"project_id": 500, "entity_id": 20, "entity_type": 0}, {"project_id": 500, "entity_id": 30, "entity_type": 1}, {"project_id": 501, "entity_id": 10, "entity_type": 0}, {"project_id": 502, "entity_id": 10, "entity_type": 0, "add_type": 2}, {"project_id": 506, "entity_id": 40, "entity_type": 0, "add_type": 2}, {"project_id": 503, "entity_id": 10, "entity_type": 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": "HBO", "rep_owner_key": "522456", "external_name": "HBO", "child_rep_owner_keys": "{}"}, ], "ArtistTeam": [ {"artist_id": 10, "label_id": 1}, {"artist_id": 10, "label_id": 3}, {"artist_id": 40, "label_id": 2}, ], "ArtistTeamUser": [ { "artist_team_id": 1, "user_id": 1, "role": 1, }, { "artist_team_id": 1, "user_id": 3, "role": 1, }, { "artist_team_id": 1, "user_id": 4, "role": 3, }, {"artist_team_id": 2, "user_id": 1, "role": 1}, ], "UserProject": [ {"project_id": 500, "user_id": 1, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 501, "user_id": 2, "shared_by": 1, "editable": False, "role": 1}, {"project_id": 501, "user_id": 1, "shared_by": 2, "editable": False, "role": 3}, {"project_id": 502, "user_id": 1, "shared_by": 1, "editable": False, "role": 1}, {"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": 506, "user_id": 3, "shared_by": 1, "editable": False, "role": 1}, ], "ArtistLevel": [{"id": 1, "name": "New"}], "Contact": [{"id": 1, "name": "TestContactName", "email": "test@gmail.com", "phone": "+2141111111"}], "Currency": [{"id": 1, "name": "United States Dollar", "code": "USD"}], "Artist": [ {"id": 10, "external_id": "GRAS_10", "name": "TestAtrist", "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}, ], "Polymorphable": [ {"id": 10, "type": "Artist"}, {"id": 20, "type": "Artist"}, {"id": 30, "type": "Artist"}, {"id": 40, "type": "Artist"}, {"id": 110, "type": "Playlist"}, {"id": 120, "type": "Playlist"}, ], "Playlist": [ {"id": 110, "external_id": "05", "name": "Playlist1", "owner_name": "Owner1", "provider": "apple"}, {"id": 120, "external_id": "06", "name": "Playlist2", "owner_name": "Owner2", "provider": "spotify"}, ], "Image": [{"id": 100, "url": "www.test.image.com", "width": 100, "height": 200, "related_object_id": 20}], "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}, {"id": 47, "name": "Untitled For Test", "project_id": 505, "order": 0}, ], "MediaPlanPhase": [ {"id": 450, "media_plan_id": 42, "name": "Phase For Test", "order": 0}, {"id": 550, "media_plan_id": 43, "name": "Phase For Test [Empty]", "order": 0}, {"id": 555, "media_plan_id": 44, "name": "Phase For Test [All Deleted]", "order": 0}, {"id": 780, "media_plan_id": 45, "name": "Phase 1", "order": 0}, {"id": 781, "media_plan_id": 46, "name": "Phase 2", "order": 0}, {"id": 782, "media_plan_id": 47, "name": "Phase 1", "order": 0}, ], "TerritoryType": [{"id": 1, "name": "Global type"}], "Territory": [ {"id": 1, "name": "USA", "code": "USA", "territory_type_id": 1}, {"id": 2, "name": "Ukraine", "code": "UA", "territory_type_id": 1}, ], "ArtistMomentTerritory": [ {"artist_moment_id": 100, "territory_id": 1}, {"artist_moment_id": 101, "territory_id": 2}, {"artist_moment_id": 102, "territory_id": 2}, {"artist_moment_id": 103, "territory_id": 2}, {"artist_moment_id": 104, "territory_id": 2}, {"artist_moment_id": 105, "territory_id": 2}, ], "ArtistMoment": [ { "id": 100, "name": "Dilsinho New Release", "artist_id": 10, "project_id": 500, "date": "2021-01-05", "link": "www.dilsinho.com", "notes": "some notes", "type_id": 10, "created_at": "2021-01-11 13:10:18.065395", "updated_at": "2021-01-11 13:10:18.065395", "create_user_id": 1, "edit_user_id": 1, "metainfo": { "fields": { "name": True, "date": True, "artist": True, "territories": True, "link": True, "notes": True, "type": True, "category": True, } }, }, { "id": 101, "name": "Just New Release", "artist_id": 20, "date": "2021-01-06", "category_id": 4, "created_at": "2021-01-11 13:10:18.065395", "updated_at": "2021-01-11 13:10:18.065395", "create_user_id": 2, "edit_user_id": 2, "metainfo": { "fields": { "name": True, "date": True, "artist": True, "territories": True, "link": True, "notes": True, "type": True, "category": True, } }, }, { "id": 102, "name": "Just New Release 2", "artist_id": 30, "date": "2021-02-05", "type_id": 1, "created_at": "2021-01-11 13:10:18.065395", "updated_at": "2021-01-11 13:10:18.065395", "create_user_id": 2, "edit_user_id": 2, "metainfo": { "fields": { "name": True, "date": True, "artist": True, "territories": True, "link": True, "notes": True, "type": True, "category": True, } }, }, { "id": 103, "name": "Just New Release 103", "artist_id": 40, "date": "2021-02-05", "type_id": 1, "created_at": "2021-01-11 13:10:18.065395", "updated_at": "2021-01-11 13:10:18.065395", "create_user_id": 2, "edit_user_id": 2, "metainfo": { "fields": { "name": False, "date": True, "artist": True, "territories": True, "link": True, "notes": True, "type": True, "category": True, } }, }, { "id": 104, "name": "Just New Release 104", "artist_id": 40, "date": "2021-02-05", "type_id": 1, "created_at": "2021-01-11 13:10:18.065395", "updated_at": "2021-01-11 13:10:18.065395", "create_user_id": 2, "edit_user_id": 2, "metainfo": { "fields": { "name": True, "date": False, "artist": True, "territories": True, "link": True, "notes": True, "type": True, "category": True, } }, }, { "id": 105, "name": "Just New Release 105", "artist_id": 40, "date": "2021-02-05", "type_id": 1, "created_at": "2021-01-11 13:10:18.065395", "updated_at": "2021-01-11 13:10:18.065395", "create_user_id": 2, "edit_user_id": 2, "metainfo": { "fields": { "name": True, "date": True, "artist": False, "territories": True, "link": True, "notes": True, "type": True, "category": True, } }, }, { "id": 106, "name": "Just New Release 106", "artist_id": 40, "date": "2021-02-05", "type_id": 1, "created_at": "2021-01-11 13:10:18.065395", "updated_at": "2021-01-11 13:10:18.065395", "create_user_id": 2, "edit_user_id": 2, "metainfo": { "fields": { "name": True, "date": True, "artist": True, "territories": False, "link": True, "notes": True, "type": True, "category": True, } }, }, ], }