1

I'm a trying to sync all the models in one file , according to sequelize documentation sequelize.sync() will do the work but after running the file no errors occurs but also no tables created in the database

This an example of the product model file

module.exports = (sequelize, DataTypes) => {

const Product = sequelize.define('product', {
    id: {
        type: DataTypes.INTEGER,
        primaryKey: true,
        autoIncrement: true,
    },
    name: {
        type: DataTypes.STRING,
        allowNull: false,
    },
    description: {
        type: DataTypes.TEXT
    },
    price: {
        type: DataTypes.DECIMAL
    }, sale_price: {
        type: DataTypes.DECIMAL,
    }, sku: {
        type: DataTypes.INTEGER
    }, qty: {
        type: DataTypes.INTEGER
    }
})
return Product;

}

and this is the file supposed to sync the database :

const { Sequelize, DataTypes } = require('sequelize');
const dbConfig = require('./config/dbConfig');
const Product = require('./models/product')

const sequelize = new Sequelize(
    dbConfig.DB,
    dbConfig.USER,
    dbConfig.PASSWORD, {
    host: dbConfig.HOST,
    dialect: dbConfig.dialect,
    operatorsAliases: false,
    pool: {
        max: dbConfig.pool.max,
        min: dbConfig.pool.min,
        aquire: dbConfig.pool.aquire,
        idle: dbConfig.pool.idle
    }
}
)

sequelize.authenticate()
    .then(() => {
        console.log("Connected to the database successfuly !");
    }).catch((err) => {
        console.log("Error: " + err)
    })


const db = {}

db.Sequelize = Sequelize
db.sequelize = sequelize
db.product = Product



db.sequelize.sync({ force: true })
    .then(() => {
        console.log("re-sync done!");
    })


module.exports = db
  • This answer worked for me ! i hope it helps someone else :) https://stackoverflow.com/questions/63611772/sequelize-does-not-creating-a-table-shows-this-result-executing-default-se – Muhammad Essam Sep 06 '22 at 17:17

1 Answers1

1

You didn't register your Product model in Sequelize instance. Please look at my other answer here to get the idea how to do it.

Anatoly
  • 20,799
  • 3
  • 28
  • 42