feat: backend pagination

serverLoad++;
userRamUsage--;

2 files changed, 19 insertions, 5 deletions

diff --git a/src/api/routes/files/filesGET.js b/src/api/routes/files/filesGET.js
index f1a3a26..07dc1f7 100644
--- a/src/api/routes/files/filesGET.js
+++ b/src/api/routes/files/filesGET.js
@@ -7,10 +7,23 @@ class filesGET extends Route {
 	}
 
 	async run(req, res, db, user) {
-		// Get all the files from the user
-		const files = await db.table('files')
+		let count = 0;
+
+		let files = db.table('files')
 			.where('userId', user.id)
-			.orderBy('id', 'desc');
+			.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;
+		} else {
+			count = files.length;
+		}
 
 		// For each file, create the public link to be able to display the file
 		for (let file of files) {
@@ -19,7 +32,8 @@ class filesGET extends Route {
 
 		return res.json({
 			message: 'Successfully retrieved files',
-			files
+			files,
+			count
 		});
 	}
 }
diff --git a/src/api/utils/Util.js b/src/api/utils/Util.js
index b8d960d..c37297a 100644
--- a/src/api/utils/Util.js
+++ b/src/api/utils/Util.js
@@ -122,7 +122,7 @@ class Util {
 			/*
 				It's funny but if you do i++ the asignment never gets done resulting in an infinite loop
 			*/
-			if (i < 5) return retry(i + 1);
+			if (i < 5) return retry(++i);
 			log.error('Couldnt allocate identifier for album');
 			return null;
 		};