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",
        },
        {
            "id": 6,
            "email": "dev-marketing-user-6@example.com",
            "external_id": "sme-dna|phn0091d6cuhjp30fe6opttml",
            "name": "dev-marketing-user-6",
            "phone": "09179947668",
        },
    ],
    "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:14:55.446196",
            "edit_user_id": 1,
            "is_confidential": False,
            "budget": 1205,
            "allocation": 1205,
            "initial_start_date": "2007-02-02",
            "gras_title": "New Frontline Release",
            "gras_project_code": "23456789",
            "prs_title": "New Frontline Release(PRS)",
            "prs_project_code": "23456789",
            "updated_by_import_at": "2020-10-11",
        },
        {
            "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": 1,
            "updated_at": "2019-07-22 16:14:55.446196",
            "edit_user_id": 1,
            "is_deleted": True,
            "is_confidential": False,
            "budget": 4400,
            "allocation": 4400,
            "initial_start_date": "2007-02-02",
            "gras_title": "New Frontline Release +",
            "gras_project_code": "12345511",
            "prs_title": "New Frontline Release(PRS)",
            "prs_project_code": "12345511",
            "updated_by_import_at": "2020-10-11",
        },
        {
            "id": 502,
            "name": "test_project_502",
            "label_id": 5,
            "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": "1232456",
            "updated_by_import_at": "2020-10-11",
        },
        {
            "id": 503,
            "name": "test_project_503",
            "label_id": 5,
            "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": "6478390",
            "prs_title": "New Frontline Release(PRS)",
            "prs_project_code": "6478390",
            "updated_by_import_at": "2020-10-11",
        },
    ],
    "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": 5, "shared_by": 1, "editable": False, "role": 1},
        {"project_id": 502, "user_id": 2, "editable": False, "shared_by": 5, "role": 1},
        {"project_id": 502, "user_id": 1, "editable": False, "shared_by": 5, "role": 3},
        {"project_id": 503, "user_id": 1, "shared_by": 1, "editable": False, "role": 1},
    ],
    "MediaPlan": [
        {"id": 42, "name": "Untitled For Test", "project_id": 500, "order": 0},
        {"id": 43, "name": "Untitled For Test", "project_id": 501, "order": 0},
    ],
    "MediaPlanPhase": [
        {"id": 100, "name": "Phase 1", "media_plan_id": 42, "order": 1},
        {"id": 200, "name": "Phase 2", "media_plan_id": 42, "order": 2},
        {"id": 300, "name": "Phase 3", "media_plan_id": 42, "order": 3},
        {"id": 400, "name": "Phase 3", "media_plan_id": 43, "order": 1},
    ],
    "Artist": [
        {"id": 10, "external_id": "GRAS_2010", "name": "TestAtrist", "is_sony": True},
        {"id": 20, "external_id": "GRAS_2020", "name": "TestingUpdate", "is_sony": True},
        {"id": 30, "external_id": "GRAS_2040", "name": "artist2", "is_sony": True},
        {"id": 40, "external_id": "GRAS_2050", "name": "artist01", "is_sony": True},
        {"id": 50, "external_id": "GRAS_2060", "name": "UpdateArtist", "is_sony": True},
        {"id": 60, "external_id": "GRAS_2070", "name": "artist2e", "is_sony": True},
        {"id": 130, "external_id": "GRAS_2030", "name": "Petruccho", "is_sony": True},
    ],
    "ProjectTargetItem": [
        {"project_id": 500, "entity_id": 40, "entity_type": 0},
        {"project_id": 500, "entity_id": 50, "entity_type": 0},
        {"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},
    ],
    "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": 130, "type": "Artist"},
    ],
    "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": "{}",
        },
        {"id": 6, "name": "Nash", "rep_owner_key": "623456", "external_name": "Nash", "child_rep_owner_keys": "{}"},
    ],
    "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": 5, "label_id": 5},
    ],
    "UserMetricsField": [
        {"user_id": 2, "metric_field_id": 1},
        {"user_id": 2, "metric_field_id": 2},
        {"user_id": 2, "metric_field_id": 3},
        {"user_id": 2, "metric_field_id": 4},
        {"user_id": 1, "metric_field_id": 2},
        {"user_id": 1, "metric_field_id": 16},
        {"user_id": 1, "metric_field_id": 26},
        {"user_id": 1, "metric_field_id": 40},
        {"user_id": 1, "metric_field_id": 39},
        {"user_id": 1, "metric_field_id": 63},
    ],
    "Campaign": [
        {
            "id": 1,
            "uuid": "34ed4c22-e1f9-4184-a06d-f04cbdb97455",
            "name": "test_campaign_1",
            "external_id": "3456789456",
            "project_id": 500,
            "media_plan_phase_id": 100,
            "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": True,
            "provider_id": 1,
            "age_range": "(0, 60)",
            "objective_id": 2,
        },
        {
            "id": 2,
            "uuid": "aa1490b5-832c-4852-9d28-7a96884ff399",
            "name": "test_campaign_2",
            "external_id": "56748930",
            "project_id": 500,
            "media_plan_phase_id": 200,
            "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,
            "source": "google",
        },
        {
            "id": 3,
            "uuid": "c40fe4e8-58ce-4ba6-ab10-4932e685a389",
            "name": "test_campaign_3",
            "external_id": "34067745",
            "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_campaign_4",
            "external_id": "98765224",
            "start_date": "2008-02-02",
            "end_date": "2008-10-10",
            "planned_budget": 15000,
            "budget_spend": 15000,
            "currency_id": 1,
            "created_at": "2019-07-22 19:14:55.355226",
            "updated_at": "2019-07-22 20:14:55.355226",
            "provider_id": 1,
            "age_range": "(0, 60)",
            "objective_id": 4,
        },
        {
            "id": 5,
            "uuid": "55e87545-a3b3-4bd1-9357-a5373df46270",
            "name": "test_campaign_5",
            "external_id": "65838578",
            "project_id": 500,
            "media_plan_phase_id": 300,
            "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,
            "source": "google",
        },
        {
            "id": 6,
            "uuid": "20618d97-5190-4589-8fed-9e109e5ac5b5",
            "name": "test_campaign_6",
            "external_id": "111554555",
            "project_id": 501,
            "create_user_id": 1,
            "start_date": "2007-02-02",
            "end_date": "2008-10-10",
            "planned_budget": 100,
            "budget_spend": 20,
            "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": 7,
            "uuid": "0b70c231-1997-417b-a23f-9a89ffa4f6bf",
            "name": "test_campaign_7",
            "external_id": "99665533",
            "project_id": 502,
            "create_user_id": 1,
            "start_date": "2007-02-02",
            "end_date": "2008-10-10",
            "planned_budget": 230,
            "budget_spend": 100,
            "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": 3,
        },
        {
            "id": 8,
            "uuid": "9d6211cf-1e47-487d-bb01-e08f6472d71e",
            "name": "test_campaign_8",
            "project_id": 502,
            "create_user_id": 5,
            "start_date": "2007-02-02",
            "end_date": "2008-10-10",
            "planned_budget": 1200,
            "budget_spend": 300,
            "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": 9,
            "uuid": "df9a3dc8-c3d3-440c-bc3c-cee1c3c2dd67",
            "name": "test_campaign_9",
            "external_id": "996655003",
            "project_id": 503,
            "create_user_id": 5,
            "start_date": "2007-02-02",
            "end_date": "2008-10-10",
            "planned_budget": 230,
            "budget_spend": 100,
            "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": 3,
        },
    ],
    "ProjectCampaign": [
        {"project_id": 500, "campaign_id": 3, "status": 0},
        {"project_id": 500, "campaign_id": 4, "status": 0},
        {"project_id": 501, "campaign_id": 4, "status": 0},
    ],
    "ObjectiveMetricsField": [
        {"id": 1, "objective_id": 2, "metrics_field_id": 1, "index": 0},
        {"id": 2, "objective_id": 2, "metrics_field_id": 2, "index": 1},
        {"id": 3, "objective_id": 2, "metrics_field_id": 3, "index": 2},
        {"id": 4, "objective_id": 2, "metrics_field_id": 4, "index": 3},
        {"id": 5, "objective_id": 2, "metrics_field_id": 5, "index": 4},
        {"id": 6, "objective_id": 2, "metrics_field_id": 7, "index": 5},
        {"id": 7, "objective_id": 2, "metrics_field_id": 6, "index": 6},
        {"id": 8, "objective_id": 2, "metrics_field_id": 8, "index": 7},
        {"id": 9, "objective_id": 2, "metrics_field_id": 9, "index": 8},
        {"id": 10, "objective_id": 3, "metrics_field_id": 2, "index": 0},
        {"id": 11, "objective_id": 3, "metrics_field_id": 3, "index": 1},
        {"id": 12, "objective_id": 3, "metrics_field_id": 4, "index": 2},
        {"id": 13, "objective_id": 3, "metrics_field_id": 6, "index": 3},
        {"id": 14, "objective_id": 3, "metrics_field_id": 7, "index": 4},
        {"id": 15, "objective_id": 3, "metrics_field_id": 8, "index": 5},
        {"id": 16, "objective_id": 3, "metrics_field_id": 9, "index": 6},
        {"id": 17, "objective_id": 3, "metrics_field_id": 10, "index": 7},
        {"id": 18, "objective_id": 3, "metrics_field_id": 1, "index": 8},
        {"id": 19, "objective_id": 5, "metrics_field_id": 1, "index": 0},
        {"id": 20, "objective_id": 5, "metrics_field_id": 2, "index": 1},
        {"id": 21, "objective_id": 5, "metrics_field_id": 3, "index": 2},
        {"id": 22, "objective_id": 5, "metrics_field_id": 4, "index": 3},
        {"id": 23, "objective_id": 5, "metrics_field_id": 5, "index": 4},
        {"id": 24, "objective_id": 5, "metrics_field_id": 6, "index": 5},
        {"id": 25, "objective_id": 5, "metrics_field_id": 7, "index": 6},
        {"id": 26, "objective_id": 5, "metrics_field_id": 8, "index": 7},
        {"id": 27, "objective_id": 5, "metrics_field_id": 9, "index": 8},
        {"id": 28, "objective_id": 6, "metrics_field_id": 10, "index": 0},
        {"id": 29, "objective_id": 6, "metrics_field_id": 1, "index": 1},
        {"id": 30, "objective_id": 6, "metrics_field_id": 2, "index": 2},
        {"id": 31, "objective_id": 6, "metrics_field_id": 3, "index": 3},
        {"id": 32, "objective_id": 6, "metrics_field_id": 4, "index": 4},
        {"id": 33, "objective_id": 6, "metrics_field_id": 5, "index": 5},
        {"id": 34, "objective_id": 6, "metrics_field_id": 6, "index": 6},
        {"id": 35, "objective_id": 6, "metrics_field_id": 7, "index": 7},
        {"id": 36, "objective_id": 6, "metrics_field_id": 8, "index": 8},
        {"id": 37, "objective_id": 7, "metrics_field_id": 9, "index": 0},
        {"id": 38, "objective_id": 7, "metrics_field_id": 10, "index": 1},
        {"id": 39, "objective_id": 7, "metrics_field_id": 1, "index": 2},
        {"id": 40, "objective_id": 7, "metrics_field_id": 2, "index": 3},
        {"id": 41, "objective_id": 7, "metrics_field_id": 3, "index": 4},
        {"id": 42, "objective_id": 7, "metrics_field_id": 4, "index": 5},
        {"id": 43, "objective_id": 7, "metrics_field_id": 5, "index": 6},
        {"id": 44, "objective_id": 7, "metrics_field_id": 6, "index": 7},
        {"id": 45, "objective_id": 7, "metrics_field_id": 7, "index": 8},
        {"id": 46, "objective_id": 8, "metrics_field_id": 8, "index": 0},
        {"id": 47, "objective_id": 8, "metrics_field_id": 9, "index": 1},
        {"id": 48, "objective_id": 8, "metrics_field_id": 10, "index": 2},
        {"id": 49, "objective_id": 8, "metrics_field_id": 1, "index": 3},
        {"id": 50, "objective_id": 8, "metrics_field_id": 2, "index": 4},
        {"id": 51, "objective_id": 8, "metrics_field_id": 3, "index": 5},
        {"id": 52, "objective_id": 8, "metrics_field_id": 4, "index": 6},
        {"id": 53, "objective_id": 8, "metrics_field_id": 5, "index": 7},
        {"id": 54, "objective_id": 8, "metrics_field_id": 6, "index": 8},
        {"id": 55, "objective_id": 9, "metrics_field_id": 7, "index": 0},
        {"id": 56, "objective_id": 9, "metrics_field_id": 8, "index": 1},
        {"id": 57, "objective_id": 9, "metrics_field_id": 9, "index": 2},
        {"id": 58, "objective_id": 9, "metrics_field_id": 10, "index": 3},
        {"id": 59, "objective_id": 9, "metrics_field_id": 1, "index": 4},
        {"id": 60, "objective_id": 9, "metrics_field_id": 2, "index": 5},
        {"id": 61, "objective_id": 9, "metrics_field_id": 3, "index": 6},
        {"id": 62, "objective_id": 9, "metrics_field_id": 4, "index": 7},
        {"id": 63, "objective_id": 9, "metrics_field_id": 5, "index": 8},
        {"id": 64, "objective_id": 10, "metrics_field_id": 6, "index": 0},
        {"id": 65, "objective_id": 10, "metrics_field_id": 7, "index": 1},
        {"id": 66, "objective_id": 10, "metrics_field_id": 8, "index": 2},
        {"id": 67, "objective_id": 10, "metrics_field_id": 9, "index": 3},
        {"id": 68, "objective_id": 10, "metrics_field_id": 10, "index": 4},
        {"id": 69, "objective_id": 10, "metrics_field_id": 1, "index": 5},
        {"id": 70, "objective_id": 10, "metrics_field_id": 2, "index": 6},
        {"id": 71, "objective_id": 10, "metrics_field_id": 3, "index": 7},
        {"id": 72, "objective_id": 10, "metrics_field_id": 4, "index": 8},
    ],
}