db.js

const pg = require("pg");
const url = require("url");

var configs;

if (process.env.DATABASE_URL) {
  const params = url.parse(process.env.DATABASE_URL);
  const auth = params.auth.split(":");

  configs = {
    user: auth[0],
    password: auth[1],
    host: params.hostname,
    port: params.port,
    database: params.pathname.split("/")[1],
    ssl: {
      rejectUnauthorized: false,
    },
  };
} else {
  configs = {
    user: "vincent",
    host: "127.0.0.1",
    database: "expenses_tracker",
    port: 5432,
  };
}

const pool = new pg.Pool(configs);

pool.on("error", function (err) {
  console.log("client pool error", err.message, err.stack);
});

// import models
const allUserModelsFunction = require("./models/users");

const userModelsObject = allUserModelsFunction(pool);

const allTrackerModelsFunction = require("./models/tracker");

const userTrackerObject = allTrackerModelsFunction(pool);

module.exports = {
  //make queries directly from here
  queryInterface: (text, params, callback) => {
    return pool.query(text, params, callback);
  },

  // get a reference to end the connection pool at server end
  pool: pool,

  /*
   * ADD APP MODELS HERE
   */
  users: userModelsObject,
  tracker: userTrackerObject
};