From f79ca500a73508e1556f6ca151649f522f74e83a Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Thu, 15 May 2025 15:19:57 +0000
Subject: [PATCH] adding db queries
---
lib/db.js | 14 ++++++++++++--
1 files changed, 12 insertions(+), 2 deletions(-)
diff --git a/lib/db.js b/lib/db.js
index b70af0e..3ff3fc7 100644
--- a/lib/db.js
+++ b/lib/db.js
@@ -20,6 +20,7 @@
module.exports = {
getUsers,
+ getUserCount,
getUserByLogin,
getUserByUserId,
}
@@ -34,11 +35,20 @@
const [results, fields] = await pool.query(
`SELECT ${sel}
FROM ilias.usr_data AS ud
+ WHERE login REGEXP '^[0-9]+$'
LIMIT ${limit}
OFFSET ${offset}
`
)
return results
+}
+
+async function getUserCount () {
+ const pool = await poolP
+ const [results, fields] = await pool.query(
+ `SELECT COUNT(*) FROM ilias.usr_data AS ud WHERE login REGEXP '^[0-9]+$'`
+ )
+ return results[0]["COUNT(*)"]
}
async function getUserByLogin (login) {
@@ -49,7 +59,7 @@
const [results, fields] = await pool.query(
`SELECT ${sel}
FROM ilias.usr_data AS ud
- WHERE login = '${login}'`
+ WHERE login = '${login}' AND login REGEXP '^[0-9]+$'`
)
return results
}
@@ -62,7 +72,7 @@
const [results, fields] = await pool.query(
`SELECT ${sel}
FROM ilias.usr_data AS ud
- WHERE usr_id = '${userId}'`
+ WHERE usr_id = '${userId}' AND login REGEXP '^[0-9]+$'`
)
return results
}
--
Gitblit v1.8.0