From be556d5982e743d0af7cbf63a619b77d23a13f2a Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Mon, 26 May 2025 14:33:46 +0000
Subject: [PATCH] need separate settings file
---
lib/db.js | 16 ++++++++--------
1 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/lib/db.js b/lib/db.js
index 4813ba7..a8cac67 100644
--- a/lib/db.js
+++ b/lib/db.js
@@ -37,7 +37,7 @@
const pool = await poolP
const [results, fields] = await pool.query(
`SELECT ${sel}
- FROM ilias.usr_data AS ud
+ FROM ${database}.usr_data AS ud
WHERE login REGEXP '^[0-9]+$'
LIMIT ${limit}
OFFSET ${offset}
@@ -55,7 +55,7 @@
const pool = await poolP
const [results, fields] = await pool.query(
`SELECT COUNT(*)
- FROM ilias.usr_data AS ud
+ FROM ${database}.usr_data AS ud
WHERE login REGEXP '^[0-9]+$'`
)
return results[0]["COUNT(*)"]
@@ -69,7 +69,7 @@
const pool = await poolP
const [results, fields] = await pool.query(
`SELECT ${sel}
- FROM ilias.usr_data AS ud
+ FROM ${database}.usr_data AS ud
WHERE login = '${login}'
AND login REGEXP '^[0-9]+$'`
)
@@ -84,7 +84,7 @@
const pool = await poolP
const [results, fields] = await pool.query(
`SELECT ${sel}
- FROM ilias.usr_data AS ud
+ FROM ${database}.usr_data AS ud
WHERE usr_id = '${userId}'
AND login REGEXP '^[0-9]+$'`
)
@@ -95,8 +95,8 @@
const pool = await poolP
const [results] = await pool.query(
`SELECT ut.usr_id, ud.field_name, ut.value
- FROM ilias.udf_definition ud
- JOIN ilias.udf_text ut ON ut.field_id = ud.field_id`
+ FROM ${database}.udf_definition ud
+ JOIN ${database}.udf_text ut ON ut.field_id = ud.field_id`
)
return results
}
@@ -105,8 +105,8 @@
const pool = await poolP
const [results] = await pool.query(
`SELECT ut.usr_id, ud.field_name, ut.value
- FROM ilias.udf_definition ud
- JOIN ilias.udf_text ut ON ut.field_id = ud.field_id
+ FROM ${database}.udf_definition ud
+ JOIN ${database}.udf_text ut ON ut.field_id = ud.field_id
WHERE ut.usr_id = '${usr_id}'
`
)
--
Gitblit v1.8.0