66
66
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "drizzle_connect(): %s(%s)", drizzle_error(con), drizzle_strerror(ret));
68
drizzle_query_str(con, "DROP SCHEMA IF EXISTS libdrizzle", &ret);
68
drizzle_query(con, "DROP SCHEMA IF EXISTS libdrizzle", 0, &ret);
69
69
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA libdrizzle (%s)", drizzle_error(con));
71
drizzle_query_str(con, "CREATE SCHEMA libdrizzle", &ret);
71
drizzle_query(con, "CREATE SCHEMA libdrizzle", 0, &ret);
72
72
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA libdrizzle (%s)", drizzle_error(con));
74
74
ret= drizzle_select_db(con, "libdrizzle");
75
75
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "USE libdrizzle");
77
drizzle_query_str(con, "create table libdrizzle.t1 (a int)", &ret);
77
drizzle_query(con, "create table libdrizzle.t1 (a int)", 0, &ret);
78
78
if (ret != DRIZZLE_RETURN_OK)
80
80
printf("Create table failure\n");
81
81
return EXIT_FAILURE;
84
drizzle_query_str(con, "insert into libdrizzle.t1 values (1),(2),(3)", &ret);
84
drizzle_query(con, "insert into libdrizzle.t1 values (1),(2),(3)", 0, &ret);
85
85
if (ret != DRIZZLE_RETURN_OK)
87
87
printf("Insert failure\n");
88
88
return EXIT_FAILURE;
91
drizzle_result_st *result= drizzle_query_str(con, "select * from libdrizzle.t1", &ret);
91
drizzle_result_st *result= drizzle_query(con, "select * from libdrizzle.t1", 0, &ret);
92
92
if (ret != DRIZZLE_RETURN_OK)
94
94
printf("Select failure\n");
124
124
drizzle_result_free(result);
126
drizzle_query_str(con, "DROP TABLE libdrizzle.t1", &ret);
126
drizzle_query(con, "DROP TABLE libdrizzle.t1", 0, &ret);
127
127
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP TABLE libdrizzle.t1");
129
drizzle_query_str(con, "DROP SCHEMA IF EXISTS libdrizzle", &ret);
129
drizzle_query(con, "DROP SCHEMA IF EXISTS libdrizzle", 0, &ret);
130
130
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP SCHEMA libdrizzle (%s)", drizzle_error(con));
132
132
ret= drizzle_quit(con);