From ba257e507eb8ae5f783ce916f6be5f95c0b6f285 Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Mon, 02 Jun 2025 16:04:55 +0000
Subject: [PATCH] adding new routes

---
 lib/db.js |   10 ++++++++--
 1 files changed, 8 insertions(+), 2 deletions(-)

diff --git a/lib/db.js b/lib/db.js
index d13bd08..d492507 100644
--- a/lib/db.js
+++ b/lib/db.js
@@ -30,7 +30,8 @@
    getRefIdFromObjId,
 
    getKurse,
-   getKurs,
+   getKursByObjId,
+   getKursByRefId,
    getTeilnehmer,
 }
 
@@ -171,7 +172,12 @@
    return results
 }
 
-async function getKurs (obj_id) {
+async function getKursByRefId (refId) {
+   const {ref_id, obj_id} = await getObjIdFromRefId(refId)
+   return getKursByObjId(obj_id)
+}
+
+async function getKursByObjId (obj_id) {
    const pool = await poolP
    const q = `SELECT or2.ref_id, or2.obj_id, od.title, od.description, od.type
               FROM ${database}.object_reference or2

--
Gitblit v1.8.0