From 9771bffb3e80e1df879f1b2daaec6ddab1f9dd18 Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Mon, 02 Jun 2025 09:46:15 +0000
Subject: [PATCH] adding cli prog getObjId.js
---
lib/db.js | 43 +++++++++++++++++++++++++++++++++++--------
1 files changed, 35 insertions(+), 8 deletions(-)
diff --git a/lib/db.js b/lib/db.js
index 4813ba7..e849ebd 100644
--- a/lib/db.js
+++ b/lib/db.js
@@ -25,6 +25,9 @@
getUserByUserId,
getUserDefinedFields,
getUserDefinedField,
+
+ getObjIdFromRefId,
+ getRefIdFromObjId,
}
/////////////////////////////////////////////////////////////////////////
@@ -37,7 +40,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 +58,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 +72,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 +87,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 +98,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,14 +108,38 @@
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}'
`
)
return results
}
+/////// obj_id / ref_id ////////////////////////////////////////////////////////////////
+
+async function getObjIdFromRefId (refId) {
+ const pool = await poolP
+ const [results] = await pool.query(
+ `SELECT ref_id, obj_id
+ FROM ${database}.object_reference as obr
+ WHERE obr.ref_id = ${refId}
+ `
+ )
+ return results.length ? results[0] : undefined
+}
+
+async function getRefIdFromObjId (objId) {
+ const pool = await poolP
+ const [results] = await pool.query(
+ `SELECT ref_id, obj_id
+ FROM ${database}.object_reference as obr
+ WHERE obr.obj_id = ${objId}
+ `
+ )
+ return results.length ? results[0] : undefined
+}
+
/////////////////////////////////////////////////////////////////////////
async function promiseDelay (ms) {
--
Gitblit v1.8.0