diff options
Diffstat (limited to 'src/dbi.c')
| -rw-r--r-- | src/dbi.c | 37 |
1 files changed, 37 insertions, 0 deletions
@@ -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 */ |