knexfile.js

// I only want migrations, rollbacks, and seeds to run when the NODE_ENV is specified
// in the knex seed/migrate command. Knex will error out if it is not specified.
if (!process.env.NODE_ENV) {
  throw new Error("NODE_ENV not set");
}

require("dotenv").config();

module.exports = {
  testing: {
    client: "mysql",
    debug: false,
    connection: {
      host: process.env.DB_HOST,
      port: process.env.DB_PORT,
      user: process.env.DB_USER,
      password: process.env.DB_PASSWORD,
      database: `${process.env.DB_DATABASE}_testing`,
      charset: "utf8mb4",
      collate: "utf8mb4_unicode_ci",
    },
    migrations: {
      directory: "./src/db/migrations",
    },
    seeds: {
      directory: "./src/db/seeds/dev",
    },
  },
  development: {
    client: "mysql",
    debug: false,
    connection: {
      host: process.env.DB_HOST,
      port: process.env.DB_PORT,
      user: process.env.DB_USER,
      password: process.env.DB_PASSWORD,
      database: `${process.env.DB_DATABASE}_development`,
      charset: "utf8mb4",
      collate: "utf8mb4_unicode_ci",
    },
    migrations: {
      directory: "./src/db/migrations",
    },
    seeds: {
      directory: "./src/db/seeds/dev",
    },
  },
  production: {
    client: "mysql",
    debug: false,
    connection: {
      host: process.env.DB_HOST,
      port: process.env.DB_PORT,
      user: process.env.DB_USER,
      password: process.env.DB_PASSWORD,
      database: `${process.env.DB_DATABASE}_production`,
      charset: "utf8mb4",
      collate: "utf8mb4_unicode_ci",
    },
    migrations: {
      directory: "./src/db/migrations",
    },
  },
};