Class TaskRepository

apps/task-manager/src/db/repository.ts:49–332

 * Task Repository class for database operations
 */
export class TaskRepository {
  private db: Database;

  constructor() {
    this.db = getDatabase();
  }

  /**
   * Create a new task
   * @param input - Task creation input
   * @returns The created task
   */
  create(input: CreateTaskInput): Task {
    const now = new Date().toISOString();

    try {
      const stmt = this.db.prepare(`
        INSERT INTO tasks (title, description, priority, due_date, completed, created_at)
        VALUES (?, ?, ?, ?, 0, ?)
      `);

      const result = stmt.run(
        input.title,
        input.description ?? null,
        input.priority,
        input.dueDate ?? null,
        now
      );

      const id = Number(result.lastInsertRowid);

      // Fetch and return the created task
      const task = this.findById(id);
      if (!task) {
        throw new Error('Failed to retrieve created task');
      }

      return task;
    } catch (error) {
      const message = error instanceof Error ? error.message : 'Unknown error';
      throw new Error(`Failed to create task: ${message}`);
    }
  }

  /**
   * Find all tasks with optional filters
   * @param filters - Optional filters for priority, completed status, pending, overdue
   * @returns Array of tasks matching the filters
   */
  findAll(filters?: {
    priority?: Priority;
    completed?: boolean;
    pending?: boolean;
    overdue?: boolean;
  }): Task[] {
    try {
      let query = 'SELECT * FROM tasks WHERE 1=1';
      const params: (string | number)[] = [];