/*****************************************************************************
 * Copyright (c) 2005  Daniel Lerch Hostalot <http://daniellerch.com>
 *
 * Permission is hereby granted, free of charge, to any person obtaining a 
 * copy of this software and associated documentation files (the "Software"), 
 * to deal in the Software without restriction, including without limitation 
 * the rights to use, copy, modify, merge, publish, distribute, sublicense, 
 * and/or sell copies of the Software, and to permit persons to whom the 
 * Software is furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in 
 * all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR 
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, 
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE 
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER 
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING 
 * FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER 
 * DEALINGS IN THE SOFTWARE.
 ****************************************************************************/


#include "database.h"


database_t *database_new() 
{
   database_t *newdb;
   newdb = (database_t*)malloc(sizeof(database_t));

   newdb->conn = NULL;

   memset(newdb->dbhost, 0, sizeof(newdb->dbhost));
   memset(newdb->dbname, 0, sizeof(newdb->dbname));
   memset(newdb->dbuser, 0, sizeof(newdb->dbuser));
   memset(newdb->dbpass, 0, sizeof(newdb->dbpass));

   return newdb;
}


void database_free(database_t *obj)
{
   if (obj) free(obj);
}

char *database_get_dbuser(database_t *obj) 
{
   return obj->dbuser;
}

void database_set_dbuser(database_t *obj, char* dbuser) 
{
   snprintf(obj->dbuser, sizeof(obj->dbuser), "%s", dbuser);
}

char *database_get_dbname(database_t *obj) 
{
   return obj->dbname;
}

void database_set_dbname(database_t *obj, char* dbname) 
{
   snprintf(obj->dbname, sizeof(obj->dbname), "%s", dbname);
}

char *database_get_dbhost(database_t *obj) 
{
   return obj->dbhost;
}

void database_set_dbhost(database_t *obj, char* dbhost) 
{
   snprintf(obj->dbhost, sizeof(obj->dbhost), "%s", dbhost);
}

void database_set_dbpass(database_t *obj, char* dbpass) 
{
   snprintf(obj->dbpass, sizeof(obj->dbpass), "%s", dbpass);
}

int database_connect(database_t *obj)
{

   if (!obj->conn) {

      obj->conn = mysql_init (NULL);
      if (!obj->conn) return 0;

      if (mysql_real_connect(obj->conn,
               obj->dbhost,
               obj->dbuser,
               obj->dbpass,
               obj->dbname,
               3306,
               NULL,
               0 )==NULL) return 0;		
   }

   return 1;
}


void database_disconnect(database_t *obj)
{
   if (obj->conn) mysql_close (obj->conn);
}


resultset_t *database_execquery (database_t *obj, char* query) 
{
   resultset_t *rs;

   if (mysql_query(obj->conn, query)!=0) return NULL;

   rs = resultset_new(mysql_store_result(obj->conn));

   return rs;
}


void database_transaction_start(database_t *obj)
{
   database_execquery(obj, "START TRANSACTION;");
}

void database_transaction_commit(database_t *obj)
{
   database_execquery(obj, "COMMIT;");
}

void database_transaction_rollback(database_t *obj)
{
   database_execquery(obj, "ROLLBACK;");
}