eggjs / eggjs/egg

希望egg-mysql支持在select字段列中写子查询

Open
#5,761 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
TypeScript
Stars
19k
Forks
1.8k
PR merge metrics
No merged PRs in 30d

Description

### 请详细告知你的新点子(Nice Ideas):

1. 希望egg-mysql支持在select字段列中写子查询
如:
```sql
SELECT id, username, nickname, login_type,
(SELECT SUM(times) FROM remoter_device_use AS du
WHERE du.user_id = sys_user.id AND du.times > 0) AS use_times
FROM sys_user WHERE deleted = 0
ORDER BY use_times DESC, id DESC
LIMIT 0, 10
```

我使用这种写法会出现sql错误`(SELECT SUM(times) FROM remoter_device_use AS du WHERE du.user_id = sys_user.id AND times > 0) AS use_times`不是字段
```sql
this.app.mysql.select('sys_user', {
columns: [
'id',
'username',
'nickname',
'login_type',
'(SELECT SUM(times) FROM remoter_device_use AS du WHERE du.user_id = sys_user.id AND times > 0) AS use_times'
],
where,
orders: [
[ 'use_times', 'DESC' ],
[ 'id', 'DESC' ]
],
limit: pageSize,
offset
});
```
2. 希望egg-mysql查询支持写and or条件混合。
egg-mysql的支持实在太弱了。

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.