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",
        },
    ],
    "UserProject": [
        {"project_id": 500, "user_id": 1, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 501, "user_id": 1, "shared_by": 2, "editable": True, "role": 1},
        {"project_id": 501, "user_id": 2, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 502, "user_id": 3, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 502, "user_id": 1, "shared_by": 3, "editable": True, "role": 1},
        {"project_id": 503, "user_id": 1, "shared_by": 4, "editable": True, "role": 3, "id": 100},
        {"project_id": 503, "user_id": 4, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 504, "user_id": 1, "shared_by": 5, "editable": True, "role": 3},
        {"project_id": 504, "user_id": 5, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 505, "user_id": 1, "shared_by": 5, "editable": True, "role": 1},
        {"project_id": 505, "user_id": 5, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 506, "user_id": 2, "shared_by": 5, "editable": True, "role": 1},
        {"project_id": 506, "user_id": 5, "shared_by": 1, "editable": False, "role": 1},
    ],
    "UserProjectCampaignTypeGroup": [{"user_project_id": 100, "campaign_type_group_id": 1}],
    "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_500",
            "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:10:55.446196",
            "edit_user_id": 1,
            "gras_project_code": "GRAS_1031",
            "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": "2020-02-03",
            "budget": 31402.41,
            "allocation": 12000.0,
            "prs_project_code": 2974115,
        },
        {
            "id": 501,
            "name": "test_project_501",
            "label_id": 4,
            "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": 2,
            "is_deleted": True,
            "gras_project_code": "GRAS_1032",
            "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": "2020-02-03",
            "budget": 31402.41,
            "allocation": 12000.0,
            "prs_project_code": 2972315,
        },
        {
            "id": 502,
            "name": "test_project_502",
            "label_id": 4,
            "is_claimed": True,
            "end_date": "2020-10-11",
            "created_at": "2019-07-22 16:14:35.748032",
            "create_user_id": 3,
            "updated_at": "2019-07-22 16:15:55.446196",
            "edit_user_id": 3,
            "notes": "Some notes",
            "gras_project_code": "GRAS_1033",
            "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": "2020-02-03",
            "budget": 31402.41,
            "allocation": 12000.0,
            "prs_project_code": 29721565,
        },
        {
            "id": 503,
            "name": "test_project_503",
            "label_id": 4,
            "is_claimed": True,
            "end_date": "2020-10-11",
            "created_at": "2019-07-22 16:14:35.748032",
            "create_user_id": 4,
            "updated_at": "2019-07-22 16:14:55.446196",
            "edit_user_id": 4,
            "gras_project_code": "GRAS_1034",
            "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": "2020-02-03",
            "budget": 31402.41,
            "allocation": 12000.0,
            "prs_project_code": 2974615,
        },
        {
            "id": 504,
            "name": "test_project_504",
            "label_id": 4,
            "is_claimed": True,
            "end_date": "2020-10-11",
            "created_at": "2019-07-24 16:14:35.748032",
            "create_user_id": 5,
            "updated_at": "2019-07-24 17:14:55.446196",
            "edit_user_id": 5,
            "gras_project_code": "GRAS_1035",
            "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": "2020-02-03",
            "budget": 31402.41,
            "allocation": 12000.0,
            "prs_project_code": 29715532,
        },
        {
            "id": 505,
            "name": "test_project_505",
            "label_id": 4,
            "is_claimed": True,
            "end_date": "2020-10-11",
            "created_at": "2019-07-24 16:14:35.748032",
            "create_user_id": 5,
            "updated_at": "2019-07-24 16:14:55.446196",
            "edit_user_id": 5,
            "gras_project_code": "GRAS_1036",
            "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": "2020-02-03",
            "budget": 31402.41,
            "allocation": 12000.0,
            "prs_project_code": 2971512,
        },
        {
            "id": 506,
            "name": "test_project_505",
            "label_id": 4,
            "is_claimed": True,
            "end_date": "2020-10-11",
            "created_at": "2019-08-24 16:14:35.748032",
            "create_user_id": 5,
            "updated_at": "2019-08-24 16:14:55.446196",
            "edit_user_id": 5,
            "gras_project_code": "GRAS_1073",
            "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": "2020-02-03",
            "budget": 31402.41,
            "allocation": 12000.0,
            "prs_project_code": 1221124124,
        },
    ],
    "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": 3, "label_id": 4},
        {"user_id": 5, "label_id": 4},
    ],
    "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},
        {"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": 50, "entity_type": 0},
        {"project_id": 504, "entity_id": 10, "entity_type": 0},
        {"project_id": 505, "entity_id": 30, "entity_type": 0},
        {"project_id": 506, "entity_id": 130, "entity_type": 3},
    ],
    "Artist": [
        {"id": 10, "external_id": "GRAS_1234211", "name": "TestAtrist", "is_sony": True},
        {"id": 20, "external_id": "GRAS_1234212", "name": "TestingUpdate", "is_sony": True},
        {"id": 30, "external_id": "GRAS_1234213", "name": "artist2", "is_sony": True},
        {"id": 40, "external_id": "GRAS_1234214", "name": "artist01", "is_sony": True},
        {"id": 50, "external_id": "GRAS_1234215", "name": "UpdateArtist", "is_sony": True},
        {"id": 60, "external_id": "GRAS_1234216", "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": 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"},
    ],
    "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"},
    ],
    "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,
            "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,
            "provider_id": 1,
            "age_range": "(0, 60)",
            "objective_id": 2,
        },
        {
            "id": 2,
            "uuid": "aa1490b5-832c-4852-9d28-7a96884ff399",
            "name": "test_campaign_2",
            "project_id": 500,
            "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,
            "provider_id": 1,
            "age_range": "(0, 60)",
            "objective_id": 1,
        },
        {
            "id": 3,
            "uuid": "c40fe4e8-58ce-4ba6-ab10-4932e685a389",
            "name": "test_deleted_campaign_3",
            "project_id": 501,
            "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,
            "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,
            "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,
            "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,
            "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,
            "provider_id": 1,
            "age_range": "(0, 60)",
            "objective_id": 2,
        },
    ],
    "CampaignTerritory": [{"campaign_id": 5, "territory_id": 1, "budget_spend": 5000}],
    "ProjectHistoryItem": [
        {"project_id": 500, "created_at": "2019-01-01 00:00:00", "user_id": 1, "action_id": 14},
        {
            "project_id": 500,
            "created_at": "2020-05-11 12:30:00",
            "user_id": 1,
            "action_id": 17,
            "old_value": {"value": "Test Project 1"},
            "new_value": {"value": "JP Saxe"},
        },
        {
            "project_id": 500,
            "created_at": "2020-05-11 12:31:00",
            "user_id": 1,
            "action_id": 16,
            "old_value": {"value": ""},
            "new_value": {"value": "<p>HELLO KITTY</p>"},
        },
        {"project_id": 500, "created_at": "2020-05-11 12:35:00", "user_id": 2, "action_id": 14},
        {
            "project_id": 500,
            "created_at": "2020-05-11 12:49:00",
            "user_id": 3,
            "action_id": 19,
            "new_value": '[{"id": 1415, "name": "Luiggi Berrios"}]',
        },
        {"project_id": 501, "created_at": "2020-01-01 00:00:01", "user_id": 2, "action_id": 14},
        {
            "project_id": 501,
            "created_at": "2020-06-11 17:20:01",
            "user_id": 2,
            "action_id": 1,
            "new_value": {"value": 10000},
        },
        {"project_id": 502, "created_at": "2020-01-01 00:00:02", "user_id": 3, "action_id": 14},
        {
            "project_id": 502,
            "created_at": "2020-04-12 07:10:31",
            "user_id": 3,
            "action_id": 1,
            "new_value": {"value": 12000},
        },
        {"project_id": 503, "created_at": "2020-01-01 00:01:02", "user_id": 4, "action_id": 14},
        {
            "project_id": 503,
            "created_at": "2020-06-11 17:20:01",
            "user_id": 4,
            "action_id": 1,
            "new_value": {"value": 10000},
        },
        {"project_id": 504, "created_at": "2020-01-01 00:02:02", "user_id": 5, "action_id": 14},
        {
            "project_id": 504,
            "created_at": "2020-05-31 11:31:12",
            "user_id": 5,
            "action_id": 17,
            "old_value": {"value": "Doge Lore"},
            "new_value": {"value": "Pepe the Frog"},
        },
        {"project_id": 505, "created_at": "2020-01-01 00:03:02", "user_id": 5, "action_id": 14},
        {"project_id": 506, "created_at": "2020-06-15 10:20:11", "user_id": 5, "action_id": 14},
    ],
    "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},
    ],
}