My sequelize-auto command execution throws error "Please install tedious package manually"

Question

I have too many tables in my SQL server database and my application uses sequelize ORM of node.js. I find out that there is a way to scaffold my database models and it is sequelize-auto command.

So I created a command and run it. but it throws an error!

here is my sequelize-auto command:

sequelize-auto -h my server_ip_address -d database_name -u username -x mypassword  --dialect mssql -c ./api/config/onlinestore.json -o ./api/models/newScafolded

but when I run this command it throws this error:

    C:\Users\AMoha\AppData\Roaming\npm\node_modules\sequelize-auto\node_modules\sequelize\lib\dialects\mssql\connection-manager.js:21
        throw new Error('Please install tedious package manually');
        ^

    Error: Please install tedious package manually
        at new ConnectionManager (C:\Users\AMoha\AppData\Roaming\npm\node_modules\sequelize-auto\node_modules\sequelize\lib\dialects\mssql\connection-manager.js:21:13)
        at new MssqlDialect (C:\Users\AMoha\AppData\Roaming\npm\node_modules\sequelize-auto\node_modules\sequelize\lib\dialects\mssql\index.js:12:28)
        at new Sequelize (C:\Users\AMoha\AppData\Roaming\npm\node_modules\sequelize-auto\node_modules\sequelize\lib\sequelize.js:233:18)
        at new AutoSequelize (C:\Users\AMoha\AppData\Roaming\npm\node_modules\sequelize-auto\lib\index.js:19:22)
        at Object.<anonymous> (C:\Users\AMoha\AppData\Roaming\npm\node_modules\sequelize-auto\bin\sequelize-auto:90:12)
        at Module._compile (internal/modules/cjs/loader.js:945:30)
        at Object.Module._extensions..js (internal/modules/cjs/loader.js:962:10)
        at Module.load (internal/modules/cjs/loader.js:798:32)
        at Function.Module._load (internal/modules/cjs/loader.js:711:12)
        at Function.Module.runMain (internal/modules/cjs/loader.js:1014:10)
        at internal/main/run_main_module.js:17:11

I installed and used tedious package.

here is my package.json content:

{
  "name": "onlinestore",
  "version": "0.0.1",
  "private": true,
  "scripts": {
    "dev": "babel-watch ./bin/www",
    "start": "node ./bin/www"
  },
  "dependencies": {
    "body-parser": "^1.19.0",
    "braces": "^3.0.2",
    "constantinople": "^4.0.1",
    "cookie-parser": "~1.3.3",
    "cors": "^2.8.5",
    "custom-env": "^1.0.0",
    "debug": "^4.1.0",
    "express": "^4.16.4",
    "express-jwt": "^3.4.0",
    "jade": "~1.9.1",
    "jsonwebtoken": "^5.7.0",
    "lodash": "^4.17.15",
    "mongoose": "^5.8.7",
    "morgan": "^1.9.1",
    "passport": "^0.2.2",
    "passport-local": "^1.0.0",
    "sequelize": "^5.21.5",
    "serve-favicon": "^2.5.0",
    "tedious": "^6.7.0",
    "uglify-js": "^3.4.9"
  },
  "devDependencies": {
    "@babel/cli": "^7.4.4",
    "@babel/core": "^7.4.4",
    "@babel/preset-env": "^7.4.4",
    "babel-watch": "^7.0.0",
    "gulp": "^4.0.0",
    "gulp-concat": "^2.6.0",
    "gulp-ng-annotate": "^1.1.0",
    "gulp-ng-html2js": "^0.2.3",
    "gulp-sourcemaps": "^1.5.2",
    "gulp-uglify": "^1.2.0",
    "gulp-watch": "^5.0.1"
  }
}

What's your idea?

Answer 1

Finally I found the solution.

I should install tedious and mssql package in the same path.

I run below command and my problem solved:

npm install -g mssql tedious

I searched again and finally I found overall solution. A GUI Desktop App for export sequelize models from database automatically. click here to see what it will do. I used it and it worked for me.