aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorConstantin Michael <constantin@codesynthesis.com>2011-07-22 00:06:17 +0200
committerConstantin Michael <constantin@codesynthesis.com>2011-07-22 10:01:36 +0200
commitd8b3a3388349d7055423f35911ef8ae17aba5ab4 (patch)
tree3e36125efb4ffa4ad3687a601e9ca26b4d0302a0
parent3ccd52b46db124086345f3c7b8e95e435d500903 (diff)
Add PostgreSQL support to Qt profile
-rw-r--r--odb/qt/basic-pgsql.options11
-rw-r--r--odb/qt/basic/pgsql/default-mapping.hxx22
-rw-r--r--odb/qt/basic/pgsql/qbyte-array-traits.hxx71
-rw-r--r--odb/qt/basic/pgsql/qstring-traits.hxx76
-rw-r--r--odb/qt/date-time-pgsql.options12
-rw-r--r--odb/qt/date-time/pgsql/default-mapping.hxx28
-rw-r--r--odb/qt/date-time/pgsql/qdate-time-traits.hxx84
-rw-r--r--odb/qt/date-time/pgsql/qdate-traits.hxx65
-rw-r--r--odb/qt/date-time/pgsql/qtime-traits.hxx67
9 files changed, 436 insertions, 0 deletions
diff --git a/odb/qt/basic-pgsql.options b/odb/qt/basic-pgsql.options
new file mode 100644
index 0000000..1940dc6
--- /dev/null
+++ b/odb/qt/basic-pgsql.options
@@ -0,0 +1,11 @@
+# file : odb/qt/basic-pgsql.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 qt/version
+
+--odb-epilogue '#include <odb/qt/basic/pgsql/default-mapping.hxx>'
+
+--hxx-prologue '#include <odb/qt/basic/pgsql/qstring-traits.hxx>'
+--hxx-prologue '#include <odb/qt/basic/pgsql/qbyte-array-traits.hxx>'
diff --git a/odb/qt/basic/pgsql/default-mapping.hxx b/odb/qt/basic/pgsql/default-mapping.hxx
new file mode 100644
index 0000000..17882e4
--- /dev/null
+++ b/odb/qt/basic/pgsql/default-mapping.hxx
@@ -0,0 +1,22 @@
+// file : odb/qt/basic/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_BASIC_PGSQL_DEFAULT_MAPPING_HXX
+#define ODB_QT_BASIC_PGSQL_DEFAULT_MAPPING_HXX
+
+#include <QtCore/QString>
+#include <QtCore/QByteArray>
+
+// Map QString to PostgreSQL TEXT by default. Allow NULL values by default as
+// QString provides a null representation.
+//
+#pragma db value(QString) type("TEXT") null
+
+// Map QByteArray to PostgreSQL BYTEA by default. Allow NULL values by default
+// as QByteArray provides a null representation.
+//
+#pragma db value(QByteArray) type("BYTEA") null
+
+#endif // ODB_QT_BASIC_PGSQL_DEFAULT_MAPPING_HXX
diff --git a/odb/qt/basic/pgsql/qbyte-array-traits.hxx b/odb/qt/basic/pgsql/qbyte-array-traits.hxx
new file mode 100644
index 0000000..cf0477e
--- /dev/null
+++ b/odb/qt/basic/pgsql/qbyte-array-traits.hxx
@@ -0,0 +1,71 @@
+// file : odb/qt/basic/pgsql/qbyte-array-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_BASIC_PGSQL_QBYTE_ARRAY_TRAITS_HXX
+#define ODB_QT_BASIC_PGSQL_QBYTE_ARRAY_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <cstring> // std::memcpy
+#include <cstddef> // std::size_t
+
+#include <QtCore/QByteArray>
+
+#include <odb/details/buffer.hxx>
+#include <odb/pgsql/traits.hxx>
+
+namespace odb
+{
+ namespace pgsql
+ {
+ template <>
+ struct default_value_traits<QByteArray, id_bytea>
+ {
+ typedef QByteArray value_type;
+ typedef QByteArray query_type;
+ typedef details::buffer image_type;
+
+ static void
+ set_value (QByteArray& v,
+ const details::buffer& b,
+ std::size_t n,
+ bool is_null)
+ {
+ if (is_null)
+ v = QByteArray ();
+ else
+ v.replace (0, v.size (), b.data (), static_cast<int> (n));
+ }
+
+ static void
+ set_image (details::buffer& b,
+ std::size_t& n,
+ bool& is_null,
+ const QByteArray& v)
+ {
+ if (v.isNull ())
+ is_null = true;
+ else
+ {
+ is_null = false;
+
+ n = static_cast<std::size_t> (v.size ());
+ if (n > b.capacity ())
+ b.capacity (n);
+
+ std::memcpy (b.data (), v.data (), n);
+ }
+ }
+ };
+
+ template <>
+ struct default_type_traits<QByteArray>
+ {
+ static const database_type_id db_type_id = id_bytea;
+ };
+ }
+}
+
+#endif // ODB_QT_BASIC_PGSQL_QBYTE_ARRAY_TRAITS_HXX
diff --git a/odb/qt/basic/pgsql/qstring-traits.hxx b/odb/qt/basic/pgsql/qstring-traits.hxx
new file mode 100644
index 0000000..047509b
--- /dev/null
+++ b/odb/qt/basic/pgsql/qstring-traits.hxx
@@ -0,0 +1,76 @@
+// file : odb/qt/basic/pgsql/qstring-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_BASIC_PGSQL_QSTRING_TRAITS_HXX
+#define ODB_QT_BASIC_PGSQL_QSTRING_TRAITS_HXX
+
+#include <odb/pre.hxx>
+
+#include <cstring> // std::memcpy
+#include <cstddef> // std::size_t
+
+#include <QtCore/QString>
+
+#include <odb/details/buffer.hxx>
+#include <odb/pgsql/traits.hxx>
+
+namespace odb
+{
+ namespace pgsql
+ {
+ template <>
+ struct default_value_traits <QString, id_string>
+ {
+ public:
+ typedef QString value_type;
+ typedef QString query_type;
+ typedef details::buffer image_type;
+
+ static void
+ set_value (QString& v,
+ const details::buffer& b,
+ std::size_t n,
+ bool is_null)
+ {
+ if (is_null)
+ v = QString ();
+ else
+ v = QString::fromUtf8 (b.data (), static_cast<int> (n));
+ }
+
+ static void
+ set_image (details::buffer& b,
+ std::size_t& n,
+ bool& is_null,
+ const QString& v)
+ {
+ if (v.isNull ())
+ is_null = true;
+ else
+ {
+ is_null = false;
+
+ const QByteArray& a (v.toUtf8 ());
+ n = static_cast<std::size_t> (a.size ());
+
+ if (n > b.capacity ())
+ b.capacity (n);
+
+ std::memcpy (b.data (), a.data (), n);
+ }
+ }
+ };
+
+ template <>
+ struct default_type_traits<QString>
+ {
+ static const database_type_id db_type_id = id_string;
+ };
+ }
+}
+
+#include <odb/post.hxx>
+
+#endif // ODB_QT_BASIC_PGSQL_QSTRING_TRAITS_HXX
diff --git a/odb/qt/date-time-pgsql.options b/odb/qt/date-time-pgsql.options
new file mode 100644
index 0000000..a637b60
--- /dev/null
+++ b/odb/qt/date-time-pgsql.options
@@ -0,0 +1,12 @@
+# file : odb/qt/date-time-pgsql.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 qt/version
+
+--odb-epilogue '#include <odb/qt/date-time/pgsql/default-mapping.hxx>'
+
+--hxx-prologue '#include <odb/qt/date-time/pgsql/qdate-traits.hxx>'
+--hxx-prologue '#include <odb/qt/date-time/pgsql/qtime-traits.hxx>'
+--hxx-prologue '#include <odb/qt/date-time/pgsql/qdate-time-traits.hxx>'
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