4
4
* Copyright (C) 2008 Eric Day (eday@oddments.org)
5
5
* All rights reserved.
7
* Redistribution and use in source and binary forms, with or without
8
* modification, are permitted provided that the following conditions are
11
* * Redistributions of source code must retain the above copyright
12
* notice, this list of conditions and the following disclaimer.
14
* * Redistributions in binary form must reproduce the above
15
* copyright notice, this list of conditions and the following disclaimer
16
* in the documentation and/or other materials provided with the
19
* * The names of its contributors may not be used to endorse or
20
* promote products derived from this software without specific prior
23
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
24
* "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
25
* LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
26
* A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
27
* OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
28
* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
29
* LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
30
* DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
31
* THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
32
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
33
* OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
7
* Use and distribution licensed under the BSD license. See
8
* the COPYING.BSD file in the root source directory for full text.
41
12
#include <stdlib.h>
42
13
#include <string.h>
56
27
const char *query= "SELECT TABLE_SCHEMA,TABLE_NAME FROM TABLES";
57
28
drizzle_verbose_t verbose= DRIZZLE_VERBOSE_NEVER;
58
29
drizzle_st drizzle;
59
drizzle_con_st *con= (drizzle_con_st*)malloc(sizeof(drizzle_con_st));
60
31
drizzle_result_st result;
61
32
drizzle_return_t ret;
92
case DRIZZLE_VERBOSE_NEVER:
93
verbose= DRIZZLE_VERBOSE_FATAL;
95
case DRIZZLE_VERBOSE_FATAL:
96
verbose= DRIZZLE_VERBOSE_ERROR;
98
case DRIZZLE_VERBOSE_ERROR:
99
verbose= DRIZZLE_VERBOSE_INFO;
101
case DRIZZLE_VERBOSE_INFO:
102
verbose= DRIZZLE_VERBOSE_DEBUG;
104
case DRIZZLE_VERBOSE_DEBUG:
105
verbose= DRIZZLE_VERBOSE_CRAZY;
107
case DRIZZLE_VERBOSE_CRAZY:
108
case DRIZZLE_VERBOSE_MAX:
132
83
drizzle_set_verbose(&drizzle, verbose);
134
if (drizzle_con_create(&drizzle, con) == NULL)
85
if (drizzle_con_create(&drizzle, &con) == NULL)
136
87
printf("drizzle_con_create:NULL\n");
141
drizzle_con_add_options(con, DRIZZLE_CON_MYSQL);
143
drizzle_con_set_tcp(con, host, port);
144
drizzle_con_set_db(con, db);
146
(void)drizzle_query_str(con, &result, query, &ret);
92
drizzle_con_add_options(&con, DRIZZLE_CON_MYSQL);
94
drizzle_con_set_tcp(&con, host, port);
95
drizzle_con_set_db(&con, db);
97
(void)drizzle_query_str(&con, &result, query, &ret);
147
98
if (ret != DRIZZLE_RETURN_OK)
149
printf("drizzle_query:%s\n", drizzle_con_error(con));
100
printf("drizzle_query:%s\n", drizzle_con_error(&con));
153
104
ret= drizzle_result_buffer(&result);
154
105
if (ret != DRIZZLE_RETURN_OK)
156
printf("drizzle_result_buffer:%s\n", drizzle_con_error(con));
107
printf("drizzle_result_buffer:%s\n", drizzle_con_error(&con));