rest: Add /center/info

Add URI to allow a GET request to obtain info about a center (name, id
and comment of the center as of now).

To use this uri, simply send a GET request with a json containing the id
of the center whose info needs to be consulted:

curl -X GET -H "Authorization: $API_KEY" http://127.0.0.1:8888/center/info -d '{"id":1}'

based on work from Javier Hernandez.

1 files changed, 33 insertions, 0 deletions

diff --git a/src/dbi.c b/src/dbi.c
index 3d2608d..a3bee37 100644
--- a/src/dbi.c
+++ b/src/dbi.c
@@ -129,6 +129,39 @@ int og_dbi_get_computer_info(struct og_dbi *dbi, struct og_computer *computer,
 	return 0;
 }
 
+int og_dbi_get_center_info(struct og_dbi *dbi, struct og_center *center)
+{
+	const char *msglog;
+	dbi_result result;
+
+	result = dbi_conn_queryf(dbi->conn,
+				 "SELECT nombrecentro, idcentro, comentarios "
+				 "FROM centros WHERE idcentro=%d",
+				 center->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, "center does not exist in database (%s:%d)\n",
+		       __func__, __LINE__);
+		dbi_result_free(result);
+		return -1;
+	}
+
+	snprintf(center->name, sizeof(center->name), "%s",
+		 dbi_result_get_string(result, "nombrecentro"));
+	snprintf(center->comment, sizeof(center->comment), "%s",
+		 dbi_result_get_string(result, "comentarios"));
+
+	dbi_result_free(result);
+
+	return 0;
+}
+
 int og_dbi_get_room_info(struct og_dbi *dbi, struct og_room *room,
 			 uint32_t room_id)
 {