dbi: add server_id to og_computer struct

Extend og_dbi_get_computer_info to fetch "identorno" column from
"ordenadores". "identorno" holds the row id value from the "entornos"
table (valid ogserver addresses).

Extend og_computer struct with a new field: "server_id" that will store
the value of "identorno" column fetched from the database.

2 files changed, 3 insertions, 0 deletions

diff --git a/src/dbi.c b/src/dbi.c
index a90d5ec..7c7a5d0 100644
--- a/src/dbi.c
+++ b/src/dbi.c
@@ -77,6 +77,7 @@ int og_dbi_get_computer_info(struct og_dbi *dbi, struct og_computer *computer,
 				 "       ordenadores.oglivedir,"
 				 "       ordenadores.inremotepc,"
 				 "       ordenadores.maintenance,"
+				 "       ordenadores.identorno,"
 				 "       centros.idcentro "
 				 "FROM ordenadores "
 				 "INNER JOIN aulas ON aulas.idaula=ordenadores.idaula "
@@ -104,6 +105,7 @@ int og_dbi_get_computer_info(struct og_dbi *dbi, struct og_computer *computer,
 		 dbi_result_get_string(result, "ip"));
 	snprintf(computer->mac, sizeof(computer->mac), "%s",
 		 dbi_result_get_string(result, "mac"));
+	computer->server_id = dbi_result_get_uint(result, "identorno");
 	computer->room = dbi_result_get_uint(result, "idaula");
 	computer->center = dbi_result_get_uint(result, "idcentro");
 	computer->hardware_id = dbi_result_get_uint(result, "idperfilhard");
diff --git a/src/dbi.h b/src/dbi.h
index 5f6b52e..f6cb1dd 100644
--- a/src/dbi.h
+++ b/src/dbi.h
@@ -74,6 +74,7 @@ struct og_legacy_partition {
 struct og_computer {
 	unsigned int	procedure_id;
 	unsigned int	hardware_id;
+	unsigned int	server_id;
 	unsigned int	repo_id;
 	unsigned int	center;
 	unsigned int	room;