ali-rds icon indicating copy to clipboard operation
ali-rds copied to clipboard

新增了OR和AND等选项

Open SimbaZZX opened this issue 4 years ago • 0 comments

operator.js进行了简单的修改,新增了ORAND等选项,支持了like,大于小于、嵌套条件等

害,似乎缺少了 a<1 or a =2的操作 ,我的项目比较简单,没用到

调用示例如下:

where: {
                a: 1,
                b: [11, 22],
                OR: {
                    sender11: { op: 'like', value: `%111%` },
                    receiver22: { op: 'like', value: `%222%` },
                },
                AND: {
                    orderno: null,
                    id: 1,
                    role: ['admin', 'guest'],
                    OR: {
                        realname: { op: 'like', value: 'simba' },
                        age: { op: '>', value: '20' },
                        nickname: { op: 'like', value: 'ace' }
                    },
                    createtime: [
                        { op: '>', value: '2020-10-13' },
                        { op: '<', value: '2020-11-22' },
                    ]
                },
          }

SimbaZZX avatar Dec 05 '20 09:12 SimbaZZX