我的sequelize-auto命令执行抛出错误“请手动安装繁琐的软件包”

Question

我的SQL server数据库中有太多的表，而我的应用程序使用的是node.js的sequelize对象模型。我发现有一种方法可以搭建我的数据库模型，那就是sequelize-auto命令。

所以我创建了一个命令并运行它。但是它抛出了一个错误！

下面是我的sequelize-auto命令：

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

但是当我运行这个命令时，它抛出了这个错误：

    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

我安装并使用了繁琐的软件包。

以下是我的package.json内容：

{
  "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"
  }
}

你的想法是什么？

Answer 1

最后我找到了解决方案。

我应该在相同的路径下安装繁琐的和mssql包。

我在命令下运行，我的问题就解决了：

npm install -g mssql tedious

我又找了一遍，最后找到了整体的解决方案。一个GUI桌面应用程序导出序列化模型从数据库中自动。单击here查看它将执行的操作。我用过它，它对我很有效。