From 7acbe9233bdad08182042cf609f1a92bfb5f32c3 Mon Sep 17 00:00:00 2001
From: Boris Kolpackov <boris@codesynthesis.com>
Date: Fri, 6 Feb 2015 08:57:30 +0200
Subject: Implement join types support in views

---
 view/driver.cxx | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

(limited to 'view/driver.cxx')

diff --git a/view/driver.cxx b/view/driver.cxx
index 74d6eed..d975cc4 100644
--- a/view/driver.cxx
+++ b/view/driver.cxx
@@ -314,6 +314,28 @@ main (int argc, char* argv[])
       t.commit ();
     }
 
+    // Get the list of employers that have any employees.
+    //
+    {
+      typedef odb::result<employer_with_employees> result;
+
+      shared_ptr<employer> es (new employer (3, "Empty Shell LLC"));
+
+      transaction t (db->begin ());
+      db->persist (es);
+
+      result r (db->query<employer_with_employees> ());
+
+      cout << "Employers with employees" << endl;
+
+      for (result::iterator i (r.begin ()); i != r.end (); ++i)
+        cout << "  " << i->e->name () << endl;
+
+      cout << endl;
+
+      db->erase (es);
+      t.commit ();
+    }
 
     // Get the list of employees that have accumulated vacation days.
     //
-- 
cgit v1.1