thinkjs / thinkjs

Use full ES2015+ features to develop Node.js applications, Support TypeScript.
https://thinkjs.org/
MIT License
5.31k stars 617 forks source link

关联模型,根据字段值,自动关闭 #712

Closed humbass closed 7 years ago

humbass commented 7 years ago

DESC


export default class extends think.model.relation {
    init(...args) {
        super.init(...args);
        this.relation = {
            admin: {
                type: think.model.BELONG_TO, 
                model: 'admin', 
                name: 'admin', 
                key: 'admin_id',
                fKey: 'id', 
                field: 'id, nickname, user',
            },
            user: {
                type: think.model.BELONG_TO, 
                model: 'player', 
                name: 'player', 
                key: 'player_id',
                fKey: 'id', 
                field: 'id, nickname, phone', 
            }
        }
    }
}

表 ask 里头有 admin_id,user_id 字段,部分记录admin_id是空的,因此在运行的时候会出现 SELECT id,nickname,user FROM xxx_admin WHERE ( id = 'undefined' ) 0ms

求教: admin_id 不存在的时候,不进行查询,应该如何设置?

ENV

Platform:

Node.js Version:

ThinkJS Version:

welefen commented 7 years ago

为啥部分记录的 admin_id 是空的呢?

humbass commented 7 years ago

@welefen 当这条记录没有被admin审核的时候,ask中字段admin_id的记录是空的,直到签名后,才有admin_id。

welefen commented 7 years ago

@humbass 下个版本里支持下这种情况

welefen commented 7 years ago

https://github.com/thinkjs/think-model/commit/9741a6e21db36c00b27a873cea11c57bea908f28 提交中修复了这个问题

humbass commented 7 years ago

gooooood.