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

2022-01-19 00:00:00 node.js mysql sequelize.js

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

I started to learn how to build Rest API using Nodejs,Expressjs,Sequelize and MySQL using Mysqlworkbench. My Problem: After I start the server, the table is not created by Sequelize and no table in Mysqlworkbench also. Just this message appeared below... Thanks for any guide or help in advance:-

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 模型位于单独的文件中，您需要使用 import 方法导入它在 sequelize 实例上可用，如下所示

since your product model is in a separate file you are required to import it using the import method available on sequelize instance as follows

模型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;

参考续集导入

项目演示

相关文章