From 7a1be868574beb4843d189a7d9d758d608da65c9 Mon Sep 17 00:00:00 2001
From: Boris Kolpackov <boris@codesynthesis.com>
Date: Tue, 27 Sep 2011 11:20:31 +0200
Subject: Add support for associating tables with views

---
 common/view/test.hxx | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)

(limited to 'common/view/test.hxx')

diff --git a/common/view/test.hxx b/common/view/test.hxx
index 37486aa..2497097 100644
--- a/common/view/test.hxx
+++ b/common/view/test.hxx
@@ -172,6 +172,21 @@ struct view1c
   unsigned short age;
 };
 
+// Assembled SELECT and FROM-lists.
+//
+#pragma db view table("common_view_person")
+struct view1d
+{
+  #pragma db column("first")
+  std::string first;
+
+  #pragma db column("last")
+  std::string last;
+
+  #pragma db column("age")
+  unsigned short age;
+};
+
 //
 // Count view plus associated object.
 //
@@ -330,6 +345,23 @@ struct view6b
   std::string employer;
 };
 
+// The same using tables.
+//
+#pragma db view table("common_view_person" = "p") \
+  table("common_view_employer_employees" = "ee": "ee.value = p.id") \
+  table("common_view_employer" = "e": "ee.object_id = e.name")
+struct view6c
+{
+  #pragma db column("p.first")
+  std::string first_name;
+
+  #pragma db column("p"."last")
+  std::string last_name;
+
+  #pragma db column("e.name")
+  std::string employer;
+};
+
 //
 // JOIN via a custom condition.
 //
-- 
cgit v1.1