Ejemplo n.º 1
0
        // sets val as DateTime with Oid oid (PqsqlDbType.Time, PqsqlDbType.TimeTZ) into pqparam_buffer pb
        internal static void SetDate(IntPtr pb, object val, PqsqlDbType oid)
        {
            DateTime dt = (DateTime)val;

            int year;
            int month;
            int day;

            PqsqlBinaryFormat.GetDate(dt, out year, out month, out day);

            PqsqlBinaryFormat.pqbf_add_date(pb, year, month, day);
        }
Ejemplo n.º 2
0
        // adds o as DateTime array element into PQExpBuffer a
        internal static void SetDateArray(IntPtr a, object o)
        {
            DateTime dt = (DateTime)o;

            int year;
            int month;
            int day;

            PqsqlBinaryFormat.GetDate(dt, out year, out month, out day);

            PqsqlBinaryFormat.pqbf_set_array_itemlength(a, 4);
            PqsqlBinaryFormat.pqbf_set_date(a, year, month, day);
        }
Ejemplo n.º 3
0
        public int WriteDate(DateTime value)
        {
            if (mRowInfo == null)
            {
                throw new InvalidOperationException($"{nameof(PqsqlCopyFrom)}.{nameof(Start)} must be called before we can write data");
            }

            long begin = LengthCheckReset();

#if CODECONTRACTS
            Contract.Assume(mRowInfo != null);
            Contract.Assume(mPos >= 0 && mPos < mRowInfo.Length);
#endif

            PqsqlColInfo ci = mRowInfo[mPos];
            if (ci == null)
            {
                throw new PqsqlException($"{nameof(PqsqlCopyFrom)}.{nameof(Start)} could not setup column information for column {mPos}");
            }

            PqsqlDbType oid = ci.Oid;

            if (oid != PqsqlDbType.Date)
            {
                throw new PqsqlException($"{nameof(PqsqlCopyFrom)}.{nameof(WriteDate)}: cannot write {PqsqlDbType.Date} into column {mPos} of type {oid}");
            }

            int year;
            int month;
            int day;
            PqsqlBinaryFormat.GetDate(value, out year, out month, out day);

            PqsqlBinaryFormat.pqbf_set_date(mExpBuf, year, month, day);
            unsafe
            {
                sbyte *val = PqsqlBinaryFormat.pqbf_get_bufval(mExpBuf) + begin;
                return(PutColumn(val, 4));
            }
        }