30:T5a1,function groupedSelect(config = {}) { let { value: formValue, title, description, submit, multiple, size, groups } = config; debugger; if (Array.isArray(config)) groups = config; groups = groups.map(g => { if (!g.label) { throw new Error('Undefined label for groupedSelect') } return Object.assign(g, { options: g.options.map( o => (typeof o === "object" ? o : { value: o, label: o }) ) }); }); const form = input({ type: "select", title, description, submit, getValue: input => { const selected = Array.prototype.filter .call(input.options, i => i.selected) .map(i => i.value); return multiple ? selected : selected[0]; }, form: html` ` }); form.output.remove(); return form; }31:[] 2e:{"title":"Utils","cells":[{"id":0,"value":"md`# Utils`","pinned":false,"hidden":false,"mode":"ojs"},{"id":53,"value":"viewof a = storedText({\"key\": \"myStoredTest\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":51,"value":"storedText = (options) => {\n const key = options.key || \"dummyKey\";\n \n const value = window.localStorage.getItem(key) || options.value;\n const form = text({value: value});\n \n form[\"oninput\"] = (e) => {\n e && e.preventDefault();\n const value = form.input.value;\n window.localStorage.setItem(key, value);\n form.value = value;\n //form.dispatchEvent(new CustomEvent(\"input\"));\n };\n \n console.log(form);\n return form;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":42,"value":"text = _text","pinned":false,"hidden":false,"mode":"ojs"},{"id":85,"value":"button = _button","pinned":false,"hidden":false,"mode":"ojs"},{"id":47,"value":"file = _file","pinned":false,"hidden":false,"mode":"ojs"},{"id":95,"value":"viewof item = groupedSelect({\n title: 'Select a nutrient',\n groups: [\n {\n label: 'My Macronutrients',\n options: [{label:'Protein', value:123}]\n },\n {\n label: 'Micronutrients',\n options: ['Thiamine', 'Riboflavin', 'Niacin'],\n disabled: true\n }\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":110,"value":"item","pinned":true,"hidden":false,"mode":"ojs"},{"id":167,"value":"async function getOWIDData(variable) {\n let db = new dbClient.DuckDBClient();\n\n await insertParquetUrl(\n db,\n `https://raw.githubusercontent.com/elaval/owid_data/main/variables/data_${variable}.parquet`,\n \"owidData\"\n );\n\n const q = await db.query(`SELECT * FROM owidData`);\n\n return q.toArray();\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":135,"value":"function insertCSVTable(db, data, tableName) {\n const dataCSV = d3.csvFormat(data);\n const bufferData = new TextEncoder().encode(dataCSV);\n\n return new Promise((resolve, reject) => {\n db.insertCSV(tableName, bufferData)\n .then((d) => resolve(d))\n .catch((err) => reject(err));\n });\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":154,"value":"function insertParquetUrl(db, url, tableName) {\n let internalDB = null;\n\n debugger;\n return new Promise((resolve, reject) => {\n db.db()\n .then((_db) => {\n internalDB = _db;\n return internalDB.registerFileURL(tableName, url);\n })\n .then((dummy) => {\n return db.connection();\n })\n .then((conn) =>\n conn.query(\n `CREATE VIEW ${tableName} AS SELECT * FROM parquet_scan('${tableName}')`\n )\n )\n .then((d) => resolve(db))\n .catch((err) => reject(err));\n });\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":112,"value":"es_ES = ({\n decimal: \",\",\n thousands: \".\",\n grouping: [3],\n currency: [\"$\", \"\"],\n dateTime: \"%a %b %e %X %Y\",\n date: \"%d/%m/%Y\",\n time: \"%H:%M:%S\",\n periods: [\"AM\", \"PM\"],\n days: [\n \"Domingo\",\n \"Lunes\",\n \"Martes\",\n \"Miércoles\",\n \"Jueves\",\n \"Viernes\",\n \"Sábado\"\n ],\n shortDays: [\"Dom\", \"Lun\", \"Mar\", \"Mi\", \"Jue\", \"Vie\", \"Sab\"],\n months: [\n \"Enero\",\n \"Febrero\",\n \"Marzo\",\n \"Abril\",\n \"Mayo\",\n \"Junio\",\n \"Julio\",\n \"Agosto\",\n \"Septiembre\",\n \"Octubre\",\n \"Noviembre\",\n \"Diciembre\"\n ],\n shortMonths: [\n \"Ene\",\n \"Feb\",\n \"Mar\",\n \"Abr\",\n \"May\",\n \"Jun\",\n \"Jul\",\n \"Ago\",\n \"Sep\",\n \"Oct\",\n \"Nov\",\n \"Dic\"\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":114,"value":"function setLocaleD3_ES() {\n d3.formatDefaultLocale(es_ES);\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":117,"value":"function setLocaleMoment_ES() {\n moment.locale(\"es\");\n\n moment.updateLocale(\"es\", {\n weekdays: [\n \"Domingo\",\n \"Lunes\",\n \"Martes\",\n \"Miércoles\",\n \"Jueves\",\n \"Viernes\",\n \"Sábado\"\n ]\n });\n\n moment.updateLocale(\"es\", {\n months: [\n \"Enero\",\n \"Febrero\",\n \"Marzo\",\n \"Abril\",\n \"Mayo\",\n \"Junio\",\n \"Julio\",\n \"Agosto\",\n \"Septiembre\",\n \"Octubre\",\n \"Noviembre\",\n \"Diciembre\"\n ]\n });\n\n moment.updateLocale(\"es\", {\n monthsShort: [\n \"Ene\",\n \"Feb\",\n \"Mar\",\n \"Abr\",\n \"May\",\n \"Jun\",\n \"Jul\",\n \"Ago\",\n \"Sep\",\n \"Oct\",\n \"Nov\",\n \"Dic\"\n ]\n });\n\n moment.updateLocale(\"es\", {\n weekdaysShort: [\"Dom\", \"Lun\", \"Mar\", \"Mie\", \"Jue\", \"Vie\", \"Sab\"]\n });\n\n moment.updateLocale(\"es\", {\n weekdaysMin: [\"Do\", \"Lu\", \"Ma\", \"Mi\", \"Ju\", \"Vi\", \"Sa\"]\n });\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":91,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"import { text as _text, file as _file, button as _button } from \"@jashkenas/inputs\"\n\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":2,"value":"bootstrapContent = d3.text(\"https://stackpath.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":169,"value":"bootstrapContent_5 = d3.text(\n \"https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css\"\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":32,"value":"style_fontawesome = html``\n\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":127,"value":"d3Config = ({\n setLocaleD3_ES: setLocaleD3_ES\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":131,"value":"momentConfig = ({\n setLocaleMoment_ES: setLocaleMoment_ES\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":8,"value":"style_bootstrap = html`\n\n`","pinned":true,"hidden":false,"mode":"ojs"},{"id":173,"value":"style_bootstrap5 = html`\n\n`","pinned":true,"hidden":false,"mode":"ojs"},{"id":25,"value":"html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":93,"value":"import {input} from '@jashkenas/inputs'","pinned":true,"hidden":false,"mode":"ojs"},{"id":16,"value":"_ = require(\"lodash\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":119,"value":"moment = require(\"moment\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":6,"value":"d3 = require(\"d3\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"rxjs = require(\"https://cdnjs.cloudflare.com/ajax/libs/rxjs/6.1.0/rxjs.umd.min.js\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":142,"value":"dbClient = ({\n DuckDBClient: DuckDBClient\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":139,"value":"import { DuckDBClient } from \"@cmudig/duckdb\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":147,"value":"colorSchemes = ({\n vibrant: [\n \"#EE7733\",\n \"#0077BB\",\n \"#33BBEE\",\n \"#EE3377\",\n \"#CC3311\",\n \"#009988\",\n\n \"#BBBBBB\"\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":151,"value":"color = ({\n blue: \"#0077BB\",\n teal: \"#009988\",\n red: \"#CC3311\",\n orange: \"#EE7733\",\n green: \"#228833\"\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":177,"value":"downloadButton = (data, filename = \"data.csv\") => {\n if (!data) throw new Error(\"Array of data required as first argument\");\n\n let downloadData;\n if (filename.includes(\".csv\")) {\n downloadData = new Blob([d3.csvFormat(data)], { type: \"text/csv\" });\n } else if (filename.includes(\".tsv\")) {\n downloadData = new Blob([d3.tsvFormat(data)], { type: \"text/tsv\" });\n } else {\n downloadData = new Blob([JSON.stringify(data, null, 2)], {\n type: \"application/json\"\n });\n }\n\n const size = (downloadData.size / 1024).toFixed(0);\n const button = DOM.download(\n downloadData,\n filename,\n `Download ${filename} (~${size} KB)`\n );\n return button;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":180,"value":"config = ({\n momentConfig: momentConfig,\n d3Config: d3Config\n})","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}