我基于库中包含的node-orm2示例项目构建了一个node express应用。我遇到了一个讨厌的“虫”,我的返回值看上去一团糟。
一个“用户”只有一个“权限”:User.hasOne('permission', db.models.permission, {required: true, autoFetch: true});
一个“公司”只有一个所有者,但是这是相反的,因此“用户”有多个“公司”。Company.hasOne('user', db.models.user, { required: true, reverse: 'companies', autoFetch: true});
function setup(db, cb) {
require('./company')(orm, db);
require('./user')(orm, db);
require('./permission')(orm, db);
return cb(null, db);
}
{
"id": 1,
"username": "l.vanbuiten",
"name": "Lex",
"surname": "van Buiten",
"age": "1992-05-13T22:00:00.000Z",
"createdAt": "2015-12-21T23:25:04.000Z",
"permission": {
"id": 1,
"username": "l.vanbuiten",
"name": "Lex",
"surname": "van Buiten",
"age": "1992-05-13T22:00:00.000Z",
"createdAt": "2015-12-21T23:25:04.000Z",
"permission_id": 1
},
"companies": []
}
交换这些设置行后,事情如我所愿:
function setup(db, cb) {
require('./permission')(orm, db);
require('./user')(orm, db);
require('./company')(orm, db);
return cb(null, db);
}
{
"id": 1,
"username": "l.vanbuiten",
"name": "Lex",
"surname": "van Buiten",
"age": "1992-05-13T22:00:00.000Z",
"createdAt": "2015-12-21T23:25:04.000Z",
"permission": {
"id": 1,
"name": "permission name"
},
"companies": [
{
"id": 1,
"name": "company name",
"description": "company description",
"createdAt": "2015-12-21T23:25:25.000Z"
}
]
}
var moment = require('moment');
module.exports = function (orm, db) {
var Company = db.define('company', {
id: {type: 'serial', key: true},
name: {type: 'text', required: true, unique: true},
description: {type: 'text', big: true},
createdAt: {type: 'date', required: true, time: true}
},
{
cache: false,
hooks: {
beforeValidation: function () {
this.createdAt = new Date();
}
},
validations: {
name: [
orm.enforce.unique("Company already exist"),
orm.enforce.ranges.length(1, undefined, "Company name cannot be empty"),
orm.enforce.ranges.length(undefined, 50, "Company name is to long")
]
},
methods: {
serialize: function () {
return {
id: this.id,
name: this.name,
description: this.description,
createdAt: this.createdAt
}
}
}
});
Company.hasOne('user', db.models.user, { required: true, reverse: 'companies', autoFetch: true});
};
订单相差这么多怎么办?
(免责声明:我node-orm2
经验不足)
在我看来,您建立关联的方式正在引起您的问题。
在第一个设置中,定义模型和关联的顺序如下:
Company
模型Company
,并User
通过db.models.user
(这还不存在!)User
模型相反,我认为您必须等到所有模型都定义好后才能创建关联:
function setup(db, cb) {
// Create models.
var Permission = require('./permission')(orm, db);
var User = require('./user')(orm, db);
var Company = require('./company')(orm, db);
// Create associations.
Company.hasOne('user', User, { required: true, reverse: 'companies', autoFetch: true});
...
// Return.
return cb(null, db);
}
(这也假设每个所需模型文件中的导出函数都返回模型,例如return Company
在的末尾company.js
)。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句