PgTypes_.h File Reference

Go to the source code of this file.

Macros
#define	__DCL_PG_TYPES_H__   20250406

Functions
__DCL_BEGIN_NAMESPACE void	__decode (const date *_s, SQL::Date *_r)
void	__encode (const SQL::Date *_s, date *_r)
void	__decode (const char *_s, SQL::Time *_r)
ByteString	__encode (const SQL::Time *_s)
void	__decode (const timestamp *_s, SQL::TimeStamp *_r)
void	__encode (const SQL::TimeStamp *_s, timestamp *_r)
void	__decode (const interval *_s, SQL::Interval *_r)
void	__encode (const SQL::Interval *_s, interval *_r)

Macro Definition Documentation

__DCL_PG_TYPES_H__

#define __DCL_PG_TYPES_H__   20250406

Definition at line 2 of file PgTypes_.h.

Function Documentation

__decode() [1/4]

void __decode	(	const char *	_s,
		SQL::Time *	_r )

Definition at line 49 of file PgTypes.cpp.

{
    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;
}

__decode() [2/4]

__DCL_BEGIN_NAMESPACE void __decode	(	const date *	_s,
		SQL::Date *	_r )

Definition at line 27 of file PgTypes.cpp.

{
    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]);
}

__decode() [3/4]

void __decode	(	const interval *	_s,
		SQL::Interval *	_r )

Definition at line 110 of file PgTypes.cpp.

{
    //__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);
}

__decode() [4/4]

void __decode	(	const timestamp *	_s,
		SQL::TimeStamp *	_r )

Definition at line 65 of file PgTypes.cpp.

{
    // 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);
}

__encode() [1/4]

void __encode	(	const SQL::Date *	_s,
		date *	_r )

Definition at line 37 of file PgTypes.cpp.

{
    int mdy[3];
    mdy[0] = _s->nMonth;
    mdy[1] = _s->nDay;
    mdy[2] = _s->nYear;
    PGTYPESdate_mdyjul(mdy, _r);
}

__encode() [2/4]

void __encode	(	const SQL::Interval *	_s,
		interval *	_r )

Definition at line 126 of file PgTypes.cpp.

{
    //__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)
        ;
}

__encode() [3/4]

ByteString __encode

(

const SQL::Time *

_s

)

Definition at line 59 of file PgTypes.cpp.

{
    return ByteString::format(__TIME_FORMAT,
        _s->nHour, _s->nMin, _s->nSec, _s->nFrac / 10000);
}

__encode() [4/4]

void __encode	(	const SQL::TimeStamp *	_s,
		timestamp *	_r )

Definition at line 92 of file PgTypes.cpp.

{
    //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);
}