CODEWITHSUNDEEP
javascriptmysqlsequelize.js
sinammd
sinammd

Reputation: 132

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

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

Upvotes: 4

Views: 13517

Answers (8)

studyNas
studyNas

Reputation: 31

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

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

the path should be changed

const sequelize = require('./models/user')

import user.js not db-mysql-config.js

Upvotes: 1

Izrrael Sand
Izrrael Sand

Reputation: 1

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.

Upvotes: 0

Matheus Dias
Matheus Dias

Reputation: 1

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

Upvotes: 0

Hicham Mounadi
Hicham Mounadi

Reputation: 469

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]

Upvotes: 1

florian_drupal
florian_drupal

Reputation: 157

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

Upvotes: 0

Mohammed Aliyaan
Mohammed Aliyaan

Reputation: 19

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()

Upvotes: 1

Amal
Amal

Reputation: 33

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.

Upvotes: 0

Ahmed Shafraz
Ahmed Shafraz

Reputation: 66

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

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

     User.sync();

Upvotes: 5

Related Questions