from tests.root_fixture import root_fixture
from datetime import timedelta, datetime

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",
        },
        {
            "id": 6,
            "email": "dev-marketing-user-6@example.com",
            "external_id": "sme-dna|phn0091d6cuhjp30fe6opttml",
            "name": "dev-marketing-user-5",
            "phone": "09179947668",
        },
    ],
    "UserProject": [
        {"project_id": 500, "user_id": 1, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 500, "user_id": 2, "shared_by": 1, "editable": True, "role": 1},
        {"project_id": 500, "user_id": 3, "shared_by": 1, "editable": True, "role": 1, "id": 100},
        {"project_id": 500, "user_id": 5, "shared_by": 1, "editable": False, "role": 4},
        {"project_id": 500, "user_id": 5, "shared_by": 1, "editable": False, "role": 3},
        {"project_id": 501, "user_id": 1, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 502, "user_id": 1, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 502, "user_id": 5, "shared_by": 1, "editable": False, "role": 4},
        {"project_id": 542, "user_id": 5, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 542, "user_id": 5, "shared_by": 5, "editable": False, "role": 4},
        {"project_id": 543, "user_id": 1, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 543, "user_id": 5, "shared_by": 1, "editable": False, "role": 4},
        {"project_id": 600, "user_id": 1, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 600, "user_id": 5, "shared_by": 1, "editable": False, "role": 4},
        {"project_id": 700, "user_id": 1, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 700, "user_id": 5, "shared_by": 1, "editable": False, "role": 4}
    ],
    "UserProjectCampaignTypeGroup": [{"user_project_id": 100, "campaign_type_group_id": 1}],
    "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"}],
    "Project": [
        {
            "id": 500,
            "name": "test_project_1",
            "label_id": 1,
            "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:14:55.446196",
            "edit_user_id": 1,
            "is_confidential": False,
            "budget": 500,
            "allocation": 500,
            "initial_start_date": "2007-02-02",
            "gras_title": "New Frontline Release ++",
            "gras_project_code": "1232456",
            "prs_title": "New Frontline Release(PRS)",
            "prs_project_code": "012345512",
            "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",
            "create_user_id": 1,
            "updated_at": "2019-07-22 16:14:55.446196",
            "edit_user_id": 1,
            "is_deleted": True,
            "is_confidential": False,
            "budget": 5700,
            "allocation": 5700,
            "initial_start_date": "2007-02-02",
            "gras_title": "New Frontline Release ++",
            "gras_project_code": "1232457",
            "prs_title": "New Frontline Release(PRS)",
            "prs_project_code": "012345513",
            "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",
            "create_user_id": 1,
            "updated_at": "2019-07-22 16:14:55.446196",
            "edit_user_id": 1,
            "is_confidential": False,
            "budget": 1500,
            "allocation": 1500,
            "initial_start_date": "2007-02-02",
            "gras_title": "New Frontline Release ++",
            "gras_project_code": "123245611",
            "prs_title": "New Frontline Release(PRS)",
            "prs_project_code": "012345514",
            "updated_by_import_at": "2020-10-11",
        },
        {
            "id": 542,
            "name": "test_project_542",
            "label_id": 3,
            "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:14:55.446196",
            "edit_user_id": 1,
            "is_confidential": False,
            "budget": 42,
            "allocation": 42,
            "initial_start_date": "1997-02-02",
            "gras_title": "New Frontline Release ++42",
            "gras_project_code": "123245611",
            "prs_title": "New Frontline Release(PRS)",
            "prs_project_code": "012345514",
            "updated_by_import_at": "2020-10-11",
        },
        {
            "id": 543,
            "name": "test_project_543",
            "label_id": 3,
            "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:14:55.446196",
            "edit_user_id": 1,
            "is_confidential": False,
            "budget": 420,
            "allocation": 420,
            "initial_start_date": "1997-02-02",
            "gras_title": "New Frontline Release ++42",
            "gras_project_code": "123245611",
            "prs_title": "New Frontline Release(PRS)",
            "prs_project_code": "012345514",
            "updated_by_import_at": "2020-10-11",
        },
        {
            "id": 600,
            "name": "test_project_600",
            "label_id": 1,
            "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:14:55.446196",
            "edit_user_id": 1,
            "is_confidential": False,
            "budget": 600,
            "allocation": 600,
            "initial_start_date": "2007-02-02",
            "gras_title": "New Frontline Release ++",
            "gras_project_code": "1232456",
            "prs_title": "New Frontline Release(PRS)",
            "prs_project_code": "012345512",
            "updated_by_import_at": "2020-09-11",
        },
        {
            "id": 700,
            "name": "test_project_600",
            "label_id": 1,
            "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:14:55.446196",
            "edit_user_id": 1,
            "is_confidential": False,
            "budget": 600,
            "allocation": 600,
            "initial_start_date": "2007-02-02",
            "gras_title": "New Frontline Release ++",
            "gras_project_code": "1232456",
            "prs_title": "New Frontline Release(PRS)",
            "prs_project_code": "012345512",
            "updated_by_import_at": "2020-09-11",
        },
    ],
    "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": "{}",
        },
    ],
    "UserLabel": [
        {"user_id": 1, "label_id": 1},
        {"user_id": 1, "label_id": 3},
        {"user_id": 4, "label_id": 1},
        {"user_id": 5, "label_id": 3}
    ],
    "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": "Ukraine1", "code": "UA1", "territory_type_id": 1},
    ],
    "CampaignTerritory": [
        {"campaign_id": 100, "territory_id": 1, "budget_spend": 5000},
        {"campaign_id": 200, "territory_id": 2, "budget_spend": 5000},
        {"campaign_id": 300, "territory_id": 1, "budget_spend": 5000},
        {"campaign_id": 400, "territory_id": 1, "budget_spend": 5000},
    ],
    "ProjectTargetItem": [
        {"project_id": 500, "entity_id": 10, "entity_type": 0},
        {"project_id": 500, "entity_id": 20, "entity_type": 0},
        {"project_id": 501, "entity_id": 30, "entity_type": 0},
        {"project_id": 502, "entity_id": 70, "entity_type": 3},
        {"project_id": 542, "entity_id": 10, "entity_type": 0, "add_type": 2},
        {"project_id": 543, "entity_id": 10, "entity_type": 0, "add_type": 2},
        {"project_id": 600, "entity_id": 10, "entity_type": 0, "add_type": 2},
        {"project_id": 700, "entity_id": 10, "entity_type": 0},
    ],
    "Artist": [
        {"id": 10, "external_id": "GRAS_1245112", "name": "TestAtrist", "is_sony": True},
        {"id": 20, "external_id": "GRAS_1245114", "name": "TestingUpdate", "is_sony": True},
        {"id": 30, "external_id": "GRAS_1245115", "name": "artist2", "is_sony": True},
    ],
    "ArtistTeam": [
        {"id": 10, "artist_id": 10, "label_id": 1},
    ],
    "ArtistTeamUser": [
        {"artist_team_id": 10, "user_id": 5, "role": 1}
    ],
    "Polymorphable": [
        {"id": 10, "type": "Artist"},
        {"id": 20, "type": "Artist"},
        {"id": 30, "type": "Artist"},
        {"id": 70, "type": "Playlist"},
    ],
    "Playlist": [{"id": 70, "external_id": "01", "name": "TestAtrist", "owner_name": "Owner1", "provider": "spotify"}],
    "Image": [],
    "Campaign": [
        {
            "id": 100,
            "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,
            "is_deleted": False,
            "provider_id": 1,
            "age_range": "(0, 60)",
            "objective_id": 2,
            "metainfo": {
                "fields": {
                    "budget": True,
                    "spend": True,
                    "startDate": True,
                    "endDate": True,
                    "genders": True,
                    "audienceAge": True,
                    "countries": True,
                    "destinations": True,
                    "notes": True,
                }
            },
        },
        {
            "id": 200,
            "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,
            "is_deleted": False,
            "provider_id": 1,
            "age_range": "(0, 60)",
            "objective_id": 1,
            "metainfo": {
                "fields": {
                    "budget": True,
                    "spend": True,
                    "startDate": True,
                    "endDate": True,
                    "genders": True,
                    "audienceAge": True,
                    "countries": True,
                    "destinations": True,
                    "notes": True,
                }
            },
        },
        {
            "id": 300,
            "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,
            "is_deleted": True,
            "provider_id": 1,
            "age_range": "(0, 60)",
            "objective_id": 2,
            "metainfo": {
                "fields": {
                    "budget": True,
                    "spend": True,
                    "startDate": True,
                    "endDate": True,
                    "genders": True,
                    "audienceAge": True,
                    "countries": True,
                    "destinations": True,
                    "notes": True,
                }
            },
        },
        {
            "id": 400,
            "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,
            "is_deleted": False,
            "provider_id": 1,
            "age_range": "(0, 60)",
            "objective_id": 2,
            "metainfo": {
                "fields": {
                    "budget": True,
                    "spend": True,
                    "startDate": True,
                    "endDate": True,
                    "genders": True,
                    "audienceAge": True,
                    "countries": True,
                    "destinations": True,
                    "notes": True,
                }
            },
        },
        {
            "id": 500,
            "uuid": "55e87545-a3b3-4bd1-9357-a5373df46270",
            "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,
            "is_deleted": False,
            "provider_id": 1,
            "age_range": "(0, 60)",
            "objective_id": 2,
            "metainfo": {
                "fields": {
                    "budget": True,
                    "spend": True,
                    "startDate": True,
                    "endDate": True,
                    "genders": True,
                    "audienceAge": True,
                    "countries": True,
                    "destinations": True,
                    "notes": True,
                }
            },
        },
    ],
    "ArtistLevel": [{"id": 1, "name": "New"}, {"id": 2, "name": "Developing"}, {"id": 3, "name": "Established"}],
    "Contact": [{"id": 1, "name": "TestContactName", "email": "test@gmail.com", "phone": "+2141111111"}],
    "Currency": [{"id": 1, "name": "United States Dollar", "code": "USD"}, {"id": 2, "name": "Hryvnya", "code": "UAH"}],
    "Genre": [
        {"id": 1, "name": "2-step"},
        {"id": 2, "name": "20s"},
        {"id": 3, "name": "30s"},
        {"id": 4, "name": "40s"},
        {"id": 5, "name": "4x4"},
        {"id": 6, "name": "50s"},
        {"id": 7, "name": "60s"},
        {"id": 8, "name": "70s"},
        {"id": 9, "name": "80s"},
        {"id": 10, "name": "90s"},
        {"id": 11, "name": "A Capella"},
        {"id": 12, "name": "Acid"},
        {"id": 13, "name": "Acid Jazz"},
        {"id": 14, "name": "Acoustic"},
        {"id": 15, "name": "Adult Contemporary"},
        {"id": 16, "name": "African"},
        {"id": 17, "name": "Afro-Cuban"},
        {"id": 18, "name": "Afrobeat"},
        {"id": 19, "name": "Algerian"},
    ],
    "MediaPlanPhaseCampaign": [
        {"phase_id": 450, "campaign_id": 100},
        {"phase_id": 560, "campaign_id": 100},
        {"phase_id": 560, "campaign_id": 200},
        {"phase_id": 555, "campaign_id": 300},
        {"phase_id": 555, "campaign_id": 400},
    ],
    "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},
    ],
    "MediaPlanPhase": [
        {"id": 450, "name": "Phase For Test", "media_plan_id": 42, "order": 1},
        {
            "id": 560,
            "name": "Phase For Test with Asset",
            "media_plan_id": 42,
            "order": 2,
        },
        {"id": 550, "name": "Phase For Test [Empty]", "media_plan_id": 42, "order": 3},
        {"id": 555, "name": "Phase For Test [All Deleted]", "media_plan_id": 42, "order": 4},
        {"id": 780, "name": "Phase 1", "media_plan_id": 43, "order": 0},
        {"id": 420, "name": "Phase 502 projects", "media_plan_id": 44, "order": 0}
    ],
    "ProjectHistoryItem": [
        {"project_id": 500, "created_at": "2019-01-01 00:00:00", "user_id": 1, "action_id": 1},
        {"project_id": 501, "created_at": "2019-01-01 00:00:01", "user_id": 1, "action_id": 1},
        {"project_id": 502, "created_at": "2019-01-01 00:00:02", "user_id": 1, "action_id": 1},
        {"project_id": 600, "created_at": "2019-01-01 00:00:02", "user_id": 1, "action_id": 1},
    ],
    "ProjectGenre": [
        {"project_id": 502, "genre_id": 15},
        {"project_id": 502, "genre_id": 16},
        {"project_id": 500, "genre_id": 17},
    ],
    "CampaignGender": [
        {"campaign_id": 100, "gender_id": 1},
        {"campaign_id": 200, "gender_id": 1},
        {"campaign_id": 300, "gender_id": 1},
        {"campaign_id": 400, "gender_id": 1},
        {"campaign_id": 500, "gender_id": 1},
    ],
    "ApprovalRequest": [
        {
            "id": 42,
            "media_plan_id": 42,
            "requester_id": 1,
            "reviewer_id": 5,
            "email_uuid": "42ed4c22-e1f9-4184-a06d-f04cbdb97442"
        },
        {
            "id": 43,
            "media_plan_id": 44,
            "requester_id": 1,
            "reviewer_id": 5,
            "email_uuid": "42ed4c22-e1f9-4184-a06d-f04cbdb97443"
        }
    ],
    "ApprovalRequestCampaign": [
        {
            "id": 4242,
            "approval_request_id": 42,
            "campaign_uuid": "34ed4c22-e1f9-4184-a06d-f04cbdb97455",
            "expiration_date": datetime.strftime(datetime.now() + timedelta(days=7), "%Y-%m-%d"),
            "is_deleted": False,
            "is_approved": False
        },
        {
            "id": 4243,
            "approval_request_id": 43,
            "campaign_uuid": "55e87545-a3b3-4bd1-9357-a5373df46270",
            "expiration_date": datetime.strftime(datetime.now() + timedelta(days=7), "%Y-%m-%d"),
            "is_deleted": False,
            "is_approved": False
        }
    ],
}