summaryrefslogtreecommitdiff
path: root/libmysql
diff options
context:
space:
mode:
authorunknown <msvensson@shellback.>2006-04-10 20:04:36 +0200
committerunknown <msvensson@shellback.>2006-04-10 20:04:36 +0200
commite10f0d9b98e8a5107b2021d20aabc8bfb1ff1188 (patch)
tree6f5073515da35e0bd2a83beab00b06ebf98fcb94 /libmysql
parent070f757cb0028294610122ea123047ce2c4e4376 (diff)
downloadmariadb-git-e10f0d9b98e8a5107b2021d20aabc8bfb1ff1188.tar.gz
Make line endings consistent, use Unix format
Diffstat (limited to 'libmysql')
-rw-r--r--libmysql/mytest.c147
1 files changed, 147 insertions, 0 deletions
diff --git a/libmysql/mytest.c b/libmysql/mytest.c
index a1dc13db39f..e1acf3e2136 100644
--- a/libmysql/mytest.c
+++ b/libmysql/mytest.c
@@ -1,54 +1,103 @@
/*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.... */
+
/****************************************************************/
+
+
+
#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 ] ;
+
const char *pszT;
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");
+
printf("net:\t%3d %3d\n",(int) sizeof(myData->net),
(int) offsetof(MYSQL,net));
printf("host:\t%3d %3d\n",(int) sizeof(myData->host),
@@ -75,101 +124,199 @@ main( int argc, char * argv[] )
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 ) )
+
{
+
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 ;
+
+
}
+