[{"_1":2,"_214":-5,"_215":-5},"loaderData",{"_3":4,"_91":92,"_193":194},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","0f1790570f24c75ae1c9fc99892327093b413003","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",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":22,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":22,"_90":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":22,"_21":22,"_82":72,"_83":84,"_85":72,"_86":45,"_87":22,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_93":94,"_95":96,"_97":-7,"_98":72,"_99":-7,"_100":101,"_146":147,"_169":170,"_171":172,"_181":182,"_186":-5,"_187":-5,"_188":-5,"_189":22,"_190":22,"_191":192},"handle","thiagomatsunaga","name","untitled-4533","branchName","path","version","project",{"_102":103,"_95":96,"_104":105,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":127,"_130":131,"_133":134,"_145":22},"id","aa086844-8e43-11f0-af74-0224a6c84d84","createdAt",["D",1757508171506],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","f2b2bfd0-f470-11ef-af6d-a9567ab4944b","pinnedFileId","pinPreview","screenshotVersion","likeCount","f888c66f-a867-4c8c-b3b3-26a295b83efc","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_128":129},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ0YWZWUXZFcFBYQmFBMmZlczlINThEZGlsTiJ9","org",{"_93":94,"_132":129},"avatar","branch",{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},4,"aa08ca78-8e43-11f0-af74-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[148],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":158,"_99":159,"_160":161,"_162":163,"_164":22,"_165":-5,"_166":167,"_98":168},"f146afae-8e43-11f0-ac06-0224a6c84d84","main.ts","fileId","aa0b680a-8e43-11f0-af74-0224a6c84d84","parentId","branchId","branchVersion","latest",true,["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","children",[],[150],"files",[148],"counts",{"_173":32,"_174":175,"_176":32,"_177":178},"pulls","branches",1,"forks","envVars",{"_179":32,"_180":32},"count","emptyCount","contents",[183],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":184,"_99":159,"_160":161,"_162":163,"_164":22,"_165":-5,"_98":185},["D",1757508291027],[150],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_93":94,"_95":96,"_97":-7,"_99":-7,"_100":195,"_181":200,"_203":-7,"_204":-5,"_205":-5,"_169":206,"_210":211,"_212":-5,"_213":-5},{"_102":103,"_95":96,"_104":196,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":197,"_130":198,"_133":199,"_145":22},["D",1757508171506],{"_93":94,"_128":129},{"_93":94,"_132":129},{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},[201],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":184,"_99":159,"_160":161,"_162":163,"_164":22,"_165":-5,"_98":202},[150],"readme","upstream","pull",[207],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":158,"_99":159,"_160":161,"_162":163,"_164":22,"_165":-5,"_166":208,"_98":209},[],[150],"previews",[207],"ahead","behind","actionData","errors"]