67
69
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "%s", drizzle_error(con));
69
drizzle_query(con, "DROP SCHEMA IF EXISTS libdrizzle", 0, &ret);
70
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA libdrizzle (%s)", drizzle_error(con));
71
CHECKED_QUERY("DROP SCHEMA IF EXISTS libdrizzle");
72
drizzle_query(con, "CREATE SCHEMA libdrizzle", 0, &ret);
73
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA libdrizzle (%s)", drizzle_error(con));
73
CHECKED_QUERY("CREATE SCHEMA libdrizzle");
75
75
ret= drizzle_select_db(con, "libdrizzle");
76
76
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "USE libdrizzle");
78
drizzle_query(con, "create table libdrizzle.t1 (a int primary key auto_increment, b int)", 0, &ret);
79
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "create table libdrizzle.t1 (a int primary key auto_increment, b int)");
78
CHECKED_QUERY("create table libdrizzle.t1 (a int primary key auto_increment, b int)");
81
80
drizzle_result_st *result= drizzle_query(con, "insert into libdrizzle.t1 (b) values (1),(2),(3)", 0, &ret);
82
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "insert into libdrizzle.t1 (b) values (1),(2),(3)");
81
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "insert into libdrizzle.t1 (b) values (1),(2),(3): %s", drizzle_error(con));
83
82
ASSERT_TRUE(result);
85
84
ASSERT_EQ_(drizzle_result_insert_id(result), 1, "Got bad insert_id (expected 1, got %"PRIu64")", drizzle_result_insert_id(result));
86
85
drizzle_result_free(result);
88
87
result= drizzle_query(con, "INSERT INTO libdrizzle.t1 (b) VALUES (4),(5),(6)", 0, &ret);
89
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "INSERT INTO libdrizzle.t1 (b) VALUES (4),(5),(6)");
88
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "INSERT INTO libdrizzle.t1 (b) VALUES (4),(5),(6): %s", drizzle_error(con));
91
90
ASSERT_EQ_(drizzle_result_insert_id(result), 4, "Got bad insert_id (expected 4, got %"PRIu64")", drizzle_result_insert_id(result));
92
91
drizzle_result_free(result);
94
drizzle_query(con, "DROP TABLE libdrizzle.t1", 0, &ret);
95
ASSERT_EQ_(ret, DRIZZLE_RETURN_OK, "dROP TABLE failure");
93
CHECKED_QUERY("DROP TABLE libdrizzle.t1");
97
drizzle_query(con, "DROP SCHEMA IF EXISTS libdrizzle", 0, &ret);
98
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP SCHEMA libdrizzle (%s)", drizzle_error(con));
95
CHECKED_QUERY("DROP SCHEMA libdrizzle");
100
97
ret= drizzle_quit(con);
101
98
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "%s", drizzle_strerror(ret));