[{"_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",21,"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\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 generateInsertStatements(\n tableName: string,\n columns: string[],\n rows: string[][],\n): string[] {\n const columnNames = columns.join(\", \");\n let insertStatements = [];\n\n for (const row of rows) {\n const values = row.map(v => `'${typeof v === \"string\" ? v.replace(/'/g, \"%27\") : v}'`).join(\", \");\n\n const insertStatement = `INSERT INTO ${tableName} (${columnNames}) VALUES (${values});`;\n insertStatements.push(insertStatement);\n }\n\n return insertStatements;\n}\n\nexport async function sqliteDump(\n tables?: string[],\n callback?: (result: string) => string | void | Promise,\n) {\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 = tableSchema.replace(\"CREATE TABLE\", \"CREATE TABLE IF NOT EXISTS\");\n\n const { columns, rows } = await sqlite.execute(`select * from ${table}`);\n const insertStatements = generateInsertStatements(table, columns, rows);\n statements.push(createStatement, ...insertStatements);\n }\n\n if (callback === undefined) {\n callback = (result) => {\n return result;\n };\n }\n\n const result = `BEGIN TRANSACTION;\n${statements.join(\";\\n\").replace(\";;\", \";\")}\nCOMMIT;`;\n\n return callback(result);\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[] }> = ({ tables }) => {\n return (\n \n

Val.Town SQL Dump tables

\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.raw.formData();\n console.log(body.get(\"tables\"));\n // const tables = await getAllDumpableTables();\n // return ctx.html();\n return ctx.text(\"testy\");\n});\n\nexport default passwordAuth(app.fetch, {\n sessionTable: \"sqliteDumpHtml_passwordAuthSession\",\n verifyPassword: verifyToken,\n});","/** @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\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 generateInsertStatements(\n tableName: string,\n columns: string[],\n rows: string[][],\n): string[] {\n const columnNames = columns.join(\", \");\n let insertStatements = [];\n\n for (const row of rows) {\n const values = row.map(v => `'${typeof v === \"string\" ? v.replace(/'/g, \"%27\") : v}'`).join(\", \");\n\n const insertStatement = `INSERT INTO ${tableName} (${columnNames}) VALUES (${values});`;\n insertStatements.push(insertStatement);\n }\n\n return insertStatements;\n}\n\nexport async function sqliteDump(\n tables?: string[],\n callback?: (result: string) => string | void | Promise,\n) {\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 = tableSchema.replace(\"CREATE TABLE\", \"CREATE TABLE IF NOT EXISTS\");\n\n const { columns, rows } = await sqlite.execute(`select * from ${table}`);\n const insertStatements = generateInsertStatements(table, columns, rows);\n statements.push(createStatement, ...insertStatements);\n }\n\n if (callback === undefined) {\n callback = (result) => {\n return result;\n };\n }\n\n const result = `BEGIN TRANSACTION;\n${statements.join(\";\\n\").replace(\";;\", \";\")}\nCOMMIT;`;\n\n return callback(result);\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[] }> = ({ tables }) => {\n return (\n \n

Val.Town SQL Dump tables

\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.raw.formData();\n // console.log(body.get(\"tables\"));\n const body = await ctx.req.parseBody();\n console.log(body.tables);\n // const tables = await getAllDumpableTables();\n // return ctx.html();\n return ctx.text(\"testy\");\n});\n\nexport default passwordAuth(app.fetch, {\n sessionTable: \"sqliteDumpHtml_passwordAuthSession\",\n verifyPassword: verifyToken,\n});","createdAt",["D",1740959371346],"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},"fcc83fbe-26d8-11f0-a5b3-569c3dd06744","parentId","latest",["D",1740959371346],20,"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",1740959371346],"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","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v21