#include <stdio.h>
#include <stdlib.h>
#include <stdarg.h>
#include <WinSock.h>
#include <iostream>
#include "mysql.h"

#pragma comment (lib, "libmysqld.lib")

MYSQL *mysql = NULL;
MYSQL_RES *results = NULL;
MYSQL_ROW record = NULL;

static char *server_options[] = \
       { "mysql_embedded", "--defaults-file=my.ini", NULL };
int num_elements = (sizeof(server_options) / sizeof(char *)) - 1;

static char *server_groups[] = { "server", NULL };

int doQuery (const char *query) {

    int ret = mysql_query (mysql, query);
    if (ret != 0) {

        std::cout << mysql_error (mysql) << std::endl;
    }

    return ret;
}

int main (int argc, char *argv[])
{
   int ret;
   if (ret = mysql_library_init(num_elements, server_options, (char **)server_groups)) {

       printf("Return code: %d, Error: %s", ret, mysql_error(NULL));
       return ret;
   }
   std::cout << "embedded server created" << std::endl;

   mysql = mysql_init(NULL);
   if (!mysql) {

       std::cout << "mysql failed to init" << std::endl;
       return -1;
   }

   std::cout << "mysql loaded" << std::endl;

   mysql_options(mysql, MYSQL_READ_DEFAULT_GROUP, "client");
   mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, NULL);

   if (!mysql_real_connect(mysql, NULL, NULL,NULL, NULL, 0,NULL,0)) {

       std::cout << "failed to connect:" << mysql_error(mysql) << std::endl;
       return -1;
   }

   std::cout << "connected to mysql" << std::endl;

   doQuery ("CREATE database RiftAddons");
   doQuery ("use RiftAddons");

   mysql_query(mysql, "SELECT column1, column2 FROM table1");

   results = mysql_store_result(mysql);

   while((record = mysql_fetch_row(results))) {
      printf("%s - %s \n", record[0], record[1]);
   }

   mysql_free_result(results);
   mysql_close(mysql);
   mysql_library_end();

   return 0;
}