Node.js - Sequelize Model Setup

Breed.js

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

module.exports = {
  name: "Breed",
  modelName: "breed",
  schema: {
    name: {
      type: DataTypes.STRING,
      allowNull: false,
    }   
  },
};

BreedImage.js

const { DataTypes, Deferrable } = require("sequelize");
const breed = require('./Breed')

module.exports = {
  name: "BreedImage",
  modelName: "breed_image",
  schema: {
    breed_id:  {
      type: DataTypes.INTEGER,
   
      references: {
        // This is a reference to another model
        model: breed.modelName,
   
        // This is the column name of the referenced model
        key: 'id',
   
        // This declares when to check the foreign key constraint. PostgreSQL only.
        deferrable: Deferrable.INITIALLY_IMMEDIATE
      }
    },
    image_src: {
      type: DataTypes.STRING,
      allowNull: false,
    },
  },
};

ModelFactory.js

function getModels(sequelize) {
  const models = [require("./Breed"), require("./BreedImage")];
  const result = {};

  for (const model of models) {
    result[model.name] = modelFactory(sequelize, model);
  }

  return result;
}


const modelFactory = (sequelize, modelDefinition) => {
  const customModel = sequelize.define(
    modelDefinition.name,
    modelDefinition.schema,
    {
      sequelize,
      modelName: modelDefinition.modelName || modelDefinition.name,
    }
  );
  return customModel;
};

module.exports = {
  getModels,
};

usage-example.js

const Sequelize = require("sequelize");
const Keys = require("./keys");

const {getModels} = require("./ModelFactory")

const sequelize = new Sequelize(Keys.PGDATABASE, Keys.PGUSER, Keys.PGPASSWORD, {
  host: Keys.PGHOST,
  dialect: "postgres",
});

const models = getModels(sequelize);

// Sync the table and add the breed
models.BreedImage.sync({ force: true }).then(() => {
    return models.BreedImage.create({
      breed: "Collie",
      image:"myimage.jpg"
    });
  });