0.3.0 • Published 6 years ago
node-queries v0.3.0
node-queries
Node.js library for building SQL queries and HTTP responses using SQL-like DSL.
Installation
$ npm install node-queries
Usage
Import node-queries
module:
import nodeQueries from 'node-queries';
Initialize database connection:
nodeQueries.init({
"host": "db.example.com",
"user": "user",
"password": "P4ssw0rd!",
"database": "example"
});
Add middleware to your HTTP server:
let app = express();
app.use(nodeQueries.middleware);
That's it. You can use queries in your controllers now:
let router = express.Router();
app.use(router);
router.get('/items', function(request, response) {
nodeQueries
.selectFrom('item')
.where({
'visible': 1
})
.whereLike({
'name': request.params.q
})
.orderBy('time_added', 'DESC')
.limitOffset(request.params.limit, request.params.offset)
.postprocess(item => {
item.code = item.code.toUpperCase();
delete item.visible;
})
.execute(response);
};