[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_166":167,"_168":169},"routes/_app.x.$handle.$name",{"_95":94,"_33":46,"_103":85,"_28":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":27,"_118":119,"_120":27,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":27,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":27},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":29,"_34":38,"_36":37,"_39":40,"_41":14,"_42":43,"_24":27},"previous",{"_31":32,"_33":29,"_34":35,"_36":37},"deleted",true,"deletedHere",false,"path","val2.ts","latestPath","fileId","4679adb8-e07a-11f0-8393-42dde27851f2","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { email as sendEmail } from \"https://esm.town/v/std/email\";\n\n// Generate UUID\nfunction uuid() {\n return crypto.randomUUID();\n}\n\n// CORS headers\nconst corsHeaders = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n};\n\nexport default async function (req: Request): Promise {\n // Handle CORS preflight\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: corsHeaders });\n }\n\n const url = new URL(req.url);\n const path = url.pathname;\n\n try {\n // Route: POST /api/auth - Register or login user\n if (path === \"/api/auth\" && req.method === \"POST\") {\n const { email, canvasDomain } = await req.json();\n\n if (!email || !canvasDomain) {\n return Response.json(\n { error: \"Email and Canvas domain required\" },\n { status: 400, headers: corsHeaders },\n );\n }\n\n // Check if user exists\n const existing = await sqlite.execute({\n sql: \"SELECT * FROM users WHERE email = ?\",\n args: [email],\n });\n\n let userId;\n let isPro = false;\n\n if (existing.rows.length > 0) {\n // Existing user\n userId = existing.rows[0].id;\n isPro = existing.rows[0].is_pro === 1;\n\n // Update canvas domain if changed\n await sqlite.execute({\n sql:\n \"UPDATE users SET canvas_domain = ?, updated_at = ? WHERE id = ?\",\n args: [canvasDomain, new Date().toISOString(), userId],\n });\n } else {\n // New user\n userId = uuid();\n await sqlite.execute({\n sql: \"INSERT INTO users (id, email, canvas_domain) VALUES (?, ?, ?)\",\n args: [userId, email, canvasDomain],\n });\n\n // Create default reminder settings\n await sqlite.execute({\n sql: \"INSERT INTO reminder_settings (id, user_id) VALUES (?, ?)\",\n args: [uuid(), userId],\n });\n\n // Send welcome email\n await sendEmail({\n to: email,\n subject: \"Welcome to Canvas Reminder! 🎓\",\n html: `\n

You're all set!

Canvas Reminder will now send you notifications before your assignments are due.

Default reminders:

2 days before
1 day before
6 hours before
1 hour before

Open Canvas in your browser and click the extension to sync your assignments.

Good luck with your studies! 📚

