from datetime import datetime, timedelta

from tests.root_fixture import root_fixture

fixture = {
    **root_fixture,
    "User": [
        {
            "id": 1,
            "email": "user-1@example.com",
            "external_id": "sme-dna|user-1",
            "updated_at": "2019-11-06 16:49:53.973942+02",
            "name": "user-1",
            "phone": "",
        },
        {
            "id": 2,
            "email": "user-2@example.com",
            "external_id": "sme-dna|user-2",
            "updated_at": "2020-11-06 16:49:53.973942+02",
            "name": "user-2",
            "is_admin": True,
            "phone": "",
        },
        {
            "id": 3,
            "email": "user-3@example.com",
            "external_id": "sme-dna|user-3",
            "updated_at": "2020-11-06 16:49:53.973942+02",
            "name": "user-3",
            "is_admin": True,
            "phone": "",
        },
        {
            "id": 42,
            "email": "mulinette@universe.galaxy",
            "external_id": "sme-dna|mulinette",
            "updated_at": "2020-11-06 16:49:53.973942+02",
            "name": "Moulinette",
            "phone": "",
        },
        {
            "id": 43,
            "email": "43@universe.galaxy",
            "is_admin": True,
            "external_id": "sme-dna|universe",
            "updated_at": "2020-11-06 16:49:53.973942+02",
            "name": "WUniverse",
            "phone": "",
        }
    ],
    "CampaignTypeWidget": [
        {"id": 1, "name": "select"},
        {"id": 2, "name": "multi-select"},
        {"id": 3, "name": "checkbox"},
        {"id": 4, "name": "toggle"},
        {"id": 5, "name": "text"},
        {"id": 6, "name": "city"},
        {"id": 7, "name": "city and placements"},
    ],
    "CampaignTypeCity": [{"id": 100, "name": "New York"}],
    "TerritoryType": [{"id": 1, "name": "Global type"}],
    "Territory": [
        {"id": 100, "name": "USA", "code": "USA", "territory_type_id": 1},
        {"id": 101, "name": "Canada", "code": "CA", "territory_type_id": 1},
    ],
    "MediaPlan": [
        {
            "id": 42,
            "name": "Untitled",
            "order": 0,
            "project_id": 500
        }
    ],
    "MediaPlanPhase": [{"id": 100, "name": "Phase For Test", "media_plan_id": 42, "order": 1}],
    "Project": [
        {
            "id": 500,
            "name": "test_project_1",
            "label_id": 5,
            "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_claimed": True,
            "end_date": datetime.strftime(datetime.now() + timedelta(days=200), "%Y-%m-%d"),
            "is_confidential": False,
            "budget": 66666,
            "allocation": 66666,
            "initial_start_date": "2022-10-11",
            "gras_title": "New Frontline Release",
            "gras_project_code": "12345517",
            "prs_title": "New Frontline Release(PRS)",
            "prs_project_code": "012345517",
            "updated_by_import_at": "2020-10-11",
        },
        {
            "id": 501,
            "name": "test_project_2",
            "label_id": 5,
            "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_claimed": True,
            "end_date": datetime.strftime(datetime.now() + timedelta(days=200), "%Y-%m-%d"),
            "is_confidential": False,
            "budget": 66666,
            "allocation": 66666,
            "initial_start_date": "2022-10-11",
            "gras_title": "New Frontline Release",
            "gras_project_code": "12345517",
            "prs_title": "New Frontline Release(PRS)",
            "prs_project_code": "501501501",
            "updated_by_import_at": "2020-10-11",
        }
    ],
    "ProjectTargetItem": [
        {"project_id": 500, "entity_id": 70, "entity_type": 0},
        {"project_id": 501, "entity_id": 70, "entity_type": 0},
    ],
    "Label": [
        {
            "id": 1,
            "name": "Columbia Records",
            "rep_owner_key": "123456",
            "external_name": "Columbia Records",
            "child_rep_owner_keys": "{}",
            "abbreviation": "CLMBRCRDS",
            "country": "USA",
        },
        {
            "id": 2,
            "name": "Epic Records",
            "rep_owner_key": "223456",
            "external_name": "Epic Records",
            "child_rep_owner_keys": "{}",
            "abbreviation": "PCRCRDS",
            "country": "USA",
        },
        {
            "id": 3,
            "name": "RCA Records",
            "rep_owner_key": "323456",
            "external_name": "RCA Records",
            "child_rep_owner_keys": "{}",
            "abbreviation": "RCRCRDS",
            "country": "USA",
        },
        {
            "id": 4,
            "name": "CMG",
            "rep_owner_key": "423456",
            "external_name": "CMG",
            "child_rep_owner_keys": "{}",
            "abbreviation": "CMG",
            "country": "USA",
        },
        {
            "id": 5,
            "name": "Nashville",
            "rep_owner_key": "523456",
            "external_name": "Nashville",
            "child_rep_owner_keys": "{}",
            "abbreviation": "NSHVLL",
            "country": "USA",
        },
    ],
    "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": 2, "label_id": 1},
        {"user_id": 2, "label_id": 2},
        {"user_id": 2, "label_id": 3},
        {"user_id": 2, "label_id": 4},
        {"user_id": 2, "label_id": 5},
        {"user_id": 42, "label_id": 5},
    ],
    "RecordType": [{"id": 1, "name": "Album"}, {"id": 2, "name": "Track"}, {"id": 3, "name": "Playlist"}],
    "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"}],
    "Artist": [
        {"id": 10, "external_id": "GRAS_124121", "name": "mOZart", "is_sony": True},
        {"id": 20, "external_id": "GRAS_124122", "name": "Kalush", "is_sony": True},
        {"id": 30, "external_id": "GRAS_124123", "name": "Anna Berbok", "is_sony": True},
        {"id": 40, "external_id": "GRAS_124124", "name": "TestArtist4", "is_sony": True},
        {"id": 50, "external_id": "GRAS_124125", "name": "YaYTestArtist5", "is_sony": True},
        {"id": 60, "external_id": "GRAS_124126", "name": "AAATestArtist6", "is_sony": True},
        {"id": 70, "external_id": "GRAS_707070", "name": "artist_70", "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"},
    ],
    "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": 7, "artist_id": 20, "label_id": 4},
        {"id": 8, "artist_id": 70, "label_id": 5},
    ],
    "ArtistTeamUser": [
        {
            "artist_team_id": 6,
            "user_id": 2,
            "role": 1
        },
        {
            "artist_team_id": 1,
            "user_id": 1,
            "role": 1
        },
        {
            "artist_team_id": 1,
            "user_id": 43,
            "role": 1
        },
        {
            "artist_team_id": 4,
            "user_id": 1,
            "role": 1
        },
        {
            "artist_team_id": 5,
            "user_id": 1,
            "role": 1
        },
        {
            "artist_team_id": 6,
            "user_id": 1,
            "role": 1
        },
        {
            "artist_team_id": 7,
            "user_id": 1,
            "role": 1
        },
        {
            "artist_team_id": 8,
            "user_id": 1,
            "role": 1
        }
    ],
    "UserProject": [
        {"project_id": 500, "user_id": 1, "shared_by": 1, "editable": False, "role": 1},
    ],
}