// db/knex.js
const knex = require('knex');
const path = require('path');

const db = knex({
  client: 'better-sqlite3',

  connection: {
    filename: './api_v1/database.sqlite',
  },

  useNullAsDefault: true,

  pool: {
    afterCreate(conn, done) {
      try {
        conn.pragma('journal_mode = WAL');
        conn.pragma('busy_timeout = 30000');

        console.log('[DB] journal_mode=WAL');
        console.log('[DB] busy_timeout=30000');
      } catch (err) {
        console.error('[DB] pragma error', err);
      }

      done(null, conn);
    },
  },
});

console.log(
  '📌 DB PATH:',
  path.resolve('./api_v1/database.sqlite')
);

module.exports = db;