aboutsummaryrefslogtreecommitdiff
path: root/odb/qt/date-time/pgsql/qdate-traits.hxx
blob: f52872fbf9fc896029bdd600108aad2443a10e9b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
// file      : odb/qt/date-time/pgsql/qdate-traits.hxx
// copyright : Copyright (c) 2009-2015 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>

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
        {
          const QDate pg_epoch (2000, 1, 1);
          v = pg_epoch.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;
          const QDate pg_epoch (2000, 1, 1);
          // In Qt5 daysTo() returns qint64.
          //
          i = endian_traits::hton (static_cast<int> (pg_epoch.daysTo (v)));
        }
      }
    };

    template <>
    struct default_type_traits<QDate>
    {
      static const database_type_id db_type_id = id_date;
    };
  }
}

#include <odb/post.hxx>

#endif // ODB_QT_DATE_TIME_PGSQL_QDATE_TRAITS_HXX