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.
39
* @brief Query definitions
44
drizzle_result_st *drizzle_query(drizzle_con_st *con, drizzle_result_st *result,
45
const char *query, size_t size,
46
drizzle_return_t *ret_ptr)
48
return drizzle_con_command_write(con, result, DRIZZLE_COMMAND_QUERY,
49
(uint8_t *)query, size, size, ret_ptr);
52
drizzle_result_st *drizzle_query_str(drizzle_con_st *con,
53
drizzle_result_st *result,
55
drizzle_return_t *ret_ptr)
61
return drizzle_con_command_write(con, result, DRIZZLE_COMMAND_QUERY,
62
(uint8_t *)query, size, size, ret_ptr);
65
drizzle_result_st *drizzle_query_inc(drizzle_con_st *con,
66
drizzle_result_st *result,
67
const char *query, size_t size,
68
size_t total, drizzle_return_t *ret_ptr)
70
return drizzle_con_command_write(con, result, DRIZZLE_COMMAND_QUERY,
71
(uint8_t *)query, size, total, ret_ptr);
74
drizzle_query_st *drizzle_query_add(drizzle_st *drizzle,
75
drizzle_query_st *query,
77
drizzle_result_st *result,
78
const char *query_string, size_t size,
79
drizzle_query_options_t options,
82
query= drizzle_query_create(drizzle, query);
86
drizzle_query_set_con(query, con);
87
drizzle_query_set_result(query, result);
88
drizzle_query_set_string(query, query_string, size);
89
drizzle_query_add_options(query, options);
90
drizzle_query_set_context(query, context);
95
drizzle_query_st *drizzle_query_create(drizzle_st *drizzle,
96
drizzle_query_st *query)
100
query= new drizzle_query_st;
101
query->options|= DRIZZLE_CON_ALLOCATED;
107
query->state= DRIZZLE_QUERY_STATE_INIT;
112
query->context= NULL;
113
query->context_free_fn= NULL;
116
query->drizzle= drizzle;
118
if (drizzle->query_list)
119
drizzle->query_list->prev= query;
120
query->next= drizzle->query_list;
121
drizzle->query_list= query;
122
drizzle->query_count++;
123
drizzle->query_new++;
128
void drizzle_query_free(drizzle_query_st *query)
130
if (query->context != NULL && query->context_free_fn != NULL)
131
query->context_free_fn(query, query->context);
133
if (query->drizzle->query_list == query)
134
query->drizzle->query_list= query->next;
136
query->prev->next= query->next;
138
query->next->prev= query->prev;
139
query->drizzle->query_count--;
141
if (query->options & DRIZZLE_QUERY_ALLOCATED)
145
void drizzle_query_free_all(drizzle_st *drizzle)
147
while (drizzle->query_list != NULL)
148
drizzle_query_free(drizzle->query_list);
151
drizzle_con_st *drizzle_query_con(drizzle_query_st *query)
156
void drizzle_query_set_con(drizzle_query_st *query, drizzle_con_st *con)
161
drizzle_result_st *drizzle_query_result(drizzle_query_st *query)
163
return query->result;
166
void drizzle_query_set_result(drizzle_query_st *query,
167
drizzle_result_st *result)
169
query->result= result;
172
char *drizzle_query_string(drizzle_query_st *query, size_t *size)
175
return (char *)(query->string);
178
void drizzle_query_set_string(drizzle_query_st *query, const char *string,
181
query->string= string;
185
int drizzle_query_options(drizzle_query_st *query)
187
return query->options;
190
void drizzle_query_set_options(drizzle_query_st *query,
193
query->options= options;
196
void drizzle_query_add_options(drizzle_query_st *query,
199
query->options|= options;
202
void drizzle_query_remove_options(drizzle_query_st *query,
205
query->options&= ~options;
208
void *drizzle_query_context(drizzle_query_st *query)
210
return query->context;
213
void drizzle_query_set_context(drizzle_query_st *query, void *context)
215
query->context= context;
218
void drizzle_query_set_context_free_fn(drizzle_query_st *query,
219
drizzle_query_context_free_fn *function)
221
query->context_free_fn= function;
224
static void drizzle_query_run_state(drizzle_query_st* query,
225
drizzle_return_t* ret_ptr)
227
switch (query->state)
229
case DRIZZLE_QUERY_STATE_INIT:
230
query->state= DRIZZLE_QUERY_STATE_QUERY;
231
case DRIZZLE_QUERY_STATE_QUERY:
232
query->result= drizzle_query(query->con, query->result, query->string,
233
query->size, ret_ptr);
234
if (*ret_ptr == DRIZZLE_RETURN_IO_WAIT)
238
else if (*ret_ptr != DRIZZLE_RETURN_OK)
240
query->state= DRIZZLE_QUERY_STATE_DONE;
244
query->state= DRIZZLE_QUERY_STATE_RESULT;
246
case DRIZZLE_QUERY_STATE_RESULT:
247
*ret_ptr= drizzle_result_buffer(query->result);
248
if (*ret_ptr == DRIZZLE_RETURN_IO_WAIT)
253
query->state= DRIZZLE_QUERY_STATE_DONE;
257
case DRIZZLE_QUERY_STATE_DONE:
262
drizzle_query_st *drizzle_query_run(drizzle_st *drizzle,
263
drizzle_return_t *ret_ptr)
266
drizzle_query_st *query;
269
if (drizzle->query_new == 0 && drizzle->query_running == 0)
271
*ret_ptr= DRIZZLE_RETURN_OK;
275
options= drizzle->options;
276
drizzle->options|= DRIZZLE_NON_BLOCKING;
278
/* Check to see if any queries need to be started. */
279
if (drizzle->query_new > 0)
281
for (query= drizzle->query_list; query != NULL; query= query->next)
283
if (query->state != DRIZZLE_QUERY_STATE_INIT)
286
drizzle->query_new--;
287
drizzle->query_running++;
288
assert(query->con->query == NULL);
289
query->con->query= query;
291
drizzle_query_run_state(query, ret_ptr);
292
if (*ret_ptr != DRIZZLE_RETURN_IO_WAIT)
294
assert(query->state == DRIZZLE_QUERY_STATE_DONE);
295
drizzle->query_running--;
296
drizzle->options= options;
297
query->con->query= NULL;
298
if (*ret_ptr == DRIZZLE_RETURN_ERROR_CODE || *ret_ptr == DRIZZLE_RETURN_OK)
305
assert(drizzle->query_new == 0);
310
/* Loop through each active connection. */
311
while ((con= drizzle_con_ready(drizzle)) != NULL)
314
drizzle_query_run_state(query, ret_ptr);
315
if (query->state == DRIZZLE_QUERY_STATE_DONE)
317
drizzle->query_running--;
318
drizzle->options= options;
322
assert(*ret_ptr == DRIZZLE_RETURN_IO_WAIT);
325
if (options & DRIZZLE_NON_BLOCKING)
327
*ret_ptr= DRIZZLE_RETURN_IO_WAIT;
331
*ret_ptr= drizzle_con_wait(drizzle);
332
if (*ret_ptr != DRIZZLE_RETURN_OK)
334
drizzle->options= options;
340
drizzle_return_t drizzle_query_run_all(drizzle_st *drizzle)
342
drizzle_return_t ret;
344
while (drizzle->query_new > 0 || drizzle->query_running > 0)
346
(void)drizzle_query_run(drizzle, &ret);
347
if (ret != DRIZZLE_RETURN_OK && ret != DRIZZLE_RETURN_ERROR_CODE)
351
return DRIZZLE_RETURN_OK;
354
ssize_t drizzle_safe_escape_string(char *to, size_t max_to_size, const char *from, size_t from_size)
360
for (end= from + from_size; from < end; from++)
363
/* All multi-byte UTF8 characters have the high bit set for all bytes. */
395
if ((size_t)to_size + 2 > max_to_size)
404
if ((size_t)to_size + 1 > max_to_size)
417
size_t drizzle_escape_string(char *to, const char *from, size_t from_size)
419
return (size_t) drizzle_safe_escape_string(to, (from_size * 2), from, from_size);
422
size_t drizzle_hex_string(char *to, const char *from, size_t from_size)
424
static const char hex_map[]= "0123456789ABCDEF";
425
const char *from_end;
427
for (from_end= from + from_size; from != from_end; from++)
429
*to++= hex_map[((unsigned char) *from) >> 4];
430
*to++= hex_map[((unsigned char) *from) & 0xF];
435
return from_size * 2;
438
void drizzle_mysql_password_hash(char *to, const char *from, size_t from_size)
441
uint8_t hash_tmp1[SHA1_DIGEST_LENGTH];
442
uint8_t hash_tmp2[SHA1_DIGEST_LENGTH];
445
SHA1Update(&ctx, (const uint8_t*)from, from_size);
446
SHA1Final(hash_tmp1, &ctx);
449
SHA1Update(&ctx, hash_tmp1, SHA1_DIGEST_LENGTH);
450
SHA1Final(hash_tmp2, &ctx);
452
(void)drizzle_hex_string(to, (char*)hash_tmp2, SHA1_DIGEST_LENGTH);