Add PostgreSQL support to Qt profile

4 files changed, 244 insertions, 0 deletions

diff --git a/odb/qt/date-time/pgsql/default-mapping.hxx b/odb/qt/date-time/pgsql/default-mapping.hxx
new file mode 100644
index 0000000..becf577
--- /dev/null
+++ b/odb/qt/date-time/pgsql/default-mapping.hxx
@@ -0,0 +1,28 @@
+// file      : odb/qt/date-time/pgsql/default-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_QT_DATE_TIME_PGSQL_DEFAULT_MAPPING_HXX
+#define ODB_QT_DATE_TIME_PGSQL_DEFAULT_MAPPING_HXX
+
+#include <QtCore/QDate>
+#include <QtCore/QTime>
+#include <QtCore/QDateTime>
+
+// Map QDate to PostgreSQL DATE by default. QDate provides a null
+// representation so allow NULL values by default.
+//
+#pragma db value(QDate) type("DATE") null
+
+// Map QTime to PostgreSQL TIME by default. QTime provides a null
+// representation so allow NULL values by default.
+//
+#pragma db value(QTime) type("TIME") null
+
+// Map QDateTime to PostgreSQL TIMESTAMP by default. QDateTime provides a null
+// representation so allow NULL values by default.
+//
+#pragma db value(QDateTime) type("TIMESTAMP") null
+
+#endif // ODB_QT_DATE_TIME_PGSQL_DEFAULT_MAPPING_HXX
diff --git a/odb/qt/date-time/pgsql/qdate-time-traits.hxx b/odb/qt/date-time/pgsql/qdate-time-traits.hxx
new file mode 100644
index 0000000..288425e
--- /dev/null
+++ b/odb/qt/date-time/pgsql/qdate-time-traits.hxx
@@ -0,0 +1,84 @@
+// file      : odb/qt/date-time/pgsql/qdatetime-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_QT_DATE_TIME_PGSQL_QDATETIME_TRAITS_HXX
+#define ODB_QT_DATE_TIME_PGSQL_QDATETIME_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <QtCore/QDateTime>
+
+#include <odb/details/buffer.hxx>
+#include <odb/pgsql/traits.hxx>
+#include <odb/qt/date-time/exceptions.hxx>
+
+namespace odb
+{
+  namespace pgsql
+  {
+    // Implementation of mapping between QDateTime and PostgreSQL TIMESTAMP.
+    // TIMESTAMP values are stored as micro-seconds since the PostgreSQL
+    // epoch 2000-01-01.
+    //
+    template <>
+    struct default_value_traits<QDateTime, id_timestamp>
+    {
+      typedef details::endian_traits endian_traits;
+
+      typedef QDateTime value_type;
+      typedef QDateTime 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 void
+      set_value (QDateTime& v, long long i, bool is_null)
+      {
+        if (is_null)
+          // Default constructor creates a null QDateTime.
+          //
+          v = QDateTime ();
+        else
+          v.setTime_t (
+            static_cast <uint> (
+              endian_traits::ntoh (i) / 1000000 + epoch_diff));
+      }
+
+      static void
+      set_image (long long& i, bool& is_null, const QDateTime& v)
+      {
+        if (v.isNull ())
+          is_null = true;
+        // QDateTime::toTime_t returns an unsigned integer. Values less
+        // than the Unix epoch are not supported.
+        //
+        else if (v < QDateTime (QDate (1970, 1, 1),
+                                QTime (0, 0, 0),
+                                Qt::UTC))
+          throw odb::qt::date_time::value_out_of_range ();
+        else
+        {
+          is_null = false;
+
+          long long pg_seconds (static_cast<long long> (v.toTime_t ()) -
+                                epoch_diff);
+
+          i = endian_traits::hton (pg_seconds * 1000000);
+        }
+      }
+    };
+
+    template <>
+    struct default_type_traits<QDateTime>
+    {
+      static const database_type_id db_type_id = id_timestamp;
+    };
+  }
+}
+
+#endif // ODB_QT_DATE_TIME_PGSQL_QDATETIME_TRAITS_HXX
diff --git a/odb/qt/date-time/pgsql/qdate-traits.hxx b/odb/qt/date-time/pgsql/qdate-traits.hxx
new file mode 100644
index 0000000..94345e1
--- /dev/null
+++ b/odb/qt/date-time/pgsql/qdate-traits.hxx
@@ -0,0 +1,65 @@
+// file      : odb/qt/date-time/pgsql/qdate-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_QT_DATE_TIME_PGSQL_QDATE_TRAITS_HXX
+#define ODB_QT_DATE_TIME_PGSQL_QDATE_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <QtCore/QDate>
+
+#include <odb/pgsql/traits.hxx>
+#include <odb/qt/date-time/exceptions.hxx>
+
+namespace odb
+{
+  namespace pgsql
+  {
+    // Implementation of the mapping between QDate and PostgreSQL DATE. The
+    // DATE values are stored as days since the PostgreSQL epoch 2000-01-01.
+    //
+    template <>
+    struct default_value_traits<QDate, id_date>
+    {
+      typedef details::endian_traits endian_traits;
+
+      typedef QDate value_type;
+      typedef QDate query_type;
+      typedef int image_type;
+
+      static void
+      set_value (QDate& v, int i, bool is_null)
+      {
+        if (is_null)
+          // A null QDate value is equivalent to an invalid QDate value.
+          // Set v to an invalid date to represent null.
+          //
+          v.setDate (0, 0, 0);
+        else
+          v = QDate (2000, 1, 1).addDays (endian_traits::ntoh (i));
+      }
+
+      static void
+      set_image (int& i, bool& is_null, const QDate& v)
+      {
+        if (v.isNull ())
+          is_null = true;
+        else
+        {
+          is_null = false;
+          i = endian_traits::hton (QDate (2000, 1, 1).daysTo (v));
+        }
+      }
+    };
+
+    template <>
+    struct default_type_traits<QDate>
+    {
+      static const database_type_id db_type_id = id_date;
+    };
+  }
+}
+
+#endif // ODB_QT_DATE_TIME_PGSQL_QDATE_TRAITS_HXX
diff --git a/odb/qt/date-time/pgsql/qtime-traits.hxx b/odb/qt/date-time/pgsql/qtime-traits.hxx
new file mode 100644
index 0000000..c822017
--- /dev/null
+++ b/odb/qt/date-time/pgsql/qtime-traits.hxx
@@ -0,0 +1,67 @@
+// file      : odb/qt/date-time/pgsql/qtime-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_QT_DATE_TIME_PGSQL_QTIME_TRAITS_HXX
+#define ODB_QT_DATE_TIME_PGSQL_QTIME_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <QtCore/QTime>
+
+#include <odb/pgsql/traits.hxx>
+
+namespace odb
+{
+  namespace pgsql
+  {
+    // Implementation of the mapping between QTime and PostgreSQL TIME. The
+    // TIME values are stored as micro-seconds since 00:00:00.
+    //
+    template <>
+    struct default_value_traits<QTime, id_time>
+    {
+      typedef details::endian_traits endian_traits;
+
+      typedef QTime value_type;
+      typedef QTime query_type;
+      typedef long long image_type;
+
+      static void
+      set_value (QTime& v, long long i, bool is_null)
+      {
+        if (is_null)
+          // A null QTime value is equivalent to an invalid QTime value.
+          // Set v to an invalid time to represent null (hour value of
+          // a valid time must be in the range 0-23).
+          //
+          v.setHMS (24, 0, 0);
+        else
+          v = QTime (0, 0, 0).addSecs (
+            static_cast<int> (endian_traits::ntoh (i) / 1000000));
+      }
+
+      static void
+      set_image (long long& i, bool& is_null, const QTime& v)
+      {
+        if (v.isNull ())
+          is_null = true;
+        else
+        {
+          is_null = false;
+          i = endian_traits::hton (
+            static_cast<long long> (QTime (0, 0, 0).secsTo (v)) * 1000000);
+        }
+      }
+    };
+
+    template <>
+    struct default_type_traits<QTime>
+    {
+      static const database_type_id db_type_id = id_time;
+    };
+  }
+}
+
+#endif // ODB_QT_DATE_TIME_PGSQL_QTIME_TRAITS_HXX