// @QUERY: Likely obselete (don't remove at request of ohnobinki)

int update_xml_joblist(struct general_info *geninfo)

{

  struct distrenjob *job;

  xmlTextWriterPtr writer;

  char *tmp;

  int counter;

  /**

     update timestamp

  */

  geninfo->timestamp ++;

  if(geninfo->timestamp > 65530)

    geninfo->timestamp = 0;

  _distren_asprintf(&tmp, "%s/job_list.xml",

                    geninfo->config->datadir);

  writer = xmlNewTextWriterFilename(tmp, 0);

  free(tmp);

  xmlTextWriterStartDocument(writer, NULL, "utf-8", NULL);

  /**

     create root element job_list

  */

  xmlTextWriterStartElement(writer, (xmlChar*)"job_list");

  _distren_asprintf(&tmp, "%d", geninfo->timestamp);

  xmlTextWriterWriteAttribute(writer, (xmlChar*)"timestamp", (xmlChar*)tmp);

  free(tmp);

  geninfo->total_priority_pieces = 0;

  counter = 0;

  for(job = geninfo->head.next; job; job = job->next)

    {

      _distren_asprintf(&tmp, "%d", job->jobnum);

      xmlTextWriterWriteElement(writer, (xmlChar*)"jobnum", (xmlChar*)tmp);

      free(tmp);

      /**

        this is needed for the new frame finder to work

        Why the random constant numeral 11? --ohnobinki

      */

      geninfo->total_priority_pieces = geninfo->total_priority_pieces + job->priority;

      counter++;

    }

  xmlTextWriterEndElement(writer);

  /**

     close elements and end document

  */

  xmlTextWriterEndDocument(writer);

  /**

     free writer and save xml file to disk

  */

  xmlFreeTextWriter(writer);

  return 0;

}

/* ************************** Test Functions ************************* */

/** Interactive test for the queuing system */

/* @QUEUE: Test uses methods not present in C code using mysql web-based system */

int interactiveTest(int test, struct general_info general_info, distrend_mysql_conn_t conn){

  int command;

  fprintf(stderr,"Hello!\n");

  int32_t slaveKey = 1;

  jobnum_t jobKey = 0;

  int32_t frameNum = 0;

  int32_t newPriority = 0;

  int tmp = 0;

  while(test == 1)

   {

     fprintf(stderr, "Welcome to DistRen Alpha Interactive Test Mode\n\n");

     fprintf(stderr, "\t1 \tGet a frame to render\n");

     fprintf(stderr, "\t2 \tChange job priority\n");

     fprintf(stderr, "\t3 \tSet frame finished\n");

     fprintf(stderr, "\t4 \tSet frame started\n");

     fprintf(stderr, "\t5 \tQuit\n");

     scanf("%d", &command);

     switch(command)

     {

     case 1:

       fprintf(stderr,"Slave Key: ");

       scanf("%d", &slaveKey);

       fprintf(stderr, "Got frame: ");

       if(find_jobframe(conn, slaveKey, &jobKey, &frameNum))

         fprintf(stderr,"No frames available to render!\n");

       else

         fprintf(stderr, "jobKey: %d, frameNum: %d\n",jobKey,frameNum);

       break;

     case 2:

       fprintf(stderr,"Job key: ");

       scanf("%d", &tmp);

       jobKey = tmp;

       fprintf(stderr,"New priority: ");

       scanf("%d", &tmp);

       newPriority = tmp;

       change_job_priority(conn, jobKey, newPriority);

       fprintf(stderr,"Changed!");

       break;

     case 3:

       fprintf(stderr,"Slave Key: ");

       scanf("%d", &tmp);

       slaveKey = tmp;

       fprintf(stderr,"Job Key: ");

       scanf("%d", &tmp);

       jobKey = tmp;

       fprintf(stderr,"Frame Number: ");

       scanf("%d", &tmp);

       frameNum = tmp;

       finish_frame(conn, slaveKey, jobKey, frameNum);

       fprintf(stderr,"Finished Frame!\n");

       break;

     case 4:

       fprintf(stderr,"Slave Key: ");

       scanf("%d", &tmp);

       slaveKey = tmp;

       fprintf(stderr,"Job Key: ");

       scanf("%d", &tmp);

       jobKey = tmp;

       fprintf(stderr,"Frame Number: ");

       scanf("%d", &tmp);

       frameNum = tmp;

       start_frame(conn, slaveKey, jobKey, frameNum);

       fprintf(stderr,"Started Frame!\n");

       break;

     case 5:

       test = 0;

       break;

     default:

       fprintf(stderr, "Invalid input, please try again.\n");

       break;

     }

   }

  return 0;

}

   */

  num_columns = mysql_num_fields(result);

  if(num_columns != expected_columns)

    {

      fprintf(stderr, "Expected %d columns, got %d for ``%s''\n", expected_columns, num_columns, query);

      mysql_free_result(result);

      return NULL;

    }

  fprintf(stderr,"Done!\n");

  /**

     Prepare data for return.

   */

  distrenresult = malloc(sizeof(struct distrend_mysql_result));

  if(!distrenresult)

    {

      while(mysql_fetch_row(result))

	;

        mysql_free_result(result);

      return NULL;

    }

  distrenresult->mysqlresult = result;

  distrenresult->pointlesscheck = FORTY_TWO;

  return distrenresult;

}

int mysqlResultFree(distrend_mysql_conn_t conn, distrend_mysql_result_t result)

