From d8b3a3388349d7055423f35911ef8ae17aba5ab4 Mon Sep 17 00:00:00 2001 From: Constantin Michael Date: Fri, 22 Jul 2011 00:06:17 +0200 Subject: Add PostgreSQL support to Qt profile --- odb/qt/basic-pgsql.options | 11 ++++ odb/qt/basic/pgsql/default-mapping.hxx | 22 ++++++++ odb/qt/basic/pgsql/qbyte-array-traits.hxx | 71 +++++++++++++++++++++++ odb/qt/basic/pgsql/qstring-traits.hxx | 76 +++++++++++++++++++++++++ odb/qt/date-time-pgsql.options | 12 ++++ odb/qt/date-time/pgsql/default-mapping.hxx | 28 ++++++++++ odb/qt/date-time/pgsql/qdate-time-traits.hxx | 84 ++++++++++++++++++++++++++++ odb/qt/date-time/pgsql/qdate-traits.hxx | 65 +++++++++++++++++++++ odb/qt/date-time/pgsql/qtime-traits.hxx | 67 ++++++++++++++++++++++ 9 files changed, 436 insertions(+) create mode 100644 odb/qt/basic-pgsql.options create mode 100644 odb/qt/basic/pgsql/default-mapping.hxx create mode 100644 odb/qt/basic/pgsql/qbyte-array-traits.hxx create mode 100644 odb/qt/basic/pgsql/qstring-traits.hxx create mode 100644 odb/qt/date-time-pgsql.options create mode 100644 odb/qt/date-time/pgsql/default-mapping.hxx create mode 100644 odb/qt/date-time/pgsql/qdate-time-traits.hxx create mode 100644 odb/qt/date-time/pgsql/qdate-traits.hxx create mode 100644 odb/qt/date-time/pgsql/qtime-traits.hxx 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 +# copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC +# license : GNU GPL v2; see accompanying LICENSE file + +--profile qt/version + +--odb-epilogue '#include ' + +--hxx-prologue '#include ' +--hxx-prologue '#include ' 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 +// 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 +#include + +// 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 +// 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 + +#include // std::memcpy +#include // std::size_t + +#include + +#include +#include + +namespace odb +{ + namespace pgsql + { + template <> + struct default_value_traits + { + 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 (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 (v.size ()); + if (n > b.capacity ()) + b.capacity (n); + + std::memcpy (b.data (), v.data (), n); + } + } + }; + + template <> + struct default_type_traits + { + 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 +// 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 + +#include // std::memcpy +#include // std::size_t + +#include + +#include +#include + +namespace odb +{ + namespace pgsql + { + template <> + struct default_value_traits + { + 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 (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 (a.size ()); + + if (n > b.capacity ()) + b.capacity (n); + + std::memcpy (b.data (), a.data (), n); + } + } + }; + + template <> + struct default_type_traits + { + static const database_type_id db_type_id = id_string; + }; + } +} + +#include + +#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 +# copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC +# license : GNU GPL v2; see accompanying LICENSE file + +--profile qt/version + +--odb-epilogue '#include ' + +--hxx-prologue '#include ' +--hxx-prologue '#include ' +--hxx-prologue '#include ' 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 +// 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 +#include +#include + +// 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 +// 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 + +#include + +#include +#include +#include + +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 + { + 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 ( + 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 (v.toTime_t ()) - + epoch_diff); + + i = endian_traits::hton (pg_seconds * 1000000); + } + } + }; + + template <> + struct default_type_traits + { + 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 +// 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 + +#include + +#include +#include + +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 + { + 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 + { + 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 +// 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 + +#include + +#include + +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 + { + 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 (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 (QTime (0, 0, 0).secsTo (v)) * 1000000); + } + } + }; + + template <> + struct default_type_traits + { + static const database_type_id db_type_id = id_time; + }; + } +} + +#endif // ODB_QT_DATE_TIME_PGSQL_QTIME_TRAITS_HXX -- cgit v1.1