node.js - 可以使用 Sequelize 连接到新数据库吗？

Question

在设计一个简单的 node.js 项目时，我尝试使用以下配置参数使用 Sequelize 连接到 mysql 服务器:

{ dbname: users
  username: jimmy
  password: users
  params:
    host: localhost
    port: 3306
    dialect: mysql }

虽然“用户”数据库还不存在。
我收到服务器错误:

InternalServerError: {"name":"SequelizeConnectionError","parent":{"code":"ER_BAD_DB_ERROR","errno":1049,"sqlState":"42000","sqlMessage":"Unknown database 'users'"},"original":{"code":"ER_BAD_DB_ERROR","errno":1049,"sqlState":"42000","sqlMessage":"Unknown database 'users'"}}

但是 Sequelize 文档:Manual | Sequelize表明 Sequelize 可以连接到一个新的数据库。拜托，Sequelize如何用于连接到新的(不存在的)数据库？

Answer 1

您应该阅读 documentation再次仔细(因为措辞确实令人困惑!)。

New databases versus existing databases

If you are starting a project from scratch, and your database does not exist yet, Sequelizecan be used since the beginning in order to automate the creation ofevery table in your database.

Also, if you want to use Sequelize to connect to a database that isalready filled with tables and data, that works as well! Sequelize hasgot you covered in both cases.

它只会连接到一个现有的数据库，它可以通过创建表来帮助您，如果它们还不存在，但数据库必须存在以便 sequelize 与其连接。

在这个问题之后，我写了this PR更新文档以减少混淆。希望对您有所帮助!