Merge pull request #250 from Zephyrrus/feature/system_status_page

Feature/system status page

1 files changed, 48 insertions, 0 deletions

diff --git a/src/api/routes/service/statsGET.js b/src/api/routes/service/statsGET.js
new file mode 100644
index 0000000..2241ca8
--- /dev/null
+++ b/src/api/routes/service/statsGET.js
@@ -0,0 +1,48 @@
+const Route = require('../../structures/Route');
+const StatsGenerator = require('../../utils/StatsGenerator');
+const moment = require('moment');
+
+// Thank you Bobby for the stats code https://github.com/BobbyWibowo/lolisafe/blob/safe.fiery.me/controllers/utilsController.js
+class filesGET extends Route {
+	constructor() {
+		super('/service/statistics', 'get', { adminOnly: true });
+	}
+
+	async run(req, res, db) {
+		const cachedStats = await db('statistics')
+			.select('type', 'data', 'batchId', 'createdAt')
+			.where('batchId', '=', db('statistics').max('batchId'));
+
+		let stats = cachedStats.reduce((acc, { type, data, createdAt }) => {
+			try {
+				// pg returns json, sqlite retuns a string...
+				if (typeof data === 'string' || data instanceof String) {
+					acc[type] = JSON.parse(data);
+				} else {
+					acc[type] = data;
+				}
+
+				acc[type].meta = {
+					cached: true,
+					generatedOn: moment(createdAt).format('MMMM Do YYYY, h:mm:ss a z'), // pg returns this as a date, sqlite3 returns an unix timestamp :<
+					type: StatsGenerator.Type.HIDDEN
+				};
+			} catch (e) {
+				console.error(e);
+			}
+
+			return acc;
+		}, {});
+
+		stats = { ...stats, ...(await StatsGenerator.getMissingStats(db, Object.keys(stats))) };
+
+		const ordered = StatsGenerator.keyOrder.reduce((acc, k) => {
+			acc[k] = stats[k];
+			return acc;
+		}, {});
+
+		return res.json({ statistics: ordered });
+	}
+}
+
+module.exports = filesGET;