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