libdrizzle Public API Documentation

simple_multi.c
Go to the documentation of this file.
1 /*
2  * Drizzle Client & Protocol Library
3  *
4  * Copyright (C) 2008 Eric Day (eday@oddments.org)
5  * All rights reserved.
6  *
7  * Use and distribution licensed under the BSD license. See
8  * the COPYING file in this directory for full text.
9  */
10 
11 #include <stdio.h>
12 #include <string.h>
13 
15 
16 #define SIMPLE_MULTI_COUNT 10
17 
18 int main(int argc, char *argv[])
19 {
20  const char *query= "SELECT table_schema,table_name FROM tables";
21  drizzle_st drizzle;
25  drizzle_return_t ret;
26  drizzle_row_t row;
27  int x;
28 
29  if (drizzle_create(&drizzle) == NULL)
30  {
31  printf("drizzle_create:NULL\n");
32  return 1;
33  }
34 
35  /* Create SIMPLE_MULTI_COUNT connections and initialize query list. */
36  for (x= 0; x < SIMPLE_MULTI_COUNT; x++)
37  {
38  if (x == 0)
39  {
40  if (drizzle_con_create(&drizzle, &(con[0])) == NULL)
41  {
42  printf("drizzle_con_create:%s\n", drizzle_error(&drizzle));
43  return 1;
44  }
45 
46  if (argc == 2 && !strcmp(argv[1], "-m"))
48  else if (argc != 1)
49  {
50  printf("usage: %s [-m]\n", argv[0]);
51  return 1;
52  }
53 
54  drizzle_con_set_db(&(con[0]), "information_schema");
55  }
56  else
57  {
58  if (drizzle_con_clone(&drizzle, &(con[x]), &(con[0])) == NULL)
59  {
60  printf("drizzle_con_clone:%s\n", drizzle_error(&drizzle));
61  return 1;
62  }
63  }
64 
65  if (drizzle_query_add(&drizzle, &(ql[x]), &(con[x]), &(result[x]), query,
66  strlen(query), 0, NULL) == NULL)
67  {
68  printf("drizzle_query_add:%s\n", drizzle_error(&drizzle));
69  return 1;
70  }
71  }
72 
73  ret= drizzle_query_run_all(&drizzle);
74  if (ret != DRIZZLE_RETURN_OK)
75  {
76  printf("drizzle_query_run_all:%s\n", drizzle_error(&drizzle));
77  return 1;
78  }
79 
80  for (x= 0; x < SIMPLE_MULTI_COUNT; x++)
81  {
82  if (drizzle_result_error_code(&(result[x])) != 0)
83  {
84  printf("%d:%s\n", drizzle_result_error_code(&(result[x])),
85  drizzle_result_error(&(result[x])));
86  continue;
87  }
88 
89  while ((row= drizzle_row_next(&(result[x]))) != NULL)
90  printf("%d %s:%s\n", x, row[0], row[1]);
91  }
92 
93  drizzle_free(&drizzle);
94 
95  return 0;
96 }