[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_285":286,"_287":288},"routes/_app.x.$handle.$name",{"_105":104,"_37":50,"_113":95,"_32":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":30,"_128":129,"_130":64,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":30},"version",56,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","2e0f3215-4eae-41ff-b7b0-6edf80e90884","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","backend/daily-report-cron.ts","latestPath","fileId","5dce1bd6-37c1-11f1-ab09-42b51c65c3df","name","daily-report-cron.ts","fileType","interval","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport default async function (interval: Interval) {\n // -------------------------------------------------------\n // TODO: Replace this query with your own\n // Available tables: BKLINKS, GHUB, UNCOMMON_WORDS, YTLINKS\n // -------------------------------------------------------\n const result = await sqlite.execute(`\n SELECT * FROM BKLINKS LIMIT 10\n `);\n\n // Build markdown content from query results\n const now = new Date().toISOString().split(\"T\")[0]; // YYYY-MM-DD\n const rows = result.rows as Record[];\n\n let md = `# Daily Report\\n\\n_Generated: ${now}_\\n\\n`;\n\n if (rows.length === 0) {\n md += \"_No data found._\\n\";\n } else {\n const columns = result.columns;\n\n // Table header\n md += `| ${columns.join(\" | \")} |\\n`;\n md += `| ${columns.map(() => \"---\").join(\" | \")} |\\n`;\n\n // Table rows\n for (const row of rows) {\n const cells = columns.map((col) => String(row[col] ?? \"\"));\n md += `| ${cells.join(\" | \")} |\\n`;\n }\n }\n\n // Write (overwrite) the file in the frontend folder\n const response = await fetch(\n \"https://api.val.town/v2/vals/89f035d6-3169-11f1-9094-42dde27851f2/files?path=frontend%2Fdaily_report.md\",\n {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${Deno.env.get(\"valtown\")}`,\n \"Content-Type\": \"application/octet-stream\",\n \"X-Val-Town-Op\": \"write\",\n },\n body: md,\n },\n );\n\n if (!response.ok) {\n const text = await response.text();\n throw new Error(`Failed to write daily_report.md: ${response.status} ${text}`);\n }\n\n console.log(`daily_report.md written successfully (${rows.length} rows)`);\n}\n","createdAt",["D",1776143906710],"branchVersion","branchId","89f88876-3169-11f1-9094-42dde27851f2","id","89f035d6-3169-11f1-9094-42dde27851f2","khacks",["D",1775446478026],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Personal hacks","imageUrl","019d3acb-4266-73d5-b8a9-93ce4f16a9b3","pinnedFileId","019d60db-4d3b-744e-a4f9-a1cd54af5feb","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019d3acb-4266-73d5-b8a9-96af6d3b07cc","tursoName","89f035d6316911f1909442dde27851f2","tursoHostname","89f035d6316911f1909442dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789470042795],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_112":108},"org",{"_105":104,"_106":-5,"_107":108,"_19":60,"_109":110,"_111":30},"branch",{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",215,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","KMan","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzNCZDkxUG1lV2dqZEV1N1ljYXFxVUM1Ull2bSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_37":50,"_43":280,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":281,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":282,"_89":283,"_91":284,"_93":30},"tree",[179,182,191,192],"files",[179,180,181,182,183,184,185,186,187,188,189,190,191,192],"counts",{"_169":68,"_170":153,"_171":68,"_172":173,"_174":175},"contents",[135,136,137,138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":163,"_37":164,"_35":165,"_141":-5,"_46":47,"_45":166,"_143":64,"_43":167,"_13":153,"_39":161,"_41":-5,"_29":30,"_148":-5,"_32":168},{"_48":157,"_37":158,"_35":159,"_141":-5,"_46":47,"_45":153,"_143":64,"_43":160,"_13":68,"_39":161,"_41":-5,"_29":30,"_148":-5,"_32":162},{"_48":150,"_37":151,"_35":152,"_141":-5,"_46":47,"_45":153,"_143":64,"_43":154,"_13":68,"_39":26,"_41":155,"_29":30,"_148":-5,"_32":156},{"_48":139,"_37":140,"_35":62,"_141":-5,"_46":47,"_45":142,"_143":30,"_43":144,"_13":145,"_39":146,"_41":147,"_29":30,"_148":50,"_32":149},"251c5b84-36ba-11f1-841d-42b51c65c3df","index.ts","parentId",55,"latest",["D",1776030853749],15,"http","import { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\nimport {\n getUncommonWords,\n insertBook,\n insertUncommonWord,\n insertYTUrl,\n} from \"./backend/db.ts\";\n\nimport { fetch } from \"https://esm.town/v/std/fetch\";\n\nconst app = new Hono();\n\n// Serve index.html at the root /\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\n// Serve all /frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// Add your API routes here\n// app.get(\"/api/data\", c => c.json({ hello: \"world\" }));\n\napp.post(\"/books\", async (c) => {\n try {\n // Parse JSON body\n const body = await c.req.json().catch(() => null);\n\n // Validate input\n if (!body || typeof body !== \"object\") {\n return c.json({ error: \"Request body must be a valid JSON object\" }, 400);\n }\n\n if (!body.title || typeof body.title !== \"string\") {\n return c.json({\n error: \"Request must include a 'title' property with a string value\",\n }, 400);\n }\n\n if (body.title.trim() === \"\") {\n return c.json({ error: \"Message cannot be empty\" }, 400);\n }\n\n insertBook(\n body.title,\n body.author,\n body.description ?? null,\n body.genre ?? null,\n );\n\n // Return the newly created phrase\n return c.json({\n message: \"Book saved successfully\",\n yturl: body.title,\n }, 200);\n } catch (error) {\n console.error(\"Error adding books:\", error);\n return c.json({ error: \"Failed to books\" }, 500);\n }\n});\n\napp.get(\"/uncommon\", async (c) => {\n return c.json(await getUncommonWords());\n});\n\napp.post(\"/uncommon\", async (c) => {\n try {\n // Parse JSON body\n const body = await c.req.json().catch(() => null);\n\n // Validate input\n if (!body || typeof body !== \"object\") {\n return c.json({ error: \"Request body must be a valid JSON object\" }, 400);\n }\n\n if (!body.term || typeof body.term !== \"string\") {\n return c.json({\n error: \"Request must include a 'term' property with a string value\",\n }, 400);\n }\n\n if (body.term.trim() === \"\") {\n return c.json({ error: \"Term cannot be empty\" }, 400);\n }\n\n await insertUncommonWord(\n body.term,\n body.description ?? null,\n body.notes ?? null,\n );\n\n return c.json({\n message: \"Uncommon phrase saved successfully\",\n yturl: body.term,\n }, 200);\n } catch (error) {\n console.error(\"Error adding uncommon phrase:\", error);\n return c.json({ error: \"Failed to save the phrase\" }, 500);\n }\n});\n\napp.post(\"/ytube\", async (c) => {\n //await ensureTableExists();\n\n try {\n // Parse JSON body\n const body = await c.req.json().catch(() => null);\n\n // Validate input\n if (!body || typeof body !== \"object\") {\n return c.json({ error: \"Request body must be a valid JSON object\" }, 400);\n }\n\n if (!body.url || typeof body.url !== \"string\") {\n return c.json({\n error: \"Request must include a 'url' property with a string value\",\n }, 400);\n }\n\n if (body.url.trim() === \"\") {\n return c.json({ error: \"Message cannot be empty\" }, 400);\n }\n\n //https://www.youtube.com/oembed?url=\n const data = await fetch(\n `https://www.youtube.com/oembed?url=${body.url}&format=json`,\n );\n const jsonData = await data.json();\n\n insertYTUrl(body.url.trim(), jsonData.title, body.description ?? null);\n\n // Return the newly created phrase\n return c.json({\n message: \"YT Url saved successfully\",\n yturl: jsonData.title,\n }, 201);\n } catch (error) {\n console.error(\"Error adding YT url:\", error);\n return c.json({ error: \"Failed to save YT url\" }, 500);\n }\n});\n\napp.get(\"/testing\", (c) => {\n const val = parseVal(import.meta.url);\n console.log(val);\n\n const val_id = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n console.log(\"Val id is \", val_id);\n\n return c.json({\n hello: \"world\",\n baseUrl: c.req.url.replace(c.req.path, \"\"),\n \"import.meta.url\": import.meta.url,\n });\n});\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;","label",[140],"89fbc892-3169-11f1-9094-42dde27851f2","README.md","019d60db-4d3b-744e-a4f9-9d1d6b380c62",1,["D",1775446478026],"# React Hono Starter\n\nThis app is a starter template for client-side React and server-side Hono.\n\n## Getting started\n\nGet a copy of this starter template by clicking the **Remix** button in the\ntop-right.\n\n## How it works\n\n- The **entrypoint** is [`index.ts`](index.ts). That's the backend HTTP server,\n which also serves the all the frontend assets.\n\n- The **client-side entrypoint** is\n [`/frontend/index.html`](/frontend/index.html)\n - which in turn imports [`/frontend/index.tsx`](/frontend/index.tsx)\n - which in turn imports the React app from\n [`/frontend/components/App.tsx`](/frontend/components/App.tsx).\n\nSo if you wanted to get a sense of how this app comes together, we suggest\nreading the files in this order:\n\n[`index.ts`](index.ts) -> [`/frontend/index.html`](/frontend/index.html) ->\n[`/frontend/index.tsx`](/frontend/index.tsx) ->\n[`/frontend/components/App.tsx`](/frontend/components/App.tsx)\n\n## Further resources\n\n- [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) is a\n bigger example project, with a SQLite database table, queries, client-side\n CSS, a favicon, and shared code that runs on both client and server.",[151],"89fbc75c-3169-11f1-9094-42dde27851f2","frontend","019d60db-4d3b-744e-a4f9-99649d93cb85",["D",1775446478026],"directory",[158],"ff6af6c4-316f-11f1-88b8-42dde27851f2","backend","fd9c88d0-316f-11f1-ae4b-42dde27851f2",3,["D",1775449252133],[164],"pulls","branches","forks","envVars",{"_176":153,"_178":68},"connections",{"_176":68,"_177":68},"count","unfilledCount","emptyCount",{"_48":163,"_37":164,"_35":165,"_141":-5,"_46":47,"_45":166,"_143":64,"_43":277,"_13":153,"_39":161,"_41":-5,"_29":30,"_148":-5,"_194":278,"_32":279},{"_48":273,"_37":38,"_35":36,"_141":165,"_46":47,"_45":14,"_143":30,"_43":274,"_13":68,"_39":40,"_41":42,"_29":30,"_148":-5,"_194":275,"_32":276},{"_48":265,"_37":266,"_35":267,"_141":165,"_46":47,"_45":268,"_143":30,"_43":269,"_13":145,"_39":213,"_41":270,"_29":30,"_148":-5,"_194":271,"_32":272},{"_48":157,"_37":158,"_35":159,"_141":-5,"_46":47,"_45":153,"_143":64,"_43":262,"_13":68,"_39":161,"_41":-5,"_29":30,"_148":-5,"_194":263,"_32":264},{"_48":258,"_37":250,"_35":243,"_141":159,"_46":47,"_45":153,"_143":64,"_43":259,"_13":68,"_39":161,"_41":-5,"_29":30,"_148":-5,"_194":260,"_32":261},{"_48":251,"_37":252,"_35":253,"_141":243,"_46":47,"_45":153,"_143":64,"_43":254,"_13":68,"_39":213,"_41":255,"_29":30,"_148":-5,"_194":256,"_32":257},{"_48":240,"_37":241,"_35":242,"_141":243,"_46":47,"_45":244,"_143":30,"_43":245,"_13":246,"_39":213,"_41":247,"_29":30,"_148":-5,"_194":248,"_32":249},{"_48":231,"_37":232,"_35":233,"_141":159,"_46":47,"_45":234,"_143":64,"_43":235,"_13":236,"_39":26,"_41":237,"_29":30,"_148":-5,"_194":238,"_32":239},{"_48":224,"_37":225,"_35":226,"_141":159,"_46":47,"_45":153,"_143":64,"_43":227,"_13":68,"_39":26,"_41":228,"_29":30,"_148":-5,"_194":229,"_32":230},{"_48":217,"_37":218,"_35":219,"_141":159,"_46":47,"_45":153,"_143":30,"_43":220,"_13":68,"_39":26,"_41":221,"_29":30,"_148":-5,"_194":222,"_32":223},{"_48":207,"_37":208,"_35":209,"_141":159,"_46":47,"_45":210,"_143":64,"_43":211,"_13":212,"_39":213,"_41":214,"_29":30,"_148":-5,"_194":215,"_32":216},{"_48":200,"_37":201,"_35":202,"_141":159,"_46":47,"_45":153,"_143":64,"_43":203,"_13":68,"_39":26,"_41":204,"_29":30,"_148":-5,"_194":205,"_32":206},{"_48":150,"_37":151,"_35":152,"_141":-5,"_46":47,"_45":153,"_143":64,"_43":197,"_13":68,"_39":26,"_41":155,"_29":30,"_148":-5,"_194":198,"_32":199},{"_48":139,"_37":140,"_35":62,"_141":-5,"_46":47,"_45":142,"_143":30,"_43":193,"_13":145,"_39":146,"_41":147,"_29":30,"_148":50,"_194":195,"_32":196},["D",1776030853749],"children",[],[140],["D",1775446478026],[],[151],"89fbc446-3169-11f1-9094-42dde27851f2","style.css","019d60db-4d3b-744e-a4f9-9411665e62ef",["D",1775446478026],"body {\n font-family: -apple-system, Arial, sans-serif;\n color: #333;\n padding: 20px;\n}\n\nbutton {\n background-color: #4a90e2;\n color: white;\n border: none;\n padding: 8px 16px;\n border-radius: 4px;\n cursor: pointer;\n}\n\nbutton:hover {\n background-color: #357ae8;\n}",[],[158,201],"7a89b578-3618-11f1-b5e5-42b51c65c3df","index.tsx","019d60db-4d3b-744e-a4f9-93129402de20",49,["D",1775961418801],4,"script","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n//import { App } from \"./components/App.tsx\";\nimport { CommonNotesApp } from \"./components/CommonNotes.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[158,208],"89fbb550-3169-11f1-9094-42dde27851f2","index.html","019d60db-4d3b-744e-a4f9-8e243d39f3d6",["D",1775446478026],"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",[],[158,218],"89fbaf38-3169-11f1-9094-42dde27851f2","favicon.svg","019d60db-4d3b-744e-a4f9-89ecb6740d40",["D",1775446478026],"\n",[],[158,225],"5d897788-3613-11f1-8bd3-42b51c65c3df","Common.html","d62c0fb4-3610-11f1-acce-42b51c65c3df",41,["D",1775959222663],5,"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n\n \n \n \n",[],[158,232],"cb1786d8-3621-11f1-8a91-42b51c65c3df","CommonNotes.tsx","24262f88-3611-11f1-95c2-42b51c65c3df","019d60db-4d3b-744e-a4f9-875ac38dca3b",52,["D",1775965419420],10,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, {\n useEffect,\n useRef,\n useState,\n} from \"https://esm.sh/react@18.2.0\";\n\ntype Note = {\n id: number;\n term: string;\n};\n\nconst BATCH_SIZE = 50;\n\nconst COLORS = [\n \"#FFF9A6\",\n \"#FFE0AC\",\n \"#FFCCD5\",\n \"#D5F5E3\",\n \"#D6EAF8\",\n \"#E8DAEF\",\n];\n\nfunction randomColor() {\n return COLORS[Math.floor(Math.random() * COLORS.length)];\n}\n\nexport function CommonNotesApp() {\n const [notes, setNotes] = useState([]);\n const [index, setIndex] = useState(0);\n const [batchStart, setBatchStart] = useState(0);\n const [color, setColor] = useState(randomColor());\n\n const touchStartX = useRef(0);\n const touchEndX = useRef(0);\n\n /* ---------------- FETCH DATA ---------------- */\n\n async function fetchNotes() {\n const url = `https://khacks.val.run/uncommon`;\n const urlx =\n `https://jsonplaceholder.typicode.com/posts?_start=${batchStart}&_limit=${BATCH_SIZE}`;\n\n const res = await fetch(url);\n const data: Note[] = await res.json();\n\n setNotes((prev) => [...prev, ...data]);\n setBatchStart((prev) => prev + BATCH_SIZE);\n }\n\n /* ---------------- INIT ---------------- */\n\n useEffect(() => {\n fetchNotes();\n }, []);\n\n useEffect(() => {\n window.addEventListener(\"keydown\", handleKeyDown);\n return () => window.removeEventListener(\"keydown\", handleKeyDown);\n }, [index]);\n\n /* ---------------- SWIPE HANDLERS ---------------- */\n\n function handleTouchStart(e: React.TouchEvent) {\n touchStartX.current = e.changedTouches[0].screenX;\n }\n\n function handleTouchEnd(e: React.TouchEvent) {\n touchEndX.current = e.changedTouches[0].screenX;\n handleSwipe();\n }\n\n function handleKeyDown(e: KeyboardEvent) {\n if (e.key === \"ArrowRight\") {\n const nextIndex = index + 1;\n setIndex(nextIndex);\n setColor(randomColor());\n\n if (nextIndex % BATCH_SIZE === 0) {\n fetchNotes();\n }\n }\n\n if (e.key === \"ArrowLeft\" && index > 0) {\n setIndex((prev) => prev - 1);\n setColor(randomColor());\n }\n }\n\n function handleSwipe() {\n const delta = touchEndX.current - touchStartX.current;\n\n // Swipe right\n if (delta > 40) {\n const nextIndex = index + 1;\n setIndex(nextIndex);\n setColor(randomColor());\n\n // Fetch every 10 right swipes\n if (nextIndex % BATCH_SIZE === 0) {\n fetchNotes();\n }\n }\n\n // Swipe left\n if (delta < -40 && index > 0) {\n setIndex((prev) => prev - 1);\n setColor(randomColor());\n }\n }\n\n const note = notes[index];\n\n return (\n

