Generate database schema from database model instead of C++ model

We now first create the so-called database model from C++ model and
then use that to generate the database schema. The new approach also
adds more general support for primary/foreign keys, including multi-
column keys. Finally, for MySQL we now generate out-of-line foreign
key definitions. Because MySQL does not support deferred constraints
checking, deferred foreign keys are written commented out, for
documentation.

1 files changed, 100 insertions, 0 deletions

diff --git a/odb/semantics/relational/key.hxx b/odb/semantics/relational/key.hxx
new file mode 100644
index 0000000..7e7a847
--- /dev/null
+++ b/odb/semantics/relational/key.hxx
@@ -0,0 +1,100 @@
+// file      : odb/semantics/relational/key.hxx
+// author    : Boris Kolpackov <boris@codesynthesis.com>
+// copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+// license   : GNU GPL v3; see accompanying LICENSE file
+
+#ifndef ODB_SEMANTICS_RELATIONAL_KEY_HXX
+#define ODB_SEMANTICS_RELATIONAL_KEY_HXX
+
+#include <odb/semantics/relational/elements.hxx>
+#include <odb/semantics/relational/column.hxx>
+
+namespace semantics
+{
+  namespace relational
+  {
+    class key;
+
+    class contains: public edge
+    {
+    public:
+      typedef relational::key key_type;
+      typedef relational::column column_type;
+
+      key_type&
+      key () const
+      {
+        return *key_;
+      }
+
+      column_type&
+      column () const
+      {
+        return *column_;
+      }
+
+    public:
+      void
+      set_left_node (key_type& n)
+      {
+        key_ = &n;
+      }
+
+      void
+      set_right_node (column_type& n)
+      {
+        column_ = &n;
+      }
+
+    protected:
+      key_type* key_;
+      column_type* column_;
+    };
+
+    class key: public nameable
+    {
+      typedef std::vector<contains*> contains_list;
+
+    public:
+      typedef
+      pointer_iterator<contains_list::const_iterator>
+      contains_iterator;
+
+      contains_iterator
+      contains_begin () const
+      {
+        return contains_.begin ();
+      }
+
+      contains_iterator
+      contains_end () const
+      {
+        return contains_.end ();
+      }
+
+      contains_list::size_type
+      contains_size () const
+      {
+        return contains_.size ();
+      }
+
+    public:
+      void
+      add_edge_left (contains& e)
+      {
+        contains_.push_back (&e);
+      }
+
+    protected:
+      key (string const& id)
+          : nameable (id)
+      {
+      }
+
+    private:
+      contains_list contains_;
+    };
+  }
+}
+
+#endif // ODB_SEMANTICS_RELATIONAL_KEY_HXX