Comparing version 0.1.12 to 0.1.13
{ | ||
"name": "mql2", | ||
"version": "0.1.12", | ||
"version": "0.1.13", | ||
"description": "query builder", | ||
@@ -5,0 +5,0 @@ "main": "index.js", |
@@ -125,3 +125,3 @@ # MQL - Node.js Functional SQL Query Builder & ORM | ||
const POOL = await CONNECT(); | ||
const = { | ||
const { | ||
VALUES, IN, NOT_IN, EQ, SET, COLUMN, CL, TABLE, TB, SQL, MQL_DEBUG, | ||
@@ -157,3 +157,3 @@ QUERY, | ||
```javascript | ||
const users = await QUERY `SELECT * FROM users WHERE ${NOT_IN('id', [2, 4])} LIMIT 3 ORDER BY ID`; | ||
const users = await QUERY `SELECT * FROM users WHERE ${NOT_IN('id', [2, 4])} ORDER BY ID LIMIT 3`; | ||
// [{ id: 1, ...}, { id: 3, ...}, { id: 5, ...}] | ||
@@ -277,3 +277,3 @@ ``` | ||
`; | ||
// SELECT * FROM photos WHERE attached_id IN (${map($ => $.id, posts)}) AND attached_type = 'photos'; | ||
// SELECT * FROM photos WHERE attached_id IN (${map($ => $.id, posts)}) AND attached_type = 'posts'; | ||
// SELECT * FROM photos WHERE attached_id IN (${map($ => $.id, users)}) AND attached_type = 'users'; | ||
@@ -280,0 +280,0 @@ // SELECT * FROM photos WHERE attached_id IN (${map($ => $.id, comments)}) AND attached_type = 'comments'; |
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
34233