65
65
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "%s", drizzle_error(con));
67
drizzle_query_str(con, "DROP SCHEMA IF EXISTS libdrizzle", &ret);
67
drizzle_query(con, "DROP SCHEMA IF EXISTS libdrizzle", 0, &ret);
68
68
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA libdrizzle (%s)", drizzle_error(con));
70
drizzle_query_str(con, "CREATE SCHEMA libdrizzle", &ret);
70
drizzle_query(con, "CREATE SCHEMA libdrizzle", 0, &ret);
71
71
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA libdrizzle (%s)", drizzle_error(con));
73
73
ret= drizzle_select_db(con, "libdrizzle");
74
74
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "USE libdrizzle");
76
drizzle_query_str(con, "create table libdrizzle.t1 (a int primary key auto_increment, b int)", &ret);
76
drizzle_query(con, "create table libdrizzle.t1 (a int primary key auto_increment, b int)", 0, &ret);
77
77
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "create table libdrizzle.t1 (a int primary key auto_increment, b int)");
79
drizzle_result_st *result= drizzle_query_str(con, "insert into libdrizzle.t1 (b) values (1),(2),(3)", &ret);
79
drizzle_result_st *result= drizzle_query(con, "insert into libdrizzle.t1 (b) values (1),(2),(3)", 0, &ret);
80
80
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "insert into libdrizzle.t1 (b) values (1),(2),(3)");
81
81
ASSERT_TRUE(result);
83
83
ASSERT_EQ_(drizzle_result_insert_id(result), 1, "Got bad insert_id (expected 1, got %"PRIu64")", drizzle_result_insert_id(result));
84
84
drizzle_result_free(result);
86
result= drizzle_query_str(con, "INSERT INTO libdrizzle.t1 (b) VALUES (4),(5),(6)", &ret);
86
result= drizzle_query(con, "INSERT INTO libdrizzle.t1 (b) VALUES (4),(5),(6)", 0, &ret);
87
87
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "INSERT INTO libdrizzle.t1 (b) VALUES (4),(5),(6)");
89
89
ASSERT_EQ_(drizzle_result_insert_id(result), 4, "Got bad insert_id (expected 4, got %"PRIu64")", drizzle_result_insert_id(result));
90
90
drizzle_result_free(result);
92
drizzle_query_str(con, "DROP TABLE libdrizzle.t1", &ret);
92
drizzle_query(con, "DROP TABLE libdrizzle.t1", 0, &ret);
93
93
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "dROP TABLE failure");
95
drizzle_query_str(con, "DROP SCHEMA IF EXISTS libdrizzle", &ret);
95
drizzle_query(con, "DROP SCHEMA IF EXISTS libdrizzle", 0, &ret);
96
96
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP SCHEMA libdrizzle (%s)", drizzle_error(con));
98
98
ret= drizzle_quit(con);