db.js

const Sequelize = require("sequelize");
const pkg = require("./package.json");
const chalk = require("chalk");

const dbName = process.env.NODE_ENV === "test" ? `${pkg.name}_test` : pkg.name;
console.log(chalk.yellow(`Opening database connection to ${dbName}`));

let db;

if (process.env.DATABASE_URL) {
  //heroku configuration
  db = new Sequelize(process.env.DATABASE_URL, {
    logging: false,
    dialect: "postgres",
    protocol: "postgres",
    ssl: true,
    dialectOptions: {
      ssl: {
        require: true,
        rejectUnauthorized: false,
      },
    },
  });
} else {
  //local configuration
  db = new Sequelize(`postgres://localhost:5432/${dbName}`, {
    logging: false,
  });
}

const Copy = db.define("copy", {
  text: {
    type: Sequelize.TEXT,
  },
  language: {
    type: Sequelize.STRING,
  },
  image: {
    type: Sequelize.STRING,
  },
});

module.exports = {
  db,
  Copy,
};