[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_365":366,"_367":368},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_269":-5,"_20":270,"_22":271,"_272":273,"_274":275,"_26":276,"_24":277,"_278":-5,"_279":-5,"_280":58,"_281":282,"_283":49,"_284":-5,"_285":-5,"_286":287},"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","loading","name","wondrousCyanRodent","branchName","main","version","path","frontend","project",{"_37":216,"_13":14,"_50":217,"_218":-5,"_219":58,"_220":221,"_222":221,"_223":-5,"_224":-5,"_225":226,"_227":92,"_228":49,"_229":-5,"_230":93,"_231":52,"_232":233,"_234":-5,"_235":-5,"_236":-5,"_237":-5,"_238":239,"_240":239,"_241":242,"_243":242,"_244":242,"_245":239,"_246":239,"_247":248,"_249":250,"_251":252,"_253":58},"tree",[85,86,87,88,89],"file",{"_37":82,"_13":19,"_40":43,"_42":-5,"_44":45,"_46":64,"_48":49,"_50":83,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_18":84},"contents",[33,34,35,36],"upstream","pull","ahead","behind","envVars",{"_37":75,"_13":76,"_40":77,"_42":43,"_44":45,"_46":78,"_48":49,"_50":79,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_18":81},{"_37":68,"_13":69,"_40":70,"_42":43,"_44":45,"_46":71,"_48":49,"_50":72,"_17":52,"_53":24,"_55":73,"_57":58,"_59":-5,"_18":74},{"_37":61,"_13":62,"_40":63,"_42":43,"_44":45,"_46":64,"_48":49,"_50":65,"_17":52,"_53":24,"_55":66,"_57":58,"_59":-5,"_18":67},{"_37":38,"_13":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_17":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_18":60},"id","6e17a8b2-13c4-11f0-bce8-569c3dd06744","index.tsx","fileId","6e17a97a-13c4-11f0-bce8-569c3dd06744","parentId","de090c94-a8d0-4cf6-ac06-706facff5a92","branchId","deebde02-13c2-11f0-a341-569c3dd06744","branchVersion",12,"latest",true,"createdAt",["D",1744039482995],0,"fileType","script","content","// @jsxImportSource https://esm.sh/react@18.2.0\nimport { StrictMode } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst rootElement = document.getElementById(\"root\");\nif (!rootElement) throw new Error(\"Root element not found\");\n\nconst root = createRoot(rootElement);\nroot.render(\n \n \n \n);","deleted",false,"label",[19,39],"41e3a23c-13c4-11f0-a306-569c3dd06744","index.html","41e3a322-13c4-11f0-a306-569c3dd06744",6,["D",1744039408833],"\n\n\n \n \n Link Shortener\n \n \n \n \n\n\n

