[T019] Create migration runner

[h4yfans]

Task ID: T019

Phase: 2 - Foundational (Blocking Prerequisites)
Feature: Core Data Layer

Description

Create migration runner in src/main/database/migrate.ts

Implementation Details

File: src/main/database/migrate.ts

import { migrate } from 'drizzle-orm/better-sqlite3/migrator';
import { drizzle } from 'drizzle-orm/better-sqlite3';
import Database from 'better-sqlite3';
import path from 'path';

export function runMigrations(dbPath: string): void {
  const sqlite = new Database(dbPath);
  const db = drizzle(sqlite);

  const migrationsFolder = path.join(__dirname, 'drizzle');
  migrate(db, { migrationsFolder });

  sqlite.close();
}

Acceptance Criteria

• Runs all pending migrations
• Migrations folder path correct
• Database file created if not exists
• Closes connection after migration

Related Documents

• specs/001-core-data-layer/quickstart.md
• specs/001-core-data-layer/data-model.md