\n \n

\n {note ? note.term : \"Loading...\"}\n

\n \n );\n}\n\n/* ---------------- STYLES ---------------- */\n\nconst styles: { [key: string]: React.CSSProperties } = {\n app: {\n height: \"100vh\",\n display: \"flex\",\n alignItems: \"center\",\n justifyContent: \"center\",\n background: \"#f0f0f0\",\n },\n note: {\n width: \"85%\",\n minHeight: \"240px\",\n padding: \"20px\",\n borderRadius: \"12px\",\n boxShadow: \"0 10px 20px rgba(0,0,0,0.15)\",\n display: \"flex\",\n alignItems: \"center\",\n justifyContent: \"center\",\n textAlign: \"center\",\n fontSize: \"2.2rem\",\n transition: \"background-color 0.3s ease, transform 0.3s ease\",\n },\n text: {\n margin: 0,\n userSelect: \"none\",\n },\n};\n\n/* ---------------- MOUNT ---------------- */\n\n// const container = document.getElementById(\"root\");\n// if (!container) {\n// throw new Error(\"Root container missing\");\n// }\n\n// const root = createRoot(container);\n// root.render();",[],[158,250,241],"components","89fb886e-3169-11f1-9094-42dde27851f2","App.tsx","019d60db-4d3a-758a-85f2-055b8e771277",["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}",[],[158,250,252],"89fbacb8-3169-11f1-9094-42dde27851f2",["D",1775446478026],[184,185],[158,250],["D",1775446478026],[183,186,187,188,189,190],[158],"af014920-3617-11f1-ace9-42b51c65c3df","db.ts","03d04502-3170-11f1-a5cc-42dde27851f2",47,["D",1775961077330],"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 getUncommonWords() {\n const result = await sqlite.execute({\n sql: `SELECT id, term FROM UNCOMMON_WORDS`,\n });\n\n const rows: { id: number; term: string }[] = result.rows as any;\n return rows;\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}",[],[164,266],"5dce1b04-37c1-11f1-ab09-42b51c65c3df",["D",1776143906710],[],[164,38],["D",1775449252133],[180,181],[164],["D",1775446478026],["D",1789470042795],{"_105":104,"_112":108},{"_105":104,"_106":-5,"_107":108,"_19":60,"_109":110,"_111":30},{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_132":318,"_319":320,"_321":322,"_323":30,"_324":30,"_325":30,"_326":64,"_327":-5,"_328":-7,"_329":-7,"_330":68,"_331":30,"_332":30,"_333":-5,"_334":30,"_335":30,"_336":30,"_337":-5},"ENV",{"_289":290,"_291":292,"_293":95,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317},"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 · v56