cli icon indicating copy to clipboard operation
cli copied to clipboard

Sequelize error message gives no centext

Open owujib opened this issue 1 year ago • 0 comments

I am running sequelize cli and this is the error I get for any command being run

sequelize-cli db:seed:all

Sequelize CLI [Node: 20.17.0, CLI: 6.6.2, ORM: 6.37.3]

Loaded configuration file "server/config/config.js".
Using environment "development".

ERROR: 

My config file:

const { config } = require('dotenv');
const path = require('path');
config({ path: path.resolve('../../.env') });

const DBConfig = {
  development: {
    username: process.env.DEV_DB_USERNAME,
    password: process.env.DEV_DB_PASSWORD,
    database: process.env.DEV_DB_DATABASE,
    port: process.env.DEV_DB_PORT,
    host: process.env.DEV_DB_HOST,
    dialect: process.env.DEV_DB_DIALECT || 'mysql',
    use_env_variable: process.env.DEV_DB_DATABASE_URL,
  },
  test: {
    username: 'root',
    password: '',
    database: 'database_test',
    port: '',
    host: '127.0.0.1',
    dialect: 'mysql',
    use_env_variable: process.env.DATABASE_URL,
  },

  production: {
    username: process.env.DB_USERNAME,
    password: process.env.DB_PASSWORD,
    database: process.env.DB_DATABASE,
    host: process.env.DB_HOST,
    dialect: process.env.DB_DIALECT || 'mysql',
    port: process.env.DB_PORT,
    use_env_variable: process.env.DB_DATABASE_URL,
  },
};

module.exports = DBConfig;

My .sequelizerc file:


const path = require('path');

module.exports = {
  config: path.resolve('server', 'config', 'config.js'),
  'models-path': path.resolve('server', 'models'),
  'seeders-path': path.resolve('server', 'database', 'seeders'),
  'migrations-path': path.resolve('server', 'database', 'migrations'),
};

Please I need help with this

owujib avatar Sep 04 '24 15:09 owujib