// src/db/index.ts
import { drizzle } from 'drizzle-orm/better-sqlite3';
import Database from 'better-sqlite3';
import * as schema from './schema';
import { resolve } from 'path';

// Get database path
const databasePath = process.env.DATABASE_URL || resolve(process.cwd(), './sqlite.db');

// Create SQLite database connection
const sqlite = new Database(databasePath);

// Create Drizzle database instance
export const db = drizzle(sqlite, { schema });