summaryrefslogtreecommitdiffstats
path: root/admin/Sources/Services/ogAdmServer/sources/ogAdmServer.cpp
diff options
context:
space:
mode:
authorOpenGnSys Support Team <soporte-og@soleta.eu>2019-11-26 18:08:26 +0100
committerOpenGnSys Support Team <soporte-og@soleta.eu>2020-03-04 14:55:11 +0100
commit7db4aa449f8879013092e49535f1f41c454adffc (patch)
treeba50dfbf7f193a3c056453f6ffe7fa754c13ff56 /admin/Sources/Services/ogAdmServer/sources/ogAdmServer.cpp
parent54bd82debe2f7b8409050b800d41f70eb996301a (diff)
#941 use dbi layer from envioProgramacion
Diffstat (limited to 'admin/Sources/Services/ogAdmServer/sources/ogAdmServer.cpp')
-rw-r--r--admin/Sources/Services/ogAdmServer/sources/ogAdmServer.cpp68
1 files changed, 30 insertions, 38 deletions
diff --git a/admin/Sources/Services/ogAdmServer/sources/ogAdmServer.cpp b/admin/Sources/Services/ogAdmServer/sources/ogAdmServer.cpp
index 99e07e3f..8ee8342b 100644
--- a/admin/Sources/Services/ogAdmServer/sources/ogAdmServer.cpp
+++ b/admin/Sources/Services/ogAdmServer/sources/ogAdmServer.cpp
@@ -2641,36 +2641,35 @@ static bool recibeArchivo(TRAMA *ptrTrama, struct og_client *cli)
static bool envioProgramacion(TRAMA *ptrTrama, struct og_client *cli)
{
char *ptrIP[MAXIMOS_CLIENTES],*ptrMacs[MAXIMOS_CLIENTES];
- char sqlstr[LONSQL], msglog[LONSTD];
- char *idp,iph[LONIP],mac[LONMAC];
- Database db;
- Table tbl;
+ char *idp, *iph, *mac;
int idx,idcomando,lon;
+ const char *msglog;
+ struct og_dbi *dbi;
+ dbi_result result;
- if (!db.Open(usuario, pasguor, datasource, catalog)) {
- db.GetErrorErrStr(msglog);
- syslog(LOG_ERR, "cannot open connection database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
+ dbi = og_dbi_open(&dbi_config);
+ if (!dbi) {
+ syslog(LOG_ERR, "cannot open connection database (%s:%d)\n",
+ __func__, __LINE__);
return false;
}
idp = copiaParametro("idp",ptrTrama); // Toma identificador de la programaciĆ³n de la tabla acciones
- sprintf(sqlstr, "SELECT ordenadores.ip,ordenadores.mac,acciones.idcomando FROM acciones "\
+ result = dbi_conn_queryf(dbi->conn,
+ "SELECT ordenadores.ip,ordenadores.mac,acciones.idcomando FROM acciones "\
" INNER JOIN ordenadores ON ordenadores.ip=acciones.ip"\
" WHERE acciones.idprogramacion=%s",idp);
-
+
liberaMemoria(idp);
- if (!db.Execute(sqlstr, tbl)) {
- db.GetErrorErrStr(msglog);
+ if (!result) {
+ dbi_conn_error(dbi->conn, &msglog);
syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
__func__, __LINE__, msglog);
+ og_dbi_close(dbi);
return false;
}
- db.Close();
- if(tbl.ISEOF())
- return true; // No existen registros
/* Prepara la trama de actualizacion */
@@ -2678,36 +2677,27 @@ static bool envioProgramacion(TRAMA *ptrTrama, struct og_client *cli)
ptrTrama->tipo=MSG_COMANDO;
sprintf(ptrTrama->parametros, "nfn=Actualizar\r");
- while (!tbl.ISEOF()) { // Recorre particiones
- if (!tbl.Get("ip", iph)) {
- tbl.GetErrorErrStr(msglog);
- syslog(LOG_ERR, "cannot find ip column in table: %s\n",
- msglog);
- return false;
- }
- if (!tbl.Get("idcomando", idcomando)) {
- tbl.GetErrorErrStr(msglog);
- syslog(LOG_ERR, "cannot find idcomando column in table: %s\n",
- msglog);
- return false;
- }
- if(idcomando==1){ // Arrancar
- if (!tbl.Get("mac", mac)) {
- tbl.GetErrorErrStr(msglog);
- syslog(LOG_ERR, "cannot find mac column in table: %s\n",
- msglog);
- return false;
- }
+ while (dbi_result_next_row(result)) {
+ iph = (char *)dbi_result_get_string(result, "ip");
+ idcomando = dbi_result_get_uint(result, "idcomando");
+ if (idcomando == 1){ // Arrancar
+ mac = (char *)dbi_result_get_string(result, "mac");
lon = splitCadena(ptrIP, iph, ';');
lon = splitCadena(ptrMacs, mac, ';');
// Se manda por broadcast y por unicast
- if (!Levanta(ptrIP, ptrMacs, lon, (char*)"1"))
+ if (!Levanta(ptrIP, ptrMacs, lon, (char*)"1")) {
+ dbi_result_free(result);
+ og_dbi_close(dbi);
return false;
+ }
- if (!Levanta(ptrIP, ptrMacs, lon, (char*)"2"))
+ if (!Levanta(ptrIP, ptrMacs, lon, (char*)"2")) {
+ dbi_result_free(result);
+ og_dbi_close(dbi);
return false;
+ }
}
if (clienteDisponible(iph, &idx)) { // Si el cliente puede recibir comandos
@@ -2720,8 +2710,10 @@ static bool envioProgramacion(TRAMA *ptrTrama, struct og_client *cli)
}
//close(tbsockets[idx].sock); // Cierra el socket del cliente hasta nueva disponibilidad
}
- tbl.MoveNext();
}
+ dbi_result_free(result);
+ og_dbi_close(dbi);
+
return true; // No existen registros
}