2
* Drizzle Client & Protocol Library
4
* Copyright (C) 2008 Eric Day (eday@oddments.org)
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.
44
#include <libdrizzle-2.0/drizzle_server.h>
46
#define DRIZZLE_FIELD_MAX 32
47
#define DRIZZLE_RESULT_ROWS 20
49
#define DRIZZLE_RETURN_CHECK(__ret, __function, __drizzle) \
51
if ((__ret) != DRIZZLE_RETURN_OK) \
52
DRIZZLE_RETURN_ERROR(__function, __drizzle) \
55
#define DRIZZLE_RETURN_ERROR(__function, __drizzle) \
57
printf(__function ":%s\n", drizzle_error(__drizzle)); \
61
static void server(drizzle_st *drizzle, drizzle_con_st *con, drizzle_column_st *column);
63
int main(int argc, char *argv[])
67
const char *host= NULL;
70
drizzle_verbose_t verbose= DRIZZLE_VERBOSE_NEVER;
73
drizzle_column_st column;
75
while((c = getopt(argc, argv, "c:h:mp:v")) != -1)
80
count= (uint32_t)atoi(optarg);
92
port= (in_port_t)atoi(optarg);
98
case DRIZZLE_VERBOSE_NEVER:
99
verbose= DRIZZLE_VERBOSE_FATAL;
101
case DRIZZLE_VERBOSE_FATAL:
102
verbose= DRIZZLE_VERBOSE_ERROR;
104
case DRIZZLE_VERBOSE_ERROR:
105
verbose= DRIZZLE_VERBOSE_INFO;
107
case DRIZZLE_VERBOSE_INFO:
108
verbose= DRIZZLE_VERBOSE_DEBUG;
110
case DRIZZLE_VERBOSE_DEBUG:
111
verbose= DRIZZLE_VERBOSE_CRAZY;
113
case DRIZZLE_VERBOSE_CRAZY:
114
case DRIZZLE_VERBOSE_MAX:
120
printf("\nusage: %s [-c <count>] [-h <host>] [-m] [-p <port>] [-v]\n",
122
printf("\t-c <count> - Number of connections to accept before exiting\n");
123
printf("\t-h <host> - Host to listen on\n");
124
printf("\t-m - Use the MySQL protocol\n");
125
printf("\t-p <port> - Port to listen on\n");
126
printf("\t-v - Increase verbosity level\n");
131
if ((drizzle= drizzle_create()) == NULL)
133
fprintf(stderr, "drizzle_create:NULL\n");
137
drizzle_set_option(drizzle, DRIZZLE_FREE_OBJECTS, true);
138
drizzle_set_verbose(drizzle, verbose);
140
drizzle_con_st* con_listen;
141
if ((con_listen= drizzle_con_create(drizzle)) == NULL)
143
fprintf(stderr, "drizzle_con_create:NULL\n");
147
drizzle_con_add_options(con_listen, DRIZZLE_CON_LISTEN);
148
drizzle_con_set_tcp(con_listen, host, port);
152
drizzle_con_add_options(con_listen, DRIZZLE_CON_MYSQL);
155
if (drizzle_con_listen(con_listen) != DRIZZLE_RETURN_OK)
157
fprintf(stderr, "drizzle_con_listen:%s\n", drizzle_error(drizzle));
163
drizzle_con_st *con= drizzle_con_accept(drizzle, &ret);
164
if (ret != DRIZZLE_RETURN_OK)
166
fprintf(stderr, "drizzle_con_accept:%s\n", drizzle_error(drizzle));
170
server(drizzle, con, &column);
172
drizzle_con_free(con);
183
drizzle_con_free(con_listen);
184
drizzle_free(drizzle);
189
static void server(drizzle_st *drizzle, drizzle_con_st *con,
190
drizzle_column_st *column)
192
drizzle_return_t ret;
193
drizzle_command_t command;
197
char field1[DRIZZLE_FIELD_MAX];
198
char field2[DRIZZLE_FIELD_MAX];
205
/* Handshake packets. */
206
drizzle_con_set_protocol_version(con, 10);
207
drizzle_con_set_server_version(con, "libdrizzle example 1.2.3");
208
drizzle_con_set_thread_id(con, 1);
209
drizzle_con_set_scramble(con, (const uint8_t *)"ABCDEFGHIJKLMNOPQRST");
210
drizzle_con_set_capabilities(con, DRIZZLE_CAPABILITIES_NONE);
211
drizzle_con_set_charset(con, 8);
212
drizzle_con_set_status(con, DRIZZLE_CON_STATUS_NONE);
213
drizzle_con_set_max_packet_size(con, DRIZZLE_MAX_PACKET_SIZE);
215
ret= drizzle_handshake_server_write(con);
216
DRIZZLE_RETURN_CHECK(ret, "drizzle_handshake_server_write", drizzle)
218
ret= drizzle_handshake_client_read(con);
219
DRIZZLE_RETURN_CHECK(ret, "drizzle_handshake_client_read", drizzle);
221
drizzle_result_st *result;
222
if ((result= drizzle_result_create(con)) == NULL)
224
DRIZZLE_RETURN_ERROR("drizzle_result_create", drizzle)
227
ret= drizzle_result_write(con, result, true);
228
DRIZZLE_RETURN_CHECK(ret, "drizzle_result_write", drizzle)
233
drizzle_result_free(result);
236
data= (uint8_t *)drizzle_con_command_buffer(con, &command, &total, &ret);
237
if (ret == DRIZZLE_RETURN_LOST_CONNECTION ||
238
(ret == DRIZZLE_RETURN_OK && command == DRIZZLE_COMMAND_QUIT))
243
DRIZZLE_RETURN_CHECK(ret, "drizzle_con_command_buffer", drizzle)
245
if ((result= drizzle_result_create(con)) == NULL)
247
DRIZZLE_RETURN_ERROR("drizzle_result_create", drizzle)
250
if (command != DRIZZLE_COMMAND_QUERY)
252
ret= drizzle_result_write(con, result, true);
253
DRIZZLE_RETURN_CHECK(ret, "drizzle_result_write", drizzle)
257
drizzle_result_set_column_count(result, 2);
259
ret= drizzle_result_write(con, result, false);
260
DRIZZLE_RETURN_CHECK(ret, "drizzle_result_write", drizzle)
263
if (drizzle_column_create(result, column) == NULL)
265
DRIZZLE_RETURN_ERROR("drizzle_column_create", drizzle)
268
drizzle_column_set_catalog(column, "default");
269
drizzle_column_set_db(column, "drizzle_test_db");
270
drizzle_column_set_table(column, "drizzle_test_table");
271
drizzle_column_set_orig_table(column, "drizzle_test_table");
272
drizzle_column_set_name(column, "test_column_1");
273
drizzle_column_set_orig_name(column, "test_column_1");
274
drizzle_column_set_charset(column, 8);
275
drizzle_column_set_size(column, DRIZZLE_FIELD_MAX);
276
drizzle_column_set_type(column, DRIZZLE_COLUMN_TYPE_VARCHAR);
278
ret= drizzle_column_write(result, column);
279
DRIZZLE_RETURN_CHECK(ret, "drizzle_column_write", drizzle)
281
drizzle_column_set_name(column, "test_column_2");
282
drizzle_column_set_orig_name(column, "test_column_2");
284
ret= drizzle_column_write(result, column);
285
DRIZZLE_RETURN_CHECK(ret, "drizzle_column_write", drizzle)
287
drizzle_column_free(column);
289
drizzle_result_set_eof(result, true);
291
ret= drizzle_result_write(con, result, false);
292
DRIZZLE_RETURN_CHECK(ret, "drizzle_result_write", drizzle)
295
for (x= 0; x < DRIZZLE_RESULT_ROWS; x++)
297
size[0]= (size_t)snprintf(field[0], DRIZZLE_FIELD_MAX,
298
"field %" PRIu64 "-1", x);
299
if (size[0] >= DRIZZLE_FIELD_MAX)
300
size[0]= DRIZZLE_FIELD_MAX - 1;
302
size[1]= (size_t)snprintf(field[1], DRIZZLE_FIELD_MAX,
303
"field %" PRIu64 "-2", x);
304
if (size[1] >= DRIZZLE_FIELD_MAX)
305
size[1]= DRIZZLE_FIELD_MAX - 1;
307
/* This is needed for MySQL and old Drizzle protocol. */
308
drizzle_result_calc_row_size(result, (drizzle_field_t *)field, size);
310
ret= drizzle_row_write(result);
311
DRIZZLE_RETURN_CHECK(ret, "drizzle_row_write", drizzle)
314
ret= drizzle_field_write(result, (drizzle_field_t)field[0], size[0],
316
DRIZZLE_RETURN_CHECK(ret, "drizzle_field_write", drizzle)
318
ret= drizzle_field_write(result, (drizzle_field_t)field[1], size[1],
320
DRIZZLE_RETURN_CHECK(ret, "drizzle_field_write", drizzle)
323
ret= drizzle_result_write(con, result, true);
324
DRIZZLE_RETURN_CHECK(ret, "drizzle_result_write", drizzle)