mockNativeFilters.ts 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496
  1. /**
  2. * Licensed to the Apache Software Foundation (ASF) under one
  3. * or more contributor license agreements. See the NOTICE file
  4. * distributed with this work for additional information
  5. * regarding copyright ownership. The ASF licenses this file
  6. * to you under the Apache License, Version 2.0 (the
  7. * "License"); you may not use this file except in compliance
  8. * with the License. You may obtain a copy of the License at
  9. *
  10. * http://www.apache.org/licenses/LICENSE-2.0
  11. *
  12. * Unless required by applicable law or agreed to in writing,
  13. * software distributed under the License is distributed on an
  14. * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  15. * KIND, either express or implied. See the License for the
  16. * specific language governing permissions and limitations
  17. * under the License.
  18. */
  19. import {
  20. DataMaskStateWithId,
  21. ExtraFormData,
  22. NativeFiltersState,
  23. NativeFilterType,
  24. } from '@superset-ui/core';
  25. export const nativeFilters: NativeFiltersState = {
  26. filters: {
  27. 'NATIVE_FILTER-e7Q8zKixx': {
  28. id: 'NATIVE_FILTER-e7Q8zKixx',
  29. name: 'region',
  30. filterType: 'filter_select',
  31. targets: [
  32. {
  33. datasetId: 2,
  34. column: {
  35. name: 'region',
  36. },
  37. },
  38. ],
  39. defaultDataMask: {
  40. filterState: {
  41. value: null,
  42. },
  43. },
  44. cascadeParentIds: [],
  45. scope: {
  46. rootPath: ['ROOT_ID'],
  47. excluded: [],
  48. },
  49. controlValues: {
  50. creatable: false,
  51. multiSelect: false,
  52. enableEmptyFilter: false,
  53. inverseSelection: false,
  54. },
  55. type: NativeFilterType.NativeFilter,
  56. description: '',
  57. chartsInScope: [18],
  58. },
  59. 'NATIVE_FILTER-x9QPw0so1': {
  60. id: 'NATIVE_FILTER-x9QPw0so1',
  61. name: 'country_code',
  62. filterType: 'filter_select',
  63. targets: [
  64. {
  65. datasetId: 2,
  66. column: {
  67. name: 'country_code',
  68. },
  69. },
  70. ],
  71. defaultDataMask: {
  72. filterState: {
  73. value: null,
  74. },
  75. },
  76. cascadeParentIds: [],
  77. scope: {
  78. rootPath: ['ROOT_ID'],
  79. excluded: [],
  80. },
  81. controlValues: {
  82. creatable: false,
  83. multiSelect: false,
  84. enableEmptyFilter: false,
  85. inverseSelection: false,
  86. },
  87. type: NativeFilterType.NativeFilter,
  88. description: '2 letter code',
  89. chartsInScope: [18],
  90. },
  91. },
  92. };
  93. export const dataMaskWith2Filters: DataMaskStateWithId = {
  94. 'NATIVE_FILTER-e7Q8zKixx': {
  95. id: 'NATIVE_FILTER-e7Q8zKixx',
  96. ownState: {},
  97. extraFormData: {
  98. filters: [
  99. {
  100. col: 'region',
  101. op: 'IN',
  102. val: ['East Asia & Pacific'],
  103. },
  104. ],
  105. },
  106. filterState: {
  107. value: ['East Asia & Pacific'],
  108. },
  109. },
  110. 'NATIVE_FILTER-x9QPw0so1': {
  111. id: 'NATIVE_FILTER-x9QPw0so1',
  112. ownState: {},
  113. extraFormData: {},
  114. filterState: {},
  115. },
  116. };
  117. export const extraFormData: ExtraFormData = {
  118. filters: [
  119. {
  120. col: 'ethnic_minority',
  121. op: 'IN',
  122. val: ['No, not an ethnic minority'],
  123. },
  124. ],
  125. };
  126. export const NATIVE_FILTER_ID = 'NATIVE_FILTER-p4LImrSgA';
  127. export const singleNativeFiltersState = {
  128. filters: {
  129. [NATIVE_FILTER_ID]: {
  130. id: [NATIVE_FILTER_ID],
  131. name: 'eth',
  132. type: 'text',
  133. filterType: 'filter_select',
  134. targets: [{ datasetId: 13, column: { name: 'ethnic_minority' } }],
  135. defaultDataMask: {
  136. filterState: {
  137. value: null,
  138. },
  139. },
  140. cascadeParentIds: [],
  141. scope: { rootPath: ['ROOT_ID'], excluded: [227, 229] },
  142. inverseSelection: false,
  143. allowsMultipleValues: false,
  144. isRequired: false,
  145. chartsInScope: [230],
  146. },
  147. },
  148. };
  149. export const dataMaskWith1Filter: DataMaskStateWithId = {
  150. [NATIVE_FILTER_ID]: {
  151. id: NATIVE_FILTER_ID,
  152. extraFormData,
  153. filterState: {
  154. value: ['No, not an ethnic minority'],
  155. },
  156. },
  157. };
  158. export const layoutForSingleNativeFilter = {
  159. 'CHART-ZHVS7YasaQ': {
  160. children: [],
  161. id: 'CHART-ZHVS7YasaQ',
  162. meta: {
  163. chartId: 230,
  164. height: 50,
  165. sliceName: 'Pie Chart',
  166. uuid: '05ef6145-3950-4f59-891f-160852613eca',
  167. width: 12,
  168. },
  169. parents: ['ROOT_ID', 'GRID_ID', 'ROW-NweUz7oC0'],
  170. type: 'CHART',
  171. },
  172. 'CHART-gsGu8NIKQT': {
  173. children: [],
  174. id: 'CHART-gsGu8NIKQT',
  175. meta: {
  176. chartId: 227,
  177. height: 50,
  178. sliceName: 'Another Chart',
  179. uuid: 'ddb78f6c-7876-47fc-ae98-70183b05ba90',
  180. width: 4,
  181. },
  182. parents: ['ROOT_ID', 'GRID_ID', 'ROW-QkiTjeZGs'],
  183. type: 'CHART',
  184. },
  185. 'CHART-hgYjD8axJX': {
  186. children: [],
  187. id: 'CHART-hgYjD8axJX',
  188. meta: {
  189. chartId: 229,
  190. height: 47,
  191. sliceName: 'Bar Chart',
  192. uuid: 'e1501e54-d632-4fdc-ae16-07cafee31093',
  193. width: 12,
  194. },
  195. parents: ['ROOT_ID', 'GRID_ID', 'ROW-mcdVZi0rL'],
  196. type: 'CHART',
  197. },
  198. DASHBOARD_VERSION_KEY: 'v2',
  199. GRID_ID: {
  200. children: ['ROW-mcdVZi0rL', 'ROW-NweUz7oC0', 'ROW-QkiTjeZGs'],
  201. id: 'GRID_ID',
  202. parents: ['ROOT_ID'],
  203. type: 'GRID',
  204. },
  205. HEADER_ID: {
  206. id: 'HEADER_ID',
  207. type: 'HEADER',
  208. meta: { text: 'My Native Filter Dashboard' },
  209. },
  210. ROOT_ID: { children: ['GRID_ID'], id: 'ROOT_ID', type: 'ROOT' },
  211. 'ROW-NweUz7oC0': {
  212. children: ['CHART-ZHVS7YasaQ'],
  213. id: 'ROW-NweUz7oC0',
  214. meta: { background: 'BACKGROUND_TRANSPARENT' },
  215. parents: ['ROOT_ID', 'GRID_ID'],
  216. type: 'ROW',
  217. },
  218. 'ROW-QkiTjeZGs': {
  219. children: ['CHART-gsGu8NIKQT'],
  220. id: 'ROW-QkiTjeZGs',
  221. meta: { background: 'BACKGROUND_TRANSPARENT' },
  222. parents: ['ROOT_ID', 'GRID_ID'],
  223. type: 'ROW',
  224. },
  225. 'ROW-mcdVZi0rL': {
  226. children: ['CHART-hgYjD8axJX'],
  227. id: 'ROW-mcdVZi0rL',
  228. meta: { '0': 'ROOT_ID', background: 'BACKGROUND_TRANSPARENT' },
  229. parents: ['ROOT_ID', 'GRID_ID'],
  230. type: 'ROW',
  231. },
  232. };
  233. export const mockQueryDataForCountries = [
  234. { country_name: 'Afghanistan', 'SUM(SP_POP_TOTL)': 887557752 },
  235. { country_name: 'Albania', 'SUM(SP_POP_TOTL)': 148154320 },
  236. { country_name: 'Algeria', 'SUM(SP_POP_TOTL)': 1317290647 },
  237. { country_name: 'American Samoa', 'SUM(SP_POP_TOTL)': 2294886 },
  238. { country_name: 'Andorra', 'SUM(SP_POP_TOTL)': 2704725 },
  239. { country_name: 'Angola', 'SUM(SP_POP_TOTL)': 641906296 },
  240. { country_name: 'Antigua and Barbuda', 'SUM(SP_POP_TOTL)': 3887170 },
  241. { country_name: 'Argentina', 'SUM(SP_POP_TOTL)': 1728332290 },
  242. { country_name: 'Armenia', 'SUM(SP_POP_TOTL)': 160782905 },
  243. { country_name: 'Aruba', 'SUM(SP_POP_TOTL)': 4048374 },
  244. { country_name: 'Australia', 'SUM(SP_POP_TOTL)': 903260509 },
  245. { country_name: 'Austria', 'SUM(SP_POP_TOTL)': 426785647 },
  246. { country_name: 'Azerbaijan', 'SUM(SP_POP_TOTL)': 374210660 },
  247. { country_name: 'Bahamas, The', 'SUM(SP_POP_TOTL)': 13446111 },
  248. { country_name: 'Bahrain', 'SUM(SP_POP_TOTL)': 29724096 },
  249. { country_name: 'Bangladesh', 'SUM(SP_POP_TOTL)': 5549261462 },
  250. { country_name: 'Barbados', 'SUM(SP_POP_TOTL)': 14146501 },
  251. { country_name: 'Belarus', 'SUM(SP_POP_TOTL)': 524490000 },
  252. { country_name: 'Belgium', 'SUM(SP_POP_TOTL)': 551921585 },
  253. { country_name: 'Belize', 'SUM(SP_POP_TOTL)': 10571460 },
  254. { country_name: 'Benin', 'SUM(SP_POP_TOTL)': 290736360 },
  255. { country_name: 'Bermuda', 'SUM(SP_POP_TOTL)': 3159267 },
  256. { country_name: 'Bhutan', 'SUM(SP_POP_TOTL)': 25987074 },
  257. { country_name: 'Bolivia', 'SUM(SP_POP_TOTL)': 368308373 },
  258. { country_name: 'Bosnia and Herzegovina', 'SUM(SP_POP_TOTL)': 215521543 },
  259. { country_name: 'Botswana', 'SUM(SP_POP_TOTL)': 70510085 },
  260. { country_name: 'Brazil', 'SUM(SP_POP_TOTL)': 7752058955 },
  261. { country_name: 'Brunei Darussalam', 'SUM(SP_POP_TOTL)': 13322318 },
  262. { country_name: 'Bulgaria', 'SUM(SP_POP_TOTL)': 456247765 },
  263. { country_name: 'Burkina Faso', 'SUM(SP_POP_TOTL)': 505122912 },
  264. { country_name: 'Burundi', 'SUM(SP_POP_TOTL)': 305731834 },
  265. { country_name: 'Cabo Verde', 'SUM(SP_POP_TOTL)': 19178461 },
  266. { country_name: 'Cambodia', 'SUM(SP_POP_TOTL)': 523555378 },
  267. { country_name: 'Cameroon', 'SUM(SP_POP_TOTL)': 664127790 },
  268. { country_name: 'Canada', 'SUM(SP_POP_TOTL)': 1470276931 },
  269. { country_name: 'Cayman Islands', 'SUM(SP_POP_TOTL)': 1480956 },
  270. { country_name: 'Central African Republic', 'SUM(SP_POP_TOTL)': 158650217 },
  271. { country_name: 'Chad', 'SUM(SP_POP_TOTL)': 355875809 },
  272. { country_name: 'Channel Islands', 'SUM(SP_POP_TOTL)': 7515697 },
  273. { country_name: 'Chile', 'SUM(SP_POP_TOTL)': 696739897 },
  274. { country_name: 'China', 'SUM(SP_POP_TOTL)': 58345455000 },
  275. { country_name: 'Colombia', 'SUM(SP_POP_TOTL)': 1776189608 },
  276. { country_name: 'Comoros', 'SUM(SP_POP_TOTL)': 22692936 },
  277. { country_name: 'Congo, Dem. Rep.', 'SUM(SP_POP_TOTL)': 2015439254 },
  278. { country_name: 'Congo, Rep.', 'SUM(SP_POP_TOTL)': 130701144 },
  279. { country_name: 'Costa Rica', 'SUM(SP_POP_TOTL)': 163515714 },
  280. { country_name: "Cote d'Ivoire", 'SUM(SP_POP_TOTL)': 634194484 },
  281. { country_name: 'Croatia', 'SUM(SP_POP_TOTL)': 246197511 },
  282. { country_name: 'Cuba', 'SUM(SP_POP_TOTL)': 550461345 },
  283. { country_name: 'Curacao', 'SUM(SP_POP_TOTL)': 7898637 },
  284. { country_name: 'Cyprus', 'SUM(SP_POP_TOTL)': 43711039 },
  285. { country_name: 'Czech Republic', 'SUM(SP_POP_TOTL)': 559416359 },
  286. { country_name: 'Denmark', 'SUM(SP_POP_TOTL)': 283435789 },
  287. { country_name: 'Djibouti', 'SUM(SP_POP_TOTL)': 26324244 },
  288. { country_name: 'Dominica', 'SUM(SP_POP_TOTL)': 3881071 },
  289. { country_name: 'Dominican Republic', 'SUM(SP_POP_TOTL)': 373939753 },
  290. { country_name: 'Ecuador', 'SUM(SP_POP_TOTL)': 537148542 },
  291. { country_name: 'Egypt, Arab Rep.', 'SUM(SP_POP_TOTL)': 2967887581 },
  292. { country_name: 'El Salvador', 'SUM(SP_POP_TOTL)': 266413287 },
  293. { country_name: 'Equatorial Guinea', 'SUM(SP_POP_TOTL)': 22627794 },
  294. { country_name: 'Eritrea', 'SUM(SP_POP_TOTL)': 161125877 },
  295. { country_name: 'Estonia', 'SUM(SP_POP_TOTL)': 77119567 },
  296. { country_name: 'Ethiopia', 'SUM(SP_POP_TOTL)': 2750952916 },
  297. { country_name: 'Faeroe Islands', 'SUM(SP_POP_TOTL)': 2399439 },
  298. { country_name: 'Fiji', 'SUM(SP_POP_TOTL)': 37505227 },
  299. { country_name: 'Finland', 'SUM(SP_POP_TOTL)': 271585488 },
  300. { country_name: 'France', 'SUM(SP_POP_TOTL)': 3151638853 },
  301. { country_name: 'French Polynesia', 'SUM(SP_POP_TOTL)': 9974982 },
  302. { country_name: 'Gabon', 'SUM(SP_POP_TOTL)': 52489952 },
  303. { country_name: 'Gambia, The', 'SUM(SP_POP_TOTL)': 50232086 },
  304. { country_name: 'Georgia', 'SUM(SP_POP_TOTL)': 241070850 },
  305. { country_name: 'Germany', 'SUM(SP_POP_TOTL)': 4361793335 },
  306. { country_name: 'Ghana', 'SUM(SP_POP_TOTL)': 801844889 },
  307. { country_name: 'Greece', 'SUM(SP_POP_TOTL)': 547065293 },
  308. { country_name: 'Greenland', 'SUM(SP_POP_TOTL)': 2807533 },
  309. { country_name: 'Grenada', 'SUM(SP_POP_TOTL)': 5366107 },
  310. { country_name: 'Guam', 'SUM(SP_POP_TOTL)': 6647797 },
  311. { country_name: 'Guatemala', 'SUM(SP_POP_TOTL)': 498361800 },
  312. { country_name: 'Guinea', 'SUM(SP_POP_TOTL)': 362469063 },
  313. { country_name: 'Guinea-Bissau', 'SUM(SP_POP_TOTL)': 58400669 },
  314. { country_name: 'Guyana', 'SUM(SP_POP_TOTL)': 39868752 },
  315. { country_name: 'Haiti', 'SUM(SP_POP_TOTL)': 377521290 },
  316. { country_name: 'Honduras', 'SUM(SP_POP_TOTL)': 257791863 },
  317. { country_name: 'Hong Kong SAR, China', 'SUM(SP_POP_TOTL)': 298353905 },
  318. { country_name: 'Hungary', 'SUM(SP_POP_TOTL)': 566995908 },
  319. { country_name: 'Iceland', 'SUM(SP_POP_TOTL)': 13716537 },
  320. { country_name: 'India', 'SUM(SP_POP_TOTL)': 46023037597 },
  321. { country_name: 'Indonesia', 'SUM(SP_POP_TOTL)': 9357861231 },
  322. { country_name: 'Iran, Islamic Rep.', 'SUM(SP_POP_TOTL)': 2717528355 },
  323. { country_name: 'Iraq', 'SUM(SP_POP_TOTL)': 983604177 },
  324. { country_name: 'Ireland', 'SUM(SP_POP_TOTL)': 196019322 },
  325. { country_name: 'Isle of Man', 'SUM(SP_POP_TOTL)': 3728525 },
  326. { country_name: 'Israel', 'SUM(SP_POP_TOTL)': 263866720 },
  327. { country_name: 'Italy', 'SUM(SP_POP_TOTL)': 3082869665 },
  328. { country_name: 'Jamaica', 'SUM(SP_POP_TOTL)': 124779119 },
  329. { country_name: 'Japan', 'SUM(SP_POP_TOTL)': 6454620759 },
  330. { country_name: 'Jordan', 'SUM(SP_POP_TOTL)': 180850641 },
  331. { country_name: 'Kazakhstan', 'SUM(SP_POP_TOTL)': 797168043 },
  332. { country_name: 'Kenya', 'SUM(SP_POP_TOTL)': 1253201109 },
  333. { country_name: 'Kiribati', 'SUM(SP_POP_TOTL)': 3874990 },
  334. { country_name: 'Korea, Dem. Rep.', 'SUM(SP_POP_TOTL)': 1047335229 },
  335. { country_name: 'Korea, Rep.', 'SUM(SP_POP_TOTL)': 2216456927 },
  336. { country_name: 'Kosovo', 'SUM(SP_POP_TOTL)': 86627232 },
  337. { country_name: 'Kuwait', 'SUM(SP_POP_TOTL)': 84737006 },
  338. { country_name: 'Kyrgyz Republic', 'SUM(SP_POP_TOTL)': 222809200 },
  339. { country_name: 'Lao PDR', 'SUM(SP_POP_TOTL)': 227340983 },
  340. { country_name: 'Latvia', 'SUM(SP_POP_TOTL)': 130544986 },
  341. { country_name: 'Lebanon', 'SUM(SP_POP_TOTL)': 162031498 },
  342. { country_name: 'Lesotho', 'SUM(SP_POP_TOTL)': 81971241 },
  343. { country_name: 'Liberia', 'SUM(SP_POP_TOTL)': 125666085 },
  344. { country_name: 'Libya', 'SUM(SP_POP_TOTL)': 217716251 },
  345. { country_name: 'Liechtenstein', 'SUM(SP_POP_TOTL)': 1527171 },
  346. { country_name: 'Lithuania', 'SUM(SP_POP_TOTL)': 182416949 },
  347. { country_name: 'Luxembourg', 'SUM(SP_POP_TOTL)': 21852156 },
  348. { country_name: 'Macao SAR, China', 'SUM(SP_POP_TOTL)': 18882494 },
  349. { country_name: 'Macedonia, FYR', 'SUM(SP_POP_TOTL)': 104100695 },
  350. { country_name: 'Madagascar', 'SUM(SP_POP_TOTL)': 656478313 },
  351. { country_name: 'Malawi', 'SUM(SP_POP_TOTL)': 470725354 },
  352. { country_name: 'Malaysia', 'SUM(SP_POP_TOTL)': 978122682 },
  353. { country_name: 'Maldives', 'SUM(SP_POP_TOTL)': 11478624 },
  354. { country_name: 'Mali', 'SUM(SP_POP_TOTL)': 500758830 },
  355. { country_name: 'Malta', 'SUM(SP_POP_TOTL)': 19363458 },
  356. { country_name: 'Marshall Islands', 'SUM(SP_POP_TOTL)': 2086174 },
  357. { country_name: 'Mauritania', 'SUM(SP_POP_TOTL)': 113489314 },
  358. { country_name: 'Mauritius', 'SUM(SP_POP_TOTL)': 56066051 },
  359. { country_name: 'Mexico', 'SUM(SP_POP_TOTL)': 4444653964 },
  360. { country_name: 'Micronesia, Fed. Sts.', 'SUM(SP_POP_TOTL)': 4627492 },
  361. { country_name: 'Moldova', 'SUM(SP_POP_TOTL)': 186156257 },
  362. { country_name: 'Monaco', 'SUM(SP_POP_TOTL)': 1595554 },
  363. { country_name: 'Mongolia', 'SUM(SP_POP_TOTL)': 106717826 },
  364. { country_name: 'Montenegro', 'SUM(SP_POP_TOTL)': 31652512 },
  365. { country_name: 'Morocco', 'SUM(SP_POP_TOTL)': 1277441301 },
  366. { country_name: 'Mozambique', 'SUM(SP_POP_TOTL)': 807229371 },
  367. { country_name: 'Myanmar', 'SUM(SP_POP_TOTL)': 2126848982 },
  368. { country_name: 'Namibia', 'SUM(SP_POP_TOTL)': 75238033 },
  369. { country_name: 'Nepal', 'SUM(SP_POP_TOTL)': 1007162709 },
  370. { country_name: 'Netherlands', 'SUM(SP_POP_TOTL)': 803013980 },
  371. { country_name: 'New Caledonia', 'SUM(SP_POP_TOTL)': 9225822 },
  372. { country_name: 'New Zealand', 'SUM(SP_POP_TOTL)': 187593600 },
  373. { country_name: 'Nicaragua', 'SUM(SP_POP_TOTL)': 213048662 },
  374. { country_name: 'Niger', 'SUM(SP_POP_TOTL)': 471910464 },
  375. { country_name: 'Nigeria', 'SUM(SP_POP_TOTL)': 5259800493 },
  376. { country_name: 'Northern Mariana Islands', 'SUM(SP_POP_TOTL)': 2015842 },
  377. { country_name: 'Norway', 'SUM(SP_POP_TOTL)': 233337059 },
  378. { country_name: 'Oman', 'SUM(SP_POP_TOTL)': 93132249 },
  379. { country_name: 'Pakistan', 'SUM(SP_POP_TOTL)': 5696041480 },
  380. { country_name: 'Palau', 'SUM(SP_POP_TOTL)': 833299 },
  381. { country_name: 'Panama', 'SUM(SP_POP_TOTL)': 130974461 },
  382. { country_name: 'Papua New Guinea', 'SUM(SP_POP_TOTL)': 228299012 },
  383. { country_name: 'Paraguay', 'SUM(SP_POP_TOTL)': 221768661 },
  384. { country_name: 'Peru', 'SUM(SP_POP_TOTL)': 1121937313 },
  385. { country_name: 'Philippines', 'SUM(SP_POP_TOTL)': 3272015554 },
  386. { country_name: 'Poland', 'SUM(SP_POP_TOTL)': 1976772515 },
  387. { country_name: 'Portugal', 'SUM(SP_POP_TOTL)': 536945679 },
  388. { country_name: 'Puerto Rico', 'SUM(SP_POP_TOTL)': 181515497 },
  389. { country_name: 'Qatar', 'SUM(SP_POP_TOTL)': 30075210 },
  390. { country_name: 'Romania', 'SUM(SP_POP_TOTL)': 1171333228 },
  391. { country_name: 'Russian Federation', 'SUM(SP_POP_TOTL)': 7667188460 },
  392. { country_name: 'Rwanda', 'SUM(SP_POP_TOTL)': 347121852 },
  393. { country_name: 'Samoa', 'SUM(SP_POP_TOTL)': 8770470 },
  394. { country_name: 'San Marino', 'SUM(SP_POP_TOTL)': 1298411 },
  395. { country_name: 'Sao Tome and Principe', 'SUM(SP_POP_TOTL)': 6169644 },
  396. { country_name: 'Saudi Arabia', 'SUM(SP_POP_TOTL)': 828451525 },
  397. { country_name: 'Senegal', 'SUM(SP_POP_TOTL)': 414475224 },
  398. { country_name: 'Serbia', 'SUM(SP_POP_TOTL)': 186596480 },
  399. { country_name: 'Seychelles', 'SUM(SP_POP_TOTL)': 3761184 },
  400. { country_name: 'Sierra Leone', 'SUM(SP_POP_TOTL)': 203443826 },
  401. { country_name: 'Singapore', 'SUM(SP_POP_TOTL)': 173168000 },
  402. { country_name: 'Sint Maarten (Dutch part)', 'SUM(SP_POP_TOTL)': 597781 },
  403. { country_name: 'Slovak Republic', 'SUM(SP_POP_TOTL)': 276228375 },
  404. { country_name: 'Slovenia', 'SUM(SP_POP_TOTL)': 104119695 },
  405. { country_name: 'Solomon Islands', 'SUM(SP_POP_TOTL)': 16859526 },
  406. { country_name: 'Somalia', 'SUM(SP_POP_TOTL)': 332677926 },
  407. { country_name: 'South Africa', 'SUM(SP_POP_TOTL)': 1871083248 },
  408. { country_name: 'South Sudan', 'SUM(SP_POP_TOTL)': 319024522 },
  409. { country_name: 'Spain', 'SUM(SP_POP_TOTL)': 2115316751 },
  410. { country_name: 'Sri Lanka', 'SUM(SP_POP_TOTL)': 881137000 },
  411. { country_name: 'St. Kitts and Nevis', 'SUM(SP_POP_TOTL)': 2535482 },
  412. { country_name: 'St. Lucia', 'SUM(SP_POP_TOTL)': 7336842 },
  413. { country_name: 'St. Martin (French part)', 'SUM(SP_POP_TOTL)': 1020457 },
  414. {
  415. country_name: 'St. Vincent and the Grenadines',
  416. 'SUM(SP_POP_TOTL)': 5557117,
  417. },
  418. { country_name: 'Sudan', 'SUM(SP_POP_TOTL)': 1118903636 },
  419. { country_name: 'Suriname', 'SUM(SP_POP_TOTL)': 22687861 },
  420. { country_name: 'Swaziland', 'SUM(SP_POP_TOTL)': 42858935 },
  421. { country_name: 'Sweden', 'SUM(SP_POP_TOTL)': 468210684 },
  422. { country_name: 'Switzerland', 'SUM(SP_POP_TOTL)': 369360744 },
  423. { country_name: 'Syrian Arab Republic', 'SUM(SP_POP_TOTL)': 663924524 },
  424. { country_name: 'Tajikistan', 'SUM(SP_POP_TOTL)': 267603756 },
  425. { country_name: 'Tanzania', 'SUM(SP_POP_TOTL)': 1413734053 },
  426. { country_name: 'Thailand', 'SUM(SP_POP_TOTL)': 2827157965 },
  427. { country_name: 'Timor-Leste', 'SUM(SP_POP_TOTL)': 41694123 },
  428. { country_name: 'Togo', 'SUM(SP_POP_TOTL)': 204624027 },
  429. { country_name: 'Tonga', 'SUM(SP_POP_TOTL)': 5038574 },
  430. { country_name: 'Trinidad and Tobago', 'SUM(SP_POP_TOTL)': 62771502 },
  431. { country_name: 'Tunisia', 'SUM(SP_POP_TOTL)': 415992799 },
  432. { country_name: 'Turkey', 'SUM(SP_POP_TOTL)': 2805220683 },
  433. { country_name: 'Turkmenistan', 'SUM(SP_POP_TOTL)': 189687365 },
  434. { country_name: 'Turks and Caicos Islands', 'SUM(SP_POP_TOTL)': 775185 },
  435. { country_name: 'Tuvalu', 'SUM(SP_POP_TOTL)': 466709 },
  436. { country_name: 'Uganda', 'SUM(SP_POP_TOTL)': 987376102 },
  437. { country_name: 'Ukraine', 'SUM(SP_POP_TOTL)': 2657782543 },
  438. { country_name: 'United Arab Emirates', 'SUM(SP_POP_TOTL)': 134952923 },
  439. { country_name: 'United Kingdom', 'SUM(SP_POP_TOTL)': 3169118137 },
  440. { country_name: 'United States', 'SUM(SP_POP_TOTL)': 13604468357 },
  441. { country_name: 'Uruguay', 'SUM(SP_POP_TOTL)': 167612670 },
  442. { country_name: 'Uzbekistan', 'SUM(SP_POP_TOTL)': 1053380227 },
  443. { country_name: 'Vanuatu', 'SUM(SP_POP_TOTL)': 7966814 },
  444. { country_name: 'Venezuela, RB', 'SUM(SP_POP_TOTL)': 1036057583 },
  445. { country_name: 'Vietnam', 'SUM(SP_POP_TOTL)': 3420037000 },
  446. { country_name: 'Virgin Islands (U.S.)', 'SUM(SP_POP_TOTL)': 5006756 },
  447. { country_name: 'West Bank and Gaza', 'SUM(SP_POP_TOTL)': 77390117 },
  448. { country_name: 'Yemen, Rep.', 'SUM(SP_POP_TOTL)': 695646128 },
  449. { country_name: 'Zambia', 'SUM(SP_POP_TOTL)': 438847085 },
  450. { country_name: 'Zimbabwe', 'SUM(SP_POP_TOTL)': 509866860 },
  451. ];
  452. export const buildNativeFilter = (
  453. id: string,
  454. name: string,
  455. dependencies: string[],
  456. ) => ({
  457. id,
  458. controlValues: {
  459. creatable: true,
  460. multiSelect: true,
  461. enableEmptyFilter: false,
  462. defaultToFirstItem: false,
  463. inverseSelection: false,
  464. searchAllOptions: false,
  465. },
  466. name,
  467. filterType: 'filter_select',
  468. targets: [
  469. {
  470. datasetId: 1,
  471. column: {
  472. name,
  473. },
  474. },
  475. ],
  476. defaultDataMask: {
  477. extraFormData: {},
  478. filterState: {},
  479. ownState: {},
  480. },
  481. cascadeParentIds: dependencies,
  482. scope: {
  483. rootPath: ['ROOT_ID'],
  484. excluded: [],
  485. },
  486. type: 'NATIVE_FILTER',
  487. });