\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","label",[99],"permalink","https://www.val.town/x/velocity/canvasReminderCron/code/main.ts","extension","actionData","errors"]