67
67
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "drizzle_connect(): %s(%s)", drizzle_error(con), drizzle_strerror(ret));
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));
72
drizzle_query(con, "CREATE SCHEMA libdrizzle", 0, &ret);
73
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA libdrizzle (%s)", drizzle_error(con));
75
ret= drizzle_select_db(con, "libdrizzle");
76
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "USE libdrizzle");
78
drizzle_query(con, "create table libdrizzle.t1 (a int)", 0, &ret);
69
drizzle_query(con, "DROP SCHEMA IF EXISTS test_row", 0, &ret);
70
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA test_row (%s)", drizzle_error(con));
72
drizzle_query(con, "CREATE SCHEMA test_row", 0, &ret);
73
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "CREATE SCHEMA test_row (%s)", drizzle_error(con));
75
ret= drizzle_select_db(con, "test_row");
76
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "USE test_row");
78
drizzle_query(con, "create table test_row.t1 (a int)", 0, &ret);
79
79
if (ret != DRIZZLE_RETURN_OK)
81
81
printf("Create table failure\n");
82
82
return EXIT_FAILURE;
85
drizzle_query(con, "insert into libdrizzle.t1 values (1),(2),(3)", 0, &ret);
85
drizzle_query(con, "insert into test_row.t1 values (1),(2),(3)", 0, &ret);
86
86
if (ret != DRIZZLE_RETURN_OK)
88
88
printf("Insert failure\n");
89
89
return EXIT_FAILURE;
92
drizzle_result_st *result= drizzle_query(con, "select * from libdrizzle.t1", 0, &ret);
92
drizzle_result_st *result= drizzle_query(con, "select * from test_row.t1", 0, &ret);
93
93
if (ret != DRIZZLE_RETURN_OK)
95
95
printf("Select failure\n");
149
149
drizzle_result_free(result);
151
drizzle_query(con, "DROP TABLE libdrizzle.t1", 0, &ret);
152
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP TABLE libdrizzle.t1");
151
drizzle_query(con, "DROP TABLE test_row.t1", 0, &ret);
152
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP TABLE test_row.t1");
154
drizzle_query(con, "DROP SCHEMA IF EXISTS libdrizzle", 0, &ret);
155
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP SCHEMA libdrizzle (%s)", drizzle_error(con));
154
drizzle_query(con, "DROP SCHEMA IF EXISTS test_row", 0, &ret);
155
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "DROP SCHEMA test_row (%s)", drizzle_error(con));
157
157
ret= drizzle_quit(con);
158
158
ASSERT_EQ_(DRIZZLE_RETURN_OK, ret, "%s", drizzle_strerror(ret));