我不知道為什么與 Sequelize 的關聯對我不起作用。我嘗試了幾個函數,但我無法輸入 N:M 的語法。我嘗試了幾種方法,但沒有一種對我有用。如果有人可以幫助我,謝謝。這些是我的表格和我的陳述。用戶.js'use strict'const sequelize = require('sequelize')const db = require('../database/database')const modelUser = db.define('usuarios', { idusuario: { primaryKey: true, type: sequelize.INTEGER }, username: { type: sequelize.STRING }, password: { type: sequelize.STRING }, email: { type: sequelize.STRING }, victorias: { type: sequelize.INTEGER }, muertes: { type: sequelize.INTEGER }, admin: { type: sequelize.INTEGER }}, { timestamps: false})module.exports = modelUser標題.js'use strict'const sequelize = require('sequelize')const db = require('../database/database')const modelTitle = db.define('titulos', { idtitulo: { primaryKey: true, type: sequelize.INTEGER }, titulo: { type: sequelize.STRING }}, { timestamps: false})module.exports = modelTitletitles_users.js'use strict'const sequelize = require('sequelize')const db = require('../database/database')const modelTitle = db.define('titulos', { fx_idtitulo: { type: sequelize.INTEGER }, fx_idusuario: { type: sequelize.INTEGER }}, { timestamps: false})module.exports = modelTitle控制器.jsconst TitlesUsers = require('../models/titles_users')const Users = require('../models/user')const Titles = require('../models/title') TitlesUsers.belongsTo(Users, {foreignKey: 'fx_idusuario', sourceKey: 'idusuario'}); TitlesUsers.belongsTo(Titles, {foreignKey: 'fx_idtitulo', sourceKey: 'idtitulo'});const users = await Users.findOne({ include: [{model:Titles}], where: {idusuario:req.user} })
續集關聯 N:M
鳳凰求蠱
2021-08-20 17:56:22