sequelize throwing error Dialect needs to be explicitly defined in express js

Question

Hi I am trying to use sequelize find all query. But it is giving error as :

Error: Dialect needs to be explicitly supplied as of v4.0.0 at new Sequelize (/home/europa/public_html/wired-rest-apis/node_modules/sequelize/lib/sequelize.js:170:13)

Below is my express js / node js code:-

  var Sequelize = require('sequelize');

    // db config
    var env = "dev";
    var config = require('./config.json')[env];
    var password = config.password ? config.password : null;

    // initialize database connection
    var sequelize = new Sequelize(
        config.database,
        config.user,
        config.password, {
            logging: console.log,
            define: {
                timestamps: false
            }
        }
    );

    app.get('/list_cars', function(req,res){

        const Image = sequelize.define('add_cars', {/* ... */})
        const Car = sequelize.define('car_images', {/* ... */})
        Car.hasMany(Image, {as: 'Images', foreignKey:'add_car_id'})
        Car.findAll({
         include: [{
         model: Image
         }]
       })  .success(function(cars) {
            console.log(cars);
         });

    });

Grijan Grijan · Accepted Answer · 2017-12-06T08:49:51

Make sure u are using dialect in config.json,

{
    "username" : "root",
    "password" : "root",
    "database" :"grijan",
    "host" : "localhost",
    "dialect" : "mysql",
    "name" : "add"
}

sequelize throwing error Dialect needs to be explicitly defined in express js

1 Answers