[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_256":257,"_258":259},"routes/_app.x.$handle.$name",{"_97":96,"_32":46,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":59,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",30,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/types.ts","latestPath","fileId","825a1182-36a9-4815-9fce-8dabbc695b80","name","types.ts","fileType","script","content","// Shared type definitions for the Linear-Slack Reminder Bot\n\nexport interface LinearTicket {\n id: string;\n identifier: string;\n title: string;\n state: {\n name: string;\n type: string;\n };\n assignee?: {\n email: string;\n name: string;\n };\n completedAt?: string;\n}\n\nexport interface LinearIssue extends LinearTicket {\n children: {\n nodes: LinearTicket[];\n };\n}\n\nexport interface SlackUser {\n id: string;\n name: string;\n real_name: string;\n profile: {\n email: string;\n };\n}\n\nexport interface Reminder {\n id?: number;\n ticket_id: string;\n ticket_title: string;\n interval_days: number;\n last_ping: string;\n ping_count: number;\n creator_slack_id: string;\n assignee_mappings: string;\n subticket_status: string; \n active: number; // 1 or 0 boolean\n created_at: string;\n}\n\nexport interface SlackModalPayload {\n type: string;\n user: {\n id: string;\n };\n view: {\n callback_id: string;\n state: {\n values: Record>;\n };\n private_metadata: string;\n };\n}\n\nexport interface SlackCommandPayload {\n command: string;\n text: string;\n trigger_id: string;\n user_id: string;\n}","// Shared type definitions for the Linear-Slack Reminder Bot\n\nexport interface LinearTicket {\n id: string;\n identifier: string;\n title: string;\n state: {\n name: string;\n type: string;\n };\n assignee?: {\n email: string;\n name: string;\n };\n completedAt?: string;\n}\n\nexport interface LinearIssue extends LinearTicket {\n children: {\n nodes: LinearTicket[];\n };\n labels?: {\n id: string;\n name: string;\n }[];\n team: {\n id: string;\n };\n}\n\nexport interface SlackUser {\n id: string;\n name: string;\n real_name: string;\n profile: {\n email: string;\n };\n}\n\nexport interface Reminder {\n id?: number;\n ticket_id: string;\n ticket_title: string;\n interval_days: number;\n last_ping: string;\n ping_count: number;\n creator_slack_id: string;\n assignee_mappings: string;\n subticket_status: string;\n active: number; // 1 or 0 boolean\n created_at: string;\n}\n\nexport interface SlackModalPayload {\n type: string;\n user: {\n id: string;\n };\n view: {\n callback_id: string;\n state: {\n values: Record>;\n };\n private_metadata: string;\n };\n}\n\nexport interface SlackCommandPayload {\n command: string;\n text: string;\n trigger_id: string;\n user_id: string;\n}","createdAt",["D",1752720593162],"branchVersion","branchId","27583b16-5c0e-11f0-a4dc-0224a6c84d84","id","275590c8-5c0e-11f0-a4dc-0224a6c84d84","Linear-to-Slack-Reminder",["D",1751987630741],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","80253444-09af-4df4-a560-c86b38750edf","pinnedFileId","13d59912-3d8a-4fe5-85cb-b5c9c34eef2b","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",2,"orgId","01989fcc-dbe7-7389-a3ad-45c50d401a74","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":-5,"_101":102,"_103":59},"branch",{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"isOwned",53,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Crossmint","handle","displayName","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/dc2506f3-9fe8-4b41-d79b-eb9074f98200/square512?exp=1789589756&sig=0050ae1d222b6fb7f9c328d50f4c30e19a1e61220c1afa0843396d4049a49613","tier","business","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":252,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":253,"_81":254,"_83":255,"_85":25},"tree",[180,185,188,189,190],"files",[180,181,182,183,184,185,186,187,188,189,190],"counts",{"_170":138,"_171":135,"_172":138,"_173":174,"_175":176},"contents",[127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":165,"_32":166,"_30":167,"_134":-5,"_42":43,"_41":135,"_136":59,"_39":168,"_13":138,"_34":163,"_36":-5,"_24":25,"_141":-5,"_27":169},{"_44":159,"_32":160,"_30":161,"_134":-5,"_42":43,"_41":135,"_136":59,"_39":162,"_13":138,"_34":163,"_36":-5,"_24":25,"_141":-5,"_27":164},{"_44":151,"_32":152,"_30":153,"_134":-5,"_42":43,"_41":154,"_136":25,"_39":155,"_13":156,"_34":20,"_36":157,"_24":25,"_141":-5,"_27":158},{"_44":143,"_32":144,"_30":145,"_134":-5,"_42":43,"_41":146,"_136":25,"_39":147,"_13":63,"_34":148,"_36":149,"_24":25,"_141":-5,"_27":150},{"_44":132,"_32":133,"_30":57,"_134":-5,"_42":43,"_41":135,"_136":25,"_39":137,"_13":138,"_34":139,"_36":140,"_24":25,"_141":-5,"_27":142},"27676e10-5c0e-11f0-a4dc-0224a6c84d84","main.ts","parentId",1,"latest",["D",1751987630741],0,"http","/**\n * Main HTTP endpoint router for the Linear-Slack Reminder Bot\n * \n * This file handles all incoming HTTP requests and routes them to the appropriate handlers:\n * - /slack/commands - Slash commands (/track-linear, /track-status)\n * - /slack/interactive - Interactive components (modal submissions)\n */\n\nimport handleSlashCommand from \"./slack/slashCommand.ts\";\nimport handleModalSubmit from \"./slack/modalSubmit.ts\";\n\nexport default async function main(req: Request) {\n const url = new URL(req.url);\n \n // Handle slash commands\n if (url.pathname === \"/slack/commands\") {\n return handleSlashCommand(req);\n }\n \n // Handle interactive components (modal submissions)\n if (url.pathname === \"/slack/interactive\") {\n const formData = await req.formData();\n const payload = JSON.parse(formData.get(\"payload\") as string);\n \n if (payload.type === \"view_submission\") {\n return handleModalSubmit(payload);\n }\n }\n \n return new Response(\"Not found\", { status: 404 });\n}","label",[133],"6b9fcef6-5e66-11f0-8481-0224a6c84d84","cron.ts","a41ae8df-fa7e-41a5-b518-9ef53642aa7d",24,["D",1752245443370],"interval","/**\n * Cron Job - Daily Reminder Checker\n *\n * This file is long, but it's mostly just assembling the notifications and and a lot of logs for debugging.\n *\n * Runs daily to:\n * 1. Check all active reminders\n * 2. Send notifications for overdue tickets\n * 3. Escalate to creators after 3 reminders\n * 4. Celebrate completed tickets\n *\n * Set TESTING = true to test notifications immediately\n */\n\nimport { getActiveReminders, updateReminder } from \"./backend/database.ts\";\nimport { getLinearTicket } from \"./backend/linearApi.ts\";\nimport { sendDirectMessage } from \"./backend/slackApi.ts\";\nimport { LinearTicket, Reminder } from \"./backend/types.ts\";\n\n/**\n * Orchestrates the daily reminder check. This is the main cron entrypoint.\n */\nexport default async function checkReminders() {\n const TESTING = false; // TODO: change this to false to put this into production\n\n const reminders = await getActiveReminders();\n const now = new Date();\n const runTimestamp = now.toISOString();\n\n console.log(`\\n=== CRON RUN STARTED: ${runTimestamp} ===`);\n if (TESTING) {\n console.log(`⚡ TESTING MODE ENABLED - ALL REMINDERS WILL PROCESS ⚡`);\n }\n console.log(`Found ${reminders.length} active reminders to check\\n`);\n\n let totalNotificationsSent = 0;\n let totalRemindersProcessed = 0;\n\n for (const reminder of reminders) {\n if (shouldProcessReminder(reminder, now, TESTING)) {\n const notificationsSent = await processReminder(reminder);\n totalNotificationsSent += notificationsSent;\n totalRemindersProcessed++;\n }\n }\n\n const summary = buildSummary(\n runTimestamp,\n reminders.length,\n totalRemindersProcessed,\n totalNotificationsSent,\n );\n console.log(summary);\n return new Response(summary, { status: 200 });\n}\n\nfunction shouldProcessReminder(\n reminder: Reminder,\n now: Date,\n testingMode: boolean,\n): boolean {\n const lastPing = new Date(reminder.last_ping);\n const daysSinceLastPing = Math.floor(\n (now.getTime() - lastPing.getTime()) / (1000 * 60 * 60 * 24),\n );\n return testingMode || daysSinceLastPing >= reminder.interval_days;\n}\n\nfunction buildSummary(\n runTimestamp: string,\n totalChecked: number,\n processed: number,\n sent: number,\n): string {\n return `\\n=== CRON RUN COMPLETED ===\\n` +\n `Time: ${runTimestamp}\\n` +\n `Total reminders checked: ${totalChecked}\\n` +\n `Reminders processed: ${processed}\\n` +\n `Notifications sent: ${sent}\\n`;\n}\n\nasync function processReminder(reminder: Reminder): Promise {\n console.log(`\\n --- Processing ${reminder.ticket_title} ---`);\n\n // Get ticket data\n const ticket = await getLinearTicket(reminder.ticket_id);\n const assigneeMappings = JSON.parse(reminder.assignee_mappings);\n const currentStatus: Record = {};\n\n // Track reassignments\n const reassignedTickets: Array<\n { ticket: LinearTicket; oldMapping: string | null }\n > = [];\n\n console.log(\n ` Assignee mappings: ${Object.keys(assigneeMappings).length} users`,\n );\n console.log(` Mapping keys: ${Object.keys(assigneeMappings).join(\", \")}`);\n\n let allComplete = true;\n const incompleteTickets: LinearTicket[] = [];\n\n // Check if this is a parent ticket with sub-tickets or a single ticket\n if (ticket.children?.nodes?.length) {\n // Parent ticket with sub-tickets\n console.log(\n ` Type: Parent ticket with ${ticket.children.nodes.length} sub-tickets`,\n );\n for (const subticket of ticket.children.nodes) {\n const isComplete = !!subticket.completedAt;\n console.log(\n ` - Subticket: ${subticket.title} (${subticket.identifier}) completedAt: ${\n subticket.completedAt || \"null\"\n } | isComplete: ${isComplete}`,\n );\n currentStatus[subticket.id] = isComplete;\n\n if (!isComplete) {\n allComplete = false;\n incompleteTickets.push(subticket);\n }\n }\n } else {\n // Single ticket\n console.log(` Type: Single ticket`);\n const isComplete = !!ticket.completedAt;\n console.log(\n ` - Ticket: ${ticket.title} (${ticket.identifier}) completedAt: ${\n ticket.completedAt || \"null\"\n } | isComplete: ${isComplete}`,\n );\n currentStatus[ticket.id] = isComplete;\n\n if (!isComplete) {\n allComplete = false;\n incompleteTickets.push(ticket);\n }\n }\n\n console.log(` Status: ${incompleteTickets.length} incomplete tickets found`);\n\n let notificationsSent = 0;\n const ticketsWithoutMappings: LinearTicket[] = [];\n\n // Send notifications for incomplete tickets\n for (const ticketItem of incompleteTickets) {\n let slackUserId = null;\n\n // Determine who to notify\n // First try case-insensitive email match for current assignee\n if (ticketItem.assignee?.email) {\n const assigneeEmail = ticketItem.assignee.email.toLowerCase();\n const mappingKey = Object.keys(assigneeMappings).find(\n (key) => key.toLowerCase() === assigneeEmail,\n );\n if (mappingKey) {\n slackUserId = assigneeMappings[mappingKey];\n console.log(\n ` 📧 ${ticketItem.title}: Notifying assigned user ${ticketItem.assignee.email} -> ${slackUserId}`,\n );\n } else {\n // Check if this ticket was previously assigned to someone else\n const previousAssigneeKey = Object.keys(assigneeMappings).find((key) =>\n key.startsWith(\"prev_assignee_\") && key.endsWith(`_${ticketItem.id}`)\n );\n if (previousAssigneeKey) {\n const prevEmail = previousAssigneeKey.replace(`prev_assignee_`, \"\")\n .replace(`_${ticketItem.id}`, \"\");\n console.log(\n ` 🔄 ${ticketItem.title}: Detected reassignment from ${prevEmail} to ${ticketItem.assignee.email}`,\n );\n reassignedTickets.push({\n ticket: ticketItem,\n oldMapping: assigneeMappings[previousAssigneeKey],\n });\n }\n }\n }\n\n // If not found, try manual mapping for unassigned tickets\n if (!slackUserId && assigneeMappings[`unassigned_${ticketItem.id}`]) {\n slackUserId = assigneeMappings[`unassigned_${ticketItem.id}`];\n console.log(\n ` 📧 ${ticketItem.title}: Notifying manually selected user -> ${slackUserId}`,\n );\n }\n\n // If no mapping found, track it for later notification to creator\n if (!slackUserId) {\n console.log(\n ` ⚠️ ${ticketItem.title}: No user mapping found, skipping notification`,\n );\n ticketsWithoutMappings.push(ticketItem);\n continue; // Skip this ticket - no notification sent\n }\n\n if (slackUserId) {\n // Build Linear URL for the ticket\n const ticketUrl = `https://linear.app/issue/${ticketItem.identifier}`;\n\n let message =\n `🔔 Reminder: Your ticket <${ticketUrl}|*${ticketItem.title}*> is still open. Please update it in Linear.`;\n\n // If this is the 3rd ping, also notify the creator\n if (reminder.ping_count === 2) {\n message =\n `⚠️ This is your 3rd reminder! <${ticketUrl}|*${ticketItem.title}*> has been incomplete for ${\n reminder.interval_days * 3\n } days. Please prioritize this task.`;\n\n // Also notify the creator\n const parentUrl = `https://linear.app/issue/${ticket.identifier}`;\n await sendDirectMessage(\n reminder.creator_slack_id,\n `⚠️ <@${slackUserId}> has received their 3rd reminder for <${ticketUrl}|*${ticketItem.title}*> in ticket <${parentUrl}|*${ticket.title}*>. The task has been open for ${\n reminder.interval_days * 3\n } days.`,\n );\n }\n\n try {\n await sendDirectMessage(slackUserId, message);\n notificationsSent++;\n console.log(` ✅ Notification sent successfully`);\n } catch (error) {\n console.log(` ❌ Failed to send notification: ${error.message}`);\n }\n }\n }\n\n // Notify creator about tickets that need mapping setup\n if (ticketsWithoutMappings.length > 0) {\n console.log(\n ` ⚠️ Notifying creator about ${ticketsWithoutMappings.length} tickets that need mapping setup`,\n );\n const ticketUrls = ticketsWithoutMappings.map((t) =>\n `• `\n ).join(\"\\n\");\n\n const mappingMessage =\n `⚠️ Some tickets in your reminder \"\" don't have user mappings set up:\\n\\n${ticketUrls}\\n\\nPlease use \\`/track-linear ${ticket.identifier}\\` to update the reminder settings and select who should be notified for these tickets.`;\n\n try {\n await sendDirectMessage(reminder.creator_slack_id, mappingMessage);\n notificationsSent++;\n console.log(` ✅ Notified creator about missing mappings`);\n } catch (error) {\n console.log(\n ` ❌ Failed to notify about missing mappings: ${error.message}`,\n );\n }\n }\n\n // Send completion notifications for newly completed tickets\n if (ticket.children?.nodes?.length) {\n // Parent ticket with subtickets - check each subticket\n for (const subticket of ticket.children.nodes) {\n if (currentStatus[subticket.id]) {\n // Subticket completed (newly or previously)\n if (\n subticket.assignee?.email &&\n assigneeMappings[subticket.assignee.email]\n ) {\n const slackUserId = assigneeMappings[subticket.assignee.email];\n try {\n const subticketUrl =\n `https://linear.app/issue/${subticket.identifier}`;\n await sendDirectMessage(\n slackUserId,\n `✅ Great job! You've completed <${subticketUrl}|*${subticket.title}*>. No more reminders for this task.`,\n );\n notificationsSent++;\n console.log(\n ` 🎉 Sent completion notification for \"${subticket.title}\" to ${slackUserId}`,\n );\n } catch (error) {\n console.log(\n ` ❌ Failed to send completion notification: ${error.message}`,\n );\n }\n }\n }\n }\n } else {\n // Single ticket - check if it's complete\n if (currentStatus[ticket.id]) {\n // Single ticket completed (newly or previously)\n if (\n ticket.assignee?.email && assigneeMappings[ticket.assignee.email]\n ) {\n const slackUserId = assigneeMappings[ticket.assignee.email];\n try {\n const ticketUrl = `https://linear.app/issue/${ticket.identifier}`;\n await sendDirectMessage(\n slackUserId,\n `✅ Great job! You've completed <${ticketUrl}|*${ticket.title}*>. No more reminders for this task.`,\n );\n notificationsSent++;\n console.log(\n ` 🎉 Sent completion notification for single ticket \"${ticket.title}\" to ${slackUserId}`,\n );\n } catch (error) {\n console.log(\n ` ❌ Failed to send completion notification: ${error.message}`,\n );\n }\n }\n }\n }\n\n // Notify creator about any reassignments\n if (reassignedTickets.length > 0) {\n console.log(\n ` 🔄 Notifying creator about ${reassignedTickets.length} reassignments`,\n );\n for (const reassignment of reassignedTickets) {\n const ticketUrl =\n `https://linear.app/issue/${reassignment.ticket.identifier}`;\n const reassignMessage =\n `🔄 Ticket <${ticketUrl}|*${reassignment.ticket.title}*> has been reassigned to ${\n reassignment.ticket.assignee?.email || \"unassigned\"\n }. You may need to update the reminder settings to ensure notifications reach the right person.`;\n\n try {\n await sendDirectMessage(reminder.creator_slack_id, reassignMessage);\n notificationsSent++;\n console.log(` ✅ Notified creator about reassignment`);\n } catch (error) {\n console.log(\n ` ❌ Failed to notify about reassignment: ${error.message}`,\n );\n }\n }\n }\n\n try {\n // Always update last_ping, ping_count and the latest subticket status\n const nowIso = new Date().toISOString();\n await updateReminder(reminder.id!, {\n last_ping: nowIso,\n ping_count: reminder.ping_count + 1,\n subticket_status: JSON.stringify(currentStatus),\n // If everything is complete, mark the reminder as inactive so it no longer shows in /track-status\n active: allComplete ? 0 : 1,\n });\n console.log(\n ` 💾 Updated reminder (active=${allComplete ? 0 : 1}, ping_count=${\n reminder.ping_count + 1\n })`,\n );\n } catch (err) {\n console.log(` ❌ Failed to update reminder record: ${err.message}`);\n }\n\n // If all tickets are complete, notify the creator and deactivate\n if (allComplete) {\n const mainTicketUrl = `https://linear.app/issue/${ticket.identifier}`;\n const completeMessage = ticket.children?.nodes?.length\n ? `🎉 All sub-tickets for <${mainTicketUrl}|*${ticket.title}*> are done! Please review and close the main ticket.`\n : `🎉 The ticket <${mainTicketUrl}|*${ticket.title}*> is complete!`;\n\n try {\n await sendDirectMessage(reminder.creator_slack_id, completeMessage);\n notificationsSent++;\n console.log(` ✅ Notified creator about completion`);\n } catch (error) {\n console.log(` ❌ Failed to notify about completion: ${error.message}`);\n }\n }\n\n return notificationsSent;\n}",[144],"35e19648-5c11-11f0-b59c-0224a6c84d84","README.md","13342248-0b37-4af5-9daf-1828fe60ba47",15,["D",1751988943658],6,"# Linear-Slack Reminder Bot\n\nLinear-Slack Reminder Bot monitors Linear tickets and sends scheduled Slack\nreminders to assignees.\n\n## Here's what the bot does:\n\n1. **Track a ticket** using `/track-linear [ticket-id]`\n2. **Configure reminders** - Choose how often to ping (daily, every 2 days,\n etc.)\n3. **Automatic notifications** - The bot sends DMs to assignees of incomplete\n tickets\n4. **Escalation** - After 3 reminders, the ticket creator is also notified\n5. **Completion** - When all tasks are done, the creator gets a success\n notification\n\n## Setup Instructions:\n\n### Step 1: Remix this val to your account\n\n1. You'll need the `HTTP Request URL` from `main.ts`. E.g.\n `charmaine-17829713.val.run` for Step 2 below.\n1. You'll need to these environment variables:\n - `SLACK_BOT_TOKEN` - Your Slack bot token (see Step 2 below)\n - `LINEAR_API_KEY` - Your Linear API key (see Step 3 below)\n\n### Step 2: Create and Configure Slack App\n\n1. Go to [api.slack.com/apps](https://api.slack.com/apps) and click **\"Create\n New App\"**\n2. Choose **\"From scratch\"** and name it (e.g., \"Linear Reminder Bot\")\n3. Navigate to **OAuth & Permissions** > **Scopes** > add these **Bot Token\n Scopes**:\n - `chat:write` - To send messages\n - `users:read` - To list workspace users\n - `users:read.email` - To match Linear users by email\n - `commands` - To handle slash commands\n - `im:write` - To send direct messages\n\n4. Scroll up and click **\"Install to [Workspace Name]\"** and authorize the app\n5. Copy the **Bot User OAuth Token** (starts with `xoxb-`)\n6. Set up **Slash Commands** (under \"Slash Commands\" in sidebar):\n - Command: **`/chase`**\n - _Note: you can change this command, but you'll also have to change it in\n `slack/slashCommand.ts` in this val_\n - **Request URL:** `https://[YOUR-VALTOWN-URL]/slack/commands` (You get get\n this via the `main.ts` file)\n - Description: \"Track a Linear ticket for reminders\"\n - Command: **`/status-chaser`**\n - **Request URL:** `https://[YOUR-VALTOWN-URL]/slack/commands`\n - Description: \"View your active Linear reminders\"\n - Command: **`/clear-chasers`**\n - **Request URL:** `https://[YOUR-VALTOWN-URL]/slack/commands`\n - Description: \"Clear all active reminders you have set\"\n\n7. Enable **Interactivity** (under \"Interactivity & Shortcuts\"):\n - Turn ON\n - **Request URL:** `https://[YOUR-VALTOWN-URL]/slack/interactive`\n\n### Step 3: Get Your Linear API Key\n\n1. Open Linear and click your profile picture\n2. Go to **Settings** → **Account** → **Security & access**\n - Direct link: `https://linear.app/YOUR-WORKSPACE/settings/account/security`\n3. Under **\"Personal API keys\"**, click **\"New API key\"**\n4. Name it something memorable (e.g., \"Val Town Slack Reminder Bot\")\n5. Give it full permissions and team access for easiest set up\n6. **Copy the key immediately** - you won't be able to see it again!\n7. Add it to Val Town as the `LINEAR_API_KEY` environment variable\n\n## Usage Guide\n\n### Starting a Reminder\n\n```\n/track-linear VAL-123\n```\n\nor\n\n```\n/track-linear https://linear.app/team/issue/VAL-123\n```\n\nThis will open a modal where you can:\n\n- Select the reminder interval (daily, every 2 days, etc.)\n- Map Linear assignees to Slack users\n- Configure who gets notified for unassigned tickets\n\n### Viewing Active Reminders\n\n```\n/track-status\n```\n\nShows all your active reminders with clickable links to Linear tickets.\n\n### Stopping Reminders\n\nReminders automatically stop when:\n\n- All tracked tickets are marked as complete in Linear\n- The parent ticket is closed (for tickets with sub-tasks)\n\nYou may also manually clear all reminders with\n\n```\n/clear-reminders\n```\n\n## Testing Your Setup\n\n### Quick Test Mode\n\n1. Edit your `cron.ts` file in Val Town\n2. Change `const FORCE_RUN = false` to `true`\n3. Run the cron manually - it will send notifications immediately\n4. Change back to `false` when done testing",[152],"27675b96-5c0e-11f0-a4dc-0224a6c84d84","slack","7f1c8f08-b4f8-43a3-a731-82f3adea16d5",["D",1751987630741],"directory",[160],"2767443a-5c0e-11f0-a4dc-0224a6c84d84","backend","4bbcdb0b-19ae-4a4d-820f-c9ba7e9cd798",["D",1751987630741],[166],"pulls","branches","forks","envVars",{"_177":63,"_179":138},"connections",{"_177":138,"_178":138},"count","unfilledCount","emptyCount",{"_44":165,"_32":166,"_30":167,"_134":-5,"_42":43,"_41":135,"_136":59,"_39":249,"_13":138,"_34":163,"_36":-5,"_24":25,"_141":-5,"_192":250,"_27":251},{"_44":241,"_32":242,"_30":243,"_134":167,"_42":43,"_41":244,"_136":59,"_39":245,"_13":229,"_34":35,"_36":246,"_24":25,"_141":-5,"_192":247,"_27":248},{"_44":233,"_32":234,"_30":235,"_134":167,"_42":43,"_41":236,"_136":59,"_39":237,"_13":135,"_34":35,"_36":238,"_24":25,"_141":-5,"_192":239,"_27":240},{"_44":224,"_32":225,"_30":226,"_134":167,"_42":43,"_41":227,"_136":59,"_39":228,"_13":229,"_34":35,"_36":230,"_24":25,"_141":-5,"_192":231,"_27":232},{"_44":220,"_32":33,"_30":31,"_134":167,"_42":43,"_41":14,"_136":59,"_39":221,"_13":135,"_34":35,"_36":38,"_24":25,"_141":-5,"_192":222,"_27":223},{"_44":159,"_32":160,"_30":161,"_134":-5,"_42":43,"_41":135,"_136":59,"_39":217,"_13":138,"_34":163,"_36":-5,"_24":25,"_141":-5,"_192":218,"_27":219},{"_44":210,"_32":211,"_30":212,"_134":161,"_42":43,"_41":135,"_136":25,"_39":213,"_13":138,"_34":35,"_36":214,"_24":25,"_141":-5,"_192":215,"_27":216},{"_44":201,"_32":202,"_30":203,"_134":161,"_42":43,"_41":204,"_136":25,"_39":205,"_13":206,"_34":35,"_36":207,"_24":25,"_141":-5,"_192":208,"_27":209},{"_44":151,"_32":152,"_30":153,"_134":-5,"_42":43,"_41":154,"_136":25,"_39":198,"_13":156,"_34":20,"_36":157,"_24":25,"_141":-5,"_192":199,"_27":200},{"_44":143,"_32":144,"_30":145,"_134":-5,"_42":43,"_41":146,"_136":25,"_39":195,"_13":63,"_34":148,"_36":149,"_24":25,"_141":-5,"_192":196,"_27":197},{"_44":132,"_32":133,"_30":57,"_134":-5,"_42":43,"_41":135,"_136":25,"_39":191,"_13":138,"_34":139,"_36":140,"_24":25,"_141":-5,"_192":193,"_27":194},["D",1751987630741],"children",[],[133],["D",1752245443370],[],[144],["D",1751988943658],[],[152],"930d2350-5e5a-11f0-acf1-0224a6c84d84","slashCommand.ts","842d355e-c60d-4200-958c-678463c4ad93",23,["D",1752240355558],13,"/**\n * Slash Command Handler\n *\n * Handles three commands:\n * - /chase [ticket-id] - Opens modal to configure reminder for a Linear ticket\n * - /status-chaser - Shows all active reminders for the user\n * - /clear-chasers - Clears all existing reminders\n */\n\nimport {\n clearAllReminders,\n getAllRemindersByCreator,\n getRemindersByCreator,\n initDatabase,\n} from \"../backend/database.ts\";\nimport { extractTicketId, getLinearTicket } from \"../backend/linearApi.ts\";\nimport { lookupUserByEmail, openModal } from \"../backend/slackApi.ts\";\nimport { LinearIssue, LinearTicket } from \"../backend/types.ts\";\n\nfunction checkIfTicketComplete(ticket: LinearIssue): boolean {\n if (ticket.children?.nodes?.length) {\n // Parent ticket with sub-tickets - check if all sub-tickets are complete\n return ticket.children.nodes.every(subticket => !!subticket.completedAt);\n } else {\n // Single ticket - check if it's complete\n return !!ticket.completedAt;\n }\n}\n\nexport default async function handleSlashCommand(req: Request) {\n const formData = await req.formData();\n const command = formData.get(\"command\");\n const text = formData.get(\"text\") as string;\n const triggerId = formData.get(\"trigger_id\") as string;\n const userId = formData.get(\"user_id\") as string;\n\n await initDatabase();\n\n if (command === \"/chase\") {\n if (!text) {\n return new Response(\"Please provide a Linear ticket ID or URL\", {\n status: 200,\n });\n }\n\n try {\n const ticketId = extractTicketId(text);\n\n // Check if user already has an active reminder for this ticket\n const existingReminders = await getRemindersByCreator(userId);\n const existingReminder = existingReminders.find(r => r.ticket_id === ticketId);\n\n console.log(\"existingReminder:\", existingReminder);\n console.log(\"ticketId:\", ticketId);\n console.log(\"existingReminders:\", existingReminders.map(r => r.ticket_id));\n\n if (existingReminder) {\n // If ticket already exists, allow editing the existing reminder\n console.log(`User ${userId} is editing existing reminder for ticket ${ticketId}`);\n }\n\n const ticket = await getLinearTicket(ticketId);\n\n // Check if ticket is currently complete in Linear\n const isTicketComplete = checkIfTicketComplete(ticket);\n\n if (isTicketComplete) {\n return new Response(\n \"This ticket is marked as completed, change the status in Linear if you'd like it to be tracked.\",\n { status: 200 },\n );\n }\n\n // Handle both parent tickets with sub-tickets and individual tickets\n let ticketsToTrack: LinearTicket[] = [];\n\n if (ticket.children?.nodes?.length) {\n // This is a parent ticket with sub-tickets\n ticketsToTrack = ticket.children.nodes;\n } else {\n // This is a single ticket, track it directly\n ticketsToTrack = [ticket];\n }\n\n // Try to auto-match assignees\n const assigneeMappings: Record = {};\n const unmatchedAssignees: string[] = [];\n\n // If editing existing reminder, start with current mappings\n if (existingReminder) {\n const currentMappings = JSON.parse(existingReminder.assignee_mappings);\n Object.assign(assigneeMappings, currentMappings);\n }\n\n for (const ticketItem of ticketsToTrack) {\n if (ticketItem.assignee?.email) {\n try {\n const email = ticketItem.assignee.email.trim().toLowerCase();\n const slackUser = await lookupUserByEmail(email);\n console.log(`[Slack Lookup] Linear email: ${email} → Slack user:`, slackUser);\n\n if (slackUser) {\n assigneeMappings[ticketItem.assignee.email] = slackUser.id;\n } else {\n assigneeMappings[ticketItem.assignee.email] = null;\n unmatchedAssignees.push(ticketItem.assignee.email);\n }\n } catch (error) {\n // If lookup fails, mark as unmatched\n console.error(`[Slack Lookup ERROR] Linear email: ${ticketItem.assignee.email}`, error);\n assigneeMappings[ticketItem.assignee.email] = null;\n unmatchedAssignees.push(ticketItem.assignee.email);\n }\n }\n }\n\n // Build the modal\n const modal = buildSetupModal(\n ticket,\n ticketsToTrack,\n assigneeMappings,\n ticketId,\n existingReminder,\n );\n\n await openModal(triggerId, modal);\n\n return new Response(\"\", { status: 200 });\n } catch (error) {\n return new Response(\n `Error fetching Linear ticket: ${error.message}`,\n { status: 200 },\n );\n }\n }\n\n if (command === \"/status-chaser\") {\n const reminders = await getRemindersByCreator(userId);\n\n if (!reminders.length) {\n return new Response(\"You have no active reminders.\", { status: 200 });\n }\n\n const reminderList = reminders\n .map(r => {\n const ticketUrl = `https://linear.app/issue/${r.ticket_id}`;\n return `• <${ticketUrl}|${r.ticket_title}> - Pinging every ${r.interval_days} days`;\n })\n .join(\"\\n\");\n\n return new Response(\n `Your active reminders:\\n${reminderList}`,\n { status: 200 },\n );\n }\n\n if (command === \"/clear-chasers\") {\n await clearAllReminders();\n return new Response(\"All reminders have been cleared.\", { status: 200 });\n }\n\n return new Response(\"Unknown command\", { status: 200 });\n}\n\nfunction buildSetupModal(\n ticket: LinearIssue,\n ticketsToTrack: LinearTicket[],\n assigneeMappings: Record,\n ticketId: string,\n existingReminder?: any,\n) {\n const isParentTicket = ticket.children?.nodes?.length > 0;\n const ticketCount = ticketsToTrack.length;\n const ticketTypeText = isParentTicket\n ? `This ticket has ${ticketCount} sub-tickets.`\n : `Tracking this individual ticket.`;\n\n const isEditing = !!existingReminder;\n const titleText = isEditing ? \"Edit Reminder\" : \"Set Up Reminder\";\n const submitText = isEditing ? \"Update Tracking\" : \"Start Tracking\";\n\n // Define interval options\n const intervalOptions = [\n { text: { type: \"plain_text\", text: \"Daily\" }, value: \"1\" },\n { text: { type: \"plain_text\", text: \"Every 2 days\" }, value: \"2\" },\n { text: { type: \"plain_text\", text: \"Every 3 days\" }, value: \"3\" },\n { text: { type: \"plain_text\", text: \"Every 5 days\" }, value: \"5\" },\n { text: { type: \"plain_text\", text: \"Weekly\" }, value: \"7\" },\n ];\n\n let initialOption;\n if (isEditing && existingReminder) {\n initialOption = intervalOptions.find(opt => opt.value === existingReminder.interval_days.toString());\n }\n\n const blocks: any[] = [\n {\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: `*${isEditing ? \"Editing\" : \"Tracking\"}: ${ticket.title}*\\n${ticketTypeText}`,\n },\n },\n {\n type: \"input\",\n block_id: \"interval_block\",\n element: {\n type: \"static_select\",\n placeholder: {\n type: \"plain_text\",\n text: \"Select ping interval\",\n },\n action_id: \"interval_select\",\n options: intervalOptions,\n ...(initialOption ? { initial_option: initialOption } : {}),\n },\n label: {\n type: \"plain_text\",\n text: \"Ping Interval\",\n },\n },\n {\n type: \"divider\",\n },\n {\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: \"*Sub-ticket Assignee Mapping*\",\n },\n },\n ];\n\n // Add mapping fields for each ticket\n ticketsToTrack.forEach((ticketItem: LinearTicket, index: number) => {\n // If ticket has no assignee, we need to let user select someone\n if (!ticketItem.assignee?.email) {\n const unassignedKey = `unassigned_${ticketItem.id}`;\n const currentMapping = assigneeMappings[unassignedKey];\n\n blocks.push({\n type: \"input\",\n block_id: `mapping_${unassignedKey}`,\n element: {\n type: \"users_select\",\n placeholder: {\n type: \"plain_text\",\n text: \"Select Slack user to notify\",\n },\n action_id: `user_select_${index}`,\n ...(currentMapping ? { initial_user: currentMapping } : {}),\n },\n label: {\n type: \"plain_text\",\n text: `${ticketItem.title} (Unassigned - select someone to notify)`,\n },\n });\n return;\n }\n\n const isMatched = assigneeMappings[ticketItem.assignee.email] !== null;\n\n if (!isMatched) {\n blocks.push({\n type: \"input\",\n block_id: `mapping_${ticketItem.assignee.email}`,\n element: {\n type: \"users_select\",\n placeholder: {\n type: \"plain_text\",\n text: \"Select Slack user\",\n },\n action_id: `user_select_${index}`,\n },\n label: {\n type: \"plain_text\",\n text: `${ticketItem.title} (${ticketItem.assignee.email})`,\n },\n });\n } else {\n blocks.push({\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: `✓ *${ticketItem.title}*\\n${ticketItem.assignee.email} → <@${\n assigneeMappings[ticketItem.assignee.email]\n }>`,\n },\n });\n }\n });\n\n return {\n type: \"modal\",\n callback_id: \"setup_reminder\",\n title: {\n type: \"plain_text\",\n text: titleText,\n },\n submit: {\n type: \"plain_text\",\n text: submitText,\n },\n close: {\n type: \"plain_text\",\n text: \"Cancel\",\n },\n private_metadata: JSON.stringify({\n ticketId,\n assigneeMappings,\n isEditing,\n existingReminderId: existingReminder?.id,\n }),\n blocks,\n };\n}",[],[160,202],"27674610-5c0e-11f0-a4dc-0224a6c84d84","modalSubmit.ts","b263e099-dd1d-4ad4-b27d-d59729e28716",["D",1751987630741],"/**\n * Modal Submit Handler\n * \n * Processes the reminder configuration form when user clicks \"Start Tracking\"\n * Creates a new reminder in the database with the selected options\n */\n\nimport { createReminder, updateReminder } from \"../backend/database.ts\";\nimport { getLinearTicket } from \"../backend/linearApi.ts\";\nimport { SlackModalPayload } from \"../backend/types.ts\";\n\nexport default async function handleModalSubmit(payload: SlackModalPayload) {\n if (payload.view.callback_id !== \"setup_reminder\") {\n return new Response(\"\", { status: 200 });\n }\n\n const userId = payload.user.id;\n const values = payload.view.state.values;\n const metadata = JSON.parse(payload.view.private_metadata);\n \n console.log(\"Modal submit metadata:\", metadata);\n \n // Get the selected interval\n const intervalDays = parseInt(\n values.interval_block.interval_select.selected_option.value\n );\n \n // Update assignee mappings with user selections\n const finalMappings = { ...metadata.assigneeMappings };\n \n Object.keys(values).forEach(blockId => {\n if (blockId.startsWith(\"mapping_\")) {\n const selectedUserId = Object.values(values[blockId])[0].selected_user;\n \n if (blockId.startsWith(\"mapping_unassigned_\")) {\n // For unassigned tickets, use ticket ID as key\n const ticketId = blockId.replace(\"mapping_unassigned_\", \"\");\n finalMappings[`unassigned_${ticketId}`] = selectedUserId;\n } else {\n // For assigned tickets, use email as key\n const email = blockId.replace(\"mapping_\", \"\");\n finalMappings[email] = selectedUserId;\n }\n }\n });\n \n try {\n // Get fresh ticket data to ensure we have current status\n const ticket = await getLinearTicket(metadata.ticketId);\n \n // Build initial subticket status (track completion state)\n const subticketStatus: Record = {};\n \n if (ticket.children?.nodes?.length) {\n // Parent ticket with sub-tickets\n ticket.children.nodes.forEach((subticket) => {\n subticketStatus[subticket.id] = subticket.state.type === \"completed\";\n });\n } else {\n // Single ticket\n subticketStatus[ticket.id] = ticket.state.type === \"completed\";\n }\n \n // Only update if editing and existingReminderId is a valid number\n if (metadata.isEditing && metadata.existingReminderId && !isNaN(Number(metadata.existingReminderId))) {\n await updateReminder(Number(metadata.existingReminderId), {\n interval_days: intervalDays,\n assignee_mappings: JSON.stringify(finalMappings),\n subticket_status: JSON.stringify(subticketStatus),\n });\n } else {\n // Create new reminder\n await createReminder({\n ticket_id: metadata.ticketId,\n ticket_title: ticket.title,\n interval_days: intervalDays,\n last_ping: new Date().toISOString(),\n ping_count: 0,\n creator_slack_id: userId,\n assignee_mappings: JSON.stringify(finalMappings),\n subticket_status: JSON.stringify(subticketStatus),\n active: 1,\n created_at: new Date().toISOString(),\n });\n }\n \n return new Response(\"\", { status: 200 });\n } catch (error) {\n console.error(\"Error creating/updating reminder:\", error);\n return new Response(\"Failed to create/update reminder. Please try again.\", { status: 500 });\n }\n} ",[],[160,211],["D",1751987630741],[186,187],[160],"b6f7fa12-62b8-11f0-bcd3-0224a6c84d84",["D",1752720593162],[],[166,33],"b40624be-62b8-11f0-8a91-0224a6c84d84","slackApi.ts","2a2cafe0-9148-487d-ba32-e6bdeb22d4c6",29,["D",1752720588219],3,"import { WebClient } from \"https://esm.sh/@slack/web-api@7.0.2\";\nimport { SlackUser } from \"./types.ts\";\n\nexport const slackClient = new WebClient(\n Deno.env.get(\"SLACK_BOT_TOKEN\")\n ?? (() => {\n throw new Error(\"Missing SLACK_BOT_TOKEN\");\n })(),\n);\n\nexport async function lookupUserByEmail(\n email: string,\n): Promise {\n try {\n const result = await slackClient.users.lookupByEmail({ email });\n return result.user as SlackUser;\n } catch (error) {\n console.error(`Failed to lookup user by email: ${error}`);\n return null;\n }\n}\n\nexport async function sendDirectMessage(\n userId: string,\n text: string,\n): Promise {\n await slackClient.chat.postMessage({\n channel: userId,\n text: text,\n });\n}\n\nexport async function openModal(\n triggerId: string,\n view: Record,\n): Promise {\n await slackClient.views.open({\n trigger_id: triggerId,\n view: view as any,\n } as any);\n}",[],[166,225],"9feedae8-62b8-11f0-8940-0224a6c84d84","linearApi.ts","fad2a188-786f-4acf-a882-5edfe4251e6f",26,["D",1752720554513],"import { LinearClient } from \"https://esm.sh/@linear/sdk@22.0.0\";\nimport { LinearIssue } from \"./types.ts\";\n\nconst linearClient = new LinearClient({\n apiKey: Deno.env.get(\"LINEAR_API_KEY\") ?? (() => {\n throw new Error(\"Missing required env var: LINEAR_API_KEY\");\n })(),\n});\n\nexport async function getLinearTicket(ticketId: string): Promise {\n const query = `\n query IssueWithChildren($id: String!) {\n issue(id: $id) {\n id\n identifier\n title\n state { id name type }\n assignee { email name }\n completedAt\n team { id }\n labels {\n nodes {\n id\n name\n }\n }\n children {\n nodes {\n id\n identifier\n title\n state { id name type }\n assignee { email name }\n completedAt\n }\n }\n }\n }\n `;\n\n const response: any = await linearClient.client.rawRequest(query, { id: ticketId });\n const issue = response.data.issue;\n\n const linearIssue: LinearIssue = {\n id: issue.id,\n identifier: issue.identifier,\n title: issue.title,\n state: {\n name: issue.state?.name || \"\",\n type: issue.state?.type || \"\",\n },\n assignee: issue.assignee\n ? {\n email: issue.assignee.email || \"\",\n name: issue.assignee.name || \"\",\n }\n : undefined,\n completedAt: issue.completedAt,\n team: { id: issue.team.id },\n labels: issue.labels?.nodes || [],\n children: {\n nodes: (issue.children.nodes || []).map((child: any) => ({\n id: child.id,\n identifier: child.identifier,\n title: child.title,\n state: {\n name: child.state?.name || \"\",\n type: child.state?.type || \"\",\n },\n assignee: child.assignee\n ? {\n email: child.assignee.email || \"\",\n name: child.assignee.name || \"\",\n }\n : undefined,\n completedAt: child.completedAt,\n })),\n },\n };\n\n return linearIssue;\n}\n\nexport function extractTicketId(input: string): string {\n // Handle Linear URLs like https://linear.app/team/issue/TEAM-123\n const urlMatch = input.match(/([A-Z]+-\\d+)/);\n return urlMatch ? urlMatch[1] : input;\n}\n\nexport async function addChaseLabelToIssue(issueId: string): Promise {\n const issue = await getLinearTicket(issueId);\n const hasChaseLabel = issue.labels?.some(label => label.name.toLowerCase().includes(\"chase\"));\n\n if (!hasChaseLabel && issue.team?.id) {\n const labelQuery = `\n query FindChaseLabel($teamId: String!) {\n team(id: $teamId) {\n labels {\n nodes {\n id\n name\n }\n }\n }\n }\n `;\n\n const labelResponse: any = await linearClient.client.rawRequest(labelQuery, { teamId: issue.team.id });\n let chaseLabelId = labelResponse.data.team.labels.nodes.find((label: any) =>\n label.name.toLowerCase().includes(\"chase\")\n )?.id;\n\n if (chaseLabelId) {\n const mutation = `\n mutation AddChaseLabel($issueId: String!, $labelId: String!) {\n issueAddLabel(id: $issueId, labelId: $labelId) {\n success\n }\n }\n `;\n\n await linearClient.client.rawRequest(mutation, {\n issueId: issue.id,\n labelId: chaseLabelId,\n });\n }\n }\n}\n\nexport async function removeChaseLabelFromIssue(issueId: string): Promise {\n const issue = await getLinearTicket(issueId);\n const chaseLabel = issue.labels?.find(label => label.name.toLowerCase().includes(\"chase\"));\n\n if (chaseLabel) {\n const mutation = `\n mutation RemoveChaseLabel($issueId: String!, $labelId: String!) {\n issueRemoveLabel(id: $issueId, labelId: $labelId) {\n success\n }\n }\n `;\n\n await linearClient.client.rawRequest(mutation, {\n issueId: issue.id,\n labelId: chaseLabel.id,\n });\n }\n}\n\nexport async function getIssuesWithChaseLabel(): Promise {\n const query = `\n query IssuesWithChaseLabel {\n issues(\n filter: { labels: { name: { containsIgnoreCase: \"chase\" } } }\n orderBy: updatedAt\n ) {\n nodes {\n id\n identifier\n title\n state { id name type }\n assignee { email name }\n completedAt\n team { id }\n labels {\n nodes {\n id\n name\n }\n }\n children {\n nodes {\n id\n identifier\n title\n state { id name type }\n assignee { email name }\n completedAt\n }\n }\n }\n }\n }\n `;\n\n const response: any = await linearClient.client.rawRequest(query);\n return response.data.issues.nodes.map((issue: any) => ({\n id: issue.id,\n identifier: issue.identifier,\n title: issue.title,\n state: {\n name: issue.state?.name || \"\",\n type: issue.state?.type || \"\",\n },\n assignee: issue.assignee\n ? {\n email: issue.assignee.email || \"\",\n name: issue.assignee.name || \"\",\n }\n : undefined,\n completedAt: issue.completedAt,\n team: { id: issue.team.id },\n labels: issue.labels?.nodes || [],\n children: {\n nodes: (issue.children.nodes || []).map((child: any) => ({\n id: child.id,\n identifier: child.identifier,\n title: child.title,\n state: {\n name: child.state?.name || \"\",\n type: child.state?.type || \"\",\n },\n assignee: child.assignee\n ? {\n email: child.assignee.email || \"\",\n name: child.assignee.name || \"\",\n }\n : undefined,\n completedAt: child.completedAt,\n })),\n },\n }));\n}",[],[166,234],"9ce2e7d6-62b8-11f0-9142-0224a6c84d84","database.ts","e497ab87-6558-43d9-9275-16318f6e00f7",25,["D",1752720549395],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { Reminder } from \"./types.ts\";\n\nexport async function initDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS reminders_v2 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n ticket_id TEXT NOT NULL,\n ticket_title TEXT NOT NULL,\n interval_days INTEGER NOT NULL,\n last_ping TEXT NOT NULL,\n ping_count INTEGER DEFAULT 0,\n creator_slack_id TEXT NOT NULL,\n assignee_mappings TEXT NOT NULL,\n subticket_status TEXT NOT NULL,\n active INTEGER DEFAULT 1,\n created_at TEXT NOT NULL\n )\n `);\n}\n\nexport async function createReminder(reminder: Omit): Promise {\n const result = await sqlite.execute({\n sql: `\n INSERT INTO reminders_v2 (\n ticket_id, ticket_title, interval_days, last_ping, ping_count,\n creator_slack_id, assignee_mappings, subticket_status, active, created_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `,\n args: [\n reminder.ticket_id,\n reminder.ticket_title,\n reminder.interval_days,\n reminder.last_ping,\n reminder.ping_count,\n reminder.creator_slack_id,\n reminder.assignee_mappings,\n reminder.subticket_status,\n reminder.active,\n reminder.created_at,\n ],\n });\n\n return Number(result.lastInsertRowid);\n}\n\n// Map SQLite row arrays to Reminder objects so it's cleaner to read\nfunction rowToReminder(row: any[]): Reminder {\n return {\n id: row[0],\n ticket_id: row[1],\n ticket_title: row[2],\n interval_days: row[3],\n last_ping: row[4],\n ping_count: row[5],\n creator_slack_id: row[6],\n assignee_mappings: row[7],\n subticket_status: row[8],\n active: row[9],\n created_at: row[10],\n };\n}\n\nexport async function getActiveReminders(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM reminders_v2 WHERE active = 1\");\n return result.rows.map(rowToReminder);\n}\n\nexport async function updateReminder(\n id: number,\n updates: Partial,\n): Promise {\n const fields = Object.keys(updates)\n .map(key => `${key} = ?`)\n .join(\", \");\n\n await sqlite.execute({\n sql: `UPDATE reminders_v2 SET ${fields} WHERE id = ?`,\n args: [...Object.values(updates), id],\n });\n}\n\nexport async function getRemindersByCreator(creatorId: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM reminders_v2 WHERE creator_slack_id = ? AND active = 1\",\n args: [creatorId],\n });\n\n return result.rows.map(rowToReminder);\n}\n\nexport async function getAllRemindersByCreator(creatorId: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM reminders_v2 WHERE creator_slack_id = ?\",\n args: [creatorId],\n });\n return result.rows.map(rowToReminder);\n}\n\nexport async function clearAllReminders(): Promise {\n await sqlite.execute(\"UPDATE reminders_v2 SET active = 0\");\n}\n\nexport async function createAutoReminder(reminder: Omit): Promise {\n const existing = await sqlite.execute({\n sql: \"SELECT id FROM reminders_v2 WHERE ticket_id = ? AND creator_slack_id = ? AND active = 1\",\n args: [reminder.ticket_id, reminder.creator_slack_id],\n });\n\n if (existing.rows.length > 0) {\n return Number(existing.rows[0][0]);\n }\n\n return createReminder(reminder);\n}\n\nexport async function getReminderByTicketId(ticketId: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM reminders_v2 WHERE ticket_id = ? AND active = 1\",\n args: [ticketId],\n });\n\n return result.rows.length > 0 ? rowToReminder(result.rows[0]) : null;\n}",[],[166,242],["D",1751987630741],[181,182,183,184],[166],["D",1751987630741],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":-5,"_101":102,"_103":59},{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"ctx",{"_79":-5,"_124":289,"_290":291,"_292":293,"_294":25,"_295":25,"_296":25,"_297":59,"_298":-5,"_299":-7,"_300":-7,"_301":138,"_302":25,"_303":25,"_304":-5,"_305":25,"_306":25,"_307":25,"_308":-5},"ENV",{"_260":261,"_262":263,"_264":87,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v30