[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_236":237,"_238":239},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_180":-5,"_20":181,"_22":182,"_183":184,"_185":186,"_26":187,"_24":188,"_189":-5,"_190":-5,"_191":51,"_192":193,"_194":43,"_195":-5,"_196":-5,"_197":198},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","ceculbe","name","database-demo","branchName","main","version","path","index.html","project",{"_33":122,"_13":14,"_44":123,"_124":-5,"_125":51,"_126":127,"_128":127,"_129":130,"_131":-5,"_132":133,"_134":-5,"_135":51,"_136":-5,"_137":-5,"_138":118,"_139":140,"_141":142,"_143":144,"_145":146,"_147":-5,"_148":149,"_150":149,"_151":152,"_153":152,"_154":152,"_155":149,"_156":149,"_157":158,"_159":160,"_161":162,"_163":51},"tree",[54,55,56,57,58,59,60],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":53},"contents",[],"upstream","pull","ahead","behind","envVars","id","eb2b3792-42a8-11f1-86ed-42b51c65c3df","fileId","438be3aa-4295-11f1-9a42-42b51c65c3df","parentId","branchId","35f95a76-07c4-11f1-8afc-42dde27851f2","branchVersion",114,"latest",true,"createdAt",["D",1777342869232],9,"fileType","content","\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\n and click Save New Data\n

