/*****************************************************************************\ * mysql_jobcomp_process.c - functions the processing of * information from the mysql jobcomp * storage. ***************************************************************************** * * Copyright (C) 2004-2007 The Regents of the University of California. * Produced at Lawrence Livermore National Laboratory (cf, DISCLAIMER). * Written by Danny Auble * * This file is part of Slurm, a resource management program. * For details, see . * Please also read the included file: DISCLAIMER. * * Slurm is free software; you can redistribute it and/or modify it under * the terms of the GNU General Public License as published by the Free * Software Foundation; either version 2 of the License, or (at your option) * any later version. * * In addition, as a special exception, the copyright holders give permission * to link the code of portions of this program with the OpenSSL library under * certain conditions as described in each individual source file, and * distribute linked combinations including the two. You must obey the GNU * General Public License in all respects for all of the code used other than * OpenSSL. If you modify file(s) with this exception, you may extend this * exception to your version of the file(s), but you are not obligated to do * so. If you do not wish to do so, delete this exception statement from your * version. If you delete this exception statement from all source files in * the program, then also delete it here. * * Slurm is distributed in the hope that it will be useful, but WITHOUT ANY * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more * details. * * You should have received a copy of the GNU General Public License along * with Slurm; if not, write to the Free Software Foundation, Inc., * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. * * This file is patterned after jobcomp_linux.c, written by Morris Jette and * Copyright (C) 2002 The Regents of the University of California. \*****************************************************************************/ #include #include "src/common/parse_time.h" #include "src/common/xstring.h" #include "mysql_jobcomp_process.h" extern List mysql_jobcomp_process_get_jobs(slurmdb_job_cond_t *job_cond) { char *query = NULL; char *extra = NULL; char *tmp = NULL; char *selected_part = NULL; slurmdb_selected_step_t *selected_step = NULL; ListIterator itr = NULL; int set = 0; MYSQL_RES *result = NULL; MYSQL_ROW row; int i; int lc = 0; jobcomp_job_rec_t *job = NULL; char time_str[32]; time_t temp_time; List job_list = list_create(jobcomp_destroy_job); if (job_cond->step_list && list_count(job_cond->step_list)) { set = 0; xstrcat(extra, " where ("); itr = list_iterator_create(job_cond->step_list); while ((selected_step = list_next(itr))) { if (set) xstrcat(extra, " || "); tmp = xstrdup_printf("jobid=%u", selected_step->jobid); xstrcat(extra, tmp); set = 1; xfree(tmp); } list_iterator_destroy(itr); xstrcat(extra, ")"); } if (job_cond->partition_list && list_count(job_cond->partition_list)) { set = 0; if (extra) xstrcat(extra, " && ("); else xstrcat(extra, " where ("); itr = list_iterator_create(job_cond->partition_list); while ((selected_part = list_next(itr))) { if (set) xstrcat(extra, " || "); tmp = xstrdup_printf("`partition`='%s'", selected_part); xstrcat(extra, tmp); set = 1; xfree(tmp); } list_iterator_destroy(itr); xstrcat(extra, ")"); } i = 0; while (jobcomp_table_fields[i].name) { if (i) xstrcat(tmp, ", "); xstrfmtcat(tmp, "`%s`", jobcomp_table_fields[i].name); i++; } query = xstrdup_printf("select %s from %s", tmp, jobcomp_table); xfree(tmp); if (extra) { xstrcat(query, extra); xfree(extra); } //info("query = %s", query); if (!(result = mysql_db_query_ret(jobcomp_mysql_conn, query, 0))) { xfree(query); FREE_NULL_LIST(job_list); return NULL; } xfree(query); while ((row = mysql_fetch_row(result))) { lc++; job = xmalloc(sizeof(jobcomp_job_rec_t)); if (row[JOBCOMP_REQ_JOBID]) job->jobid = slurm_atoul(row[JOBCOMP_REQ_JOBID]); job->partition = xstrdup(row[JOBCOMP_REQ_PARTITION]); temp_time = atoi(row[JOBCOMP_REQ_STARTTIME]); slurm_make_time_str(&temp_time, time_str, sizeof(time_str)); job->start_time = xstrdup(time_str); temp_time = atoi(row[JOBCOMP_REQ_ENDTIME]); slurm_make_time_str(&temp_time, time_str, sizeof(time_str)); job->elapsed_time = atoi(row[JOBCOMP_REQ_ENDTIME]) - atoi(row[JOBCOMP_REQ_STARTTIME]); job->end_time = xstrdup(time_str); if (row[JOBCOMP_REQ_UID]) job->uid = slurm_atoul(row[JOBCOMP_REQ_UID]); job->uid_name = xstrdup(row[JOBCOMP_REQ_USER_NAME]); if (row[JOBCOMP_REQ_GID]) job->gid = slurm_atoul(row[JOBCOMP_REQ_GID]); job->gid_name = xstrdup(row[JOBCOMP_REQ_GROUP_NAME]); job->jobname = xstrdup(row[JOBCOMP_REQ_NAME]); job->nodelist = xstrdup(row[JOBCOMP_REQ_NODELIST]); if (row[JOBCOMP_REQ_NODECNT]) job->node_cnt = slurm_atoul(row[JOBCOMP_REQ_NODECNT]); if (row[JOBCOMP_REQ_STATE]) { i = atoi(row[JOBCOMP_REQ_STATE]); job->state = xstrdup(job_state_string(i)); } job->timelimit = xstrdup(row[JOBCOMP_REQ_TIMELIMIT]); if (row[JOBCOMP_REQ_MAXPROCS]) job->max_procs = slurm_atoul(row[JOBCOMP_REQ_MAXPROCS]); job->connection = xstrdup(row[JOBCOMP_REQ_CONNECTION]); job->reboot = xstrdup(row[JOBCOMP_REQ_REBOOT]); job->rotate = xstrdup(row[JOBCOMP_REQ_ROTATE]); job->geo = xstrdup(row[JOBCOMP_REQ_GEOMETRY]); job->bg_start_point = xstrdup(row[JOBCOMP_REQ_START]); job->blockid = xstrdup(row[JOBCOMP_REQ_BLOCKID]); list_append(job_list, job); } mysql_free_result(result); return job_list; } extern int mysql_jobcomp_process_archive(slurmdb_archive_cond_t *arch_cond) { return SLURM_SUCCESS; }