summaryrefslogtreecommitdiffstats
path: root/src
diff options
context:
space:
mode:
authorJose M. Guisado <jguisado@soleta.eu>2023-08-23 15:21:53 +0200
committerJose M. Guisado <jguisado@soleta.eu>2023-08-23 15:34:44 +0200
commit4cc2ca61fdf9b899a41ab60bfe58eeacd113ac0e (patch)
tree8902e88e077db5951e578d5f6efb48944b4f4ed2 /src
parent44745a3f22875af77da8f6e25ebc48b9840964ac (diff)
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.
Diffstat (limited to 'src')
-rw-r--r--src/dbi.c2
-rw-r--r--src/dbi.h1
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;