38
#include <yatl/lite.h>
38
40
#include <libdrizzle-5.1/libdrizzle.h>
40
42
#include <stdlib.h>
41
43
#include <stdint.h>
42
44
#include <inttypes.h>
48
46
int main(int argc, char *argv[])
54
drizzle_result_st *result;
56
con = drizzle_create_tcp("localhost", 3306, "root", "", "libdrizzle", 0);
59
printf("Drizzle connection object creation error\n");
62
ret = drizzle_connect(con);
51
drizzle_st *con= drizzle_create_tcp("localhost", 3306, "root", "", "libdrizzle", 0);
52
ASSERT_NOT_NULL_(con, "Drizzle connection object creation error");
54
drizzle_return_t ret= drizzle_connect(con);
63
55
if (ret != DRIZZLE_RETURN_OK)
65
printf("Drizzle connection failure\n");
58
SKIP_IF_(ret != DRIZZLE_RETURN_OK, "Drizzle connection failure");
70
61
drizzle_query_str(con, "create table libdrizzle.t1 (a int primary key auto_increment, b int)", &ret);
71
if (ret != DRIZZLE_RETURN_OK)
73
printf("Create table failure\n");
77
result= drizzle_query_str(con, "insert into libdrizzle.t1 (b) values (1),(2),(3)", &ret);
78
if (ret != DRIZZLE_RETURN_OK)
80
printf("Insert failure\n");
84
if (drizzle_result_insert_id(result) != 1)
86
printf("Got bad insert_id (expected 1, got %"PRIu64")", drizzle_result_insert_id(result));
89
drizzle_result_free(result);
91
result= drizzle_query_str(con, "insert into libdrizzle.t1 (b) values (4),(5),(6)", &ret);
92
if (ret != DRIZZLE_RETURN_OK)
94
printf("Insert failure\n");
98
if (drizzle_result_insert_id(result) != 4)
100
printf("Got bad insert_id (expected 4, got %"PRIu64")", drizzle_result_insert_id(result));
103
drizzle_result_free(result);
105
drizzle_query_str(con, "drop table libdrizzle.t1", &ret);
106
if (ret != DRIZZLE_RETURN_OK)
108
printf("Drop table failure\n");
62
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "create table libdrizzle.t1 (a int primary key auto_increment, b int)");
64
drizzle_result_st *result= drizzle_query_str(con, "insert into libdrizzle.t1 (b) values (1),(2),(3)", &ret);
65
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "insert into libdrizzle.t1 (b) values (1),(2),(3)");
68
ASSERT_EQ_(drizzle_result_insert_id(result), 1, "Got bad insert_id (expected 1, got %"PRIu64")", drizzle_result_insert_id(result));
69
drizzle_result_free(result);
71
result= drizzle_query_str(con, "INSERT INTO libdrizzle.t1 (b) VALUES (4),(5),(6)", &ret);
72
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "INSERT INTO libdrizzle.t1 (b) VALUES (4),(5),(6)");
74
ASSERT_EQ_(drizzle_result_insert_id(result), 4, "Got bad insert_id (expected 4, got %"PRIu64")", drizzle_result_insert_id(result));
75
drizzle_result_free(result);
77
drizzle_query_str(con, "DROP TABLE libdrizzle.t1", &ret);
78
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "dROP TABLE failure");
113
80
drizzle_quit(con);
114
81
return EXIT_SUCCESS;