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, 87 insertions, 0 deletions

diff --git a/odb/semantics/relational/foreign-key.hxx b/odb/semantics/relational/foreign-key.hxx
new file mode 100644
index 0000000..4a0b543
--- /dev/null
+++ b/odb/semantics/relational/foreign-key.hxx
@@ -0,0 +1,87 @@
+// file      : odb/semantics/relational/foreign-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_FOREIGN_KEY_HXX
+#define ODB_SEMANTICS_RELATIONAL_FOREIGN_KEY_HXX
+
+#include <odb/semantics/relational/elements.hxx>
+#include <odb/semantics/relational/key.hxx>
+
+namespace semantics
+{
+  namespace relational
+  {
+    class foreign_key: public key
+    {
+    public:
+      enum action
+      {
+        no_action,
+        cascade
+      };
+
+      foreign_key (string const& id,
+                   string const& referenced_table,
+                   bool deferred,
+                   action on_delete = no_action)
+          : key (id),
+            referenced_table_ (referenced_table),
+            deferred_ (deferred),
+            on_delete_ (on_delete)
+      {
+      }
+
+    public:
+      string
+      referenced_table () const
+      {
+        return referenced_table_;
+      }
+
+      typedef std::vector<string> columns;
+
+      columns const&
+      referenced_columns () const
+      {
+        return referenced_columns_;
+      }
+
+      columns&
+      referenced_columns ()
+      {
+        return referenced_columns_;
+      }
+
+    public:
+      bool
+      deferred () const
+      {
+        return deferred_;
+      }
+
+    public:
+      action
+      on_delete () const
+      {
+        return on_delete_;
+      }
+
+    public:
+      virtual string
+      kind () const
+      {
+        return "foreign key";
+      }
+
+    private:
+      string referenced_table_;
+      columns referenced_columns_;
+      bool deferred_;
+      action on_delete_;
+    };
+  }
+}
+
+#endif // ODB_SEMANTICS_RELATIONAL_FOREIGN_KEY_HXX