\n \n\n",[19,62],"44f6b78e-13c4-11f0-a419-569c3dd06744","favicon.svg","44f6b860-13c4-11f0-a419-569c3dd06744",7,["D",1744039413996],"",[19,69],"4ed588de-13c4-11f0-b944-569c3dd06744","components","03b7444d-30e6-482b-8b3e-dd6be0702b1b",8,["D",1744039430553],"directory",[19,76],"41e3a9c6-13c4-11f0-a306-569c3dd06744",["D",1744039408833],[19],{"_37":177,"_13":178,"_40":179,"_42":-5,"_44":45,"_46":180,"_48":49,"_50":181,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_97":182,"_18":183},{"_37":82,"_13":19,"_40":43,"_42":-5,"_44":45,"_46":64,"_48":49,"_50":123,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_97":124,"_18":125},{"_37":108,"_13":109,"_40":110,"_42":-5,"_44":45,"_46":111,"_48":49,"_50":112,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_97":113,"_18":114},{"_37":100,"_13":101,"_40":102,"_42":-5,"_44":45,"_46":103,"_48":49,"_50":104,"_17":52,"_53":24,"_55":105,"_57":58,"_59":-5,"_97":106,"_18":107},{"_37":90,"_13":91,"_40":92,"_42":-5,"_44":45,"_46":93,"_48":49,"_50":94,"_17":71,"_53":95,"_55":96,"_57":58,"_59":-5,"_97":98,"_18":99},"e6046fa4-13c4-11f0-b1d8-569c3dd06744","index.ts","e3ca705a-13c2-11f0-9f02-569c3dd06744",20,["D",1744039684197],"http","// Re-export the backend app\nimport data from \"./backend/index.ts\";\n\nconsole.log(data);\n\nexport default data;","children",[],[91],"7d2821c4-13c4-11f0-a808-569c3dd06744","README.md","7d2822a0-13c4-11f0-a808-569c3dd06744",14,["D",1744039508273],"# Link Shortener\n\nA simple and fast link shortener service built with React Router 7 and Hono on Val Town.\n\n## Features\n\n- Create shortened links with custom or auto-generated IDs\n- Track click counts for each shortened link\n- Responsive design with Tailwind CSS\n- Client-side routing with React Router 7\n- SQLite database for persistent storage\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema setup\n│ │ └── queries.ts # Database operations\n│ └── index.ts # Hono API server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main React component with routing\n│ │ ├── CreateLink.tsx # Form to create short links\n│ │ ├── LinkList.tsx # List of created links\n│ │ └── NotFound.tsx # 404 page\n│ ├── favicon.svg # Site favicon\n│ ├── index.html # HTML template\n│ └── index.tsx # React entry point\n├── index.ts # Entry point that exports the backend\n└── shared/\n └── types.ts # Shared TypeScript interfaces\n```\n\n## Technologies Used\n\n- **Frontend**:\n - React 18.2.0\n - React Router 7\n - Tailwind CSS (via CDN)\n \n- **Backend**:\n - Hono (lightweight web framework)\n - SQLite (via Val Town's SQLite API)\n \n- **Other**:\n - TypeScript\n - nanoid for generating short IDs\n\n## How It Works\n\n1. Users enter a URL to shorten (with optional custom short ID)\n2. The backend creates a new entry in the SQLite database\n3. When someone visits the shortened URL, the backend:\n - Looks up the original URL in the database\n - Increments the click counter\n - Redirects to the original URL\n4. The frontend displays statistics for all created links\n\n## Development\n\nThis project is designed to run on Val Town. The code is organized to separate concerns between frontend and backend while sharing common types.\n\n## License\n\nMIT",[],[101],"3535347e-13c4-11f0-b5ff-569c3dd06744","shared","1e069ae4-6a24-4338-9f02-a86f3a57470b",4,["D",1744039387561],[115],[109],{"_37":116,"_13":117,"_40":118,"_42":110,"_44":45,"_46":111,"_48":49,"_50":119,"_17":52,"_53":54,"_55":120,"_57":58,"_59":-5,"_97":121,"_18":122},"35352cae-13c4-11f0-b5ff-569c3dd06744","types.ts","35352d80-13c4-11f0-b5ff-569c3dd06744",["D",1744039387561],"// Link data structure\nexport interface Link {\n id: number;\n shortId: string;\n originalUrl: string;\n createdAt: number;\n clickCount: number;\n}\n\n// Request to create a new link\nexport interface CreateLinkRequest {\n originalUrl: string;\n customShortId?: string;\n}\n\n// Response for link creation\nexport interface CreateLinkResponse {\n success: boolean;\n link?: Link;\n error?: string;\n}\n\n// Response for getting all links\nexport interface GetLinksResponse {\n links: Link[];\n}",[],[109,117],["D",1744039408833],[126,127,128,129],[19],{"_37":75,"_13":76,"_40":77,"_42":43,"_44":45,"_46":78,"_48":49,"_50":139,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_97":140,"_18":141},{"_37":68,"_13":69,"_40":70,"_42":43,"_44":45,"_46":71,"_48":49,"_50":136,"_17":52,"_53":24,"_55":73,"_57":58,"_59":-5,"_97":137,"_18":138},{"_37":61,"_13":62,"_40":63,"_42":43,"_44":45,"_46":64,"_48":49,"_50":133,"_17":52,"_53":24,"_55":66,"_57":58,"_59":-5,"_97":134,"_18":135},{"_37":38,"_13":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":130,"_17":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_97":131,"_18":132},["D",1744039482995],[],[19,39],["D",1744039408833],[],[19,62],["D",1744039413996],[],[19,69],["D",1744039430553],[142,143,144,145],[19,76],{"_37":169,"_13":170,"_40":171,"_42":77,"_44":45,"_46":172,"_48":49,"_50":173,"_17":52,"_53":54,"_55":174,"_57":58,"_59":-5,"_97":175,"_18":176},{"_37":162,"_13":163,"_40":164,"_42":77,"_44":45,"_46":78,"_48":49,"_50":165,"_17":52,"_53":54,"_55":166,"_57":58,"_59":-5,"_97":167,"_18":168},{"_37":154,"_13":155,"_40":156,"_42":77,"_44":45,"_46":157,"_48":49,"_50":158,"_17":52,"_53":54,"_55":159,"_57":58,"_59":-5,"_97":160,"_18":161},{"_37":146,"_13":147,"_40":148,"_42":77,"_44":45,"_46":149,"_48":49,"_50":150,"_17":52,"_53":54,"_55":151,"_57":58,"_59":-5,"_97":152,"_18":153},"5c2f0578-13c4-11f0-b944-569c3dd06744","NotFound.tsx","5c2f0622-13c4-11f0-b944-569c3dd06744",10,["D",1744039452949],"// @jsxImportSource https://esm.sh/react@18.2.0\nimport { Link } from \"https://esm.sh/react-router-dom@7.0.0-rc.0?deps=react@18.2.0,react-dom@18.2.0\";\n\nexport function NotFound() {\n return (\n

Link Not Found

\n The short link you're looking for doesn't exist or has been removed.\n

\n \n Go to Homepage\n \n

\n );\n}",[],[19,76,147],"57b8d442-13c4-11f0-856e-569c3dd06744","LinkList.tsx","57b8d532-13c4-11f0-856e-569c3dd06744",9,["D",1744039445464],"// @jsxImportSource https://esm.sh/react@18.2.0\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { Link } from \"../../shared/types.ts\";\n\ninterface LinkListProps {\n links: Link[];\n}\n\nexport function LinkList({ links }: LinkListProps) {\n const [copiedId, setCopiedId] = useState(null);\n \n if (links.length === 0) {\n return (\n

