From 0316b8949b75f68a3d3f3e88f3b8512a913f9190 Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Mon, 02 Jun 2025 13:32:38 +0000
Subject: [PATCH] adding cli prog getRefId.js
---
lib/db.js | 27 +++++++++++++++++++++++++++
1 files changed, 27 insertions(+), 0 deletions(-)
diff --git a/lib/db.js b/lib/db.js
index a8cac67..e849ebd 100644
--- a/lib/db.js
+++ b/lib/db.js
@@ -25,6 +25,9 @@
getUserByUserId,
getUserDefinedFields,
getUserDefinedField,
+
+ getObjIdFromRefId,
+ getRefIdFromObjId,
}
/////////////////////////////////////////////////////////////////////////
@@ -113,6 +116,30 @@
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