我有一个我正在构建的节点后端,我有两个我正在使用sequelize构建的模型。用户模型和朋友模型。我希望在朋友模型中有两个字段(requester、requester),它们引用了用户模型中的两个不同的用户。
我现在在postgres shell中设置它的方法是,只有一个对firends_userId用户模型的引用。我想把它改成两个。
下面是我的代码:
型号:
const seq = require('sequelize');
const { postgres } = require('../../index');
const { user } = require('./User')
const friend = postgres.define(
"friend",
{
id: {
type: seq.INTEGER,
primaryKey: true,
autoIncrement: true
},
blocked: {
type: seq.BOOLEAN,
default: false,
null: false
},
favorite: {
type: seq.BOOLEAN,
default: false,
null: false
},
},{
createdAt: seq.DATE,
updatedAt: seq.DATE,
},
);
postgres.sync()
.then(() => {
console.log("friend table is synced")
})
.catch((error) => {
console.log("caught error with friend: " + error)
})
user.hasMany(friend, {as: 'friender', foreignkey: 'frienderId'});
user.hasMany(friend, {as: 'friended', foreignkey: 'friendedId'});
module.exports.friend = friend;和
const seq = require('sequelize');
const { postgres } = require('../../index');
const user = postgres.define(
"user",
{
id: {
type: seq.INTEGER,
primaryKey: true,
autoIncrement: true
},
username: {
type: seq.STRING,
unique: true,
null: false,
require: true,
validate: {
isAlphanumeric: true,
allowNull: false,
len: [8,16],
}
},
email: {
type: seq.STRING,
unique: true,
null: false,
require: true,
validate: {
isEmail: true,
allowNull: false,
}
},
password: {
type: seq.STRING,
null: false,
require: true,
validate: {
allowNull: false,
len: [8, 18],
}
},
first_name: {
type: seq.STRING,
null: false,
require: true,
validate: {
allowNull: false,
isAlpha: true,
}
},
last_name: {
type: seq.STRING,
null: false,
require: true,
validate: {
allowNull: false,
isAlpha: true,
}
}
},{
createdAt: seq.DATE,
updatedAt: seq.DATE,
},
);
postgres.sync()
.then(() => {
console.log("friend table is synced")
})
.catch((error) => {
console.log("caught error with friend: " + error)
})
module.exports.user = user;这是postgres shell中的当前表
splitter=# \d+ friends;
Table "public.friends"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
----------+--------------------------+-----------+----------+-------------------------------------+---------+--------------+-------------
id | integer | | not null | nextval('friends_id_seq'::regclass) | plain | |
blocked | boolean | | | | plain | |
favorite | boolean | | | | plain | |
DATE | timestamp with time zone | | not null | | plain | |
userId | integer | | | | plain | |
Indexes:
"friends_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
"friends_userId_fkey" FOREIGN KEY ("userId") REFERENCES users(id) ON UPDATE CASCADE ON DELETE SET NULL
splitter=# 发布于 2019-07-27 01:23:31
可以通过为多个列指定primaryKey: true来在Sequelize模型中编写复合主键,但是Sequelize目前不支持复合主键,因此没有办法这样做。
参见https://github.com/sequelize/sequelize/issues/311 (关于组合外键的讨论,这在squelize中是不可能的,这直接意味着组合主键也是不可能的)。
对于有多个外键指向一个表的情况,可以使用belongsTo方法。
有关更多详细信息,请参阅以下内容:
Two foreign Key of same table in one table in sequelize
文档:
https://sequelize.readthedocs.io/en/latest/docs/associations/#belongsto
https://stackoverflow.com/questions/57224500
复制相似问题