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->hour = h;
    _r->min = m;
    _r->sec = s;
    _r->frac = f * 10000;
    _r->tzoff = INT16_MIN;
}

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

__decode() [3/4]

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

Definition at line 111 of file PgTypes.cpp.

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

__decode() [4/4]

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

Definition at line 66 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, 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);
}

__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->month;
    mdy[1] = _s->day;
    mdy[2] = _s->year;
    PGTYPESdate_mdyjul(mdy, _r);
}

__encode() [2/4]

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

Definition at line 127 of file PgTypes.cpp.

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

__encode() [3/4]

ByteString __encode

(

const SQL::Time *

_s

)

Definition at line 60 of file PgTypes.cpp.

{
    return ByteString::format(__TIME_FORMAT,
        _s->hour, _s->min, _s->sec, _s->frac / 10000);
}

__encode() [4/4]

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

Definition at line 93 of file PgTypes.cpp.

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