\n \n \n \n",[],[152,211],"89fbaf38-3169-11f1-9094-42dde27851f2","favicon.svg","019d60db-4d3b-744e-a4f9-89ecb6740d40",["D",1775446478026],"\n",[],[152,218],"89fb886e-3169-11f1-9094-42dde27851f2","App.tsx","019d60db-4d3a-758a-85f2-055b8e771277","019d60db-4d3b-744e-a4f9-875ac38dca3b",["D",1775446478026],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function App() {\n const [clicked, setClicked] = useState(0);\n return (\n

Val Town React + Hono Starter

\n I've been clicked times\n

\n );\n}",[],[152,232,225],"components","89fbacb8-3169-11f1-9094-42dde27851f2",["D",1775446478026],[177],[152,232],["D",1775446478026],[176,178,179,180,181,182],[152],"cc34a654-32fc-11f1-974f-42b51c65c3df","db.ts","03d04502-3170-11f1-a5cc-42dde27851f2",25,["D",1775619676352],12,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n//await createTables();\n\nexport async function insertYTUrl(\n url: string,\n title: string | null,\n description: string | null,\n) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO YTLINKS (url, title, description) VALUES(:url, :title, :description)`,\n args: { url, title, description },\n });\n\n // await sqlite.execute({\n // sql: `insert into kv(key, value) values (:key, :value)`,\n // args: { key: \"specialkey\", value: \"specialvalue\" },\n // });\n}\n\nexport async function insertBook(\n title: string,\n author: string | null,\n description: string | null,\n genre: string | null,\n) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO BKLINKS (title, author, description, genre) VALUES (:title, :author, :description, :genre)`,\n args: { title, author, description, genre },\n });\n}\n\nexport async function insertUncommonWord(\n term: string,\n description: string | null,\n notes: string | null,\n) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO UNCOMMON_WORDS (term, description, notes) VALUES (:term, :description, :notes)`,\n args: { term, description, notes },\n });\n}\n\nexport async function insertGHubLink(\n url: string,\n description: string | null,\n) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO GHUB (url, description) VALUES (:url, :description)`,\n args: { url, description },\n });\n}\n\nexport async function createTables() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS YTLINKS (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n url TEXT NOT NULL UNIQUE,\n title TEXT NULL,\n description TEXT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n\n `CREATE TABLE IF NOT EXISTS BKLINKS (\n id INTEGER PRIMARY KEY AUTOINCREMENT, \n title TEXT NOT NULL,\n author TEXT NOT NULL,\n description TEXT NULL,\n genre TEXT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n\n `CREATE TABLE IF NOT EXISTS UNCOMMON_WORDS (\n id INTEGER PRIMARY KEY AUTOINCREMENT, \n term TEXT NOT NULL,\n description TEXT NULL,\n notes TEXT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n /* Add any other tables or migrations you want here\n\n However, you should know that SQLite has much more limited\n support for altering existing tables as compared to other databases.\n Often it's easier to create new tables with the schema you want, and then\n copy the data over. */\n ]);\n}",[],[158,241],["D",1775449252133],[174],[158],["D",1775446478026],["D",1789470042795],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":24},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_126":290,"_291":292,"_293":294,"_295":24,"_296":24,"_297":24,"_298":59,"_299":-5,"_300":-7,"_301":-7,"_302":63,"_303":24,"_304":24,"_305":-5,"_306":24,"_307":24,"_308":24,"_309":-5},"ENV",{"_261":262,"_263":264,"_265":90,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289},"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 · v27