[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_178":179,"_180":181},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_106":85,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":119,"_120":121,"_122":25,"_123":124,"_125":57,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",49,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","fc549046-26d8-11f0-a5b3-569c3dd06744","name","fileType","http","content","/** @jsx npm:jsx */\n/** @jsxImportSource npm:hono@3/jsx */\n\nimport { passwordAuth } from \"https://esm.town/v/pomdtr/password_auth?v=84\";\nimport { verifyToken } from \"https://esm.town/v/pomdtr/verifyToken\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { Hono } from \"npm:hono\";\nimport type { FC, PropsWithChildren } from \"npm:hono/jsx\";\n\nconst coerceArray = (v: T | T[]): T[] => Array.isArray(v) ? v : [v];\n\nfunction prettifyCreateSqlStatement(sql: string) {\n let result = \"\";\n\n let isInsideParens = false;\n\n for (const line of sql.split(\"\\n\")) {\n if (!isInsideParens) {\n const parenStartIdx = line.indexOf(\"(\");\n if (parenStartIdx < 0) {\n result += `${line}\\n`;\n continue;\n }\n\n result += `${line.slice(0, parenStartIdx + 1)}\\n`;\n isInsideParens = true;\n result += ` ${line.slice(parenStartIdx + 1)}\\n`;\n } else {\n const parenEndIdx = line.indexOf(\")\");\n if (parenEndIdx < 0) {\n result += ` ${line}\\n`;\n continue;\n }\n\n result += ` ${line.slice(0, parenEndIdx)}`;\n isInsideParens = false;\n result += `${line.slice(parenEndIdx)}\\n`;\n }\n }\n\n return result\n .replaceAll(/^\\s*/gm, \"\")\n .replaceAll(/^\\n$/gm, \"\");\n}\n\nasync function getAllDumpableTables() {\n const { rows } = await sqlite.execute(\n \"SELECT name FROM sqlite_schema WHERE type = 'table' AND name NOT LIKE 'sqlite_%'\",\n );\n return rows.map(row => row[0]);\n}\n\nfunction generateInsertStatement(\n tableName: string,\n columns: string[],\n rows: string[][],\n): string {\n const columnNames = columns.join(\", \");\n\n const valuesStr = \"VALUES \";\n const insertStatement = `INSERT INTO ${tableName} (${columnNames})\\n${\n rows.map((row, idx) => {\n const values = row.map(v => `${typeof v === \"string\" ? `'${v.replace(/'/g, \"%27\")}'` : v}`).join(\", \");\n return `${idx === 0 ? valuesStr : \" \".repeat(valuesStr.length)}(${values})`;\n }).join(\",\\n\")\n }`;\n\n return insertStatement;\n}\n\nexport async function sqliteDump(tables?: string[]) {\n const dumpTables = tables !== undefined\n ? tables\n : await getAllDumpableTables();\n\n let statements: string[] = [];\n\n for (const table of dumpTables) {\n const schemaQuery = await sqlite.execute(\n `SELECT name, sql FROM sqlite_schema WHERE name = '${table}'`,\n );\n\n const tableSchema = schemaQuery.rows[0][1] as string;\n const createStatement = prettifyCreateSqlStatement(\n tableSchema.replace(\"CREATE TABLE\", \"CREATE TABLE IF NOT EXISTS\"),\n ).replace(\n /;\\s*$/,\n \"\",\n );\n\n const { columns, rows } = await sqlite.execute(`SELECT * FROM ${table}`);\n const insertStatement = generateInsertStatement(table, columns, rows);\n statements.push(createStatement, insertStatement);\n }\n\n statements.unshift(\"BEGIN TRANSACTION\");\n statements.push(\"COMMIT\");\n\n return statements.map((stmnt) => `${stmnt};`).join(\"\\n\\n\");\n}\n\n// --- //\n\nconst app = new Hono();\n\nconst Layout: FC = (props) => {\n return (\n \n {props.children}\n \n );\n};\n\nconst HomePage: FC<{ tables: string[]; error?: string }> = ({ tables, error }) => (\n \n \n \n\n

Val.Town SQL Dump tables

\n\n {error &&

{error}

Val.Town SQL Dump tables

\n\n {error &&

{error}

}\n\n \n \n);\n\napp.get(\"/\", async (ctx) => {\n const tables = await getAllDumpableTables();\n return ctx.html();\n});\n\napp.post(\"/dump\", async (ctx) => {\n const body = await ctx.req.parseBody();\n const tables = coerceArray(body[\"tables[]\"] as string | string[]);\n\n if (!Array.isArray(tables) || tables.length === 0) {\n const tables = await getAllDumpableTables();\n return ctx.html();\n }\n\n const dump = await sqliteDump(tables);\n return ctx.text(dump, { headers: { \"content-type\": \"text/sql\" } });\n});\n\nexport default passwordAuth(app.fetch, {\n sessionTable: \"sqliteDumpHtml_passwordAuthSession\",\n verifyPassword: verifyToken,\n});","createdAt",["D",1740963598767],"branchVersion","branchId","fc51157e-26d8-11f0-a5b3-569c3dd06744","id","fc50a18e-26d8-11f0-a5b3-569c3dd06744","sqliteDumpHtml",["D",1746137383636],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","1f7d9d33-9646-4147-8b94-d2fed28b2e73","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","d9983b5d-99e8-44e7-bbfa-a17f3ab18de0","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":54,"_102":103,"_104":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":88,"_89":61,"_90":50,"_91":92,"_93":94,"_95":45,"_96":97},"isOwned",78,"main","projectId","forkedBranchId","957fe1e0-209d-11f0-a527-569c3dd06744","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","957f604e-209d-11f0-a527-569c3dd06744","forkedProjectOrgId","5f80108f-7ca4-4327-b77b-089dbe4b5a82","projectName","userHandle","netux","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybENxd2U2ZnpaMlJaYzlqMnAyclN4cmRCdmIifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":174,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":175,"_79":176,"_81":177,"_83":25},"tree",[165,166],"files",[165,166],"counts",{"_155":61,"_156":151,"_157":61,"_158":159,"_160":161},"contents",[139,140],"upstreamProject",{"_43":92,"_32":136,"_52":-5,"_53":-5,"_49":50,"_77":137},"upstreamBranch",{"_43":88,"_38":130,"_131":132,"_32":85,"_86":92,"_13":133,"_87":-5,"_89":-5,"_134":-5,"_47":-5,"_83":25,"_49":50,"_96":135,"_62":94,"_95":136},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1745452163857],"updatedAt",["D",1712267447349],148,"lockfileKey","nbbaier","sqliteDump",{"_98":135,"_105":138},"https://secure.gravatar.com/avatar/0129a541b7b3574e92c4afd06c5e32da&d=identicon",{"_43":148,"_32":149,"_30":150,"_142":-5,"_41":42,"_40":151,"_143":57,"_38":152,"_13":61,"_33":20,"_35":153,"_24":25,"_146":-5,"_27":154},{"_43":141,"_32":28,"_30":31,"_142":-5,"_41":42,"_40":14,"_143":25,"_38":144,"_13":145,"_33":34,"_35":37,"_24":25,"_146":-5,"_27":147},"fd7ad67e-26d8-11f0-a5b3-569c3dd06744","parentId","latest",["D",1740963598767],48,"label",[28],"fc549488-26d8-11f0-a5b3-569c3dd06744","README.md","fc5494f6-26d8-11f0-a5b3-569c3dd06744",1,["D",1740955754211],"# SQLite Dump Util Html\n\n**Last stable version:** v77\n\nFork of [nbbaier/sqliteDump](https://val.town/v/nbbaier/sqliteDump) with a web interface.\n\n> A utility function that generates SQL statements to dump the data and schema of tables in a SQLite database.\n\n## Usage\n\n1. Fork this Val\n3. Navigate to and either use an already existing API key or generate a new one. Only User and SQLite Read permissions are required\n3. Open URL of your forked Val\n4. Paste your API key into the password input\n5. Select one or more tables to dump and click on **Dump**\n",[149],"pulls","branches","forks","envVars",{"_162":61,"_164":61},"connections",{"_162":61,"_163":61},"count","unfilledCount","emptyCount",{"_43":148,"_32":149,"_30":150,"_142":-5,"_41":42,"_40":151,"_143":57,"_38":171,"_13":61,"_33":20,"_35":153,"_24":25,"_146":-5,"_168":172,"_27":173},{"_43":141,"_32":28,"_30":31,"_142":-5,"_41":42,"_40":14,"_143":25,"_38":167,"_13":145,"_33":34,"_35":37,"_24":25,"_146":-5,"_168":169,"_27":170},["D",1740963598767],"children",[],[28],["D",1740955754211],[],[149],["D",1746137383636],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":54,"_102":103,"_104":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":88,"_89":61,"_90":50,"_91":92,"_93":94,"_95":45,"_96":97},"ctx",{"_77":-5,"_127":211,"_212":213,"_214":215,"_216":25,"_217":25,"_218":25,"_219":57,"_220":-5,"_221":-7,"_222":-7,"_223":61,"_224":25,"_225":25,"_226":-5,"_227":25,"_228":25,"_229":25,"_230":-5},"ENV",{"_182":183,"_184":185,"_186":85,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","RENDER_GIT_BRANCH","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v49