In my case i just import Model to app.js

const sequelize = require("./src/Utils/database");
const User = require("./src/models/User");

sequelize
  .sync()
  .then((result) => {
    console.log(result);
  })
  .catch((err) => {
    console.log(err);
  });

@PawelC your code is same as mine so it will also work for you

Thanks

just import the user model file in index.js .This will create the table in database, as unless and until node reads that file it doesnot know that a table is created.

To solve this challenge, install sequelize-cli on your console. Then follow these steps below,

1. Run npx sequelize init on your console, it generates some folders like config folder, models folder, etc. Delete the config folder and open the models -> index.js and refactor the code this way:

`

"use strict";
 const Sequelize = require("sequelize");
  const sequelize = new Sequelize("DATABASE NAME ", "USERNAME", "PASSWORD", {
  dialect: "mysql"
});

const models = {
  Product: sequelize.import("./Product") // kindly import the model created in the same folder in this manner and import more models name been created
};

Object.keys(models).forEach(modelName => {
  if ("associate" in models[modelName]) {
    models[modelName].associate(models);
  }
});

models.sequelize = sequelize;
models.Sequelize = Sequelize;
module.exports = models;
`

2. In the same model folder where models are created, kindly refactor your model creation code this way

const sequelize = require("../util/database") // import the Database connection path;

module.exports = (sequelize, DataTypes) => {
  const Product = sequelize.define("product", {
    id: {
      type: DataTypes.INTEGER,
      autoIncrement: true,
      primaryKey: true,
      allowNull: false
    },
    name: {
      type: DataTypes.STRING,
      unique: true
    },
    email: {
      type: DataTypes.STRING,
      unique: true
    },
    password: DataTypes.STRING
  });

  return Product;
};

3. In your index.js file

`

    const express = require('express');
    const bodyParser = require('body-parser');
    const app = express();
    const defaultRoutes = require('./routes/default');
    const sequelize = require('./util/database');
    const models = require("./models");  // add your models folder created (Index.js)

    app.use(bodyParser.json());

    app.use(defaultRoutes);

    // Add models.sequelize script

    models.sequelize.sync({ force: true }).then(result => {
        console.log(result);
        app.listen(3000);
    }).catch(err => {
        console.log(err);
    });

`

4. Then run your code -> npm start to get your table created. Thank you.

I think the reason your code won't work is because you don't have something imported from the 'models' folder. Max has in the admin.js file from 'controllers' folder this import: const Product = require('../models/product'); and this way he linked the models folder to the rest of the app and thus allowing Sequelize to find his configuration for the model defined in the 'models' folder.

If you try to move all the code from user.js into app.js or index.js and try syncing then, you will see that will work.

In index.js

Import the models.

eg:-

const Product = require('./models/product');
const User = require('./models/user');

after:-

const sequelize = require('./util/database');

Code will look something like this:-

const sequelize = require('./util/database');
const Product = require('./models/product');
const User = require('./models/user');

Make sure that you are importing and using that Model somewhere in the code. This could be in index/app.js, or any controller.

If the model is defined but not imported somewhere else, the table will not be created.

const sequelize = require('./util/database');
const Order = require('./models/order');
const Customer = require('./models/customer');

I was also following Maximilian's Udemy Course, what worked for me is that i created a post request (even though the sync didn't create table), and when i had the logic of creating a entry in one of the post routes and i started the node server, it automatically created the table.

Make sure the code is imported in some way or connected to the main application through other files.

Eg if a model is imported in controller that controller is then imported in routes and that routes is imported in app.js, then also in that way it will work...