[{"_1":2,"_170":-5,"_171":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","8abab1f3bacc65052d6313ca736f41d897b49791","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_150":151,"_167":168,"_169":-5},"handle","thiagomatsunaga","name","untitled-4533","path","main.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":32,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_149":20},"id","aa086844-8e43-11f0-af74-0224a6c84d84","createdAt",["D",1757508171506],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","f2b2bfd0-f470-11ef-af6d-a9567ab4944b","pinnedFileId","aa0b680a-8e43-11f0-af74-0224a6c84d84","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","f888c66f-a867-4c8c-b3b3-26a295b83efc","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ0YWZWUXZFcFBYQmFBMmZlczlINThEZGlsTiJ9","org",{"_94":95,"_135":132,"_12":112},"avatar","branch",{"_138":139,"_96":44,"_102":140,"_141":103,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":97,"_148":95},"version",4,"aa08ca78-8e43-11f0-af74-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":152,"_96":99,"_153":114,"_154":-5,"_155":140,"_156":139,"_157":116,"_104":158,"_138":159,"_160":161,"_162":163,"_164":20,"_165":-5,"_98":166},"f146afae-8e43-11f0-ac06-0224a6c84d84","fileId","parentId","branchId","branchVersion","latest",["D",1757508291027],3,"fileType","http","content","// thiago.csvToJson on Val Town\n// Features:\n// - Converte CSV -> JSON\n// - Query params: limit, offset, orderBy, order, columns, where, contains\n// - CORS liberado\n// - Erros amigáveis\n\n// Dependência robusta para CSV (sincrona, zero hassle no Val Town):\nimport { parse } from \"npm:csv-parse/sync\";\n\nconst CSV_URL =\n \"https://metabase.tivita.ai/public/question/b423876b-1ebf-4b64-9fc8-fbc08b65b04f.csv\";\n\ntype Order = \"asc\" | \"desc\";\n\nfunction cors(headers: HeadersInit = {}) {\n return {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n ...headers,\n };\n}\n\nfunction parseNumber(q: string | null, fallback: number) {\n if (!q) return fallback;\n const n = Number(q);\n return Number.isFinite(n) && n >= 0 ? n : fallback;\n}\n\nfunction normalizeKey(k: string) {\n // Mantém chave original, mas cria uma alternativa sem acentos/espacos/case para filtros\n return k\n .normalize(\"NFD\")\n .replace(/\\p{Diacritic}/gu, \"\")\n .replace(/\\s+/g, \"_\")\n .toLowerCase();\n}\n\nfunction buildIndexKeys(record: Record) {\n const map = new Map();\n for (const [k, v] of Object.entries(record)) {\n map.set(normalizeKey(k), v);\n }\n return map;\n}\n\nfunction matchesWhere(\n row: Record,\n where: string | null,\n): boolean {\n if (!where) return true;\n // Sintaxe: where=campo=valor&where=outro=valor2 (múltiplos aceitos) ou separado por \";\"\n const parts = where.split(\";\").filter(Boolean);\n if (parts.length === 0) return true;\n const idx = buildIndexKeys(row);\n\n return parts.every((expr) => {\n const [rawKey, ...rest] = expr.split(\"=\");\n if (!rawKey || rest.length === 0) return false;\n const key = normalizeKey(rawKey);\n const expected = rest.join(\"=\");\n const v = idx.get(key);\n return String(v ?? \"\").toLowerCase() === expected.toLowerCase();\n });\n}\n\nfunction matchesContains(\n row: Record,\n contains: string | null,\n): boolean {\n if (!contains) return true;\n // Sintaxe: contains=campo:termo;outro:termo2\n const parts = contains.split(\";\").filter(Boolean);\n if (parts.length === 0) return true;\n const idx = buildIndexKeys(row);\n\n return parts.every((expr) => {\n const [rawKey, ...rest] = expr.split(\":\");\n if (!rawKey || rest.length === 0) return false;\n const key = normalizeKey(rawKey);\n const needle = rest.join(\":\").toLowerCase();\n const v = String(idx.get(key) ?? \"\").toLowerCase();\n return v.includes(needle);\n });\n}\n\nfunction pickColumns(\n row: Record,\n columnsParam: string | null,\n): Record {\n if (!columnsParam) return row;\n const wanted = columnsParam\n .split(\",\")\n .map((c) => c.trim())\n .filter(Boolean);\n if (wanted.length === 0) return row;\n\n // Seleciona pelas chaves originais se bater, senão tenta pelas normalizadas\n const normalizedMap = new Map();\n for (const k of Object.keys(row)) normalizedMap.set(normalizeKey(k), k);\n\n const out: Record = {};\n for (const col of wanted) {\n const exact = row[col];\n if (exact !== undefined) {\n out[col] = exact;\n continue;\n }\n const fallbackKey = normalizedMap.get(normalizeKey(col));\n if (fallbackKey && row[fallbackKey] !== undefined) {\n out[fallbackKey] = row[fallbackKey];\n }\n }\n return out;\n}\n\nfunction sortRows(\n rows: Record[],\n orderBy: string | null,\n order: Order,\n) {\n if (!orderBy) return rows;\n const keyNormalized = normalizeKey(orderBy);\n return rows.sort((a, b) => {\n const ai = buildIndexKeys(a).get(keyNormalized);\n const bi = buildIndexKeys(b).get(keyNormalized);\n // Tenta comparação numérica se ambos forem números\n const an = Number(ai);\n const bn = Number(bi);\n let cmp = 0;\n if (Number.isFinite(an) && Number.isFinite(bn)) {\n cmp = an - bn;\n } else {\n cmp = String(ai ?? \"\").localeCompare(String(bi ?? \"\"), \"pt-BR\", {\n numeric: true,\n sensitivity: \"base\",\n });\n }\n return order === \"asc\" ? cmp : -cmp;\n });\n}\n\nexport default async function (req: Request): Promise {\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: cors() });\n }\n\n try {\n const url = new URL(req.url);\n const limit = parseNumber(url.searchParams.get(\"limit\"), 1000);\n const offset = parseNumber(url.searchParams.get(\"offset\"), 0);\n const orderBy = url.searchParams.get(\"orderBy\");\n const order = (url.searchParams.get(\"order\") ?? \"asc\").toLowerCase() as Order;\n const columns = url.searchParams.get(\"columns\"); // ex: \"colA,colB\"\n const where = url.searchParams.getAll(\"where\").join(\";\"); // permite múltiplos ?where=\n const contains = url.searchParams.get(\"contains\"); // ex: \"nome:ana;cidade:curi\"\n\n // (Opcional) permitir override da origem via ?src=...\n const src = url.searchParams.get(\"src\") ?? CSV_URL;\n\n const resp = await fetch(src, { redirect: \"follow\" });\n if (!resp.ok) {\n return new Response(\n JSON.stringify({ error: \"Falha ao baixar CSV\", status: resp.status }),\n { status: 502, headers: cors({ \"Content-Type\": \"application/json\" }) },\n );\n }\n const csvText = await resp.text();\n\n // Parse robusto com inferência básica\n const records = parse(csvText, {\n columns: true, // usa header da primeira linha\n skip_empty_lines: true,\n bom: true,\n relax_column_count: true,\n trim: true,\n }) as Record[];\n\n // Filtros\n let data = records.filter((r) => matchesWhere(r, where));\n data = data.filter((r) => matchesContains(r, contains));\n\n // Ordenação\n data = sortRows(data, orderBy, order);\n\n // Paginação + seleção de colunas\n const total = data.length;\n const slice = data.slice(offset, offset + limit).map((r) =>\n pickColumns(r, columns)\n );\n\n const result = {\n meta: {\n source: src,\n total,\n limit,\n offset,\n orderBy: orderBy ?? null,\n order,\n columns: columns ? columns.split(\",\").map((c) => c.trim()) : null,\n where: where || null,\n contains: contains || null,\n generatedAt: new Date().toISOString(),\n },\n data: slice,\n };\n\n return new Response(JSON.stringify(result, null, 2), {\n headers: cors({ \"Content-Type\": \"application/json; charset=utf-8\" }),\n });\n } catch (err) {\n return new Response(\n JSON.stringify({\n error: \"Erro inesperado ao processar o CSV\",\n detail: err instanceof Error ? err.message : String(err),\n }),\n { status: 500, headers: cors({ \"Content-Type\": \"application/json\" }) },\n );\n }\n}","deleted","label",[99],"permalink","https://www.val.town/x/thiagomatsunaga/untitled-4533/code/main.ts","extension","actionData","errors"]