From edac32bb986e8dab23a14a79317c2109bc523270 Mon Sep 17 00:00:00 2001
From: OpenGnSys Support Team <soporte-og@soleta.eu>
Date: Thu, 30 Nov 2023 20:06:07 +0100
Subject: rest: add GET /room/info

Add GET /room/info to obtain room information, this includes the name,
gateway and netmask.

curl -X GET -H "Authorization: $API_KEY" http://127.0.0.1:8888/room/info -d '{ "id" : 1 }
---
 src/dbi.c | 37 +++++++++++++++++++++++++++++++++++++
 1 file changed, 37 insertions(+)

(limited to 'src/dbi.c')

diff --git a/src/dbi.c b/src/dbi.c
index 7c7a5d0..ba4c113 100644
--- a/src/dbi.c
+++ b/src/dbi.c
@@ -129,6 +129,43 @@ int og_dbi_get_computer_info(struct og_dbi *dbi, struct og_computer *computer,
 	return 0;
 }
 
+int og_dbi_get_room_info(struct og_dbi *dbi, struct og_room *room,
+			 uint32_t room_id)
+{
+	const char *msglog;
+	dbi_result result;
+
+	result = dbi_conn_queryf(dbi->conn,
+				 "SELECT nombreaula, router, netmask "
+				 "FROM aulas WHERE idaula=%d AND grupoid=0",
+				 room_id);
+	if (!result) {
+		dbi_conn_error(dbi->conn, &msglog);
+		syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
+		       __func__, __LINE__, msglog);
+		return -1;
+	}
+
+	if (!dbi_result_next_row(result)) {
+		syslog(LOG_ERR, "room does not exist in database (%s:%d)\n",
+		       __func__, __LINE__);
+		dbi_result_free(result);
+		return -1;
+	}
+
+	room->id = room_id;
+	snprintf(room->name, sizeof(room->name), "%s",
+		 dbi_result_get_string(result, "nombreaula"));
+	snprintf(room->gateway, sizeof(room->gateway), "%s",
+		 dbi_result_get_string(result, "router"));
+	snprintf(room->netmask, sizeof(room->netmask), "%s",
+		 dbi_result_get_string(result, "netmask"));
+
+	dbi_result_free(result);
+
+	return 0;
+}
+
 #define OG_UNASSIGNED_SW_ID 0
 #define OG_IMAGE_DEFAULT_TYPE 1 /* monolithic */
 
-- 
cgit v1.2.3-18-g5258