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.pulls._index",{"_96":97,"_95":464,"_131":132,"_145":146,"_99":100,"_625":32,"_626":32,"_51":52,"_627":628},{"_99":100,"_96":97,"_101":102,"_103":-5,"_104":-5,"_105":106,"_107":108,"_109":110,"_111":112,"_113":26,"_114":112,"_115":116,"_117":465,"_119":120,"_121":26,"_122":32,"_123":32,"_124":32,"_125":126,"_127":32,"_128":32,"_129":-5,"_20":466,"_135":467,"_142":-7,"_143":144,"_145":146,"_147":468},["D",1740965605362],{"_131":132,"_133":134},{"_114":137,"_131":138,"_99":139,"_119":140,"_141":-5},[469,471,473,475,477,479,481,483,485,487,489,491,493,495,497,499,501,503,505,507,509,511,513,515,517,519,521,523,525,527,529,531,533,535,537,539,541,543,545,547,549,551,553,555,557,559,561,563,565,567,569,571,573,575,577,579,581,583,585,587,589,591,593,595,597,599,601,603,605,607,609,611,613,615,617,619,621,623],{"_119":120,"_150":-5,"_117":470,"_114":112},["D",1740965605362],{"_119":153,"_150":-5,"_117":472,"_114":155},["D",1740965248894],{"_119":157,"_150":-5,"_117":474,"_114":159},["D",1740964806584],{"_119":161,"_150":-5,"_117":476,"_114":163},["D",1740964786537],{"_119":165,"_150":-5,"_117":478,"_114":167},["D",1740964776621],{"_119":169,"_150":-5,"_117":480,"_114":171},["D",1740964766012],{"_119":173,"_150":-5,"_117":482,"_114":175},["D",1740964725350],{"_119":177,"_150":-5,"_117":484,"_114":179},["D",1740964690928],{"_119":181,"_150":-5,"_117":486,"_114":183},["D",1740964663182],{"_119":185,"_150":-5,"_117":488,"_114":187},["D",1740964652023],{"_119":189,"_150":-5,"_117":490,"_114":191},["D",1740964618831],{"_119":193,"_150":-5,"_117":492,"_114":195},["D",1740964592402],{"_119":197,"_150":-5,"_117":494,"_114":199},["D",1740964570597],{"_119":201,"_150":-5,"_117":496,"_114":203},["D",1740964529843],{"_119":205,"_150":-5,"_117":498,"_114":207},["D",1740964492174],{"_119":209,"_150":-5,"_117":500,"_114":211},["D",1740964341058],{"_119":213,"_150":-5,"_117":502,"_114":215},["D",1740963932428],{"_119":217,"_150":-5,"_117":504,"_114":219},["D",1740963911052],{"_119":221,"_150":-5,"_117":506,"_114":223},["D",1740963894368],{"_119":225,"_150":-5,"_117":508,"_114":227},["D",1740963872449],{"_119":229,"_150":-5,"_117":510,"_114":231},["D",1740963838886],{"_119":233,"_150":-5,"_117":512,"_114":235},["D",1740963822350],{"_119":237,"_150":-5,"_117":514,"_114":239},["D",1740963807402],{"_119":241,"_150":-5,"_117":516,"_114":243},["D",1740963776441],{"_119":245,"_150":-5,"_117":518,"_114":247},["D",1740963753416],{"_119":249,"_150":-5,"_117":520,"_114":251},["D",1740963732542],{"_119":253,"_150":-5,"_117":522,"_114":255},["D",1740963722024],{"_119":257,"_150":-5,"_117":524,"_114":259},["D",1740963710566],{"_119":261,"_150":-5,"_117":526,"_114":263},["D",1740963682599],{"_119":265,"_150":-5,"_117":528,"_114":267},["D",1740963598767],{"_119":269,"_150":-5,"_117":530,"_114":271},["D",1740963524484],{"_119":273,"_150":-5,"_117":532,"_114":275},["D",1740963491271],{"_119":277,"_150":-5,"_117":534,"_114":279},["D",1740963481393],{"_119":281,"_150":-5,"_117":536,"_114":283},["D",1740963478704],{"_119":285,"_150":-5,"_117":538,"_114":287},["D",1740963460580],{"_119":289,"_150":-5,"_117":540,"_114":291},["D",1740963446335],{"_119":293,"_150":-5,"_117":542,"_114":295},["D",1740963444875],{"_119":297,"_150":-5,"_117":544,"_114":299},["D",1740960673352],{"_119":301,"_150":-5,"_117":546,"_114":303},["D",1740960618511],{"_119":305,"_150":-5,"_117":548,"_114":307},["D",1740960590061],{"_119":309,"_150":-5,"_117":550,"_114":311},["D",1740960450975],{"_119":313,"_150":-5,"_117":552,"_114":315},["D",1740960438928],{"_119":317,"_150":-5,"_117":554,"_114":319},["D",1740960427781],{"_119":321,"_150":-5,"_117":556,"_114":323},["D",1740960342101],{"_119":325,"_150":-5,"_117":558,"_114":327},["D",1740960311712],{"_119":329,"_150":-5,"_117":560,"_114":331},["D",1740960304006],{"_119":333,"_150":-5,"_117":562,"_114":335},["D",1740960246579],{"_119":337,"_150":-5,"_117":564,"_114":339},["D",1740960213062],{"_119":341,"_150":-5,"_117":566,"_114":343},["D",1740960157358],{"_119":345,"_150":-5,"_117":568,"_114":347},["D",1740959846918],{"_119":349,"_150":-5,"_117":570,"_114":351},["D",1740959843967],{"_119":353,"_150":-5,"_117":572,"_114":355},["D",1740959781632],{"_119":357,"_150":-5,"_117":574,"_114":359},["D",1740959679285],{"_119":361,"_150":-5,"_117":576,"_114":363},["D",1740959632118],{"_119":365,"_150":-5,"_117":578,"_114":367},["D",1740959612251],{"_119":369,"_150":-5,"_117":580,"_114":371},["D",1740959608591],{"_119":373,"_150":-5,"_117":582,"_114":375},["D",1740959385786],{"_119":377,"_150":-5,"_117":584,"_114":379},["D",1740959371346],{"_119":381,"_150":-5,"_117":586,"_114":383},["D",1740959302908],{"_119":385,"_150":-5,"_117":588,"_114":387},["D",1740959299107],{"_119":389,"_150":-5,"_117":590,"_114":391},["D",1740959282195],{"_119":393,"_150":-5,"_117":592,"_114":395},["D",1740959174715],{"_119":397,"_150":-5,"_117":594,"_114":399},["D",1740958967829],{"_119":401,"_150":-5,"_117":596,"_114":403},["D",1740958952833],{"_119":405,"_150":-5,"_117":598,"_114":407},["D",1740958903710],{"_119":409,"_150":-5,"_117":600,"_114":411},["D",1740958897130],{"_119":413,"_150":-5,"_117":602,"_114":415},["D",1740958817878],{"_119":417,"_150":-5,"_117":604,"_114":419},["D",1740958639852],{"_119":421,"_150":-5,"_117":606,"_114":423},["D",1740958632048],{"_119":425,"_150":-5,"_117":608,"_114":427},["D",1740958273999],{"_119":429,"_150":-5,"_117":610,"_114":431},["D",1740958234177],{"_119":433,"_150":-5,"_117":612,"_114":435},["D",1740958207271],{"_119":437,"_150":-5,"_117":614,"_114":439},["D",1740958183276],{"_119":441,"_150":-5,"_117":616,"_114":443},["D",1740958094701],{"_119":126,"_150":-5,"_117":618,"_114":446},["D",1740958065566],{"_119":91,"_150":-5,"_117":620,"_114":449},["D",1740956166394],{"_119":451,"_150":-5,"_117":622,"_114":453},["D",1740956018801],{"_119":32,"_150":-5,"_117":624,"_114":456},["D",1740955754211],"page","count","prs",[],"routes/_app","actionData","errors"]