import nodeQueries from 'node-queries';

nodeQueries.init({
  "host":     "db.example.com",
  "user":     "user",
  "password": "P4ssw0rd!",
  "database": "example"
});

let app = express();
app.use(nodeQueries.middleware);

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);
};