\n \n \n \n","deleted",false,"label",[19],{"_33":113,"_13":114,"_35":115,"_37":-5,"_38":39,"_40":116,"_42":43,"_44":117,"_17":118,"_47":24,"_48":119,"_50":51,"_52":-5,"_68":120,"_18":121},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":110,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_68":111,"_18":112},{"_33":102,"_13":103,"_35":104,"_37":-5,"_38":39,"_40":105,"_42":43,"_44":106,"_17":46,"_47":87,"_48":107,"_50":51,"_52":14,"_68":108,"_18":109},{"_33":92,"_13":93,"_35":94,"_37":-5,"_38":39,"_40":95,"_42":43,"_44":96,"_17":97,"_47":87,"_48":98,"_50":51,"_52":99,"_68":100,"_18":101},{"_33":81,"_13":82,"_35":83,"_37":-5,"_38":39,"_40":84,"_42":43,"_44":85,"_17":86,"_47":87,"_48":88,"_50":51,"_52":89,"_68":90,"_18":91},{"_33":71,"_13":72,"_35":73,"_37":-5,"_38":39,"_40":74,"_42":43,"_44":75,"_17":76,"_47":77,"_48":78,"_50":51,"_52":-5,"_68":79,"_18":80},{"_33":61,"_13":62,"_35":63,"_37":-5,"_38":39,"_40":64,"_42":43,"_44":65,"_17":66,"_47":24,"_48":67,"_50":51,"_52":-5,"_68":69,"_18":70},"83c8990a-4299-11f1-b394-42b51c65c3df","style.css","7b42d00c-4299-11f1-862b-42b51c65c3df",29,["D",1777336253346],2,"","children",[],[62],"f2ffc2ae-42a7-11f1-ac0f-42b51c65c3df","script.js","04540ebe-4296-11f1-b045-42b51c65c3df",111,["D",1777342452884],41,"script","let id = 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 respJson = await resp.json(); \n console.log(respJson);\n\n // the returned data should be one row of two columns, as set up in main.ts\n id = respJson.rows[0][0];\n const contents = respJson.rows[0][1];\n localStorage.setItem(\"id\", id);\n document.getElementById(\"intro\").innerHTML = \"Hi! Your user ID on this website is: \" + id;\n document.getElementById(\"data\").innerHTML = \"The data we have stored for you is:
\" + contents;\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 respJson = await resp.json();\n // the rowsAffected can be checked to see if the update was successful\n console.log(respJson);\n getUserData(id);\n}",[],[72],"b738516a-42a6-11f1-94d1-42b51c65c3df","saveToDB.ts","a8b42ca6-42a4-11f1-bc0e-42b51c65c3df",108,["D",1777341923085],8,"http","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 const resSet = await sqlite.execute(\n \"UPDATE data SET contents=? WHERE id=?\",\n [data, id],\n );\n // return all info about the record as JSON dobject\n return Response.json(resSet);\n}","s2db",[],[82],"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",[],[93],"00225c1c-42a8-11f1-87cd-42b51c65c3df","main.ts","35fc6d4c-07c4-11f1-8afc-42dde27851f2",112,["D",1777342474887],"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\nexport default staticHTTPServer(import.meta.url);",[],[103],["D",1777342869232],[],[19],"d877c890-42a8-11f1-9c7a-42b51c65c3df","README.md","d877c958-42a8-11f1-9c7a-42b51c65c3df",113,["D",1777342837875],0,"# database-demo",[],[114],"35f8fde2-07c4-11f1-8afc-42dde27851f2",["D",1770867472565],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","A demo using the built-in SQLite DB to store unique user data","imageUrl","userId","019b8c31-c867-72d0-a0f3-377b0a71335d","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019b8c31-c867-72d0-a0f3-3af4d1c41815","tursoName","35f8fde207c411f18afc42dde27851f2","tursoHostname","35f8fde207c411f18afc42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789431052082],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_179":175},"org",{"_11":12,"_172":173,"_174":175,"_132":133,"_176":177,"_178":51},"branch",{"_17":41,"_13":16,"_33":39,"_164":122,"_165":-5,"_166":-5,"_167":-5,"_168":-5,"_169":-5,"_170":14,"_171":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Cory","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zN294dm1HMFFyZ0NhbWJUNmpBeEN3U0s1QWgifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":122,"_13":14,"_44":231,"_124":-5,"_125":51,"_126":127,"_128":127,"_129":130,"_131":-5,"_132":133,"_134":-5,"_135":51,"_136":-5,"_137":-5,"_138":118,"_139":140,"_141":142,"_143":144,"_145":232,"_147":-5,"_148":149,"_150":149,"_151":152,"_153":152,"_154":152,"_155":149,"_156":149,"_157":233,"_159":234,"_161":235,"_163":51},[210,211,212,213,214,215,216],"files",[210,211,212,213,214,215,216],"counts",{"_200":118,"_201":202,"_203":202,"_32":204,"_205":206},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":199},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches",1,"forks",{"_207":118,"_209":118},"connections",{"_207":118,"_208":118},"count","unfilledCount","emptyCount",{"_33":113,"_13":114,"_35":115,"_37":-5,"_38":39,"_40":116,"_42":43,"_44":117,"_17":118,"_47":24,"_48":119,"_50":51,"_52":-5,"_68":229,"_18":230},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":110,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_68":227,"_18":228},{"_33":102,"_13":103,"_35":104,"_37":-5,"_38":39,"_40":105,"_42":43,"_44":106,"_17":46,"_47":87,"_48":107,"_50":51,"_52":14,"_68":225,"_18":226},{"_33":92,"_13":93,"_35":94,"_37":-5,"_38":39,"_40":95,"_42":43,"_44":96,"_17":97,"_47":87,"_48":98,"_50":51,"_52":99,"_68":223,"_18":224},{"_33":81,"_13":82,"_35":83,"_37":-5,"_38":39,"_40":84,"_42":43,"_44":85,"_17":86,"_47":87,"_48":88,"_50":51,"_52":89,"_68":221,"_18":222},{"_33":71,"_13":72,"_35":73,"_37":-5,"_38":39,"_40":74,"_42":43,"_44":75,"_17":76,"_47":77,"_48":78,"_50":51,"_52":-5,"_68":219,"_18":220},{"_33":61,"_13":62,"_35":63,"_37":-5,"_38":39,"_40":64,"_42":43,"_44":65,"_17":66,"_47":24,"_48":67,"_50":51,"_52":-5,"_68":217,"_18":218},[],[62],[],[72],[],[82],[],[93],[],[103],[],[19],[],[114],["D",1770867472565],["D",1789431052082],{"_11":12,"_179":175},{"_11":12,"_172":173,"_174":175,"_132":133,"_176":177,"_178":51},{"_17":41,"_13":16,"_33":39,"_164":122,"_165":-5,"_166":-5,"_167":-5,"_168":-5,"_169":-5,"_170":14,"_171":12},"ctx",{"_157":-5,"_196":269,"_270":271,"_272":273,"_274":51,"_275":51,"_276":51,"_277":43,"_278":-5,"_279":-7,"_280":-7,"_281":118,"_282":51,"_283":51,"_284":-5,"_285":51,"_286":51,"_287":51,"_288":-5},"ENV",{"_240":241,"_242":243,"_244":16,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268},"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"]