1
  1. C:\Users\lenovo\Desktop\Yoobou\Yoobou>sequelize db:migrate

    Sequelize CLI [Node: 14.15.1, CLI: 6.2.0, ORM: 6.3.5]

    Loaded configuration file "config\config.json". Using environment "development". == 20201207141344-create-producteurs: migrating =======

    ERROR: Cannot find module 'sequelize/types' Require stack:

    • C:\Users\lenovo\Desktop\Yoobou\Yoobou\migrations\20201207141344-create-producteurs.js
    • C:\Users\lenovo\AppData\Roaming\npm\node_modules\sequelize-cli\node_modules\umzug\lib\migration.js
    • C:\Users\lenovo\AppData\Roaming\npm\node_modules\sequelize-cli\node_modules\umzug\lib\index.js
    • C:\Users\lenovo\AppData\Roaming\npm\node_modules\sequelize-cli\lib\core\migrator.js
    • C:\Users\lenovo\AppData\Roaming\npm\node_modules\sequelize-cli\lib\commands\migrate.js
    • C:\Users\lenovo\AppData\Roaming\npm\node_modules\sequelize-cli\lib\sequelize

    //MIGRATION 20201207141344-create-producteurs.js

    'use strict'; const { UniqueConstraintError } = require('sequelize/types');

    module.exports = { up: async (queryInterface, Sequelize) => { await queryInterface.createTable('PRODUCTEURS', { id: { allowNull: false, autoIncrement: true, primaryKey: true, type: Sequelize.INTEGER, },

      first_name: {
        allowNull: false,
        type: Sequelize.STRING,
        unique: true,
      },
      last_name: {
        allowNull: false,
        type: Sequelize.STRING,
      },
      email: {
        allowNull: false,
        type: Sequelize.STRING,
        Unique: true,
      },
      password: {
        allowNull: false,
        type: Sequelize.STRING,
      },
      avatar: {
        allowNull: false,
        type: Sequelize.STRING,
      },
      createdAt: {
        allowNull: false,
        type: Sequelize.DATE,
      },
      updatedAt: {
        allowNull: false,
        type: Sequelize.DATE,
      },
    });   },   down: async (queryInterface, Sequelize) => {
    await queryInterface.dropTable('PRODUCTEURS');   }, };
    // ASSOCIATION MODELS  'use strict'; const { Model } = require('sequelize'); module.exports = (sequelize, DataTypes) => {  
    

    class ADMINISTRATEUR extends Model { /** * Helper method for defining associations. * This method is not a part of Sequelize lifecycle. * The models/index file will call this method automatically. / associate(models) { // define association here models.ADMINISTRATEUR.hasMany(models.CLIENTS); models.ADMINISTRATEUR.hasMany(models.PRODUITS); models.ADMINISTRATEUR.hasMany(models.ADRESSE_CLIENTS); models.ADMINISTRATEUR.hasMany(models.CATEGORY_PRODUITS); models.ADMINISTRATEUR.hasMany(models.COMMANDES); models.ADMINISTRATEUR.hasMany(models.PRODUCTEURS); models.ADMINISTRATEUR.hasMany(models.AVIS); } } ADMINISTRATEUR.init( { first_name: DataTypes.STRING, last_name: DataTypes.STRING, email: DataTypes.STRING, password: DataTypes.STRING, avatar: DataTypes.STRING, }, { sequelize, modelName: 'ADMINISTRATEUR', } ); return ADMINISTRATEUR; }; 'use strict'; const { Model } = require('sequelize'); module.exports = (sequelize, DataTypes) => { class PRODUCTEURS extends Model { /* * Helper method for defining associations. * This method is not a part of Sequelize lifecycle. * The models/index file will call this method automatically. */ static associate(models) { // define association here models.PRODUCTEURS.belongsTo(models.ADMINISTRATEUR , { foreignKey: { allowNull: false } }); models.PRODUCTEURS.hasMany(models.CLIENTS); models.PRODUCTEURS.hasMany(models.PRODUITS); models.PRODUCTEURS.hasMany(models.ADRESSE_CLIENTS); models.PRODUCTEURS.hasMany(models.CATEGORY_PRODUITS); models.PRODUCTEURS.hasMany(models.COMMANDES); } }; PRODUCTEURS.init({ first_name: DataTypes.STRING, last_name: DataTypes.STRING, email: DataTypes.STRING, password: DataTypes.STRING, avatar: DataTypes.STRING }, { sequelize, modelName: 'PRODUCTEURS', }); return PRODUCTEURS; };

2
  • can you show 20201207141344-create-producteurs.js? Commented Dec 8, 2020 at 18:26
  • @Anatoly I put it back in the question Commented Dec 8, 2020 at 18:58

1 Answer 1

0

I finally found the answer I had to put the variable "const {UniqueConstraintError} = require ('sequelize / types')" in comment and retype sequelize db: migrate

Sign up to request clarification or add additional context in comments.

1 Comment

what? can you explain that a little bit more

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.