PgTypes.cpp

Go to the documentation of this file.

#include <dcl/Config.h>
 
#include <pgtypes_date.h>
#include <pgtypes_timestamp.h>
#include <pgtypes_interval.h>
 
#include <stdio.h>
#include <string.h>
 
#include <dcl/Object.h>
#if __DCL_HAVE_ALLOC_DEBUG
#undef __DCL_ALLOC_LEVEL
#define __DCL_ALLOC_LEVEL   __DCL_ALLOC_INTERNAL
#endif
 
#include <dcl/SQLCore.h>
 
#include "PgTypes_.h"
 
#ifdef __DCL_DEBUG
#undef __THIS_FILE__
static const wchar_t __THIS_FILE__[] = __T("dcl/sql/PgTypes.cpp");
#endif
 
__DCL_BEGIN_NAMESPACE
 
void __decode(const date* _s, SQL::Date* _r)
{
    int mdy[3];
    PGTYPESdate_julmdy(*_s, mdy);
    _r->month = mdy[0];
    _r->day = mdy[1];
    _r->year = mdy[2] - (*_s < 730119 ? 1 : 0);
    //__DCL_TRACE4(L"[%d][%d][%d][%d]\n", *_s, mdy[0], mdy[1], mdy[2]);
}
 
void __encode(const SQL::Date* _s, date* _r)
{
    int mdy[3];
    mdy[0] = _s->month;
    mdy[1] = _s->day;
    mdy[2] = _s->year;
    PGTYPESdate_mdyjul(mdy, _r);
}
 
static const char* __TIME_FORMAT =
    "%02u:%02u:%02u.%05u";
 
void __decode(const char* _s, SQL::Time* _r)
{
    int h, m, s, f;
    (void) sscanf(_s, __TIME_FORMAT, &h, &m, &s, &f);
    _r->hour = h;
    _r->min = m;
    _r->sec = s;
    _r->frac = f * 10000;
    _r->tzoff = INT16_MIN;
}
 
ByteString __encode(const SQL::Time* _s)
{
    return ByteString::format(__TIME_FORMAT,
        _s->hour, _s->min, _s->sec, _s->frac / 10000);
}
 
void __decode(const timestamp* _s, SQL::TimeStamp* _r)
{
    // PostgreSQL timestamp API에서 TZ는 무시된다.
    char sz[40];    // 2025-04-07 10:09:49 +0900 25
    int r = PGTYPEStimestamp_fmt_asc((timestamp*) _s, sz, sizeof(sz),
        "%Y-%m-%d %H:%M:%S %z");
    //__DCL_TRACE2(L"[%lld][%hs]\n", *_s, sz);
    int Y, m, d, H, M, S, tzhour, tzmin;
    (void) sscanf(sz, "%d-%02u-%02u %02u:%02u:%02u %3d%02u",
        &Y, &m, &d, &H, &M, &S, &tzhour, &tzmin);
    _r->year = Y - (*_s < -63082281600000000LL ? 1 : 0);
    _r->month = m;
    _r->day = d;
    _r->hour = H;
    _r->min = M;
    _r->sec = S;
    _r->frac = 0;
    _r->tzoff = INT16_MIN; // (tzhour * 60) + tzmin;
    //__DCL_TRACE4(L"[%d][%d][%d][%d]\n", Y, m, d, H);
    //__DCL_TRACE4(L"[%d][%d][%d][%d]\n", M, S, tzhour, tzmin);
}
 
inline int __ABS(int n)
{
    return n < 0 ? -n : n;
}
 
void __encode(const SQL::TimeStamp* _s, timestamp* _r)
{
    //int tzhour = 0, tzmin = 0;
    //if (_s->tzoff != INT16_MIN) {
    //  tzhour = _s->tzoff / 60;
    //  tzmin = __ABS(_s->tzoff % 60);
    //}
    char sz[40];
    int n = snprintf(
        sz, sizeof(sz), "%04d-%02u-%02u %02u:%02u:%02u",
        _s->year, _s->month, _s->day,
        _s->hour, _s->min, _s->sec
    );
    //sz[n] = '\0';
    //__DCL_TRACE1(L"[%hs]\n", sz);
    PGTYPEStimestamp_defmt_asc(sz, "%Y-%m-%d %H:%M:%S", _r);
}
 
void __decode(const interval* _s, SQL::Interval* _r)
{
    //__DCL_TRACE2(L"month[%ld] time[%lld]\n", _s->month, _s->time);
    _r->years = _s->month / 12;
    _r->months = _s->month % 12;
 
    _r->fracs = (_s->time % 1000000) * 1000;
    int64_t t = _s->time / 1000000;
    _r->secs = t % 60;
    t /= 60;
    _r->mins = t % 60;
    t /= 60;
    _r->hours = t % 24;
    _r->days = (int) (t / 24);
}
 
void __encode(const SQL::Interval* _s, interval* _r)
{
    //__DCL_TRACE3(L"[%d][%d][%d]\n", _s->years, _s->months, _s->days);
    //__DCL_TRACE4(L"[%d][%d][%d][%d]\n",
    //  _s->hours, _s->mins, _s->secs, _s->fracs);
    _r->month = _s->years * 12 + _s->months;
    _r->time = (_s->fracs / 1000LL)
        + (_s->secs * 1000000LL)
        + (_s->mins * 60 * 1000000LL)
        + (_s->hours * 60 * 60 * 1000000LL)
        + (_s->days * 24 * 60 * 60 * 1000000LL)
        ;
}
 
__DCL_END_NAMESPACE