File: mysqltest.C

package info (click to toggle)
sqlrelay 1%3A0.35-10
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 11,944 kB
  • ctags: 6,102
  • sloc: cpp: 41,419; python: 11,007; ansic: 10,279; java: 9,833; perl: 9,500; php: 9,229; ruby: 9,182; sh: 8,700; makefile: 3,474; tcl: 5
file content (73 lines) | stat: -rw-r--r-- 1,476 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
// Copyright (c) 2000-2001  David Muse
// See the file COPYING for more information

#include "../../config.h"

#include <stdlib.h>
#include <stdio.h>
#include <string.h>
#include <time.h>
#include <mysql.h>

MYSQL		mysql;
MYSQL_RES	*mysqlresult;
MYSQL_ROW	mysqlrow;

int main(int argc, char **argv) {

	if (argc<4) {
		printf("usage: mysqltest host user password query iterations\n");
		exit(0);
	}

	char	*host=argv[1];
	char	*user=argv[2];
	char	*password=argv[3];
	char	*query=argv[4];
	int	iterations=atoi(argv[5]);

	// init the timer
	time_t	starttime=time(NULL);
	clock();

	for (int count=0; count<iterations; count++) {

		// init
#ifdef MYSQL_VERSION
	#if MYSQL_VERSION_ID>=32200
		mysql_init(&mysql);
	
		// log in
		mysql_real_connect(&mysql,host,user,password,"",0,NULL,0);
	#else
		mysql_real_connect(&mysql,host,user,password,0,NULL,0);
	#endif
#else
		mysql_connect(&mysql,host,user,password);
#endif

		// execute the query
		mysql_real_query(&mysql,query,strlen(query));

		// get the result set
		mysqlresult=mysql_store_result(&mysql);

		// run through the rows
		int	cols=mysql_num_fields(mysqlresult);
		while(mysqlrow=mysql_fetch_row(mysqlresult)) {
			for (int i=0; i<cols; i++) {
				printf("\"%s\",",mysqlrow[i]);
			}
			printf("\n");
		}

			// free the result set
		mysql_free_result(mysqlresult);

		// log off
		mysql_close(&mysql);
	}

	printf("total system time used: %d\n",clock());
	printf("total real time: %d\n",time(NULL)-starttime);
}