Login to Lucia Demo

Your one-time login code is:

\n ${code}\n

This code will expire in 5 minutes.

If you didn't request this code, you can safely ignore this email.

\n `,\n });\n\n return true;\n } catch (error) {\n console.error(\"Error sending email:\", error);\n return false;\n }\n}\n\n// Validate an OTP code and return user ID\nexport async function validateOTPCode(userEmail: string, code: string): Promise<{ valid: boolean; userId?: number }> {\n const now = Math.floor(Date.now() / 1000);\n\n // Get the code from the database\n const { rows } = await sqlite.execute(\n `SELECT code, expires_at FROM ${OTP_CODES_TABLE} WHERE email = ? ORDER BY created_at DESC LIMIT 1`,\n [userEmail],\n );\n\n if (rows.length === 0) {\n console.log(\"No OTP code found for email:\", userEmail);\n return { valid: false };\n }\n\n const storedCode = rows[0][0];\n const expiresAt = rows[0][1];\n\n // Check if the code has expired\n if (now > expiresAt) {\n console.log(\"OTP code has expired\");\n // Delete expired code\n await sqlite.execute(`DELETE FROM ${OTP_CODES_TABLE} WHERE email = ?`, [userEmail]);\n return { valid: false };\n }\n\n // Check if the code matches\n if (storedCode !== code) {\n console.log(\"OTP code does not match\");\n return { valid: false };\n }\n\n console.log(\"Valid OTP code\");\n\n // Get or create the user\n const { rows: userRows } = await sqlite.execute(\n `SELECT id FROM ${USER_TABLE} WHERE email = ?`,\n [userEmail],\n );\n\n let userId: number;\n\n if (userRows.length === 0) {\n console.log(\"Creating user\", userEmail);\n // Create a new user\n const { lastInsertRowid } = await sqlite.execute(\n `INSERT INTO ${USER_TABLE} (email, created_at) VALUES (?, ?)`,\n [userEmail, now],\n );\n userId = lastInsertRowid;\n } else {\n console.log(\"Found user\", userEmail);\n userId = userRows[0][0];\n }\n\n // Delete the used code\n await sqlite.execute(`DELETE FROM ${OTP_CODES_TABLE} WHERE email = ?`, [userEmail]);\n\n return { valid: true, userId };\n}","deleted","label",[171,172,153],"backend","database","permalink","https://www.val.town/x/dcm31/luciaOTP/code/backend/database/otp-codes.ts","extension","actionData","errors"]