我已經創建了 15 個模型，并且只隨機獲取了幾個表中的每一列。這可能是什么原因造成的？誰能幫我？
PS：我只包含了我認為與我的問題相關的代碼部分
應用程式.js：
// imports
const express = require('express');
const bodyParser = require('body-parser');
const app = express()
const port = 5000
//Body Parser
app.use(bodyParser.urlencoded({ extended: true }));
//Database connection
const db = require("./models");
db.sequelize.sync({ force: true }).then(() => {
console.log("Drop and re-sync db.");
});
//listen on port 5000
app.listen(port, () => console.info('Ready To Proceed'))
country.js（僅獲取 id、createdAt 和 updatedAt 等默認列）
module.exports = (sequelize, Sequelize) => {
const Country = sequelize.define("country", {
name: {
type: Sequelize.STRING,
unique: true
},
flag: {
type: Sequelize.STRING
},
countryCode: {
type: Sequelize.STRING
}
});
return Country;
};
購物車.js（獲取我定義的所有列）
module.exports = (sequelize, Sequelize) => {
var User = sequelize.define('user');
var Product = sequelize.define('product');
const Cart = sequelize.define("cart", {
quantity: {
type: Sequelize.STRING
}
});
Cart.belongsTo(User);
Cart.belongsTo(Product);
return Cart;
};
index.js（同步所有模型）
const dbConfig = require("../config/db.config");
const Sequelize = require("sequelize");
const sequelize = new Sequelize(dbConfig.DB, dbConfig.USER, dbConfig.PASSWORD, {
host: dbConfig.HOST,
dialect: dbConfig.dialect,
port: dbConfig.PORT,
operatorsAliases: false,
pool: {
max: dbConfig.pool.max,
min: dbConfig.pool.min,
acquire: dbConfig.pool.acquire,
idle: dbConfig.pool.idle
}
});
const db = {};
db.Sequelize = Sequelize;
db.sequelize = sequelize;
db.country = require("./country.model")(sequelize, Sequelize);
db.cart = require("./cart.model")(sequelize, Sequelize);
module.exports = db;
db.config.js：
module.exports = {
HOST: "localhost",
USER: "<<USER>>",
PASSWORD: "<<Password>>",
DB: "redhuntdb",
dialect: "mysql",
PORT: 3307(My db port is 3307),
pool: {
max: 15,
min: 0,
acquire: 30000,
idle: 10000
}
};
uj5u.com熱心網友回復：
如果有人遇到這個問題并遇到同樣的問題，我就知道我做錯了什么。sequelize.define()每次使用它時都會創建一個新表。我在不知不覺中使用sequelize.define()在另一個模型中創建模型的物件，這是不對的。
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/334828.html
標籤：mysql 节点.js 表达 sequelize.js