我有以下表格:
我想在上述输出中返回的每个用户中添加一个方法,该方法具有其总评论数量的计数。我尝试将以下内容添加到“User”模型中,但我无法正确地执行它。
books
book_reviews
users
const BookReview = require('./BookReview').model;
const User = require('./User').model;
module.exports.model = bookshelf.Model.extend({
tableName: 'books',
user: function() {
return this.hasOne(User, 'user_id');
},
reviews: function() {
return this.hasMany(BookReview);
}
});
module.exports.model = bookshelf.Model.extend({
tableName: 'book_reviews',
user: function() {
// Prevent circular dependency.
const User = require('./User').model;
return this.belongsTo(User, 'user_id');
},
});
module.exports.model = bookshelf.Model.extend({
tableName: 'users',
reviews: function() {
return this.belongsToMany(BookReview, 'user_id');
}
});
我正在查找一本书,并尝试获取所有评论(并且写这些评论的所有用户都附加在返回的评论中),目前使用以下语句进行操作:
return Book.forge({
id: req.params.id,
type: req.params.type
}).fetch({withRelated: ['reviews', 'reviews.user'], require: true}).then(function(book) {
console.log(book.toJSON());
return book;
}).catch(function(err) {
throw new Error(err.message);
});
};
book.toJSON()
的输出结果如下:
上述代码的 book.toJSON()
输出结果如下:
{ id: 1,
type: 'novel',
slug: 'catcher-in-the-rye',
user_id: 1,
name: 'Catcher in the Rye',
created_at: Tue Oct 04 2016 22:35:42 GMT-0700 (PDT),
updated_at: Tue Oct 04 2016 22:35:42 GMT-0700 (PDT),
reviews:
[ { id: 14,
user_id: 2,
book_id: 1,
rating: 3,
review: 'Test',
created_at: Wed Oct 05 2016 20:47:34 GMT-0700 (PDT),
updated_at: Wed Oct 05 2016 20:47:34 GMT-0700 (PDT),
user: [Object] } ] }
我想在上述输出中返回的每个用户中添加一个方法,该方法具有其总评论数量的计数。我尝试将以下内容添加到“User”模型中,但我无法正确地执行它。
numReviews: function(userId) {
return new BookReview.query(function(qb){
qb.where("user_id",userId);
qb.count();
}).fetch();
},