mysql/test/compile.c

   1 /* copyleft (C) GPL3 {{{2
   2  * Filename:    compile.c
   3  *
   4  * Author:      arrow <arrow_zhang@sdc.sercomm.com>
   5  * Created at:  Wed Dec 26 14:38:41 2007
   6  * }}}*/
   7 /*header files  {{{1*/
   8 #include <mysql.h>
   9 #include "debug.h"
  10 #include "defines.h"
  11 /*}}}*/
  12
  13 /*declaration           {{{1*/
  14 static void app_init(void);
  15 static void app_exit(void);
  16
  17 static void mysql(void);
  18 static void mysql_show_num(MYSQL *mysql);
  19 static void mysql_show_data(MYSQL *mysql);
  20
  21 static int row, col;
  22 /*}}}*/
  23
  24 /*functions             {{{1*/
  25 int main(int argc, char *argv[])
  26 {
  27         app_init();
  28         mysql();
  29         app_exit();
  30         return 0;
  31 }
  32
  33 static void app_init(void)
  34 {
  35         initscr();
  36         getmaxyx(stdscr, row, col);
  37         mvseep(row - 1, 0, "win init ok, row = %d, col = %d\n", row, col);
  38         refresh();
  39 }
  40
  41 static void app_exit(void)
  42 {
  43         int ch;
  44
  45         refresh();
  46         for (;;) {
  47                 ch = getch();
  48                 if (ch == KEY_RESIZE) {
  49                         clear();
  50                         app_init();
  51                         mysql();
  52                         refresh();
  53                         continue;
  54                 }
  55                 break; /* will exit */
  56         }
  57         endwin();
  58 }
  59
  60 static void mysql(void)
  61 {
  62         MYSQL mysql;
  63
  64         mysql_init(&mysql);
  65         /* mysql_options(&mysql, MYSQL_READ_DEFAULT_GROUP, "your_prog_name"); */
  66
  67         if (!mysql_real_connect(&mysql, DB_HOST, DB_USER, DB_PWD,
  68                 DB_DATABASE, 0, NULL, 0)) {
  69                 mvseep(row - 2, 0, "Failed to connect to database: Error: %s\n",
  70                         mysql_error(&mysql));
  71         } else {
  72                 mvseep(row - 2, 0, "success connect to database\n");
  73                 refresh();
  74                 /* sleep(2); */
  75                 mysql_show_num(&mysql);
  76                 mysql_show_data(&mysql);
  77         }
  78 }
  79
  80 static void mysql_show_num(MYSQL *mysql)
  81 {
  82         MYSQL_RES *result;
  83         unsigned int num_fields = 0;
  84         unsigned int num_rows = 0;
  85         char *query_string = "select * from stats";
  86
  87         if (mysql_query(mysql, query_string)) {
  88
  89         } else {
  90                 result = mysql_store_result(mysql);
  91                 if (result) {
  92                         num_fields = mysql_num_fields(result);
  93                         /* num_rows = mysql_affected_rows(mysql); */
  94                         num_rows = mysql_num_rows(result);
  95                 } else{
  96                         if (mysql_field_count(mysql) == 0) {
  97                                 num_rows = mysql_affected_rows(mysql);
  98                         } else {
  99                                 fprintf(stderr, "Error: %s\n", mysql_error(mysql));
 100                         }
 101                 }
 102         }
 103         mvseep(0, 0, "data fileds = %d, rows = %d\n", num_fields, num_rows);
 104         mysql_free_result(result);
 105 }
 106
 107 static void mysql_show_data(MYSQL *mysql)
 108 {
 109         int i = 0;
 110         MYSQL_ROW record;
 111         MYSQL_RES *result;
 112
 113         mysql_query(mysql, "SELECT * FROM stats");
 114         result = mysql_store_result(mysql);
 115         seep("\n");
 116         while (((i ++) < row - 6) && (record = mysql_fetch_row(result))) {
 117                 seep("%s - %s - %s\n", record[0], record[2], record[3]);
 118         }
 119
 120         mysql_free_result(result);
 121 }
 122
 123 /* vim:fdm=marker:ts=8:ft=c:norl:fdl=1:
 124  * }}}*/
 125