From 9e1cd642d87d67c645b687231a002753fdfb28ca Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Thu, 15 May 2025 21:24:09 +0000
Subject: [PATCH] adding REST routes
---
tst.js | 66 +++++++++++++++++++++++----------
1 files changed, 46 insertions(+), 20 deletions(-)
diff --git a/tst.js b/tst.js
index f1bb561..fc30d66 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,51 @@
/////////////////////////////////////////////////////////////////////////
-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() {
+ const user = await db.getUserByLogin("242424")
+ console.log("user", user)
-// A simple SELECT query
- try {
- const [results, fields] = await connection.query(
- `SELECT ud.* FROM ilias.usr_data AS ud WHERE login = '242424'`
- )
+ const user2 = await db.getUserByUserId(317)
+ console.log("user2", user2)
- 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)
- }
+ 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)
+}
+
+// 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