sequelize does not creating a table shows this result : "Executing (default): SELECT 1+1 AS result"

user_9056324 0
Viewed 6026

I try to create a table using sequelize it goes fine with no error but instead of creating a table is show this message as a result

Executing (default): SELECT 1+1 AS result

here my config file:

const Sequelize = require('sequelize');

const sequelize = new Sequelize('*******', '******', '*******', {
    dialect: 'mysql',
    host: 'localhost',
});

module.exports = sequelize;

here my user.js file:

const Sequelize = require('sequelize');

const sequelize = require('../db/mysql/config');

const User = sequelize.define('user', {
    id: {
        type: Sequelize.INREGER,
        autoIncrement: true,
        allowNull: false,
        primaryKey: true
    },
    userName: {
        type: Sequelize.STRING,
        allowNull: false
    },
    email: {
        type: Sequelize.STRING,
        allowNull: false
    },
    password: {
        type: Sequelize.STRING,
        allowNull: false
    }

});


module.exports = User;

and this is my test.js file i run it with node commend:

const sequelize = require('./db/mysql/config')

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

if I copy user.js code inside config file it works fine

sequelize.js mysql javascript
7 Answers

import your user.js model in config.js a example:-

     const User = require('enter your path here for user.js')

     User.sync();
user_103336640

Importing user.js file to test.js solved the issue for me.

You need to execute your models somehow to create tables. You can do it by requiring your model files in a program execution flow.

user_70915740

Because you are not exporting the Tables you have created.

  • In your file you have created user.js, so you have to export it and make sure you are hitting(synchronizing) that table, either you can sync a particular table, or you can sync all the tables(models) at once.

How you can sync a Particular table (model)?

  • In your root file(which starts the application), you import the user.js

import user.js from ('your path to the file')

  • Now write modelName.sync();

How you can hit(sync) all the tables at once?

  1. After you created all the models, you have to export it
  2. Then in your root file, write the following

sequelize.sync()

user_130094850

My solution process : => Check database OWNER before

  1. Save all models files in /app/models
  2. Model example :
const {DataTypes, Model} = require('sequelize');

// on importe la connexion
const sequelize = require('./../database');

class User extends Model {
}

User.init({
        username: {
            type: DataTypes.STRING,
            allowNull: false
        },
        email: {
            type: DataTypes.STRING,
            allowNull: false,
            unique: true
        },
        password: {
            type: DataTypes.STRING,
            allowNull: false
        },
        roles: {
            type: DataTypes.JSON,
            defaultValue: {"roles":[{
                    "role_name":"ROLE_USER",
                }
            ]},
        },
        status: {
            type: DataTypes.BOOLEAN,
            defaultValue: false
        },
        birthday: {
            type: DataTypes.DATE,
            allowNull: false
        },
        filename: DataTypes.STRING,
        activation_token: DataTypes.STRING,

    },
    {
        underscored: true,
        sequelize, //connexion a l'instance
        timestamps: true,
        tableName: 'user'
    }
);

User.sync({ alter: true });
console.log("==> The table for the User model was just (re)created!");

module.exports = User;
  1. Create dedicated file for database connection in /app/database.js
const {Sequelize} = require('sequelize');

const sequelize = new Sequelize(process.env.PG_URL, {});

module.exports = sequelize;
  1. Create inside directory /app/models new file index.js
  2. Inside this file add all models required like that :
const User      = require('./user');
const Category  = require('./category');
    ...
module.exports = { User, Category };
  1. Create new file on project root like : init_models_db.js
const models = require('./app/models'); //By default load index.js inside /app/models
const sequelize = require('./app/database');

const init_BDD = async () => {
    try {
        await sequelize.authenticate();
        console.log('Connection has been established successfully.');
        const created =  sequelize.sync({force: true});

        if(created) {
            console.log("==> TABLE DONE !");
        }

    } catch (error) {
        console.error('Unable to connect to the database:', error);
    }
} 
init_BDD();
  1. Execute command : node init_models_db.js
user_139947690

once you import your model and require it into your controller, and then define your route, finishing by adding the route to the index.js or your app's entry point, the table will be created automatically, and no need to require the model directly into your entry point file meaning;

  • yourModel.js [export your model]
  • yourController.js [require your model here]
  • yourRoutes.js [require your controller]
  • index.js | app.js | main.js [require your router]
user_43669280 
const Sequelize = require('sequelize');

const sequelize = new Sequelize('*******', '******', '*******', {
    dialect: 'mysql',
    host: 'localhost',
    logging: false

});

module.exports = sequelize;

You need to add 'logging: false' which solves the problem

user_194293590

Easy fix: Go to your controller file and instantiate your object

const User = require('models/user');

As soon as you create an instance for your model the tables will be generated.

user_197792690
Related