mysql - 启动服务器后，带有sequelize的Nodejs无法在mysql workbench中创建表-6ren

mysql - 启动服务器后，带有sequelize的Nodejs无法在mysql workbench中创建表

转载作者：行者123 更新时间：2023-11-29 07:23:40

我开始学习如何使用 Nodejs、Expressjs、Sequelize 和 MySQL 构建 Rest API，使用 Mysql 工作台。我的问题: 在我启动服务器后，Sequelize 没有创建表，Mysqlworkbench 也没有表。这条消息出现在下面...感谢您提前提供任何指导或帮助:-

Sequelize {
  options:
   { dialect: 'mysql',
     dialectModulePath: null,
     host: 'localhost',
     protocol: 'tcp',
     define: {},
     query: {},
     sync: {},
     timezone: '+00:00',
     logging: [Function: bound consoleCall],
     omitNull: false,
     native: false,
     replication: false,
     ssl: undefined,
     pool: {},
     quoteIdentifiers: true,
     hooks: {},
     retry: { max: 5, match: [Array] },
     transactionType: 'DEFERRED',
     isolationLevel: null,
     databaseVersion: 0,
     typeValidation: false,
     benchmark: false,
     operatorsAliases: false },
  config:
   { database: 'node',
     username: 'root',
     password: '1234567890',
     host: 'localhost',
     port: 3306,
     pool: {},
     protocol: 'tcp',
     native: false,
     ssl: undefined,
     replication: false,
     dialectModulePath: null,
     keepDefaultTimezone: undefined,
     dialectOptions: undefined },
  dialect:
   MysqlDialect {
     sequelize: [Circular],
     connectionManager:
      ConnectionManager {
        sequelize: [Circular],
        config: [Object],
        dialect: [Circular],
        versionPromise: null,
        dialectName: 'mysql',
        pool: [Object],
        lib: [Object] },
     QueryGenerator:
      { dialect: 'mysql',
        OperatorMap: [Object],
        createSchema: [Function: createSchema],
        showSchemasQuery: [Function: showSchemasQuery],
        versionQuery: [Function: versionQuery],
        createTableQuery: [Function: createTableQuery],
        showTablesQuery: [Function: showTablesQuery],
        addColumnQuery: [Function: addColumnQuery],
        removeColumnQuery: [Function: removeColumnQuery],
        changeColumnQuery: [Function: changeColumnQuery],
        renameColumnQuery: [Function: renameColumnQuery],
        handleSequelizeMethod: [Function: handleSequelizeMethod],
        _toJSONValue: [Function: _toJSONValue],
        upsertQuery: [Function: upsertQuery],
        deleteQuery: [Function: deleteQuery],
        showIndexesQuery: [Function: showIndexesQuery],
        showConstraintsQuery: [Function: showConstraintsQuery],
        removeIndexQuery: [Function: removeIndexQuery],
        attributeToSQL: [Function: attributeToSQL],
        attributesToSQL: [Function: attributesToSQL],
        quoteIdentifier: [Function: quoteIdentifier],
        _checkValidJsonStatement: [Function: _checkValidJsonStatement],
        jsonPathExtractionQuery: [Function: jsonPathExtractionQuery],
        _getForeignKeysQueryFields: [Function: _getForeignKeysQueryFields],
        getForeignKeysQuery: [Function: getForeignKeysQuery],
        getForeignKeyQuery: [Function: getForeignKeyQuery],
        dropForeignKeyQuery: [Function: dropForeignKeyQuery],
        _templateSettings: [Object],
        options: [Object],
        extractTableDetails: [Function: extractTableDetails],
        addSchema: [Function: addSchema],
        dropSchema: [Function: dropSchema],
        describeTableQuery: [Function: describeTableQuery],
        dropTableQuery: [Function: dropTableQuery],
        renameTableQuery: [Function: renameTableQuery],
        insertQuery: [Function: insertQuery],
        bulkInsertQuery: [Function: bulkInsertQuery],
        updateQuery: [Function: updateQuery],
        arithmeticQuery: [Function: arithmeticQuery],
        nameIndexes: [Function: nameIndexes],
        addIndexQuery: [Function: addIndexQuery],
        addConstraintQuery: [Function: addConstraintQuery],
        getConstraintSnippet: [Function: getConstraintSnippet],
        removeConstraintQuery: [Function: removeConstraintQuery],
        quoteTable: [Function: quoteTable],
        quote: [Function: quote],
        quoteIdentifiers: [Function: quoteIdentifiers],
        escape: [Function: escape],
        selectQuery: [Function: selectQuery],
        escapeAttributes: [Function: escapeAttributes],
        generateInclude: [Function: generateInclude],
        generateJoin: [Function: generateJoin],
        generateThroughJoin: [Function: generateThroughJoin],
        _generateSubQueryFilter: [Function: _generateSubQueryFilter],
        _getRequiredClosure: [Function: _getRequiredClosure],
        getQueryOrders: [Function: getQueryOrders],
        selectFromTableFragment: [Function: selectFromTableFragment],
        setAutocommitQuery: [Function: setAutocommitQuery],
        setIsolationLevelQuery: [Function: setIsolationLevelQuery],
        generateTransactionId: [Function: generateTransactionId],
        startTransactionQuery: [Function: startTransactionQuery],
        deferConstraintsQuery: [Function: deferConstraintsQuery],
        setConstraintQuery: [Function: setConstraintQuery],
        setDeferredQuery: [Function: setDeferredQuery],
        setImmediateQuery: [Function: setImmediateQuery],
        commitTransactionQuery: [Function: commitTransactionQuery],
        rollbackTransactionQuery: [Function: rollbackTransactionQuery],
        addLimitAndOffset: [Function: addLimitAndOffset],
        whereQuery: [Function: whereQuery],
        whereItemsQuery: [Function: whereItemsQuery],
        OperatorsAliasMap: false,
        setOperatorsAliases: [Function: setOperatorsAliases],
        whereItemQuery: [Function: whereItemQuery],
        _findField: [Function: _findField],
        _replaceAliases: [Function: _replaceAliases],
        _whereGroupBind: [Function: _whereGroupBind],
        _whereBind: [Function: _whereBind],
        _whereJSON: [Function: _whereJSON],
        _traverseJSON: [Function: _traverseJSON],
        _castKey: [Function: _castKey],
        _getJsonCast: [Function: _getJsonCast],
        _joinKeyValue: [Function: _joinKeyValue],
        _getSafeKey: [Function: _getSafeKey],
        _prefixKey: [Function: _prefixKey],
        _whereParseSingleValueObject: [Function: _whereParseSingleValueObject],
        getWhereConditions: [Function: getWhereConditions],
        parseConditionObject: [Function: parseConditionObject],
        isIdentifierQuoted: [Function: isIdentifierQuoted],
        booleanValue: [Function: booleanValue],
        _dialect: [Circular],
        sequelize: [Circular],
        typeValidation: undefined } },
  queryInterface:
   QueryInterface {
     sequelize: [Circular],
     QueryGenerator:
      { dialect: 'mysql',
        OperatorMap: [Object],
        createSchema: [Function: createSchema],
        showSchemasQuery: [Function: showSchemasQuery],
        versionQuery: [Function: versionQuery],
        createTableQuery: [Function: createTableQuery],
        showTablesQuery: [Function: showTablesQuery],
        addColumnQuery: [Function: addColumnQuery],
        removeColumnQuery: [Function: removeColumnQuery],
        changeColumnQuery: [Function: changeColumnQuery],
        renameColumnQuery: [Function: renameColumnQuery],
        handleSequelizeMethod: [Function: handleSequelizeMethod],
        _toJSONValue: [Function: _toJSONValue],
        upsertQuery: [Function: upsertQuery],
        deleteQuery: [Function: deleteQuery],
        showIndexesQuery: [Function: showIndexesQuery],
        showConstraintsQuery: [Function: showConstraintsQuery],
        removeIndexQuery: [Function: removeIndexQuery],
        attributeToSQL: [Function: attributeToSQL],
        attributesToSQL: [Function: attributesToSQL],
        quoteIdentifier: [Function: quoteIdentifier],
        _checkValidJsonStatement: [Function: _checkValidJsonStatement],
        jsonPathExtractionQuery: [Function: jsonPathExtractionQuery],
        _getForeignKeysQueryFields: [Function: _getForeignKeysQueryFields],
        getForeignKeysQuery: [Function: getForeignKeysQuery],
        getForeignKeyQuery: [Function: getForeignKeyQuery],
        dropForeignKeyQuery: [Function: dropForeignKeyQuery],
        _templateSettings: [Object],
        options: [Object],
        extractTableDetails: [Function: extractTableDetails],
        addSchema: [Function: addSchema],
        dropSchema: [Function: dropSchema],
        describeTableQuery: [Function: describeTableQuery],
        dropTableQuery: [Function: dropTableQuery],
        renameTableQuery: [Function: renameTableQuery],
        insertQuery: [Function: insertQuery],
        bulkInsertQuery: [Function: bulkInsertQuery],
        updateQuery: [Function: updateQuery],
        arithmeticQuery: [Function: arithmeticQuery],
        nameIndexes: [Function: nameIndexes],
        addIndexQuery: [Function: addIndexQuery],
        addConstraintQuery: [Function: addConstraintQuery],
        getConstraintSnippet: [Function: getConstraintSnippet],
        removeConstraintQuery: [Function: removeConstraintQuery],
        quoteTable: [Function: quoteTable],
        quote: [Function: quote],
        quoteIdentifiers: [Function: quoteIdentifiers],
        escape: [Function: escape],
        selectQuery: [Function: selectQuery],
        escapeAttributes: [Function: escapeAttributes],
        generateInclude: [Function: generateInclude],
        generateJoin: [Function: generateJoin],
        generateThroughJoin: [Function: generateThroughJoin],
        _generateSubQueryFilter: [Function: _generateSubQueryFilter],
        _getRequiredClosure: [Function: _getRequiredClosure],
        getQueryOrders: [Function: getQueryOrders],
        selectFromTableFragment: [Function: selectFromTableFragment],
        setAutocommitQuery: [Function: setAutocommitQuery],
        setIsolationLevelQuery: [Function: setIsolationLevelQuery],
        generateTransactionId: [Function: generateTransactionId],
        startTransactionQuery: [Function: startTransactionQuery],
        deferConstraintsQuery: [Function: deferConstraintsQuery],
        setConstraintQuery: [Function: setConstraintQuery],
        setDeferredQuery: [Function: setDeferredQuery],
        setImmediateQuery: [Function: setImmediateQuery],
        commitTransactionQuery: [Function: commitTransactionQuery],
        rollbackTransactionQuery: [Function: rollbackTransactionQuery],
        addLimitAndOffset: [Function: addLimitAndOffset],
        whereQuery: [Function: whereQuery],
        whereItemsQuery: [Function: whereItemsQuery],
        OperatorsAliasMap: false,
        setOperatorsAliases: [Function: setOperatorsAliases],
        whereItemQuery: [Function: whereItemQuery],
        _findField: [Function: _findField],
        _replaceAliases: [Function: _replaceAliases],
        _whereGroupBind: [Function: _whereGroupBind],
        _whereBind: [Function: _whereBind],
        _whereJSON: [Function: _whereJSON],
        _traverseJSON: [Function: _traverseJSON],
        _castKey: [Function: _castKey],
        _getJsonCast: [Function: _getJsonCast],
        _joinKeyValue: [Function: _joinKeyValue],
        _getSafeKey: [Function: _getSafeKey],
        _prefixKey: [Function: _prefixKey],
        _whereParseSingleValueObject: [Function: _whereParseSingleValueObject],
        getWhereConditions: [Function: getWhereConditions],
        parseConditionObject: [Function: parseConditionObject],
        isIdentifierQuoted: [Function: isIdentifierQuoted],
        booleanValue: [Function: booleanValue],
        _dialect: [Object],
        sequelize: [Circular],
        typeValidation: undefined } },
  models: {},
  modelManager: ModelManager { models: [], sequelize: [Circular] },
  connectionManager:
   ConnectionManager {
     sequelize: [Circular],
     config:
      { database: 'node',
        username: 'root',
        password: '1234567890',
        host: 'localhost',
        port: undefined,
        pool: [Object],
        protocol: 'tcp',
        native: false,
        ssl: undefined,
        replication: false,
        dialectModulePath: null,
        keepDefaultTimezone: undefined,
        dialectOptions: undefined },
     dialect:
      MysqlDialect {
        sequelize: [Circular],
        connectionManager: [Circular],
        QueryGenerator: [Object] },
     versionPromise: null,
     dialectName: 'mysql',
     pool:
      Pool {
        domain: null,
        _events: {},
        _eventsCount: 0,
        _maxListeners: undefined,
        _config: [Object],
        _Promise: [Object],
        _factory: [Object],
        _draining: false,
        _started: false,
        _waitingClientsQueue: [Object],
        _factoryCreateOperations: Set {},
        _factoryDestroyOperations: Set {},
        _availableObjects: [Object],
        _testOnBorrowResources: Set {},
        _testOnReturnResources: Set {},
        _validationOperations: Set {},
        _allObjects: Set {},
        _resourceLoans: Map {},
        _evictionIterator: [Object],
        _evictor: DefaultEvictor {},
        _scheduledEviction: null },
     lib:
      { createConnection: [Function],
        connect: [Function],
        Connection: [Function: Connection],
        createPool: [Function],
        createPoolCluster: [Function],
        createQuery: [Function: createQuery],
        Pool: [Function: Pool],
        createServer: [Function],
        PoolConnection: [Object],
        escape: [Function: escape],
        escapeId: [Function: escapeId],
        format: [Function: format],
        raw: [Function: raw],
        createConnectionPromise: [Getter],
        createPoolPromise: [Getter],
        createPoolClusterPromise: [Getter],
        Types: [Getter],
        Charsets: [Getter],
        CharsetToEncoding: [Getter],
        setMaxParserCache: [Function],
        clearParserCache: [Function] } },
  importCache: {},
  test:
   { _trackRunningQueries: false,
     _runningQueries: 0,
     trackRunningQueries: [Function: trackRunningQueries],
     verifyNoRunningQueries: [Function: verifyNoRunningQueries] } }