{

  size_t counter;

  MYSQL_RES *mysqlresult;

  if(!result)

    {

      fprintf(stderr, "mysqlResultFree(): warning, passed NULL parameter\n");

      return 0;

    }

  if(result->pointlesscheck != FORTY_TWO)

    fprintf(stderr, "%s:%d: I didn't get the type of handle I wanted\n", __FILE__, __LINE__);

  mysqlresult = result->mysqlresult;

  free(result);

  /**

     Must flush the resultset buffer.

   */

  for(counter = 0;

      mysql_fetch_row(mysqlresult);

      counter ++)

    ;

  if(counter)

    fprintf(stderr, "Calling function did not flush %d rows\n", (int)counter);

  while(mysql_more_results(conn->mysqlconn))

    {

      fprintf(stderr, "flushing an extraneous result set\n");

      mysql_next_result(conn->mysqlconn);

      mysqlresult = mysql_use_result(conn->mysqlconn);

      if(mysqlresult)

	{

	  while(mysql_fetch_row(mysqlresult))

	    ;

	  mysql_free_result(mysqlresult);

	}

    }

  return 0;

}

/*

   Individual query functions:

 */

void finish_frame(distrend_mysql_conn_t conn, int32_t slavekey, int32_t jobkey, int32_t framenum)

{

  char *query;

  _distren_asprintf(&query, "CALL `distren`.`Frame_Complete`(%d,%d,%d);", slavekey, jobkey, framenum);

  mysqlQuery(conn, query, 0);

  free(query);

}

void start_frame(distrend_mysql_conn_t conn, int32_t slavekey, int32_t jobkey, int32_t framenum)

{

  char *query;

  _distren_asprintf(&query, "CALL `distren`.`Frame_Start`(%d,%d,%d);", slavekey, jobkey, framenum);

  mysqlQuery(conn, query, 0);

  free(query);

}

int change_job_priority(distrend_mysql_conn_t conn, int32_t jobkey, int32_t newpriority)

{

  char *query;

  _distren_asprintf(&query, "UPDATE `distren`.`Job` SET `Priority`=%d WHERE `Job_Key`=%d",

		    newpriority, jobkey);

  mysqlQuery(conn, query, 0);

  return 0;

}

int find_jobframe(distrend_mysql_conn_t conn, int32_t slavekey, jobnum_t *jobkey, int32_t *framenum)

{

  distrend_mysql_result_t result;

  char *query;

  MYSQL_ROW row;

  int rtn;

  _distren_asprintf(&query, "CALL `distren`.`Frame_Get`(%d);", slavekey);

  result = mysqlQuery(conn, query, 2);

  free(query);

  if(!result)

    return 1;

  row = mysql_fetch_row(result->mysqlresult);

  if(!row)

    {

      mysqlResultFree(conn, result);

      return 1;

    }

  rtn = distrend_mysql_getint(row, 0, (int32_t *)jobkey);

  rtn += distrend_mysql_getint(row, 1, framenum);

  mysqlResultFree(conn, result);

  return rtn;

}

{

  distrend_mysql_result_t result;

  char *query;

  MYSQL_ROW row;

  int32_t *isAuth = 0;

  int rtn;

  result = mysqlQuery(conn, query, 2);

  free(query);

  if(!result)

    return 1;

  row = mysql_fetch_row(result->mysqlresult);

  if(!row)

    {

      mysqlResultFree(conn, result);

      return 1;

    }

  rtn = distrend_mysql_getint(row, 0, (int32_t *)isAuth);

  mysqlResultFree(conn, result);

  return rtn;

}

/*

  Copyright 2009 Nathan Phillip Brink, Ethan Zonca, Matthew Orlando

  This file is a part of DistRen.

  DistRen is free software: you can redistribute it and/or modify

  it under the terms of the GNU Affero General Public License as published by

  the Free Software Foundation, either version 3 of the License, or

  (at your option) any later version.

  DistRen 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 Affero General Public License for more details.

  You should have received a copy of the GNU Affero General Public License

  along with DistRen.  If not, see <http://www.gnu.org/licenses/>.

*/

#ifndef MYSQL_H_

#define MYSQL_H_

#include "distrenjob.h"

#include <stdint.h>

struct distrend_mysql_conn;

struct distrend_mysql_result;

typedef struct distrend_mysql_conn *distrend_mysql_conn_t;

typedef struct distrend_mysql_result *distrend_mysql_result_t;

/**

   initiates a MySQL connection

   @param conn, pointer will be set to the struct

   @return 0 on success

 */

int mysqlConnect(distrend_mysql_conn_t *conn);

/**

   cleans and disconnects MySQL connection

   @param conn connection to clean

   @return 0 on success

*/

int mysqlDisconnect(distrend_mysql_conn_t conn);

/**

   Mark a frame as finished in the database and calculate the seconds spent on that frame.

 */

void finish_frame(distrend_mysql_conn_t conn, int32_t slavekey, int32_t jobkey, int32_t framenum);

/**

   Mark a frame as started in the database and save the time at which it started.

 */

void start_frame(distrend_mysql_conn_t conn, int32_t slavekey, int32_t jobkey, int32_t framenum);

/**

   Changes the priority of an existing (and maybe running) job. @arg head I may end up changing the head if job == head

*/

int change_job_priority(distrend_mysql_conn_t conn, int32_t jobkey, int32_t newpriority);

/**

  Frame Finder: Finds a frame for a slave to render

*/

int find_jobframe(distrend_mysql_conn_t conn, int32_t slaveKey, jobnum_t *jobKey, int32_t *frameNum);

#endif /* MYSQL_H_ */