[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":53,"_126":127,"_128":53,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","velocity","name","canvasReminderCron","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","446ff008-e07b-11f0-91b4-42dde27851f2","main.ts","fileId","352d00d6-e07b-11f0-8c15-42dde27851f2","parentId","branchId","352adb12-e07b-11f0-8c15-42dde27851f2","branchVersion",4,"latest",true,"createdAt",["D",1766548048221],3,"fileType","interval","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { email as sendEmail } from \"https://esm.town/v/std/email\";\n\n// Twilio config - replace with your credentials\nconst TWILIO_ACCOUNT_SID = \"YOUR_TWILIO_SID\";\nconst TWILIO_AUTH_TOKEN = \"YOUR_TWILIO_TOKEN\";\nconst TWILIO_PHONE_NUMBER = \"+1XXXXXXXXXX\";\n\nasync function sendSMS(to: string, body: string) {\n const response = await fetch(\n `https://api.twilio.com/2010-04-01/Accounts/${TWILIO_ACCOUNT_SID}/Messages.json`,\n {\n method: \"POST\",\n headers: {\n \"Authorization\": \"Basic \" +\n btoa(`${TWILIO_ACCOUNT_SID}:${TWILIO_AUTH_TOKEN}`),\n \"Content-Type\": \"application/x-www-form-urlencoded\",\n },\n body: new URLSearchParams({\n To: to,\n From: TWILIO_PHONE_NUMBER,\n Body: body,\n }),\n },\n );\n return response.json();\n}\n\nexport default async function () {\n console.log(\"Running reminder cron job...\");\n\n const now = new Date();\n\n // Get all users with their settings\n const users = await sqlite.execute(`\n SELECT u.*, rs.intervals, rs.email_enabled, rs.sms_enabled\n FROM users u\n JOIN reminder_settings rs ON u.id = rs.user_id\n WHERE rs.email_enabled = 1 OR (rs.sms_enabled = 1 AND u.is_pro = 1)\n `);\n\n for (const user of users.rows) {\n const intervals = JSON.parse(user.intervals || \"[48, 24, 6, 1]\");\n\n // Get user's upcoming assignments\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: [user.id],\n });\n\n for (const assignment of assignments.rows) {\n const dueDate = new Date(assignment.due_date);\n const hoursUntil = (dueDate.getTime() - now.getTime()) / (1000 * 60 * 60);\n\n // Check each interval\n for (const interval of intervals) {\n // Check if we're within the notification window (interval - 0.5 hours to interval hours)\n if (hoursUntil <= interval && hoursUntil > interval - 0.5) {\n // Check if we've already sent this reminder\n const sent = await sqlite.execute({\n sql: `SELECT * FROM sent_reminders \n WHERE user_id = ? AND assignment_id = ? AND interval_hours = ?`,\n args: [user.id, assignment.id, interval],\n });\n\n if (sent.rows.length === 0) {\n // Send reminders\n const timeText = interval >= 24\n ? `${Math.round(interval / 24)} day${interval >= 48 ? \"s\" : \"\"}`\n : `${interval} hour${interval !== 1 ? \"s\" : \"\"}`;\n\n const urgencyEmoji = interval <= 1\n ? \"🚨\"\n : interval <= 6\n ? \"⚠️\"\n : \"📅\";\n\n // Send email\n if (user.email_enabled) {\n try {\n await sendEmail({\n to: user.email,\n subject:\n `${urgencyEmoji} Assignment due in ${timeText}: ${assignment.name}`,\n html: `\n

\n ${urgencyEmoji} Due in ${timeText}\n

${assignment.name}

${assignment.course_name}

\n Due: ${dueDate.toLocaleString()}\n

\n ${\n assignment.url\n ? `Open in Canvas`\n : \"\"\n }\n

\n Canvas Reminder - Never miss an assignment\n

\n `,\n });\n\n // Record sent reminder\n await sqlite.execute({\n sql:\n `INSERT INTO sent_reminders (id, user_id, assignment_id, interval_hours, channel)\n VALUES (?, ?, ?, ?, 'email')`,\n args: [crypto.randomUUID(), user.id, assignment.id, interval],\n });\n\n console.log(\n `Sent email reminder to ${user.email} for ${assignment.name}`,\n );\n } catch (err) {\n console.error(`Failed to send email to ${user.email}:`, err);\n }\n }\n\n // Send SMS (pro users only)\n if (user.sms_enabled && user.is_pro && user.phone) {\n try {\n await sendSMS(\n user.phone,\n `${urgencyEmoji} Due in ${timeText}: ${assignment.name} (${assignment.course_name})`,\n );\n\n // Record sent reminder\n await sqlite.execute({\n sql:\n `INSERT INTO sent_reminders (id, user_id, assignment_id, interval_hours, channel)\n VALUES (?, ?, ?, ?, 'sms')`,\n args: [crypto.randomUUID(), user.id, assignment.id, interval],\n });\n\n console.log(\n `Sent SMS reminder to ${user.phone} for ${assignment.name}`,\n );\n } catch (err) {\n console.error(`Failed to send SMS to ${user.phone}:`, err);\n }\n }\n }\n }\n }\n }\n }\n\n // Clean up old sent_reminders (older than 30 days)\n await sqlite.execute(`\n DELETE FROM sent_reminders \n WHERE sent_at < datetime('now', '-30 days')\n `);\n\n console.log(\"Reminder cron job complete\");\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1766548048221],"children",[],[35],"352a9742-e07b-11f0-8c15-42dde27851f2",["D",1766548022604],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","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",{"_11":12,"_114":110},"org",{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},"branch",{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM3R29zaGNPekxzUnIyOHNEWW5SaTRzMWk1UiJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":148,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":149,"_95":150,"_97":151,"_99":53},[145],"files",[145],"counts",{"_135":77,"_136":137,"_138":77,"_31":139,"_140":141},[133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":134},[35],"pulls","branches",1,"forks",{"_142":77,"_144":77},"connections",{"_142":77,"_143":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":146,"_18":147},[],[35],["D",1766548022604],{"_11":12,"_114":110},{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_130":185,"_186":187,"_188":189,"_190":53,"_191":53,"_192":53,"_193":44,"_194":-5,"_195":-7,"_196":-7,"_197":77,"_198":53,"_199":53,"_200":-5,"_201":53,"_202":53,"_203":53,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":16,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"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"]

Code