knexfile.js

'use strict';

/**
 * Knex configuration (issue #252).
 *
 * Migration files already existed under src/db/migrations, but there was no
 * knexfile and knex was not a dependency, so nothing could actually run
 * them. This wires them up and points knex at the same DATABASE_URL the
 * rest of the service uses.
 *
 * `migrations.tableName` is left at knex's default (`knex_migrations`);
 * the dedicated status tracking the issue asks for lives in a separate
 * table written by src/db/migrationSafety.js, so knex's own bookkeeping
 * stays untouched and recoverable.
 */

require('dotenv').config();

const path = require('path');

const migrations = {
  directory: path.join(__dirname, 'src', 'db', 'migrations'),
  extension: 'js',
  disableTransactions: false,
};

function connectionFor(fallback) {
  return process.env.DATABASE_URL || fallback;
}

// Issue #494 — migrations and ad-hoc knex CLI queries must render timestamps
// in UTC too, not in the database server's local zone. Runs per pooled
// connection.
function afterCreateUtcConnection(conn, done) {
  conn.query("SET TIME ZONE 'UTC'", (err) => done(err, conn));
}

module.exports = {
  development: {
    client: 'pg',
    connection: connectionFor('postgres://localhost/smartdrop'),
    pool: { min: 2, max: 10, afterCreate: afterCreateUtcConnection },
    migrations,
  },

  test: {
    client: 'pg',
    connection: connectionFor('postgres://localhost/smartdrop_test'),
    pool: { min: 2, max: 10, afterCreate: afterCreateUtcConnection },
    migrations,
  },

  production: {
    client: 'pg',
    connection: connectionFor(undefined),
    pool: { min: 2, max: 10, afterCreate: afterCreateUtcConnection },
    migrations,
  },
};