summaryrefslogtreecommitdiffstats
path: root/src/rest.c
diff options
context:
space:
mode:
Diffstat (limited to 'src/rest.c')
-rw-r--r--src/rest.c2871
1 files changed, 1 insertions, 2870 deletions
diff --git a/src/rest.c b/src/rest.c
index 235cab8..917b72b 100644
--- a/src/rest.c
+++ b/src/rest.c
@@ -16,8 +16,6 @@
#include "wol.h"
#include "cfg.h"
#include "repo.h"
-#include "schedule.h"
-#include "legacy.h"
#include <ev.h>
#include <syslog.h>
#include <sys/ioctl.h>
@@ -219,46 +217,6 @@ int og_json_parse_partition_setup(json_t *element, struct og_msg_params *params)
return 0;
}
-static int og_json_parse_time_params(json_t *element,
- struct og_msg_params *params)
-{
- const char *key;
- json_t *value;
- int err = 0;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "years")) {
- err = og_json_parse_uint(value, &params->time.years);
- params->flags |= OG_REST_PARAM_TIME_YEARS;
- } else if (!strcmp(key, "months")) {
- err = og_json_parse_uint(value, &params->time.months);
- params->flags |= OG_REST_PARAM_TIME_MONTHS;
- } else if (!strcmp(key, "weeks")) {
- err = og_json_parse_uint(value, &params->time.weeks);
- params->flags |= OG_REST_PARAM_TIME_WEEKS;
- } else if (!strcmp(key, "week_days")) {
- err = og_json_parse_uint(value, &params->time.week_days);
- params->flags |= OG_REST_PARAM_TIME_WEEK_DAYS;
- } else if (!strcmp(key, "days")) {
- err = og_json_parse_uint(value, &params->time.days);
- params->flags |= OG_REST_PARAM_TIME_DAYS;
- } else if (!strcmp(key, "hours")) {
- err = og_json_parse_uint(value, &params->time.hours);
- params->flags |= OG_REST_PARAM_TIME_HOURS;
- } else if (!strcmp(key, "am_pm")) {
- err = og_json_parse_uint(value, &params->time.am_pm);
- params->flags |= OG_REST_PARAM_TIME_AM_PM;
- } else if (!strcmp(key, "minutes")) {
- err = og_json_parse_uint(value, &params->time.minutes);
- params->flags |= OG_REST_PARAM_TIME_MINUTES;
- }
- if (err != 0)
- return err;
- }
-
- return err;
-}
-
static const char *og_cmd_to_uri[OG_CMD_MAX] = {
[OG_CMD_WOL] = "wol",
[OG_CMD_PROBE] = "probe",
@@ -274,7 +232,6 @@ static const char *og_cmd_to_uri[OG_CMD_MAX] = {
[OG_CMD_IMAGE_UPDATE] = "image/update",
[OG_CMD_IMAGE_RESTORE] = "image/restore",
[OG_CMD_SETUP] = "setup",
- [OG_CMD_RUN_SCHEDULE] = "run/schedule",
[OG_CMD_IMAGES] = "images",
[OG_CMD_CACHE_DELETE] = "cache/delete",
[OG_CMD_CACHE_FETCH] = "cache/fetch",
@@ -372,29 +329,6 @@ int og_send_request(enum og_rest_method method, enum og_cmd_type type,
return 0;
}
-static int og_cmd_post_clients(json_t *element, struct og_msg_params *params)
-{
- const char *key;
- json_t *value;
- int err = 0;
-
- if (json_typeof(element) != JSON_OBJECT)
- return -1;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "clients"))
- err = og_json_parse_clients(value, params);
-
- if (err < 0)
- return err;
- }
-
- if (!og_msg_params_validate(params, OG_REST_PARAM_ADDR))
- return -1;
-
- return og_send_request(OG_METHOD_POST, OG_CMD_PROBE, params, NULL);
-}
-
struct og_buffer {
char *data;
int len;
@@ -4613,1350 +4547,6 @@ static int og_cmd_setup(json_t *element, struct og_msg_params *params)
return og_send_request(OG_METHOD_POST, OG_CMD_SETUP, params, clients);
}
-static int og_cmd_run_schedule(json_t *element, struct og_msg_params *params)
-{
- const char *key;
- json_t *value;
- int err = 0;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "clients"))
- err = og_json_parse_clients(value, params);
-
- if (err < 0)
- return err;
- }
-
- if (!og_msg_params_validate(params, OG_REST_PARAM_ADDR))
- return -1;
-
- return og_send_request(OG_METHOD_GET, OG_CMD_RUN_SCHEDULE, params,
- NULL);
-}
-
-static LIST_HEAD(cmd_list);
-
-const struct og_cmd *og_cmd_find(const char *client_ip)
-{
- struct og_cmd *cmd, *next;
-
- list_for_each_entry_safe(cmd, next, &cmd_list, list) {
- if (strcmp(cmd->ip, client_ip))
- continue;
-
- list_del(&cmd->list);
- return cmd;
- }
-
- return NULL;
-}
-
-void og_cmd_free(const struct og_cmd *cmd)
-{
- struct og_msg_params *params = (struct og_msg_params *)&cmd->params;
- int i;
-
- for (i = 0; i < params->ips_array_len; i++) {
- free((void *)params->netmask_array[i]);
- free((void *)params->ips_array[i]);
- free((void *)params->mac_array[i]);
- }
- free((void *)params->wol_type);
-
- if (cmd->json)
- json_decref(cmd->json);
-
- free((void *)cmd->ip);
- free((void *)cmd->mac);
- free((void *)cmd);
-}
-
-static void og_cmd_init(struct og_cmd *cmd, enum og_rest_method method,
- enum og_cmd_type type, json_t *root)
-{
- cmd->type = type;
- cmd->method = method;
- cmd->params.ips_array[0] = strdup(cmd->ip);
- cmd->params.ips_array_len = 1;
- cmd->json = root;
- gettimeofday(&cmd->tv, NULL);
-}
-
-static int og_cmd_legacy_wol(const char *input, struct og_cmd *cmd)
-{
- char wol_type[2] = {};
- const char *msglog;
- struct og_dbi *dbi;
- dbi_result result;
-
- if (sscanf(input, "mar=%s", wol_type) != 1) {
- syslog(LOG_ERR, "malformed database legacy input\n");
- return -1;
- }
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open connection database (%s:%d)\n",
- __func__, __LINE__);
- return -1;
- }
-
- result = dbi_conn_queryf(dbi->conn,
- "SELECT aulas.netmask "
- "FROM ordenadores "
- "INNER JOIN aulas "
- "ON ordenadores.idaula = aulas.idaula "
- "WHERE ordenadores.ip = '%s'",
- cmd->ip);
- 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 -1;
- }
- dbi_result_next_row(result);
-
- og_cmd_init(cmd, OG_METHOD_NO_HTTP, OG_CMD_WOL, NULL);
- cmd->params.netmask_array[0] = dbi_result_get_string_copy(result,
- "netmask");
- cmd->params.mac_array[0] = strdup(cmd->mac);
- cmd->params.wol_type = strdup(wol_type);
-
- dbi_result_free(result);
- og_dbi_close(dbi);
-
- return 0;
-}
-
-static int og_cmd_legacy_shell_run(const char *input, struct og_cmd *cmd)
-{
- json_t *root, *script, *echo;
-
- script = json_string(input + 4);
- echo = json_boolean(false);
-
- root = json_object();
- if (!root)
- return -1;
- json_object_set_new(root, "run", script);
- json_object_set_new(root, "echo", echo);
-
- og_cmd_init(cmd, OG_METHOD_POST, OG_CMD_SHELL_RUN, root);
-
- return 0;
-}
-
-static int og_cmd_legacy_session(const char *input, struct og_cmd *cmd)
-{
- char part_str[OG_DB_SMALLINT_MAXLEN + 1];
- char disk_str[OG_DB_SMALLINT_MAXLEN + 1];
- json_t *root, *disk, *partition;
-
- if (sscanf(input, "dsk=%s\rpar=%s\r", disk_str, part_str) != 2)
- return -1;
- partition = json_string(part_str);
- disk = json_string(disk_str);
-
- root = json_object();
- if (!root)
- return -1;
- json_object_set_new(root, "partition", partition);
- json_object_set_new(root, "disk", disk);
-
- og_cmd_init(cmd, OG_METHOD_POST, OG_CMD_SESSION, root);
-
- return 0;
-}
-
-static int og_cmd_legacy_poweroff(const char *input, struct og_cmd *cmd)
-{
- og_cmd_init(cmd, OG_METHOD_POST, OG_CMD_POWEROFF, NULL);
-
- return 0;
-}
-
-static int og_cmd_legacy_refresh(const char *input, struct og_cmd *cmd)
-{
- og_cmd_init(cmd, OG_METHOD_GET, OG_CMD_REFRESH, NULL);
-
- return 0;
-}
-
-static int og_cmd_legacy_reboot(const char *input, struct og_cmd *cmd)
-{
- og_cmd_init(cmd, OG_METHOD_POST, OG_CMD_REBOOT, NULL);
-
- return 0;
-}
-
-static int og_cmd_legacy_stop(const char *input, struct og_cmd *cmd)
-{
- og_cmd_init(cmd, OG_METHOD_POST, OG_CMD_STOP, NULL);
-
- return 0;
-}
-
-static int og_cmd_legacy_hardware(const char *input, struct og_cmd *cmd)
-{
- og_cmd_init(cmd, OG_METHOD_GET, OG_CMD_HARDWARE, NULL);
-
- return 0;
-}
-
-static int og_cmd_legacy_software(const char *input, struct og_cmd *cmd)
-{
- char part_str[OG_DB_SMALLINT_MAXLEN + 1];
- char disk_str[OG_DB_SMALLINT_MAXLEN + 1];
- json_t *root, *disk, *partition;
-
- if (sscanf(input, "dsk=%s\rpar=%s\r", disk_str, part_str) != 2)
- return -1;
- partition = json_string(part_str);
- disk = json_string(disk_str);
-
- root = json_object();
- if (!root)
- return -1;
- json_object_set_new(root, "partition", partition);
- json_object_set_new(root, "disk", disk);
-
- og_cmd_init(cmd, OG_METHOD_GET, OG_CMD_SOFTWARE, root);
-
- return 0;
-}
-
-static int og_cmd_legacy_image_create(const char *input, struct og_cmd *cmd)
-{
- json_t *root, *disk, *partition, *code, *image_id, *name, *repo;
- struct og_image_legacy img = {};
-
- if (sscanf(input, "dsk=%s\rpar=%s\rcpt=%s\ridi=%s\rnci=%s\ripr=%s\r",
- img.disk, img.part, img.code, img.image_id, img.name,
- img.repo) != 6)
- return -1;
- image_id = json_string(img.image_id);
- partition = json_string(img.part);
- code = json_string(img.code);
- name = json_string(img.name);
- repo = json_string(img.repo);
- disk = json_string(img.disk);
-
- root = json_object();
- if (!root)
- return -1;
- json_object_set_new(root, "partition", partition);
- json_object_set_new(root, "repository", repo);
- json_object_set_new(root, "id", image_id);
- json_object_set_new(root, "code", code);
- json_object_set_new(root, "name", name);
- json_object_set_new(root, "disk", disk);
-
- og_cmd_init(cmd, OG_METHOD_POST, OG_CMD_IMAGE_CREATE, root);
-
- return 0;
-}
-
-#define OG_DB_RESTORE_TYPE_MAXLEN 64
-
-static int og_cmd_legacy_image_restore(const char *input, struct og_cmd *cmd)
-{
- json_t *root, *disk, *partition, *image_id, *name, *repo;
- char restore_type_str[OG_DB_RESTORE_TYPE_MAXLEN + 1] = {};
- char software_id_str[OG_DB_INT_MAXLEN + 1] = {};
- json_t *software_id, *restore_type;
- struct og_image_legacy img = {};
-
- if (sscanf(input,
- "dsk=%s\rpar=%s\ridi=%s\rnci=%s\r"
- "ipr=%s\rifs=%s\rptc=%[^\r]\r",
- img.disk, img.part, img.image_id, img.name, img.repo,
- software_id_str, restore_type_str) != 7)
- return -1;
-
- restore_type = json_string(restore_type_str);
- software_id = json_string(software_id_str);
- image_id = json_string(img.image_id);
- partition = json_string(img.part);
- name = json_string(img.name);
- repo = json_string(img.repo);
- disk = json_string(img.disk);
-
- root = json_object();
- if (!root)
- return -1;
- json_object_set_new(root, "profile", software_id);
- json_object_set_new(root, "partition", partition);
- json_object_set_new(root, "type", restore_type);
- json_object_set_new(root, "repository", repo);
- json_object_set_new(root, "id", image_id);
- json_object_set_new(root, "name", name);
- json_object_set_new(root, "disk", disk);
-
- og_cmd_init(cmd, OG_METHOD_POST, OG_CMD_IMAGE_RESTORE, root);
-
- return 0;
-}
-
-#define OG_PARTITION_TABLE_TYPE_MAXLEN 5
-
-static int og_cmd_legacy_setup(const char *input, struct og_cmd *cmd)
-{
- json_t *root, *disk, *cache, *cache_size, *partition_setup, *object;
- char part_table_type_str[OG_PARTITION_TABLE_TYPE_MAXLEN + 1];
- struct og_legacy_partition part_cfg[OG_PARTITION_MAX] = {};
- json_t *part_table_type, *part, *code, *fs, *size, *format;
- char cache_size_str [OG_DB_INT_MAXLEN + 1];
- char disk_str [OG_DB_SMALLINT_MAXLEN + 1];
- unsigned int partition_len = 0;
- const char *in_ptr;
- char cache_str[2];
-
- if (sscanf(input, "ttp=%s\rdsk=%s\rcfg=dis=%*[^*]*che=%[^*]*tch=%[^!]!",
- part_table_type_str, disk_str, cache_str, cache_size_str) != 4)
- return -1;
-
- in_ptr = strstr(input, "!") + 1;
- while (strlen(in_ptr) > 0) {
- if(sscanf(in_ptr,
- "par=%[^*]*cpt=%[^*]*sfi=%[^*]*tam=%[^*]*ope=%[^%%]%%",
- part_cfg[partition_len].partition,
- part_cfg[partition_len].code,
- part_cfg[partition_len].filesystem,
- part_cfg[partition_len].size,
- part_cfg[partition_len].format) != 5)
- return -1;
- in_ptr = strstr(in_ptr, "%") + 1;
- partition_len++;
- }
-
- root = json_object();
- if (!root)
- return -1;
-
- part_table_type = json_string(part_table_type_str);
- cache_size = json_string(cache_size_str);
- cache = json_string(cache_str);
- partition_setup = json_array();
- disk = json_string(disk_str);
-
- for (unsigned int i = 0; i < partition_len; ++i) {
- object = json_object();
- if (!object) {
- json_decref(root);
- return -1;
- }
-
- part = json_string(part_cfg[i].partition);
- fs = json_string(part_cfg[i].filesystem);
- format = json_string(part_cfg[i].format);
- code = json_string(part_cfg[i].code);
- size = json_string(part_cfg[i].size);
-
- json_object_set_new(object, "partition", part);
- json_object_set_new(object, "filesystem", fs);
- json_object_set_new(object, "format", format);
- json_object_set_new(object, "code", code);
- json_object_set_new(object, "size", size);
-
- json_array_append_new(partition_setup, object);
- }
-
- json_object_set_new(root, "partition_setup", partition_setup);
- json_object_set_new(root, "cache_size", cache_size);
- json_object_set_new(root, "type", part_table_type);
- json_object_set_new(root, "cache", cache);
- json_object_set_new(root, "disk", disk);
-
- og_cmd_init(cmd, OG_METHOD_POST, OG_CMD_SETUP, root);
-
- return 0;
-}
-
-static int og_cmd_legacy_run_schedule(const char *input, struct og_cmd *cmd)
-{
- og_cmd_init(cmd, OG_METHOD_GET, OG_CMD_RUN_SCHEDULE, NULL);
-
- return 0;
-}
-
-static int og_cmd_legacy(const char *input, struct og_cmd *cmd)
-{
- char legacy_cmd[32] = {};
- int err = -1;
-
- if (sscanf(input, "nfn=%31s\r", legacy_cmd) != 1) {
- syslog(LOG_ERR, "malformed database legacy input\n");
- return -1;
- }
- input = strchr(input, '\r') + 1;
-
- if (!strcmp(legacy_cmd, "Arrancar")) {
- err = og_cmd_legacy_wol(input, cmd);
- } else if (!strcmp(legacy_cmd, "EjecutarScript")) {
- err = og_cmd_legacy_shell_run(input, cmd);
- } else if (!strcmp(legacy_cmd, "IniciarSesion")) {
- err = og_cmd_legacy_session(input, cmd);
- } else if (!strcmp(legacy_cmd, "Apagar")) {
- err = og_cmd_legacy_poweroff(input, cmd);
- } else if (!strcmp(legacy_cmd, "Actualizar")) {
- err = og_cmd_legacy_refresh(input, cmd);
- } else if (!strcmp(legacy_cmd, "Reiniciar")) {
- err = og_cmd_legacy_reboot(input, cmd);
- } else if (!strcmp(legacy_cmd, "Purgar")) {
- err = og_cmd_legacy_stop(input, cmd);
- } else if (!strcmp(legacy_cmd, "InventarioHardware")) {
- err = og_cmd_legacy_hardware(input, cmd);
- } else if (!strcmp(legacy_cmd, "InventarioSoftware")) {
- err = og_cmd_legacy_software(input, cmd);
- } else if (!strcmp(legacy_cmd, "CrearImagen")) {
- err = og_cmd_legacy_image_create(input, cmd);
- } else if (!strcmp(legacy_cmd, "RestaurarImagen")) {
- err = og_cmd_legacy_image_restore(input, cmd);
- } else if (!strcmp(legacy_cmd, "Configurar")) {
- err = og_cmd_legacy_setup(input, cmd);
- } else if (!strcmp(legacy_cmd, "EjecutaComandosPendientes") ||
- !strcmp(legacy_cmd, "Actualizar")) {
- err = og_cmd_legacy_run_schedule(input, cmd);
- }
-
- return err;
-}
-
-static int og_dbi_add_action(const struct og_dbi *dbi, struct og_task *task,
- struct og_cmd *cmd)
-{
- char start_date_string[24];
- struct tm *start_date;
- const char *msglog;
- dbi_result result;
- time_t now;
-
- time(&now);
- start_date = localtime(&now);
-
- sprintf(start_date_string, "%hu/%hhu/%hhu %hhu:%hhu:%hhu",
- start_date->tm_year + 1900, start_date->tm_mon + 1,
- start_date->tm_mday, start_date->tm_hour, start_date->tm_min,
- start_date->tm_sec);
- result = dbi_conn_queryf(dbi->conn,
- "INSERT INTO acciones (idordenador, "
- "tipoaccion, idtipoaccion, descriaccion, ip, "
- "sesion, idcomando, parametros, fechahorareg, "
- "estado, resultado, ambito, idambito, "
- "restrambito, idprocedimiento, idcentro, "
- "idprogramacion) "
- "VALUES (%d, %d, %d, '%s', '%s', %d, %d, '%s', "
- "'%s', %d, %d, %d, %d, '%s', %d, %d, %d)",
- cmd->client_id, EJECUCION_TAREA, task->task_id,
- "", cmd->ip, task->session, task->command_id,
- task->params, start_date_string,
- ACCION_INICIADA, ACCION_SINRESULTADO,
- task->type_scope, task->scope, "",
- task->procedure_id, task->center_id,
- task->schedule_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;
- }
-
- cmd->id = dbi_conn_sequence_last(dbi->conn, NULL);
- if (!task->session) {
- task->session = cmd->id;
- dbi_result_free(result);
- result = dbi_conn_queryf(dbi->conn,
- "UPDATE acciones SET sesion=%d "
- "WHERE idaccion=%d",
- task->session, cmd->id);
- }
-
- dbi_result_free(result);
-
- return 0;
-}
-
-static int og_queue_task_command(struct og_dbi *dbi, struct og_task *task,
- char *query)
-{
- struct og_cmd *cmd;
- const char *msglog;
- dbi_result result;
-
- result = dbi_conn_queryf(dbi->conn, query);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- return -1;
- }
-
- while (dbi_result_next_row(result)) {
- cmd = (struct og_cmd *)calloc(1, sizeof(struct og_cmd));
- if (!cmd) {
- dbi_result_free(result);
- return -1;
- }
-
- cmd->client_id = dbi_result_get_uint(result, "idordenador");
- cmd->ip = strdup(dbi_result_get_string(result, "ip"));
- cmd->mac = strdup(dbi_result_get_string(result, "mac"));
-
- og_cmd_legacy(task->params, cmd);
-
- if (task->procedure_id) {
- if (og_dbi_add_action(dbi, task, cmd)) {
- dbi_result_free(result);
- return -1;
- }
- } else {
- cmd->id = task->task_id;
- }
-
- list_add_tail(&cmd->list, &cmd_list);
- }
-
- dbi_result_free(result);
-
- return 0;
-}
-
-static int og_queue_task_group_clients(struct og_dbi *dbi, struct og_task *task,
- char *query)
-{
-
- const char *msglog;
- dbi_result result;
-
- result = dbi_conn_queryf(dbi->conn, query);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- return -1;
- }
-
- while (dbi_result_next_row(result)) {
- uint32_t group_id = dbi_result_get_uint(result, "idgrupo");
-
- sprintf(query, "SELECT idgrupo FROM gruposordenadores "
- "WHERE grupoid=%d", group_id);
- if (og_queue_task_group_clients(dbi, task, query)) {
- dbi_result_free(result);
- return -1;
- }
-
- sprintf(query,"SELECT ip, mac, idordenador FROM ordenadores "
- "WHERE grupoid=%d", group_id);
- if (og_queue_task_command(dbi, task, query)) {
- dbi_result_free(result);
- return -1;
- }
-
- }
-
- dbi_result_free(result);
-
- return 0;
-}
-
-static int og_queue_task_group_classrooms(struct og_dbi *dbi,
- struct og_task *task, char *query)
-{
-
- const char *msglog;
- dbi_result result;
-
- result = dbi_conn_queryf(dbi->conn, query);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- return -1;
- }
-
- while (dbi_result_next_row(result)) {
- uint32_t group_id = dbi_result_get_uint(result, "idgrupo");
-
- sprintf(query, "SELECT idgrupo FROM grupos "
- "WHERE grupoid=%d AND tipo=%d", group_id, AMBITO_GRUPOSAULAS);
- if (og_queue_task_group_classrooms(dbi, task, query)) {
- dbi_result_free(result);
- return -1;
- }
-
- sprintf(query,
- "SELECT ip,mac,idordenador "
- "FROM ordenadores INNER JOIN aulas "
- "WHERE ordenadores.idaula=aulas.idaula "
- "AND aulas.grupoid=%d",
- group_id);
- if (og_queue_task_command(dbi, task, query)) {
- dbi_result_free(result);
- return -1;
- }
-
- }
-
- dbi_result_free(result);
-
- return 0;
-}
-
-static int og_queue_task_clients(struct og_dbi *dbi, struct og_task *task)
-{
- char query[4096];
-
- switch (task->type_scope) {
- case AMBITO_CENTROS:
- sprintf(query,
- "SELECT ip,mac,idordenador "
- "FROM ordenadores INNER JOIN aulas "
- "WHERE ordenadores.idaula=aulas.idaula "
- "AND idcentro=%d",
- task->scope);
- return og_queue_task_command(dbi, task, query);
- case AMBITO_GRUPOSAULAS:
- sprintf(query,
- "SELECT idgrupo FROM grupos "
- "WHERE idgrupo=%i AND tipo=%d",
- task->scope, AMBITO_GRUPOSAULAS);
- return og_queue_task_group_classrooms(dbi, task, query);
- case AMBITO_AULAS:
- sprintf(query,
- "SELECT ip,mac,idordenador FROM ordenadores "
- "WHERE idaula=%d",
- task->scope);
- return og_queue_task_command(dbi, task, query);
- case AMBITO_GRUPOSORDENADORES:
- sprintf(query,
- "SELECT idgrupo FROM gruposordenadores "
- "WHERE idgrupo = %d",
- task->scope);
- return og_queue_task_group_clients(dbi, task, query);
- case AMBITO_ORDENADORES:
- sprintf(query,
- "SELECT ip, mac, idordenador FROM ordenadores "
- "WHERE idordenador = %d",
- task->scope);
- return og_queue_task_command(dbi, task, query);
- }
- return 0;
-}
-
-int og_dbi_queue_procedure(struct og_dbi *dbi, struct og_task *task)
-{
- uint32_t procedure_id;
- const char *msglog;
- dbi_result result;
-
- result = dbi_conn_queryf(dbi->conn,
- "SELECT parametros, procedimientoid, idcomando "
- "FROM procedimientos_acciones "
- "WHERE idprocedimiento=%d ORDER BY orden", task->procedure_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;
- }
-
- while (dbi_result_next_row(result)) {
- procedure_id = dbi_result_get_uint(result, "procedimientoid");
- if (procedure_id > 0) {
- task->procedure_id = procedure_id;
- if (og_dbi_queue_procedure(dbi, task))
- return -1;
- continue;
- }
-
- task->params = dbi_result_get_string(result, "parametros");
- task->command_id = dbi_result_get_uint(result, "idcomando");
- if (og_queue_task_clients(dbi, task))
- return -1;
- }
-
- dbi_result_free(result);
-
- return 0;
-}
-
-static int og_dbi_queue_task(struct og_dbi *dbi, uint32_t task_id,
- uint32_t schedule_id)
-{
- struct og_task task = {};
- uint32_t task_id_next;
- const char *msglog;
- dbi_result result;
-
- task.schedule_id = schedule_id;
-
- result = dbi_conn_queryf(dbi->conn,
- "SELECT tareas_acciones.orden, "
- "tareas_acciones.idprocedimiento, "
- "tareas_acciones.tareaid, "
- "tareas.idtarea, "
- "tareas.idcentro, "
- "tareas.ambito, "
- "tareas.idambito, "
- "tareas.restrambito "
- " FROM tareas"
- " INNER JOIN tareas_acciones ON tareas_acciones.idtarea=tareas.idtarea"
- " WHERE tareas_acciones.idtarea=%u ORDER BY tareas_acciones.orden ASC", task_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;
- }
-
- while (dbi_result_next_row(result)) {
- task_id_next = dbi_result_get_uint(result, "tareaid");
-
- if (task_id_next > 0) {
- if (og_dbi_queue_task(dbi, task_id_next, schedule_id))
- return -1;
-
- continue;
- }
- task.task_id = dbi_result_get_uint(result, "idtarea");
- task.center_id = dbi_result_get_uint(result, "idcentro");
- task.procedure_id = dbi_result_get_uint(result, "idprocedimiento");
- task.type_scope = dbi_result_get_uint(result, "ambito");
- task.scope = dbi_result_get_uint(result, "idambito");
- task.filtered_scope = dbi_result_get_string(result, "restrambito");
-
- og_dbi_queue_procedure(dbi, &task);
- }
-
- dbi_result_free(result);
-
- return 0;
-}
-
-static int og_dbi_queue_command(struct og_dbi *dbi, uint32_t task_id,
- uint32_t schedule_id)
-{
- struct og_task task = {};
- const char *msglog;
- dbi_result result;
- char query[4096];
-
- result = dbi_conn_queryf(dbi->conn,
- "SELECT idaccion, idcentro, idordenador, parametros "
- "FROM acciones "
- "WHERE sesion = %u", task_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;
- }
-
- while (dbi_result_next_row(result)) {
- task.task_id = dbi_result_get_uint(result, "idaccion");
- task.center_id = dbi_result_get_uint(result, "idcentro");
- task.scope = dbi_result_get_uint(result, "idordenador");
- task.params = dbi_result_get_string(result, "parametros");
-
- sprintf(query,
- "SELECT ip, mac, idordenador FROM ordenadores "
- "WHERE idordenador = %d",
- task.scope);
- if (og_queue_task_command(dbi, &task, query)) {
- dbi_result_free(result);
- return -1;
- }
- }
-
- dbi_result_free(result);
-
- return 0;
-}
-
-int og_dbi_update_action(uint32_t id, bool success)
-{
- char end_date_string[24];
- struct tm *end_date;
- const char *msglog;
- struct og_dbi *dbi;
- uint8_t status = 2;
- dbi_result result;
- time_t now;
-
- if (!id)
- return 0;
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open connection database (%s:%d)\n",
- __func__, __LINE__);
- return -1;
- }
-
- time(&now);
- end_date = localtime(&now);
-
- sprintf(end_date_string, "%hu/%hhu/%hhu %hhu:%hhu:%hhu",
- end_date->tm_year + 1900, end_date->tm_mon + 1,
- end_date->tm_mday, end_date->tm_hour, end_date->tm_min,
- end_date->tm_sec);
- result = dbi_conn_queryf(dbi->conn,
- "UPDATE acciones SET fechahorafin='%s', "
- "estado=%d, resultado=%d WHERE idaccion=%d",
- end_date_string, ACCION_FINALIZADA,
- status - success, id);
-
- 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 -1;
- }
- dbi_result_free(result);
- og_dbi_close(dbi);
-
- return 0;
-}
-
-void og_schedule_run(unsigned int task_id, unsigned int schedule_id,
- enum og_schedule_type type)
-{
- struct og_msg_params params = {};
- struct in_addr addr, netmask;
- struct og_cmd *cmd, *next;
- bool duplicated = false;
- struct og_dbi *dbi;
- unsigned int i;
- int sd;
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open connection database (%s:%d)\n",
- __func__, __LINE__);
- return;
- }
-
- switch (type) {
- case OG_SCHEDULE_TASK:
- og_dbi_queue_task(dbi, task_id, schedule_id);
- break;
- case OG_SCHEDULE_PROCEDURE:
- case OG_SCHEDULE_COMMAND:
- og_dbi_queue_command(dbi, task_id, schedule_id);
- break;
- }
- og_dbi_close(dbi);
-
- list_for_each_entry(cmd, &cmd_list, list) {
- for (i = 0; i < params.ips_array_len; i++) {
- if (!strncmp(cmd->ip, params.ips_array[i],
- OG_DB_IP_MAXLEN)) {
- duplicated = true;
- break;
- }
- }
-
- if (!duplicated)
- params.ips_array[params.ips_array_len++] = strdup(cmd->ip);
- else
- duplicated = false;
- }
-
- sd = wol_socket_open();
- if (sd < 0) {
- syslog(LOG_ERR, "cannot open wol socket (%s:%d)\n",
- __func__, __LINE__);
- goto err_out;
- }
-
- list_for_each_entry_safe(cmd, next, &cmd_list, list) {
- if (cmd->type != OG_CMD_WOL)
- continue;
-
- for (i = 0; i < cmd->params.ips_array_len; i++) {
- if (inet_aton(cmd->params.ips_array[i], &addr) < 0)
- continue;
- if (inet_aton(cmd->params.netmask_array[i], &netmask) < 0)
- continue;
-
- if (wake_up(sd, &addr, &netmask,
- cmd->params.mac_array[i],
- atoi(cmd->params.wol_type)) < 0) {
- syslog(LOG_ERR, "Failed to send wol packet to %s\n",
- params.ips_array[i]);
- continue;
- }
- og_dbi_update_action(cmd->id, true);
- }
-
- list_del(&cmd->list);
- og_cmd_free(cmd);
- }
-
- close(sd);
-
- og_send_request(OG_METHOD_GET, OG_CMD_RUN_SCHEDULE, &params, NULL);
-
-err_out:
- for (i = 0; i < params.ips_array_len; i++)
- free((void *)params.ips_array[i]);
-}
-
-static int og_cmd_task_post(json_t *element, struct og_msg_params *params)
-{
- struct og_cmd *cmd;
- struct og_dbi *dbi;
- const char *key;
- json_t *value;
- int err = 0;
-
- if (json_typeof(element) != JSON_OBJECT)
- return -1;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "task")) {
- err = og_json_parse_string(value, &params->task_id);
- params->flags |= OG_REST_PARAM_TASK;
- }
-
- if (err < 0)
- return err;
- }
-
- if (!og_msg_params_validate(params, OG_REST_PARAM_TASK))
- return -1;
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open connection database (%s:%d)\n",
- __func__, __LINE__);
- return -1;
- }
-
- og_schedule_run(atoi(params->task_id), 0, OG_SCHEDULE_TASK);
- og_dbi_close(dbi);
-
- list_for_each_entry(cmd, &cmd_list, list)
- params->ips_array[params->ips_array_len++] = cmd->ip;
-
- return og_send_request(OG_METHOD_GET, OG_CMD_RUN_SCHEDULE, params,
- NULL);
-}
-
-#define OG_QUERY_MAXLEN 4096
-
-static int og_dbi_scope_get_computer(const struct og_dbi *dbi, json_t *array,
- const char* query)
-{
- const char *computer_name, *computer_ip;
- uint32_t computer_id;
- const char *msglog;
- dbi_result result;
- json_t *computer;
-
- result = dbi_conn_queryf(dbi->conn, query);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- return -1;
- }
-
- while (dbi_result_next_row(result)) {
- computer_id = dbi_result_get_uint(result, "idordenador");
- computer_name = dbi_result_get_string(result, "nombreordenador");
- computer_ip = dbi_result_get_string(result, "ip");
-
- computer = json_object();
- if (!computer) {
- dbi_result_free(result);
- return -1;
- }
-
- json_object_set_new(computer, "name", json_string(computer_name));
- json_object_set_new(computer, "type", json_string("computer"));
- json_object_set_new(computer, "id", json_integer(computer_id));
- json_object_set_new(computer, "scope", json_array());
- json_object_set_new(computer, "ip", json_string(computer_ip));
- json_array_append(array, computer);
- json_decref(computer);
- }
- dbi_result_free(result);
-
- return 0;
-}
-
-static int og_dbi_scope_get_computer_from_room(const struct og_dbi *dbi,
- json_t *array, char *query,
- const uint32_t room_id)
-{
- int ret = snprintf(query, OG_QUERY_MAXLEN,
- "SELECT idordenador, nombreordenador, ip "
- "FROM ordenadores WHERE idaula=%d and grupoid=0",
- room_id);
- if (ret <= 0 || ret >= OG_QUERY_MAXLEN)
- return -1;
-
- return og_dbi_scope_get_computer(dbi, array, query);
-}
-
-static int og_dbi_scope_get_computer_from_computers(const struct og_dbi *dbi,
- json_t *array,
- char *query,
- const uint32_t computers_id)
-{
- int ret = snprintf(query, OG_QUERY_MAXLEN,
- "SELECT idordenador, nombreordenador, ip "
- "FROM ordenadores WHERE grupoid=%d",
- computers_id);
- if (ret <= 0 || ret >= OG_QUERY_MAXLEN)
- return -1;
-
- return og_dbi_scope_get_computer(dbi, array, query);
-}
-
-static int og_dbi_scope_get_computers_from_computers(const struct og_dbi *dbi,
- json_t *array,
- char *query,
- const uint32_t group_id);
-
-static int og_dbi_scope_get_computers(const struct og_dbi *dbi, json_t *array,
- char *query, bool in_room)
-{
- const char *msglog, *computers_name;
- json_t *computers, *scope_array;
- uint32_t computers_id;
- uint32_t marker = 0;
- dbi_result result;
-
- if (in_room)
- marker = OG_COMPUTER_FOLDER_MARKER;
-
- result = dbi_conn_queryf(dbi->conn, query);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- return -1;
- }
-
- while (dbi_result_next_row(result)) {
- computers_id = dbi_result_get_uint(result, "idgrupo");
- computers_name = dbi_result_get_string(result,
- "nombregrupoordenador");
-
- computers = json_object();
- if (!computers) {
- dbi_result_free(result);
- return -1;
- }
-
- json_object_set_new(computers, "name",
- json_string(computers_name));
- json_object_set_new(computers, "type", json_string("folder"));
- json_object_set_new(computers, "id",
- json_integer(computers_id | marker));
- json_object_set_new(computers, "scope", json_array());
- json_array_append(array, computers);
- json_decref(computers);
-
- scope_array = json_object_get(computers, "scope");
- if (!scope_array) {
- dbi_result_free(result);
- return -1;
- }
-
- if (og_dbi_scope_get_computers_from_computers(dbi,
- scope_array,
- query,
- computers_id)) {
- dbi_result_free(result);
- return -1;
- }
-
- if (og_dbi_scope_get_computer_from_computers(dbi,
- scope_array,
- query,
- computers_id)) {
- dbi_result_free(result);
- return -1;
- }
- }
- dbi_result_free(result);
-
- return 0;
-}
-
-static int og_dbi_scope_get_computers_from_room(const struct og_dbi *dbi,
- json_t *array, char *query,
- const uint32_t room_id)
-{
- int ret = snprintf(query, OG_QUERY_MAXLEN,
- "SELECT idgrupo, nombregrupoordenador "
- "FROM gruposordenadores "
- "WHERE idaula=%d AND grupoid=0",
- room_id);
- if (ret <= 0 || ret >= OG_QUERY_MAXLEN)
- return -1;
-
- return og_dbi_scope_get_computers(dbi, array, query, true);
-}
-
-static int og_dbi_scope_get_computers_from_computers(const struct og_dbi *dbi,
- json_t *array,
- char *query,
- const uint32_t group_id)
-{
- int ret = snprintf(query, OG_QUERY_MAXLEN,
- "SELECT idgrupo, nombregrupoordenador "
- "FROM gruposordenadores WHERE grupoid=%d",
- group_id);
- if (ret <= 0 || ret >= OG_QUERY_MAXLEN)
- return -1;
-
- return og_dbi_scope_get_computers(dbi, array, query, false);
-}
-
-static int og_dbi_scope_get_room(const struct og_dbi *dbi, json_t *array,
- char *query)
-{
- const char *msglog, *room_name;
- json_t *room, *scope_array;
- dbi_result result;
- uint32_t room_id;
-
- result = dbi_conn_queryf(dbi->conn, query);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- return -1;
- }
-
- while (dbi_result_next_row(result)) {
- room_id = dbi_result_get_uint(result, "idaula");
- room_name = dbi_result_get_string(result, "nombreaula");
-
- room = json_object();
- if (!room) {
- dbi_result_free(result);
- return -1;
- }
-
- json_object_set_new(room, "name", json_string(room_name));
- json_object_set_new(room, "type", json_string("room"));
- json_object_set_new(room, "id", json_integer(room_id));
- json_object_set_new(room, "scope", json_array());
- json_array_append(array, room);
- json_decref(room);
-
- scope_array = json_object_get(room, "scope");
- if (!scope_array) {
- dbi_result_free(result);
- return -1;
- }
-
- if (og_dbi_scope_get_computers_from_room(dbi, scope_array,
- query, room_id)) {
- dbi_result_free(result);
- return -1;
- }
-
- if (og_dbi_scope_get_computer_from_room(dbi, scope_array,
- query, room_id)) {
- dbi_result_free(result);
- return -1;
- }
- }
- dbi_result_free(result);
-
- return 0;
-}
-
-static int og_dbi_scope_get_room_from_group(const struct og_dbi *dbi,
- json_t *array,
- char *query,
- const uint32_t group_id)
-{
- int ret = snprintf(query, OG_QUERY_MAXLEN,
- "SELECT idaula, nombreaula "
- "FROM aulas WHERE grupoid=%d", group_id);
- if (ret <= 0 || ret >= OG_QUERY_MAXLEN)
- return -1;
-
- return og_dbi_scope_get_room(dbi, array, query);
-}
-
-static int og_dbi_scope_get_room_from_center(const struct og_dbi *dbi,
- json_t *array,
- char *query,
- const uint32_t center_id)
-{
- int ret = snprintf(query, OG_QUERY_MAXLEN,
- "SELECT idaula, nombreaula "
- "FROM aulas WHERE idcentro=%d AND grupoid=0",
- center_id);
- if (ret <= 0 || ret >= OG_QUERY_MAXLEN)
- return -1;
-
- return og_dbi_scope_get_room(dbi, array, query);
-}
-
-static int og_dbi_scope_get_group_from_group(const struct og_dbi *dbi,
- json_t *array,
- char *query,
- const uint32_t group_id);
-
-static int og_dbi_scope_get_group(const struct og_dbi *dbi,
- json_t *array,
- char *query)
-{
- const char *msglog, *group_name;
- json_t *group, *scope_array;
- dbi_result result;
- uint32_t group_id;
-
- result = dbi_conn_queryf(dbi->conn, query);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- return -1;
- }
-
- while (dbi_result_next_row(result)) {
- group_id = dbi_result_get_uint(result, "idgrupo");
- group_name = dbi_result_get_string(result, "nombregrupo");
-
- group = json_object();
- if (!group) {
- dbi_result_free(result);
- return -1;
- }
-
- json_object_set_new(group, "name", json_string(group_name));
- json_object_set_new(group, "type", json_string("folder"));
- json_object_set_new(group, "id", json_integer(group_id));
- json_object_set_new(group, "scope", json_array());
- json_array_append(array, group);
- json_decref(group);
-
- scope_array = json_object_get(group, "scope");
- if (!scope_array) {
- dbi_result_free(result);
- return -1;
- }
-
- if (og_dbi_scope_get_group_from_group(dbi, scope_array, query,
- group_id)) {
- dbi_result_free(result);
- return -1;
- }
-
- if (og_dbi_scope_get_room_from_group(dbi, scope_array, query,
- group_id)) {
- dbi_result_free(result);
- return -1;
- }
- }
- dbi_result_free(result);
-
- return 0;
-}
-
-static int og_dbi_scope_get_group_from_group(const struct og_dbi *dbi,
- json_t *array,
- char *query,
- const uint32_t group_id)
-{
- int ret = snprintf(query, OG_QUERY_MAXLEN,
- "SELECT idgrupo, nombregrupo "
- "FROM grupos WHERE grupoid=%d", group_id);
- if (ret <= 0 || ret >= OG_QUERY_MAXLEN)
- return -1;
-
- return og_dbi_scope_get_group(dbi, array, query);
-}
-
-static int og_dbi_scope_get_group_from_center(const struct og_dbi *dbi,
- json_t *array,
- char *query,
- const uint32_t center_id)
-{
- int group_type_room = 2;
- int ret = snprintf(query, OG_QUERY_MAXLEN,
- "SELECT idgrupo, nombregrupo "
- "FROM grupos "
- "WHERE idcentro=%d AND grupoid=0 AND tipo=%d",
- center_id, group_type_room);
- if (ret <= 0 || ret >= OG_QUERY_MAXLEN)
- return -1;
-
- return og_dbi_scope_get_group(dbi, array, query);
-}
-
-static int og_dbi_scope_get(struct og_dbi *dbi, json_t *array)
-{
- const char *msglog, *center_name;
- json_t *center, *scope_array;
- char query[OG_QUERY_MAXLEN];
- uint32_t center_id;
- dbi_result result;
-
- result = dbi_conn_queryf(dbi->conn,
- "SELECT nombrecentro, idcentro FROM centros");
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- return -1;
- }
-
- while (dbi_result_next_row(result)) {
- center_id = dbi_result_get_uint(result, "idcentro");
- center_name = dbi_result_get_string(result, "nombrecentro");
-
- center = json_object();
- if (!center) {
- dbi_result_free(result);
- return -1;
- }
-
- scope_array = json_array();
- if (!scope_array) {
- dbi_result_free(result);
- json_decref(center);
- return -1;
- }
-
- json_object_set_new(center, "name", json_string(center_name));
- json_object_set_new(center, "type", json_string("center"));
- json_object_set_new(center, "id", json_integer(center_id));
- json_object_set_new(center, "scope", scope_array);
- json_array_append(array, center);
- json_decref(center);
-
- if (og_dbi_scope_get_group_from_center(dbi, scope_array, query,
- center_id)) {
- dbi_result_free(result);
- return -1;
- }
-
- if (og_dbi_scope_get_room_from_center(dbi, scope_array, query,
- center_id)) {
- dbi_result_free(result);
- return -1;
- }
- }
-
- dbi_result_free(result);
-
- return 0;
-}
-
static int og_cmd_scope_get(json_t *element, struct og_msg_params *params,
char *buffer_reply)
{
@@ -6003,576 +4593,6 @@ static int og_cmd_scope_get(json_t *element, struct og_msg_params *params,
return 0;
}
-int og_dbi_schedule_get(void)
-{
- uint32_t schedule_id, task_id;
- struct og_schedule_time time;
- struct og_dbi *dbi;
- const char *msglog;
- dbi_result result;
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open connection database (%s:%d)\n",
- __func__, __LINE__);
- return -1;
- }
-
- result = dbi_conn_queryf(dbi->conn,
- "SELECT idprogramacion, tipoaccion, identificador, "
- "sesion, annos, meses, diario, dias, semanas, horas, "
- "ampm, minutos FROM programaciones "
- "WHERE suspendida = 0");
- 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 -1;
- }
-
- while (dbi_result_next_row(result)) {
- memset(&time, 0, sizeof(time));
- schedule_id = dbi_result_get_uint(result, "idprogramacion");
- task_id = dbi_result_get_uint(result, "identificador");
- time.years = dbi_result_get_uint(result, "annos");
- time.months = dbi_result_get_uint(result, "meses");
- time.weeks = dbi_result_get_uint(result, "semanas");
- time.week_days = dbi_result_get_uint(result, "dias");
- time.days = dbi_result_get_uint(result, "diario");
- time.hours = dbi_result_get_uint(result, "horas");
- time.am_pm = dbi_result_get_uint(result, "ampm");
- time.minutes = dbi_result_get_uint(result, "minutos");
- time.check_stale = true;
-
- og_schedule_create(schedule_id, task_id, OG_SCHEDULE_TASK,
- &time);
- }
-
- dbi_result_free(result);
- og_dbi_close(dbi);
-
- return 0;
-}
-
-static int og_dbi_schedule_create(struct og_dbi *dbi,
- struct og_msg_params *params,
- uint32_t *schedule_id,
- enum og_schedule_type schedule_type)
-{
- uint8_t suspended = 0;
- uint32_t session = 0;
- const char *msglog;
- dbi_result result;
- uint8_t type;
-
- switch (schedule_type) {
- case OG_SCHEDULE_TASK:
- type = 3;
- break;
- case OG_SCHEDULE_PROCEDURE:
- type = 2;
- break;
- case OG_SCHEDULE_COMMAND:
- session = atoi(params->task_id);
- type = 1;
- break;
- }
-
- result = dbi_conn_queryf(dbi->conn,
- "INSERT INTO programaciones (tipoaccion,"
- " identificador, nombrebloque, annos, meses,"
- " semanas, dias, diario, horas, ampm, minutos,"
- " suspendida, sesion) VALUES (%d, %s, '%s',"
- " %d, %d, %d, %d, %d, %d, %d, %d, %d, %d)",
- type, params->task_id, params->name,
- params->time.years, params->time.months,
- params->time.weeks, params->time.week_days,
- params->time.days, params->time.hours,
- params->time.am_pm, params->time.minutes,
- suspended, session);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- return -1;
- }
- dbi_result_free(result);
-
- *schedule_id = dbi_conn_sequence_last(dbi->conn, NULL);
-
- return 0;
-}
-
-static int og_dbi_schedule_update(struct og_dbi *dbi,
- struct og_msg_params *params)
-{
- const char *msglog;
- dbi_result result;
- uint8_t type = 3;
-
- result = dbi_conn_queryf(dbi->conn,
- "UPDATE programaciones SET tipoaccion=%d, "
- "identificador='%s', nombrebloque='%s', "
- "annos=%d, meses=%d, "
- "diario=%d, horas=%d, ampm=%d, minutos=%d "
- "WHERE idprogramacion='%s'",
- type, params->task_id, params->name,
- params->time.years, params->time.months,
- params->time.days, params->time.hours,
- params->time.am_pm, params->time.minutes,
- params->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;
- }
- dbi_result_free(result);
-
- return 0;
-}
-
-static int og_dbi_schedule_delete(struct og_dbi *dbi, uint32_t id)
-{
- const char *msglog;
- dbi_result result;
-
- result = dbi_conn_queryf(dbi->conn,
- "DELETE FROM programaciones WHERE idprogramacion=%d",
- 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;
- }
- dbi_result_free(result);
-
- return 0;
-}
-
-struct og_db_schedule {
- uint32_t id;
- uint32_t task_id;
- const char *name;
- struct og_schedule_time time;
- uint32_t week_days;
- uint32_t weeks;
- uint32_t suspended;
- uint32_t session;
-};
-
-static int og_dbi_schedule_get_json(struct og_dbi *dbi, json_t *root,
- const char *task_id, const char *schedule_id)
-{
- struct og_db_schedule schedule;
- json_t *obj, *array;
- const char *msglog;
- dbi_result result;
- int err = 0;
-
- if (task_id) {
- result = dbi_conn_queryf(dbi->conn,
- "SELECT idprogramacion,"
- " identificador, nombrebloque,"
- " annos, meses, diario, dias,"
- " semanas, horas, ampm,"
- " minutos,suspendida, sesion "
- "FROM programaciones "
- "WHERE identificador=%d",
- atoi(task_id));
- } else if (schedule_id) {
- result = dbi_conn_queryf(dbi->conn,
- "SELECT idprogramacion,"
- " identificador, nombrebloque,"
- " annos, meses, diario, dias,"
- " semanas, horas, ampm,"
- " minutos,suspendida, sesion "
- "FROM programaciones "
- "WHERE idprogramacion=%d",
- atoi(schedule_id));
- } else {
- result = dbi_conn_queryf(dbi->conn,
- "SELECT idprogramacion,"
- " identificador, nombrebloque,"
- " annos, meses, diario, dias,"
- " semanas, horas, ampm,"
- " minutos,suspendida, sesion "
- "FROM programaciones");
- }
-
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- return -1;
- }
-
- array = json_array();
- if (!array)
- return -1;
-
- while (dbi_result_next_row(result)) {
- schedule.id = dbi_result_get_uint(result, "idprogramacion");
- schedule.task_id = dbi_result_get_uint(result, "identificador");
- schedule.name = dbi_result_get_string(result, "nombrebloque");
- schedule.time.years = dbi_result_get_uint(result, "annos");
- schedule.time.months = dbi_result_get_uint(result, "meses");
- schedule.time.days = dbi_result_get_uint(result, "diario");
- schedule.time.hours = dbi_result_get_uint(result, "horas");
- schedule.time.am_pm = dbi_result_get_uint(result, "ampm");
- schedule.time.minutes = dbi_result_get_uint(result, "minutos");
- schedule.week_days = dbi_result_get_uint(result, "dias");
- schedule.weeks = dbi_result_get_uint(result, "semanas");
- schedule.suspended = dbi_result_get_uint(result, "suspendida");
- schedule.session = dbi_result_get_uint(result, "sesion");
-
- obj = json_object();
- if (!obj) {
- err = -1;
- break;
- }
- json_object_set_new(obj, "id", json_integer(schedule.id));
- json_object_set_new(obj, "task", json_integer(schedule.task_id));
- json_object_set_new(obj, "name", json_string(schedule.name));
- json_object_set_new(obj, "years", json_integer(schedule.time.years));
- json_object_set_new(obj, "months", json_integer(schedule.time.months));
- json_object_set_new(obj, "days", json_integer(schedule.time.days));
- json_object_set_new(obj, "hours", json_integer(schedule.time.hours));
- json_object_set_new(obj, "am_pm", json_integer(schedule.time.am_pm));
- json_object_set_new(obj, "minutes", json_integer(schedule.time.minutes));
- json_object_set_new(obj, "week_days", json_integer(schedule.week_days));
- json_object_set_new(obj, "weeks", json_integer(schedule.weeks));
- json_object_set_new(obj, "suspended", json_integer(schedule.suspended));
- json_object_set_new(obj, "session", json_integer(schedule.session));
-
- json_array_append_new(array, obj);
- }
-
- json_object_set_new(root, "schedule", array);
-
- dbi_result_free(result);
-
- return err;
-}
-
-static int og_task_schedule_create(struct og_msg_params *params)
-{
- enum og_schedule_type type;
- uint32_t schedule_id;
- struct og_dbi *dbi;
- int err;
-
- if (!strcmp(params->type, "task"))
- type = OG_SCHEDULE_TASK;
- else if (!strcmp(params->type, "procedure"))
- type = OG_SCHEDULE_PROCEDURE;
- else if (!strcmp(params->type, "command"))
- type = OG_SCHEDULE_COMMAND;
- else
- return -1;
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open connection database (%s:%d)\n",
- __func__, __LINE__);
- return -1;
- }
-
- err = og_dbi_schedule_create(dbi, params, &schedule_id, type);
- if (err < 0) {
- og_dbi_close(dbi);
- return -1;
- }
- og_schedule_create(schedule_id, atoi(params->task_id), type,
- &params->time);
- og_schedule_refresh(og_loop);
- og_dbi_close(dbi);
-
- return 0;
-}
-
-static uint32_t og_tm_years_mask(struct tm *tm)
-{
- int i, j = 0;
-
- for (i = 2010; i < 2026; i++, j++) {
- if (tm->tm_year + 1900 == i)
- break;
- }
-
- return (1 << j);
-}
-
-static uint32_t og_tm_months_mask(struct tm *tm)
-{
- return 1 << tm->tm_mon;
-}
-
-static uint16_t og_tm_hours_mask(struct tm *tm)
-{
- return tm->tm_hour >= 12 ? 1 << (tm->tm_hour - 12) : 1 << tm->tm_hour;
-}
-
-static uint32_t og_tm_ampm(struct tm *tm)
-{
- return tm->tm_hour < 12 ? 0 : 1;
-}
-
-static uint32_t og_tm_days_mask(struct tm *tm)
-{
- return 1 << (tm->tm_mday - 1);
-}
-
-static void og_schedule_time_now(struct og_schedule_time *ogtime)
-{
- struct tm *tm;
- time_t now;
-
- now = time(NULL);
- tm = localtime(&now);
-
- ogtime->years = og_tm_years_mask(tm);
- ogtime->months = og_tm_months_mask(tm);
- ogtime->weeks = 0;
- ogtime->week_days = 0;
- ogtime->days = og_tm_days_mask(tm);
- ogtime->hours = og_tm_hours_mask(tm);
- ogtime->am_pm = og_tm_ampm(tm);
- ogtime->minutes = tm->tm_min;
-}
-
-static int og_cmd_schedule_create(json_t *element, struct og_msg_params *params)
-{
- bool when = false;
- const char *key;
- json_t *value;
- int err = 0;
-
- if (json_typeof(element) != JSON_OBJECT)
- return -1;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "task")) {
- err = og_json_parse_string(value, &params->task_id);
- params->flags |= OG_REST_PARAM_TASK;
- } else if (!strcmp(key, "name")) {
- err = og_json_parse_string(value, &params->name);
- params->flags |= OG_REST_PARAM_NAME;
- } else if (!strcmp(key, "when")) {
- err = og_json_parse_time_params(value, params);
- when = true;
- } else if (!strcmp(key, "type")) {
- err = og_json_parse_string(value, &params->type);
- params->flags |= OG_REST_PARAM_TYPE;
- }
-
- if (err < 0)
- return err;
- }
-
- if (!when) {
- params->time.check_stale = false;
- og_schedule_time_now(&params->time);
- params->flags |= OG_REST_PARAM_TIME_YEARS |
- OG_REST_PARAM_TIME_MONTHS |
- OG_REST_PARAM_TIME_WEEKS |
- OG_REST_PARAM_TIME_WEEK_DAYS |
- OG_REST_PARAM_TIME_DAYS |
- OG_REST_PARAM_TIME_HOURS |
- OG_REST_PARAM_TIME_AM_PM |
- OG_REST_PARAM_TIME_MINUTES;
- } else {
- params->time.check_stale = true;
- }
-
- if (!og_msg_params_validate(params, OG_REST_PARAM_TASK |
- OG_REST_PARAM_NAME |
- OG_REST_PARAM_TIME_YEARS |
- OG_REST_PARAM_TIME_MONTHS |
- OG_REST_PARAM_TIME_WEEKS |
- OG_REST_PARAM_TIME_WEEK_DAYS |
- OG_REST_PARAM_TIME_DAYS |
- OG_REST_PARAM_TIME_HOURS |
- OG_REST_PARAM_TIME_MINUTES |
- OG_REST_PARAM_TIME_AM_PM |
- OG_REST_PARAM_TYPE))
- return -1;
-
- return og_task_schedule_create(params);
-}
-
-static int og_cmd_schedule_update(json_t *element, struct og_msg_params *params)
-{
- struct og_dbi *dbi;
- bool when = false;
- const char *key;
- json_t *value;
- int err = 0;
-
- if (json_typeof(element) != JSON_OBJECT)
- return -1;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "id")) {
- err = og_json_parse_string(value, &params->id);
- params->flags |= OG_REST_PARAM_ID;
- } else if (!strcmp(key, "task")) {
- err = og_json_parse_string(value, &params->task_id);
- params->flags |= OG_REST_PARAM_TASK;
- } else if (!strcmp(key, "name")) {
- err = og_json_parse_string(value, &params->name);
- params->flags |= OG_REST_PARAM_NAME;
- } else if (!strcmp(key, "when")) {
- err = og_json_parse_time_params(value, params);
- when = true;
- }
-
- if (err < 0)
- return err;
- }
-
- if (!when) {
- params->time.check_stale = false;
- og_schedule_time_now(&params->time);
- params->flags |= OG_REST_PARAM_TIME_YEARS |
- OG_REST_PARAM_TIME_MONTHS |
- OG_REST_PARAM_TIME_WEEKS |
- OG_REST_PARAM_TIME_WEEK_DAYS |
- OG_REST_PARAM_TIME_DAYS |
- OG_REST_PARAM_TIME_HOURS |
- OG_REST_PARAM_TIME_AM_PM |
- OG_REST_PARAM_TIME_MINUTES;
- } else {
- params->time.check_stale = true;
- }
-
- if (!og_msg_params_validate(params, OG_REST_PARAM_ID |
- OG_REST_PARAM_TASK |
- OG_REST_PARAM_NAME |
- OG_REST_PARAM_TIME_YEARS |
- OG_REST_PARAM_TIME_MONTHS |
- OG_REST_PARAM_TIME_DAYS |
- OG_REST_PARAM_TIME_HOURS |
- OG_REST_PARAM_TIME_MINUTES |
- OG_REST_PARAM_TIME_AM_PM))
- return -1;
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open connection database (%s:%d)\n",
- __func__, __LINE__);
- return -1;
- }
-
- err = og_dbi_schedule_update(dbi, params);
- og_dbi_close(dbi);
-
- if (err < 0)
- return err;
-
- og_schedule_update(og_loop, atoi(params->id), atoi(params->task_id),
- &params->time);
- og_schedule_refresh(og_loop);
-
- return err;
-}
-
-static int og_cmd_schedule_delete(json_t *element, struct og_msg_params *params)
-{
- struct og_dbi *dbi;
- const char *key;
- json_t *value;
- int err = 0;
-
- if (json_typeof(element) != JSON_OBJECT)
- return -1;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "id")) {
- err = og_json_parse_string(value, &params->id);
- params->flags |= OG_REST_PARAM_ID;
- }
-
- if (err < 0)
- return err;
- }
-
- if (!og_msg_params_validate(params, OG_REST_PARAM_ID))
- return -1;
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open connection database (%s:%d)\n",
- __func__, __LINE__);
- return -1;
- }
-
- err = og_dbi_schedule_delete(dbi, atoi(params->id));
- og_dbi_close(dbi);
-
- og_schedule_delete(og_loop, atoi(params->id));
-
- return err;
-}
-
-static int og_cmd_schedule_get(json_t *element, struct og_msg_params *params,
- char *buffer_reply)
-{
- struct og_buffer og_buffer = {
- .data = buffer_reply,
- };
- json_t *schedule_root;
- struct og_dbi *dbi;
- const char *key;
- json_t *value;
- int err = 0;
-
- if (element) {
- if (json_typeof(element) != JSON_OBJECT)
- return -1;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "task")) {
- err = og_json_parse_string(value,
- &params->task_id);
- } else if (!strcmp(key, "id")) {
- err = og_json_parse_string(value, &params->id);
- }
-
- if (err < 0)
- return err;
- }
- }
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open connection database (%s:%d)\n",
- __func__, __LINE__);
- return -1;
- }
-
- schedule_root = json_object();
- if (!schedule_root) {
- og_dbi_close(dbi);
- return -1;
- }
-
- err = og_dbi_schedule_get_json(dbi, schedule_root,
- params->task_id, params->id);
- og_dbi_close(dbi);
-
- if (err >= 0)
- err = json_dump_callback(schedule_root, og_json_dump_clients,
- &og_buffer, JSON_ENSURE_ASCII);
-
- json_decref(schedule_root);
-
- return err;
-}
-
#define OG_LIVE_JSON_FILE_PATH "/opt/opengnsys/etc/ogliveinfo.json"
static int og_cmd_oglive_list(char *buffer_reply)
@@ -6756,456 +4776,6 @@ static int og_cmd_post_center_delete(json_t *element,
return 0;
}
-int og_procedure_add_steps(struct og_dbi *dbi, struct og_procedure *proc)
-{
- struct og_procedure_step *step;
- const char *legacy_params;
- const char *msglog;
- dbi_result result;
- int i;
-
- for (i = 0; i < proc->num_steps; i++) {
- step = &proc->steps[i];
- switch (step->type) {
- case OG_STEP_COMMAND:
- legacy_params = og_msg_params_to_legacy(&step->cmd);
- if (!legacy_params) {
- og_dbi_close(dbi);
- return -1;
- }
- result = dbi_conn_queryf(dbi->conn,
- "INSERT INTO procedimientos_acciones "
- "(idprocedimiento, orden, parametros) "
- "VALUES (%d, %d, '%s')",
- proc->id,
- step->position,
- legacy_params);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR,
- "failed to add procedure command to database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- og_dbi_close(dbi);
- free((char *)legacy_params);
- return -1;
- }
-
- dbi_result_free(result);
- free((char *)legacy_params);
- break;
- case OG_STEP_PROCEDURE:
- result = dbi_conn_queryf(dbi->conn,
- "INSERT INTO procedimientos_acciones "
- "(idprocedimiento, orden, procedimientoid) "
- "VALUES (%d, %d, %d)",
- proc->id,
- step->position,
- step->procedure.id);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR,
- "failed to add procedure child to database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- og_dbi_close(dbi);
- return -1;
- }
- dbi_result_free(result);
- break;
- case OG_STEP_TASK:
- syslog(LOG_ERR, "Procedures can not include tasks. "
- "Invalid step: %d\n",
- step->position);
- return -1;
- break;
- }
- }
-
- return 0;
-}
-
-static int og_cmd_post_procedure_add(json_t *element,
- struct og_msg_params *params)
-{
- struct og_procedure proc = {};
- const char *key, *msglog;
- struct og_dbi *dbi;
- dbi_result result;
- json_t *value;
- int err = 0;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "center")) {
- err = og_json_parse_string(value, &params->id);
- params->flags |= OG_REST_PARAM_ID;
- } else if (!strcmp(key, "name")) {
- err = og_json_parse_string(value, &params->name);
- params->flags |= OG_REST_PARAM_NAME;
- } else if (!strcmp(key, "description")) {
- err = og_json_parse_string(value, &params->comment);
- } else if (!strcmp(key, "steps")) {
- err = og_json_parse_procedure(value, &proc);
- }
-
- if (err < 0)
- return err;
- }
-
- if (!og_msg_params_validate(params, OG_REST_PARAM_ID |
- OG_REST_PARAM_NAME))
- return -1;
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open conection database (%s:%d)\n",
- __func__, __LINE__);
- return -1;
- }
-
- result = dbi_conn_queryf(dbi->conn,
- "SELECT descripcion FROM procedimientos "
- "WHERE descripcion='%s' AND idcentro=%s",
- params->name, params->id);
-
- 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 -1;
- }
-
- if (dbi_result_get_numrows(result) > 0) {
- syslog(LOG_ERR, "Procedure with name %s already exists in the "
- "center with id %s\n",
- params->name, params->id);
- dbi_result_free(result);
- og_dbi_close(dbi);
- return -1;
- }
- dbi_result_free(result);
-
- result = dbi_conn_queryf(dbi->conn,
- "INSERT INTO procedimientos("
- "idcentro, descripcion, comentarios) "
- "VALUES (%s, '%s', '%s')",
- params->id, params->name, params->comment);
-
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR,
- "failed to add procedure to database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- og_dbi_close(dbi);
- return -1;
- }
- dbi_result_free(result);
-
- proc.id = dbi_conn_sequence_last(dbi->conn, NULL);
- err = og_procedure_add_steps(dbi, &proc);
-
- og_dbi_close(dbi);
-
- return err;
-}
-
-static int og_cmd_post_procedure_delete(json_t *element,
- struct og_msg_params *params)
-{
- const char *key, *msglog;
- struct og_dbi *dbi;
- dbi_result result;
- json_t *value;
- int err = 0;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "id")) {
- err = og_json_parse_string(value, &params->id);
- params->flags |= OG_REST_PARAM_ID;
- }
- if (err < 0)
- return err;
- }
-
- if (!og_msg_params_validate(params, OG_REST_PARAM_ID))
- return -1;
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open conection database (%s:%d)\n",
- __func__, __LINE__);
- return -1;
- }
-
- result = dbi_conn_queryf(dbi->conn,
- "DELETE FROM procedimientos WHERE idprocedimiento=%s",
- params->id);
-
- 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 -1;
- } else if (dbi_result_get_numrows_affected(result) < 1) {
- syslog(LOG_ERR, "delete did not modify any row (%s:%d)\n",
- __func__, __LINE__);
- }
-
- dbi_result_free(result);
-
- og_dbi_close(dbi);
- return 0;
-}
-
-static int og_cmd_post_procedure_update(json_t *element,
- struct og_msg_params *params)
-{
- struct og_procedure proc = {};
- const char *key, *msglog;
- struct og_dbi *dbi;
- dbi_result result;
- json_t *value;
- int err = 0;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "procedure")) {
- err = og_json_parse_string(value, &params->task_id);
- params->flags |= OG_REST_PARAM_TASK;
- } else if (!strcmp(key, "center")) {
- err = og_json_parse_string(value, &params->id);
- params->flags |= OG_REST_PARAM_ID;
- } else if (!strcmp(key, "name")) {
- err = og_json_parse_string(value, &params->name);
- params->flags |= OG_REST_PARAM_NAME;
- } else if (!strcmp(key, "description")) {
- err = og_json_parse_string(value, &params->comment);
- } else if (!strcmp(key, "steps")) {
- err = og_json_parse_procedure(value, &proc);
- }
-
- if (err < 0)
- return err;
- }
-
- if (!og_msg_params_validate(params, OG_REST_PARAM_TASK |
- OG_REST_PARAM_ID |
- OG_REST_PARAM_NAME))
- return -1;
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open conection database (%s:%d)\n",
- __func__, __LINE__);
- return -1;
- }
-
- result = dbi_conn_queryf(dbi->conn,
- "SELECT descripcion FROM procedimientos "
- "WHERE descripcion = '%s' AND idcentro = %s "
- "AND idprocedimiento <> %s",
- params->name, params->id, params->task_id);
-
- 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 -1;
- }
-
- if (dbi_result_get_numrows(result) > 0) {
- syslog(LOG_ERR, "Procedure with name %s already exists in the "
- "center with id %s\n",
- params->name, params->id);
- dbi_result_free(result);
- og_dbi_close(dbi);
- return -1;
- }
- dbi_result_free(result);
-
- result = dbi_conn_queryf(dbi->conn,
- "UPDATE procedimientos SET idcentro = %s, "
- "descripcion = '%s', comentarios = '%s' "
- "WHERE idprocedimiento = %s",
- params->id, params->name, params->comment,
- params->task_id);
-
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR,
- "failed to update procedure %s (%s:%d) %s\n",
- params->task_id, __func__, __LINE__, msglog);
- og_dbi_close(dbi);
- return -1;
- }
- dbi_result_free(result);
-
- result = dbi_conn_queryf(dbi->conn,
- "DELETE FROM procedimientos_acciones "
- "WHERE idprocedimiento = %s",
- params->task_id);
-
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR,
- "failed to delete old procedure %s steps (%s:%d) %s\n",
- params->task_id, __func__, __LINE__, msglog);
- og_dbi_close(dbi);
- return -1;
- }
- dbi_result_free(result);
-
- proc.id = atoll(params->task_id);
- err = og_procedure_add_steps(dbi, &proc);
-
- og_dbi_close(dbi);
-
- return err;
-}
-
-static int og_task_add_steps(struct og_dbi *dbi, struct og_procedure *task)
-{
- struct og_procedure_step *step;
- const char *msglog;
- dbi_result result;
- int i;
-
- for (i = 0; i < task->num_steps; i++) {
- step = &task->steps[i];
- switch (step->type) {
- case OG_STEP_COMMAND:
- syslog(LOG_ERR, "Tasks can not include commands. "
- "Invalid step: %d\n",
- step->position);
- return -1;
- break;
- case OG_STEP_PROCEDURE:
- result = dbi_conn_queryf(dbi->conn,
- "INSERT INTO tareas_acciones "
- "(idtarea, orden, idprocedimiento) "
- "VALUES (%d, %d, %d)",
- task->id,
- step->position,
- step->procedure.id);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR,
- "failed to add procedure child to database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- og_dbi_close(dbi);
- return -1;
- }
- dbi_result_free(result);
- break;
- case OG_STEP_TASK:
- result = dbi_conn_queryf(dbi->conn,
- "INSERT INTO tareas_acciones "
- "(idtarea, orden, tareaid) "
- "VALUES (%d, %d, %d)",
- task->id,
- step->position,
- step->procedure.id);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR,
- "failed to add task child to database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- og_dbi_close(dbi);
- return -1;
- }
- dbi_result_free(result);
- break;
- }
- }
-
- return 0;
-}
-
-static int og_cmd_post_task_add(json_t *element,
- struct og_msg_params *params)
-{
- struct og_procedure task = {};
- const char *key, *msglog;
- struct og_dbi *dbi;
- dbi_result result;
- json_t *value;
- int err = 0;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "center")) {
- err = og_json_parse_string(value, &params->id);
- params->flags |= OG_REST_PARAM_ID;
- } else if (!strcmp(key, "name")) {
- err = og_json_parse_string(value, &params->name);
- params->flags |= OG_REST_PARAM_NAME;
- } else if (!strcmp(key, "description")) {
- err = og_json_parse_string(value, &params->comment);
- } else if (!strcmp(key, "steps")) {
- err = og_json_parse_procedure(value, &task);
- }
-
- if (err < 0)
- return err;
- }
-
- if (!og_msg_params_validate(params, OG_REST_PARAM_ID |
- OG_REST_PARAM_NAME))
- return -1;
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open conection database (%s:%d)\n",
- __func__, __LINE__);
- return -1;
- }
-
- result = dbi_conn_queryf(dbi->conn,
- "SELECT descripcion FROM tareas "
- "WHERE descripcion='%s' AND idcentro=%s",
- params->name, params->id);
-
- 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 -1;
- }
-
- if (dbi_result_get_numrows(result) > 0) {
- syslog(LOG_ERR, "Task with name %s already exists in the "
- "center with id %s\n",
- params->name, params->id);
- dbi_result_free(result);
- og_dbi_close(dbi);
- return -1;
- }
- dbi_result_free(result);
-
- result = dbi_conn_queryf(dbi->conn,
- "INSERT INTO tareas("
- "idcentro, descripcion, comentarios) "
- "VALUES (%s, '%s', '%s')",
- params->id, params->name, params->comment);
-
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR,
- "failed to add task to database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- og_dbi_close(dbi);
- return -1;
- }
- dbi_result_free(result);
-
- task.id = dbi_conn_sequence_last(dbi->conn, NULL);
- err = og_task_add_steps(dbi, &task);
-
- og_dbi_close(dbi);
-
- return err;
-}
-
static int og_cmd_post_repository_update(json_t *element,
struct og_msg_params *params,
char *buffer_reply)
@@ -7690,273 +5260,6 @@ static int og_cmd_post_room_delete(json_t *element,
return 0;
}
-enum {
- OG_SCHEDULE_CMD_TYPE = 0,
- OG_SCHEDULE_CMD_PARAMS,
-};
-
-static bool og_cmd_validate(const struct og_cmd_json *cmd,
- const uint64_t flags)
-{
- return (cmd->flags & flags) == flags;
-}
-
-
-static int og_cmd_post_schedule_command(json_t *element,
- struct og_msg_params *params)
-{
- char *centerid_query = "SELECT o.idordenador, c.idcentro "
- "FROM `ordenadores` AS o "
- "INNER JOIN aulas AS a ON o.idaula = a.idaula "
- "INNER JOIN centros AS c ON a.idcentro = c.idcentro "
- "WHERE o.ip = '%s';";
- uint32_t sequence, session = 0;
- int center_id, client_id, len;
- struct og_cmd_json cmd = {};
- const char *legacy_params;
- const char *key, *msglog;
- struct og_dbi *dbi;
- char task_id[128];
- bool when = false;
- dbi_result result;
- json_t *value;
- int err = 0, i;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "clients")) {
- err = og_json_parse_clients(value, params);
- } else if (!strcmp(key, "command")) {
- err = og_json_parse_string(value, &cmd.type);
- cmd.flags |= OG_SCHEDULE_CMD_TYPE;
- } else if (!strcmp(key, "params")) {
- cmd.json = value;
- cmd.flags |= OG_SCHEDULE_CMD_PARAMS;
- } else if (!strcmp(key, "when")) {
- err = og_json_parse_time_params(value, params);
- when = true;
- }
-
- if (err < 0)
- return err;
- }
-
- if (!og_cmd_validate(&cmd, OG_SCHEDULE_CMD_TYPE |
- OG_SCHEDULE_CMD_PARAMS))
- return -1;
-
- if (!when) {
- params->time.check_stale = false;
- og_schedule_time_now(&params->time);
- params->flags |= OG_REST_PARAM_TIME_YEARS |
- OG_REST_PARAM_TIME_MONTHS |
- OG_REST_PARAM_TIME_WEEKS |
- OG_REST_PARAM_TIME_WEEK_DAYS |
- OG_REST_PARAM_TIME_DAYS |
- OG_REST_PARAM_TIME_HOURS |
- OG_REST_PARAM_TIME_AM_PM |
- OG_REST_PARAM_TIME_MINUTES;
- } else {
- params->time.check_stale = true;
- }
-
- if (!og_msg_params_validate(params, OG_REST_PARAM_ADDR |
- OG_REST_PARAM_TIME_YEARS |
- OG_REST_PARAM_TIME_MONTHS |
- OG_REST_PARAM_TIME_WEEKS |
- OG_REST_PARAM_TIME_WEEK_DAYS |
- OG_REST_PARAM_TIME_DAYS |
- OG_REST_PARAM_TIME_HOURS |
- OG_REST_PARAM_TIME_MINUTES |
- OG_REST_PARAM_TIME_AM_PM))
- return -1;
-
- params->type = "command";
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open conection database (%s:%d)\n",
- __func__, __LINE__);
- goto err_dbi_open;
- }
-
- legacy_params = og_msg_params_to_legacy(&cmd);
- if (!legacy_params)
- goto err_legacy_params;
-
- /* ips_array -> ids */
- for (i = 0; i < params->ips_array_len; i++) {
-
- result = dbi_conn_queryf(dbi->conn, centerid_query, params->ips_array[i]);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- goto err_dbi_result;
- }
- if (dbi_result_get_numrows(result) != 1) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "client not found (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- goto err_dbi;
- }
-
- if (!dbi_result_next_row(result)) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to get idcentro (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- goto err_dbi;
- }
- center_id = dbi_result_get_uint(result, "idcentro");
- if (!center_id) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to get idcentro (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- goto err_dbi;
- }
- client_id = dbi_result_get_uint(result, "idordenador");
- dbi_result_free(result);
-
- result = dbi_conn_queryf(dbi->conn, "INSERT INTO acciones (idordenador, "
- "idcentro, parametros)"
- "VALUES (%d, %d, '%s')",
- client_id, center_id, legacy_params);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- goto err_dbi_result;
- }
- dbi_result_free(result);
-
- sequence = dbi_conn_sequence_last(dbi->conn, NULL);
-
- /* This 'session' ID allows us to correlate the schedule with
- * the commands after expansion.
- */
- if (!session)
- session = dbi_conn_sequence_last(dbi->conn, NULL);
-
- result = dbi_conn_queryf(dbi->conn, "UPDATE acciones SET idordenador=%d, "
- "idcentro=%d, parametros='%s', sesion=%d"
- "WHERE idaccion=%d",
- client_id, center_id, legacy_params,
- session, sequence);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- goto err_dbi_result;
- }
- dbi_result_free(result);
- }
-
- len = snprintf(task_id, sizeof(session), "%d", session);
- if (len >= (int)sizeof(task_id)) {
- syslog(LOG_ERR, "truncated snprintf (%s:%d)\n",
- __func__, __LINE__);
- goto err_dbi_result;
- }
- params->task_id = task_id;
-
- og_task_schedule_create(params);
-
- free((char *)legacy_params);
- og_dbi_close(dbi);
- return 0;
-
-err_dbi:
- dbi_result_free(result);
-err_dbi_result:
- free((char *)legacy_params);
-err_legacy_params:
- og_dbi_close(dbi);
-err_dbi_open:
- return -1;
-}
-
-static int og_cmd_post_procedure_run(json_t *element,
- struct og_msg_params *params)
-{
- const char *centerid_query = "SELECT o.idordenador, c.idcentro "
- "FROM `ordenadores` AS o "
- "INNER JOIN aulas AS a "
- "ON o.idaula = a.idaula "
- "INNER JOIN centros AS c "
- "ON a.idcentro = c.idcentro "
- "WHERE o.ip = '%s';";
- struct og_task task = {};
- const char *key, *msglog;
- struct og_dbi *dbi;
- dbi_result result;
- int i, err = 0;
- json_t *value;
-
- json_object_foreach(element, key, value) {
- if (!strcmp(key, "clients")) {
- err = og_json_parse_clients(value, params);
- } else if (!strcmp(key, "procedure")) {
- err = og_json_parse_string(value, &params->id);
- params->flags |= OG_REST_PARAM_ID;
- }
-
- if (err < 0)
- goto err_return;
- }
-
- if (!og_msg_params_validate(params, OG_REST_PARAM_ADDR |
- OG_REST_PARAM_ID ))
- goto err_return;
-
- task.type_scope = AMBITO_ORDENADORES;
- task.procedure_id = atoi(params->id);
-
- dbi = og_dbi_open(&ogconfig.db);
- if (!dbi) {
- syslog(LOG_ERR, "cannot open conection database (%s:%d)\n",
- __func__, __LINE__);
- goto err_return;
- }
-
- for (i = 0; i < params->ips_array_len; i++) {
-
- result = dbi_conn_queryf(dbi->conn, centerid_query, params->ips_array[i]);
- if (!result) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to query database (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- goto err_close_dbi;
- }
-
- if (dbi_result_get_numrows(result) != 1 ||
- !dbi_result_next_row(result) ||
- !dbi_result_get_uint(result, "idcentro") ||
- !dbi_result_get_uint(result, "idordenador")) {
- dbi_conn_error(dbi->conn, &msglog);
- syslog(LOG_ERR, "failed to get query data (%s:%d) %s\n",
- __func__, __LINE__, msglog);
- goto err_free_result;
- }
-
- task.center_id = dbi_result_get_uint(result, "idcentro");
- task.scope = dbi_result_get_uint(result, "idordenador");
- dbi_result_free(result);
-
- if (og_dbi_queue_procedure(dbi, &task))
- goto err_close_dbi;
- }
-
- og_dbi_close(dbi);
-
- return og_send_request(OG_METHOD_GET, OG_CMD_RUN_SCHEDULE, params,
- NULL);
-
-err_free_result:
- dbi_result_free(result);
-err_close_dbi:
- og_dbi_close(dbi);
-err_return:
- return -1;
-}
-
static int og_cmd_get_servers(char *buffer_reply)
{
json_t *root, *servers, *address;
@@ -8456,12 +5759,6 @@ struct {
[OG_URI_CACHE_FETCH] = { "cache/fetch", },
[OG_URI_EFI] = { "efi", },
[OG_URI_PART_SETUP] = { "setup", },
- [OG_URI_RUN_SCHEDULE] = { "run/schedule", },
- [OG_URI_TASK_RUN] = { "task/run", },
- [OG_URI_SCHEDULE_CREATE] = { "schedule/create", },
- [OG_URI_SCHEDULE_DELETE] = { "schedule/delete", },
- [OG_URI_SCHEDULE_UPDATE] = { "schedule/update", },
- [OG_URI_SCHEDULE_GET] = { "schedule/get", },
[OG_URI_OGLIVE_LIST] = { "oglive/list", },
[OG_URI_OGLIVE_SET] = { "oglive/set", },
[OG_URI_CENTER_ADD] = { "center/add", },
@@ -8472,12 +5769,6 @@ struct {
[OG_URI_ROOM_UPDATE] = { "room/update", },
[OG_URI_ROOM_DELETE] = { "room/delete", },
[OG_URI_ROOM_INFO] = { "room/info", },
- [OG_URI_PROC_ADD] = { "procedure/add", },
- [OG_URI_PROC_UPDATE] = { "procedure/update", },
- [OG_URI_PROC_RUN] = { "procedure/run", },
- [OG_URI_SCHEDULE_RUN] = { "schedule/command", },
- [OG_URI_PROC_DEL] = { "procedure/delete", },
- [OG_URI_TASK_ADD] = { "task/add", },
[OG_URI_SERVER] = { "server", },
[OG_URI_STATS] = { "stats", },
[OG_URI_FOLDER_ADD] = { "folder/add", },
@@ -8587,21 +5878,12 @@ int og_client_state_process_payload_rest(struct og_client *cli)
uri = og_str_to_uri(cmd);
if (!strncmp(cmd, "clients", strlen("clients"))) {
- if (method != OG_METHOD_POST &&
- method != OG_METHOD_GET) {
+ if (method != OG_METHOD_GET) {
err = og_client_method_not_found(cli);
goto err_process_rest_payload;
}
- if (method == OG_METHOD_POST && !root) {
- syslog(LOG_ERR, "command clients with no payload\n");
- err = og_client_bad_request(cli);
- goto err_process_rest_payload;
- }
switch (method) {
- case OG_METHOD_POST:
- err = og_cmd_post_clients(root, &params);
- break;
case OG_METHOD_GET:
err = og_cmd_get_clients(root, &params, buf_reply);
break;
@@ -9117,78 +6399,6 @@ int og_client_state_process_payload_rest(struct og_client *cli)
goto err_process_rest_payload;
}
err = og_cmd_setup(root, &params);
- } else if (!strncmp(cmd, "run/schedule", strlen("run/schedule"))) {
- if (method != OG_METHOD_POST) {
- err = og_client_method_not_found(cli);
- goto err_process_rest_payload;
- }
-
- if (!root) {
- syslog(LOG_ERR, "command create with no payload\n");
- err = og_client_bad_request(cli);
- goto err_process_rest_payload;
- }
-
- err = og_cmd_run_schedule(root, &params);
- } else if (!strncmp(cmd, "task/run", strlen("task/run"))) {
- if (method != OG_METHOD_POST) {
- err = og_client_method_not_found(cli);
- goto err_process_rest_payload;
- }
-
- if (!root) {
- syslog(LOG_ERR, "command task with no payload\n");
- err = og_client_bad_request(cli);
- goto err_process_rest_payload;
- }
- err = og_cmd_task_post(root, &params);
- } else if (!strncmp(cmd, "schedule/create",
- strlen("schedule/create"))) {
- if (method != OG_METHOD_POST) {
- err = og_client_method_not_found(cli);
- goto err_process_rest_payload;
- }
-
- if (!root) {
- syslog(LOG_ERR, "command task with no payload\n");
- err = og_client_bad_request(cli);
- goto err_process_rest_payload;
- }
- err = og_cmd_schedule_create(root, &params);
- } else if (!strncmp(cmd, "schedule/delete",
- strlen("schedule/delete"))) {
- if (method != OG_METHOD_POST) {
- err = og_client_method_not_found(cli);
- goto err_process_rest_payload;
- }
-
- if (!root) {
- syslog(LOG_ERR, "command task with no payload\n");
- err = og_client_bad_request(cli);
- goto err_process_rest_payload;
- }
- err = og_cmd_schedule_delete(root, &params);
- } else if (!strncmp(cmd, "schedule/update",
- strlen("schedule/update"))) {
- if (method != OG_METHOD_POST) {
- err = og_client_method_not_found(cli);
- goto err_process_rest_payload;
- }
-
- if (!root) {
- syslog(LOG_ERR, "command task with no payload\n");
- err = og_client_bad_request(cli);
- goto err_process_rest_payload;
- }
- err = og_cmd_schedule_update(root, &params);
- } else if (!strncmp(cmd, "schedule/get",
- strlen("schedule/get"))) {
- if (method != OG_METHOD_POST) {
- err = og_client_method_not_found(cli);
- goto err_process_rest_payload;
- }
-
- err = og_cmd_schedule_get(root, &params, buf_reply);
} else if (!strncmp(cmd, "oglive/list",
strlen("oglive/list"))) {
if (method != OG_METHOD_GET) {
@@ -9310,85 +6520,6 @@ int og_client_state_process_payload_rest(struct og_client *cli)
}
err = og_cmd_get_room_info(root, &params, buf_reply);
- } else if (!strncmp(cmd, "procedure/add", strlen("procedure/add"))) {
- if (method != OG_METHOD_POST) {
- err = og_client_method_not_found(cli);
- goto err_process_rest_payload;
- }
-
- if (!root) {
- syslog(LOG_ERR,
- "command procedure add with no payload\n");
- err = og_client_bad_request(cli);
- goto err_process_rest_payload;
- }
- err = og_cmd_post_procedure_add(root, &params);
- } else if (!strncmp(cmd, "procedure/update",
- strlen("procedure/update"))) {
- if (method != OG_METHOD_POST) {
- err = og_client_method_not_found(cli);
- goto err_process_rest_payload;
- }
-
- if (!root) {
- syslog(LOG_ERR,
- "command procedure update with no payload\n");
- err = og_client_bad_request(cli);
- goto err_process_rest_payload;
- }
- err = og_cmd_post_procedure_update(root, &params);
- } else if (!strncmp(cmd, "procedure/run", strlen("procedure/run"))) {
- if (method != OG_METHOD_POST) {
- err = og_client_method_not_found(cli);
- goto err_process_rest_payload;
- }
-
- if (!root) {
- syslog(LOG_ERR,
- "command procedure run with no payload\n");
- err = og_client_bad_request(cli);
- goto err_process_rest_payload;
- }
- err = og_cmd_post_procedure_run(root, &params);
- } else if (!strncmp(cmd, "schedule/command", strlen("schedule/command"))) {
- if (method != OG_METHOD_POST) {
- err = og_client_method_not_found(cli);
- goto err_process_rest_payload;
- }
-
- if (!root) {
- syslog(LOG_ERR,
- "command schedule action with no payload\n");
- err = og_client_bad_request(cli);
- goto err_process_rest_payload;
- }
- err = og_cmd_post_schedule_command(root, &params);
- } else if (!strncmp(cmd, "procedure/delete", strlen("schedule/command"))) {
- if (method != OG_METHOD_POST) {
- err = og_client_method_not_found(cli);
- goto err_process_rest_payload;
- }
-
- if (!root) {
- syslog(LOG_ERR,
- "command procedure delete with no payload\n");
- err = og_client_bad_request(cli);
- goto err_process_rest_payload;
- }
- err = og_cmd_post_procedure_delete(root, &params);
- } else if (!strncmp(cmd, "task/add", strlen("task/add"))) {
- if (method != OG_METHOD_POST) {
- err = og_client_method_not_found(cli);
- goto err_process_rest_payload;
- }
-
- if (!root) {
- syslog(LOG_ERR,
- "command task add with no payload\n");
- err = og_client_bad_request(cli);
- goto err_process_rest_payload;
- }
- err = og_cmd_post_task_add(root, &params);
} else if (!strncmp(cmd, "server", strlen("server"))) {
switch (method) {
case OG_METHOD_GET: