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->nMonth = mdy[0];
    _r->nDay = mdy[1];
    _r->nYear = 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->nMonth;
    mdy[1] = _s->nDay;
    mdy[2] = _s->nYear;
    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->nHour = h;
    _r->nMin = m;
    _r->nSec = s;
    _r->nFrac = f * 10000;
}
 
ByteString __encode(const SQL::Time* _s)
{
    return ByteString::format(__TIME_FORMAT,
        _s->nHour, _s->nMin, _s->nSec, _s->nFrac / 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, zh, zm;
    (void) sscanf(sz, "%d-%02u-%02u %02u:%02u:%02u %3d%02u",
        &Y, &m, &d, &H, &M, &S, &zh, &zm);
    _r->nYear = Y - (*_s < -63082281600000000LL ? 1 : 0);
    _r->nMonth = m;
    _r->nDay = d;
    _r->nHour = H;
    _r->nMin = M;
    _r->nSec = S;
    _r->nFrac = 0;
    _r->nTzMin = INT16_MIN; // (zh * 60) + zm;
    //__DCL_TRACE4(L"[%d][%d][%d][%d]\n", Y, m, d, H);
    //__DCL_TRACE4(L"[%d][%d][%d][%d]\n", M, S, zh, zm);
}
 
inline int __ABS(int n)
{
    return n < 0 ? -n : n;
}
 
void __encode(const SQL::TimeStamp* _s, timestamp* _r)
{
    //int zh = 0, zm = 0;
    //if (_s->nTzMin != INT16_MIN) {
    //  zh = _s->nTzMin / 60;
    //  zm = __ABS(_s->nTzMin % 60);
    //}
    char sz[40];
    int n = snprintf(
        sz, sizeof(sz), "%04d-%02u-%02u %02u:%02u:%02u",
        _s->nYear, _s->nMonth, _s->nDay,
        _s->nHour, _s->nMin, _s->nSec
    );
    //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->nYears = _s->month / 12;
    _r->nMonths = _s->month % 12;
 
    _r->nFracs = (_s->time % 1000000) * 1000;
    int64_t t = _s->time / 1000000;
    _r->nSecs = t % 60;
    t /= 60;
    _r->nMins = t % 60;
    t /= 60;
    _r->nHours = t % 24;
    _r->nDays = (int) (t / 24);
}
 
void __encode(const SQL::Interval* _s, interval* _r)
{
    //__DCL_TRACE3(L"[%d][%d][%d]\n", _s->nYears, _s->nMonths, _s->nDays);
    //__DCL_TRACE4(L"[%d][%d][%d][%d]\n",
    //  _s->nHours, _s->nMins, _s->nSecs, _s->nFracs);
    _r->month = _s->nYears * 12 + _s->nMonths;
    _r->time = (_s->nFracs / 1000LL)
        + (_s->nSecs * 1000000LL)
        + (_s->nMins * 60 * 1000000LL)
        + (_s->nHours * 60 * 60 * 1000000LL)
        + (_s->nDays * 24 * 60 * 60 * 1000000LL)
        ;
}
 
__DCL_END_NAMESPACE