-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.js
44 lines (33 loc) · 1.11 KB
/
index.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
const qs = require('qs');
const pick = require('lodash.pick');
module.exports = function parseListOpts(
querystring,
defaults,
opts = { format: 'knex', pageBase: 0 }
) {
if (opts.format && !/(sequelize|knex)/.test(opts.format)) console.warn('unsupported format');
const baseQuery = qs.parse(querystring);
const parsedQuery = pick(baseQuery, ['page', 'limit', 'offset', 'order', 'where']);
// query ex: `order=id&order=-name`
// query ex: `where[name]=doug&where[color]=red`
const query = {
page: opts.pageBase || 0,
limit: 20,
offset: 0,
order: [],
where: {},
...defaults,
...parsedQuery
};
let { page, limit, offset, where } = query;
page = parseInt(page);
limit = parseInt(limit);
offset = parseInt(offset);
if (!Array.isArray(query.order)) query.order = [query.order];
const order = query.order.map(field => {
let [column, order] = field.split('-').reverse();
order = typeof order === 'string' ? 'desc' : 'asc';
return opts.format === 'knex' ? { column, order } : [column, order];
});
return { ...baseQuery, page, limit, offset, order, where };
};