from tests.root_fixture import root_fixture
from datetime import datetime, timedelta
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|5cf0091d6c91d310fe6fcdc8",
            "name": "user-3",
            "phone": "",
        },
    ],
    "Artist": [
        {"id": 10, "external_id": "GRAS_10", "name": "TestAtrist1", "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},
        {"id": 50, "external_id": "GRAS_50", "name": "TestArtist5", "is_sony": True},
        {"id": 60, "external_id": "GRAS_60", "name": "TestArtist6", "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"},
    ],
    "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},
    ],
    "UserLabel": [
        {"user_id": 1, "label_id": 1},
        {"user_id": 2, "label_id": 2},
        {"user_id": 2, "label_id": 3},
    ],
    "ArtistTeamUser": [
        {
            "artist_team_id": 1,
            "user_id": 1,
            "role": 1
        },
        {
            "artist_team_id": 4,
            "user_id": 2,
            "role": 1
        },
        {
            "artist_team_id": 5,
            "user_id": 2,
            "role": 1
        },
        {
            "artist_team_id": 6,
            "user_id": 3,
            "role": 1
        },
    ],
    "Project": [
        {
            "id": 500,
            "name": "test_project_1",
            "label_id": 1,
            "budget": 30000,
            "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": datetime.now() - timedelta(days=15),
            "end_date": datetime.now() + timedelta(days=20),
            "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",
            "currency": "USD",
        },
        {
            "id": 501,
            "name": "test_project_2",
            "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": datetime.now() + timedelta(days=10),
            "end_date": datetime.now() + timedelta(days=20),
            "gras_title": "New Frontline Release 2",
            "gras_project_code": "12345568",
            "prs_title": "New Frontline Release(PRS) 2",
            "prs_project_code": "012345568",
            "updated_by_import_at": "2020-10-11",
        },
        {
            "id": 502,
            "name": "Project 3",
            "label_id": 1,
            "budget": 1000,
            "allocation": 500,
            "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": datetime.now() + timedelta(days=20),
            "end_date": datetime.now() + timedelta(days=40),
            "gras_title": "New Frontline Release 3",
            "gras_project_code": "12345569",
            "prs_title": "New Frontline Release(PRS) 3",
            "prs_project_code": "012345569",
            "updated_by_import_at": "2020-10-11",
            "currency": "GBP",
        },
        {
            "id": 503,
            "name": "Project 4",
            "label_id": 1,
            "budget": 2000,
            "allocation": 500,
            "created_at": "2019-07-21 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": datetime.now() + timedelta(days=1),
            "end_date": datetime.now() + timedelta(days=40),
            "gras_title": "New Frontline Release 4",
            "gras_project_code": "12345561",
            "prs_title": "New Frontline Release(PRS) 4",
            "prs_project_code": "012345569",
            "updated_by_import_at": "2020-10-11",
            "currency": "GBP",
        },
        {
            "id": 504,
            "name": "Project 5",
            "label_id": 1,
            "budget": 2000,
            "allocation": 500,
            "created_at": "2019-07-21 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": datetime.now() - timedelta(days=3),
            "end_date": datetime.now() - timedelta(days=2),
            "gras_title": "New Frontline Release 5",
            "gras_project_code": "12345566",
            "prs_title": "New Frontline Release(PRS) 5",
            "prs_project_code": "012345569",
            "updated_by_import_at": "2020-10-11",
            "currency": "USD",
        },
        {
            "id": 505,
            "name": "Project 6",
            "label_id": 1,
            "budget": 2000,
            "allocation": 500,
            "created_at": "2019-07-21 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": datetime.now() - timedelta(days=3),
            "end_date": datetime.now() + timedelta(days=20),
            "gras_title": "New Frontline Release 6",
            "gras_project_code": "12345554",
            "prs_title": "New Frontline Release(PRS) 6",
            "prs_project_code": "012345569",
            "updated_by_import_at": "2020-10-11",
            "currency": "USD",
        },
    ],
    "Campaign": [
            {
                "id": 100,
                "uuid": "34ed4c22-e1f9-4184-a06d-f04cbdb97455",
                "name": "Campaign 1",
                "project_id": 500,
                "create_user_id": 1,
                "start_date": datetime.now() - timedelta(days=1),
                "end_date": datetime.now(),
                "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,
                "source": "PRS",
                "age_range": "[0, 60]",
                "objective_id": 1,
                "notes": "Lorem Ipsum",
                "metainfo": {
                    "fields": {
                        "budget": True,
                        "spend": True,
                        "startDate": False,
                        "endDate": False,
                        "genders": False,
                        "audienceAge": True,
                        "countries": True,
                        "destinations": True,
                        "notes": True,
                    }
                },
                "type_id": 8,
                "gratis": False,
            },
            {
                "id": 200,
                "uuid": "aa1490b5-832c-4852-9d28-7a96884ff399",
                "name": "Campaign 2",
                "project_id": 500,
                "create_user_id": 1,
                "start_date": "2008-02-02",
                "end_date": "2008-10-10",
                "planned_budget": 190000,
                "budget_spend": 90000,
                "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": "[18, 35]",
                "objective_id": 2,
                "metainfo": {
                    "fields": {
                        "budget": False,
                        "spend": False,
                        "startDate": False,
                        "endDate": False,
                        "genders": False,
                        "audienceAge": True,
                        "countries": True,
                        "destinations": False,
                        "notes": True,
                    }
                },
                "type_id": 8,
                "gratis": False,
            },
            {
                "id": 300,
                "uuid": "c40fe4e8-58ce-4ba6-ab10-4932e685a389",
                "name": "Deleted Campaign 3",
                "project_id": 500,
                "create_user_id": 1,
                "start_date": "2007-02-02",
                "end_date": "2008-10-10",
                "planned_budget": 1000,
                "budget_spend": 10000,
                "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": 1,
                "type_id": 8,
                "gratis": False,
            },
            {
                "id": 400,
                "uuid": "2dd6f9b4-42f5-48e8-a01f-c7bb9dc6434d",
                "name": "Campaign from 501 project",
                "project_id": 501,
                "create_user_id": 1,
                "start_date": "2015-02-02",
                "end_date": "2016-10-10",
                "planned_budget": 12000,
                "budget_spend": 15000,
                "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": False,
                        "endDate": False,
                        "genders": False,
                        "audienceAge": False,
                        "countries": True,
                        "destinations": False,
                        "notes": False,
                    }
                },
                "type_id": 8,
                "gratis": False,
            },
            {
                "id": 500,
                "uuid": "20618d97-5190-4589-8fed-9e109e5ac5b5",
                "name": "Campaign Facebook External",
                "project_id": 500,
                "create_user_id": 1,
                "start_date": datetime.now() - timedelta(days=1),
                "end_date": datetime.now(),
                "planned_budget": 190000,
                "budget_spend": 90000,
                "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,
                "source": "facebook",
                "age_range": "[18, 35]",
                "objective_id": 2,
                "metainfo": {
                    "fields": {
                        "budget": False,
                        "spend": False,
                        "startDate": False,
                        "endDate": False,
                        "genders": False,
                        "audienceAge": True,
                        "countries": True,
                        "destinations": False,
                        "notes": True,
                    }
                },
                "type_id": 8,
                "gratis": False,
            },
            {
                "id": 600,
                "uuid": "0b70c231-1997-417b-a23f-9a89ffa4f6bf",
                "name": "Campaign Google External",
                "project_id": 500,
                "create_user_id": 1,
                "start_date": datetime.now() - timedelta(days=1),
                "end_date": datetime.now(),
                "planned_budget": 190000,
                "budget_spend": 90000,
                "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,
                "source": "google",
                "age_range": "[18, 35]",
                "objective_id": 2,
                "metainfo": {
                    "fields": {
                        "budget": False,
                        "spend": False,
                        "startDate": False,
                        "endDate": False,
                        "genders": False,
                        "audienceAge": True,
                        "countries": True,
                        "destinations": False,
                        "notes": True,
                    }
                },
                "type_id": 8,
                "gratis": False,
            },
            {
                "id": 700,
                "uuid": "9d6211cf-1e47-487d-bb01-e08f6472d71e",
                "name": "Campaign Internal Source None",
                "project_id": 500,
                "create_user_id": 1,
                "start_date": datetime.now() - timedelta(days=1),
                "end_date": datetime.now() + timedelta(days=1),
                "planned_budget": 250000,
                "budget_spend": 90000,
                "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": "[18, 35]",
                "objective_id": 2,
                "metainfo": {
                    "fields": {
                        "budget": False,
                        "spend": False,
                        "startDate": False,
                        "endDate": False,
                        "genders": False,
                        "audienceAge": True,
                        "countries": True,
                        "destinations": False,
                        "notes": True,
                    }
                },
                "type_id": 8,
                "gratis": False,
            },
            {
                "id": 800,
                "uuid": "df9a3dc8-c3d3-440c-bc3c-cee1c3c2dd67",
                "name": "Pending Campaign",
                "create_user_id": 1,
                "start_date": datetime.now() - timedelta(days=1),
                "end_date": datetime.now() + timedelta(days=1),
                "planned_budget": 0,
                "budget_spend": 0,
                "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": "[18, 35]",
                "objective_id": 2,
                "metainfo": {
                    "fields": {
                        "budget": False,
                        "spend": False,
                        "startDate": False,
                        "endDate": False,
                        "genders": False,
                        "audienceAge": True,
                        "countries": True,
                        "destinations": False,
                        "notes": True,
                    }
                },
                "type_id": 8,
                "gratis": False,
            },
    ],
    "ProjectCampaign": [
        {
            "project_id": 500,
            "campaign_id": 100,
            "status": 1,
        },
        {
            "project_id": 500,
            "campaign_id": 200,
            "status": 1,
        },
        {
            "project_id": 500,
            "campaign_id": 300,
            "status": 1,
        },
        {
            "project_id": 501,
            "campaign_id": 400,
            "status": 1,
        },
        {
            "project_id": 500,
            "campaign_id": 500,
            "status": 1,
        },
        {
            "project_id": 500,
            "campaign_id": 600,
            "status": 1,
        },
        {
            "project_id": 500,
            "campaign_id": 700,
            "status": 1,
        },
        {
            "project_id": 500,
            "campaign_id": 800,
            "status": 0,
        },
        {
            "project_id": 501,
            "campaign_id": 800,
            "status": 0,
        },
    ],
    "CampaignPlatformsLinks": [
        {"campaign_id": 100, "platform_id": 67},
        {"campaign_id": 200, "platform_id": 7},
        {"campaign_id": 300, "platform_id": 1},
        {"campaign_id": 400, "platform_id": 22},
    ],
    "MediaPlan": [
        {"id":  42, "name": "Untitled For Test", "project_id": 500, "order": 0},
        {"id":  41, "name": "MediaPlan2", "project_id": 500, "order": 1},
        {"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": [
        {"name": "Phase For Test", "media_plan_id": 42, "order": 0},
        {"name": "Phase For Test 2", "media_plan_id": 42, "order": 1},
        {"name": "Phase For Test 3", "media_plan_id": 42, "order": 2},
        {"name": "Phase For Test", "media_plan_id": 43, "order": 0},
        {"name": "Phase For Test", "media_plan_id": 44, "order": 0},
        {"name": "Phase For Test", "media_plan_id": 45, "order": 0},
        {"name": "Phase For Test", "media_plan_id": 46, "order": 0},
        {"name": "Phase For Test", "media_plan_id": 47, "order": 0},
    ],
    "ProjectTargetItem": [
        {"project_id": 500, "entity_id": 10, "entity_type": 0},
        {"project_id": 501, "entity_id": 30, "entity_type": 0},
        {"project_id": 502, "entity_id": 10, "entity_type": 0},
        {"project_id": 503, "entity_id": 20, "entity_type": 0},
        {"project_id": 504, "entity_id": 20, "entity_type": 0},
        {"project_id": 505, "entity_id": 20, "entity_type": 0}
    ],
    "UserProject": [
        {"project_id": 500, "user_id": 1, "shared_by": 1, "editable": False, "role": 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": 1, "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, "shared_by": 1, "editable": False, "role": 1},
    ],
}