模型 product.js

const Sequelize = require('sequelize');

const sequelize = require('./dbconfig');


const Product = sequelize.define('product', {
  id: {
    type: Sequelize.INTEGER,
    autoIncrement: true,
    allowNull: false,
    primaryKey: true
  },
  title: Sequelize.STRING,
  price: {
    type: Sequelize.DOUBLE,
    allowNull: false
  },
  imageUrl: {
    type: Sequelize.STRING,
    allowNull: false
  },
  description: {
    type: Sequelize.STRING,
    allowNull: false
  }
});

module.exports = Product;

App.js

const express = require('express');
const feedroutes = require('./routes/feed');
const bodyParser = require('body-parser');
const sequelize = require('./dbconfig');


const app = express()

app.use(bodyParser.json());//application/json

app.use((req, res, next) => {
    res.setHeader('Access-Control-Allow-Origin', '*');
    res.setHeader('Access-Control-Allow-Methods', 'OPTIONS, GET, POST, PUT, PATCH, DELETE');
    res.setHeader('Access-Control-Allow-Headers', 'Content-Type, Authorization');
    next();
});

app.use('/feed',feedroutes);

sequelize.sync().then(reslut => {
    console.log(reslut);
    app.listen(8080); 

})
.catch(error => {
    console.log(error);   
});

