[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_353":354,"_355":356},"routes/_app.x.$handle.$name",{"_108":107,"_33":56,"_116":98,"_28":117,"_13":14,"_118":-5,"_11":119,"_120":121,"_122":123,"_124":125,"_126":127,"_22":-5,"_128":-5,"_129":-5,"_130":26,"_131":132,"_133":69,"_134":-5,"_135":-5,"_136":137},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_54":55,"_33":56,"_37":57,"_58":-5,"_59":26,"_60":61,"_62":61,"_63":-5,"_64":-5,"_18":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":-5,"_79":-5,"_80":-5,"_81":82,"_83":82,"_84":85,"_86":85,"_87":85,"_88":82,"_89":82,"_90":91,"_92":93,"_94":95,"_96":26},"version",35,"changes",[19,20,21],"aiChatInfo","userId",{"_22":49,"_24":-7,"_25":26,"_27":26,"_28":50,"_30":50},{"_22":42,"_24":-7,"_25":26,"_27":26,"_28":43,"_30":43},{"_22":23,"_24":-7,"_25":26,"_27":26,"_28":29,"_30":29},"file",{"_31":32,"_33":29,"_34":35,"_36":-5,"_37":38,"_39":14,"_40":41,"_25":26},"previous","deleted",false,"deletedHere","path","frontend","latestPath","fileId","e982ed55-985b-4f41-99b8-1fe4ebf462ba","name","fileType","directory","content","createdAt",["D",1744058518575],"branchVersion","branchId","38474c6c-13ef-11f0-bfb0-569c3dd06744",{"_31":44,"_33":45,"_34":46,"_36":47,"_37":48,"_39":14,"_40":41,"_25":26},"frontend/components/App.tsx","c02e7384-13f0-11f0-ab97-569c3dd06744","App.tsx","script","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { Home } from \"./Home.tsx\";\nimport { CreateShortUrl } from \"./CreateShortUrl.tsx\";\n\nexport function App() {\n const [currentRoute, setCurrentRoute] = useState(\"/\");\n\n useEffect(() => {\n const handleHashChange = () => {\n setCurrentRoute(window.location.hash.slice(1) || \"/\");\n };\n window.addEventListener(\"hashchange\", handleHashChange);\n handleHashChange();\n return () => window.removeEventListener(\"hashchange\", handleHashChange);\n }, []);\n\n return (\n

URL Shortener

\n \n

\n {currentRoute === \"/\" && }\n {currentRoute === \"/create\" && }\n

\n \n

\n );\n}",["D",1744058518575],{"_31":51,"_33":52,"_34":35,"_36":-5,"_37":53,"_39":14,"_40":41,"_25":26},"frontend/components","090d1353-aaa7-4229-be8c-ef5b2efad21d","components",["D",1744058518575],"id","3846fd0c-13ef-11f0-bfb0-569c3dd06744","url-project",["D",1744057861075],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","c7d91915-4070-4350-8e28-6c792ff73b1c","pinnedFileId","48e28ffa-13ef-11f0-8bb9-569c3dd06744","pinPreview",true,"pinMigrated","screenshotVersion",66,"likeCount",3,"orgId","9ee5b56c-6e87-47cb-98e4-c31219468b31","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_108":107,"_115":111},"org",{"_108":107,"_109":-5,"_110":111,"_18":65,"_112":113,"_114":26},"branch",{"_13":97,"_33":98,"_54":41,"_99":55,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":56,"_106":107},"isOwned",73,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","loading","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaTFCT2UzVDJHbzF6RjhPTnpBd3p6VEJHZEQifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_54":55,"_33":56,"_37":349,"_58":-5,"_59":26,"_60":61,"_62":61,"_63":-5,"_64":-5,"_18":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":-5,"_79":-5,"_80":-5,"_81":82,"_83":82,"_84":85,"_86":85,"_87":85,"_88":82,"_89":82,"_90":350,"_92":351,"_94":352,"_96":26},"tree",[211,215,218,226,228,229,230,231],"files",[211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231],"counts",{"_200":176,"_201":152,"_202":203,"_204":205,"_206":207},"contents",[138,139,140,141,142,143,144,145],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_54":194,"_33":195,"_31":196,"_148":-5,"_40":41,"_39":197,"_150":69,"_37":198,"_13":176,"_34":35,"_36":-5,"_25":26,"_155":-5,"_28":199},{"_54":191,"_33":29,"_31":32,"_148":-5,"_40":41,"_39":14,"_150":69,"_37":192,"_13":176,"_34":35,"_36":-5,"_25":26,"_155":-5,"_28":193},{"_54":185,"_33":186,"_31":187,"_148":-5,"_40":41,"_39":188,"_150":69,"_37":189,"_13":176,"_34":35,"_36":-5,"_25":26,"_155":-5,"_28":190},{"_54":179,"_33":180,"_31":181,"_148":-5,"_40":41,"_39":182,"_150":69,"_37":183,"_13":176,"_34":35,"_36":-5,"_25":26,"_155":-5,"_28":184},{"_54":171,"_33":172,"_31":173,"_148":-5,"_40":41,"_39":174,"_150":69,"_37":175,"_13":176,"_34":22,"_36":177,"_25":26,"_155":-5,"_28":178},{"_54":164,"_33":165,"_31":166,"_148":-5,"_40":41,"_39":167,"_150":69,"_37":168,"_13":149,"_34":46,"_36":169,"_25":26,"_155":-5,"_28":170},{"_54":157,"_33":158,"_31":159,"_148":-5,"_40":41,"_39":160,"_150":69,"_37":161,"_13":152,"_34":46,"_36":162,"_25":26,"_155":-5,"_28":163},{"_54":146,"_33":147,"_31":67,"_148":-5,"_40":41,"_39":149,"_150":26,"_37":151,"_13":152,"_34":153,"_36":154,"_25":26,"_155":-5,"_28":156},"4aafca5a-13ef-11f0-820a-569c3dd06744","server.tsx","parentId",2,"latest",["D",1744057891955],1,"http","import { handler } from \"./entry.server.tsx\";\n\nexport default async function(request: Request) {\n const url = new URL(request.url);\n if (url.pathname == \"/js/entry.client.js\") {\n const moduleUrl = new URL(\"./entry.client.tsx\", import.meta.url);\n return fetch(moduleUrl);\n }\n return handler(request);\n}","label",[147],"18f9c5c8-13f0-11f0-ab6b-569c3dd06744","entry.server.tsx","5c2615dc-13ef-11f0-b44b-569c3dd06744",27,["D",1744058238050],"/** @jsxImportSource npm:react */\nimport { renderToString } from \"npm:react-dom/server\";\nimport { createStaticHandler, createStaticRouter, StaticRouterProvider } from \"npm:react-router\";\n\nimport routes from \"./routes/index.ts\";\n\nlet { query, dataRoutes } = createStaticHandler(routes);\n\nexport async function handler(request: Request) {\n // 1. run actions/loaders to get the routing context with `query`\n let context = await query(request);\n\n // If `query` returns a Response, send it raw (a route probably a redirected)\n if (context instanceof Response) {\n return context;\n }\n\n // 2. Create a static router for SSR\n let router = createStaticRouter(dataRoutes, context);\n\n // 3. Render everything with StaticRouterProvider\n let html = renderToString(\n ,\n );\n\n // Setup headers from action and loaders from deepest match\n let leaf = context.matches[context.matches.length - 1];\n let actionHeaders = context.actionHeaders[leaf.route.id];\n let loaderHeaders = context.loaderHeaders[leaf.route.id];\n let headers = new Headers(actionHeaders);\n if (loaderHeaders) {\n for (let [key, value] of loaderHeaders.entries()) {\n headers.append(key, value);\n }\n }\n\n headers.set(\"Content-Type\", \"text/html; charset=utf-8\");\n\n // 4. send a response\n return new Response(`${html}`, {\n status: context.statusCode,\n headers,\n });\n}",[158],"142db0ea-13f0-11f0-9e72-569c3dd06744","entry.client.tsx","52fd858a-13ef-11f0-aa91-569c3dd06744",26,["D",1744058230001],"import { createElement, StrictMode } from \"npm:react\";\nimport { hydrateRoot } from \"npm:react-dom/client\";\nimport { createBrowserRouter } from \"npm:react-router\";\nimport { RouterProvider } from \"npm:react-router/dom\";\nimport routes from \"./routes/index.ts\";\n\nlet router = createBrowserRouter(routes, {\n // @ts-expect-error It's fine\n hydrationData: window.__staticRouterHydrationData,\n});\n\nhydrateRoot(document, createElement(RouterProvider, { router: router }));",[165],"ab628cb0-13f0-11f0-a41a-569c3dd06744","README.md","ab628d46-13f0-11f0-a41a-569c3dd06744",31,["D",1744058483684],0,"# URL Shortener\n\nA simple URL shortener application built on Val Town.\n\n## Features\n\n- Create short URLs for long links\n- View recently created short URLs\n- Automatic redirection from short URLs to original destinations\n\n## Project Structure\n\n- `/backend` - Server-side code and database operations\n- `/frontend` - React components and UI\n- `/shared` - Shared utilities and types\n\n## Technologies\n\n- React for the frontend\n- SQLite for data storage\n- TailwindCSS for styling",[172],"adc7632c-13f0-11f0-a145-569c3dd06744","shared","87ff1306-5163-42a1-8b25-91bf861c9ca1",32,["D",1744058487699],[180],"7cb25536-13ef-11f0-8ae5-569c3dd06744","routes","7cb2561c-13ef-11f0-8ae5-569c3dd06744",6,["D",1744057975860],[186],"c02e83ec-13f0-11f0-ab97-569c3dd06744",["D",1744058518575],[29],"b39d13b4-13f0-11f0-a1c3-569c3dd06744","backend","51dc5c24-ea6f-4bc1-98eb-f4920f288364",33,["D",1744058497486],[195],"pulls","branches","forks",4,"envVars",{"_208":176,"_210":176},"connections",{"_208":176,"_209":176},"count","unfilledCount","emptyCount",{"_54":194,"_33":195,"_31":196,"_148":-5,"_40":41,"_39":197,"_150":69,"_37":346,"_13":176,"_34":35,"_36":-5,"_25":26,"_155":-5,"_233":347,"_28":348},{"_54":342,"_33":341,"_31":336,"_148":196,"_40":41,"_39":197,"_150":69,"_37":343,"_13":176,"_34":35,"_36":-5,"_25":26,"_155":-5,"_233":344,"_28":345},{"_54":333,"_33":334,"_31":335,"_148":336,"_40":41,"_39":197,"_150":26,"_37":337,"_13":176,"_34":46,"_36":338,"_25":26,"_155":-5,"_233":339,"_28":340},{"_54":326,"_33":280,"_31":327,"_148":196,"_40":41,"_39":328,"_150":26,"_37":329,"_13":176,"_34":46,"_36":330,"_25":26,"_155":-5,"_233":331,"_28":332},{"_54":191,"_33":29,"_31":32,"_148":-5,"_40":41,"_39":14,"_150":69,"_37":323,"_13":176,"_34":35,"_36":-5,"_25":26,"_155":-5,"_233":324,"_28":325},{"_54":319,"_33":52,"_31":51,"_148":32,"_40":41,"_39":14,"_150":69,"_37":320,"_13":176,"_34":35,"_36":-5,"_25":26,"_155":-5,"_233":321,"_28":322},{"_54":315,"_33":45,"_31":44,"_148":51,"_40":41,"_39":14,"_150":69,"_37":316,"_13":176,"_34":46,"_36":47,"_25":26,"_155":-5,"_233":317,"_28":318},{"_54":185,"_33":186,"_31":187,"_148":-5,"_40":41,"_39":188,"_150":69,"_37":312,"_13":176,"_34":35,"_36":-5,"_25":26,"_155":-5,"_233":313,"_28":314},{"_54":304,"_33":305,"_31":306,"_148":187,"_40":41,"_39":307,"_150":69,"_37":308,"_13":152,"_34":46,"_36":309,"_25":26,"_155":-5,"_233":310,"_28":311},{"_54":296,"_33":297,"_31":298,"_148":187,"_40":41,"_39":299,"_150":26,"_37":300,"_13":152,"_34":46,"_36":301,"_25":26,"_155":-5,"_233":302,"_28":303},{"_54":288,"_33":289,"_31":290,"_148":187,"_40":41,"_39":291,"_150":26,"_37":292,"_13":152,"_34":46,"_36":293,"_25":26,"_155":-5,"_233":294,"_28":295},{"_54":279,"_33":280,"_31":281,"_148":187,"_40":41,"_39":282,"_150":26,"_37":283,"_13":284,"_34":46,"_36":285,"_25":26,"_155":-5,"_233":286,"_28":287},{"_54":271,"_33":272,"_31":273,"_148":187,"_40":41,"_39":274,"_150":69,"_37":275,"_13":203,"_34":46,"_36":276,"_25":26,"_155":-5,"_233":277,"_28":278},{"_54":263,"_33":264,"_31":265,"_148":187,"_40":41,"_39":266,"_150":69,"_37":267,"_13":149,"_34":46,"_36":268,"_25":26,"_155":-5,"_233":269,"_28":270},{"_54":255,"_33":256,"_31":257,"_148":187,"_40":41,"_39":258,"_150":26,"_37":259,"_13":152,"_34":46,"_36":260,"_25":26,"_155":-5,"_233":261,"_28":262},{"_54":179,"_33":180,"_31":181,"_148":-5,"_40":41,"_39":182,"_150":69,"_37":252,"_13":176,"_34":35,"_36":-5,"_25":26,"_155":-5,"_233":253,"_28":254},{"_54":245,"_33":246,"_31":247,"_148":181,"_40":41,"_39":182,"_150":69,"_37":248,"_13":176,"_34":46,"_36":249,"_25":26,"_155":-5,"_233":250,"_28":251},{"_54":171,"_33":172,"_31":173,"_148":-5,"_40":41,"_39":174,"_150":69,"_37":242,"_13":176,"_34":22,"_36":177,"_25":26,"_155":-5,"_233":243,"_28":244},{"_54":164,"_33":165,"_31":166,"_148":-5,"_40":41,"_39":167,"_150":69,"_37":239,"_13":149,"_34":46,"_36":169,"_25":26,"_155":-5,"_233":240,"_28":241},{"_54":157,"_33":158,"_31":159,"_148":-5,"_40":41,"_39":160,"_150":69,"_37":236,"_13":152,"_34":46,"_36":162,"_25":26,"_155":-5,"_233":237,"_28":238},{"_54":146,"_33":147,"_31":67,"_148":-5,"_40":41,"_39":149,"_150":26,"_37":232,"_13":152,"_34":153,"_36":154,"_25":26,"_155":-5,"_233":234,"_28":235},["D",1744057891955],"children",[],[147],["D",1744058238050],[],[158],["D",1744058230001],[],[165],["D",1744058483684],[],[172],"adc75dbe-13f0-11f0-a145-569c3dd06744","utils.ts","adc75e9a-13f0-11f0-a145-569c3dd06744",["D",1744058487699],"/**\n * Generates a random short code for URL shortening\n * @returns A 6-character alphanumeric code\n */\nexport const generateShortCode = (): string => {\n const characters = \"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789\";\n let result = \"\";\n for (let i = 0; i < 6; i++) {\n result += characters.charAt(Math.floor(Math.random() * characters.length));\n }\n return result;\n};\n\n/**\n * URL-related types\n */\nexport interface ShortUrl {\n id?: number;\n shortCode: string;\n longUrl: string;\n createdAt?: string;\n}",[],[180,246],["D",1744058487699],[227],[180],"af6c4dd8-13ef-11f0-befd-569c3dd06744","layout.tsx","ad875850-13ef-11f0-aaff-569c3dd06744",10,["D",1744058060961],"/** @jsxImportSource npm:react */\nimport { Form, Link, Outlet, useLoaderData } from \"npm:react-router\";\nimport { type loader } from \"./layout.server.ts\";\n\nexport default function Layout() {\n let data = useLoaderData();\n return (\n \n \n React Router Custom Framework\n \n \n

