diff options
| author | Zephyrrus <[email protected]> | 2020-07-01 20:40:10 +0300 |
|---|---|---|
| committer | Zephyrrus <[email protected]> | 2020-07-01 20:40:10 +0300 |
| commit | e9ef148d7498b7068274a4141d5591cc8a64016e (patch) | |
| tree | 3d3afe519bf12b611a61e7435977925c019f33e1 /src/api/routes/files | |
| parent | chore: add thumb generator for migration (diff) | |
| download | host.fuwn.me-e9ef148d7498b7068274a4141d5591cc8a64016e.tar.xz host.fuwn.me-e9ef148d7498b7068274a4141d5591cc8a64016e.zip | |
feat: backend pagination for albums
Diffstat (limited to 'src/api/routes/files')
| -rw-r--r-- | src/api/routes/files/filesGET.js | 13 |
1 files changed, 8 insertions, 5 deletions
diff --git a/src/api/routes/files/filesGET.js b/src/api/routes/files/filesGET.js index 07dc1f7..9e90633 100644 --- a/src/api/routes/files/filesGET.js +++ b/src/api/routes/files/filesGET.js @@ -10,18 +10,21 @@ class filesGET extends Route { let count = 0; let files = db.table('files') - .where('userId', user.id) + .where({ userId: user.id }) .orderBy('createdAt', 'desc'); const { page, limit = 100 } = req.query; if (page && page >= 0) { files = await files.offset((page - 1) * limit).limit(limit); - count = (await db.table('files') - .count('id as count') - .where('userId', user.id) - .first()).count; + const dbRes = await db.table('files') + .count('* as count') + .where({ userId: user.id }) + .first(); + + count = dbRes.count; } else { + files = await files; // execute the query count = files.length; } |