[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_325":326,"_327":328},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_239":-5,"_20":240,"_22":241,"_242":243,"_244":245,"_26":246,"_24":247,"_248":249,"_250":251,"_252":53,"_253":254,"_255":72,"_256":-5,"_257":-5,"_258":259},"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":29,"_30":-5,"_31":32,"_33":34,"_35":-5},"handle","tsuchi_ya","name","luciaMagicLinkStarter","branchName","main","version","path","frontend/index.html","project",{"_36":195,"_13":14,"_38":196,"_51":-5,"_197":53,"_54":55,"_198":55,"_199":-5,"_200":-5,"_201":202,"_203":152,"_204":72,"_205":72,"_206":-5,"_207":32,"_58":208,"_209":-5,"_210":-5,"_211":-5,"_212":-5,"_213":214,"_215":214,"_216":217,"_218":217,"_219":217,"_220":214,"_221":214,"_222":223,"_224":225,"_226":227,"_52":53},"tree",[81,82,83],"file",{"_36":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_38":73,"_17":32,"_74":24,"_75":76,"_77":53,"_78":-5,"_18":79},"contents",[],"upstream",{"_36":37,"_38":39,"_40":41,"_13":16,"_42":43,"_17":44,"_45":46,"_47":48,"_49":50,"_51":-5,"_52":53,"_54":55,"_56":57,"_58":59,"_60":14},"pull","ahead",0,"behind",5,"envVars","id","d58458a4-2b7c-11f0-b025-569c3dd06744","createdAt",["D",1746647560619],"updatedAt",["D",1770901632622],"projectId","d5804cd2-2b7c-11f0-b025-569c3dd06744",174,"forkedBranchId","961078ea-f528-11ef-aa68-569c3dd06744","forkedBranchVersion",39,"lockfileKey","1781070447004-esm.town_v_stevekrouse_luciaMagicLinkStarter@174-main","deletedAt","isOwned",false,"privacy","public","userHandle","stevekrouse","orgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","projectName","31e8bbec-3949-11f0-817e-9e149126039e","index.html","fileId","f7884d8a-092b-43b0-9a20-78cf7026b3fe","parentId","110c2d10-9afe-4d5d-af09-3fa67bb3561c","branchId","31e5b58c-3949-11f0-817e-9e149126039e","branchVersion",1,"latest",true,["D",1748164698080],"fileType","content","\n\n \n \n \n Lucia Auth Demo\n \n \n \n

\n \n \n \n","deleted","label",[80,62],"frontend",{"_36":141,"_13":142,"_63":143,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":144,"_17":32,"_74":94,"_75":-5,"_77":53,"_78":-5,"_89":145,"_18":146},{"_36":92,"_13":80,"_63":66,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":93,"_17":32,"_74":94,"_75":-5,"_77":53,"_78":-5,"_89":95,"_18":96},{"_36":84,"_13":85,"_63":86,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":87,"_17":32,"_74":24,"_75":88,"_77":53,"_78":-5,"_89":90,"_18":91},"31e8c0ce-3949-11f0-817e-9e149126039e","README.md","c284661c-907f-485d-a752-d3a32a242c83",["D",1748164698080],"# Lucia Auth Starter\n\nA demonstration of [Lucia, the guide](https://lucia-next.pages.dev/), and magic link authentication using Val Town.\n\nThis uses [Val Town SQLite](https://docs.val.town/std/sqlite/) and [Val Town Email](https://docs.val.town/std/email/), so you can Remix & roll-your-own-auth in a single-click. Literally zero set up required.\n\nNote: Sending emails to users besides yourself requires [Val Town Pro](https://www.val.town/pricing).\n\n## Features\n\n- Magic link authentication\n- Server-side rendering with client-side hydration\n- User profile management (username editing)\n- Session management with secure cookies\n- Responsive UI with Tailwind CSS\n\n## Authentication Flow\n\n1. User enters their email address on the login page\n2. A magic link is sent to the user's email\n3. User clicks the magic link in their email\n4. The server validates the token, creates a session, and sets a secure cookie\n5. User is redirected to the authenticated home page\n\n## Technical Implementation\n\n- **Database**:[Val Town SQLite](https://docs.val.town/std/sqlite/) for storing users, sessions, and magic link tokens\n- **Frontend**: React with Tailwind CSS\n- **Backend**: Hono.js for API routes and middleware\n- **Authentication**: Built by following the [Lucia guide](https://lucia-next.pages.dev/)\n\n## API Endpoints\n\nProvided by the Auth Middleware in `backend/auth.ts`:\n\n- `POST /auth/magic-link` - Request a magic link\n- `GET /auth/magic-link/:token` - Validate a magic link token\n- `POST /auth/logout` - Log out the current user\n\nIn the app's API, in `backend/index.ts`:\n\n- `POST /api/user/username` - Update the user's username\n\n## Notes\n\n- Email sending requires Val Town Pro subscription for sending to addresses other than your own\n- Magic links expire after 15 minutes\n- Session tokens are automatically rotated when 50% of their lifetime remains (15 days)\n- Sessions expire after 30 days\n\n## Todos\n\n- When I tried to make the magic link token single-use, it caused issues. I think the best practice there is something a bit more complicated, ie a GET request to an HTML page that makes a POST request.\n- When I tried to make the SameSite=Strict, the cookie stopped working. It's currently Lax, which I think is OK, but it'd be nice to know Strict isn't working.","children",[],[85],"31e8bf16-3949-11f0-817e-9e149126039e",["D",1748164698080],"directory",[97,98,99],[80],{"_36":111,"_13":112,"_63":113,"_65":66,"_67":68,"_69":70,"_71":72,"_38":114,"_17":32,"_74":94,"_75":-5,"_77":53,"_78":-5,"_89":115,"_18":116},{"_36":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_38":108,"_17":32,"_74":24,"_75":76,"_77":53,"_78":-5,"_89":109,"_18":110},{"_36":100,"_13":101,"_63":102,"_65":66,"_67":68,"_69":70,"_71":72,"_38":103,"_17":32,"_74":104,"_75":105,"_77":53,"_78":-5,"_89":106,"_18":107},"31e8bd7c-3949-11f0-817e-9e149126039e","index.tsx","6b75f346-7753-489d-9c23-ca816da6e87a",["D",1748164698080],"script","/** @jsxImportSource 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 initialDataString = document.getElementById(\"initial-data\")!.textContent as string;\nlet initialData = JSON.parse(initialDataString);\n\nconst urlParams = new URLSearchParams(window.location.search);\nconst errorParam = urlParams.get(\"error\");\nif (errorParam === \"invalid_token\" && !initialData.user) {\n initialData.error = \"Invalid or expired magic link. Please request a new one.\";\n} else {\n initialData.error = errorParam;\n}\n\ncreateRoot(document.getElementById(\"root\")!).render();",[],[80,101],["D",1748164698080],[],[80,62],"31e8ba3e-3949-11f0-817e-9e149126039e","components","8d59cbd3-8da9-4064-ada9-886e58eb2ebd",["D",1748164698080],[117,118,119],[80,112],{"_36":134,"_13":135,"_63":136,"_65":113,"_67":68,"_69":70,"_71":72,"_38":137,"_17":32,"_74":104,"_75":138,"_77":53,"_78":-5,"_89":139,"_18":140},{"_36":127,"_13":128,"_63":129,"_65":113,"_67":68,"_69":70,"_71":72,"_38":130,"_17":32,"_74":104,"_75":131,"_77":53,"_78":-5,"_89":132,"_18":133},{"_36":120,"_13":121,"_63":122,"_65":113,"_67":68,"_69":70,"_71":72,"_38":123,"_17":32,"_74":104,"_75":124,"_77":53,"_78":-5,"_89":125,"_18":126},"31e8b46c-3949-11f0-817e-9e149126039e","UserProfile.tsx","136566b7-03ef-400d-88dc-e776d9bbb1dc",["D",1748164698080],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface User {\n id: number;\n email?: string;\n username?: string;\n}\n\ninterface UserProfileProps {\n user: User;\n onUpdate: (user: User) => void;\n}\n\nexport function UserProfile({ user, onUpdate }: UserProfileProps) {\n const [username, setUsername] = useState(user.username || \"\");\n const [isEditing, setIsEditing] = useState(false);\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(null);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n\n if (!username.trim()) {\n setError(\"Username cannot be empty\");\n return;\n }\n\n // Client-side validation to match server-side rules\n if (username.length < 3 || username.length > 50) {\n setError(\"Username must be between 3 and 50 characters\");\n return;\n }\n\n // Ensure username is only letters and numbers\n if (!/^[a-zA-Z0-9]+$/.test(username)) {\n setError(\"Username can only contain letters and numbers\");\n return;\n }\n\n setIsSubmitting(true);\n setError(null);\n\n try {\n const response = await fetch(\"/api/user/username\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ username }),\n });\n\n const data = await response.json();\n\n if (!response.ok) {\n throw new Error(data.error || \"Failed to update username\");\n }\n\n onUpdate({ ...user, username });\n setIsEditing(false);\n } catch (err) {\n console.error(\"Error updating username:\", err);\n setError(err instanceof Error ? err.message : \"Failed to update username\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n return (\n

Welcome!

\n Email: {user.email}\n

\n\n {error && (\n

\n {error}\n setError(null)}\n >\n ×\n \n

\n )}\n\n {isEditing\n ? (\n \n )\n : (\n

\n Username: {user.username\n ? {user.username}\n : Not set}\n

\n setIsEditing(true)}\n >\n {user.username ? \"Edit Username\" : \"Set Username\"}\n \n

\n )}\n\n

\n \n Logout\n \n

\n );\n}",[],[80,112,121],"31e8ae7c-3949-11f0-817e-9e149126039e","LoginForm.tsx","e09b859b-4056-4ecc-8bff-e33c4e12b448",["D",1748164698080],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface LoginFormProps {\n onError: (error: string) => void;\n}\n\nexport function LoginForm({ onError }: LoginFormProps) {\n const [email, setEmail] = useState(\"\");\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [emailSent, setEmailSent] = useState(false);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n\n if (!email || !email.includes(\"@\")) {\n onError(\"Please enter a valid email address\");\n return;\n }\n\n setIsSubmitting(true);\n\n try {\n const response = await fetch(\"/auth/magic-link\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ email }),\n });\n\n const data = await response.json();\n\n if (!response.ok) {\n if (data.error) {\n onError(data.error);\n return;\n }\n throw new Error(data.error || \"Failed to send magic link\");\n }\n setEmailSent(true);\n } catch (err) {\n console.error(\"Error sending magic link:\", err);\n onError(err instanceof Error ? err.message : \"Failed to send magic link\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n if (emailSent) {\n return (\n

Check your email!

\n We've sent a magic link to {email}. Click the link in the email to log in.\n

\n );\n }\n\n return (\n

\n \n

\n );\n}",[],[80,112,128],"31e8ad1e-3949-11f0-817e-9e149126039e","App.tsx","fb00d902-a82f-4d53-bcc9-9bcd808362b9",["D",1748164698080],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { LoginForm } from \"./LoginForm.tsx\";\nimport { UserProfile } from \"./UserProfile.tsx\";\n\ninterface User {\n id: number;\n email?: string;\n username?: string;\n}\n\ninterface InitialData {\n user: User | null;\n projectURL: string;\n error: string | null;\n}\n\nexport function App({ initialData }: { initialData: InitialData }) {\n const [user, setUser] = useState(initialData.user);\n const [error, setError] = useState(initialData.error);\n\n // Update user data after username change\n const updateUser = (updatedUser: User) => {\n setUser(updatedUser);\n };\n\n return (\n

Lucia Demo

\n\n {error && (\n

\n {error}\n setError(null)}\n >\n ×\n \n

\n )}\n\n

\n \n View Source Code\n \n

\n\n {user ? : }\n

\n );\n}",[],[80,112,135],"31e8abb6-3949-11f0-817e-9e149126039e","backend","328be5d6-0800-45ae-90f4-021c58e5fc18",["D",1748164698080],[147,148,149],[142],{"_36":165,"_13":166,"_63":167,"_65":143,"_67":68,"_69":70,"_71":72,"_38":168,"_17":32,"_74":94,"_75":-5,"_77":53,"_78":-5,"_89":169,"_18":170},{"_36":158,"_13":159,"_63":160,"_65":143,"_67":68,"_69":70,"_71":72,"_38":161,"_17":32,"_74":104,"_75":162,"_77":53,"_78":-5,"_89":163,"_18":164},{"_36":150,"_13":151,"_63":152,"_65":143,"_67":68,"_69":70,"_71":72,"_38":153,"_17":32,"_74":154,"_75":155,"_77":53,"_78":-5,"_89":156,"_18":157},"31e8a8dc-3949-11f0-817e-9e149126039e","index.ts","2d1eb53b-7996-48f4-bd36-2c46ff926b94",["D",1748164698080],"http","import { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { Hono } from \"npm:hono\";\nimport { authMiddleware } from \"./auth.ts\";\nimport { USER_TABLE } from \"./database/schema.ts\";\n\nconst app = new Hono();\n\n// Serve all /frontend files\napp.get(\"/frontend/**/*\", c => serveFile(c.req.path, import.meta.url));\n\napp.use(authMiddleware);\n\n// Serve index.html at the root / with bootstrapped data\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n const user = c.get(\"user\");\n const dataScript = ``;\n\n // Insert the script right before the closing tag\n html = html.replace(\"\", `${dataScript}`);\n\n return c.html(html);\n});\n\n// API endpoint to update username\napp.post(\"/api/user/username\", async c => {\n const user = c.get(\"user\");\n\n if (!user) {\n return c.json({ success: false, error: \"Not authenticated\" }, 401);\n }\n\n try {\n const { username } = await c.req.json();\n\n if (!username || typeof username !== \"string\") {\n return c.json({ success: false, error: \"Invalid username\" }, 400);\n }\n\n // Validate username length (3-50 characters)\n if (username.length < 3 || username.length > 50) {\n return c.json({\n success: false,\n error: \"Username must be between 3 and 50 characters\",\n }, 400);\n }\n\n // Validate username contains only alphanumeric characters\n if (!/^[a-zA-Z0-9]+$/.test(username)) {\n return c.json({\n success: false,\n error: \"Username contains invalid characters\",\n }, 400);\n }\n\n // Update the username\n await sqlite.execute(\n `UPDATE ${USER_TABLE} SET username = ? WHERE id = ?`,\n [username, user.id],\n );\n\n return c.json({ success: true, username });\n } catch (error) {\n console.error(\"Error updating username:\", error);\n return c.json({ success: false, error: \"An unexpected error occurred\" }, 500);\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, c) => {\n throw err;\n});\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;",[],[142,151],"31e8a526-3949-11f0-817e-9e149126039e","auth.ts","f67d09f2-df46-46e7-8cf9-f4096adbb134",["D",1748164698080],"import { getCookie, setCookie } from \"npm:hono/cookie\";\nimport { createMiddleware } from \"npm:hono/factory\";\nimport { createMagicLinkToken, sendMagicLinkEmail, validateMagicLinkToken } from \"./database/magic-links.ts\";\nimport { createSession, generateSessionToken, invalidateSession, validateSessionToken } from \"./database/sessions.ts\";\n\nexport const authMiddleware = createMiddleware(async (c, next) => {\n const url = new URL(c.req.url);\n const path = url.pathname;\n const origin = c.req.header(\"Origin\");\n\n // CSRF Protection, more info: https://lucia-next.pages.dev/sessions/cookies/\n if (c.req.method !== \"GET\") {\n const host = new URL(c.req.url).hostname;\n if (origin === null || origin !== url.origin) {\n return c.text(\"CSRF Protection\", 401);\n }\n }\n\n // Handle magic link request\n if (path === \"/auth/magic-link\" && c.req.method === \"POST\") {\n try {\n const { email } = await c.req.json();\n\n if (!email || typeof email !== \"string\" || !email.includes(\"@\")) {\n return c.json({ success: false, error: \"Invalid email address\" }, 400);\n }\n\n // Create a magic link token\n const token = await createMagicLinkToken(email);\n\n // Send the magic link email\n const emailSent = await sendMagicLinkEmail(url.origin, email, token);\n\n if (!emailSent) {\n return c.json({\n success: false,\n error:\n \"Failed to send email. Val Town requires Pro subscription to send emails to addresses other than your own. See https://www.val.town/pricing\",\n }, 500);\n }\n\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error creating magic link:\", error);\n return c.json({ success: false, error: \"An unexpected error occurred\" }, 500);\n }\n }\n\n // Handle magic link validation\n if (path.startsWith(\"/auth/magic-link/\") && c.req.method === \"GET\") {\n const token = path.split(\"/\").pop();\n if (token) {\n const result = await validateMagicLinkToken(token);\n if (result.valid && result.userId) {\n // Create a new session\n const sessionToken = generateSessionToken();\n await createSession(sessionToken, result.userId);\n\n // Set the session cookie\n setCookie(c, \"session\", sessionToken, {\n httpOnly: true,\n secure: true,\n sameSite: \"Lax\",\n path: \"/\",\n maxAge: 60 * 60 * 24 * 30, // 30 days\n });\n\n // Redirect to the home page\n return c.redirect(\"/\");\n } else {\n // Invalid or expired token\n return c.redirect(\"/?error=invalid_token\");\n }\n }\n }\n\n // Regular session validation\n const token = getCookie(c, \"session\");\n if (token) {\n const { session, user, newToken } = await validateSessionToken(token);\n // If a new token was generated (session rotation), update the cookie\n if (newToken) {\n setCookie(c, \"session\", newToken, {\n httpOnly: true,\n secure: true,\n sameSite: \"Lax\",\n path: \"/\",\n maxAge: 60 * 60 * 24 * 30, // 30 days\n });\n }\n\n // Handle logout\n if (session && path === \"/auth/logout\") {\n await invalidateSession(session.id);\n\n setCookie(c, \"session\", \"\", {\n httpOnly: true,\n secure: true,\n sameSite: \"Lax\",\n path: \"/\",\n maxAge: 0,\n });\n\n return c.redirect(\"/\");\n }\n\n if (user) {\n c.set(\"user\", user);\n } else {\n // delete the session cookie\n setCookie(c, \"session\", \"\", {\n httpOnly: true,\n secure: true,\n sameSite: \"Lax\",\n path: \"/\",\n maxAge: 0,\n });\n }\n }\n\n // If you end up on the logout page when you weren't logged in, redirect to the home page\n if (path === \"/auth/logout\") {\n return c.redirect(\"/\");\n }\n\n await next();\n});",[],[142,159],"31e8a35a-3949-11f0-817e-9e149126039e","database","6a53a440-00d9-46ff-86b5-f0a277d16acb",["D",1748164698080],[171,172,173],[142,166],{"_36":188,"_13":189,"_63":190,"_65":167,"_67":68,"_69":70,"_71":72,"_38":191,"_17":32,"_74":104,"_75":192,"_77":53,"_78":-5,"_89":193,"_18":194},{"_36":181,"_13":182,"_63":183,"_65":167,"_67":68,"_69":70,"_71":72,"_38":184,"_17":32,"_74":104,"_75":185,"_77":53,"_78":-5,"_89":186,"_18":187},{"_36":174,"_13":175,"_63":176,"_65":167,"_67":68,"_69":70,"_71":72,"_38":177,"_17":32,"_74":104,"_75":178,"_77":53,"_78":-5,"_89":179,"_18":180},"31e8a030-3949-11f0-817e-9e149126039e","sessions.ts","11859c6a-bb9d-402f-8180-bea854d96f61",["D",1748164698080],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { sha256 } from \"npm:@oslojs/crypto/sha2\";\nimport { encodeBase32LowerCaseNoPadding, encodeHexLowerCase } from \"npm:@oslojs/encoding\";\nimport { SESSIONS_TABLE, USER_TABLE } from \"./schema.ts\";\n\nexport function generateSessionToken(): string {\n const bytes = new Uint8Array(20);\n crypto.getRandomValues(bytes);\n const token = encodeBase32LowerCaseNoPadding(bytes);\n return token;\n}\n\nexport async function createSession(token: string, userId: number): Promise {\n const sessionId = encodeHexLowerCase(sha256(new TextEncoder().encode(token)));\n const session: Session = {\n id: sessionId,\n userId,\n expiresAt: new Date(Date.now() + 1000 * 60 * 60 * 24 * 30),\n };\n await sqlite.execute(\n `INSERT INTO ${SESSIONS_TABLE} (id, user_id, expires_at) VALUES (?, ?, ?)`,\n [session.id, session.userId, Math.floor(session.expiresAt.getTime() / 1000)],\n );\n return session;\n}\n\nexport async function validateSessionToken(token: string): Promise {\n const sessionId = encodeHexLowerCase(sha256(new TextEncoder().encode(token)));\n const { rows } = await sqlite.execute(\n `SELECT s.id, s.user_id, s.expires_at, u.id, u.email, u.username \n FROM ${SESSIONS_TABLE} s \n INNER JOIN ${USER_TABLE} u ON u.id = s.user_id \n WHERE s.id = ?`,\n [sessionId],\n );\n\n if (rows.length === 0) {\n return { session: null, user: null };\n }\n\n const row = rows[0];\n const session: Session = {\n id: row[0],\n userId: row[1],\n expiresAt: new Date(row[2] * 1000),\n };\n const user: User = {\n id: row[3],\n email: row[4],\n username: row[5],\n };\n\n if (Date.now() >= session.expiresAt.getTime()) {\n await sqlite.execute(`DELETE FROM ${SESSIONS_TABLE} WHERE id = ?`, [session.id]);\n return { session: null, user: null };\n }\n\n // If 50% of the session lifetime has passed (15 days out of 30), rotate the token\n if (Date.now() >= session.expiresAt.getTime() - 1000 * 60 * 60 * 24 * 15) {\n // Generate a new token\n const newToken = generateSessionToken();\n const newSessionId = encodeHexLowerCase(sha256(new TextEncoder().encode(newToken)));\n\n // Create a new session with the new token\n const newExpiresAt = new Date(Date.now() + 1000 * 60 * 60 * 24 * 30);\n\n // Insert the new session\n await sqlite.execute(\n `INSERT INTO ${SESSIONS_TABLE} (id, user_id, expires_at) VALUES (?, ?, ?)`,\n [newSessionId, session.userId, Math.floor(newExpiresAt.getTime() / 1000)],\n );\n\n // Delete the old session\n await sqlite.execute(`DELETE FROM ${SESSIONS_TABLE} WHERE id = ?`, [session.id]);\n\n // Return the new session and token\n const newSession: Session = {\n id: newSessionId,\n userId: session.userId,\n expiresAt: newExpiresAt,\n };\n\n return { session: newSession, user, newToken };\n }\n\n return { session, user };\n}\n\nexport async function invalidateSession(sessionId: string): Promise {\n await sqlite.execute(`DELETE FROM ${SESSIONS_TABLE} WHERE id = ?`, [sessionId]);\n}\n\nexport type SessionValidationResult =\n | { session: Session; user: User; newToken?: string }\n | { session: null; user: null };\n\nexport interface Session {\n id: string;\n userId: number;\n expiresAt: Date;\n}\n\nexport interface User {\n id: number;\n email?: string;\n username?: string;\n}",[],[142,166,175],"31e89cde-3949-11f0-817e-9e149126039e","schema.ts","1c12d656-7d60-47fe-b070-b53c002b59a6",["D",1748164698080],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport const USER_TABLE = \"lucia_demo_users\";\nexport const SESSIONS_TABLE = \"lucia_demo_sessions\";\nexport const MAGIC_LINKS_TABLE = \"lucia_demo_magic_links_v2\";\n\nasync function createTables() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USER_TABLE} (\n id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,\n created_at INTEGER NOT NULL,\n email STRING UNIQUE,\n username STRING UNIQUE\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SESSIONS_TABLE} (\n id TEXT NOT NULL PRIMARY KEY,\n user_id INTEGER NOT NULL REFERENCES ${USER_TABLE}(id),\n expires_at INTEGER NOT NULL\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MAGIC_LINKS_TABLE} (\n id TEXT NOT NULL PRIMARY KEY,\n email TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n expires_at INTEGER NOT NULL\n )\n `);\n}\n\nawait createTables();",[],[142,166,182],"31e873ee-3949-11f0-817e-9e149126039e","magic-links.ts","67598069-620b-47e3-add0-81340a697678",["D",1748164698080],"import { email } from \"https://esm.town/v/std/email\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { sha256 } from \"npm:@oslojs/crypto/sha2\";\nimport { encodeHexLowerCase } from \"npm:@oslojs/encoding\";\nimport { MAGIC_LINKS_TABLE, USER_TABLE } from \"./schema.ts\";\nimport { createSession, generateSessionToken } from \"./sessions.ts\";\n\n// Hash a token using sha256\nfunction hashToken(token: string): string {\n return encodeHexLowerCase(sha256(new TextEncoder().encode(token)));\n}\n\n// Create a magic link token for the given email\nexport async function createMagicLinkToken(userEmail: string): Promise {\n const token = generateSessionToken();\n const tokenHash = hashToken(token);\n const now = Math.floor(Date.now() / 1000);\n const expiresAt = now + 60 * 15; // 15 minutes expiration\n\n await sqlite.execute(\n `INSERT INTO ${MAGIC_LINKS_TABLE} (id, email, created_at, expires_at) VALUES (?, ?, ?, ?)`,\n [tokenHash, userEmail, now, expiresAt],\n );\n\n return token;\n}\n\n// Send a magic link email\nexport async function sendMagicLinkEmail(url: string, userEmail: string, token: string): Promise {\n try {\n const magicLink = `${url}/auth/magic-link/${token}`;\n\n await email({\n to: userEmail,\n subject: \"Your login link for Lucia Demo\",\n text: `Click this link to log in: ${magicLink}`,\n html: `\n

Login to Lucia Demo

Click the button below to log in:

\n \n Log in\n \n

Or copy and paste this URL into your browser:

${magicLink}

This link will expire in 15 minutes.

\n `,\n });\n\n return true;\n } catch (error) {\n console.error(\"Error sending email:\", error);\n return false;\n }\n}\n\n// Validate a magic link token and create a session\nexport async function validateMagicLinkToken(token: string): Promise<{ valid: boolean; userId?: number }> {\n const now = Math.floor(Date.now() / 1000);\n const tokenHash = hashToken(token);\n\n // Get the token from the database using its hash\n const { rows } = await sqlite.execute(\n `SELECT email, expires_at FROM ${MAGIC_LINKS_TABLE} WHERE id = ?`,\n [tokenHash],\n );\n\n if (rows.length === 0) {\n console.log(\"Did not find magic link token in database\");\n return { valid: false };\n }\n\n const { email, expiresAt } = rows[0];\n\n // Check if the token has expired\n if (now > expiresAt) {\n console.log(\"Magic link token has expired\", expiresAt);\n // Delete expired token\n await sqlite.execute(`DELETE FROM ${MAGIC_LINKS_TABLE} WHERE id = ?`, [tokenHash]);\n return { valid: false };\n }\n\n console.log(\"Valid magic link token\");\n\n // Get or create the user\n const { rows: userRows } = await sqlite.execute(\n `SELECT id FROM ${USER_TABLE} WHERE email = ?`,\n [email],\n );\n\n let userId: number;\n\n if (userRows.length === 0) {\n console.log(\"Creating user\", email);\n // Create a new user\n const { lastInsertRowid } = await sqlite.execute(\n `INSERT INTO ${USER_TABLE} (email, created_at) VALUES (?, ?)`,\n [email, now],\n );\n userId = lastInsertRowid;\n } else {\n console.log(\"Found user\", email);\n userId = userRows[0][0];\n }\n\n // Delete the used token\n // TODO - investigate: I found that when I immediately delete the token (single use),\n // That it causes issues. It seems like somehow the token is getting used before it's getting used.\n // Maybe my browser or something is making a pre-flight request that's using it up? Maybe my email client?\n // await sqlite.execute(`DELETE FROM ${MAGIC_LINKS_TABLE} WHERE id = ?`, [tokenHash]);\n\n return { valid: true, userId };\n}",[],[142,166,189],"31e39b12-3949-11f0-817e-9e149126039e",["D",1748164698080],"legacyEnvVars","httpPrivacy","description","imageUrl","userId","fc0bd9ca-263d-48ce-84f0-30b4a2ea6082","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","fc71265b-929d-440a-aa31-727271a3da69","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_238":234},"org",{"_11":12,"_232":-5,"_233":234,"_201":202,"_235":236,"_237":53},"branch",{"_17":70,"_13":16,"_36":68,"_42":195,"_45":37,"_47":228,"_229":55,"_230":43,"_231":59,"_60":14,"_56":12},169,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycVRJUVhlbWlxQ1ZNUnJVcWpHQ1dWNGEwcU0ifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":195,"_13":14,"_38":321,"_51":-5,"_197":53,"_54":55,"_198":55,"_199":-5,"_200":-5,"_201":202,"_203":152,"_204":72,"_205":72,"_206":-5,"_207":32,"_58":208,"_209":-5,"_210":-5,"_211":-5,"_212":-5,"_213":214,"_215":214,"_216":217,"_218":217,"_219":217,"_220":214,"_221":214,"_222":322,"_224":323,"_226":324,"_52":53},[276,283,290],"files",[276,277,278,279,280,281,282,283,284,285,286,287,288,289,290],"counts",{"_267":32,"_268":70,"_269":32,"_35":270,"_271":272},[],{"_36":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_38":73,"_17":32,"_74":24,"_75":76,"_77":53,"_78":-5,"_18":266},"upstreamProject",{"_36":43,"_13":14,"_199":262,"_200":263,"_54":55,"_222":264},"upstreamBranch",{"_36":37,"_38":260,"_40":261,"_13":16,"_42":43,"_17":44,"_45":46,"_47":48,"_49":50,"_51":-5,"_52":53,"_54":55,"_56":57,"_58":59,"_60":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1746647560619],["D",1770901632622],"Demo app of roll-your-own auth & magic link login","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/ef5744e2-62bc-4f47-8081-012828fcc300/square512?exp=1789574399&sig=ed09f2dc4342e6c2a1631280962e5f4cd4147cedb459613f481a161dc8d7f669",{"_11":57,"_238":265},"https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",[80,62],"pulls","branches","forks",{"_273":32,"_275":32},"connections",{"_273":32,"_274":32},"count","unfilledCount","emptyCount",{"_36":141,"_13":142,"_63":143,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":144,"_17":32,"_74":94,"_75":-5,"_77":53,"_78":-5,"_89":319,"_18":320},{"_36":165,"_13":166,"_63":167,"_65":143,"_67":68,"_69":70,"_71":72,"_38":168,"_17":32,"_74":94,"_75":-5,"_77":53,"_78":-5,"_89":317,"_18":318},{"_36":188,"_13":189,"_63":190,"_65":167,"_67":68,"_69":70,"_71":72,"_38":191,"_17":32,"_74":104,"_75":192,"_77":53,"_78":-5,"_89":315,"_18":316},{"_36":181,"_13":182,"_63":183,"_65":167,"_67":68,"_69":70,"_71":72,"_38":184,"_17":32,"_74":104,"_75":185,"_77":53,"_78":-5,"_89":313,"_18":314},{"_36":174,"_13":175,"_63":176,"_65":167,"_67":68,"_69":70,"_71":72,"_38":177,"_17":32,"_74":104,"_75":178,"_77":53,"_78":-5,"_89":311,"_18":312},{"_36":158,"_13":159,"_63":160,"_65":143,"_67":68,"_69":70,"_71":72,"_38":161,"_17":32,"_74":104,"_75":162,"_77":53,"_78":-5,"_89":309,"_18":310},{"_36":150,"_13":151,"_63":152,"_65":143,"_67":68,"_69":70,"_71":72,"_38":153,"_17":32,"_74":154,"_75":155,"_77":53,"_78":-5,"_89":307,"_18":308},{"_36":92,"_13":80,"_63":66,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":93,"_17":32,"_74":94,"_75":-5,"_77":53,"_78":-5,"_89":305,"_18":306},{"_36":111,"_13":112,"_63":113,"_65":66,"_67":68,"_69":70,"_71":72,"_38":114,"_17":32,"_74":94,"_75":-5,"_77":53,"_78":-5,"_89":303,"_18":304},{"_36":134,"_13":135,"_63":136,"_65":113,"_67":68,"_69":70,"_71":72,"_38":137,"_17":32,"_74":104,"_75":138,"_77":53,"_78":-5,"_89":301,"_18":302},{"_36":127,"_13":128,"_63":129,"_65":113,"_67":68,"_69":70,"_71":72,"_38":130,"_17":32,"_74":104,"_75":131,"_77":53,"_78":-5,"_89":299,"_18":300},{"_36":120,"_13":121,"_63":122,"_65":113,"_67":68,"_69":70,"_71":72,"_38":123,"_17":32,"_74":104,"_75":124,"_77":53,"_78":-5,"_89":297,"_18":298},{"_36":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_38":108,"_17":32,"_74":24,"_75":76,"_77":53,"_78":-5,"_89":295,"_18":296},{"_36":100,"_13":101,"_63":102,"_65":66,"_67":68,"_69":70,"_71":72,"_38":103,"_17":32,"_74":104,"_75":105,"_77":53,"_78":-5,"_89":293,"_18":294},{"_36":84,"_13":85,"_63":86,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":87,"_17":32,"_74":24,"_75":88,"_77":53,"_78":-5,"_89":291,"_18":292},[],[85],[],[80,101],[],[80,62],[],[80,112,121],[],[80,112,128],[],[80,112,135],[285,286,287],[80,112],[284,288,289],[80],[],[142,151],[],[142,159],[],[142,166,175],[],[142,166,182],[],[142,166,189],[278,279,280],[142,166],[277,281,282],[142],["D",1748164698080],{"_11":12,"_238":234},{"_11":12,"_232":-5,"_233":234,"_201":202,"_235":236,"_237":53},{"_17":70,"_13":16,"_36":68,"_42":195,"_45":37,"_47":228,"_229":55,"_230":43,"_231":59,"_60":14,"_56":12},"ctx",{"_222":-5,"_257":358,"_359":360,"_361":362,"_363":53,"_364":53,"_365":53,"_366":72,"_367":-5,"_368":-7,"_369":-7,"_370":32,"_371":53,"_372":53,"_373":-5,"_374":53,"_375":53,"_376":53,"_377":-5},"ENV",{"_329":330,"_331":332,"_333":16,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357},"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"]