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": "gras@example.com", "external_id": "sme-dna|5cf0091d6c91d310fe6fcdc7", "name": "GRAS", "is_service_account": True, }, ], "HistoryUser": [ {"id": "sme-dna|5cf0091d6c91d310fe6fcdc6", "email": "user-1@example.com", "created_at": "2019-05-31 15:25:24"} ], "MarketingAccount": [ {"id": 1, "label_id": 1, "type": 0, "external_id": "8653387137", "provider_id": 1, "currency": "USD"}, {"id": 2, "label_id": 2, "type": 0, "external_id": "2333825793", "provider_id": 2, "currency": "USD"}, {"id": 3, "label_id": 1, "type": 0, "external_id": "6449900252", "provider_id": 3, "currency": "USD"}, {"id": 4, "label_id": 5, "type": 0, "external_id": "3029121817", "provider_id": 1, "currency": "EUR"}, {"id": 5, "label_id": 2, "type": 0, "external_id": "3029121842", "provider_id": 1, "currency": "USD"}, ], "Project": [ { "id": 500, "name": "test_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, "is_confidential": False, "budget": 500, "allocation": 500, "initial_start_date": "2007-02-02", "gras_title": "New Frontline Release ++", "gras_project_code": "GRAS_00", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345510", "updated_by_import_at": "2020-10-11", "currency": "USD", }, { "id": 501, "name": "test_project_2", "label_id": 2, "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": 500, "allocation": 500, "initial_start_date": "2020-08-04", "gras_title": "DJ KHALEED feat. 200 id", "gras_project_code": "GRAS_200", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345511", "updated_by_import_at": "2020-10-11", "currency": "USD", }, { "id": 502, "name": "test_project_3", "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, "notes": "Some notes", "is_confidential": False, "budget": 500, "allocation": 500, "initial_start_date": "2020-02-03", "gras_title": "DJ KHALEED feat. 200 id", "gras_project_code": "GRAS_100", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345515", "updated_by_import_at": "2020-10-11", "currency": "USD", }, { "id": 503, "name": "test_project_4", "label_id": 2, "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, "notes": "Some notes", "is_confidential": False, "budget": 500, "allocation": 500, "initial_start_date": "2020-12-04", "gras_title": "Chris Brown feat. 300 id", "gras_project_code": "GRAS_300", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345516", "updated_by_import_at": "2020-10-11", "currency": "USD", }, { "id": 504, "name": "test_project_5", "label_id": 2, "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, "notes": "Some notes", "is_confidential": False, "budget": 500, "allocation": 500, "initial_start_date": "2021-12-04", "gras_title": "Chris Brown feat. 400 id", "gras_project_code": "GRAS_400", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345518", "updated_by_import_at": "2020-10-11", "currency": "USD", }, { "id": 505, "name": "test_project_6", "label_id": 2, "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, "notes": "Some notes", "is_confidential": False, "budget": 500, "allocation": 500, "initial_start_date": "2019-12-04", "gras_title": "Chris Brown feat. 400 id", "gras_project_code": "2001235655", "prs_title": "New Frontline Release(PRS)", "prs_project_code": "012345519", "updated_by_import_at": "2020-10-11", "currency": "USD", }, ], "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": 550, "name": "Phase For Test [Empty]", "media_plan_id": 43, "order": 1}, {"id": 555, "name": "Phase For Test [All Deleted]", "media_plan_id": 44, "order": 1}, ], "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": 2}, {"user_id": 1, "label_id": 3}, {"user_id": 1, "label_id": 4}, {"user_id": 1, "label_id": 5}, ], "Artist": [ {"id": 10, "external_id": "GRAS_10", "name": "Chris Brown", "is_sony": True}, {"id": 20, "external_id": "GRAS_20", "name": "Johnny Cash", "is_sony": True}, {"id": 30, "external_id": "GRAS_30", "name": "Whitney Houston", "is_sony": True}, {"id": 40, "external_id": "GRAS_40", "name": "Paul Epworth", "is_sony": True}, {"id": 50, "external_id": "GRAS_50", "name": "Maren Morris", "is_sony": True}, {"id": 60, "external_id": "GRAS_60", "name": "Calboy", "is_sony": True}, {"id": 130, "external_id": "GRAS_130", "name": "Pedro Capo", "is_sony": True}, {"id": 140, "external_id": "GRAS_140", "name": "AC/DC", "is_sony": True}, ], "ProjectTargetItem": [ {"project_id": 500, "entity_id": 70, "entity_type": 3, "add_type": 1}, {"project_id": 500, "entity_id": 80, "entity_type": 3, "add_type": 1}, {"project_id": 500, "entity_id": 90, "entity_type": 3, "add_type": 1}, {"project_id": 500, "entity_id": 100, "entity_type": 3, "add_type": 1}, {"project_id": 501, "entity_id": 60, "entity_type": 0, "add_type": 1}, {"project_id": 502, "entity_id": 140, "entity_type": 1, "add_type": 1}, {"project_id": 502, "entity_id": 10, "entity_type": 0, "add_type": 0}, {"project_id": 502, "entity_id": 30, "entity_type": 1, "add_type": 0}, {"project_id": 502, "entity_id": 40, "entity_type": 0, "add_type": 0, "is_deleted": True}, {"project_id": 502, "entity_id": 130, "entity_type": 1, "add_type": 0, "is_deleted": True}, {"project_id": 502, "entity_id": 60, "entity_type": 1, "add_type": 1, "is_deleted": True}, {"project_id": 503, "entity_id": 10, "entity_type": 0, "add_type": 0}, {"project_id": 504, "entity_id": 10, "entity_type": 0, "add_type": 0}, {"project_id": 505, "entity_id": 10, "entity_type": 0, "add_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": 70, "type": "Playlist"}, {"id": 80, "type": "Playlist"}, {"id": 90, "type": "Playlist"}, {"id": 100, "type": "Playlist"}, {"id": 110, "type": "Playlist"}, {"id": 120, "type": "Playlist"}, {"id": 130, "type": "Artist"}, {"id": 140, "type": "Artist"}, ], "Playlist": [ {"id": 70, "external_id": "01", "name": "TestAtrist", "owner_name": "Owner1", "provider": "spotify"}, {"id": 80, "external_id": "02", "name": "TestingUpdate", "owner_name": "Owner1", "provider": "spotify"}, {"id": 90, "external_id": "03", "name": "artist2", "owner_name": "Owner1", "provider": "spotify"}, {"id": 100, "external_id": "04", "name": "artist01", "owner_name": "Owner3", "provider": "apple"}, {"id": 110, "external_id": "05", "name": "UpdateArtist", "owner_name": "Owner2", "provider": "apple"}, {"id": 120, "external_id": "06", "name": "artist2e", "owner_name": "Owner1", "provider": "spotify"}, ], "Image": [ {"id": 13, "url": "http://test.com", "width": 200, "height": 250, "related_object_id": 70}, {"id": 14, "url": "http://test.com/1", "width": 200, "height": 250, "related_object_id": 70}, {"id": 15, "url": "http://test.com/2", "width": 300, "height": 250, "related_object_id": 20}, {"id": 16, "url": "http://test.com/3", "width": 400, "height": 250, "related_object_id": 50}, {"id": 17, "url": "http://test.com/4", "width": 400, "height": 250, "related_object_id": 130}, {"id": 18, "url": "http://test.com/5", "width": 400, "height": 250, "related_object_id": 130}, ], "Currency": [{"id": 1, "name": "United States Dollar", "code": "USD"}, {"id": 2, "name": "Hryvnya", "code": "UAH"}], "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}, ], "Campaign": [ { "id": 100, "uuid": "34ed4c22-e1f9-4184-a06d-f04cbdb97455", "external_id": "234567890", "project_id": 500, "name": "Calboy - CA (Go Crazy Video)", "start_date": "2020-02-02", "end_date": "2020-10-10", "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", "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, "source": "google", "type_id": 8, "gratis": False, }, { "id": 200, "uuid": "aa1490b5-832c-4852-9d28-7a96884ff399", "external_id": "677567856", "name": "[MANUALLY ASSIGNED] - CA (Go Crazy Video)", "start_date": "2020-12-04", "end_date": "2020-12-06", "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", "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, "source": "google", "type_id": 8, "gratis": False, }, { "id": 300, "uuid": "c40fe4e8-58ce-4ba6-ab10-4932e685a389", "external_id": "45677567856", "name": "[MANUALLY ASSIGNED + 1] - CA (Go Crazy Video)", "start_date": "2020-12-04", "end_date": "2020-12-06", "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", "provider_id": 1, "age_range": "(0, 60)", "objective_id": 2, "source": "google", "type_id": 8, "gratis": False, }, ], "CampaignAd": [ { "id": 101, "external_id": "101", "name": "Campaign Ad 1", "start_date": "2015-02-05", "end_date": "2015-02-12", "planned_budget": 14000, "budget_spend": 15000, "age_range": "[0, 60]", "objective_id": 1, "campaign_id": 100, "platform": "Tiktok", }, { "id": 202, "external_id": "202202", "name": "Campaign Ad 2", "start_date": "2016-02-05", "end_date": "2016-02-12", "planned_budget": 0, "budget_spend": 0, "age_range": "[0, 40]", "objective_id": 1, "campaign_id": 100, "platform": "Tiktok", }, { "id": 303, "external_id": "303303", "name": "Campaign Ad 3", "start_date": "2017-02-05", "end_date": "2017-02-12", "planned_budget": 100, "budget_spend": 0, "age_range": "[0, 30]", "objective_id": 1, "campaign_id": 100, "platform": "Tiktok", }, { "id": 404, "external_id": "404404", "name": "Campaign Ad 4", "start_date": "2018-02-05", "end_date": "2018-02-12", "planned_budget": 200, "budget_spend": 0, "age_range": "[0, 55]", "objective_id": 1, "campaign_id": 200, "platform": "Tiktok", }, ], "CampaignAdLink": [ {"campaign_ad_id": 101, "link": "www.sony.com"}, {"campaign_ad_id": 202, "link": "www.decibel.com"}, {"campaign_ad_id": 303, "link": "www.decibel1.com"}, {"campaign_ad_id": 404, "link": "www.decibel2.com"}, ], "CampaignAdTerritory": [ {"campaign_ad_id": 101, "territory_id": 1}, {"campaign_ad_id": 202, "territory_id": 2}, {"campaign_ad_id": 303, "territory_id": 1}, {"campaign_ad_id": 404, "territory_id": 1}, ], "ProjectCampaign": [ {"project_id": 501, "campaign_id": 100, "status": 1}, {"project_id": 504, "campaign_id": 300, "status": 0}, {"project_id": 503, "campaign_id": 200, "status": 0}, {"project_id": 503, "campaign_id": 300, "status": 0}, ], "Territory": [ {"id": 0, "name": "Global", "territory_type_id": 0, "code": "GLBL"}, {"id": 1, "name": "Afghanistan", "territory_type_id": 1, "parent_id": 0, "code": "AF"}, {"id": 2, "name": "Albania", "territory_type_id": 1, "parent_id": 0, "code": "AL"}, {"id": 3, "name": "Algeria", "territory_type_id": 1, "parent_id": 0, "code": "DZ"}, {"id": 4, "name": "American Samoa", "territory_type_id": 1, "parent_id": 0, "code": "AS"}, {"id": 5, "name": "Andorra", "territory_type_id": 1, "parent_id": 0, "code": "AD"}, {"id": 6, "name": "Angola", "territory_type_id": 1, "parent_id": 0, "code": "AO"}, {"id": 7, "name": "Anguilla", "territory_type_id": 1, "parent_id": 0, "code": "AI"}, {"id": 8, "name": "Antarctica", "territory_type_id": 1, "parent_id": 0, "code": "AQ"}, {"id": 9, "name": "Antigua and Barbuda", "territory_type_id": 1, "parent_id": 0, "code": "AG"}, {"id": 10, "name": "Argentina", "territory_type_id": 1, "parent_id": 0, "code": "AR"}, {"id": 11, "name": "Armenia", "territory_type_id": 1, "parent_id": 0, "code": "AM"}, {"id": 12, "name": "Aruba", "territory_type_id": 1, "parent_id": 0, "code": "AW"}, {"id": 13, "name": "Australia", "territory_type_id": 1, "parent_id": 0, "code": "AU"}, {"id": 14, "name": "Austria", "territory_type_id": 1, "parent_id": 0, "code": "AT"}, {"id": 15, "name": "Azerbaijan", "territory_type_id": 1, "parent_id": 0, "code": "AZ"}, {"id": 16, "name": "Bahamas", "territory_type_id": 1, "parent_id": 0, "code": "BS"}, {"id": 17, "name": "Bahrain", "territory_type_id": 1, "parent_id": 0, "code": "BH"}, {"id": 18, "name": "Bangladesh", "territory_type_id": 1, "parent_id": 0, "code": "BD"}, {"id": 19, "name": "Barbados", "territory_type_id": 1, "parent_id": 0, "code": "BB"}, {"id": 20, "name": "Belarus", "territory_type_id": 1, "parent_id": 0, "code": "BY"}, {"id": 21, "name": "Belgium", "territory_type_id": 1, "parent_id": 0, "code": "BE"}, {"id": 22, "name": "Belize", "territory_type_id": 1, "parent_id": 0, "code": "BZ"}, {"id": 23, "name": "Benin", "territory_type_id": 1, "parent_id": 0, "code": "BJ"}, {"id": 24, "name": "Bermuda", "territory_type_id": 1, "parent_id": 0, "code": "BM"}, {"id": 25, "name": "Bhutan", "territory_type_id": 1, "parent_id": 0, "code": "BT"}, {"id": 26, "name": "Bolivia", "territory_type_id": 1, "parent_id": 0, "code": "BO"}, {"id": 27, "name": "Bosnia and Herzegovina", "territory_type_id": 1, "parent_id": 0, "code": "BA"}, {"id": 28, "name": "Botswana", "territory_type_id": 1, "parent_id": 0, "code": "BW"}, {"id": 29, "name": "Bouvet Island", "territory_type_id": 1, "parent_id": 0, "code": "BV"}, {"id": 30, "name": "Brazil", "territory_type_id": 1, "parent_id": 0, "code": "BR"}, {"id": 31, "name": "British Indian Ocean Territory", "territory_type_id": 1, "parent_id": 0, "code": "IO"}, {"id": 32, "name": "Brunei Darussalam", "territory_type_id": 1, "parent_id": 0, "code": "BN"}, {"id": 33, "name": "Bulgaria", "territory_type_id": 1, "parent_id": 0, "code": "BG"}, {"id": 34, "name": "Burkina Faso", "territory_type_id": 1, "parent_id": 0, "code": "BF"}, {"id": 35, "name": "Burundi", "territory_type_id": 1, "parent_id": 0, "code": "BI"}, {"id": 36, "name": "Cambodia", "territory_type_id": 1, "parent_id": 0, "code": "KH"}, {"id": 37, "name": "Cameroon", "territory_type_id": 1, "parent_id": 0, "code": "CM"}, {"id": 38, "name": "Canada", "territory_type_id": 1, "parent_id": 0, "code": "CA"}, {"id": 39, "name": "Cape Verde", "territory_type_id": 1, "parent_id": 0, "code": "CV"}, {"id": 40, "name": "Cayman Islands", "territory_type_id": 1, "parent_id": 0, "code": "KY"}, {"id": 41, "name": "Central African Republic", "territory_type_id": 1, "parent_id": 0, "code": "CF"}, {"id": 42, "name": "Chad", "territory_type_id": 1, "parent_id": 0, "code": "TD"}, {"id": 43, "name": "Chile", "territory_type_id": 1, "parent_id": 0, "code": "CL"}, {"id": 44, "name": "China", "territory_type_id": 1, "parent_id": 0, "code": "CN"}, {"id": 45, "name": "Christmas Island", "territory_type_id": 1, "parent_id": 0, "code": "CX"}, {"id": 46, "name": "Cocos (Keeling) Islands", "territory_type_id": 1, "parent_id": 0, "code": "CC"}, {"id": 47, "name": "Colombia", "territory_type_id": 1, "parent_id": 0, "code": "CO"}, {"id": 48, "name": "Comoros", "territory_type_id": 1, "parent_id": 0, "code": "KM"}, {"id": 49, "name": "Congo", "territory_type_id": 1, "parent_id": 0, "code": "CG"}, {"id": 50, "name": "Cook Islands", "territory_type_id": 1, "parent_id": 0, "code": "CK"}, {"id": 51, "name": "Costa Rica", "territory_type_id": 1, "parent_id": 0, "code": "CR"}, {"id": 52, "name": "Croatia", "territory_type_id": 1, "parent_id": 0, "code": "HR"}, {"id": 53, "name": "Cuba", "territory_type_id": 1, "parent_id": 0, "code": "CU"}, {"id": 54, "name": "Cyprus", "territory_type_id": 1, "parent_id": 0, "code": "CY"}, {"id": 55, "name": "Czech Republic", "territory_type_id": 1, "parent_id": 0, "code": "CZ"}, {"id": 56, "name": "Denmark", "territory_type_id": 1, "parent_id": 0, "code": "DK"}, {"id": 57, "name": "Djibouti", "territory_type_id": 1, "parent_id": 0, "code": "DJ"}, {"id": 58, "name": "Dominica", "territory_type_id": 1, "parent_id": 0, "code": "DM"}, {"id": 59, "name": "Dominican Republic", "territory_type_id": 1, "parent_id": 0, "code": "DO"}, {"id": 60, "name": "East Timor", "territory_type_id": 1, "parent_id": 0, "code": "TL"}, {"id": 61, "name": "Ecuador", "territory_type_id": 1, "parent_id": 0, "code": "EC"}, {"id": 62, "name": "Egypt", "territory_type_id": 1, "parent_id": 0, "code": "EG"}, {"id": 63, "name": "El Salvador", "territory_type_id": 1, "parent_id": 0, "code": "SV"}, {"id": 64, "name": "Equatorial Guinea", "territory_type_id": 1, "parent_id": 0, "code": "GQ"}, {"id": 65, "name": "Eritrea", "territory_type_id": 1, "parent_id": 0, "code": "ER"}, {"id": 66, "name": "Estonia", "territory_type_id": 1, "parent_id": 0, "code": "EE"}, {"id": 67, "name": "Ethiopia", "territory_type_id": 1, "parent_id": 0, "code": "ET"}, {"id": 68, "name": "Falkland Islands", "territory_type_id": 1, "parent_id": 0, "code": "FK"}, {"id": 69, "name": "Faroe Islands", "territory_type_id": 1, "parent_id": 0, "code": "FO"}, {"id": 70, "name": "Fiji", "territory_type_id": 1, "parent_id": 0, "code": "FJ"}, {"id": 71, "name": "Finland", "territory_type_id": 1, "parent_id": 0, "code": "FI"}, {"id": 72, "name": "France", "territory_type_id": 1, "parent_id": 0, "code": "FR"}, {"id": 73, "name": "France Metropolitan", "territory_type_id": 1, "parent_id": 0, "code": "FX"}, {"id": 74, "name": "French Guiana", "territory_type_id": 1, "parent_id": 0, "code": "GF"}, {"id": 75, "name": "French Polynesia", "territory_type_id": 1, "parent_id": 0, "code": "PF"}, {"id": 76, "name": "French Southern Territories", "territory_type_id": 1, "parent_id": 0, "code": "TF"}, {"id": 77, "name": "Gabon", "territory_type_id": 1, "parent_id": 0, "code": "GA"}, {"id": 78, "name": "Gambia", "territory_type_id": 1, "parent_id": 0, "code": "GM"}, {"id": 79, "name": "Georgia", "territory_type_id": 1, "parent_id": 0, "code": "GE"}, {"id": 80, "name": "Germany", "territory_type_id": 1, "parent_id": 0, "code": "DE"}, {"id": 81, "name": "Ghana", "territory_type_id": 1, "parent_id": 0, "code": "GH"}, {"id": 82, "name": "Gibraltar", "territory_type_id": 1, "parent_id": 0, "code": "GI"}, {"id": 83, "name": "Guernsey", "territory_type_id": 1, "parent_id": 0, "code": "GG"}, {"id": 84, "name": "Greece", "territory_type_id": 1, "parent_id": 0, "code": "GR"}, {"id": 85, "name": "Greenland", "territory_type_id": 1, "parent_id": 0, "code": "GL"}, {"id": 86, "name": "Grenada", "territory_type_id": 1, "parent_id": 0, "code": "GD"}, {"id": 87, "name": "Guadeloupe", "territory_type_id": 1, "parent_id": 0, "code": "GP"}, {"id": 88, "name": "Guam", "territory_type_id": 1, "parent_id": 0, "code": "GU"}, {"id": 89, "name": "Guatemala", "territory_type_id": 1, "parent_id": 0, "code": "GT"}, {"id": 90, "name": "Guinea", "territory_type_id": 1, "parent_id": 0, "code": "GN"}, {"id": 91, "name": "Guinea-Bissau", "territory_type_id": 1, "parent_id": 0, "code": "GW"}, {"id": 92, "name": "Guyana", "territory_type_id": 1, "parent_id": 0, "code": "GY"}, {"id": 93, "name": "Haiti", "territory_type_id": 1, "parent_id": 0, "code": "HT"}, {"id": 94, "name": "Heard and Mc Donald Islands", "territory_type_id": 1, "parent_id": 0, "code": "HM"}, {"id": 95, "name": "Honduras", "territory_type_id": 1, "parent_id": 0, "code": "HN"}, {"id": 96, "name": "Hong Kong", "territory_type_id": 1, "parent_id": 0, "code": "HK"}, {"id": 97, "name": "Hungary", "territory_type_id": 1, "parent_id": 0, "code": "HU"}, {"id": 98, "name": "Iceland", "territory_type_id": 1, "parent_id": 0, "code": "IS"}, {"id": 99, "name": "India", "territory_type_id": 1, "parent_id": 0, "code": "IN"}, {"id": 100, "name": "Isle of Man", "territory_type_id": 1, "parent_id": 0, "code": "IM"}, {"id": 101, "name": "Indonesia", "territory_type_id": 1, "parent_id": 0, "code": "ID"}, {"id": 102, "name": "Iran", "territory_type_id": 1, "parent_id": 0, "code": "IR"}, {"id": 103, "name": "Iraq", "territory_type_id": 1, "parent_id": 0, "code": "IQ"}, {"id": 104, "name": "Ireland", "territory_type_id": 1, "parent_id": 0, "code": "IE"}, {"id": 105, "name": "Israel", "territory_type_id": 1, "parent_id": 0, "code": "IL"}, {"id": 106, "name": "Italy", "territory_type_id": 1, "parent_id": 0, "code": "IT"}, {"id": 107, "name": "Ivory Coast", "territory_type_id": 1, "parent_id": 0, "code": "CI"}, {"id": 108, "name": "Jersey", "territory_type_id": 1, "parent_id": 0, "code": "JE"}, {"id": 109, "name": "Jamaica", "territory_type_id": 1, "parent_id": 0, "code": "JM"}, {"id": 110, "name": "Japan", "territory_type_id": 1, "parent_id": 0, "code": "JP"}, {"id": 111, "name": "Jordan", "territory_type_id": 1, "parent_id": 0, "code": "JO"}, {"id": 112, "name": "Kazakhstan", "territory_type_id": 1, "parent_id": 0, "code": "KZ"}, {"id": 113, "name": "Kenya", "territory_type_id": 1, "parent_id": 0, "code": "KE"}, {"id": 114, "name": "Kiribati", "territory_type_id": 1, "parent_id": 0, "code": "KI"}, {"id": 115, "name": "North Korea", "territory_type_id": 1, "parent_id": 0, "code": "KP"}, {"id": 116, "name": "South Korea", "territory_type_id": 1, "parent_id": 0, "code": "KR"}, {"id": 117, "name": "Kosovo", "territory_type_id": 1, "parent_id": 0, "code": "XK"}, {"id": 118, "name": "Kuwait", "territory_type_id": 1, "parent_id": 0, "code": "KW"}, {"id": 119, "name": "Kyrgyzstan", "territory_type_id": 1, "parent_id": 0, "code": "KG"}, {"id": 120, "name": "Laos", "territory_type_id": 1, "parent_id": 0, "code": "LA"}, {"id": 121, "name": "Latvia", "territory_type_id": 1, "parent_id": 0, "code": "LV"}, {"id": 122, "name": "Lebanon", "territory_type_id": 1, "parent_id": 0, "code": "LB"}, {"id": 123, "name": "Lesotho", "territory_type_id": 1, "parent_id": 0, "code": "LS"}, {"id": 124, "name": "Liberia", "territory_type_id": 1, "parent_id": 0, "code": "LR"}, {"id": 125, "name": "Libya", "territory_type_id": 1, "parent_id": 0, "code": "LY"}, {"id": 126, "name": "Liechtenstein", "territory_type_id": 1, "parent_id": 0, "code": "LI"}, {"id": 127, "name": "Lithuania", "territory_type_id": 1, "parent_id": 0, "code": "LT"}, {"id": 128, "name": "Luxembourg", "territory_type_id": 1, "parent_id": 0, "code": "LU"}, {"id": 129, "name": "Macau", "territory_type_id": 1, "parent_id": 0, "code": "MO"}, {"id": 130, "name": "Macedonia", "territory_type_id": 1, "parent_id": 0, "code": "MK"}, {"id": 131, "name": "Madagascar", "territory_type_id": 1, "parent_id": 0, "code": "MG"}, {"id": 132, "name": "Malawi", "territory_type_id": 1, "parent_id": 0, "code": "MW"}, {"id": 133, "name": "Malaysia", "territory_type_id": 1, "parent_id": 0, "code": "MY"}, {"id": 134, "name": "Maldives", "territory_type_id": 1, "parent_id": 0, "code": "MV"}, {"id": 135, "name": "Mali", "territory_type_id": 1, "parent_id": 0, "code": "ML"}, {"id": 136, "name": "Malta", "territory_type_id": 1, "parent_id": 0, "code": "MT"}, {"id": 137, "name": "Marshall Islands", "territory_type_id": 1, "parent_id": 0, "code": "MH"}, {"id": 138, "name": "Martinique", "territory_type_id": 1, "parent_id": 0, "code": "MQ"}, {"id": 139, "name": "Mauritania", "territory_type_id": 1, "parent_id": 0, "code": "MR"}, {"id": 140, "name": "Mauritius", "territory_type_id": 1, "parent_id": 0, "code": "MU"}, {"id": 141, "name": "Mayotte", "territory_type_id": 1, "parent_id": 0, "code": "YT"}, {"id": 142, "name": "Mexico", "territory_type_id": 1, "parent_id": 0, "code": "MX"}, {"id": 143, "name": "Federated States of Micronesia", "territory_type_id": 1, "parent_id": 0, "code": "FM"}, {"id": 144, "name": "Moldova", "territory_type_id": 1, "parent_id": 0, "code": "MD"}, {"id": 145, "name": "Monaco", "territory_type_id": 1, "parent_id": 0, "code": "MC"}, {"id": 146, "name": "Mongolia", "territory_type_id": 1, "parent_id": 0, "code": "MN"}, {"id": 147, "name": "Montenegro", "territory_type_id": 1, "parent_id": 0, "code": "ME"}, {"id": 148, "name": "Montserrat", "territory_type_id": 1, "parent_id": 0, "code": "MS"}, {"id": 149, "name": "Morocco", "territory_type_id": 1, "parent_id": 0, "code": "MA"}, {"id": 150, "name": "Mozambique", "territory_type_id": 1, "parent_id": 0, "code": "MZ"}, {"id": 151, "name": "Myanmar", "territory_type_id": 1, "parent_id": 0, "code": "MM"}, {"id": 152, "name": "Namibia", "territory_type_id": 1, "parent_id": 0, "code": "NA"}, {"id": 153, "name": "Nauru", "territory_type_id": 1, "parent_id": 0, "code": "NR"}, {"id": 154, "name": "Nepal", "territory_type_id": 1, "parent_id": 0, "code": "NP"}, {"id": 155, "name": "Netherlands", "territory_type_id": 1, "parent_id": 0, "code": "NL"}, {"id": 156, "name": "Netherlands Antilles", "territory_type_id": 1, "parent_id": 0, "code": "AN"}, {"id": 157, "name": "New Caledonia", "territory_type_id": 1, "parent_id": 0, "code": "NC"}, {"id": 158, "name": "New Zealand", "territory_type_id": 1, "parent_id": 0, "code": "NZ"}, {"id": 159, "name": "Nicaragua", "territory_type_id": 1, "parent_id": 0, "code": "NI"}, {"id": 160, "name": "Niger", "territory_type_id": 1, "parent_id": 0, "code": "NE"}, {"id": 161, "name": "Nigeria", "territory_type_id": 1, "parent_id": 0, "code": "NG"}, {"id": 162, "name": "Niue", "territory_type_id": 1, "parent_id": 0, "code": "NU"}, {"id": 163, "name": "Norfolk Island", "territory_type_id": 1, "parent_id": 0, "code": "NF"}, {"id": 164, "name": "Northern Mariana Islands", "territory_type_id": 1, "parent_id": 0, "code": "MP"}, {"id": 165, "name": "Norway", "territory_type_id": 1, "parent_id": 0, "code": "NO"}, {"id": 166, "name": "Oman", "territory_type_id": 1, "parent_id": 0, "code": "OM"}, {"id": 167, "name": "Pakistan", "territory_type_id": 1, "parent_id": 0, "code": "PK"}, {"id": 168, "name": "Palau", "territory_type_id": 1, "parent_id": 0, "code": "PW"}, {"id": 169, "name": "Palestine", "territory_type_id": 1, "parent_id": 0, "code": "PS"}, {"id": 170, "name": "Panama", "territory_type_id": 1, "parent_id": 0, "code": "PA"}, {"id": 171, "name": "Papua New Guinea", "territory_type_id": 1, "parent_id": 0, "code": "PG"}, {"id": 172, "name": "Paraguay", "territory_type_id": 1, "parent_id": 0, "code": "PY"}, {"id": 173, "name": "Peru", "territory_type_id": 1, "parent_id": 0, "code": "PE"}, {"id": 174, "name": "Philippines", "territory_type_id": 1, "parent_id": 0, "code": "PH"}, {"id": 175, "name": "Pitcairn", "territory_type_id": 1, "parent_id": 0, "code": "PN"}, {"id": 176, "name": "Poland", "territory_type_id": 1, "parent_id": 0, "code": "PL"}, {"id": 177, "name": "Portugal", "territory_type_id": 1, "parent_id": 0, "code": "PT"}, {"id": 178, "name": "Puerto Rico", "territory_type_id": 1, "parent_id": 0, "code": "PR"}, {"id": 179, "name": "Qatar", "territory_type_id": 1, "parent_id": 0, "code": "QA"}, {"id": 180, "name": "Reunion", "territory_type_id": 1, "parent_id": 0, "code": "RE"}, {"id": 181, "name": "Romania", "territory_type_id": 1, "parent_id": 0, "code": "RO"}, {"id": 182, "name": "Russian Federation", "territory_type_id": 1, "parent_id": 0, "code": "RU"}, {"id": 183, "name": "Rwanda", "territory_type_id": 1, "parent_id": 0, "code": "RW"}, {"id": 184, "name": "Saint Kitts and Nevis", "territory_type_id": 1, "parent_id": 0, "code": "KN"}, {"id": 185, "name": "Saint Lucia", "territory_type_id": 1, "parent_id": 0, "code": "LC"}, {"id": 186, "name": "Saint Vincent and the Grenadines", "territory_type_id": 1, "parent_id": 0, "code": "VC"}, {"id": 187, "name": "Samoa", "territory_type_id": 1, "parent_id": 0, "code": "WS"}, {"id": 188, "name": "San Marino", "territory_type_id": 1, "parent_id": 0, "code": "SM"}, {"id": 189, "name": "Sao Tome and Principe", "territory_type_id": 1, "parent_id": 0, "code": "ST"}, {"id": 190, "name": "Saudi Arabia", "territory_type_id": 1, "parent_id": 0, "code": "SA"}, {"id": 191, "name": "Senegal", "territory_type_id": 1, "parent_id": 0, "code": "SN"}, {"id": 192, "name": "Serbia", "territory_type_id": 1, "parent_id": 0, "code": "RS"}, {"id": 193, "name": "Seychelles", "territory_type_id": 1, "parent_id": 0, "code": "SC"}, {"id": 194, "name": "Sierra Leone", "territory_type_id": 1, "parent_id": 0, "code": "SL"}, {"id": 195, "name": "Singapore", "territory_type_id": 1, "parent_id": 0, "code": "SG"}, {"id": 196, "name": "Slovakia", "territory_type_id": 1, "parent_id": 0, "code": "SK"}, {"id": 197, "name": "Slovenia", "territory_type_id": 1, "parent_id": 0, "code": "SI"}, {"id": 198, "name": "Solomon Islands", "territory_type_id": 1, "parent_id": 0, "code": "SB"}, {"id": 199, "name": "Somalia", "territory_type_id": 1, "parent_id": 0, "code": "SO"}, {"id": 200, "name": "South Africa", "territory_type_id": 1, "parent_id": 0, "code": "ZA"}, { "id": 201, "name": "South Georgia South Sandwich Islands", "territory_type_id": 1, "parent_id": 0, "code": "GS", }, {"id": 202, "name": "South Sudan", "territory_type_id": 1, "parent_id": 0, "code": "SS"}, {"id": 203, "name": "Spain", "territory_type_id": 1, "parent_id": 0, "code": "ES"}, {"id": 204, "name": "Sri Lanka", "territory_type_id": 1, "parent_id": 0, "code": "LK"}, {"id": 205, "name": "St. Helena", "territory_type_id": 1, "parent_id": 0, "code": "SH"}, {"id": 206, "name": "St. Pierre and Miquelon", "territory_type_id": 1, "parent_id": 0, "code": "PM"}, {"id": 207, "name": "Sudan", "territory_type_id": 1, "parent_id": 0, "code": "SD"}, {"id": 208, "name": "Suriname", "territory_type_id": 1, "parent_id": 0, "code": "SR"}, {"id": 209, "name": "Svalbard and Jan Mayen Islands", "territory_type_id": 1, "parent_id": 0, "code": "SJ"}, {"id": 210, "name": "Swaziland", "territory_type_id": 1, "parent_id": 0, "code": "SZ"}, {"id": 211, "name": "Sweden", "territory_type_id": 1, "parent_id": 0, "code": "SE"}, {"id": 212, "name": "Switzerland", "territory_type_id": 1, "parent_id": 0, "code": "CH"}, {"id": 213, "name": "Syrian Arab Republic", "territory_type_id": 1, "parent_id": 0, "code": "SY"}, {"id": 214, "name": "Taiwan", "territory_type_id": 1, "parent_id": 0, "code": "TW"}, {"id": 215, "name": "Tajikistan", "territory_type_id": 1, "parent_id": 0, "code": "TJ"}, {"id": 216, "name": "Tanzania", "territory_type_id": 1, "parent_id": 0, "code": "TZ"}, {"id": 217, "name": "Thailand", "territory_type_id": 1, "parent_id": 0, "code": "TH"}, {"id": 218, "name": "Togo", "territory_type_id": 1, "parent_id": 0, "code": "TG"}, {"id": 219, "name": "Tokelau", "territory_type_id": 1, "parent_id": 0, "code": "TK"}, {"id": 220, "name": "Tonga", "territory_type_id": 1, "parent_id": 0, "code": "TO"}, {"id": 221, "name": "Trinidad and Tobago", "territory_type_id": 1, "parent_id": 0, "code": "TT"}, {"id": 222, "name": "Tunisia", "territory_type_id": 1, "parent_id": 0, "code": "TN"}, {"id": 223, "name": "Turkey", "territory_type_id": 1, "parent_id": 0, "code": "TR"}, {"id": 224, "name": "Turkmenistan", "territory_type_id": 1, "parent_id": 0, "code": "TM"}, {"id": 225, "name": "Turks and Caicos Islands", "territory_type_id": 1, "parent_id": 0, "code": "TC"}, {"id": 226, "name": "Tuvalu", "territory_type_id": 1, "parent_id": 0, "code": "TV"}, {"id": 227, "name": "Uganda", "territory_type_id": 1, "parent_id": 0, "code": "UG"}, {"id": 228, "name": "Ukraine", "territory_type_id": 1, "parent_id": 0, "code": "UA"}, {"id": 229, "name": "United Arab Emirates", "territory_type_id": 1, "parent_id": 0, "code": "AE"}, {"id": 230, "name": "United Kingdom", "territory_type_id": 1, "parent_id": 0, "code": "GB"}, {"id": 231, "name": "United States", "territory_type_id": 1, "parent_id": 0, "code": "US"}, { "id": 232, "name": "United States minor outlying islands", "territory_type_id": 1, "parent_id": 0, "code": "UM", }, {"id": 233, "name": "Uruguay", "territory_type_id": 1, "parent_id": 0, "code": "UY"}, {"id": 234, "name": "Uzbekistan", "territory_type_id": 1, "parent_id": 0, "code": "UZ"}, {"id": 235, "name": "Vanuatu", "territory_type_id": 1, "parent_id": 0, "code": "VU"}, {"id": 236, "name": "Vatican City State", "territory_type_id": 1, "parent_id": 0, "code": "VA"}, {"id": 237, "name": "Venezuela", "territory_type_id": 1, "parent_id": 0, "code": "VE"}, {"id": 238, "name": "Vietnam", "territory_type_id": 1, "parent_id": 0, "code": "VN"}, {"id": 239, "name": "Virgin Islands (British)", "territory_type_id": 1, "parent_id": 0, "code": "VG"}, {"id": 240, "name": "Virgin Islands (U.S.)", "territory_type_id": 1, "parent_id": 0, "code": "VI"}, {"id": 241, "name": "Wallis and Futuna Islands", "territory_type_id": 1, "parent_id": 0, "code": "WF"}, {"id": 242, "name": "Western Sahara", "territory_type_id": 1, "parent_id": 0, "code": "EH"}, {"id": 243, "name": "Yemen", "territory_type_id": 1, "parent_id": 0, "code": "YE"}, {"id": 244, "name": "Zaire", "territory_type_id": 1, "parent_id": 0, "code": "ZR"}, {"id": 245, "name": "Zambia", "territory_type_id": 1, "parent_id": 0, "code": "ZM"}, {"id": 246, "name": "Zimbabwe", "territory_type_id": 1, "parent_id": 0, "code": "ZW"}, {"id": 248, "name": "Bonaire, Sint Eustatius and Saba", "territory_type_id": 1, "parent_id": 0, "code": "BQ"}, {"id": 249, "name": "Curasao", "territory_type_id": 1, "parent_id": 0, "code": "CW"}, {"id": 250, "name": "Saint Barthélemy", "territory_type_id": 1, "parent_id": 0, "code": "BL"}, {"id": 251, "name": "Saint Martin (French part)", "territory_type_id": 1, "parent_id": 0, "code": "MF"}, {"id": 252, "name": "Sint Maarten (Dutch part)", "territory_type_id": 1, "parent_id": 0, "code": "SX"}, {"id": 253, "name": "Aland Islands", "territory_type_id": 1, "parent_id": 0, "code": "AX"}, {"id": 254, "name": "Unknown country", "territory_type_id": 1, "parent_id": 0, "code": "ZZ"}, {"id": 255, "name": "Democratic Republic of the Congo", "territory_type_id": 1, "parent_id": 0, "code": "CD"}, ], "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}, ], }