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});","deleted","label",[60],"fc549488-26d8-11f0-a5b3-569c3dd06744","README.md","fc5494f6-26d8-11f0-a5b3-569c3dd06744",1,["D",1740955754211],0,"# 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",[79],{"_35":78,"_13":79,"_61":80,"_63":-5,"_64":65,"_66":81,"_67":68,"_37":92,"_17":83,"_71":24,"_73":84,"_75":48,"_76":-5,"_89":93,"_18":94},{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":31,"_67":68,"_37":88,"_17":70,"_71":72,"_73":74,"_75":48,"_76":-5,"_89":90,"_18":91},["D",1740965605362],"children",[],[60],["D",1740955754211],[],[79],"fc50a18e-26d8-11f0-a5b3-569c3dd06744",["D",1746137383636],"legacyEnvVars","httpPrivacy","description","imageUrl","userId","1f7d9d33-9646-4147-8b94-d2fed28b2e73","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","d9983b5d-99e8-44e7-bbfa-a17f3ab18de0","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_137":133},"org",{"_11":12,"_131":-5,"_132":133,"_101":102,"_134":135,"_136":48},"branch",{"_17":31,"_13":16,"_35":65,"_41":95,"_43":36,"_44":83,"_128":50,"_129":42,"_130":54,"_55":14,"_51":12},"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybENxd2U2ZnpaMlJaYzlqMnAyclN4cmRCdmIifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":95,"_13":14,"_37":181,"_46":-5,"_97":48,"_49":50,"_98":50,"_99":-5,"_100":-5,"_101":102,"_103":62,"_104":68,"_105":-5,"_106":-5,"_107":83,"_53":108,"_109":-5,"_110":-5,"_111":-5,"_112":-5,"_113":114,"_115":114,"_116":117,"_118":117,"_119":117,"_120":114,"_121":114,"_122":182,"_124":183,"_126":184,"_47":48},[175,176],"files",[175,176],"counts",{"_166":83,"_167":81,"_168":83,"_34":169,"_170":171},[162,163],"upstreamProject",{"_35":42,"_13":56,"_99":-5,"_100":-5,"_49":50,"_122":160},"upstreamBranch",{"_35":36,"_37":158,"_39":159,"_13":16,"_41":42,"_17":33,"_43":-5,"_44":-5,"_45":-5,"_46":-5,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1745452163857],["D",1712267447349],{"_11":52,"_137":161},"https://secure.gravatar.com/avatar/0129a541b7b3574e92c4afd06c5e32da&d=identicon",{"_35":78,"_13":79,"_61":80,"_63":-5,"_64":65,"_66":81,"_67":68,"_37":82,"_17":83,"_71":24,"_73":84,"_75":48,"_76":-5,"_18":165},{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":31,"_67":68,"_37":69,"_17":70,"_71":72,"_73":74,"_75":48,"_76":-5,"_18":164},[60],[79],"pulls","branches","forks",{"_172":83,"_174":83},"connections",{"_172":83,"_173":83},"count","unfilledCount","emptyCount",{"_35":78,"_13":79,"_61":80,"_63":-5,"_64":65,"_66":81,"_67":68,"_37":92,"_17":83,"_71":24,"_73":84,"_75":48,"_76":-5,"_89":179,"_18":180},{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":31,"_67":68,"_37":88,"_17":70,"_71":72,"_73":74,"_75":48,"_76":-5,"_89":177,"_18":178},[],[60],[],[79],["D",1746137383636],{"_11":12,"_137":133},{"_11":12,"_131":-5,"_132":133,"_101":102,"_134":135,"_136":48},{"_17":31,"_13":16,"_35":65,"_41":95,"_43":36,"_44":83,"_128":50,"_129":42,"_130":54,"_55":14,"_51":12},"ctx",{"_122":-5,"_155":218,"_219":220,"_221":222,"_223":48,"_224":48,"_225":48,"_226":68,"_227":-5,"_228":-7,"_229":-7,"_230":83,"_231":48,"_232":48,"_233":-5,"_234":48,"_235":48,"_236":48,"_237":-5},"ENV",{"_189":190,"_191":192,"_193":16,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217},"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"]

Code