React Router Custom Framework

\n\n \n\n

\n Home | About\n

\n\n

\n\n \n

\n\n \n \n \n );\n}",[],[186,256],"e9780792-13ef-11f0-a18c-569c3dd06744","layout.server.ts","bac1e01c-13ef-11f0-8aea-569c3dd06744",19,["D",1744058158345],"import { ActionFunctionArgs, type LoaderFunctionArgs } from \"npm:react-router\";\n\nlet db = { message: \"Hello world!\" };\n\nexport async function loader(args: LoaderFunctionArgs) {\n await new Promise(resolve => setTimeout(resolve, 200));\n return { message: db.message };\n}\n\nexport async function action({ request }: ActionFunctionArgs) {\n let formData = await request.formData();\n db.message = String(formData.get(\"message\"));\n return { ok: true };\n}",[],[186,264],"e7538cfc-13ef-11f0-bfb0-569c3dd06744","layout.client.ts","beba5f00-13ef-11f0-a220-569c3dd06744",18,["D",1744058154751],"import { type LoaderFunctionArgs } from \"npm:react-router\";\n\nexport async function loader({ request }: LoaderFunctionArgs) {\n let url = new URL(request.url);\n let res = await fetch(url, {\n headers: {\n Accept: \"application/json\",\n \"X-Route-Id\": \"layout\",\n },\n });\n return res.json();\n}\n\nexport async function action({ request }: LoaderFunctionArgs) {\n let url = new URL(request.url);\n // call the server action\n let res = await fetch(url, {\n method: \"POST\",\n body: new URLSearchParams(await request.formData()),\n headers: {\n \"Content-Type\": \"application/x-www-form-urlencoded\",\n Accept: \"application/json\",\n \"X-Route-Id\": \"layout\",\n },\n });\n return res.json();\n}",[],[186,272],"542e5df2-13f0-11f0-8650-569c3dd06744","index.ts","7f420d0a-13ef-11f0-ac6f-569c3dd06744",30,["D",1744058337381],5,"import { ActionFunctionArgs, LoaderFunctionArgs } from \"npm:react-router\";\nimport Layout from \"./layout.tsx\";\nlet isServer = typeof document === \"undefined\";\n\nexport default [\n {\n id: \"layout\",\n path: \"/\",\n Component: Layout,\n // up to you where your loaders run (client or server), this one dynamically\n // imports the correct one to avoid putting the server code in client\n // bundles\n async loader(args: LoaderFunctionArgs) {\n let mod = await (isServer\n ? import(\"./layout.server.ts\")\n : import(\"./layout.client.ts\"));\n return mod.loader(args);\n },\n // same with the action, you'll probably want to abstract this kind of stuff\n // in a createRoute() kind of thing\n async action(args: ActionFunctionArgs) {\n let mod = await (isServer\n ? import(\"./layout.server.ts\")\n : import(\"./layout.client.ts\"));\n return mod.action(args);\n },\n },\n];",[],[186,280],"f7d4e2ce-13ef-11f0-aaff-569c3dd06744","home.tsx","f674faf4-13ef-11f0-9a50-569c3dd06744",21,["D",1744058182443],"/** @jsxImportSource npm:react */\n\nexport default function Home() {\n return

