Implement Boost profile for Oracle

6 files changed, 315 insertions, 0 deletions

diff --git a/odb/boost/date-time/gregorian-oracle.options b/odb/boost/date-time/gregorian-oracle.options
new file mode 100644
index 0000000..4ae1dc9
--- /dev/null
+++ b/odb/boost/date-time/gregorian-oracle.options
@@ -0,0 +1,9 @@
+# file      : odb/boost/date-time/gregorian-oracle.options
+# author    : Constantin Michael <constantin@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/oracle/gregorian-mapping.hxx>'
+--hxx-prologue '#include <odb/boost/date-time/oracle/gregorian-traits.hxx>'
diff --git a/odb/boost/date-time/oracle/gregorian-mapping.hxx b/odb/boost/date-time/oracle/gregorian-mapping.hxx
new file mode 100644
index 0000000..aa2ea3b
--- /dev/null
+++ b/odb/boost/date-time/oracle/gregorian-mapping.hxx
@@ -0,0 +1,16 @@
+// file      : odb/boost/date-time/oracle/gregorian-mapping.hxx
+// author    : Constantin Michael <constantin@codesynthesis.com>
+// copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+// license   : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef ODB_BOOST_DATE_TIME_ORACLE_GREGORIAN_MAPPING_HXX
+#define ODB_BOOST_DATE_TIME_ORACLE_GREGORIAN_MAPPING_HXX
+
+#include <boost/date_time/gregorian/gregorian_types.hpp>
+
+// By default map boost::gregorian::date to Oracle DATE. We use the
+// NULL value to represent not_a_date_time.
+//
+#pragma db value(boost::gregorian::date) type("DATE") null
+
+#endif // ODB_BOOST_DATE_TIME_ORACLE_GREGORIAN_MAPPING_HXX
diff --git a/odb/boost/date-time/oracle/gregorian-traits.hxx b/odb/boost/date-time/oracle/gregorian-traits.hxx
new file mode 100644
index 0000000..6daf6cf
--- /dev/null
+++ b/odb/boost/date-time/oracle/gregorian-traits.hxx
@@ -0,0 +1,85 @@
+// file      : odb/boost/date-time/oracle/gregorian-traits.hxx
+// author    : Constantin Michael <constantin@codesynthesis.com>
+// copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+// license   : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef ODB_BOOST_DATE_TIME_ORACLE_GREGORIAN_TRAITS_HXX
+#define ODB_BOOST_DATE_TIME_ORACLE_GREGORIAN_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <boost/date_time/gregorian/gregorian_types.hpp>
+
+#include <odb/core.hxx>
+
+#include <odb/oracle/traits.hxx>
+#include <odb/oracle/details/date.hxx>
+
+#include <odb/boost/date-time/exceptions.hxx>
+
+namespace odb
+{
+  namespace oracle
+  {
+    template <>
+    struct default_value_traits< ::boost::gregorian::date, id_date>
+    {
+      typedef ::boost::gregorian::date date;
+      typedef date value_type;
+      typedef date query_type;
+      typedef char* image_type;
+
+      static void
+      set_value (date& v, const char* b, bool is_null)
+      {
+        if (is_null)
+          v = date (::boost::date_time::not_a_date_time);
+        else
+        {
+          short y (0);
+          unsigned char m (0), d (0), h (0), min (0), s (0);
+
+          details::get_date (b, y, m, d, h, min, s);
+
+          v = date (static_cast<date::year_type> (y),
+                    static_cast<date::month_type> (m),
+                    static_cast<date::day_type> (d));
+        }
+      }
+
+      static void
+      set_image (char* b, 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;
+
+          details::set_date (b,
+                             static_cast<short> (v.year ()),
+                             static_cast<unsigned char> (v.month ()),
+                             static_cast<unsigned char> (v.day ()),
+                             0,
+                             0,
+                             0);
+        }
+      }
+    };
+
+    template <>
+    struct default_type_traits< ::boost::gregorian::date>
+    {
+      static const database_type_id db_type_id = id_date;
+    };
+  }
+}
+
+#include <odb/post.hxx>
+
+#endif // ODB_BOOST_DATE_TIME_ORACLE_GREGORIAN_TRAITS_HXX
diff --git a/odb/boost/date-time/oracle/posix-time-mapping.hxx b/odb/boost/date-time/oracle/posix-time-mapping.hxx
new file mode 100644
index 0000000..2050ef5
--- /dev/null
+++ b/odb/boost/date-time/oracle/posix-time-mapping.hxx
@@ -0,0 +1,22 @@
+// file      : odb/boost/date-time/oracle/posix-time-mapping.hxx
+// author    : Constantin Michael <constantin@codesynthesis.com>
+// copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+// license   : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef ODB_BOOST_DATE_TIME_ORACLE_POSIX_TIME_MAPPING_HXX
+#define ODB_BOOST_DATE_TIME_ORACLE_POSIX_TIME_MAPPING_HXX
+
+#include <boost/date_time/posix_time/posix_time_types.hpp>
+
+// By default map boost::posix_time::ptime to Oracle TIMESTAMP. We use the NULL
+// value to represent not_a_date_time.
+//
+#pragma db value(boost::posix_time::ptime) type("TIMESTAMP") null
+
+// By default map boost::posix_time::time_duration to Oracle
+// INTERVAL DAY TO SECOND. We use the NULL value to represent not_a_date_time.
+//
+#pragma db value(boost::posix_time::time_duration) \
+  type("INTERVAL DAY TO SECOND") null
+
+#endif // ODB_BOOST_DATE_TIME_ORACLE_POSIX_TIME_MAPPING_HXX
diff --git a/odb/boost/date-time/oracle/posix-time-traits.hxx b/odb/boost/date-time/oracle/posix-time-traits.hxx
new file mode 100644
index 0000000..e08945d
--- /dev/null
+++ b/odb/boost/date-time/oracle/posix-time-traits.hxx
@@ -0,0 +1,174 @@
+// file      : odb/boost/date-time/oracle/posix-time-traits.hxx
+// author    : Constantin Michael <constantin@codesynthesis.com>
+// copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC
+// license   : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef ODB_BOOST_DATE_TIME_ORACLE_POSIX_TIME_TRAITS_HXX
+#define ODB_BOOST_DATE_TIME_ORACLE_POSIX_TIME_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <boost/date_time/posix_time/posix_time_types.hpp>
+
+#include <odb/core.hxx>
+
+#include <odb/oracle/traits.hxx>
+#include <odb/oracle/oracle-fwd.hxx>   // ub1, sb2, ub4
+#include <odb/oracle/oracle-types.hxx> // odb::oracle::datetime,
+                                       // odb::oracle::interval_ds
+
+#include <odb/boost/date-time/exceptions.hxx>
+
+namespace odb
+{
+  namespace oracle
+  {
+    template <>
+    struct default_value_traits< ::boost::posix_time::ptime, id_timestamp>
+    {
+      typedef ::boost::posix_time::ptime ptime;
+      typedef ::boost::posix_time::time_duration time_duration;
+      typedef ::boost::gregorian::date date;
+
+      typedef ptime value_type;
+      typedef ptime query_type;
+      typedef datetime image_type;
+
+      static void
+      set_value (ptime& v, const datetime& i, bool is_null)
+      {
+        if (is_null)
+          v = ptime (::boost::date_time::not_a_date_time);
+        else
+        {
+          sb2 y (0);
+          ub1 m (0), d (0), h (0), min (0), s (0);
+          ub4 ns;
+
+          i.get (y, m, d, h, min, s, ns);
+
+          unsigned long long fract_s (ns);
+          fract_s = fract_s * time_duration::ticks_per_second () /
+            1000000000ULL;
+
+          v = ptime (
+            date (static_cast<date::year_type> (y),
+                  static_cast<date::month_type> (m),
+                  static_cast<date::day_type> (d)),
+            time_duration (
+              static_cast<time_duration::hour_type> (h),
+              static_cast<time_duration::min_type> (min),
+              static_cast<time_duration::sec_type> (s),
+              static_cast<time_duration::fractional_seconds_type> (fract_s)));
+        }
+      }
+
+      static void
+      set_image (datetime& i, bool& is_null, const ptime& v)
+      {
+        if (v.is_special ())
+        {
+          if (v.is_not_a_date_time ())
+            is_null = true;
+          else
+            throw odb::boost::date_time::special_value ();
+        }
+        else
+        {
+          is_null = false;
+
+          const date& d (v.date ());
+          const time_duration& t (v.time_of_day ());
+
+          unsigned long long ns (t.fractional_seconds ());
+          ns = ns * 1000000000ULL / time_duration::ticks_per_second ();
+
+          i.set (static_cast<sb2> (d.year ()),
+                 static_cast<ub1> (d.month ()),
+                 static_cast<ub1> (d.day ()),
+                 static_cast<ub1> (t.hours ()),
+                 static_cast<ub1> (t.minutes ()),
+                 static_cast<ub1> (t.seconds ()),
+                 static_cast<ub4> (ns));
+        }
+      }
+    };
+
+    template <>
+    struct default_value_traits< ::boost::posix_time::time_duration,
+                                 id_interval_ds>
+    {
+      typedef ::boost::posix_time::time_duration time_duration;
+
+      typedef time_duration value_type;
+      typedef time_duration query_type;
+      typedef interval_ds image_type;
+
+      static void
+      set_value (time_duration& v,
+                 const interval_ds& i,
+                 bool is_null)
+      {
+        if (is_null)
+          v = time_duration (::boost::date_time::not_a_date_time);
+        else
+        {
+          sb4 d (0), h (0), m (0), s (0), ns (0);
+          i.get (d, h, m, s, ns);
+
+          unsigned long long fract_s (ns);
+          fract_s = fract_s * time_duration::ticks_per_second () /
+            1000000000ULL;
+
+          v = time_duration (
+            static_cast<time_duration::hour_type> (
+              static_cast<unsigned long long> (d) * 24 + h),
+            static_cast<time_duration::min_type> (m),
+            static_cast<time_duration::sec_type> (s),
+            static_cast<time_duration::fractional_seconds_type> (fract_s));
+        }
+      }
+
+      static void
+      set_image (interval_ds& i,
+                 bool& is_null,
+                 const time_duration& v)
+      {
+        if (v.is_special ())
+        {
+          if (v.is_not_a_date_time ())
+            is_null = true;
+          else
+            throw odb::boost::date_time::special_value ();
+        }
+        else
+        {
+          is_null = false;
+
+          unsigned long long ns (v.fractional_seconds ());
+          ns = ns * 1000000000ULL / time_duration::ticks_per_second ();
+
+          i.set (0,
+                 static_cast<sb4> (v.hours ()),
+                 static_cast<sb4> (v.minutes ()),
+                 static_cast<sb4> (v.seconds ()),
+                 static_cast<sb4> (ns));
+        }
+      }
+    };
+
+    template <>
+    struct default_type_traits< ::boost::posix_time::ptime>
+    {
+      static const database_type_id db_type_id = id_timestamp;
+    };
+
+    template <>
+    struct default_type_traits< ::boost::posix_time::time_duration>
+    {
+      static const database_type_id db_type_id = id_interval_ds;
+    };
+  }
+}
+
+#endif // ODB_BOOST_DATE_TIME_ORACLE_POSIX_TIME_TRAITS_HXX
diff --git a/odb/boost/date-time/posix-time-oracle.options b/odb/boost/date-time/posix-time-oracle.options
new file mode 100644
index 0000000..20baf53
--- /dev/null
+++ b/odb/boost/date-time/posix-time-oracle.options
@@ -0,0 +1,9 @@
+# file      : odb/boost/date-time/posix-time-oracle.options
+# author    : Constantin Michael <constantin@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/oracle/posix-time-mapping.hxx>'
+--hxx-prologue '#include <odb/boost/date-time/oracle/posix-time-traits.hxx>'