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         refresh();
  44         getch();
  45         endwin();
  46 }
  47
  48 static void mysql(void)
  49 {
  50         MYSQL mysql;
  51
  52         mysql_init(&mysql);
  53         /* mysql_options(&mysql, MYSQL_READ_DEFAULT_GROUP, "your_prog_name"); */
  54
  55         if (!mysql_real_connect(&mysql, DB_HOST, DB_USER, DB_PWD,
  56                 DB_DATABASE, 0, NULL, 0)) {
  57                 mvseep(row - 2, 0, "Failed to connect to database: Error: %s\n",
  58                         mysql_error(&mysql));
  59         } else {
  60                 mvseep(row - 2, 0, "success connect to database\n");
  61                 refresh();
  62                 /* sleep(2); */
  63                 mysql_show_num(&mysql);
  64                 mysql_show_data(&mysql);
  65         }
  66 }
  67
  68 static void mysql_show_num(MYSQL *mysql)
  69 {
  70         MYSQL_RES *result;
  71         unsigned int num_fields = 0;
  72         unsigned int num_rows = 0;
  73         char *query_string = "select * from stats";
  74
  75         if (mysql_query(mysql, query_string)) {
  76
  77         } else {
  78                 result = mysql_store_result(mysql);
  79                 if (result) {
  80                         num_fields = mysql_num_fields(result);
  81                         /* num_rows = mysql_affected_rows(mysql); */
  82                         num_rows = mysql_num_rows(result);
  83                 } else{
  84                         if (mysql_field_count(mysql) == 0) {
  85                                 num_rows = mysql_affected_rows(mysql);
  86                         } else {
  87                                 fprintf(stderr, "Error: %s\n", mysql_error(mysql));
  88                         }
  89                 }
  90         }
  91         mvseep(0, 0, "data fileds = %d, rows = %d\n", num_fields, num_rows);
  92         mysql_free_result(result);
  93 }
  94
  95 static void mysql_show_data(MYSQL *mysql)
  96 {
  97         int i = 0;
  98         MYSQL_ROW record;
  99         MYSQL_RES *result;
 100
 101         mysql_query(mysql, "SELECT * FROM stats");
 102         result = mysql_store_result(mysql);
 103         seep("\n");
 104         while (((i ++) < row - 6) && (record = mysql_fetch_row(result))) {
 105                 seep("%s - %s - %s - %s \n", record[0], record[1], record[2], record[3]);
 106         }
 107
 108         mysql_free_result(result);
 109 }
 110
 111 /* vim:fdm=marker:ts=8:ft=c:norl:fdl=1:
 112  * }}}*/
 113