From 2f5c02d6cc67f20b043492c7f4498148fa4c3adb Mon Sep 17 00:00:00 2001
From: Akshay <nerdy@peppe.rs>
Date: Mon, 16 Dec 2024 13:03:36 +0000
Subject: order subs in asc alphabetic order

---
 src/routes/index.js | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'src')

diff --git a/src/routes/index.js b/src/routes/index.js
index f4c0fc9..ef395ed 100644
--- a/src/routes/index.js
+++ b/src/routes/index.js
@@ -97,8 +97,11 @@ router.get(
 // GET /subs
 router.get("/subs", authenticateToken, async (req, res) => {
 	const subs = db
-		.query("SELECT * FROM subscriptions WHERE user_id = $id")
+		.query(
+			"SELECT * FROM subscriptions WHERE user_id = $id ORDER by LOWER(subreddit)",
+		)
 		.all({ id: req.user.id });
+
 	res.render("subs", { subs, user: req.user });
 });
 
-- 
cgit v1.2.3