Skip to content

⭐️⭐️⭐️ Open-source, self-hosted alternative to Linear and Plane. Project management and issue tracking where teams and AI agents work side by side to plan and ship products.

2.3 KB
Raw Blame
import { db } from '@repo/db';
import { sql } from 'drizzle-orm';
import { recordActivityForIssues } from './activity';
import { getIssues } from './service';
import { emitIssueEvents } from './webhook-payload';

// Archives active issues that have sat inactive in a completed/canceled column past
// their project's threshold. Inactivity is measured by issue.updated_at: moving to a
// terminal column bumps it, and any later edit resets the clock, so an issue is
// archived only after the full period with no activity.
export async function sweepStaleIssues(): Promise<number> {
  // The threshold lives in project_setting under key 'auto_archive' as
  // { completedDays, canceledDays } (kept in sync with getAutoArchiveSettings in
  // modules/projects/service.ts); a positive day count enables archiving for that state
  // group, null/absent disables it. The numeric-string regex guards the cast, so a
  // malformed value is treated as disabled rather than raising.
  const rows = await db.execute(sql`
    UPDATE issue i
    SET archived_at = now()
    FROM project_column c, project_setting s, project p
    WHERE i.column_id = c.id
      AND i.project_id = s.project_id
      AND p.id = i.project_id
      AND p.archived_at IS NULL
      AND s.key = 'auto_archive'
      AND i.archived_at IS NULL
      AND (
        (c.state_type = 'completed'
          AND (s.value->>'completedDays') ~ '^[0-9]{1,4}$'
          AND i.updated_at < now() - make_interval(days => (s.value->>'completedDays')::int))
        OR
        (c.state_type = 'canceled'
          AND (s.value->>'canceledDays') ~ '^[0-9]{1,4}$'
          AND i.updated_at < now() - make_interval(days => (s.value->>'canceledDays')::int))
      )
    RETURNING i.id, i.project_id
  `);
  const archivedRows = rows as unknown as Array<{ id: number; project_id: number }>;
  const archived = archivedRows.map((row) => row.id);
  const actor = { system: 'Auto-archive' };
  await recordActivityForIssues(archived, { action: 'archived' }, actor);
  const idsByProject = new Map<number, number[]>();
  for (const row of archivedRows) {
    const ids = idsByProject.get(row.project_id) ?? [];
    ids.push(row.id);
    idsByProject.set(row.project_id, ids);
  }
  for (const [projectId, ids] of idsByProject)
    await emitIssueEvents(projectId, 'issue.updated', () => getIssues(ids), actor);
  return archived.length;
}