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",1740965605362],"version",77,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",3,"commentCount","prCount","mergedPr",{"_131":132,"_133":134},"handle","netux","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybENxd2U2ZnpaMlJaYzlqMnAyclN4cmRCdmIifQ","forkedVal",{"_114":137,"_131":138,"_99":139,"_119":140,"_141":-5},"651a6c36-f2cd-11ee-9889-cab58f78796a","nbbaier","sqliteDump",147,"prDisabledHint","interval","slug","netux/sqliteDumpHtml","description","SQLite Dump Util Html Last stable version: v77 Fork of nbbaier/sqliteDump with a web interface. A utility function that generates SQL statements to dump the data and schema of tables in a SQLite database. Usage Fork this Val Navigate to https://www.val.town/settings/api and either use an already existing API key or generate a new one. Only User and SQLite Read permissions are required Open URL of your forked Val Paste your API key into the password input Select one or more tables to dump and click on Dump","versions",[149,152,156,160,164,168,172,176,180,184,188,192,196,200,204,208,212,216,220,224,228,232,236,240,244,248,252,256,260,264,268,272,276,280,284,288,292,296,300,304,308,312,316,320,324,328,332,336,340,344,348,352,356,360,364,368,372,376,380,384,388,392,396,400,404,408,412,416,420,424,428,432,436,440,444,447,450,454],{"_119":120,"_150":-5,"_117":151,"_114":112},"prId",["D",1740965605362],{"_119":153,"_150":-5,"_117":154,"_114":155},76,["D",1740965248894],"abc9a870-f7ce-11ef-bb42-569c3dd06744",{"_119":157,"_150":-5,"_117":158,"_114":159},75,["D",1740964806584],"a424dc9e-f7cd-11ef-ba9b-569c3dd06744",{"_119":161,"_150":-5,"_117":162,"_114":163},74,["D",1740964786537],"9832cd74-f7cd-11ef-a497-569c3dd06744",{"_119":165,"_150":-5,"_117":166,"_114":167},73,["D",1740964776621],"9249aa0e-f7cd-11ef-97d1-569c3dd06744",{"_119":169,"_150":-5,"_117":170,"_114":171},72,["D",1740964766012],"8bf78d42-f7cd-11ef-a15c-569c3dd06744",{"_119":173,"_150":-5,"_117":174,"_114":175},71,["D",1740964725350],"73ba6a42-f7cd-11ef-92ae-569c3dd06744",{"_119":177,"_150":-5,"_117":178,"_114":179},70,["D",1740964690928],"5f396942-f7cd-11ef-ad14-569c3dd06744",{"_119":181,"_150":-5,"_117":182,"_114":183},69,["D",1740964663182],"4eac2b64-f7cd-11ef-be59-569c3dd06744",{"_119":185,"_150":-5,"_117":186,"_114":187},68,["D",1740964652023],"48045b10-f7cd-11ef-bc06-569c3dd06744",{"_119":189,"_150":-5,"_117":190,"_114":191},67,["D",1740964618831],"343c5b3c-f7cd-11ef-8da3-569c3dd06744",{"_119":193,"_150":-5,"_117":194,"_114":195},66,["D",1740964592402],"247d54a8-f7cd-11ef-8bce-569c3dd06744",{"_119":197,"_150":-5,"_117":198,"_114":199},65,["D",1740964570597],"177d0622-f7cd-11ef-860a-569c3dd06744",{"_119":201,"_150":-5,"_117":202,"_114":203},64,["D",1740964529843],"ff32e460-f7cc-11ef-ae43-569c3dd06744",{"_119":205,"_150":-5,"_117":206,"_114":207},63,["D",1740964492174],"e8be890a-f7cc-11ef-bc06-569c3dd06744",{"_119":209,"_150":-5,"_117":210,"_114":211},62,["D",1740964341058],"8eacb9b4-f7cc-11ef-9ee8-569c3dd06744",{"_119":213,"_150":-5,"_117":214,"_114":215},61,["D",1740963932428],"9b1c33e2-f7cb-11ef-8aaf-569c3dd06744",{"_119":217,"_150":-5,"_117":218,"_114":219},60,["D",1740963911052],"8e5e8056-f7cb-11ef-96e7-569c3dd06744",{"_119":221,"_150":-5,"_117":222,"_114":223},59,["D",1740963894368],"846f541c-f7cb-11ef-9853-569c3dd06744",{"_119":225,"_150":-5,"_117":226,"_114":227},58,["D",1740963872449],"775cafe0-f7cb-11ef-9ca1-569c3dd06744",{"_119":229,"_150":-5,"_117":230,"_114":231},57,["D",1740963838886],"635ada80-f7cb-11ef-9278-569c3dd06744",{"_119":233,"_150":-5,"_117":234,"_114":235},56,["D",1740963822350],"5984ad7e-f7cb-11ef-a117-569c3dd06744",{"_119":237,"_150":-5,"_117":238,"_114":239},55,["D",1740963807402],"5096c242-f7cb-11ef-9de1-569c3dd06744",{"_119":241,"_150":-5,"_117":242,"_114":243},54,["D",1740963776441],"3e23e81a-f7cb-11ef-a90a-569c3dd06744",{"_119":245,"_150":-5,"_117":246,"_114":247},53,["D",1740963753416],"306a62bc-f7cb-11ef-a6fc-569c3dd06744",{"_119":249,"_150":-5,"_117":250,"_114":251},52,["D",1740963732542],"23f81d8a-f7cb-11ef-831c-569c3dd06744",{"_119":253,"_150":-5,"_117":254,"_114":255},51,["D",1740963722024],"1db52c92-f7cb-11ef-81e0-569c3dd06744",{"_119":257,"_150":-5,"_117":258,"_114":259},50,["D",1740963710566],"16e09e92-f7cb-11ef-ad5c-569c3dd06744",{"_119":261,"_150":-5,"_117":262,"_114":263},49,["D",1740963682599],"06343130-f7cb-11ef-ab82-569c3dd06744",{"_119":265,"_150":-5,"_117":266,"_114":267},48,["D",1740963598767],"d43bd930-f7ca-11ef-8e34-569c3dd06744",{"_119":269,"_150":-5,"_117":270,"_114":271},47,["D",1740963524484],"a7f56ba2-f7ca-11ef-aa54-569c3dd06744",{"_119":273,"_150":-5,"_117":274,"_114":275},46,["D",1740963491271],"9429e4a4-f7ca-11ef-a495-569c3dd06744",{"_119":277,"_150":-5,"_117":278,"_114":279},45,["D",1740963481393],"8e469cc6-f7ca-11ef-b382-569c3dd06744",{"_119":281,"_150":-5,"_117":282,"_114":283},44,["D",1740963478704],"8cab5ece-f7ca-11ef-9020-569c3dd06744",{"_119":285,"_150":-5,"_117":286,"_114":287},43,["D",1740963460580],"81dd0592-f7ca-11ef-9fb0-569c3dd06744",{"_119":289,"_150":-5,"_117":290,"_114":291},42,["D",1740963446335],"79608650-f7ca-11ef-ad94-569c3dd06744",{"_119":293,"_150":-5,"_117":294,"_114":295},41,["D",1740963444875],"7887fb64-f7ca-11ef-9fb0-569c3dd06744",{"_119":297,"_150":-5,"_117":298,"_114":299},40,["D",1740960673352],"048d767c-f7c4-11ef-8c3b-569c3dd06744",{"_119":301,"_150":-5,"_117":302,"_114":303},39,["D",1740960618511],"e3db84b4-f7c3-11ef-a85c-569c3dd06744",{"_119":305,"_150":-5,"_117":306,"_114":307},38,["D",1740960590061],"d2e7fe9e-f7c3-11ef-8c7e-569c3dd06744",{"_119":309,"_150":-5,"_117":310,"_114":311},37,["D",1740960450975],"800469a6-f7c3-11ef-9a4d-569c3dd06744",{"_119":313,"_150":-5,"_117":314,"_114":315},36,["D",1740960438928],"78d2047c-f7c3-11ef-a574-569c3dd06744",{"_119":317,"_150":-5,"_117":318,"_114":319},35,["D",1740960427781],"722d1a94-f7c3-11ef-a57b-569c3dd06744",{"_119":321,"_150":-5,"_117":322,"_114":323},34,["D",1740960342101],"3f1bb566-f7c3-11ef-bffb-569c3dd06744",{"_119":325,"_150":-5,"_117":326,"_114":327},33,["D",1740960311712],"2cfe5ed8-f7c3-11ef-80a9-569c3dd06744",{"_119":329,"_150":-5,"_117":330,"_114":331},32,["D",1740960304006],"2866e430-f7c3-11ef-9911-569c3dd06744",{"_119":333,"_150":-5,"_117":334,"_114":335},31,["D",1740960246579],"062c9806-f7c3-11ef-b357-569c3dd06744",{"_119":337,"_150":-5,"_117":338,"_114":339},30,["D",1740960213062],"f232dd92-f7c2-11ef-9869-569c3dd06744",{"_119":341,"_150":-5,"_117":342,"_114":343},29,["D",1740960157358],"d0fe1506-f7c2-11ef-bb8d-569c3dd06744",{"_119":345,"_150":-5,"_117":346,"_114":347},28,["D",1740959846918],"17f45ade-f7c2-11ef-a147-569c3dd06744",{"_119":349,"_150":-5,"_117":350,"_114":351},27,["D",1740959843967],"16326128-f7c2-11ef-94c7-569c3dd06744",{"_119":353,"_150":-5,"_117":354,"_114":355},26,["D",1740959781632],"f1122cd4-f7c1-11ef-a749-569c3dd06744",{"_119":357,"_150":-5,"_117":358,"_114":359},25,["D",1740959679285],"b409df26-f7c1-11ef-a413-569c3dd06744",{"_119":361,"_150":-5,"_117":362,"_114":363},24,["D",1740959632118],"97edd694-f7c1-11ef-8e0c-569c3dd06744",{"_119":365,"_150":-5,"_117":366,"_114":367},23,["D",1740959612251],"8c15a9f0-f7c1-11ef-8939-569c3dd06744",{"_119":369,"_150":-5,"_117":370,"_114":371},22,["D",1740959608591],"89e6f6c0-f7c1-11ef-be37-569c3dd06744",{"_119":373,"_150":-5,"_117":374,"_114":375},21,["D",1740959385786],"0519876e-f7c1-11ef-99f8-569c3dd06744",{"_119":377,"_150":-5,"_117":378,"_114":379},20,["D",1740959371346],"fc7e0328-f7c0-11ef-ab4f-569c3dd06744",{"_119":381,"_150":-5,"_117":382,"_114":383},19,["D",1740959302908],"d3b37784-f7c0-11ef-8593-569c3dd06744",{"_119":385,"_150":-5,"_117":386,"_114":387},18,["D",1740959299107],"d16fc1b2-f7c0-11ef-8d1a-569c3dd06744",{"_119":389,"_150":-5,"_117":390,"_114":391},17,["D",1740959282195],"c75ac0c8-f7c0-11ef-97ef-569c3dd06744",{"_119":393,"_150":-5,"_117":394,"_114":395},16,["D",1740959174715],"874acbcc-f7c0-11ef-acc2-569c3dd06744",{"_119":397,"_150":-5,"_117":398,"_114":399},15,["D",1740958967829],"0bfa8ae8-f7c0-11ef-a74a-569c3dd06744",{"_119":401,"_150":-5,"_117":402,"_114":403},14,["D",1740958952833],"0309d9f2-f7c0-11ef-92a1-569c3dd06744",{"_119":405,"_150":-5,"_117":406,"_114":407},13,["D",1740958903710],"e5c1c670-f7bf-11ef-9312-569c3dd06744",{"_119":409,"_150":-5,"_117":410,"_114":411},12,["D",1740958897130],"e1d64842-f7bf-11ef-997d-569c3dd06744",{"_119":413,"_150":-5,"_117":414,"_114":415},11,["D",1740958817878],"b2990a06-f7bf-11ef-9312-569c3dd06744",{"_119":417,"_150":-5,"_117":418,"_114":419},10,["D",1740958639852],"487c7752-f7bf-11ef-957f-569c3dd06744",{"_119":421,"_150":-5,"_117":422,"_114":423},9,["D",1740958632048],"43d5fe9e-f7bf-11ef-9ba4-569c3dd06744",{"_119":425,"_150":-5,"_117":426,"_114":427},8,["D",1740958273999],"6e6beff2-f7be-11ef-9de6-569c3dd06744",{"_119":429,"_150":-5,"_117":430,"_114":431},7,["D",1740958234177],"56b02d38-f7be-11ef-a4f6-569c3dd06744",{"_119":433,"_150":-5,"_117":434,"_114":435},6,["D",1740958207271],"46a662fe-f7be-11ef-86a4-569c3dd06744",{"_119":437,"_150":-5,"_117":438,"_114":439},5,["D",1740958183276],"3859d500-f7be-11ef-81d5-569c3dd06744",{"_119":441,"_150":-5,"_117":442,"_114":443},4,["D",1740958094701],"038cfd52-f7be-11ef-9d98-569c3dd06744",{"_119":126,"_150":-5,"_117":445,"_114":446},["D",1740958065566],"f22f96e6-f7bd-11ef-8172-569c3dd06744",{"_119":91,"_150":-5,"_117":448,"_114":449},["D",1740956166394],"8631b162-f7b9-11ef-bea1-569c3dd06744",{"_119":451,"_150":-5,"_117":452,"_114":453},1,["D",1740956018801],"2e3870c2-f7b9-11ef-b5e4-569c3dd06744",{"_119":32,"_150":-5,"_117":455,"_114":456},["D",1740955754211],"90b06288-f7b8-11ef-a721-569c3dd06744","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_94":464,"_465":466,"_95":467},"single","redirect","/v/netux/sqliteDumpHtml/versions",{"_114":195,"_115":468,"_119":193,"_117":469,"_470":100,"_101":102,"_109":110,"_131":132,"_11":97,"_471":-5,"_472":-5,"_473":-5,"_461":26,"_143":144},"/** @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 findClosingParen(str: string, openParenIdx: number) {\n let parenDepth = 0;\n for (let i = openParenIdx + 1; i < str.length; i++) {\n if (str[i] === \"(\") {\n parenDepth++;\n } else if (str[i] === \")\") {\n parenDepth--;\n }\n\n if (parenDepth === 0) {\n return i;\n }\n }\n\n return -1;\n}\n\nfunction prettifyCreateSqlStatement(sql: string) {\n let beforeParens: string;\n let insideParens: string;\n let afterParens: string;\n\n const openParenIdx = sql.indexOf(\"(\");\n if (openParenIdx >= 0) {\n beforeParens = sql.substring(0, openParenIdx + 1);\n\n const closingParenIdx = findClosingParen(sql, openParenIdx);\n if (closingParenIdx >= 0) {\n insideParens = sql.substring(openParenIdx + 1, closingParenIdx);\n afterParens = sql.substring(closingParenIdx);\n\n beforeParens = `${beforeParens}\\n`;\n insideParens = insideParens\n .split(/,\\s*\\n?/)\n .map((insideParensLine) => ` ${insideParensLine.trim()}`)\n .join(\",\\n\");\n afterParens = `\\n${afterParens}`;\n } else {\n insideParens = \"\";\n afterParens = sql.substring(openParenIdx + 1);\n }\n } else {\n beforeParens = sql;\n insideParens = \"\";\n afterParens = \"\";\n }\n\n let result = (beforeParens + insideParens + afterParens).trim();\n\n return result\n .replaceAll(/^\\s*$/gm, \"\")\n .replaceAll(/\\n{2,}/gm, \"\\n\")\n .trim();\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}

sqliteDumpHtml

Version 66