diff options
| author | Constantin Michael <constantin@codesynthesis.com> | 2011-10-26 15:37:32 +0200 |
|---|---|---|
| committer | Constantin Michael <constantin@codesynthesis.com> | 2011-10-26 17:16:04 +0200 |
| commit | 06712594f44e8300570103c05f54d686dfc4fb53 (patch) | |
| tree | 1bcb3b857160268ef8b8b6a4db88fb30de762062 /common/query/driver.cxx | |
| parent | 899732d4e111e0144d3e3bbaa91c054950361e1c (diff) | |
Add BLOB comparison and null predicate test cases to query test
Diffstat (limited to 'common/query/driver.cxx')
| -rw-r--r-- | common/query/driver.cxx | 44 |
1 files changed, 41 insertions, 3 deletions
diff --git a/common/query/driver.cxx b/common/query/driver.cxx index bc8fd1d..1d19860 100644 --- a/common/query/driver.cxx +++ b/common/query/driver.cxx @@ -13,6 +13,7 @@ #include <odb/database.hxx> #include <odb/transaction.hxx> +#include <common/config.hxx> // DATABASE_XXX #include <common/common.hxx> #include "test.hxx" @@ -35,9 +36,16 @@ print (result<person>& r) const char* names[] = { "John", "Jane", "Joe" }; const char** names_end = names + sizeof (names)/sizeof (names[0]); +const char* key_data[] = { "\x23\x03\x15", "\x13\x13\x54", "\x08\x62\x35" }; + int main (int argc, char* argv[]) { + vector<char> + key1 (key_data[0], key_data[0] + 3), + key2 (key_data[1], key_data[1] + 3), + key3 (key_data[2], key_data[2] + 3); + try { auto_ptr<database> db (create_database (argc, argv)); @@ -48,9 +56,9 @@ main (int argc, char* argv[]) // // { - person p1 (1, "John", "Doe", 30, true); - person p2 (2, "Jane", "Doe", 29, true); - person p3 (3, "Joe", "Dirt", 31, false); + person p1 (1, "John", "Doe", 30, true, key1); + person p2 (2, "Jane", "Doe", 29, true, key2); + person p3 (3, "Joe", "Dirt", 31, false, key3); p3.middle_name_.reset (new string ("Squeaky")); person p4 (4, "Johansen", "Johansen", 32, false); p4.middle_name_.reset (new string ("J")); @@ -416,6 +424,36 @@ main (int argc, char* argv[]) t.commit (); } + // Test BLOB column operations. + // + cout << "test 016" << endl; + { + transaction t (db->begin ()); + + result r; + +#ifndef DATABASE_ORACLE + // == + // + r = db->query<person> (query::public_key == key2); + + result::iterator i (r.begin ()); + assert (i != r.end ()); + assert (i->public_key_ == key2); +#endif + + // is_null + // + r = db->query<person> (query::public_key.is_null ()); + print (r); + + // is_not_null + // + r = db->query<person> (query::public_key.is_not_null ()); + print (r); + + t.commit (); + } } catch (const odb::exception& e) { |