knexfile.js

import dotenv from 'dotenv';
import { dirname } from 'node:path';
import { fileURLToPath } from 'node:url';

dotenv.config();
const __dirname = dirname(fileURLToPath(import.meta.url));

const knexConfig = {
  production: {
    client: 'pg',
    connection: {
      host: process.env.PG_HOST,
      port: process.env.PG_PORT,
      user: process.env.PG_USER,
      password: process.env.PG_PASSWORD,
      database: process.env.PG_DATABASE,
    },
    migrations: {
      directory: `${__dirname}/db/migrations`,
    },
    seeds: {
      directory: `${__dirname}/db/seeds`,
    },
  },

  development: {
    client: 'sqlite3',
    connection: {
      filename: `${__dirname}/db/sqlite.db`,
    },
    migrations: {
      directory: `${__dirname}/db/migrations`,
    },
    seeds: {
      directory: `${__dirname}/db/seeds`,
    },
    useNullAsDefault: true,
  },
};

export default knexConfig;