[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_225":226,"_227":228},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_107":88,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":125,"_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":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",105,"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","saveToDB.ts","latestPath","fileId","a8b42ca6-42a4-11f1-bc0e-42b51c65c3df","name","fileType","http","content","import sqlite from \"https://esm.town/v/std/sqlite@14-main/main.ts\";\n\nexport default async function (request: Request) {\n // extract requested ID from query\n const queryParams = new URL(request.url).searchParams;\n const id = queryParams.get(\"id\");\n const data = queryParams.get(\"data\");\n\n const resSet = await sqlite.execute(\n \"UPDATE data SET contents=? WHERE id=?\",\n [data, id],\n );\n\n // return all info about the record as JSON dobject\n return Response.json(resSet);\n}","import sqlite from \"https://esm.town/v/std/sqlite@14-main/main.ts\";\n\nexport default async function (request: Request) {\n // extract requested ID from query\n const queryParams = new URL(request.url).searchParams;\n const id = queryParams.get(\"id\");\n const data = queryParams.get(\"data\");\n\n const resSet = await sqlite.execute(\n \"UPDATE data SET contents=? WHERE id=?\",\n [data, id],\n );\n console.log(resSet);\n // return all info about the record as JSON dobject\n return Response.json(resSet);\n}","createdAt",["D",1777341743919],"branchVersion","branchId","35f95a76-07c4-11f1-8afc-42dde27851f2","id","35f8fde2-07c4-11f1-8afc-42dde27851f2","database-demo",["D",1770867472565],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","A demo using the built-in SQLite DB to store unique user data","imageUrl","019b8c31-c867-72d0-a0f3-377b0a71335d","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019b8c31-c867-72d0-a0f3-3af4d1c41815","tursoName","35f8fde207c411f18afc42dde27851f2","tursoHostname","35f8fde207c411f18afc42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789518064818],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",114,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ceculbe","handle","displayName","Cory","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zN294dm1HMFFyZ0NhbWJUNmpBeEN3U0s1QWgifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":220,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":221,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":222,"_82":223,"_84":224,"_86":25},"tree",[195,196,197,198,199,200],"files",[195,196,197,198,199,200],"counts",{"_184":61,"_185":186,"_187":186,"_188":189,"_190":191},"contents",[130,131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":177,"_32":178,"_30":179,"_139":-5,"_41":42,"_40":180,"_141":25,"_38":181,"_13":174,"_33":20,"_35":182,"_24":25,"_144":-5,"_27":183},{"_43":169,"_32":170,"_30":171,"_139":-5,"_41":42,"_40":172,"_141":25,"_38":173,"_13":174,"_33":34,"_35":175,"_24":25,"_144":45,"_27":176},{"_43":160,"_32":161,"_30":162,"_139":-5,"_41":42,"_40":163,"_141":125,"_38":164,"_13":165,"_33":34,"_35":166,"_24":25,"_144":167,"_27":168},{"_43":155,"_32":28,"_30":31,"_139":-5,"_41":42,"_40":14,"_141":25,"_38":156,"_13":157,"_33":34,"_35":37,"_24":25,"_144":158,"_27":159},{"_43":146,"_32":147,"_30":148,"_139":-5,"_41":42,"_40":149,"_141":25,"_38":150,"_13":151,"_33":152,"_35":153,"_24":25,"_144":-5,"_27":154},{"_43":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":125,"_38":142,"_13":143,"_33":20,"_35":108,"_24":25,"_144":-5,"_27":145},"83c8990a-4299-11f1-b394-42b51c65c3df","style.css","7b42d00c-4299-11f1-862b-42b51c65c3df","parentId",29,"latest",["D",1777336253346],2,"label",[137],"1827f198-42a6-11f1-8e9f-42b51c65c3df","script.js","04540ebe-4296-11f1-b045-42b51c65c3df",103,["D",1777341656227],37,"script","const id = \"6\";//localStorage.getItem(\"id\");\ngetUserData(id);\n\nasync function getUserData(id: string) {\n // make an HTTP request to the queryDB endpoint for data matching the ID\n // then extract the json data\n // be sure to change the qdb subdomain to your endpoint's subdomain \n // you can find the subdomain in the HTTP settings for queryDB.ts\n const resp = await fetch(\"https://qdb.val.run/?id=\"+id); \n const data = await resp.json(); \n console.log(data);\n console.log(data.rows[0]);\n document.getElementById(\"intro\").innerHTML = \"Hi! Your user ID on this website is: \" + data.rows[0][0];\n document.getElementById(\"data\").innerHTML = \"The data we have stored for you is:
\" + data.rows[0][1];\n}\n\nasync function _save(){\n const textBox = document.getElementById(\"text-in\") as HTMLInputElement;\n const newData = textBox.value;\n const resp = await fetch(\"https://s2db.val.run/?id=\"+id+\",data=\"+newData); \n const data = await resp.json(); \n console.log(data);\n getUserData(id);\n}",[147],"4c6ef870-42a6-11f1-a896-42b51c65c3df",["D",1777341743919],6,"s2db",[28],"5f3906a0-42a4-11f1-938b-42b51c65c3df","queryDB.ts","ed35234a-4294-11f1-ade9-42b51c65c3df",92,["D",1777340916466],38,"import sqlite from \"https://esm.town/v/std/sqlite@14-main/main.ts\";\n\nexport default async function (request: Request) {\n // extract requested ID from query\n const queryParams = new URL(request.url).searchParams;\n const id = queryParams.get(\"id\");\n\n // retrieve record from database if it exists\n let resSet = await sqlite.execute(\"SELECT * FROM data WHERE id=?\", [id]);\n\n // if no record exists, create new record\n if (resSet.rows.length == 0) {\n const ins = await sqlite.execute('INSERT INTO data (contents) VALUES (\"\")');\n const newID = ins.lastInsertRowid;\n // retrieve the new record\n resSet = await sqlite.execute(\"SELECT * FROM data WHERE id=?\", [newID]);\n }\n\n // return all info about the record as JSON dobject\n return Response.json(resSet);\n}","qdb",[161],"c828650a-4297-11f1-aec6-42b51c65c3df","main.ts","35fc6d4c-07c4-11f1-8afc-42dde27851f2",20,["D",1777335509064],8,"import sqlite from \"https://esm.town/v/std/sqlite@14-main/main.ts\";\nimport { staticHTTPServer } from \"https://esm.town/v/std/utils/index.ts\";\nawait sqlite.execute(\n 'CREATE TABLE IF NOT EXISTS \"data\" (\"id\" INTEGER PRIMARY KEY AUTOINCREMENT, \"contents\" TEXT)',\n);\n//await sqlite.execute( 'INSERT INTO \"data\" (\"contents\") VALUES (\"Hello, world!\")',);\n\nexport default staticHTTPServer(import.meta.url);",[170],"84889644-42a1-11f1-b0ab-42b51c65c3df","index.html","438be3aa-4295-11f1-9a42-42b51c65c3df",69,["D",1777339690574],"\n\n \n Database Demo\n \n \n \n \n \n \n