No links created yet. Create your first link above!

\n );\n }\n\n const copyToClipboard = async (shortId: string) => {\n const shortUrl = `${window.location.origin}/${shortId}`;\n \n try {\n await navigator.clipboard.writeText(shortUrl);\n setCopiedId(shortId);\n \n // Reset the copied state after 2 seconds\n setTimeout(() => {\n setCopiedId(null);\n }, 2000);\n } catch (err) {\n console.error(\"Failed to copy:\", err);\n }\n };\n\n const formatDate = (timestamp: number) => {\n return new Date(timestamp).toLocaleString();\n };\n\n return (\n

Your Links

\n \n

\n \n \n \n \n \n \n \n \n \n \n \n {links.map((link) => (\n \n \n \n \n \n \n \n ))}\n \n

\n Short URL\n	\n Original URL\n	\n Created\n	\n Clicks\n	\n Actions\n
\n \n {window.location.origin}/{link.shortId}\n \n	\n \n \n {link.originalUrl}\n \n \n	\n {formatDate(link.createdAt)}\n	\n {link.clickCount}\n	\n copyToClipboard(link.shortId)}\n className=\"text-blue-600 hover:text-blue-800\"\n >\n {copiedId === link.shortId ? \"Copied!\" : \"Copy\"}\n \n

\n );\n}",[],[19,76,155],"4ed57a6a-13c4-11f0-b944-569c3dd06744","CreateLink.tsx","4ed57b50-13c4-11f0-b944-569c3dd06744",["D",1744039430553],"// @jsxImportSource https://esm.sh/react@18.2.0\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { Link } from \"../../shared/types.ts\";\n\ninterface CreateLinkProps {\n onLinkCreated: (link: Link) => void;\n}\n\nexport function CreateLink({ onLinkCreated }: CreateLinkProps) {\n const [url, setUrl] = useState(\"\");\n const [customShortId, setCustomShortId] = useState(\"\");\n const [isLoading, setIsLoading] = useState(false);\n const [error, setError] = useState(\"\");\n const [showAdvanced, setShowAdvanced] = useState(false);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setError(\"\");\n \n if (!url) {\n setError(\"Please enter a URL\");\n return;\n }\n \n setIsLoading(true);\n \n try {\n const response = await fetch(\"/api/links\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n originalUrl: url,\n customShortId: customShortId || undefined,\n }),\n });\n \n const data = await response.json();\n \n if (!response.ok) {\n throw new Error(data.error || \"Failed to create short link\");\n }\n \n if (data.success && data.link) {\n onLinkCreated(data.link);\n setUrl(\"\");\n setCustomShortId(\"\");\n setShowAdvanced(false);\n } else {\n throw new Error(\"Something went wrong\");\n }\n } catch (err) {\n setError(err.message);\n } finally {\n setIsLoading(false);\n }\n };\n\n return (\n

