from datetime import datetime, timedelta

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|3po0091d6c91ty670fe6feeee",
            "name": "dev-marketing-user-3",
            "phone": "67589838844",
        },
    ],
    "Project": [
        {
            "id": 500,
            "name": "Hoistory_project_1",
            "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,
            "gras_project_code": "1012345",
            "gras_title": "Gras Project Title 1",
            "initial_start_date": "2018-01-12",
            "prs_title": "Gras Project Title 1",
            "updated_by_import_at": "2021-02-22 16:14:35.748032",
            "prs_project_code": 2971,
        },
        {
            "id": 501,
            "name": "History_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,
            "gras_project_code": "1012345512",
            "gras_title": "Gras Project Title 2",
            "initial_start_date": "2019-02-01",
            "prs_title": "Gras Project Title 2",
            "updated_by_import_at": "2021-02-22 16:14:35.748032",
            "prs_project_code": 29715,
        },
        {
            "id": 502,
            "name": "History_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,
            "gras_project_code": "101234552312",
            "gras_title": "Gras Project Title 25",
            "initial_start_date": "2019-06-07",
            "prs_title": "Gras Project Title 2",
            "updated_by_import_at": "2021-02-22 16:14:35.748032",
            "prs_project_code": 2971515,
        },
        {
            "id": 503,
            "name": "History_project_4",
            "label_id": 5,
            "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:14:55.446196",
            "edit_user_id": 3,
            "gras_project_code": "10123452152312",
            "gras_title": "Gras Project Title 25",
            "initial_start_date": "2019-06-07",
            "prs_title": "Gras Project Title 2",
            "updated_by_import_at": "2021-02-22 16:14:35.748032",
            "prs_project_code": 29715165,
        },
        {
            "id": 504,
            "name": "History_project_5",
            "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,
            "gras_project_code": "1012346",
            "gras_title": "Gras Project Title 14",
            "initial_start_date": "2007-02-02",
            "prs_title": "Gras Project Title 14",
            "updated_by_import_at": "2021-02-22 16:14:35.748032",
            "prs_project_code": 2971504,
        },
        {
            "id": 505,
            "name": "History_project_6",
            "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,
            "gras_project_code": "1012346",
            "gras_title": "Gras Project Title 14",
            "initial_start_date": "2007-02-02",
            "prs_title": "Gras Project Title 14",
            "updated_by_import_at": "2021-02-22 16:14:35.748032",
            "prs_project_code": 2971504,
        },
    ],
    "UserLabel": [{"user_id": 1, "label_id": 4}, {"user_id": 2, "label_id": 4}, {"user_id": 3, "label_id": 5}],
    "Territory": [
        {"id": 1, "name": "Ukraine", "code": "UA", "territory_type_id": 1},
        {"id": 2, "name": "USA", "code": "USA", "territory_type_id": 1},
        {"id": 3, "name": "Spain", "code": "SP", "territory_type_id": 1},
        {"id": 4, "name": "Germany", "code": "GE", "territory_type_id": 1},
    ],
    "ProjectTargetItem": [
        {"project_id": 500, "entity_id": 70, "entity_type": 3},
        {"project_id": 500, "entity_id": 110, "entity_type": 3},
        {"project_id": 501, "entity_id": 70, "entity_type": 3},
        {"project_id": 502, "entity_id": 20, "entity_type": 0},
        {"project_id": 503, "entity_id": 20, "entity_type": 0},
        {"project_id": 503, "entity_id": 30, "entity_type": 0},
        {"project_id": 503, "entity_id": 10, "entity_type": 1},
        {"project_id": 504, "entity_id": 40, "entity_type": 0},
        {"project_id": 505, "entity_id": 10, "entity_type": 0},
    ],
    "Artist": [
        {"id": 10, "external_id": "GRAS_12423", "name": "Pavlo Zibrov", "is_sony": True, "is_unknown": False},
        {"id": 20, "external_id": "GRAS_12424", "name": "Ricardo", "is_sony": True, "is_unknown": False},
        {"id": 30, "external_id": "GRAS_12425", "name": "Adele", "is_sony": True, "is_unknown": False},
        {"id": 40, "external_id": "GRAS_12426", "name": "Various feat. Ivo Bobul", "is_sony": True, "is_unknown": True},
    ],
    "Polymorphable": [
        {"id": 10, "type": "Artist"},
        {"id": 20, "type": "Artist"},
        {"id": 30, "type": "Artist"},
        {"id": 40, "type": "Artist"},
        {"id": 70, "type": "Playlist"},
        {"id": 110, "type": "Playlist"},
    ],
    "Playlist": [
        {"id": 70, "external_id": "01", "name": "TestAtrist", "owner_name": "Owner1", "provider": "spotify"},
        {"id": 110, "external_id": "05", "name": "UpdateArtist", "owner_name": "Owner2", "provider": "apple"},
    ],
    "Image": [
        {
            "id": 13,
            "url": "https://images-api.atlas.stream/v2/artists/by_gras_participant_id/47369",
            "width": 200,
            "height": 250,
            "related_object_id": 10
         },
        {
            "id": 14,
            "url": "https://images-api.atlas.stream/v2/artists/by_gras_participant_id/47369",
            "width": 200,
            "height": 250,
            "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": 50, "name": "Untitled For Test", "project_id": 505, "order": 0},
    ],
    "MediaPlanPhase": [
        {"id": 450, "name": "Phase For Test", "media_plan_id": 42, "order": 1},
        {"id": 550, "name": "Phase 2", "media_plan_id": 42, "order": 3},
        {"id": 555, "name": "Phase For Test 3", "media_plan_id": 42, "order": 4},
        {"id": 780, "name": "Phase 1", "media_plan_id": 43, "order": 0},
        {"id": 781, "name": "Phase 1", "media_plan_id": 44, "order": 0},
        {"id": 800, "name": "Phase 1", "media_plan_id": 50, "order": 0},
    ],
    "Campaign": [
        {
            "id": 100,
            "uuid": "34ed4c22-e1f9-4184-a06d-f04cbdb97455",
            "name": "test_history_campaign_1",
            "project_id": 500,
            "workflow_status": "Booked",
            "media_plan_phase_id": 450,
            "create_user_id": 1,
            "start_date": "2018-03-12",
            "end_date": "2018-04-13",
            "planned_budget": 1000,
            "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,
            "metainfo": {
                "fields": {
                    "budget": True,
                    "spend": True,
                    "startDate": True,
                    "endDate": True,
                    "genders": True,
                    "audienceAge": True,
                    "countries": True,
                    "destinations": True,
                    "notes": True,
                }
            },
            "type_id": 8,
            "gratis": False,
        },
        {
            "id": 200,
            "uuid": "aa1490b5-832c-4852-9d28-7a96884ff399",
            "name": "test_history_campaign_2",
            "project_id": 500,
            "create_user_id": 1,
            "workflow_status": "Booked",
            "start_date": "2018-02-15",
            "end_date": "2018-04-11",
            "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,
            "metainfo": {
                "fields": {
                    "budget": True,
                    "spend": True,
                    "startDate": True,
                    "endDate": True,
                    "genders": True,
                    "audienceAge": True,
                    "countries": True,
                    "destinations": True,
                    "notes": True,
                }
            },
            "type_id": 8,
            "gratis": False,
        },
        {
            "id": 300,
            "uuid": "c40fe4e8-58ce-4ba6-ab10-4932e685a389",
            "name": "test_deleted_history_campaign_3",
            "project_id": 501,
            "create_user_id": 1,
            "workflow_status": "Booked",
            "start_date": "2019-02-02",
            "end_date": "2019-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,
                }
            },
            "type_id": 8,
            "gratis": False,
        },
        {
            "id": 400,
            "uuid": "2dd6f9b4-42f5-48e8-a01f-c7bb9dc6434d",
            "name": "test_deleted_history_campaign_4",
            "project_id": 501,
            "create_user_id": 1,
            "workflow_status": "Booked",
            "start_date": "2019-03-19",
            "end_date": "2019-03-21",
            "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,
            "metainfo": {
                "fields": {
                    "budget": True,
                    "spend": True,
                    "startDate": True,
                    "endDate": True,
                    "genders": True,
                    "audienceAge": True,
                    "countries": True,
                    "destinations": True,
                    "notes": True,
                }
            },
            "type_id": 8,
            "gratis": False,
        },
        {
            "id": 500,
            "uuid": "55e87545-a3b3-4bd1-9357-a5373df46270",
            "name": "test_history_campaign_5",
            "project_id": 502,
            "create_user_id": 1,
            "workflow_status": "Booked",
            "start_date": "2019-06-07",
            "end_date": "2019-06-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,
            "metainfo": {
                "fields": {
                    "budget": True,
                    "spend": True,
                    "startDate": True,
                    "endDate": True,
                    "genders": True,
                    "audienceAge": True,
                    "countries": True,
                    "destinations": True,
                    "notes": True,
                }
            },
            "type_id": 8,
            "gratis": False,
        },
        {
            "id": 600,
            "uuid": "20618d97-5190-4589-8fed-9e109e5ac5b5",
            "name": "Google Campaign",
            "create_user_id": 1,
            "workflow_status": "Booked",
            "start_date": "2019-06-07",
            "end_date": "2019-06-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,
            "source": "google",
            "metainfo": {
                "fields": {
                    "budget": True,
                    "spend": True,
                    "startDate": True,
                    "endDate": True,
                    "genders": True,
                    "audienceAge": True,
                    "countries": True,
                    "destinations": True,
                    "notes": True,
                }
            },
            "type_id": 8,
            "gratis": False,
        },
        {
            "id": 700,
            "uuid": "34ed4c22-e1f9-4184-a06d-f04cbdb97333",
            "name": "test campaign 7",
            "project_id": 505,
            "media_plan_phase_id": 800,
            "create_user_id": 1,
            "workflow_status": "Draft",
            "start_date": "2007-10-11",
            "end_date": "2007-11-10",
            "planned_budget": 222,
            "budget_spend": 12,
            "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": 1,
            "notes": "Lorem Ipsum",
            "metainfo": {
                "fields": {
                    "budget": True,
                    "spend": True,
                    "startDate": True,
                    "endDate": True,
                    "genders": True,
                    "audienceAge": True,
                    "countries": True,
                    "destinations": True,
                    "notes": True,
                }
            },
            "type_id": 8,
            "gratis": False,
        },
        {
            "id": 800,
            "uuid": "34ed4c22-e1f9-4184-a06d-f04cbdb97452",
            "name": "Pending Approval campaign",
            "project_id": 505,
            "media_plan_phase_id": 800,
            "create_user_id": 1,
            "workflow_status": "Pending Approval",
            "start_date": "2007-10-11",
            "end_date": "2007-11-10",
            "planned_budget": 222,
            "budget_spend": 12,
            "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": 1,
            "notes": "Lorem Ipsum",
            "metainfo": {
                "fields": {
                    "budget": True,
                    "spend": True,
                    "startDate": True,
                    "endDate": True,
                    "genders": True,
                    "audienceAge": True,
                    "countries": True,
                    "destinations": True,
                    "notes": True,
                }
            },
            "type_id": 8,
            "gratis": False,
        },
    ],
    "CampaignTerritory": [
        {"campaign_id": 100, "territory_id": 1, "budget_spend": 5000},
        {"campaign_id": 200, "territory_id": 2, "budget_spend": 5000},
        {"campaign_id": 300, "territory_id": 2, "budget_spend": 5000},
        {"campaign_id": 400, "territory_id": 3, "budget_spend": 5000},
        {"campaign_id": 500, "territory_id": 1, "budget_spend": 5000},
        {"campaign_id": 500, "territory_id": 3, "budget_spend": 5000},
    ],
    "ProjectHistoryItem": [
        {
            "project_id": 500,
            "created_at": "2019-01-01 00:00:00",
            "new_value": {"value": "fresh_project_500"},
            "user_id": 1,
            "action_id": 14,
            "keywords": "fresh_project_500",
        },
        {
            "project_id": 501,
            "created_at": "2019-01-01 00:01:00",
            "new_value": {"value": "fresh_project_501"},
            "user_id": 1,
            "action_id": 14,
            "keywords": "fresh_project_501",
        },
        {
            "project_id": 502,
            "created_at": "2019-01-02 00:02:00",
            "new_value": {"value": "fresh_project_502"},
            "user_id": 1,
            "action_id": 14,
            "keywords": "fresh_project_502",
        },
        {
            "project_id": 503,
            "created_at": "2019-01-02 00:02:00",
            "new_value": {"value": "fresh_project_503"},
            "user_id": 3,
            "action_id": 14,
            "keywords": "fresh_project_503",
        },
        {
            "project_id": 500,
            "campaign_id": 100,
            "created_at": "2019-01-02 12:34:00",
            "user_id": 1,
            "new_value": {"value": 1000},
            "action_id": 1,
            "keywords": "1000",
        },
        {
            "project_id": 500,
            "campaign_id": 200,
            "created_at": "2019-01-02 23:59:59",
            "user_id": 1,
            "new_value": {"value": 2000},
            "action_id": 1,
            "keywords": "2000",
        },
        {
            "project_id": 501,
            "campaign_id": 300,
            "created_at": "2019-01-02 12:40:00",
            "user_id": 1,
            "new_value": {"value": 3000},
            "action_id": 1,
            "keywords": "3000",
        },
        {
            "project_id": 501,
            "campaign_id": 400,
            "created_at": "2019-01-02 13:59:00",
            "user_id": 1,
            "new_value": {"value": 4000},
            "action_id": 1,
            "keywords": "4000",
        },
        {
            "project_id": 502,
            "campaign_id": 500,
            "created_at": "2019-01-02 23:59:59",
            "user_id": 1,
            "new_value": {"value": 5000},
            "action_id": 1,
            "keywords": "5000",
        },
        {
            "project_id": 501,
            "campaign_id": 300,
            "created_at": "2019-01-04 12:41:00",
            "user_id": 1,
            "old_value": {"value": 1000},
            "action_id": 2,
            "keywords": "1000",
        },
        {"project_id": 501, "created_at": "2019-01-05 09:01:00", "user_id": 1, "action_id": 15},
    ],
    "ApprovalRequest": [
        {
            "id": 42,
            "media_plan_id": 50,
            "requester_id": 1,
            "reviewer_id": 1,
            "email_uuid": "42ed4c22-e1f9-4184-a06d-f04cbdb97442"
        }
    ],
    "ApprovalRequestCampaign": [
        {
            "id": 4242,
            "approval_request_id": 42,
            "campaign_uuid": "34ed4c22-e1f9-4184-a06d-f04cbdb97452",
            "expiration_date": datetime.strftime(datetime.now() + timedelta(days=7), "%Y-%m-%d"),
            "is_deleted": False,
            "is_approved": False
        }
    ],
    "UserProject": [
        {"project_id": 500, "user_id": 1, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 500, "user_id": 2, "role": 1, "editable": True, "shared_by": 1},
        {"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": 503, "user_id": 3, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 504, "user_id": 1, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 505, "user_id": 1, "role": 4, "editable": True, "shared_by": 1},
        {"project_id": 505, "user_id": 1, "role": 1, "editable": True, "shared_by": 1}
    ],
    "UserProjectCampaignTypeGroup": [
        {"user_project_id": 1, "campaign_type_group_id": 1},
        {"user_project_id": 1, "campaign_type_group_id": 2},
        {"user_project_id": 1, "campaign_type_group_id": 3},
        {"user_project_id": 1, "campaign_type_group_id": 4},
    ],
    "ProjectGenre": [
        {"project_id": 502, "genre_id": 15},
        {"project_id": 502, "genre_id": 16},
        {"project_id": 500, "genre_id": 17},
        {"project_id": 501, "genre_id": 12},
    ],
    "ProjectCampaign": [{"project_id": 500, "campaign_id": 600, "status": 0}],
    "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},
    ],
    # ""
}