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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
const searchQuery = require('search-query-parser');
const Route = require('../../structures/Route');
const Util = require('../../utils/Util');
const queryHelper = require('../../utils/QueryHelper');
const options = {
keywords: ['album', 'tag', 'before', 'after', 'file'],
offsets: false,
alwaysArray: true,
tokenize: true
};
class configGET extends Route {
constructor() {
super('/search/', 'get');
}
async run(req, res, db, user) {
let count = 0;
const { q, albumId } = req.query;
const parsed = searchQuery.parse(q, options);
let files = db.table('files')
.select('*')
.where({ 'files.userId': user.id })
.orderBy('files.createdAt', 'desc');
if (albumId) {
files
.join('albumsFiles', 'albumsFiles.fileId', 'files.id')
.where({ albumId });
}
files = queryHelper.processQuery(db, files, parsed);
// const query = files.toString();
const { page, limit = 100 } = req.query;
if (page && page >= 0) {
let dbRes = files.clone(); // clone the query to attach a count to it later on
files = await files.offset((page - 1) * limit).limit(limit);
dbRes = await dbRes.count('* as count').first();
count = dbRes.count;
} else {
files = await files; // execute the query
count = files.length;
}
// For each file, create the public link to be able to display the file
for (let file of files) {
file = Util.constructFilePublicLink(req, file);
}
return res.json({
message: 'Successfully retrieved files',
// query,
// parsed,
files,
count
});
}
}
module.exports = configGET;
|