Shorten a URL

\n \n

\n \n URL to shorten\n \n setUrl(e.target.value)}\n placeholder=\"https://example.com/very/long/url\"\n className=\"w-full px-4 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n required\n />\n

\n \n

\n setShowAdvanced(!showAdvanced)}\n className=\"text-sm text-blue-600 hover:text-blue-800\"\n >\n {showAdvanced ? \"Hide advanced options\" : \"Show advanced options\"}\n \n

\n \n {showAdvanced && (\n

\n \n Custom short ID (optional)\n \n setCustomShortId(e.target.value)}\n placeholder=\"custom-name\"\n className=\"w-full px-4 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n Leave empty to generate a random ID\n

\n )}\n \n {error && (\n

\n {error}\n

\n )}\n \n \n {isLoading ? \"Creating...\" : \"Create Short Link\"}\n \n \n

\n );\n}",[],[19,76,163],"6a8bb918-13c4-11f0-886f-569c3dd06744","App.tsx","6a8bb9c2-13c4-11f0-886f-569c3dd06744",11,["D",1744039477049],"// @jsxImportSource https://esm.sh/react@18.2.0\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { \n createBrowserRouter, \n RouterProvider, \n Route, \n createRoutesFromElements,\n Outlet,\n Link as RouterLink,\n useParams,\n useNavigate\n} from \"https://esm.sh/react-router-dom@7.0.0-rc.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { CreateLink } from \"./CreateLink.tsx\";\nimport { LinkList } from \"./LinkList.tsx\";\nimport { NotFound } from \"./NotFound.tsx\";\nimport { Link } from \"../../shared/types.ts\";\n\n// Layout component with header and footer\nfunction Layout() {\n return (\n

\n \n \n Link Shortener\n \n \n

\n \n

\n \n \n

\n );\n}\n\n// Home page component\nfunction HomePage() {\n const [links, setLinks] = useState([]);\n const [isLoading, setIsLoading] = useState(true);\n const [error, setError] = useState(\"\");\n\n const fetchLinks = async () => {\n try {\n setIsLoading(true);\n const response = await fetch(\"/api/links\");\n \n if (!response.ok) {\n throw new Error(\"Failed to fetch links\");\n }\n \n const data = await response.json();\n setLinks(data.links || []);\n } catch (err) {\n setError(\"Failed to load links. Please try again later.\");\n console.error(err);\n } finally {\n setIsLoading(false);\n }\n };\n\n useEffect(() => {\n fetchLinks();\n }, []);\n\n const handleLinkCreated = (newLink: Link) => {\n setLinks([newLink, ...links]);\n };\n\n return (\n