Home

;\n}",[],[186,289],"00ba7822-13f0-11f0-9d7c-569c3dd06744","about.tsx","ff60d7e6-13ef-11f0-b525-569c3dd06744",23,["D",1744058197363],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport { useLoaderData } from \"https://esm.sh/react-router@7.1.3?deps=react@18.2.0,react-dom@18.2.0\";\nimport type loader from \"./about.loader.js\";\n\nexport default function About() {\n let data = useLoaderData();\n return

{data.message}

;\n}",[],[186,297],"0bdbe420-13f0-11f0-b91e-569c3dd06744","about.loader.ts","09aa151e-13f0-11f0-a218-569c3dd06744",25,["D",1744058216043],"import { data } from \"npm:react-router\";\n\nexport default async function load() {\n await new Promise(resolve => setTimeout(resolve, 200));\n\n let isServer = typeof document === \"undefined\";\n let env = isServer ? \"server\" : \"client\";\n\n return data(\n { message: `About loader from ${env} loader` },\n {\n headers: { \"X-Custom\": \"Hello\" },\n },\n );\n}",[],[186,305],["D",1744057975860],[219,220,221,222,223,224,225],[186],"c02e72a8-13f0-11f0-ab97-569c3dd06744",["D",1744058518575],[],[29,52,45],"c02e866c-13f0-11f0-ab97-569c3dd06744",["D",1744058518575],[217],[29,52],["D",1744058518575],[216],[29],"ba000aae-13f0-11f0-ac2f-569c3dd06744","ba000b62-13f0-11f0-ac2f-569c3dd06744",34,["D",1744058508205],"import { readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { generateShortCode } from \"../shared/utils.ts\";\nimport { \n initializeDatabase, \n createShortUrl, \n getRecentUrls, \n findUrlByShortCode \n} from \"./database/queries.ts\";\n\n/**\n * Main server handler for the URL shortener application\n */\nexport default async function server(request: Request): Promise {\n // Initialize database on each request\n await initializeDatabase(import.meta.url);\n\n const url = new URL(request.url);\n const path = url.pathname;\n\n // API endpoint to shorten a URL\n if (path === \"/api/shorten\" && request.method === \"POST\") {\n try {\n const { longUrl } = await request.json();\n const shortCode = generateShortCode();\n \n const result = await createShortUrl(shortCode, longUrl, import.meta.url);\n \n return new Response(JSON.stringify(result), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error) {\n console.error(\"Error shortening URL:\", error);\n return new Response(JSON.stringify({ error: \"Failed to create short URL\" }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n // API endpoint to get recent URLs\n if (path === \"/api/recent\") {\n try {\n const recentUrls = await getRecentUrls(import.meta.url);\n \n return new Response(JSON.stringify(recentUrls), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error) {\n console.error(\"Error fetching recent URLs:\", error);\n return new Response(JSON.stringify({ error: \"Failed to fetch recent URLs\" }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n // Handle short URL redirects\n if (path.length > 1 && !path.startsWith(\"/api\")) {\n const shortCode = path.slice(1);\n try {\n const url = await findUrlByShortCode(shortCode, import.meta.url);\n \n if (url) {\n return new Response(null, {\n status: 302,\n headers: { Location: url.longUrl },\n });\n }\n } catch (error) {\n console.error(\"Error redirecting:\", error);\n }\n }\n\n // Serve the frontend for all other routes\n try {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n return new Response(html, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n } catch (error) {\n console.error(\"Error serving frontend:\", error);\n return new Response(\"Server error\", { status: 500 });\n }\n}",[],[195,280],"b39d0b12-13f0-11f0-a1c3-569c3dd06744","queries.ts","b39d0bc6-13f0-11f0-a1c3-569c3dd06744","e9820e6e-9be8-42bc-bc94-1b2b38a609d6",["D",1744058497486],"import { ShortUrl } from \"../../shared/utils.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Get the unique key for this val to use in table names\nconst getKey = (url: string): string => {\n return new URL(url).pathname.split(\"/\").at(-1) || \"url_shortener\";\n};\n\n// Current schema version - increment when changing schema\nconst SCHEMA_VERSION = 1;\n\n/**\n * Initialize the database schema\n */\nexport const initializeDatabase = async (metaUrl: string): Promise => {\n const KEY = getKey(metaUrl);\n \n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_urls_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n shortCode TEXT UNIQUE NOT NULL,\n longUrl TEXT NOT NULL,\n createdAt DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n};\n\n/**\n * Create a new short URL\n */\nexport const createShortUrl = async (\n shortCode: string, \n longUrl: string, \n metaUrl: string\n): Promise => {\n const KEY = getKey(metaUrl);\n \n await sqlite.execute(\n `INSERT INTO ${KEY}_urls_${SCHEMA_VERSION} (shortCode, longUrl) VALUES (?, ?)`, \n [shortCode, longUrl]\n );\n \n return { shortCode, longUrl };\n};\n\n/**\n * Get recent short URLs\n */\nexport const getRecentUrls = async (metaUrl: string, limit = 5): Promise => {\n const KEY = getKey(metaUrl);\n \n const result = await sqlite.execute(\n `SELECT shortCode, longUrl FROM ${KEY}_urls_${SCHEMA_VERSION} \n ORDER BY createdAt DESC LIMIT ?`,\n [limit]\n );\n \n return result.rows as ShortUrl[];\n};\n\n/**\n * Find a URL by its short code\n */\nexport const findUrlByShortCode = async (shortCode: string, metaUrl: string): Promise => {\n const KEY = getKey(metaUrl);\n \n const result = await sqlite.execute(\n `SELECT longUrl FROM ${KEY}_urls_${SCHEMA_VERSION} WHERE shortCode = ?`, \n [shortCode]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as ShortUrl;\n};",[],[195,341,334],"database","b39d1530-13f0-11f0-a1c3-569c3dd06744",["D",1744058497486],[213],[195,341],["D",1744058497486],[212,214],[195],["D",1744057861075],{"_108":107,"_115":111},{"_108":107,"_109":-5,"_110":111,"_18":65,"_112":113,"_114":26},{"_13":97,"_33":98,"_54":41,"_99":55,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":56,"_106":107},"ctx",{"_90":-5,"_135":386,"_387":388,"_389":390,"_391":26,"_392":26,"_393":26,"_394":69,"_395":-5,"_396":-7,"_397":-7,"_398":176,"_399":26,"_400":26,"_401":-5,"_402":26,"_403":26,"_404":26,"_405":-5},"ENV",{"_357":358,"_359":360,"_361":98,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377,"_378":379,"_380":381,"_382":383,"_384":385},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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 · v35