[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_303":304,"_305":306},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_229":-5,"_20":230,"_22":231,"_232":233,"_234":235,"_26":236,"_24":237,"_238":-5,"_239":-5,"_240":55,"_241":242,"_243":46,"_244":-5,"_245":-5,"_246":247},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","Crossmint","name","Linear-to-Slack-Reminder","branchName","main","version","path","linear","project",{"_34":175,"_13":14,"_47":176,"_177":-5,"_178":55,"_179":180,"_181":180,"_182":-5,"_183":-5,"_184":185,"_186":72,"_187":46,"_188":46,"_189":-5,"_190":191,"_192":193,"_194":-5,"_195":-5,"_196":-5,"_197":-5,"_198":199,"_200":199,"_201":202,"_203":202,"_204":202,"_205":199,"_206":199,"_207":208,"_209":210,"_211":212,"_213":55},"tree",[64,65,66,67,68,69],"file",{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":60,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_18":63},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","968b1b6e-62b9-11f0-a5a3-0224a6c84d84","webhookHandler.ts","fileId","c0132b12-62b8-11f0-b221-0224a6c84d84","parentId","bb2f5d28-62b8-11f0-b039-0224a6c84d84","branchId","27583b16-5c0e-11f0-a4dc-0224a6c84d84","branchVersion",53,"latest",true,"createdAt",["D",1752720968254],4,"fileType","script","content","import {\n createAutoReminder,\n getReminderByTicketId,\n getRemindersByCreator,\n updateReminder,\n} from \"../backend/database.ts\";\nimport { getLinearTicket, removeChaseLabelFromIssue } from \"../backend/linearApi.ts\";\nimport { lookupUserByEmail } from \"../backend/slackApi.ts\";\n\nexport default async function handleLinearWebhook(req: Request) {\n const payload = await req.json();\n\n console.log(\"Linear webhook received:\", JSON.stringify(payload, null, 2));\n\n // Handle issue state changes - when ticket is marked as done, remove chase label\n if (payload.action === \"update\" && payload.type === \"Issue\" && payload.updatedFrom?.stateId) {\n const oldStateId = payload.updatedFrom.stateId;\n const newState = payload.data?.state;\n\n // If ticket was moved to completed state, remove chase label\n if (newState?.type === \"completed\") {\n console.log(\"Ticket marked as completed, removing chase label for:\", payload.data.identifier);\n try {\n await removeChaseLabelFromIssue(payload.data.identifier);\n await deactivateReminderForTicket(payload.data.identifier, payload.actor?.email);\n } catch (error) {\n console.error(\"Error removing chase label from completed ticket:\", error);\n }\n }\n }\n\n // Handle issue label updates - when labels are added/removed from issues\n if (payload.action === \"update\" && payload.type === \"Issue\" && payload.updatedFrom?.labelIds) {\n const oldLabelIds = payload.updatedFrom.labelIds || [];\n const newLabelIds = payload.data?.labelIds || [];\n\n // Find current chase label (if any)\n const currentChaseLabel = payload.data?.labels?.find((label: any) => label.name.toLowerCase().includes(\"chase\"));\n\n // Check if chase label was added\n if (currentChaseLabel && !oldLabelIds.includes(currentChaseLabel.id)) {\n console.log(\"Chase label added, creating reminder for:\", payload.data.identifier);\n await createReminderFromTicket(payload.data.identifier, payload.actor?.email);\n }\n\n // Check if chase label was removed - no current chase label but there was a reminder\n if (!currentChaseLabel && oldLabelIds.length > newLabelIds.length) {\n // Check if there's actually a reminder to deactivate (implies there was a chase label)\n const reminder = await getReminderByTicketId(payload.data.identifier);\n if (reminder) {\n console.log(\"Chase label removed, deactivating reminder for:\", payload.data.identifier);\n await deactivateReminderForTicket(payload.data.identifier, payload.actor?.email);\n }\n }\n }\n\n return new Response(\"OK\", { status: 200 });\n}\n\nasync function createReminderFromTicket(ticketId: string, actorEmail: string) {\n const ticket = await getLinearTicket(ticketId);\n\n const assigneeMappings: Record = {};\n\n if (ticket.children?.nodes?.length) {\n for (const subticket of ticket.children.nodes) {\n if (subticket.assignee?.email) {\n const slackUser = await lookupUserByEmail(subticket.assignee.email);\n if (slackUser) {\n assigneeMappings[subticket.assignee.email] = slackUser.id;\n }\n }\n }\n } else if (ticket.assignee?.email) {\n const slackUser = await lookupUserByEmail(ticket.assignee.email);\n if (slackUser) {\n assigneeMappings[ticket.assignee.email] = slackUser.id;\n }\n }\n\n // Use the actor who added the chase label as the creator\n const creatorSlackUser = await lookupUserByEmail(actorEmail);\n const creatorSlackId = creatorSlackUser?.id || \"linear-webhook\";\n\n console.log(`Creating reminder with data:`, {\n ticket_id: ticket.identifier,\n ticket_title: ticket.title,\n creator_slack_id: creatorSlackId,\n assignee_mappings: JSON.stringify(assigneeMappings),\n active: 1,\n });\n\n const reminderId = await createAutoReminder({\n ticket_id: ticket.identifier,\n ticket_title: ticket.title,\n interval_days: 1,\n last_ping: new Date(Date.now() - 24 * 60 * 60 * 1000).toISOString(),\n ping_count: 0,\n creator_slack_id: creatorSlackId,\n assignee_mappings: JSON.stringify(assigneeMappings),\n subticket_status: \"{}\",\n active: 1,\n created_at: new Date().toISOString(),\n });\n\n console.log(`Reminder created with ID: ${reminderId} for creator: ${creatorSlackId}`);\n}\n\nasync function deactivateReminderForTicket(ticketId: string, actorEmail: string) {\n const reminder = await getReminderByTicketId(ticketId);\n\n if (reminder) {\n await updateReminder(reminder.id!, { active: 0 });\n console.log(`Deactivated reminder ${reminder.id} for ticket ${ticketId}`);\n }\n}","deleted",false,"label",[19,36],"bce7e2f2-62b8-11f0-b221-0224a6c84d84",32,["D",1752720603118],1,"directory",[19],{"_34":132,"_13":133,"_37":134,"_39":-5,"_41":42,"_43":61,"_45":46,"_47":135,"_17":103,"_50":62,"_52":-5,"_54":55,"_56":-5,"_77":136,"_18":137},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":125,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_77":126,"_18":127},{"_34":99,"_13":100,"_37":101,"_39":-5,"_41":42,"_43":61,"_45":46,"_47":102,"_17":103,"_50":62,"_52":-5,"_54":55,"_56":-5,"_77":104,"_18":105},{"_34":90,"_13":91,"_37":92,"_39":-5,"_41":42,"_43":93,"_45":46,"_47":94,"_17":95,"_50":24,"_52":96,"_54":55,"_56":-5,"_77":97,"_18":98},{"_34":80,"_13":81,"_37":82,"_39":-5,"_41":42,"_43":83,"_45":46,"_47":84,"_17":85,"_50":86,"_52":87,"_54":55,"_56":-5,"_77":88,"_18":89},{"_34":70,"_13":71,"_37":72,"_39":-5,"_41":42,"_43":73,"_45":46,"_47":74,"_17":49,"_50":75,"_52":76,"_54":55,"_56":-5,"_77":78,"_18":79},"e419aaea-62b8-11f0-bffe-0224a6c84d84","main.ts","13d59912-3d8a-4fe5-85cb-b5c9c34eef2b",43,["D",1752720668875],"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 handleLinearWebhook from \"./linear/webhookHandler.ts\";\nimport handleModalSubmit from \"./slack/modalSubmit.ts\";\nimport handleSlashCommand from \"./slack/slashCommand.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 if (url.pathname === \"/linear/webhook\") {\n return handleLinearWebhook(req);\n }\n\n return new Response(\"Not found\", { status: 404 });\n}","children",[],[71],"514e604c-62b9-11f0-a5a3-0224a6c84d84","cron.ts","a41ae8df-fa7e-41a5-b518-9ef53642aa7d",50,["D",1752720852091],5,"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 = true; // 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 = `⚠️ 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 .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 \\`/chase ${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 = `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 = `https://linear.app/issue/${reassignment.ticket.identifier}`;\n const reassignMessage = `🔄 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 /status-chase\n active: allComplete ? 0 : 1,\n });\n console.log(\n ` 💾 Updated reminder (active=${allComplete ? 0 : 1}, ping_count=${reminder.ping_count + 1})`,\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}",[],[81],"7e60a1d0-62b9-11f0-9142-0224a6c84d84","README.md","13342248-0b37-4af5-9daf-1828fe60ba47",52,["D",1752720927710],9,"# Linear-Slack Reminder Bot\n\nLinear-Slack Reminder Bot monitors Linear tickets and sends scheduled Slack\nreminders to assignees.\n\nYou may also trigger and use this bot through adding a `chase` Linear label - the statuses of your Linear tickets with the label will always be synced with the Slack bot.\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-chasers\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",[],[91],"27675b96-5c0e-11f0-a4dc-0224a6c84d84","slack","7f1c8f08-b4f8-43a3-a731-82f3adea16d5",["D",1751987630741],0,[106,107],[100],{"_34":117,"_13":118,"_37":119,"_39":101,"_41":42,"_43":120,"_45":46,"_47":121,"_17":61,"_50":51,"_52":122,"_54":55,"_56":-5,"_77":123,"_18":124},{"_34":108,"_13":109,"_37":110,"_39":101,"_41":42,"_43":111,"_45":46,"_47":112,"_17":113,"_50":51,"_52":114,"_54":55,"_56":-5,"_77":115,"_18":116},"21dd57b4-62b9-11f0-a5a3-0224a6c84d84","slashCommand.ts","842d355e-c60d-4200-958c-678463c4ad93",47,["D",1752720772499],18,"/**\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 {\n extractTicketId,\n getIssuesWithChaseLabel,\n getLinearTicket,\n removeChaseLabelFromIssue,\n} 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 console.log(`/status-chaser called by userId: ${userId}`);\n\n // Get both reminders and Linear chase-labeled issues\n const [reminders, chaseIssues] = await Promise.all([\n getRemindersByCreator(userId),\n getIssuesWithChaseLabel(),\n ]);\n\n console.log(`Found ${reminders.length} reminders and ${chaseIssues.length} chase-labeled issues`);\n\n // Validate reminders - check if their Linear tickets still exist\n const validReminders = [];\n for (const reminder of reminders) {\n try {\n await getLinearTicket(reminder.ticket_id);\n validReminders.push(reminder);\n } catch (error) {\n // Ticket doesn't exist anymore, deactivate the reminder\n console.log(`Ticket ${reminder.ticket_id} no longer exists, deactivating reminder`);\n await updateReminder(reminder.id!, { active: 0 });\n }\n }\n\n // Create a combined list, avoiding duplicates\n const trackedTickets = new Map();\n\n // Add valid reminders\n validReminders.forEach(r => {\n const ticketUrl = `https://linear.app/issue/${r.ticket_id}`;\n trackedTickets.set(r.ticket_id, `• <${ticketUrl}|${r.ticket_title}> - Pinging every ${r.interval_days} days`);\n });\n\n // Add chase-labeled issues (only if not already tracked)\n chaseIssues.forEach(issue => {\n if (!trackedTickets.has(issue.identifier)) {\n const ticketUrl = `https://linear.app/issue/${issue.identifier}`;\n trackedTickets.set(issue.identifier, `• <${ticketUrl}|${issue.title}> - Pinging daily`);\n }\n });\n\n if (trackedTickets.size === 0) {\n return new Response(\"You have no active reminders or chase-labeled issues.\", { status: 200 });\n }\n\n const ticketList = Array.from(trackedTickets.values()).join(\"\\n\");\n\n return new Response(\n `Your tracked tickets:\\n${ticketList}`,\n { status: 200 },\n );\n }\n\n if (command === \"/clear-chasers\") {\n const reminders = await getRemindersByCreator(userId);\n\n for (const reminder of reminders) {\n await removeChaseLabelFromIssue(reminder.ticket_id);\n }\n\n await clearAllReminders();\n return new Response(\"All reminders and chase labels 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}",[],[100,109],"cde16a9c-62b8-11f0-ad0b-0224a6c84d84","modalSubmit.ts","b263e099-dd1d-4ad4-b27d-d59729e28716",36,["D",1752720631597],"/**\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 { addChaseLabelToIssue, 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 // Add chase label to Linear issue\n await addChaseLabelToIssue(metadata.ticketId);\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}",[],[100,118],["D",1752720603118],[128],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":129,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_77":130,"_18":131},["D",1752720968254],[],[19,36],"2767443a-5c0e-11f0-a4dc-0224a6c84d84","backend","4bbcdb0b-19ae-4a4d-820f-c9ba7e9cd798",["D",1751987630741],[138,139,140,141],[133],{"_34":167,"_13":168,"_37":169,"_39":134,"_41":42,"_43":170,"_45":46,"_47":171,"_17":155,"_50":51,"_52":172,"_54":55,"_56":-5,"_77":173,"_18":174},{"_34":159,"_13":160,"_37":161,"_39":134,"_41":42,"_43":162,"_45":46,"_47":163,"_17":61,"_50":51,"_52":164,"_54":55,"_56":-5,"_77":165,"_18":166},{"_34":150,"_13":151,"_37":152,"_39":134,"_41":42,"_43":153,"_45":46,"_47":154,"_17":155,"_50":51,"_52":156,"_54":55,"_56":-5,"_77":157,"_18":158},{"_34":142,"_13":143,"_37":144,"_39":134,"_41":42,"_43":145,"_45":46,"_47":146,"_17":61,"_50":51,"_52":147,"_54":55,"_56":-5,"_77":148,"_18":149},"b6f7fa12-62b8-11f0-bcd3-0224a6c84d84","types.ts","825a1182-36a9-4815-9fce-8dabbc695b80",30,["D",1752720593162],"// 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}",[],[133,143],"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}",[],[133,151],"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}",[],[133,160],"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}",[],[133,168],"275590c8-5c0e-11f0-a4dc-0224a6c84d84",["D",1751987630741],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","80253444-09af-4df4-a560-c86b38750edf","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",2,"orgId","01989fcc-dbe7-7389-a3ad-45c50d401a74","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_228":224},"org",{"_11":12,"_222":-5,"_223":224,"_184":-5,"_225":226,"_227":46},"branch",{"_17":44,"_13":16,"_34":42,"_214":175,"_215":-5,"_216":-5,"_217":-5,"_218":-5,"_219":-5,"_220":14,"_221":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/dc2506f3-9fe8-4b41-d79b-eb9074f98200/square512?exp=1789567199&sig=dc7a09b09c6954e2f1fc12b968f053bf53d2d9d1074d51682c78fccee0c9d83e","tier","business","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":175,"_13":14,"_47":299,"_177":-5,"_178":55,"_179":180,"_181":180,"_182":-5,"_183":-5,"_184":185,"_186":72,"_187":46,"_188":46,"_189":-5,"_190":191,"_192":193,"_194":-5,"_195":-5,"_196":-5,"_197":-5,"_198":199,"_200":199,"_201":202,"_203":202,"_204":202,"_205":199,"_206":199,"_207":300,"_209":301,"_211":302,"_213":55},[260,265,267,270,271,272],"files",[260,261,262,263,264,265,266,267,268,269,270,271,272],"counts",{"_251":103,"_252":61,"_253":103,"_32":254,"_255":256},[249],{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":60,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_18":248},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":250},[19,36],"pulls","branches","forks",{"_257":191,"_259":103},"connections",{"_257":103,"_258":103},"count","unfilledCount","emptyCount",{"_34":132,"_13":133,"_37":134,"_39":-5,"_41":42,"_43":61,"_45":46,"_47":135,"_17":103,"_50":62,"_52":-5,"_54":55,"_56":-5,"_77":297,"_18":298},{"_34":167,"_13":168,"_37":169,"_39":134,"_41":42,"_43":170,"_45":46,"_47":171,"_17":155,"_50":51,"_52":172,"_54":55,"_56":-5,"_77":295,"_18":296},{"_34":159,"_13":160,"_37":161,"_39":134,"_41":42,"_43":162,"_45":46,"_47":163,"_17":61,"_50":51,"_52":164,"_54":55,"_56":-5,"_77":293,"_18":294},{"_34":150,"_13":151,"_37":152,"_39":134,"_41":42,"_43":153,"_45":46,"_47":154,"_17":155,"_50":51,"_52":156,"_54":55,"_56":-5,"_77":291,"_18":292},{"_34":142,"_13":143,"_37":144,"_39":134,"_41":42,"_43":145,"_45":46,"_47":146,"_17":61,"_50":51,"_52":147,"_54":55,"_56":-5,"_77":289,"_18":290},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":125,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_77":287,"_18":288},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":129,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_77":285,"_18":286},{"_34":99,"_13":100,"_37":101,"_39":-5,"_41":42,"_43":61,"_45":46,"_47":102,"_17":103,"_50":62,"_52":-5,"_54":55,"_56":-5,"_77":283,"_18":284},{"_34":117,"_13":118,"_37":119,"_39":101,"_41":42,"_43":120,"_45":46,"_47":121,"_17":61,"_50":51,"_52":122,"_54":55,"_56":-5,"_77":281,"_18":282},{"_34":108,"_13":109,"_37":110,"_39":101,"_41":42,"_43":111,"_45":46,"_47":112,"_17":113,"_50":51,"_52":114,"_54":55,"_56":-5,"_77":279,"_18":280},{"_34":90,"_13":91,"_37":92,"_39":-5,"_41":42,"_43":93,"_45":46,"_47":94,"_17":95,"_50":24,"_52":96,"_54":55,"_56":-5,"_77":277,"_18":278},{"_34":80,"_13":81,"_37":82,"_39":-5,"_41":42,"_43":83,"_45":46,"_47":84,"_17":85,"_50":86,"_52":87,"_54":55,"_56":-5,"_77":275,"_18":276},{"_34":70,"_13":71,"_37":72,"_39":-5,"_41":42,"_43":73,"_45":46,"_47":74,"_17":49,"_50":75,"_52":76,"_54":55,"_56":-5,"_77":273,"_18":274},[],[71],[],[81],[],[91],[],[100,109],[],[100,118],[268,269],[100],[],[19,36],[266],[19],[],[133,143],[],[133,151],[],[133,160],[],[133,168],[261,262,263,264],[133],["D",1751987630741],{"_11":12,"_228":224},{"_11":12,"_222":-5,"_223":224,"_184":-5,"_225":226,"_227":46},{"_17":44,"_13":16,"_34":42,"_214":175,"_215":-5,"_216":-5,"_217":-5,"_218":-5,"_219":-5,"_220":14,"_221":12},"ctx",{"_207":-5,"_245":336,"_337":338,"_339":340,"_341":55,"_342":55,"_343":55,"_344":46,"_345":-5,"_346":-7,"_347":-7,"_348":103,"_349":55,"_350":55,"_351":-5,"_352":55,"_353":55,"_354":55,"_355":-5},"ENV",{"_307":308,"_309":310,"_311":16,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335},"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"]