dbconfig.js

const Sequelize = require('sequelize');

const sequelize = new Sequelize('node','root','1234567890', { 
    operatorsAliases: false ,
    dialect: 'mysql',
    host:'localhost'

});


module.exports = sequelize;

最佳答案

由于您的product 模型位于单独的文件中，因此您需要使用 sequelize 实例上可用的 import 方法导入它，如下所示

模型 product.js

module.exports = function(sequelize, Sequelize) {
    const Product = sequelize.define('product', {
        id: {
            type: Sequelize.INTEGER,
            autoIncrement: true,
            allowNull: false,
            primaryKey: true
        },
        title: Sequelize.STRING,
        price: {
            type: Sequelize.DOUBLE,
            allowNull: false
        },
        imageUrl: {
            type: Sequelize.STRING,
            allowNull: false
        },
        description: {
            type: Sequelize.STRING,
            allowNull: false
        }
    });

    module.exports = Product;
};

dbconfig.js

const Sequelize = require('sequelize');

const sequelize = new Sequelize('node','root','1234567890', { 
    operatorsAliases: false ,
    dialect: 'mysql',
    host:'localhost'

});

sequelize.import('path/to/product/model');

module.exports = sequelize;

引用sequelize import

Demo 项目

关于mysql - 启动服务器后，带有sequelize的Nodejs无法在mysql workbench中创建表，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/54957159/

