wc-sql-query
0.0.5 • Public • Published Express req.query -> mysql where
New in 0.0.2
Use
Query = require("wc-sql-query")
Firm =
table:'`2015`.`firm`'
find:(q, fields, fn)->
query = Query q
where = (if query.where then " WHERE #{query.where}" else "")
order = (if query.order then " ORDER BY #{query.order}" else "")
limit = (if query.limit then " LIMIT #{query.limit}" else "")
sql = "SELECT #{fields} FROM #{@table} #{where} #{order} #{limit};"
Mysql.query sql, fn
Comparison Query Operators
EQ
NEQ
- url: /api/item?name=!test
GT
- url: /api/item?name=>test
GTE
- url: /api/item?name=]test
LT
- url: /api/item?name=< test
LTE
- url: /api/item?name=[test
Evaluation Query Operators
- url: /api/item?name=~test
Sort
- /api/item?order=name
- /api/item?order=-name
Limit
- /api/item?limit=25&skip=0
Package Sidebar
Install
Weekly Downloads