summaryrefslogtreecommitdiff
path: root/libmysql
diff options
context:
space:
mode:
Diffstat (limited to 'libmysql')
-rw-r--r--libmysql/mytest.c423
1 files changed, 138 insertions, 285 deletions
diff --git a/libmysql/mytest.c b/libmysql/mytest.c
index e1acf3e2136..2d5c576b72a 100644
--- a/libmysql/mytest.c
+++ b/libmysql/mytest.c
@@ -1,103 +1,54 @@
-/*C4*/
+/*C4*/
+/****************************************************************/
+/* Author: Jethro Wright, III TS : 3/ 4/1998 9:15 */
+/* Date: 02/18/1998 */
+/* mytest.c : do some testing of the libmySQL.DLL.... */
+/* */
+/* History: */
+/* 02/18/1998 jw3 also sprach zarathustra.... */
+/****************************************************************/
-/****************************************************************/
-/* Author: Jethro Wright, III TS : 3/ 4/1998 9:15 */
+#include <windows.h>
+#include <stdio.h>
+#include <string.h>
-/* Date: 02/18/1998 */
+#include <mysql.h>
-/* mytest.c : do some testing of the libmySQL.DLL.... */
+#define DEFALT_SQL_STMT "SELECT * FROM db"
+#ifndef offsetof
+#define offsetof(TYPE, MEMBER) ((size_t) &((TYPE *)0)->MEMBER)
+#endif
-/* */
-/* History: */
+/********************************************************
+**
+** main :-
+**
+********************************************************/
-/* 02/18/1998 jw3 also sprach zarathustra.... */
-
-/****************************************************************/
-
-
-
-
-
-#include <windows.h>
-
-#include <stdio.h>
-
-#include <string.h>
-
-
-
-#include <mysql.h>
-
-
-
-#define DEFALT_SQL_STMT "SELECT * FROM db"
-
-#ifndef offsetof
-
-#define offsetof(TYPE, MEMBER) ((size_t) &((TYPE *)0)->MEMBER)
-
-#endif
-
-
-
-
-
-/********************************************************
-
-**
-
-** main :-
-
-**
-
-********************************************************/
-
-
-
-int
-
-main( int argc, char * argv[] )
-
-{
-
-
-
- char szSQL[ 200 ], aszFlds[ 25 ][ 25 ], szDB[ 50 ] ;
+int
+main( int argc, char * argv[] )
+{
+ char szSQL[ 200 ], aszFlds[ 25 ][ 25 ], szDB[ 50 ] ;
const char *pszT;
- int i, j, k, l, x ;
-
- MYSQL * myData ;
-
- MYSQL_RES * res ;
-
- MYSQL_FIELD * fd ;
-
- MYSQL_ROW row ;
-
-
-
- //....just curious....
+ int i, j, k, l, x ;
+ MYSQL * myData ;
+ MYSQL_RES * res ;
+ MYSQL_FIELD * fd ;
+ MYSQL_ROW row ;
+ //....just curious....
printf( "sizeof( MYSQL ) == %d\n", (int) sizeof( MYSQL ) ) ;
- if ( argc == 2 )
-
- {
-
- strcpy( szDB, argv[ 1 ] ) ;
-
- strcpy( szSQL, DEFALT_SQL_STMT ) ;
-
- if (!strcmp(szDB,"--debug"))
-
- {
-
- strcpy( szDB, "mysql" ) ;
-
- printf("Some mysql struct information (size and offset):\n");
-
+ if ( argc == 2 )
+ {
+ strcpy( szDB, argv[ 1 ] ) ;
+ strcpy( szSQL, DEFALT_SQL_STMT ) ;
+ if (!strcmp(szDB,"--debug"))
+ {
+ strcpy( szDB, "mysql" ) ;
+ printf("Some mysql struct information (size and offset):\n");
printf("net:\t%3d %3d\n",(int) sizeof(myData->net),
(int) offsetof(MYSQL,net));
printf("host:\t%3d %3d\n",(int) sizeof(myData->host),
@@ -123,200 +74,102 @@ main( int argc, char * argv[] )
(int) offsetof(MYSQL,free_me));
printf("options:\t%3d %3d\n",(int) sizeof(myData->options),
(int) offsetof(MYSQL,options));
- puts("");
-
- }
-
- }
-
- else if ( argc > 2 ) {
-
- strcpy( szDB, argv[ 1 ] ) ;
-
- strcpy( szSQL, argv[ 2 ] ) ;
-
- }
-
- else {
-
- strcpy( szDB, "mysql" ) ;
-
- strcpy( szSQL, DEFALT_SQL_STMT ) ;
-
- }
-
- //....
-
-
-
- if ( (myData = mysql_init((MYSQL*) 0)) &&
-
- mysql_real_connect( myData, NULL, NULL, NULL, NULL, MYSQL_PORT,
-
- NULL, 0 ) )
-
- {
-
+ puts("");
+ }
+ }
+ else if ( argc > 2 ) {
+ strcpy( szDB, argv[ 1 ] ) ;
+ strcpy( szSQL, argv[ 2 ] ) ;
+ }
+ else {
+ strcpy( szDB, "mysql" ) ;
+ strcpy( szSQL, DEFALT_SQL_STMT ) ;
+ }
+ //....
+
+ if ( (myData = mysql_init((MYSQL*) 0)) &&
+ mysql_real_connect( myData, NULL, NULL, NULL, NULL, MYSQL_PORT,
+ NULL, 0 ) )
+ {
myData->reconnect= 1;
- if ( mysql_select_db( myData, szDB ) < 0 ) {
-
- printf( "Can't select the %s database !\n", szDB ) ;
-
- mysql_close( myData ) ;
-
- return 2 ;
-
- }
-
- }
-
- else {
-
- printf( "Can't connect to the mysql server on port %d !\n",
-
- MYSQL_PORT ) ;
-
- mysql_close( myData ) ;
-
- return 1 ;
-
- }
-
- //....
-
- if ( ! mysql_query( myData, szSQL ) ) {
-
- res = mysql_store_result( myData ) ;
-
- i = (int) mysql_num_rows( res ) ; l = 1 ;
-
- printf( "Query: %s\nNumber of records found: %ld\n", szSQL, i ) ;
-
- //....we can get the field-specific characteristics here....
-
- for ( x = 0 ; fd = mysql_fetch_field( res ) ; x++ )
-
- strcpy( aszFlds[ x ], fd->name ) ;
-
- //....
-
- while ( row = mysql_fetch_row( res ) ) {
-
- j = mysql_num_fields( res ) ;
-
- printf( "Record #%ld:-\n", l++ ) ;
-
- for ( k = 0 ; k < j ; k++ )
-
- printf( " Fld #%d (%s): %s\n", k + 1, aszFlds[ k ],
-
- (((row[k]==NULL)||(!strlen(row[k])))?"NULL":row[k])) ;
-
- puts( "==============================\n" ) ;
-
- }
-
- mysql_free_result( res ) ;
-
- }
-
- else printf( "Couldn't execute %s on the server !\n", szSQL ) ;
-
- //....
-
- puts( "==== Diagnostic info ====" ) ;
-
- pszT = mysql_get_client_info() ;
-
- printf( "Client info: %s\n", pszT ) ;
-
- //....
-
- pszT = mysql_get_host_info( myData ) ;
-
- printf( "Host info: %s\n", pszT ) ;
-
- //....
-
- pszT = mysql_get_server_info( myData ) ;
-
- printf( "Server info: %s\n", pszT ) ;
-
- //....
-
- res = mysql_list_processes( myData ) ; l = 1 ;
-
- if (res)
-
- {
-
- for ( x = 0 ; fd = mysql_fetch_field( res ) ; x++ )
-
- strcpy( aszFlds[ x ], fd->name ) ;
-
- while ( row = mysql_fetch_row( res ) ) {
-
- j = mysql_num_fields( res ) ;
-
- printf( "Process #%ld:-\n", l++ ) ;
-
- for ( k = 0 ; k < j ; k++ )
-
- printf( " Fld #%d (%s): %s\n", k + 1, aszFlds[ k ],
-
- (((row[k]==NULL)||(!strlen(row[k])))?"NULL":row[k])) ;
-
- puts( "==============================\n" ) ;
-
- }
-
- }
-
- else
-
- {
-
- printf("Got error %s when retreiving processlist\n",mysql_error(myData));
-
- }
-
- //....
-
- res = mysql_list_tables( myData, "%" ) ; l = 1 ;
-
- for ( x = 0 ; fd = mysql_fetch_field( res ) ; x++ )
-
- strcpy( aszFlds[ x ], fd->name ) ;
-
- while ( row = mysql_fetch_row( res ) ) {
-
- j = mysql_num_fields( res ) ;
-
- printf( "Table #%ld:-\n", l++ ) ;
-
- for ( k = 0 ; k < j ; k++ )
-
- printf( " Fld #%d (%s): %s\n", k + 1, aszFlds[ k ],
-
- (((row[k]==NULL)||(!strlen(row[k])))?"NULL":row[k])) ;
-
- puts( "==============================\n" ) ;
-
- }
-
- //....
-
- pszT = mysql_stat( myData ) ;
-
- puts( pszT ) ;
-
- //....
-
- mysql_close( myData ) ;
-
- return 0 ;
-
-
-
-}
-
+ if ( mysql_select_db( myData, szDB ) < 0 ) {
+ printf( "Can't select the %s database !\n", szDB ) ;
+ mysql_close( myData ) ;
+ return 2 ;
+ }
+ }
+ else {
+ printf( "Can't connect to the mysql server on port %d !\n",
+ MYSQL_PORT ) ;
+ mysql_close( myData ) ;
+ return 1 ;
+ }
+ //....
+ if ( ! mysql_query( myData, szSQL ) ) {
+ res = mysql_store_result( myData ) ;
+ i = (int) mysql_num_rows( res ) ; l = 1 ;
+ printf( "Query: %s\nNumber of records found: %ld\n", szSQL, i ) ;
+ //....we can get the field-specific characteristics here....
+ for ( x = 0 ; fd = mysql_fetch_field( res ) ; x++ )
+ strcpy( aszFlds[ x ], fd->name ) ;
+ //....
+ while ( row = mysql_fetch_row( res ) ) {
+ j = mysql_num_fields( res ) ;
+ printf( "Record #%ld:-\n", l++ ) ;
+ for ( k = 0 ; k < j ; k++ )
+ printf( " Fld #%d (%s): %s\n", k + 1, aszFlds[ k ],
+ (((row[k]==NULL)||(!strlen(row[k])))?"NULL":row[k])) ;
+ puts( "==============================\n" ) ;
+ }
+ mysql_free_result( res ) ;
+ }
+ else printf( "Couldn't execute %s on the server !\n", szSQL ) ;
+ //....
+ puts( "==== Diagnostic info ====" ) ;
+ pszT = mysql_get_client_info() ;
+ printf( "Client info: %s\n", pszT ) ;
+ //....
+ pszT = mysql_get_host_info( myData ) ;
+ printf( "Host info: %s\n", pszT ) ;
+ //....
+ pszT = mysql_get_server_info( myData ) ;
+ printf( "Server info: %s\n", pszT ) ;
+ //....
+ res = mysql_list_processes( myData ) ; l = 1 ;
+ if (res)
+ {
+ for ( x = 0 ; fd = mysql_fetch_field( res ) ; x++ )
+ strcpy( aszFlds[ x ], fd->name ) ;
+ while ( row = mysql_fetch_row( res ) ) {
+ j = mysql_num_fields( res ) ;
+ printf( "Process #%ld:-\n", l++ ) ;
+ for ( k = 0 ; k < j ; k++ )
+ printf( " Fld #%d (%s): %s\n", k + 1, aszFlds[ k ],
+ (((row[k]==NULL)||(!strlen(row[k])))?"NULL":row[k])) ;
+ puts( "==============================\n" ) ;
+ }
+ }
+ else
+ {
+ printf("Got error %s when retreiving processlist\n",mysql_error(myData));
+ }
+ //....
+ res = mysql_list_tables( myData, "%" ) ; l = 1 ;
+ for ( x = 0 ; fd = mysql_fetch_field( res ) ; x++ )
+ strcpy( aszFlds[ x ], fd->name ) ;
+ while ( row = mysql_fetch_row( res ) ) {
+ j = mysql_num_fields( res ) ;
+ printf( "Table #%ld:-\n", l++ ) ;
+ for ( k = 0 ; k < j ; k++ )
+ printf( " Fld #%d (%s): %s\n", k + 1, aszFlds[ k ],
+ (((row[k]==NULL)||(!strlen(row[k])))?"NULL":row[k])) ;
+ puts( "==============================\n" ) ;
+ }
+ //....
+ pszT = mysql_stat( myData ) ;
+ puts( pszT ) ;
+ //....
+ mysql_close( myData ) ;
+ return 0 ;
+
+}