68
68
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "drizzle_connect(): %s(%s)", drizzle_error(con), drizzle_strerror(ret));
70
drizzle_query_str(con, "DROP SCHEMA IF EXISTS libdrizzle", &ret);
70
drizzle_query(con, "DROP SCHEMA IF EXISTS libdrizzle", 0, &ret);
71
71
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA libdrizzle (%s)", drizzle_error(con));
73
drizzle_query_str(con, "CREATE SCHEMA libdrizzle", &ret);
73
drizzle_query(con, "CREATE SCHEMA libdrizzle", 0, &ret);
74
74
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA libdrizzle (%s)", drizzle_error(con));
76
76
ret= drizzle_select_db(con, "libdrizzle");
77
77
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "USE libdrizzle");
79
drizzle_query_str(con, "create table libdrizzle.t1 (a int)", &ret);
79
drizzle_query(con, "create table libdrizzle.t1 (a int)", 0, &ret);
80
80
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "create table libdrizzle.t1 (a int): %s", drizzle_error(con));
82
drizzle_query_str(con, "insert into libdrizzle.t1 values (1),(2),(3)", &ret);
82
drizzle_query(con, "insert into libdrizzle.t1 values (1),(2),(3)", 0, &ret);
83
83
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "%s", drizzle_error(con));
85
85
const char *query= "select * from libdrizzle.t1 where a > ?";
159
159
return EXIT_FAILURE;
162
drizzle_query_str(con, "DROP TABLE libdrizzle.t1", &ret);
162
drizzle_query(con, "DROP TABLE libdrizzle.t1", 0, &ret);
163
163
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP TABLE libdrizzle.t1");
165
drizzle_query_str(con, "DROP SCHEMA IF EXISTS libdrizzle", &ret);
165
drizzle_query(con, "DROP SCHEMA IF EXISTS libdrizzle", 0, &ret);
166
166
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP SCHEMA libdrizzle (%s)", drizzle_error(con));
168
168
ret= drizzle_quit(con);