aboutsummaryrefslogtreecommitdiff
path: root/mapping/traits-pgsql.hxx
blob: e196321ed69e17bb7d88d01275173059a537b9bd (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
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
// file      : mapping/traits-pgsql.hxx
// author    : Constantin Michael <constantin@codesynthesis.com>
// copyright : not copyrighted - public domain

#ifndef TRAITS_PGSQL_HXX
#define TRAITS_PGSQL_HXX

//
// PostgreSQL implementation.
//

#include <cstring>
#include <ctime>

#include <odb/pgsql/traits.hxx>
#include <odb/pgsql/details/endian-traits.hxx>

#include "person.hxx" // date

namespace odb
{
  namespace pgsql
  {
    template <>
    class value_traits<bool, id_string>
    {
    public:
      typedef bool value_type;
      typedef bool query_type;
      typedef details::buffer image_type;

      static void
      set_value (bool& v,
                 const details::buffer& b,
                 std::size_t n,
                 bool is_null)
      {
        v = (!is_null && n == 4 && std::strncmp ("true", b.data (), n) == 0);
      }

      static void
      set_image (details::buffer& b,
                 std::size_t& n,
                 bool& is_null,
                 bool v)
      {
        is_null = false;
        n = v ? 4 : 5;

        if (n > b.capacity ())
          b.capacity (n);

        std::memcpy (b.data (), (v ? "true" : "false"), n);
      }
    };

    // Mapping of date to PostgreSQL DATE. DATE is stored as the number
    // of days since the PostgreSQL epoch 2000-01-01.
    //
    template <>
    class value_traits<date, id_date>
    {
    public:
      typedef date value_type;
      typedef date query_type;
      typedef int image_type;

      // The difference between the PostgreSQL epoch and the Unix epoch
      // in seconds.
      //
      static const time_t epoch_diff = 946684800;

      static const time_t seconds_per_day = 86400;

      static void
      set_value (date& v, const int& i, bool is_null)
      {
        if (is_null)
        {
          v = date (0, 0, 0);
          return;
        }

        time_t v_tt (epoch_diff +
                     static_cast<time_t> (details::endian_traits::ntoh (i)) *
                     seconds_per_day);

        // Assume that the date is specified as UTC. Use localtime so as
        // to avoid any timeshift that could be introduced by the system
        // time locale not being UTC.
        //
        tm v_tm (*localtime (&v_tt));

        v = date (v_tm.tm_year + 1900, v_tm.tm_mon, v_tm.tm_mday);
      }

      static void
      set_image (int& i, bool& is_null, const date& v)
      {
        is_null = false;

        tm v_tm;
        memset (&v_tm, 0, sizeof (v_tm));

        v_tm.tm_mday = v.day ();
        v_tm.tm_mon = v.month ();
        v_tm.tm_year = v.year () - 1900;

        time_t v_tt (mktime (&v_tm));

        i = details::endian_traits::hton (
          static_cast<int> ((v_tt - epoch_diff) / seconds_per_day));
      }
    };
  }
}

#endif // TRAITS_PGSQL_HXX