5 files changed, 144 insertions, 0 deletions
diff --git a/odb/boost/date-time/exceptions.cxx b/odb/boost/date-time/exceptions.cxx
new file mode 100644
index 0000000..abde353
--- /dev/null
+++ b/odb/boost/date-time/exceptions.cxx
@@ -0,0 +1,21 @@
+// file      : odb/boost/date-time/exceptions.cxx
+// author    : Boris Kolpackov <boris@codesynthesis.com>
+// copyright : Copyright (c) 2005-2011 Code Synthesis Tools CC
+// license   : GNU GPL v2; see accompanying LICENSE file
+
+#include <odb/boost/date-time/exceptions.hxx>
+
+namespace odb
+{
+  namespace boost
+  {
+    namespace date_time
+    {
+      const char* special_value::
+      what () const throw ()
+      {
+        return "unrepresentable date/time special value";
+      }
+    }
+  }
+}
diff --git a/odb/boost/date-time/exceptions.hxx b/odb/boost/date-time/exceptions.hxx
new file mode 100644
index 0000000..8fd58b8
--- /dev/null
+++ b/odb/boost/date-time/exceptions.hxx
@@ -0,0 +1,31 @@
+// file      : odb/boost/date-time/exceptions.hxx
+// author    : Boris Kolpackov <boris@codesynthesis.com>
+// copyright : Copyright (c) 2005-2011 Code Synthesis Tools CC
+// license   : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef ODB_BOOST_DATE_TIME_EXCEPTIONS_HXX
+#define ODB_BOOST_DATE_TIME_EXCEPTIONS_HXX
+
+#include <odb/pre.hxx>
+
+#include <odb/boost/exception.hxx>
+#include <odb/boost/details/export.hxx>
+
+namespace odb
+{
+  namespace boost
+  {
+    namespace date_time
+    {
+      struct LIBODB_BOOST_EXPORT special_value: odb::boost::exception
+      {
+        virtual const char*
+        what () const throw ();
+      };
+    }
+  }
+}
+
+#include <odb/post.hxx>
+
+#endif // ODB_BOOST_DATE_TIME_EXCEPTIONS_HXX
diff --git a/odb/boost/date-time/gregorian.options b/odb/boost/date-time/gregorian.options
new file mode 100644
index 0000000..f320005
--- /dev/null
+++ b/odb/boost/date-time/gregorian.options
@@ -0,0 +1,9 @@
+# file      : odb/boost/date-time/gregorian.options
+# author    : Boris Kolpackov <boris@codesynthesis.com>
+# copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+# license   : GNU GPL v2; see accompanying LICENSE file
+
+--profile boost/version
+
+--odb-epilogue '#include <odb/boost/date-time/mysql/gregorian-mapping.hxx>'
+--hxx-prologue '#include <odb/boost/date-time/mysql/gregorian-traits.hxx>'
diff --git a/odb/boost/date-time/mysql/gregorian-mapping.hxx b/odb/boost/date-time/mysql/gregorian-mapping.hxx
new file mode 100644
index 0000000..add14ba
--- /dev/null
+++ b/odb/boost/date-time/mysql/gregorian-mapping.hxx
@@ -0,0 +1,19 @@
+// file      : odb/boost/date-time/mysql/gregorian-mapping.hxx
+// author    : Constantin Michael <constantin@codesynthesis.com>
+// author    : Boris Kolpackov <boris@codesynthesis.com>
+// copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+// license   : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef ODB_BOOST_DATE_TIME_MYSQL_GREGORIAN_MAPPING_HXX
+#define ODB_BOOST_DATE_TIME_MYSQL_GREGORIAN_MAPPING_HXX
+
+#include <boost/date_time/gregorian/gregorian_types.hpp>
+
+// By default map boost::gregorian::date to MySQL DATE. We use the
+// NULL value to represent not_a_date_time. In MYSQL "zero" date
+// plays the special value role but this value is not treated as
+// special by gregorian::date.
+//
+#pragma db value(boost::gregorian::date) type("DATE")
+
+#endif // ODB_BOOST_DATE_TIME_MYSQL_GREGORIAN_MAPPING_HXX
diff --git a/odb/boost/date-time/mysql/gregorian-traits.hxx b/odb/boost/date-time/mysql/gregorian-traits.hxx
new file mode 100644
index 0000000..d907aef
--- /dev/null
+++ b/odb/boost/date-time/mysql/gregorian-traits.hxx
@@ -0,0 +1,64 @@
+// file      : odb/boost/date-time/mysql/gregorian-traits.hxx
+// author    : Constantin Michael <constantin@codesynthesis.com>
+// author    : Boris Kolpackov <boris@codesynthesis.com>
+// copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+// license   : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef ODB_BOOST_DATE_TIME_MYSQL_GREGORIAN_TRAITS_HXX
+#define ODB_BOOST_DATE_TIME_MYSQL_GREGORIAN_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <boost/date_time/gregorian/gregorian_types.hpp>
+
+#include <odb/core.hxx>
+#include <odb/mysql/traits.hxx>
+#include <odb/boost/date-time/exceptions.hxx>
+
+namespace odb
+{
+  namespace mysql
+  {
+    template <>
+    class value_traits< ::boost::gregorian::date, MYSQL_TIME, id_date>
+    {
+    public:
+      typedef ::boost::gregorian::date date;
+      typedef date value_type;
+      typedef date query_type;
+      typedef MYSQL_TIME image_type;
+
+      static void
+      set_value (date& v, const MYSQL_TIME& i, bool is_null)
+      {
+        if (is_null)
+          v = date (::boost::date_time::not_a_date_time);
+        else
+          v = date (i.year, i.month, i.day);
+      }
+
+      static void
+      set_image (MYSQL_TIME& i, bool& is_null, const date& v)
+      {
+        if (v.is_special ())
+        {
+          if (v.is_not_a_date ())
+            is_null = true;
+          else
+            throw odb::boost::date_time::special_value ();
+        }
+        else
+        {
+          is_null = false;
+          i.year = v.year ();
+          i.month = v.month ();
+          i.day = v.day ();
+        }
+      }
+    };
+  }
+}
+
+#include <odb/post.hxx>
+
+#endif // ODB_BOOST_DATE_TIME_MYSQL_GREGORIAN_TRAITS_HXX