From 4cc2ca61fdf9b899a41ab60bfe58eeacd113ac0e Mon Sep 17 00:00:00 2001 From: "Jose M. Guisado" Date: Wed, 23 Aug 2023 15:21:53 +0200 Subject: 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. --- src/dbi.c | 2 ++ src/dbi.h | 1 + 2 files changed, 3 insertions(+) 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; -- cgit v1.2.3-18-g5258