71
71
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "drizzle_connect(): %s(%s)", drizzle_error(con), drizzle_strerror(ret));
73
drizzle_query(con, "DROP SCHEMA IF EXISTS libdrizzle", 0, &ret);
74
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA libdrizzle (%s)", drizzle_error(con));
76
drizzle_query(con, "CREATE SCHEMA libdrizzle", 0, &ret);
77
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA libdrizzle (%s)", drizzle_error(con));
79
ret= drizzle_select_db(con, "libdrizzle");
80
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "USE libdrizzle");
82
drizzle_query(con, "create table libdrizzle.t1 (a int)", 0, &ret);
83
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "create table libdrizzle.t1 (a int): %s", drizzle_error(con));
85
drizzle_query(con, "insert into libdrizzle.t1 values (1),(2),(3)", 0, &ret);
73
drizzle_query(con, "DROP SCHEMA IF EXISTS test_stmt", 0, &ret);
74
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA test_stmt (%s)", drizzle_error(con));
76
drizzle_query(con, "CREATE SCHEMA test_stmt", 0, &ret);
77
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA test_stmt (%s)", drizzle_error(con));
79
ret= drizzle_select_db(con, "test_stmt");
80
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "USE test_stmt");
82
drizzle_query(con, "create table test_stmt.t1 (a int)", 0, &ret);
83
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "create table test_stmt.t1 (a int): %s", drizzle_error(con));
85
drizzle_query(con, "insert into test_stmt.t1 values (1),(2),(3)", 0, &ret);
86
86
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "%s", drizzle_error(con));
88
const char *query= "select * from libdrizzle.t1 where a > ?";
88
const char *query= "select * from test_stmt.t1 where a > ?";
89
89
stmt= drizzle_stmt_prepare(con, query, strlen(query), &ret);
90
90
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "%s", drizzle_error(con));
146
146
ret = drizzle_stmt_close(stmt);
147
147
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "%s", drizzle_error(con));
149
drizzle_query(con, "DROP TABLE libdrizzle.t1", 0, &ret);
150
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP TABLE libdrizzle.t1");
149
drizzle_query(con, "DROP TABLE test_stmt.t1", 0, &ret);
150
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP TABLE test_stmt.t1");
152
drizzle_query(con, "DROP SCHEMA IF EXISTS libdrizzle", 0, &ret);
153
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP SCHEMA libdrizzle (%s)", drizzle_error(con));
152
drizzle_query(con, "DROP SCHEMA IF EXISTS test_stmt", 0, &ret);
153
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP SCHEMA test_stmt (%s)", drizzle_error(con));
155
155
ret= drizzle_quit(con);
156
156
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "%s", drizzle_strerror(ret));