文章推荐： java - StringBuilder 中的多个 StringBuilder。值得吗？

文章推荐： mysql select 在 sha1 哈希密码上返回空

文章推荐： java - 您可以在某个步骤中同时使用@Given 和@And 吗？

out-of-memory - 启动 minishift 或占用大量内存时，启动 OpenShift 集群永远不会结束
每当我运行命令以将 Virtualbox 驱动程序启动 Minishift 到操作系统主机时，它都需要一段疯狂的时间，而且它永远不会结束。有时我什至收到有关达到存储限制的错误消息。不知道是不是描述h
node.js - 使用 docker 启动 npm 启动？
您好，我正在使用 npm 运行一个基本的 React 项目，我正尝试在 docker 容器中启动它。但是我实际上无法让项目运行。我的 dockerfile 看起来像这样: FROM node:7.8.
linux - 无法从 SSH 启动 MonoGame，但可以从 GUI 启动
所以我想从我的 SSH 终端开始游戏。这真的很奇怪，当我直接从 Linux GUI 执行此操作时，它可以工作。但是当我使用 SSH 客户端进行远程连接时，它就崩溃了。似乎与我的显示驱动程序有关。 U
android - 从 WallpaperService 启动 Intent 或向 WallpaperService 启动 Intent
我有一个显示图像的动态壁纸。我在 Activity 中更改了该图像。然后我需要通知动态壁纸，以便它知道重新加载资源。 Intent 似乎是完美、简单的解决方案: Intent intent = new
java - 可以从 Eclipse (STS) 启动 Spring Boot，但不能从 CLI 启动
我有一个似乎无法解决的问题。我在 Boot Dashboard 中使用 STS 3.9.2 从 Eclipse (Oxygen) 启动 Spring Boot 应用程序没有任何问题: 但是，当我尝试从
python - 在 CMD "python"启动 Python 3.3， "py"启动 Python 2.7，我该如何更改？
全新的 Python，在我开始摆弄东西之前先设置和安装东西。我的理解是 Python 2.7 和 Python 3.3 之间存在一些显着差异/不兼容，尽管这两个版本都得到了很好的使用，所以我认为最好安
jQuery 启动
在使用了很长时间的 jQuery 之后，我有一个问题，我正在使用 jQuery 模式(样式)编写一个简单的代码， (function(window, undefined) { var jQu
Spring 启动@Configurable
我正在尝试在 spring boot 应用程序下的非 spring 托管类中配置 Autowired。我在 tomcat 服务器下部署的 Web 应用程序下成功运行了这个。但是当我想在 spring
haskell - 启动 xmonad
我对 xmonad 完全陌生，但我想开始使用它来提高我的工作效率。这是我一直在使用的指南(我使用的是 Apple OS X Snow Leopard) http://xmonad.org/tour.
Spring 启动-管理交易和多个数据源
我试图将Spring Boot指南中的Managing Transactions示例扩展到两个数据源，但是@Transaction注释似乎仅对其中一个数据源有效。在“Application.java
Conemu 启动，任务打开多个选项卡
conEmu 有没有办法默认打开多个不同的选项卡？我看到这个页面解释了如何使用 splits , 我意识到我可以按 Ctrl + T, 1, Enter，但我希望有一种方法可以自动执行此操作! "%
jquery - SignalR - 启动
我正在寻找快速而肮脏的答案。我当时脑子一片空白，盯着屏幕看了 12 个小时以上，我想我中枪了。我想做一个简单的 SignalR 应用程序作为教程。我找到了这个example ，但我不断收到票证未定义
powershell - 启动/停止特定订阅下的所有虚拟机
我正在使用 Azure Powershell cmdlet 来启动/停止 VM。 Start-AzureVM [-ServiceName] [-Name] [ ] Stop-AzureVM [-S
iis - 启动/停止iis和mssql的powershell脚本代码
我想使用Powershell脚本代码启动/停止iis和mssql 意味着当我运行ps脚本时，我想启动/停止iis和mssql 我在网上搜索了它，发现了一些代码，但按照我的要求无法正常工作码: $ii
liferay - 启动 liferay
我在 liferay 工作。我们在我们的项目中使用一个模块来创建 liferay 主题。我使用命令 ant -Ddeploy.war=true 将它部署在服务器中。 war 文件在 liferay 部
ipython - 启动 IPython
我想在已安装 Python 2.7 的 Windows XP 计算机上运行 IPython(版本 0.12)。我通过 Windows 二进制安装程序安装，但安装后 IPython 没有显示在菜单中，
docker - 启动+卷挂载后在docker容器内自动运行命令
我从创建了自己的简单图片。 FROM python:2.7.11 RUN mkdir /extra/later/ \ && mkdir /yyy 现在，我可以执行以下步骤: docker run
javascript - 启动/停止脚本以刷新页面
$(document).ready(function () { setTimeout(function() { window.location.reload(); }, 2000); // 2
javascript - OpenWeatherMap 启动
我刚刚创建了一个帐户 OpenWeatherMap 我想通过城市 ID API 调用获取当前位置的天气: http://api.openweathermap.org/data/2.5/weather?
ios - 启动 Storyboard中的图像未更新
我注意到，如果我更改 xcasset 中的图像，启动 Storyboard不会更新。例如，假设您的启动 Storyboard中有一个 UIImage View ，其中包含一个名为“logo”的蓝色图

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

mysql - 启动服务器后，带有sequelize的Nodejs无法在mysql workbench中创建表