\n \n \n {isLoading ? (\n

Loading links...

\n ) : error ? (\n

\n {error}\n

\n ) : (\n \n )}\n

\n );\n}\n\n// Redirect component\nfunction RedirectPage() {\n const { shortId } = useParams<{ shortId: string }>();\n const navigate = useNavigate();\n const [isLoading, setIsLoading] = useState(true);\n const [error, setError] = useState(\"\");\n\n useEffect(() => {\n const checkLink = async () => {\n try {\n if (!shortId) {\n navigate(\"/not-found\");\n return;\n }\n\n const response = await fetch(`/api/links/${shortId}`);\n \n if (!response.ok) {\n navigate(\"/not-found\");\n return;\n }\n \n // If we get here, the backend should have already redirected us\n // This is just a fallback\n setError(\"Redirect failed. Please try again.\");\n } catch (err) {\n setError(\"Something went wrong. Please try again.\");\n } finally {\n setIsLoading(false);\n }\n };\n\n checkLink();\n }, [shortId, navigate]);\n\n if (isLoading) {\n return (\n

Redirecting...

\n );\n }\n\n if (error) {\n return (\n

\n {error}\n

\n \n Go to Homepage\n \n

\n );\n }\n\n return null;\n}\n\n// Create the router\nconst router = createBrowserRouter(\n createRoutesFromElements(\n }>\n } />\n } />\n } />\n } />\n \n )\n);\n\n// Main App component\nexport function App() {\n return ;\n}",[],[19,76,170],"2cd51dbc-13c4-11f0-a750-569c3dd06744","backend","0b20952e-e790-4707-a773-e8c979d5f61c",2,["D",1744039373508],[184,185],[178],{"_37":193,"_13":194,"_40":195,"_42":179,"_44":45,"_46":180,"_48":49,"_50":196,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_97":197,"_18":198},{"_37":186,"_13":91,"_40":187,"_42":179,"_44":45,"_46":188,"_48":49,"_50":189,"_17":52,"_53":54,"_55":190,"_57":58,"_59":-5,"_97":191,"_18":192},"3ea4ecd4-13c4-11f0-bc34-569c3dd06744","3ea4ed92-13c4-11f0-bc34-569c3dd06744",5,["D",1744039403395],"import { Hono } from \"https://esm.sh/hono@3.12.0\";\nimport { cors } from \"https://esm.sh/hono@3.12.0/cors\";\nimport { serveFile, readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { setupDatabase } from \"./database/migrations.ts\";\nimport { \n createLink, \n getLinkByShortId, \n incrementClickCount, \n getAllLinks \n} from \"./database/queries.ts\";\nimport { CreateLinkRequest } from \"../shared/types.ts\";\n\n// Initialize the app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(\"Error:\", err);\n throw err;\n});\n\n// Add CORS middleware\napp.use(\"/*\", cors());\n\n// Setup the database on startup\napp.use(\"*\", async (c, next) => {\n try {\n await setupDatabase();\n } catch (error) {\n console.error(\"Database setup error:\", error);\n }\n return next();\n});\n\n// API routes\napp.post(\"/api/links\", async (c) => {\n try {\n const body = await c.req.json() as CreateLinkRequest;\n \n if (!body.originalUrl) {\n return c.json({ success: false, error: \"Original URL is required\" }, 400);\n }\n \n // Validate URL format\n try {\n new URL(body.originalUrl);\n } catch (error) {\n return c.json({ success: false, error: \"Invalid URL format\" }, 400);\n }\n \n const link = await createLink(body.originalUrl, body.customShortId);\n return c.json({ success: true, link });\n } catch (error) {\n return c.json({ success: false, error: error.message }, 400);\n }\n});\n\napp.get(\"/api/links\", async (c) => {\n try {\n const links = await getAllLinks();\n return c.json({ links });\n } catch (error) {\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\n// Redirect route\napp.get(\"/:shortId\", async (c) => {\n const shortId = c.req.param(\"shortId\");\n \n // Skip API routes and static files\n if (shortId.startsWith(\"api\") || shortId.startsWith(\"public\")) {\n return c.next();\n }\n \n try {\n const link = await getLinkByShortId(shortId);\n \n if (!link) {\n // If no link found, serve the frontend with the 404 state\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n }\n \n // Increment click count asynchronously\n incrementClickCount(shortId).catch(console.error);\n \n // Redirect to the original URL\n return new Response(null, {\n status: 302,\n headers: { Location: link.originalUrl }\n });\n } catch (error) {\n console.error(\"Redirect error:\", error);\n return c.text(\"Server error\", 500);\n }\n});\n\n// Serve static files\napp.get(\"/public/*\", (c) => {\n return serveFile(c.req.path.replace(\"/public\", \"/frontend\"), import.meta.url);\n});\n\n// Serve the frontend for all other routes\napp.get(\"*\", async (c) => {\n try {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving frontend:\", error);\n return c.text(\"Server error\", 500);\n }\n});\n\n// Export the app for Val Town\nexport default app.fetch;",[],[178,91],"2cd51f9c-13c4-11f0-a750-569c3dd06744","database","c0945900-7eed-4789-b775-8f502181b48b",["D",1744039373508],[199,200],[178,194],{"_37":209,"_13":210,"_40":211,"_42":195,"_44":45,"_46":180,"_48":49,"_50":212,"_17":52,"_53":54,"_55":213,"_57":58,"_59":-5,"_97":214,"_18":215},{"_37":201,"_13":202,"_40":203,"_42":195,"_44":45,"_46":204,"_48":49,"_50":205,"_17":52,"_53":54,"_55":206,"_57":58,"_59":-5,"_97":207,"_18":208},"3310d11c-13c4-11f0-a7db-569c3dd06744","queries.ts","3310d1a8-13c4-11f0-a7db-569c3dd06744",3,["D",1744039383966],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { LINKS_TABLE } from \"./migrations.ts\";\nimport { Link } from \"../../shared/types.ts\";\nimport { nanoid } from \"https://esm.sh/nanoid@4.0.2\";\n\n// Generate a short ID for the URL\nexport function generateShortId(length = 6): string {\n return nanoid(length);\n}\n\n// Create a new shortened link\nexport async function createLink(originalUrl: string, customShortId?: string): Promise {\n const shortId = customShortId || generateShortId();\n const createdAt = Date.now();\n \n try {\n await sqlite.execute(\n `INSERT INTO ${LINKS_TABLE} (short_id, original_url, created_at) VALUES (?, ?, ?)`,\n [shortId, originalUrl, createdAt]\n );\n \n return {\n id: 0, // SQLite will assign the actual ID\n shortId,\n originalUrl,\n createdAt,\n clickCount: 0\n };\n } catch (error) {\n // Handle duplicate short_id error\n if (error.message.includes('UNIQUE constraint failed')) {\n throw new Error('This short ID is already in use. Please try another one.');\n }\n throw error;\n }\n}\n\n// Get a link by its short ID\nexport async function getLinkByShortId(shortId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, short_id, original_url, created_at, click_count FROM ${LINKS_TABLE} WHERE short_id = ?`,\n [shortId]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n const row = result.rows[0];\n return {\n id: row[0] as number,\n shortId: row[1] as string,\n originalUrl: row[2] as string,\n createdAt: row[3] as number,\n clickCount: row[4] as number\n };\n}\n\n// Increment the click count for a link\nexport async function incrementClickCount(shortId: string): Promise {\n await sqlite.execute(\n `UPDATE ${LINKS_TABLE} SET click_count = click_count + 1 WHERE short_id = ?`,\n [shortId]\n );\n}\n\n// Get all links\nexport async function getAllLinks(): Promise {\n const result = await sqlite.execute(\n `SELECT id, short_id, original_url, created_at, click_count FROM ${LINKS_TABLE} ORDER BY created_at DESC`\n );\n \n return result.rows.map(row => ({\n id: row[0] as number,\n shortId: row[1] as string,\n originalUrl: row[2] as string,\n createdAt: row[3] as number,\n clickCount: row[4] as number\n }));\n}",[],[178,194,202],"2cd51498-13c4-11f0-a750-569c3dd06744","migrations.ts","2cd5156a-13c4-11f0-a750-569c3dd06744",["D",1744039373508],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table name with version to allow for schema changes\nexport const LINKS_TABLE = 'link_shortener_links_v1';\n\nexport async function setupDatabase() {\n // Create the links table if it doesn't exist\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${LINKS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n short_id TEXT NOT NULL UNIQUE,\n original_url TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n click_count INTEGER DEFAULT 0\n )\n `);\n \n // Create an index on short_id for faster lookups\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${LINKS_TABLE}_short_id ON ${LINKS_TABLE} (short_id)\n `);\n}",[],[178,194,210],"deeb460e-13c2-11f0-a341-569c3dd06744",["D",1744038813299],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","c7d91915-4070-4350-8e28-6c792ff73b1c","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","9ee5b56c-6e87-47cb-98e4-c31219468b31","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_268":264},"org",{"_11":12,"_262":-5,"_263":264,"_225":226,"_265":266,"_267":58},"branch",{"_17":93,"_13":16,"_37":45,"_254":216,"_255":-5,"_256":-5,"_257":-5,"_258":-5,"_259":-5,"_260":14,"_261":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaTFCT2UzVDJHbzF6RjhPTnpBd3p6VEJHZEQifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_37":216,"_13":14,"_50":361,"_218":-5,"_219":58,"_220":221,"_222":221,"_223":-5,"_224":-5,"_225":226,"_227":92,"_228":49,"_229":-5,"_230":93,"_231":52,"_232":233,"_234":-5,"_235":-5,"_236":-5,"_237":-5,"_238":239,"_240":239,"_241":242,"_243":242,"_244":242,"_245":239,"_246":239,"_247":362,"_249":363,"_251":364,"_253":58},[307,312,321,323,324],"files",[307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324],"counts",{"_297":52,"_298":299,"_300":52,"_32":301,"_302":303},[289,290,291,292],{"_37":82,"_13":19,"_40":43,"_42":-5,"_44":45,"_46":64,"_48":49,"_50":83,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_18":288},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_37":75,"_13":76,"_40":77,"_42":43,"_44":45,"_46":78,"_48":49,"_50":79,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_18":296},{"_37":68,"_13":69,"_40":70,"_42":43,"_44":45,"_46":71,"_48":49,"_50":72,"_17":52,"_53":24,"_55":73,"_57":58,"_59":-5,"_18":295},{"_37":61,"_13":62,"_40":63,"_42":43,"_44":45,"_46":64,"_48":49,"_50":65,"_17":52,"_53":24,"_55":66,"_57":58,"_59":-5,"_18":294},{"_37":38,"_13":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_17":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_18":293},[19,39],[19,62],[19,69],[19,76],"pulls","branches",1,"forks",{"_304":52,"_306":52},"connections",{"_304":52,"_305":52},"count","unfilledCount","emptyCount",{"_37":177,"_13":178,"_40":179,"_42":-5,"_44":45,"_46":180,"_48":49,"_50":181,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_97":359,"_18":360},{"_37":193,"_13":194,"_40":195,"_42":179,"_44":45,"_46":180,"_48":49,"_50":196,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_97":357,"_18":358},{"_37":209,"_13":210,"_40":211,"_42":195,"_44":45,"_46":180,"_48":49,"_50":212,"_17":52,"_53":54,"_55":213,"_57":58,"_59":-5,"_97":355,"_18":356},{"_37":201,"_13":202,"_40":203,"_42":195,"_44":45,"_46":204,"_48":49,"_50":205,"_17":52,"_53":54,"_55":206,"_57":58,"_59":-5,"_97":353,"_18":354},{"_37":186,"_13":91,"_40":187,"_42":179,"_44":45,"_46":188,"_48":49,"_50":189,"_17":52,"_53":54,"_55":190,"_57":58,"_59":-5,"_97":351,"_18":352},{"_37":82,"_13":19,"_40":43,"_42":-5,"_44":45,"_46":64,"_48":49,"_50":123,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_97":349,"_18":350},{"_37":75,"_13":76,"_40":77,"_42":43,"_44":45,"_46":78,"_48":49,"_50":139,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_97":347,"_18":348},{"_37":169,"_13":170,"_40":171,"_42":77,"_44":45,"_46":172,"_48":49,"_50":173,"_17":52,"_53":54,"_55":174,"_57":58,"_59":-5,"_97":345,"_18":346},{"_37":162,"_13":163,"_40":164,"_42":77,"_44":45,"_46":78,"_48":49,"_50":165,"_17":52,"_53":54,"_55":166,"_57":58,"_59":-5,"_97":343,"_18":344},{"_37":154,"_13":155,"_40":156,"_42":77,"_44":45,"_46":157,"_48":49,"_50":158,"_17":52,"_53":54,"_55":159,"_57":58,"_59":-5,"_97":341,"_18":342},{"_37":146,"_13":147,"_40":148,"_42":77,"_44":45,"_46":149,"_48":49,"_50":150,"_17":52,"_53":54,"_55":151,"_57":58,"_59":-5,"_97":339,"_18":340},{"_37":68,"_13":69,"_40":70,"_42":43,"_44":45,"_46":71,"_48":49,"_50":136,"_17":52,"_53":24,"_55":73,"_57":58,"_59":-5,"_97":337,"_18":338},{"_37":61,"_13":62,"_40":63,"_42":43,"_44":45,"_46":64,"_48":49,"_50":133,"_17":52,"_53":24,"_55":66,"_57":58,"_59":-5,"_97":335,"_18":336},{"_37":38,"_13":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":130,"_17":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_97":333,"_18":334},{"_37":108,"_13":109,"_40":110,"_42":-5,"_44":45,"_46":111,"_48":49,"_50":112,"_17":52,"_53":80,"_55":-5,"_57":58,"_59":-5,"_97":331,"_18":332},{"_37":116,"_13":117,"_40":118,"_42":110,"_44":45,"_46":111,"_48":49,"_50":119,"_17":52,"_53":54,"_55":120,"_57":58,"_59":-5,"_97":329,"_18":330},{"_37":100,"_13":101,"_40":102,"_42":-5,"_44":45,"_46":103,"_48":49,"_50":104,"_17":52,"_53":24,"_55":105,"_57":58,"_59":-5,"_97":327,"_18":328},{"_37":90,"_13":91,"_40":92,"_42":-5,"_44":45,"_46":93,"_48":49,"_50":94,"_17":71,"_53":95,"_55":96,"_57":58,"_59":-5,"_97":325,"_18":326},[],[91],[],[101],[],[109,117],[322],[109],[],[19,39],[],[19,62],[],[19,69],[],[19,76,147],[],[19,76,155],[],[19,76,163],[],[19,76,170],[314,315,316,317],[19,76],[313,318,319,320],[19],[],[178,91],[],[178,194,202],[],[178,194,210],[309,310],[178,194],[308,311],[178],["D",1744038813299],{"_11":12,"_268":264},{"_11":12,"_262":-5,"_263":264,"_225":226,"_265":266,"_267":58},{"_17":93,"_13":16,"_37":45,"_254":216,"_255":-5,"_256":-5,"_257":-5,"_258":-5,"_259":-5,"_260":14,"_261":12},"ctx",{"_247":-5,"_285":398,"_399":400,"_401":402,"_403":58,"_404":58,"_405":58,"_406":49,"_407":-5,"_408":-7,"_409":-7,"_410":52,"_411":58,"_412":58,"_413":-5,"_414":58,"_415":58,"_416":58,"_417":-5},"ENV",{"_369":370,"_371":372,"_373":16,"_374":375,"_376":377,"_378":379,"_380":381,"_382":383,"_384":385,"_386":387,"_388":389,"_390":391,"_392":393,"_394":395,"_396":397},"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"]