#include <stdio.h>
#include "mysql.h"

#define MHOST "localhost"
#define MUSER "root"
#define MPASS ""
#define MDBASE "new_crash"


char *query_array[4]={
  "SELECT * FROM TCP01 ORDER BY CPCHARNO",
  "SELECT * FROM ACEPSOH ORDER BY MANDT, COMP, BUKRS, OBJID",
  "SELECT * FROM ACEPSOI ORDER BY MANDT, COMP, BUKRS, GJAHR, OBJID",
  ""
};

#define CHECK_EQ(a, b) if (a!=b) {fprintf(stderr, "expected %d but got %d at [%s:%d]\n", b, a, __FILE__, __LINE__);exit(100);} else printf("OK!\n");

int main(int argc, char **argv)
{
  MYSQL *conn;
  MYSQL_STMT *prep_stmt = NULL;
  int res, i=-1;
	
  mysql_library_init(argc, argv, NULL);
  if (!(conn = mysql_real_connect(mysql_init(NULL), MHOST, MUSER, MPASS, MDBASE, 0, NULL, 0)))
  {
    fprintf(stderr, "Could not connect");
    exit(1);
  }

  while (query_array[++i][0])
  {
    prep_stmt= mysql_stmt_init(conn);
    printf("Preparing: %s\n", query_array[i]);
    res= mysql_stmt_prepare(prep_stmt, query_array[i] , strlen(query_array[i]));
    CHECK_EQ(res, 0);
    res= mysql_stmt_execute(prep_stmt);
    CHECK_EQ(res, 0);

    mysql_stmt_store_result(prep_stmt);
    mysql_stmt_free_result(prep_stmt);
  }
  
  mysql_close(conn);  
}