1.0.17 • Published 2 years ago
rendersql v1.0.17
rendersql
Una libreria para generar scripts sql
Install
npm i rendersql
Usage
Import your proyect
import Query from 'rendersql';
let table = new Array('users');
let columns = new Array('id', 'name');
let params = {
size: '10',
page: '1'
}
new Query(table, columns, params).renderSQl()
// return
{
"select": "SELECT id,nombre FROM usuarios LIMIT 0, 31",
"count": "SELECT count(*) as total FROM usuarios"
}
Example return class Query
let table = new Array('users');
let columns = new Array('id', 'name');
let params = {
size: '10',
page: '1',
filterColumn: 'id'
filterCondition: '='
fllterValue: '1'
}
new Query(table, columns, params).renderSQl()
// return
{
"select": "SELECT id,nombre FROM usuarios WHERE id = 1 LIMIT 0, 10",
"count": "SELECT count(*) as total FROM usuarios WHERE id_sucursal in (1)"
}
let table = new Array('users');
let columns = new Array('id', 'name');
let params = {
size: '10',
page: '1',
filterColumn: ['id', 'status']
filterCondition: ['=', '!=']
fllterValue: ['1', '0'],
filterRelation: 'and'
}
new Query(table, columns, params).renderSQl()
// return
{
"select": "SELECT id,name FROM users WHERE id = 1 and status != 0 LIMIT 0, 31",
"count": "SELECT count(*) as total FROM users WHERE id = 1 and status != 0 LIMIT 0, 31"
}
1.0.17
2 years ago
1.0.16
2 years ago
1.0.15
2 years ago
1.0.14
2 years ago
1.0.13
2 years ago
1.0.12
2 years ago
1.0.11
2 years ago
1.0.10
2 years ago
1.0.9
2 years ago
1.0.8
2 years ago
1.0.7
2 years ago
1.0.6
2 years ago
1.0.4
2 years ago
1.0.3
2 years ago
1.0.2
2 years ago
1.0.1
2 years ago
1.0.0
2 years ago
0.0.16
2 years ago
0.0.15
2 years ago
0.0.14
2 years ago
0.0.13
2 years ago
0.0.12
2 years ago
0.0.11
2 years ago
0.0.10
2 years ago
0.0.9
2 years ago
0.0.8
2 years ago
0.0.6
2 years ago
0.0.5
2 years ago
0.0.4
2 years ago
0.0.3
2 years ago
0.0.2
2 years ago
0.0.1
2 years ago