\n `,\n });\n }\n\n return Response.json(\n { userId, isPro },\n { headers: corsHeaders },\n );\n }\n\n // Route: POST /api/sync - Sync assignments from extension\n if (path === \"/api/sync\" && req.method === \"POST\") {\n const { userId, email, assignments } = await req.json();\n\n if (!userId || !assignments) {\n return Response.json(\n { error: \"User ID and assignments required\" },\n { status: 400, headers: corsHeaders },\n );\n }\n\n // Verify user exists\n const user = await sqlite.execute({\n sql: \"SELECT * FROM users WHERE id = ?\",\n args: [userId],\n });\n\n if (user.rows.length === 0) {\n return Response.json(\n { error: \"User not found\" },\n { status: 404, headers: corsHeaders },\n );\n }\n\n // Clear old assignments for this user\n await sqlite.execute({\n sql: \"DELETE FROM assignments WHERE user_id = ?\",\n args: [userId],\n });\n\n // Insert new assignments\n for (const a of assignments) {\n await sqlite.execute({\n sql:\n `INSERT INTO assignments (id, user_id, canvas_id, name, due_date, course_name, type, url)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n uuid(),\n userId,\n a.canvasId || null,\n a.name,\n a.dueDate,\n a.courseName || \"Unknown Course\",\n a.type || \"assignment\",\n a.url || null,\n ],\n });\n }\n\n // Update user's last sync time\n await sqlite.execute({\n sql: \"UPDATE users SET updated_at = ? WHERE id = ?\",\n args: [new Date().toISOString(), userId],\n });\n\n return Response.json(\n {\n success: true,\n synced: assignments.length,\n isPro: user.rows[0].is_pro === 1,\n },\n { headers: corsHeaders },\n );\n }\n\n // Route: GET /api/assignments - Get user's assignments\n if (path === \"/api/assignments\" && req.method === \"GET\") {\n const userId = url.searchParams.get(\"userId\");\n\n if (!userId) {\n return Response.json(\n { error: \"User ID required\" },\n { status: 400, headers: corsHeaders },\n );\n }\n\n const assignments = await sqlite.execute({\n sql: `SELECT * FROM assignments \n WHERE user_id = ? AND due_date > datetime('now')\n ORDER BY due_date ASC`,\n args: [userId],\n });\n\n return Response.json(\n { assignments: assignments.rows },\n { headers: corsHeaders },\n );\n }\n\n // Route: GET /api/settings - Get user's reminder settings\n if (path === \"/api/settings\" && req.method === \"GET\") {\n const userId = url.searchParams.get(\"userId\");\n\n if (!userId) {\n return Response.json(\n { error: \"User ID required\" },\n { status: 400, headers: corsHeaders },\n );\n }\n\n const user = await sqlite.execute({\n sql: \"SELECT * FROM users WHERE id = ?\",\n args: [userId],\n });\n\n const settings = await sqlite.execute({\n sql: \"SELECT * FROM reminder_settings WHERE user_id = ?\",\n args: [userId],\n });\n\n if (user.rows.length === 0) {\n return Response.json(\n { error: \"User not found\" },\n { status: 404, headers: corsHeaders },\n );\n }\n\n return Response.json({\n user: {\n email: user.rows[0].email,\n phone: user.rows[0].phone,\n isPro: user.rows[0].is_pro === 1,\n },\n settings: settings.rows[0]\n ? {\n intervals: JSON.parse(settings.rows[0].intervals),\n emailEnabled: settings.rows[0].email_enabled === 1,\n smsEnabled: settings.rows[0].sms_enabled === 1,\n }\n : null,\n }, { headers: corsHeaders });\n }\n\n // Route: POST /api/settings - Update reminder settings\n if (path === \"/api/settings\" && req.method === \"POST\") {\n const { userId, intervals, emailEnabled, smsEnabled, phone } = await req\n .json();\n\n if (!userId) {\n return Response.json(\n { error: \"User ID required\" },\n { status: 400, headers: corsHeaders },\n );\n }\n\n // Check if user is pro for SMS\n const user = await sqlite.execute({\n sql: \"SELECT * FROM users WHERE id = ?\",\n args: [userId],\n });\n\n if (user.rows.length === 0) {\n return Response.json(\n { error: \"User not found\" },\n { status: 404, headers: corsHeaders },\n );\n }\n\n const isPro = user.rows[0].is_pro === 1;\n\n // Update user phone if provided\n if (phone !== undefined) {\n await sqlite.execute({\n sql: \"UPDATE users SET phone = ? WHERE id = ?\",\n args: [phone, userId],\n });\n }\n\n // Update settings\n await sqlite.execute({\n sql: `UPDATE reminder_settings \n SET intervals = ?, email_enabled = ?, sms_enabled = ?\n WHERE user_id = ?`,\n args: [\n intervals ? JSON.stringify(intervals) : \"[48, 24, 6, 1]\",\n emailEnabled !== false ? 1 : 0,\n (smsEnabled && isPro) ? 1 : 0,\n userId,\n ],\n });\n\n return Response.json(\n { success: true },\n { headers: corsHeaders },\n );\n }\n\n // Route: GET /checkout - Redirect to Stripe\n if (path === \"/checkout\") {\n const userId = url.searchParams.get(\"userId\");\n\n // You'll need to create a Stripe checkout session here\n // For now, redirect to a placeholder\n const STRIPE_PAYMENT_LINK = \"https://buy.stripe.com/YOUR_PAYMENT_LINK\"; // Replace with your Stripe payment link\n\n return Response.redirect(\n `${STRIPE_PAYMENT_LINK}?client_reference_id=${userId}`,\n );\n }\n\n // Route: POST /webhook/stripe - Stripe webhook\n if (path === \"/webhook/stripe\" && req.method === \"POST\") {\n // In production, verify the webhook signature\n const event = await req.json();\n\n if (event.type === \"checkout.session.completed\") {\n const session = event.data.object;\n const userId = session.client_reference_id;\n const customerId = session.customer;\n\n if (userId) {\n await sqlite.execute({\n sql:\n \"UPDATE users SET is_pro = 1, stripe_customer_id = ? WHERE id = ?\",\n args: [customerId, userId],\n });\n }\n }\n\n if (event.type === \"customer.subscription.deleted\") {\n const subscription = event.data.object;\n const customerId = subscription.customer;\n\n await sqlite.execute({\n sql: \"UPDATE users SET is_pro = 0 WHERE stripe_customer_id = ?\",\n args: [customerId],\n });\n }\n\n return Response.json({ received: true }, { headers: corsHeaders });\n }\n\n // 404 for unknown routes\n return Response.json(\n { error: \"Not found\" },\n { status: 404, headers: corsHeaders },\n );\n } catch (err) {\n console.error(\"API Error:\", err);\n return Response.json(\n { error: \"Internal server error\" },\n { status: 500, headers: corsHeaders },\n );\n }\n}","script","createdAt",["D",1766547684295],"branchVersion","branchId","fbfb45f8-e079-11f0-8f36-42dde27851f2","id","fbfb0cf0-e079-11f0-8f36-42dde27851f2","canvasReminderSetup",["D",1766547497165],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","019b4ded-bd08-71b9-8d9c-c95cd2f73a6a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019b4ded-bd09-700e-8b9f-ff48e1433587","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":27},"branch",{"_13":84,"_33":85,"_44":43,"_86":45,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":46,"_93":94},"isOwned",17,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","velocity","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM3R29zaGNPekxzUnIyOHNEWW5SaTRzMWk1UiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_33":46,"_39":162,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":27,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":163,"_79":164,"_81":165,"_83":27},"tree",[153,154],"files",[153,154],"counts",{"_142":61,"_143":144,"_145":61,"_146":147,"_148":149},"contents",[125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":134,"_33":135,"_31":136,"_128":-5,"_42":43,"_41":137,"_129":25,"_39":138,"_13":139,"_34":38,"_36":140,"_24":27,"_132":-5,"_28":141},{"_44":127,"_33":29,"_31":32,"_128":-5,"_42":43,"_41":14,"_129":27,"_39":130,"_13":131,"_34":38,"_36":37,"_24":27,"_132":-5,"_28":133},"6b8608e0-e07a-11f0-91ac-42dde27851f2","parentId","latest",["D",1766547684295],4,"label",[29],"421567a8-e07a-11f0-8393-42dde27851f2","val1.ts","3a1a03e2-e07a-11f0-a1c8-42dde27851f2",7,["D",1766547614774],2,"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// Create tables\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS users (\n id TEXT PRIMARY KEY,\n email TEXT UNIQUE NOT NULL,\n canvas_domain TEXT NOT NULL,\n phone TEXT,\n is_pro INTEGER DEFAULT 0,\n stripe_customer_id TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n`);\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS assignments (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n canvas_id TEXT,\n name TEXT NOT NULL,\n due_date TEXT NOT NULL,\n course_name TEXT,\n type TEXT DEFAULT 'assignment',\n url TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users(id)\n )\n`);\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS reminder_settings (\n id TEXT PRIMARY KEY,\n user_id TEXT UNIQUE NOT NULL,\n intervals TEXT DEFAULT '[48, 24, 6, 1]',\n email_enabled INTEGER DEFAULT 1,\n sms_enabled INTEGER DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users(id)\n )\n`);\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sent_reminders (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n assignment_id TEXT NOT NULL,\n interval_hours INTEGER NOT NULL,\n channel TEXT NOT NULL,\n sent_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users(id),\n UNIQUE(user_id, assignment_id, interval_hours, channel)\n )\n`);\n\nconsole.log(\"Database setup complete!\");",[135],"pulls","branches",1,"forks","envVars",{"_150":61,"_152":61},"connections",{"_150":61,"_151":61},"count","unfilledCount","emptyCount",{"_44":134,"_33":135,"_31":136,"_128":-5,"_42":43,"_41":137,"_129":25,"_39":159,"_13":139,"_34":38,"_36":140,"_24":27,"_132":-5,"_156":160,"_28":161},{"_44":127,"_33":29,"_31":32,"_128":-5,"_42":43,"_41":14,"_129":27,"_39":155,"_13":131,"_34":38,"_36":37,"_24":27,"_132":-5,"_156":157,"_28":158},["D",1766547684295],"children",[],[29],["D",1766547614774],[],[135],["D",1766547497165],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":27},{"_13":84,"_33":85,"_44":43,"_86":45,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":46,"_93":94},"ctx",{"_77":-5,"_122":199,"_200":201,"_202":203,"_204":27,"_205":27,"_206":27,"_207":25,"_208":-5,"_209":-7,"_210":-7,"_211":61,"_212":27,"_213":27,"_214":-5,"_215":27,"_216":27,"_217":27,"_218":-5},"ENV",{"_170":171,"_172":173,"_174":85,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198},"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"]

Diff · v12