From 2c78c2d07579186caad5519e8843a2f583fe6bc0 Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Mon, 30 Jun 2025 13:58:36 +0000
Subject: [PATCH] adding script to npm run
---
tst.js | 107 +++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 87 insertions(+), 20 deletions(-)
diff --git a/tst.js b/tst.js
index f1bb561..786ddba 100644
--- a/tst.js
+++ b/tst.js
@@ -1,4 +1,5 @@
const mysql = require("mysql2/promise")
+const db = require("./lib/db")
const {host, port, user, database, password} = require("./settings").db
@@ -11,26 +12,92 @@
/////////////////////////////////////////////////////////////////////////
-async function run () {
- // Create the connection to database
- console.log(111111111111,mysql)
- const connection = await mysql.createConnection({
- host,
- port,
- database,
- user,
- password,
- })
+async function run() {
-// A simple SELECT query
- try {
- const [results, fields] = await connection.query(
- `SELECT ud.* FROM ilias.usr_data AS ud WHERE login = '242424'`
- )
+ const settings = require("./settings")
+ console.log(settings)
- console.log(results) // results contains rows returned by server
- console.log(fields) // fields contains extra meta data about results, if available
- } catch (err) {
- console.log(err)
- }
+ // console.log(await db.getKurse())
+ // console.log(await db.getKurs(9911))
+
+ // const k = await db.getKurse()
+ const k = await db.getKursTeilnehmerCount(150)
+ console.log(k)
+ console.log(k.length)
+
+ //
+ // console.log(2222222222222222)
+ // const data = await db.getTeilnehmer(9911)
+ // console.log(data)
+
+ // const dat = await db.getObjIdFromRefId(149)
+ // console.log(dat)
+ //
+ // const dat2 = await db.getRefIdFromObjId(9911)
+ // console.log(dat2)
+
+ // const user = await db.getUserByLogin("242424")
+ // console.log("user", user)
+ //
+ // const user2 = await db.getUserByUserId(317)
+ // console.log("user2", user2)
+ //
+ // const start = new Date()
+ // const users = await db.getUsers(10,0)
+ // const users2 = users.map(({usr_id,login,firstname,lastname,email,institution}) => ({usr_id,login,firstname,lastname,institution}))
+ // console.table(users2)
+ // console.log(new Date() - start + "ms")
+ //
+ // const count = await db.getUserCount()
+ // console.log("count",count)
+
+ // console.time("udf")
+ // const udf = await db.getUserDefinedFields()
+ // console.log(udf)
+ // console.timeEnd("udf")
+
+ // console.time("udf1")
+ // // const usr = await db.getUserByUserId(316)
+ // const usr = await db.getUserByLogin("051134")
+ // console.log(usr)
+ // console.timeEnd("udf1")
+
+ // console.time("udf1")
+ // const udf1 = await db.getUserDefinedField(316)
+ // console.log(udf1)
+ // console.timeEnd("udf1")
+
+
+}
+
+// async function run () {
+// // Create the connection to database
+// // console.log(111111111111,mysql)
+// const connection = await mysql.createConnection({
+// host,
+// port,
+// database,
+// user,
+// password,
+// })
+//
+// // A simple SELECT query
+// try {
+// const sel = `usr_id, login, firstname, lastname, gender, email, institution, street, city, zipcode, country, department, active`
+// // const sel = "*"
+// const [results, fields] = await connection.query(
+// `SELECT ${sel} FROM ilias.usr_data AS ud WHERE login = '242424'`
+// )
+//
+// console.log(results) // results contains rows returned by server
+// // console.log(fields) // fields contains extra meta data about results, if available
+// } catch (err) {
+// console.log(err)
+// }
+// }
+
+/////////////////////////////////////////////////////////////////////////
+
+async function promiseDelay(ms) {
+ return new Promise(resolve => setTimeout(resolve, ms))
}
--
Gitblit v1.8.0