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","label",[18],"pulls","branches","forks","envVars",{"_171":26,"_173":26},"connections",{"_171":26,"_172":26},"count","unfilledCount","emptyCount",{"_32":222,"_13":223,"_65":224,"_42":-5,"_34":35,"_157":39,"_158":143,"_36":225,"_38":26,"_67":21,"_160":226,"_68":24,"_162":-5,"_186":227,"_17":228},{"_32":156,"_13":18,"_65":66,"_42":-5,"_34":35,"_157":39,"_158":143,"_36":219,"_38":26,"_67":21,"_160":161,"_68":24,"_162":-5,"_186":220,"_17":221},{"_32":212,"_13":213,"_65":214,"_42":-5,"_34":35,"_157":39,"_158":143,"_36":215,"_38":26,"_67":201,"_160":216,"_68":24,"_162":-5,"_186":217,"_17":218},{"_32":205,"_13":206,"_65":207,"_42":-5,"_34":35,"_157":39,"_158":143,"_36":208,"_38":26,"_67":201,"_160":209,"_68":24,"_162":-5,"_186":210,"_17":211},{"_32":197,"_13":198,"_65":199,"_42":-5,"_34":35,"_157":39,"_158":143,"_36":200,"_38":26,"_67":201,"_160":202,"_68":24,"_162":-5,"_186":203,"_17":204},{"_32":189,"_13":190,"_65":191,"_42":-5,"_34":35,"_157":39,"_158":143,"_36":192,"_38":26,"_67":193,"_160":194,"_68":24,"_162":-5,"_186":195,"_17":196},{"_32":181,"_13":182,"_65":183,"_42":-5,"_34":35,"_157":39,"_158":143,"_36":184,"_38":26,"_67":21,"_160":185,"_68":24,"_162":-5,"_186":187,"_17":188},"efaf036a-430d-11f1-9ea0-42b51c65c3df","style.css","019dd479-f671-75ba-a271-c1f36cc75c5a",["D",1777386255853],"","children",[],[182],"efaefa32-430d-11f1-9ea0-42b51c65c3df","script.js","019dd479-f671-75ba-a271-be8c09f64607",["D",1777386255853],"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}",[],[190],"efaef064-430d-11f1-9ea0-42b51c65c3df","saveToDB.ts","019dd479-f671-75ba-a271-b96d8477890e",["D",1777386255853],"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}",[],[198],"efaee970-430d-11f1-9ea0-42b51c65c3df","queryDB.ts","019dd479-f671-75ba-a271-b55b9599865a",["D",1777386255853],"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}",[],[206],"efaee330-430d-11f1-9ea0-42b51c65c3df","main.ts","019dd479-f671-75ba-a271-b36c0eeb4adc",["D",1777386255853],"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);",[],[213],["D",1777386255853],[],[18],"efaeba9a-430d-11f1-9ea0-42b51c65c3df","README.md","019dd479-f670-70c9-b07a-82010a7c8ae5",["D",1777386255853],"# database-demo",[],[223],["D",1777386255853],["D",1789499469860],{"_11":12,"_123":71},{"_11":12,"_119":-5,"_70":71,"_30":69,"_120":121,"_122":24},{"_38":39,"_13":16,"_32":35,"_109":73,"_110":62,"_111":63,"_112":77,"_113":114,"_115":116,"_117":14,"_118":12},"ctx",{"_51":-5,"_145":267,"_268":269,"_270":271,"_272":24,"_273":24,"_274":24,"_275":143,"_276":-5,"_277":-7,"_278":-7,"_279":26,"_280":24,"_281":24,"_282":-5,"_283":24,"_284":24,"_285":24,"_286":-5},"ENV",{"_238":239,"_240":241,"_242":16,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266},"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"]

History · index.html