@shares-team/mariadb v0.0.3

egg-mariadb

Install

$ npm i egg-mariadb --save

Usage

// {app_root}/config/plugin.js
exports.mariadb = {
  enable: true,
  package: 'egg-mariadb',
};

Configuration

// {app_root}/config/config.default.js
exports.mariadb = {
};

see config/config.default.js for more detail.

Example

const columns = [
  { $concat: [['A', 'B', 'C', 'D'], ['NEWNAME']] },              sql: CONCAT(`A`,`B`,`C`,`D`) AS `NEWNAME`
  { $sum: ['A', 'NEWNAME'] },                                    sql: SUM(`A`) AS `NEWNAME` 
  { $count: ['A', 'NEWNAME'] },                                  sql: COUNT(`A`) AS `NEWNAME` 
  { $sumDivideCount: ['A', 'B', 'NEWNAME'] }                     sql: SUM(`A`) / COUNT(`B`) AS `NEWNAME`
  { $max: ['A', 'NEWNAME'] },                                    sql: MAX(`A`) AS `NEWNAME`
  { $min: ['A', 'NEWNAME'] },                                    sql: MIN(`A`) AS `NEWNAME`
]

const where = [
  { password: 'xxxxxxxxxxxxxxxx' },                              sql: `password` = 'xxxx'
  [{ account: 'xxxx' }, { $OR: 'OR' }, { account: 'hongyang' }], sql: (`account` = 'xxxx' OR account = 'hongyang')
  { id: { $in: ['1', '2'] } },                                   sql: `id` IN ('1', '2')
  { id: { $notIn: ['1', '2'] } },                                sql: `id` NOT IN ('1', '2')
  { $concatLike: [['nickName', 'gender'], '%key%'] },             sql: CONCAT(`nickName`, `gender`) LIKE '%key%'
  { id: {$uneq: '1'}},                                           sql: `id` <> '1'
  { id: {$great: 2}},                                            sql: `id` > 2
  { id: {$lengGreat: 3}},                                        sql: LENGTH(`id`) > 3
  { id: {$less: 4}},                                             sql: `id` < 4
  { id: {$lengLess: '5'}},                                       sql: LENGTH(`id`) < 5
  { channel: { $between: [0, 3] } },                             sql: channel BETWEEN 0 AND 3
  { $unNull: 'gender' },                                         sql: `gender` IS NOT NULL
  { $null: 'gender' },                                           sql: `gender` IS NULL
  { nickName: { $like: '%key%' } }                                sql: `nickName` LIKE '%key%'
  { name: { $column: 'nickName' } }                              sql: `name` = `nickName`
]
// 连接符为AND