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(\n token: string,\n): 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 = ?`, [\n tokenHash,\n ]);\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}","deleted","label",[185,186,169],"backend","database","permalink","https://www.val.town/x/arfan/vt-luciaMagicLinkStarter/code/backend/database/magic-links.ts","extension","actionData","errors"]