Database Demo

\n If you would like to store new data instead, type it in the text box and\n click Save New Data\n

\n \n \n \n",[178],"pulls","branches",1,"forks","envVars",{"_192":61,"_194":61},"connections",{"_192":61,"_193":61},"count","unfilledCount","emptyCount",{"_43":177,"_32":178,"_30":179,"_139":-5,"_41":42,"_40":180,"_141":25,"_38":217,"_13":174,"_33":20,"_35":182,"_24":25,"_144":-5,"_202":218,"_27":219},{"_43":169,"_32":170,"_30":171,"_139":-5,"_41":42,"_40":172,"_141":25,"_38":214,"_13":174,"_33":34,"_35":175,"_24":25,"_144":45,"_202":215,"_27":216},{"_43":160,"_32":161,"_30":162,"_139":-5,"_41":42,"_40":163,"_141":125,"_38":211,"_13":165,"_33":34,"_35":166,"_24":25,"_144":167,"_202":212,"_27":213},{"_43":155,"_32":28,"_30":31,"_139":-5,"_41":42,"_40":14,"_141":25,"_38":208,"_13":157,"_33":34,"_35":37,"_24":25,"_144":158,"_202":209,"_27":210},{"_43":146,"_32":147,"_30":148,"_139":-5,"_41":42,"_40":149,"_141":25,"_38":205,"_13":151,"_33":152,"_35":153,"_24":25,"_144":-5,"_202":206,"_27":207},{"_43":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":125,"_38":201,"_13":143,"_33":20,"_35":108,"_24":25,"_144":-5,"_202":203,"_27":204},["D",1777336253346],"children",[],[137],["D",1777341656227],[],[147],["D",1777341743919],[],[28],["D",1777340916466],[],[161],["D",1777335509064],[],[170],["D",1777339690574],[],[178],["D",1770867472565],["D",1789518064818],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_127":258,"_259":260,"_261":262,"_263":25,"_264":25,"_265":25,"_266":125,"_267":-5,"_268":-7,"_269":-7,"_270":61,"_271":25,"_272":25,"_273":-5,"_274":25,"_275":25,"_276":25,"_277":-5},"ENV",{"_229":230,"_231":232,"_233":88,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v105