[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_276":277,"_278":279},"routes/_app.x.$handle.$name",{"_98":97,"_33":47,"_106":88,"_27":38,"_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":60,"_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",{"_45":46,"_33":47,"_40":48,"_49":-5,"_50":25,"_51":52,"_53":52,"_54":-5,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":60,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",35,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":30},"file",{"_31":32,"_33":34,"_35":36,"_37":39,"_40":41,"_42":14,"_43":44,"_24":25},"previous",{"_31":32,"_33":34,"_35":36,"_37":38},"deleted",false,"deletedHere","path","linear/webhookHandler.tsx","latestPath","linear/webhookHandler.ts","fileId","c0132b12-62b8-11f0-b221-0224a6c84d84","name","webhookHandler.tsx","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}","createdAt",["D",1752720614488],"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",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":-5,"_102":103,"_104":60},"branch",{"_13":87,"_33":88,"_45":44,"_89":46,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":47,"_96":97},"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=1789588799&sig=7e028fc0dcd9deb278e9d92e3d7e002e4732f3eb7dae30cc47627f5e0eb83dfc","tier","business","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_45":46,"_33":47,"_40":272,"_49":-5,"_50":25,"_51":52,"_53":52,"_54":-5,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":60,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":273,"_82":274,"_84":275,"_86":25},"tree",[187,192,194,197,198,199],"files",[187,188,189,190,191,192,193,194,195,196,197,198,199],"counts",{"_177":139,"_178":136,"_179":139,"_180":181,"_182":183},"contents",[127,128,129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_45":172,"_33":173,"_31":174,"_135":-5,"_43":44,"_42":136,"_137":60,"_40":175,"_13":139,"_35":164,"_37":-5,"_24":25,"_142":-5,"_27":176},{"_45":166,"_33":167,"_31":168,"_135":-5,"_43":44,"_42":169,"_137":60,"_40":170,"_13":136,"_35":164,"_37":-5,"_24":25,"_142":-5,"_27":171},{"_45":160,"_33":161,"_31":162,"_135":-5,"_43":44,"_42":136,"_137":60,"_40":163,"_13":139,"_35":164,"_37":-5,"_24":25,"_142":-5,"_27":165},{"_45":152,"_33":153,"_31":154,"_135":-5,"_43":44,"_42":155,"_137":25,"_40":156,"_13":157,"_35":20,"_37":158,"_24":25,"_142":-5,"_27":159},{"_45":144,"_33":145,"_31":146,"_135":-5,"_43":44,"_42":147,"_137":25,"_40":148,"_13":64,"_35":149,"_37":150,"_24":25,"_142":-5,"_27":151},{"_45":133,"_33":134,"_31":58,"_135":-5,"_43":44,"_42":136,"_137":25,"_40":138,"_13":139,"_35":140,"_37":141,"_24":25,"_142":-5,"_27":143},"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",[134],"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}",[145],"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",[153],"27675b96-5c0e-11f0-a4dc-0224a6c84d84","slack","7f1c8f08-b4f8-43a3-a731-82f3adea16d5",["D",1751987630741],"directory",[161],"bce7e2f2-62b8-11f0-b221-0224a6c84d84","linear","bb2f5d28-62b8-11f0-b039-0224a6c84d84",32,["D",1752720603118],[167],"2767443a-5c0e-11f0-a4dc-0224a6c84d84","backend","4bbcdb0b-19ae-4a4d-820f-c9ba7e9cd798",["D",1751987630741],[173],"pulls","branches","forks","envVars",{"_184":64,"_186":139},"connections",{"_184":139,"_185":139},"count","unfilledCount","emptyCount",{"_45":172,"_33":173,"_31":174,"_135":-5,"_43":44,"_42":136,"_137":60,"_40":269,"_13":139,"_35":164,"_37":-5,"_24":25,"_142":-5,"_201":270,"_27":271},{"_45":261,"_33":262,"_31":263,"_135":174,"_43":44,"_42":264,"_137":60,"_40":265,"_13":249,"_35":36,"_37":266,"_24":25,"_142":-5,"_201":267,"_27":268},{"_45":253,"_33":254,"_31":255,"_135":174,"_43":44,"_42":256,"_137":60,"_40":257,"_13":136,"_35":36,"_37":258,"_24":25,"_142":-5,"_201":259,"_27":260},{"_45":244,"_33":245,"_31":246,"_135":174,"_43":44,"_42":247,"_137":60,"_40":248,"_13":249,"_35":36,"_37":250,"_24":25,"_142":-5,"_201":251,"_27":252},{"_45":236,"_33":237,"_31":238,"_135":174,"_43":44,"_42":239,"_137":60,"_40":240,"_13":136,"_35":36,"_37":241,"_24":25,"_142":-5,"_201":242,"_27":243},{"_45":166,"_33":167,"_31":168,"_135":-5,"_43":44,"_42":169,"_137":60,"_40":233,"_13":136,"_35":164,"_37":-5,"_24":25,"_142":-5,"_201":234,"_27":235},{"_45":229,"_33":34,"_31":32,"_135":168,"_43":44,"_42":14,"_137":25,"_40":230,"_13":64,"_35":36,"_37":39,"_24":25,"_142":-5,"_201":231,"_27":232},{"_45":160,"_33":161,"_31":162,"_135":-5,"_43":44,"_42":136,"_137":60,"_40":226,"_13":139,"_35":164,"_37":-5,"_24":25,"_142":-5,"_201":227,"_27":228},{"_45":219,"_33":220,"_31":221,"_135":162,"_43":44,"_42":136,"_137":25,"_40":222,"_13":139,"_35":36,"_37":223,"_24":25,"_142":-5,"_201":224,"_27":225},{"_45":210,"_33":211,"_31":212,"_135":162,"_43":44,"_42":213,"_137":25,"_40":214,"_13":215,"_35":36,"_37":216,"_24":25,"_142":-5,"_201":217,"_27":218},{"_45":152,"_33":153,"_31":154,"_135":-5,"_43":44,"_42":155,"_137":25,"_40":207,"_13":157,"_35":20,"_37":158,"_24":25,"_142":-5,"_201":208,"_27":209},{"_45":144,"_33":145,"_31":146,"_135":-5,"_43":44,"_42":147,"_137":25,"_40":204,"_13":64,"_35":149,"_37":150,"_24":25,"_142":-5,"_201":205,"_27":206},{"_45":133,"_33":134,"_31":58,"_135":-5,"_43":44,"_42":136,"_137":25,"_40":200,"_13":139,"_35":140,"_37":141,"_24":25,"_142":-5,"_201":202,"_27":203},["D",1751987630741],"children",[],[134],["D",1752245443370],[],[145],["D",1751988943658],[],[153],"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}",[],[161,211],"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} ",[],[161,220],["D",1751987630741],[195,196],[161],"c3ae1426-62b8-11f0-9d21-0224a6c84d84",["D",1752720614488],[],[167,34],["D",1752720603118],[193],[167],"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}",[],[173,237],"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}",[],[173,245],"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}",[],[173,254],"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}",[],[173,262],["D",1751987630741],[188,189,190,191],[173],["D",1751987630741],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":-5,"_102":103,"_104":60},{"_13":87,"_33":88,"_45":44,"_89":46,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":47,"_96":97},"ctx",{"_80":-5,"_124":309,"_310":311,"_312":313,"_314":25,"_315":25,"_316":25,"_317":60,"_318":-5,"_319":-7,"_320":-7,"_321":139,"_322":25,"_323":25,"_324":-5,"_325":25,"_326":25,"_327":25,"_328":-5},"ENV",{"_280":281,"_282":283,"_284":88,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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 · v35