[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_108":109,"_110":111},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","ngzvhmcf","name","sambkw","path","lib/db.ts","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":-5,"_58":59,"_60":61,"_62":34,"_63":-5,"_64":-5,"_65":38,"_66":67,"_68":69,"_70":71,"_72":73,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/ngzvhmcf/sambkw/code/lib/db.ts","extension","id","93c7983a-fd89-49dd-852c-c7a263e8bc2e","db.ts","fileId","7522e8a4-a740-11f1-9639-1607ee4eb77e","parentId","33c1a848-fdd3-40ee-89f1-dbfc3d09a30d","branchId","f3696943-a273-4717-a367-2529b8699f92","branchVersion",3,"latest",true,"createdAt",["D",1788403071003],"version",0,"fileType","script","content","/**\n * SQLite schema + queries for users and sessions.\n * Database is scoped to this val.\n */\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface User {\n id: number;\n email: string;\n passwordHash: string;\n createdAt: number;\n}\n\nexport interface Session {\n token: string;\n userId: number;\n createdAt: number;\n}\n\nexport async function initDb(): Promise {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT NOT NULL UNIQUE,\n passwordHash TEXT NOT NULL,\n createdAt INTEGER NOT NULL\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS sessions (\n token TEXT PRIMARY KEY,\n userId INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,\n createdAt INTEGER NOT NULL\n )`);\n}\n\nexport async function createUser(\n email: string,\n passwordHash: string,\n): Promise {\n const res = await sqlite.execute({\n sql: \"INSERT INTO users (email, passwordHash, createdAt) VALUES (?, ?, ?)\",\n args: [email, passwordHash, Date.now()],\n });\n const id = Number(res.lastInsertRowid);\n return { id, email, passwordHash, createdAt: Date.now() };\n}\n\nexport async function findUserByEmail(email: string): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT id, email, passwordHash, createdAt FROM users WHERE email = ?\",\n args: [email],\n });\n const row = res.rows[0] as Record | undefined;\n if (!row) return null;\n return {\n id: row.id as number,\n email: row.email as string,\n passwordHash: row.passwordHash as string,\n createdAt: row.createdAt as number,\n };\n}\n\nexport async function findUserById(id: number): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT id, email, passwordHash, createdAt FROM users WHERE id = ?\",\n args: [id],\n });\n const row = res.rows[0] as Record | undefined;\n if (!row) return null;\n return {\n id: row.id as number,\n email: row.email as string,\n passwordHash: row.passwordHash as string,\n createdAt: row.createdAt as number,\n };\n}\n\nexport async function createSession(\n token: string,\n userId: number,\n): Promise {\n await sqlite.execute({\n sql: \"INSERT INTO sessions (token, userId, createdAt) VALUES (?, ?, ?)\",\n args: [token, userId, Date.now()],\n });\n}\n\nexport async function findSession(\n token: string,\n): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT token, userId, createdAt FROM sessions WHERE token = ?\",\n args: [token],\n });\n const row = res.rows[0] as Record | undefined;\n if (!row) return null;\n return {\n token: row.token as string,\n userId: row.userId as number,\n createdAt: row.createdAt as number,\n };\n}\n\nexport async function deleteSession(token: string): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM sessions WHERE token = ?\",\n args: [token],\n });\n}\n","deleted",false,"label",[47,24],"lib","7c95e742-1d59-467e-b1f7-289effbf1692",["D",1788403044901],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Sambkw sample website with working email+password authentication","imageUrl","userId","c1f94b8c-4441-434e-8b7b-3ee79bd9e8f8","pinnedFileId","89687324-a740-11f1-8395-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a0651e-7b41-76ac-a4dd-a5dbdd5a1174","tursoName","7c95e7421d59467eb1f7289effbf1692","tursoHostname","7c95e7421d59467eb1f7289effbf1692-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789533091345],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_107":102},"org",{"_9":10,"_101":102,"_103":102,"_58":59,"_104":105,"_106":44},"branch",{"_37":91,"_11":92,"_22":30,"_93":48,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":12,"_100":10},"isOwned",9,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","ctx",{"_84":-5,"_141":142,"_143":144,"_145":146,"_147":44,"_148":44,"_149":44,"_150":34,"_151":-5,"_152":-7,"_153":-7,"_154":38,"_155":44,"_156":44,"_157":-5,"_158":44,"_159":44,"_160":44,"_161":-5},"ENV",{"_112":113,"_114":115,"_116":92,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138,"_139":140},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]