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}","label",[127],"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!\");",[138],"6f4f2132-e07a-11f0-ba83-42dde27851f2",["D",1766547690653],[28],"pulls","branches",1,"forks","envVars",{"_156":60,"_158":60},"connections",{"_156":60,"_157":60},"count","unfilledCount","emptyCount",{"_43":145,"_33":28,"_31":32,"_129":-5,"_41":42,"_40":14,"_131":26,"_38":169,"_13":60,"_34":35,"_36":37,"_23":26,"_135":-5,"_163":170,"_27":171},{"_43":137,"_33":138,"_31":139,"_129":-5,"_41":42,"_40":140,"_131":24,"_38":166,"_13":142,"_34":35,"_36":143,"_23":26,"_135":-5,"_163":167,"_27":168},{"_43":126,"_33":127,"_31":128,"_129":-5,"_41":42,"_40":130,"_131":26,"_38":162,"_13":133,"_34":35,"_36":134,"_23":26,"_135":-5,"_163":164,"_27":165},["D",1766547684295],"children",[],[127],["D",1766547614774],[],[138],["D",1766547690653],[],[28],["D",1766547497165],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":26},{"_13":83,"_33":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_76":-5,"_120":209,"_210":211,"_212":213,"_214":26,"_215":26,"_216":26,"_217":24,"_218":-5,"_219":-7,"_220":-7,"_221":60,"_222":26,"_223":26,"_224":-5,"_225":26,"_226":26,"_227":26,"_228":-5},"ENV",{"_180":181,"_182":183,"_184":84,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208},"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 · v13