main()

int main	(	int	argc,
		char **	argv
	)

                               {   

   char* mysql_host = "localhost";
   int   mysql_port = 0;
   char* mysql_user = NULL;
   char* mysql_password = NULL;
   char* mysql_db = NULL;

   char* dataname = NULL;
   int runid = 0;
   int option_index = 0;
   int c;
   char* datasql;


   MYSQL_RES *result;
   MYSQL_ROW row;



   /* Defining long options struct */
   static struct option long_options[] ={
      {"mysql-host",required_argument,0,'H'},
      {"mysql-port",required_argument,0,'P'},
      {"mysql-user",required_argument,0,'u'},
      {"mysql-password",required_argument,0,'p'},
      {"mysql-dbname",required_argument,0,'d'},
      {"data-name",required_argument,0,'n'},
      {"run-id",required_argument,0,'r'},
      {"version" ,no_argument      ,0,'V'},
      {"help" ,no_argument      ,0,'h'},
   };

   /*  Options Parsing loop */
   while ((c = getopt_long (argc, argv, "H:u:p:P:d:n:r:Vh",long_options,&option_index)) != -1)
   switch (c)
   {
     case 'H': // hostname
       mysql_host = malloc(strlen(optarg)+1);
       strcpy(mysql_host,optarg);
       break;
     case 'u': // username
       mysql_user = malloc(strlen(optarg)+1);
       strcpy(mysql_user,optarg);
       break;
     case 'p': // password
       mysql_password = malloc(strlen(optarg)+1);
       strcpy(mysql_password,optarg);
       break;
     case 'd': // database name
       mysql_db = malloc(strlen(optarg)+1);
       strcpy(mysql_db,optarg);
       break;
     case 'n': // data name
       dataname = malloc(strlen(optarg)+1);
       strcpy(dataname,optarg);
       break;
     case 'V': // version
       printf("ac_mysqlread (1.4)\n");
       break;
     case 'h': // help
       printhelp();
       exit(0);
       break;
     case 'P': // mysql port
       mysql_port = atoi(optarg);
       break;
     case 'r': // runid 
       runid = atoi(optarg);
       break;
     case '?':
       if (optopt == 'f')
         fprintf (stderr, "Option -%c requires an argument.\n", optopt);
     default:
       printf(" ");
   }


   // checking mandatory options
   if(NULL == mysql_user) {perror("Mysql User must be provided\n"); exit(1);}
   if(NULL == mysql_db)   {perror("Mysql DB Name must be provided\n"); exit(1);}
   if(0    == runid)      {perror("Run id must be provided\n"); exit(1);}
   if(NULL == dataname)   {perror("Data name must be provided\n"); exit(1);}

   open_connection(mysql_host, mysql_user, mysql_password, mysql_db,mysql_port); // init mysql


   // doing query
   datasql = (char*) malloc((255)*sizeof(char));
   sprintf(datasql,"select data,description from rundata where runid=%d and name='%s'",runid,dataname);
   mysql_query(connection,datasql);
   result=mysql_store_result(connection);
   if(NULL != result){
     while((row = mysql_fetch_row(result)) != NULL){
       if(NULL != row){ // if we get some result...
           printf("%s\n",row[0]);
         /*
         if(0 == strcmp(dataname,"ACOUSTO_CONFIG")){ // configuration is dumped as is
           printf("%s\n",row[0]);
         }else{ // complex array data is casted to the right array and dumped on stdout
           l   = mysql_fetch_lengths(result);
           cval = (COMPLEX*) (row[0]);
           nitems = l[0] / sizeof(COMPLEX);
           printf(" # frequency %s\n",row[1]);
           for(i=0;i<nitems;i++){
             printf("%d %f %f\n",i,creal(*cval),cimag(*cval));
             cval++;
           }
           

         }
           */
       }else{
         printf("No data found with name %s or run %d not found\n",dataname,runid);
       }
     }
   }else{
       printf("No data found with name %s or run %d not found\n",dataname,runid);
   }
   mysql_free_result(result); // freeing everything


   close_connection();


   return 0;
}