// src/db/knex.ts
import knex from "knex";
import { Model } from "objection";
import config from "../config/knexfile";

const environment = process.env.NODE_ENV || "development";
declare global {
  var __knexInstance__: ReturnType<typeof knex> | undefined;
}

// const db = knex(config[environment]);
const db = global.__knexInstance__ || knex(config[environment]);

if (process.env.NODE_ENV !== "production") {
  global.__knexInstance__ = db;
}
Model.knex(db);
export default db;