db.js

"use strict";

require("dotenv").config();
console.log("env!!!", process.env.DATABASE);
/** Database setup for pixly */

const { Sequelize, DataTypes } = require("sequelize");

const sequelize = new Sequelize({
   database: process.env.DATABASE,
   username: process.env.DATABASE_USER,
   password: process.env.DATABASE_PASSWORD,
   dialect: "postgres",
});

/**
 * Example function from sequelize to test DB connection is established
 */
async function testConnection() {
   try {
      await sequelize.authenticate();
      console.log("Connection has been established successfully.");
   } catch (error) {
      console.error("Unable to connect to the database:", error);
   }
}
testConnection();

// Definition of the images table and the data that will be passed in
const ImageModel = sequelize.define(
   "images",
   {
      image_url: {
         type: DataTypes.TEXT,
         allowNull: false,
         primaryKey: true,
      },
      title: { type: DataTypes.TEXT, allowNull: false },
      description: { type: DataTypes.TEXT, allowNull: false },
      uploaded_by: { type: DataTypes.TEXT, allowNull: false },
      metadata: { type: DataTypes.JSON, allowNull: true },
   },
   { timestamps: false }
);

module.exports = { sequelize, ImageModel };