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: ");

       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;

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

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

*/

#include "mysql.h"

#include <mysql/mysql.h>

#include "common/asprintf.h"

#include "common/protocol.h"

#include <stdio.h>

#include <string.h>

#include <unistd.h>

#include <stdlib.h>

#include <sys/stat.h>

#include <fcntl.h>

/**

   local types

 */

#define SEVENTY_FIVE 75

#define FORTY_TWO 42

/**

   performs mysql query.

   errors will be logged to the user by this function.

   @return pointer to query handle on success, NULL on failure or if expected_columns=0 (no result set expected)

 */

distrend_mysql_result_t mysqlQuery(distrend_mysql_conn_t conn, char *query, MYSQL_FIELD_OFFSET expected_columns);

/**

   frees mysql query result. Accepts a NULL pointer and ignores it to

   help deal with one-shot calls to mysqlQuery so that you don't have to

   check if it returned NULL or not.

   @return 0 on success

 */

int mysqlResultFree(distrend_mysql_result_t result);

/**

   reads an integer mysql field value

   @return 0 on success

*/

int distrend_mysql_getint(MYSQL_ROW row, MYSQL_FIELD_OFFSET column, int32_t *theint)

{

if(!row[0] || !row[1])

  *theint = atol(row[column]);

  return 0;

}

struct distrend_mysql_conn

{

  MYSQL *mysqlconn;

  short pointlesscheck;

};

struct distrend_mysql_result

{

  MYSQL_RES *mysqlresult;

  short pointlesscheck;

};

/**

    funcs

 */

int mysqlConnect(distrend_mysql_conn_t *conn)

{

  MYSQL *mysqlconn;

  char *server = "zserver1";

  char *user = "distren";

  char *password = "HwLxuBqTvJ6J7FWj";

  char *database = "distren";

  mysqlconn = mysql_init(NULL);

  if(!mysql_real_connect(mysqlconn, server, user, password, database, 0, NULL, CLIENT_MULTI_STATEMENTS))

    {

      fprintf(stderr, "%s\n", mysql_error(mysqlconn));

      return 1;

    }

  mysql_options(mysqlconn, MYSQL_OPT_RECONNECT,"true"); // After mysql_real_connect due to bug fixed in MySQL 5.1.6 and later

  *conn = malloc(sizeof(struct distrend_mysql_conn));

  if(!*conn)

    {

      mysql_close(mysqlconn);

      mysql_server_end();

      return 2;

  _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;

  _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(result);

      return 1;

    }

  mysqlResultFree(result);

  return 0;

}