69
69
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "drizzle_connect(): %s(%s)", drizzle_error(con), drizzle_strerror(ret));
71
drizzle_query_str(con, "DROP SCHEMA IF EXISTS libdrizzle", &ret);
71
drizzle_query(con, "DROP SCHEMA IF EXISTS libdrizzle", 0, &ret);
72
72
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA libdrizzle (%s)", drizzle_error(con));
74
drizzle_query_str(con, "CREATE SCHEMA libdrizzle", &ret);
74
drizzle_query(con, "CREATE SCHEMA libdrizzle", 0, &ret);
75
75
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA libdrizzle (%s)", drizzle_error(con));
77
77
ret= drizzle_select_db(con, "libdrizzle");
78
78
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "USE libdrizzle");
80
drizzle_query_str(con, "create table libdrizzle.t1 (a varchar(50))", &ret);
80
drizzle_query(con, "create table libdrizzle.t1 (a varchar(50))", 0, &ret);
81
81
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "create table libdrizzle.t1 (a int): %s", drizzle_error(con));
83
drizzle_query_str(con, "insert into libdrizzle.t1 values ('hello'),('drizzle'),('people')", &ret);
83
drizzle_query(con, "insert into libdrizzle.t1 values ('hello'),('drizzle'),('people')", 0, &ret);
84
84
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "%s", drizzle_error(con));
86
86
const char *query= "select * from libdrizzle.t1 where a = ?";
143
143
return EXIT_FAILURE;
146
drizzle_query_str(con, "DROP TABLE libdrizzle.t1", &ret);
146
drizzle_query(con, "DROP TABLE libdrizzle.t1", 0, &ret);
147
147
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP TABLE libdrizzle.t1");
149
drizzle_query_str(con, "DROP SCHEMA IF EXISTS libdrizzle", &ret);
149
drizzle_query(con, "DROP SCHEMA IF EXISTS libdrizzle", 0, &ret);
150
150
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP SCHEMA libdrizzle (%s)", drizzle_error(con));
152
152
ret= drizzle_quit(con);