aboutsummaryrefslogtreecommitdiff
path: root/query
diff options
context:
space:
mode:
Diffstat (limited to 'query')
-rw-r--r--query/driver.cxx24
-rw-r--r--query/person.hxx16
2 files changed, 36 insertions, 4 deletions
diff --git a/query/driver.cxx b/query/driver.cxx
index 5b7c926..1be6107 100644
--- a/query/driver.cxx
+++ b/query/driver.cxx
@@ -27,7 +27,12 @@ print (result& r)
{
for (result::iterator i (r.begin ()); i != r.end (); ++i)
{
- cout << i->first () << " " << i->last () << " " << i->age () << endl;
+ cout << i->first () << " ";
+
+ if (!i->middle ().null ())
+ cout << i->middle ().get () << " ";
+
+ cout << i->last () << " " << i->age () << endl;
}
cout << endl;
@@ -48,9 +53,9 @@ main (int argc, char* argv[])
p.push_back (person ("John", "Doe", 21));
p.push_back (person ("John", "Smith", 22));
p.push_back (person ("Jack", "Johnson", 31));
- p.push_back (person ("John", "Jackson", 32));
- p.push_back (person ("Jane", "Doe", 23));
- p.push_back (person ("Jane", "Smith", 24));
+ p.push_back (person ("John", "JJ", "Jackson", 32));
+ p.push_back (person ("Jane", "JD", "Doe", 23));
+ p.push_back (person ("Jane", "JS", "Smith", 24));
transaction t (db->begin ());
@@ -174,6 +179,17 @@ main (int argc, char* argv[])
t.commit ();
}
+
+ // Query that shows how to test for NULL values using the
+ // is_null()/is_not_null() functions.
+ //
+ {
+ transaction t (db->begin ());
+ result r (db->query<person> (query::middle.is_not_null ()));
+ print (r);
+ t.commit ();
+ }
+
}
catch (const odb::exception& e)
{
diff --git a/query/person.hxx b/query/person.hxx
index 72da079..db312f2 100644
--- a/query/person.hxx
+++ b/query/person.hxx
@@ -8,6 +8,7 @@
#include <string>
#include <odb/core.hxx>
+#include <odb/nullable.hxx>
#pragma db object
class person
@@ -20,12 +21,26 @@ public:
{
}
+ person (const std::string& first,
+ const std::string& middle,
+ const std::string& last,
+ unsigned short age)
+ : first_ (first), middle_ (middle), last_ (last), age_ (age)
+ {
+ }
+
const std::string&
first () const
{
return first_;
}
+ const odb::nullable<std::string>&
+ middle () const
+ {
+ return middle_;
+ }
+
const std::string&
last () const
{
@@ -47,6 +62,7 @@ private:
unsigned long id_;
std::string first_;
+ odb::nullable<std::string> middle_;
std::string last_;
unsigned short age_;
};