Complete qt/basic and qt/date-time implementations

10 files changed, 739 insertions, 0 deletions

diff --git a/odb/qt/date-time/exceptions.cxx b/odb/qt/date-time/exceptions.cxx
new file mode 100644
index 0000000..b2ccffe
--- /dev/null
+++ b/odb/qt/date-time/exceptions.cxx
@@ -0,0 +1,21 @@
+// file      : odb/qt/date-time/exceptions.cxx
+// author    : Constantin Michael <constantin@codesynthesis.com>
+// copyright : Copyright (c) 2005-2011 Code Synthesis Tools CC
+// license   : GNU GPL v2; see accompanying LICENSE file
+
+#include <odb/qt/date-time/exceptions.hxx>
+
+namespace odb
+{
+  namespace qt
+  {
+    namespace date_time
+    {
+      const char* value_out_of_range::
+      what () const throw ()
+      {
+        return "date/time value out of range";
+      }
+    }
+  }
+}
diff --git a/odb/qt/date-time/exceptions.hxx b/odb/qt/date-time/exceptions.hxx
new file mode 100644
index 0000000..445b110
--- /dev/null
+++ b/odb/qt/date-time/exceptions.hxx
@@ -0,0 +1,31 @@
+// file      : odb/qt/date-time/exceptions.hxx
+// author    : Constantin Michael <constantin@codesynthesis.com>
+// copyright : Copyright (c) 2005-2011 Code Synthesis Tools CC
+// license   : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef ODB_QT_DATE_TIME_EXCEPTIONS_HXX
+#define ODB_QT_DATE_TIME_EXCEPTIONS_HXX
+
+#include <odb/pre.hxx>
+
+#include <odb/qt/exception.hxx>
+#include <odb/qt/details/export.hxx>
+
+namespace odb
+{
+  namespace qt
+  {
+    namespace date_time
+    {
+      struct LIBODB_QT_EXPORT value_out_of_range: exception
+      {
+        virtual const char*
+        what () const throw ();
+      };
+    }
+  }
+}
+
+#include <odb/post.hxx>
+
+#endif // ODB_QT_DATE_TIME_EXCEPTIONS_HXX
diff --git a/odb/qt/date-time/mysql/default-mapping.hxx b/odb/qt/date-time/mysql/default-mapping.hxx
new file mode 100644
index 0000000..fa0b823
--- /dev/null
+++ b/odb/qt/date-time/mysql/default-mapping.hxx
@@ -0,0 +1,28 @@
+// file      : odb/qt/date-time/mysql/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_MYSQL_DEFAULT_MAPPING_HXX
+#define ODB_QT_DATE_TIME_MYSQL_DEFAULT_MAPPING_HXX
+
+#include <QDate>
+#include <QTime>
+#include <QDateTime>
+
+// Map QDate to MySQL DATE by default. QDate provides a null
+// representation so allow NULL values by default.
+//
+#pragma db value(QDate) type("DATE")
+
+// Map QTime to MySQL TIME by default. QTime provides a null
+// representation so allow NULL values by default.
+//
+#pragma db value(QTime) type("TIME")
+
+// Map QDateTime to MySQL DATETIME by default. QDateTime provides a null
+// representation so allow NULL values by default.
+//
+#pragma db value(QDateTime) type("DATETIME")
+
+#endif // ODB_QT_DATE_TIME_MYSQL_DEFAULT_MAPPING_HXX
diff --git a/odb/qt/date-time/mysql/qdate-time-traits.hxx b/odb/qt/date-time/mysql/qdate-time-traits.hxx
new file mode 100644
index 0000000..9d212a3
--- /dev/null
+++ b/odb/qt/date-time/mysql/qdate-time-traits.hxx
@@ -0,0 +1,127 @@
+// file      : odb/qt/date-time/mysql/qdate-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_QT_DATE_TIME_MYSQL_QDATETIME_TRAITS_HXX
+#define ODB_QT_DATE_TIME_MYSQL_QDATETIME_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <QDateTime>
+
+#include <odb/mysql/traits.hxx>
+
+namespace odb
+{
+  namespace mysql
+  {
+    template <>
+    class default_value_traits<QDateTime, MYSQL_TIME, id_datetime>
+    {
+    public:
+      typedef QDateTime value_type;
+      typedef QDateTime query_type;
+      typedef MYSQL_TIME image_type;
+
+      static void
+      set_value (QDateTime& v, const MYSQL_TIME& i, bool is_null)
+      {
+        if (is_null)
+          // Default constructor creates a null QDateTime.
+          //
+          v = QDateTime ();
+        else
+          v = QDateTime (QDate (static_cast<int> (i.year),
+                                static_cast<int> (i.month),
+                                static_cast<int> (i.day)),
+                         QTime (static_cast<int> (i.hour),
+                                static_cast<int> (i.minute),
+                                static_cast<int> (i.second)));
+      }
+
+      static void
+      set_image (MYSQL_TIME& i, bool& is_null, const QDateTime& v)
+      {
+        if (v.isNull ())
+          is_null = true;
+        else
+        {
+          if ((v < QDateTime (QDate (1000, 1, 1))) ||
+              (v >= QDateTime (QDate (10000, 1, 1))))
+            throw odb::qt::date_time::value_out_of_range ();
+
+          is_null = false;
+
+          const QDate& d (v.date ());
+          i.year = static_cast<unsigned int> (d.year ());
+          i.month = static_cast<unsigned int> (d.month ());
+          i.day = static_cast<unsigned int> (d.day ());
+
+          const QTime& t (v.time ());
+          i.hour = static_cast<unsigned int> (t.hour ());
+          i.minute = static_cast<unsigned int> (t.minute ());
+          i.second = static_cast<unsigned int> (t.second ());
+        }
+      }
+    };
+
+    template <>
+    class default_value_traits<QDateTime, MYSQL_TIME, id_timestamp>
+    {
+    public:
+      typedef QDateTime value_type;
+      typedef QDateTime query_type;
+      typedef MYSQL_TIME image_type;
+
+      static void
+      set_value (QDateTime& v, const MYSQL_TIME& i, bool is_null)
+      {
+        if (is_null)
+          // Default constructor creates a null QDateTime.
+          //
+          v = QDateTime ();
+        else
+          v = QDateTime (QDate (static_cast<int> (i.year),
+                                static_cast<int> (i.month),
+                                static_cast<int> (i.day)),
+                         QTime (static_cast<int> (i.hour),
+                                static_cast<int> (i.minute),
+                                static_cast<int> (i.second)));
+      }
+
+      static void
+      set_image (MYSQL_TIME& i, bool& is_null, const QDateTime& v)
+      {
+        if (v.isNull ())
+          is_null = true;
+        else
+        {
+          if ((v <= QDateTime (QDate (1970, 1, 1))) ||
+              (v > QDateTime (QDate (2038, 1, 19), QTime (3, 14, 7))))
+            throw odb::qt::date_time::value_out_of_range ();
+
+          is_null = false;
+
+          const QDate& d (v.date ());
+          i.year = static_cast<unsigned int> (d.year ());
+          i.month = static_cast<unsigned int> (d.month ());
+          i.day = static_cast<unsigned int> (d.day ());
+
+          const QTime& t (v.time ());
+          i.hour = static_cast<unsigned int> (t.hour ());
+          i.minute = static_cast<unsigned int> (t.minute ());
+          i.second = static_cast<unsigned int> (t.second ());
+        }
+      }
+    };
+
+    template <>
+    class default_type_traits<QDateTime>
+    {
+      static const database_type_id db_type_od = id_datetime;
+    };
+  }
+}
+
+#endif // ODB_QT_DATE_TIME_MYSQL_QDATETIME_TRAITS_HXX
diff --git a/odb/qt/date-time/mysql/qdate-traits.hxx b/odb/qt/date-time/mysql/qdate-traits.hxx
new file mode 100644
index 0000000..1034cbc
--- /dev/null
+++ b/odb/qt/date-time/mysql/qdate-traits.hxx
@@ -0,0 +1,68 @@
+// file      : odb/qt/date-time/mysql/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_MYSQL_QDATE_TRAITS_HXX
+#define ODB_QT_DATE_TIME_MYSQL_QDATE_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <QDate>
+
+#include <odb/mysql/traits.hxx>
+#include <odb/qt/date-time/exceptions.hxx>
+
+namespace odb
+{
+  namespace mysql
+  {
+    template <>
+    class default_value_traits<QDate, MYSQL_TIME, id_date>
+    {
+    public:
+      typedef QDate value_type;
+      typedef QDate query_type;
+      typedef MYSQL_TIME image_type;
+
+      static void
+      set_value (QDate& v, const MYSQL_TIME& 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.setDate (static_cast<int> (i.year),
+                     static_cast<int> (i.month),
+                     static_cast<int> (i.day));
+      }
+
+      static void
+      set_image (MYSQL_TIME& i, bool& is_null, const QDate& v)
+      {
+        if (v.isNull ())
+          is_null = true;
+        else if ((v < QDate (1000, 1, 1)) || (v > QDate (9999, 12, 31)))
+          throw odb::qt::date_time::value_out_of_range ();
+        else
+        {
+          is_null = false;
+
+          i.year = static_cast<unsigned int> (v.year ());
+          i.month = static_cast<unsigned int> (v.month ());
+          i.day = static_cast<unsigned int> (v.day ());
+        }
+      }
+    };
+
+    template <>
+    class default_type_traits<QDate>
+    {
+      static const database_type_id db_type_id = id_date;
+    };
+  }
+}
+
+#endif // ODB_QT_DATE_TIME_MYSQL_QDATE_TRAITS_HXX
diff --git a/odb/qt/date-time/mysql/qtime-traits.hxx b/odb/qt/date-time/mysql/qtime-traits.hxx
new file mode 100644
index 0000000..69cd49c
--- /dev/null
+++ b/odb/qt/date-time/mysql/qtime-traits.hxx
@@ -0,0 +1,69 @@
+// file      : odb/qt/date-time/mysql/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_MYSQL_QTIME_TRAITS_HXX
+#define ODB_QT_DATE_TIME_MYSQL_QTIME_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <QTime>
+
+#include <odb/mysql/traits.hxx>
+
+namespace odb
+{
+  namespace mysql
+  {
+    template <>
+    class default_value_traits<QTime, MYSQL_TIME, id_time>
+    {
+    public:
+      typedef QTime value_type;
+      typedef QTime query_type;
+      typedef MYSQL_TIME image_type;
+
+      static void
+      set_value (QTime& v, const MYSQL_TIME& 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.setHMS (static_cast<int> (i.hour),
+                    static_cast<int> (i.minute),
+                    static_cast<int> (i.second));
+      }
+
+      static void
+      set_image (MYSQL_TIME& i, bool& is_null, const QTime& v)
+      {
+        if (v.isNull ())
+          is_null = true;
+        else
+        {
+          is_null = false;
+
+          i.neg = false;
+          i.day = 0;
+
+          i.hour = static_cast<unsigned int> (v.hour ());
+          i.minute = static_cast<unsigned int> (v.minute ());
+          i.second = static_cast<unsigned int> (v.second ());
+        }
+      }
+    };
+
+    template <>
+    class default_type_traits<QTime>
+    {
+      static const database_type_id db_type_id = id_time;
+    };
+  }
+}
+
+#endif // ODB_QT_DATE_TIME_MYSQL_QTIME_TRAITS_HXX
diff --git a/odb/qt/date-time/sqlite/default-mapping.hxx b/odb/qt/date-time/sqlite/default-mapping.hxx
new file mode 100644
index 0000000..82321af
--- /dev/null
+++ b/odb/qt/date-time/sqlite/default-mapping.hxx
@@ -0,0 +1,28 @@
+// file      : odb/qt/date-time/sqlite/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_SQLITE_DEFAULT_MAPPING_HXX
+#define ODB_QT_DATE_TIME_SQLITE_DEFAULT_MAPPING_HXX
+
+#include <QDate>
+#include <QTime>
+#include <QDateTime>
+
+// Map QDate to SQLite TEXT by default. QDate provides a null representation
+// so allow NULL values by default.
+//
+#pragma db value(QDate) type("TEXT")
+
+// Map QTime to SQLite TEXT by default. QTime provides a null representation
+// so allow NULL values by default.
+//
+#pragma db value(QTime) type("TEXT")
+
+// Map QDateTime to SQLite TEXT by default. QDateTime provides a null
+// representation so allow NULL values by default.
+//
+#pragma db value(QDateTime) type("TEXT")
+
+#endif // ODB_QT_DATE_TIME_SQLITE_DEFAULT_MAPPING_HXX
diff --git a/odb/qt/date-time/sqlite/qdate-time-traits.hxx b/odb/qt/date-time/sqlite/qdate-time-traits.hxx
new file mode 100644
index 0000000..85c4c1a
--- /dev/null
+++ b/odb/qt/date-time/sqlite/qdate-time-traits.hxx
@@ -0,0 +1,123 @@
+// file      : odb/qt/date-time/sqlite/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_SQLITE_QDATETIME_TRAITS_HXX
+#define ODB_QT_DATE_TIME_SQLITE_QDATETIME_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <string>
+#include <cstddef>  // std::size_t
+#include <cstring>  // std::memcpy
+
+#include <QDateTime>
+
+#include <odb/details/buffer.hxx>
+#include <odb/sqlite/traits.hxx>
+#include <odb/qt/date-time/exceptions.hxx>
+
+namespace odb
+{
+  namespace sqlite
+  {
+    template <>
+    class default_value_traits<QDateTime, details::buffer, id_text>
+    {
+    public:
+      typedef QDateTime value_type;
+      typedef QDateTime query_type;
+      typedef details::buffer image_type;
+
+      static void
+      set_value (QDateTime& v,
+                 const details::buffer& i,
+                 std::size_t n,
+                 bool is_null)
+      {
+        if (is_null)
+          // Default constructor creates a null QDateTime.
+          //
+          v = QDateTime ();
+        else
+          v = QDateTime::fromString (
+            QString::fromAscii (i.data (), static_cast<int> (n)),
+            "yyyy-MM-ddTHH:mm:ss.zzz");
+      }
+
+      static void
+      set_image (details::buffer& i,
+                 std::size_t& n,
+                 bool& is_null,
+                 const QDateTime& v)
+      {
+        if (v.isNull ())
+          is_null = true;
+        else
+        {
+          is_null = false;
+
+          std::string s (
+            v.toString ("yyyy-MM-ddTHH:mm:ss.zzz").toStdString ());
+
+          n = s.size ();
+          if (n > i.capacity ())
+            i.capacity (n);
+
+          std::memcpy (i.data (), s.data (), n);
+        }
+      }
+    };
+
+    // Implementation of mapping between QDateTime and SQLite INTEGER.
+    // The integer value represents UNIX time.
+    //
+    template <>
+    class default_value_traits<QDateTime, long long, id_integer>
+    {
+    public:
+      typedef QDateTime value_type;
+      typedef QDateTime query_type;
+      typedef long long image_type;
+
+      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.setTimeSpec (Qt::UTC);
+          v.setTime_t (static_cast <uint> (i));
+        }
+      }
+
+      static void
+      set_image (long long& i, bool& is_null, const QDateTime& v)
+      {
+        if (v.isNull ())
+          is_null = true;
+        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;
+          i = static_cast<long long> (v.toTime_t ());
+        }
+      }
+    };
+
+    template <>
+    class default_type_traits<QDateTime>
+    {
+      static const database_type_id db_type_id = id_text;
+    };
+  }
+}
+
+#endif // ODB_QT_DATE_TIME_SQLITE_QDATETIME_TRAITS_HXX
diff --git a/odb/qt/date-time/sqlite/qdate-traits.hxx b/odb/qt/date-time/sqlite/qdate-traits.hxx
new file mode 100644
index 0000000..d8df614
--- /dev/null
+++ b/odb/qt/date-time/sqlite/qdate-traits.hxx
@@ -0,0 +1,126 @@
+// file      : odb/qt/date-time/sqlite/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_SQLITE_QDATE_TRAITS_HXX
+#define ODB_QT_DATE_TIME_SQLITE_QDATE_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <string>
+#include <cstddef>  // std::size_t
+#include <cstring>  // std::memcpy
+
+#include <QDate>
+
+#include <odb/details/buffer.hxx>
+#include <odb/sqlite/traits.hxx>
+#include <odb/qt/date-time/exceptions.hxx>
+
+namespace odb
+{
+  namespace sqlite
+  {
+    template <>
+    class default_value_traits<QDate, details::buffer, id_text>
+    {
+    public:
+      typedef QDate value_type;
+      typedef QDate query_type;
+      typedef details::buffer image_type;
+
+      static void
+      set_value (QDate& v,
+                 const details::buffer& i,
+                 std::size_t n,
+                 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::fromString (
+            QString::fromAscii (i.data (), static_cast<int> (n)),
+            "yyyy-MM-dd");
+      }
+
+      static void
+      set_image (details::buffer& i,
+                 std::size_t& n,
+                 bool& is_null,
+                 const QDate& v)
+      {
+        if (v.isNull ())
+          is_null = true;
+        else
+        {
+          is_null = false;
+
+          std::string s (v.toString ("yyyy-MM-dd").toStdString ());
+
+          n = s.size ();
+          if (n > i.capacity ())
+            i.capacity (n);
+
+          std::memcpy (i.data (), s.data (), n);
+        }
+      }
+    };
+
+    // Implementation of the mapping between QDate and SQLite INTEGER. The
+    // integer value represents UNIX time.
+    //
+    template <>
+    class default_value_traits<QDate, long long, id_integer>
+    {
+    public:
+      typedef QDate value_type;
+      typedef QDate query_type;
+      typedef long long image_type;
+
+      static void
+      set_value (QDate& v, long long 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
+        {
+          QDateTime dt;
+          dt.setTimeSpec (Qt::UTC);
+          dt.setTime_t(static_cast<uint> (i));
+
+          v = dt.date ();
+        }
+      }
+
+      static void
+      set_image (long long& i, bool& is_null, const QDate& v)
+      {
+        if (v.isNull ())
+          is_null = true;
+        else if (v < QDate (1970, 1, 1))
+          throw odb::qt::date_time::value_out_of_range ();
+        else
+        {
+          is_null = false;
+          i = static_cast<long long> (
+            QDateTime (v, QTime (0, 0, 0), Qt::UTC).toTime_t ());
+        }
+      }
+    };
+
+    template <>
+    class default_type_traits<QDate>
+    {
+      static const database_type_id db_type_id = id_text;
+    };
+  }
+}
+
+#endif // ODB_QT_DATE_TIME_SQLITE_QDATE_TRAITS_HXX
diff --git a/odb/qt/date-time/sqlite/qtime-traits.hxx b/odb/qt/date-time/sqlite/qtime-traits.hxx
new file mode 100644
index 0000000..84721ee
--- /dev/null
+++ b/odb/qt/date-time/sqlite/qtime-traits.hxx
@@ -0,0 +1,118 @@
+// file      : odb/qt/date-time/sqlite/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_SQLITE_QTIME_TRAITS_HXX
+#define ODB_QT_DATE_TIME_SQLITE_QTIME_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <string>
+#include <cstddef>  // std::size_t
+#include <cstring>  // std::memcpy
+
+#include <QTime>
+
+#include <odb/details/buffer.hxx>
+#include <odb/sqlite/traits.hxx>
+
+namespace odb
+{
+  namespace sqlite
+  {
+    template <>
+    class default_value_traits<QTime, details::buffer, id_text>
+    {
+    public:
+      typedef QTime value_type;
+      typedef QTime query_type;
+      typedef details::buffer image_type;
+
+      static void
+      set_value (QTime& v,
+                 const details::buffer& i,
+                 std::size_t n,
+                 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::fromString (
+            QString::fromAscii (i.data (), static_cast<int> (n)),
+            "HH:mm:ss.zzz");
+      }
+
+      static void
+      set_image (details::buffer& i,
+                 std::size_t& n,
+                 bool& is_null,
+                 const QTime& v)
+      {
+        if (v.isNull ())
+          is_null = true;
+        else
+        {
+          is_null = false;
+
+          std::string s (v.toString ("HH:mm:ss.zzz").toStdString ());
+
+          n = s.size ();
+          if (n > i.capacity ())
+            i.capacity (n);
+
+          std::memcpy (i.data (), s.data (), n);
+        }
+      }
+    };
+
+    // Implementation of mapping between QTime and SQLite INTEGER. The
+    // integer value represents seconds since midnight.
+    //
+    template <>
+    class default_value_traits<QTime, long long, id_integer>
+    {
+    public:
+      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> (i));
+      }
+
+      static void
+      set_image (long long& i, bool& is_null, const QTime& v)
+      {
+        if (v.isNull ())
+          is_null = true;
+        else
+        {
+          is_null = false;
+          i = static_cast<long long> (QTime (0, 0, 0).secsTo (v));
+        }
+      }
+    };
+
+    template <>
+    class default_type_traits<QTime>
+    {
+      static const database_type_id db_type_id = id_text;
+    };
+  }
+}
+
+#endif // ODB_QT_DATE_TIME_SQLITE_QTIME_TRAITS_HXX