eggjs mysql 不等于_egg-mysql or ali-rds 能否实现“可有可无”的条件查询写法吗？

Node Version:

Egg Version:

Plugin Name: egg-mysql

Plugin Version: ^1.0.0

Platform:

egg-mysql将where条件语句查询封装在对象里，

const type = this.query.type;

const page = this.query.page || 1;

const pageSize = this.query.pageSize || 10;

const pangufe = this.app.mysql.get('pangufe');

const results = yield pangufe.select('log', {

where: {type: type},

columns: ['type', 'ua', 'page', 'error_message', 'create_time'],

orders: [['create_time', 'desc'], ['id', 'desc']],

limit: pageSize,

offset: pageSize * (page - 1)

});

这样还能不能实现 某条件可有可无 的查询？

功能诸如PHP的Yii框架中，若有此条件，则加一个andWhere就好。

$find = LiveContent::find()->with('user');

if (!$this->getLiveUser(self::HOST_ID)) {

$this->addLiveUser(self::HOST_ID);

}

if (User::get('user_id') != self::HOST_ID) {

$find->andWhere(['=', 'status', LiveContent::STATUS_ACTIVE]);

}

if ($searchKey) {

$find->andWhere(['LIKE', 'content', $searchKey]);

}

if ($sort == 'old') {

if ($contentId) {

$find->andWhere(['

}

$find->orderBy('content_id DESC');

} elseif ($sort == 'new') {

if ($contentId) {

$find->andWhere(['>', 'content_id', $contentId]);

}

$find->orderBy('content_id ASC');

}

return $find;