[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_211":212,"_213":214},"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",63,"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","queryDB.ts","latestPath","fileId","ed35234a-4294-11f1-ade9-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 requestec ID from query\n const queryParams = new URL(request.url).searchParams;\n const id = queryParams.get(\"id\");\n\n // retrieve record from db if it exists\n const resultSet = await sqlite.execute('SELECT * FROM \"data\" WHERE id=' + id);\n const dataMap = resultSet.rows.map((row) => ({\n id: row[\"id\"] as number,\n contents: row[\"contents\"] as string,\n }));\n const data = [...dataMap.values()];\n const dataJson = JSON.stringify(resultSet);\n console.log(dataJson);\n console.log(dataJson);\n return Response.json(dataJson);\n\n if (data[0] === undefined) {\n console.log(\"no record\");\n return Response.json({ ok: true });\n } else {\n console.log(data[0]);\n return Response.json(data[0]);\n }\n}","import sqlite from \"https://esm.town/v/std/sqlite@14-main/main.ts\";\n\nexport default async function (request: Request) {\n // extract requestec ID from query\n const queryParams = new URL(request.url).searchParams;\n const id = queryParams.get(\"id\");\n\n // retrieve record from db if it exists\n const resultSet = await sqlite.execute('SELECT * FROM \"data\" WHERE id=' + id);\n const dataJson = JSON.stringify(resultSet);\n return Response.json(resultSet);\n\n const dataMap = resultSet.rows.map((row) => ({\n id: row[\"id\"] as number,\n contents: row[\"contents\"] as string,\n }));\n const data = [...dataMap.values()];\n console.log(dataJson);\n console.log(dataJson);\n\n if (data[0] === undefined) {\n console.log(\"no record\");\n return Response.json({ ok: true });\n } else {\n console.log(data[0]);\n return Response.json(data[0]);\n }\n}","createdAt",["D",1777339428550],"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":206,"_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":207,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":208,"_82":209,"_84":210,"_86":25},"tree",[185,186,187,188,189],"files",[185,186,187,188,189],"counts",{"_174":61,"_175":176,"_177":176,"_178":179,"_180":181},"contents",[130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":166,"_32":167,"_30":168,"_138":-5,"_41":42,"_40":169,"_140":25,"_38":170,"_13":171,"_33":20,"_35":172,"_24":25,"_143":-5,"_27":173},{"_43":159,"_32":160,"_30":161,"_138":-5,"_41":42,"_40":156,"_140":25,"_38":162,"_13":163,"_33":34,"_35":164,"_24":25,"_143":45,"_27":165},{"_43":154,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":155,"_13":156,"_33":34,"_35":37,"_24":25,"_143":157,"_27":158},{"_43":145,"_32":146,"_30":147,"_138":-5,"_41":42,"_40":148,"_140":25,"_38":149,"_13":150,"_33":151,"_35":152,"_24":25,"_143":-5,"_27":153},{"_43":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":139,"_140":125,"_38":141,"_13":142,"_33":20,"_35":108,"_24":25,"_143":-5,"_27":144},"83c8990a-4299-11f1-b394-42b51c65c3df","style.css","7b42d00c-4299-11f1-862b-42b51c65c3df","parentId",29,"latest",["D",1777336253346],2,"label",[136],"00fa043a-42a0-11f1-8c11-42b51c65c3df","script.js","04540ebe-4296-11f1-b045-42b51c65c3df",62,["D",1777339040352],21,"script","const id = localStorage.getItem(\"id\");\ndocument.getElementById(\"intro\").innerHTML = \"Hi! Your user ID on this website is: \" + id;\ngetUserData(\"3\");\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(resp);\n return data\n}",[146],"e85bfd1a-42a0-11f1-aefa-42b51c65c3df",["D",1777339428550],20,"qdb",[28],"c828650a-4297-11f1-aec6-42b51c65c3df","main.ts","35fc6d4c-07c4-11f1-8afc-42dde27851f2",["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);",[160],"22a3d050-4298-11f1-b079-42b51c65c3df","index.html","438be3aa-4295-11f1-9a42-42b51c65c3df",23,["D",1777335660868],7,"\n\n \n Database Demo\n \n \n \n \n \n \n

Database Demo

\n \n \n \n",[167],"pulls","branches",1,"forks","envVars",{"_182":61,"_184":61},"connections",{"_182":61,"_183":61},"count","unfilledCount","emptyCount",{"_43":166,"_32":167,"_30":168,"_138":-5,"_41":42,"_40":169,"_140":25,"_38":203,"_13":171,"_33":20,"_35":172,"_24":25,"_143":-5,"_191":204,"_27":205},{"_43":159,"_32":160,"_30":161,"_138":-5,"_41":42,"_40":156,"_140":25,"_38":200,"_13":163,"_33":34,"_35":164,"_24":25,"_143":45,"_191":201,"_27":202},{"_43":154,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":197,"_13":156,"_33":34,"_35":37,"_24":25,"_143":157,"_191":198,"_27":199},{"_43":145,"_32":146,"_30":147,"_138":-5,"_41":42,"_40":148,"_140":25,"_38":194,"_13":150,"_33":151,"_35":152,"_24":25,"_143":-5,"_191":195,"_27":196},{"_43":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":139,"_140":125,"_38":190,"_13":142,"_33":20,"_35":108,"_24":25,"_143":-5,"_191":192,"_27":193},["D",1777336253346],"children",[],[136],["D",1777339040352],[],[146],["D",1777339428550],[],[28],["D",1777335509064],[],[160],["D",1777335660868],[],[167],["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":244,"_245":246,"_247":248,"_249":25,"_250":25,"_251":25,"_252":125,"_253":-5,"_254":-7,"_255":-7,"_256":61,"_257":25,"_258":25,"_259":-5,"_260":25,"_261":25,"_262":25,"_263":-5},"ENV",{"_215":216,"_217":218,"_219":88,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243},"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 · v63