util/sql.c

   1 /*
   2   sql.c - find offsets of important data fields in MySQL data structures
   3
   4   version 1.1, (c) Lutz Mueller 2004, released under the GNU GPL License
   5   version 1.2 added 2 more include files for 4.0
   6
   7   compile using: gcc sql.c -o sql
   8
   9   then do: ./sql
  10   to obtain a list of offsets in MySQL data structures
  11
  12   this program is only needed when designing new MySQL support functions
  13   in newLISP and the MySQL data structures have to be accessed directly
  14
  15   the values produced by this program are used in the file mysql.lsp.
  16
  17   See also /usr/share/newlisp/mysql.lsp
  18
  19 */
  20
  21
  22 #define LINUX
  23 /* #define MACOSX */
  24
  25 #include <stdio.h>
  26 #include <unistd.h>
  27 #include <stdlib.h>
  28
  29 #ifdef MACOSX
  30 #include "/usr/local/mysql/include/mysql.h"
  31 #include "/usr/local/mysql/include/mysql_com.h"
  32 #include "/usr/local/mysql/include/mysql_version.h"
  33 #include "/usr/local/mysql/include/my_alloc.h"
  34 #endif
  35
  36 #ifdef LINUX
  37 #include "/usr/include/mysql/mysql.h"
  38 #include "/usr/include/mysql/mysql_com.h"
  39 #include "/usr/include/mysql/mysql_version.h"
  40 #include "/usr/include/mysql/my_alloc.h"
  41 #endif
  42
  43 MYSQL  * mysql;
  44 MYSQL_RES  * mysql_res;
  45
  46
  47 int main(int argc, char ** argv)
  48 {
  49 printf("sizeof(MYSQL)       %d\n", sizeof(MYSQL));
  50 printf("sizeof(MYSQL_RES)   %d\n", sizeof(MYSQL_RES));
  51 printf("sizeof(MYSQL_ROW)   %d\n", sizeof(MYSQL_ROW));
  52 printf("sizeof(MYSQL_FIELD) %d\n", sizeof(MYSQL_FIELD));
  53 printf("sizeof(NET) %d\n", sizeof(NET));
  54 printf("sizeof(my_ulonglong) %d\n", sizeof(my_ulonglong));
  55 printf("sizeof(my_bool) %d\n\n", sizeof(my_bool));
  56
  57 mysql = 0;
  58 mysql_res = 0;
  59
  60 printf("offset mysql->affected_rows: %d\n", &mysql->affected_rows);
  61 printf("offset mysql->insert_id: %d\n", &mysql->insert_id);
  62 printf("offset mysql->net.last_error: %d\n", &mysql->net.last_error);
  63
  64 printf("offset mysql_res->row_count: %d\n", &mysql_res->row_count);
  65 printf("offset mysql_res->field_count: %d\n", &mysql_res->field_count);
  66 printf("offset mysql_res->eof: %d\n", &mysql_res->eof);
  67
  68
  69 return 0;
  70 }
  71
  72 /* eof */
  73