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/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 ++++++++++++++++++++++ 4 files changed, 244 insertions(+) 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 (limited to 'odb/qt/date-time') 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