BOOST_FIXTURE_TEST_CASE(test_time_insert_time_select, fixture) {
using sql::select;
test1 t;
odbc::time write(3, 11, 17);
db.execute(insert_into(t)(t.id, t.val).values(1, write));
BOOST_RDB_CHECK_SELECT_RESULTS(db.execute(select(t.id, t.val).from(t)), "((1 03:11:17))");
}
BOOST_FIXTURE_TEST_CASE(test_time_bind_varchar, fixture) {
using sql::select;
test1 t;
varchar<30> write = "03:11:17";
db.prepare(insert_into(t)(t.id, t.val).values(1, _)).bind_parameters(write).execute();
varchar<30> read;
db.prepare(select(t.val).from(t)).bind_results(read).execute().fetch();
BOOST_CHECK(!read.is_null());
BOOST_CHECK_EQUAL(read.value(), "03:11:17");
}
BOOST_FIXTURE_TEST_CASE(test_time_bind_time, fixture) {
using sql::select;
test1 t;
odbc::time write(3, 11, 17);
db.prepare(insert_into(t)(t.id, t.val).values(1, _)).bind_parameters(write).execute();
odbc::time read;
db.prepare(select(t.val).from(t)).bind_results(read).execute().fetch();
BOOST_CHECK(!read.is_null());
BOOST_CHECK_EQUAL(read.value().hour, 3);
BOOST_CHECK_EQUAL(read.value().minute, 11);
BOOST_CHECK_EQUAL(read.value().second, 17);
}