From 90fe9df73ca0804b21d1036c6f7e3c4464838a13 Mon Sep 17 00:00:00 2001
From: Constantin Michael <constantin@codesynthesis.com>
Date: Thu, 21 Jul 2011 23:58:04 +0200
Subject: Add PostgreSQL support to Boost profile

---
 odb/boost/date-time/pgsql/posix-time-traits.hxx | 159 ++++++++++++++++++++++++
 1 file changed, 159 insertions(+)
 create mode 100644 odb/boost/date-time/pgsql/posix-time-traits.hxx

(limited to 'odb/boost/date-time/pgsql/posix-time-traits.hxx')

diff --git a/odb/boost/date-time/pgsql/posix-time-traits.hxx b/odb/boost/date-time/pgsql/posix-time-traits.hxx
new file mode 100644
index 0000000..375a5e4
--- /dev/null
+++ b/odb/boost/date-time/pgsql/posix-time-traits.hxx
@@ -0,0 +1,159 @@
+// file      : odb/boost/date-time/pgsql/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_PGSQL_POSIX_TIME_TRAITS_HXX
+#define ODB_BOOST_DATE_TIME_PGSQL_POSIX_TIME_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <ctime>
+
+#include <boost/date_time/posix_time/posix_time_types.hpp>
+#include <boost/date_time/posix_time/conversion.hpp>       // from_time_t
+
+#include <odb/core.hxx>
+#include <odb/pgsql/traits.hxx>
+#include <odb/boost/date-time/exceptions.hxx>
+
+namespace odb
+{
+  namespace pgsql
+  {
+    // Implementation of the mapping between boost::posix_time::ptime and
+    // PostgreSQL TIMESTAMP. TIMESTAMP values are stored as micro-seconds
+    // since the PostgreSQL epoch 2000-01-01.
+    //
+    template <>
+    struct default_value_traits< ::boost::posix_time::ptime, id_timestamp>
+    {
+      typedef ::boost::gregorian::date date;
+      typedef ::boost::posix_time::ptime ptime;
+      typedef ::boost::posix_time::time_duration time_duration;
+
+      typedef details::endian_traits endian_traits;
+
+      typedef ptime value_type;
+      typedef ptime query_type;
+      typedef long long image_type;
+
+      // The difference between the Unix epoch and the PostgreSQL epoch
+      // in seconds.
+      //
+      static const long long epoch_diff = 946684800LL;
+
+      static const long long neg_inf = -0x7fffffffffffffffLL - 1;
+      static const long long pos_inf = 0x7fffffffffffffffLL;
+
+      static void
+      set_value (ptime& v, long long i, bool is_null)
+      {
+        if (is_null)
+          v = ptime (::boost::date_time::not_a_date_time);
+        else
+        {
+          i = endian_traits::ntoh (i);
+
+          if (i == neg_inf)
+            v = ptime (::boost::date_time::neg_infin);
+          else if (i == pos_inf)
+            v = ptime (::boost::date_time::pos_infin);
+          else
+            v = ::boost::posix_time::from_time_t (
+              static_cast<std::time_t> (i / 1000000 + epoch_diff));
+        }
+      }
+
+      static void
+      set_image (long long& i, bool& is_null, const ptime& v)
+      {
+        is_null = false;
+
+        if (v.is_special ())
+        {
+          if (v.is_not_a_date_time ())
+            is_null = true;
+          else if (v.is_neg_infinity ())
+            i = endian_traits::hton (neg_inf);
+          else if (v.is_pos_infinity ())
+            i = endian_traits::hton (pos_inf);
+          else
+            throw odb::boost::date_time::special_value ();
+        }
+        else
+        {
+          const ptime unix_epoch (date (1970, 1, 1), time_duration (0, 0, 0));
+
+          long long pg_seconds (
+            static_cast<long long> (
+              (v - unix_epoch).ticks () / time_duration::ticks_per_second ()) -
+            epoch_diff);
+
+          i = endian_traits::hton (pg_seconds * 1000000);
+        }
+      }
+    };
+
+    // Implementation of the mapping between boost::posix_time::time_duration
+    // and PostgreSQL TIME. The TIME values are stores as micro-seconds since
+    // 00:00:00.
+    //
+    template <>
+    struct default_value_traits< ::boost::posix_time::time_duration, id_time>
+    {
+      typedef ::boost::posix_time::time_duration time_duration;
+
+      typedef details::endian_traits endian_traits;
+
+      typedef time_duration value_type;
+      typedef time_duration query_type;
+      typedef long long image_type;
+
+      static void
+      set_value (time_duration& v, long long i, bool is_null)
+      {
+        if (is_null)
+          v = time_duration (::boost::date_time::not_a_date_time);
+        else
+          v = time_duration (0, 0,
+                             static_cast<long> (
+                               endian_traits::ntoh (i) / 1000000));
+      }
+
+      static void
+      set_image (long long& 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 if (v.hours () < 0 || v.hours () > 24)
+          throw odb::boost::date_time::value_out_of_range ();
+        else
+        {
+          is_null = false;
+          i = endian_traits::hton (
+            static_cast<long long> (v.total_seconds ()) * 1000000);
+        }
+      }
+    };
+
+    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_time;
+    };
+  }
+}
+
+#endif // ODB_BOOST_DATE_TIME_PGSQL_POSIX_TIME_TRAITS_HXX
-- 
cgit v1.1