knexfile.js

// @ts-check

import path from 'path';
import url from 'url';

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

const migrations = {
  directory: path.join(__dirname, 'server', 'migrations'),
};

export const development = {
  client: 'sqlite3',
  connection: {
    filename: './database.sqlite',
  },
  useNullAsDefault: true,
  migrations,
};

// export const development = {
//   client: 'pg',
//   connection: {
//     host: '127.0.0.1',
//     port: 5432,
//     database: 'b4_hexlet_db',
//     user: 'prestor',
//     password: 'f',
//   },
//   useNullAsDefault: true,
//   migrations,
// };

export const test = {
  client: 'sqlite3',
  connection: ':memory:',
  useNullAsDefault: true,
  // debug: true,
  migrations,
};

export const production = {
  client: 'pg',
  connection: {
    connectionString: process.env.DATABASE_URL,
    ssl: { rejectUnauthorized: false },
  },
  useNullAsDefault: true,
  migrations,
};