如何使用bookshelf.js在单个查询中通过PK获得记录列表?
最终查询应等效于:
SELECT * FROM `user` WHERE `id` IN (1,3,5,6,7);
此解决方案有效:
AdModel
.where('search_id', 'IN', [1, 2, 3])
.fetchAll();
您也可以使用KnexQueryBuilder来获得相同的结果
AdModel
.query(qb => {
qb.whereIn('search_id', [1, 2, 3]);
})
.fetchAll();
列出(单个)查询和获取关系(withRelated)
BookshelfModel
.where('field_id', 'IN', [1, 2, 3])
.fetchAll({withRelated: ["tableA", "tableB"]});