How to use the pg.types.getTypeParser function in pg

To help you get started, we’ve selected a few pg examples, based on popular ways it is used in public projects.

Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.

github opentrials / api / test / config / pg_types.js View on Github external
describe('parseDate', () => {
  const DATE_OID = 1082;
  const parseDate = pgTypes.getTypeParser(DATE_OID);

  it('does not offset time', () => {
    const testDate = '2016-12-01';
    const expectedDate = new Date(testDate).toISOString();
    const resultedDate = parseDate(testDate);
    resultedDate.toISOString().should.equal(expectedDate);
  });

  it('returns null when value is null', () => {
    const testDate = null;
    should(parseDate(testDate)).equal(null);
  });
});
github opentrials / api / test / config / pg_types.js View on Github external
describe('parseDateArray', () => {
  const DATE_ARRAY_OID = 1182;
  const parseDateArray = pgTypes.getTypeParser(DATE_ARRAY_OID);

  it('parses array correctly', () => {
    const testDate = '2014-01-12';
    const testPgArray = `{${testDate}}`;
    const expectedDate = new Date(testDate).toISOString();
    const resultedArray = parseDateArray(testPgArray);
    resultedArray.map((date) => date.toISOString()).should.deepEqual([
      expectedDate,
    ]);
  });

  it('returns null when value is null', () => {
    const testPgArray = null;
    should(parseDateArray(testPgArray)).equal(null);
  });
github cube-js / cube.js / packages / cubejs-postgres-driver / driver / PostgresDriver.js View on Github external
getTypeParser: (dataType, format) => {
            const isTimestamp = timestampDataTypes.indexOf(dataType) > -1;
            let parser = types.getTypeParser(dataType, format);

            if (isTimestamp) {
              parser = timestampTypeParser;
            }

            return val => parser(val);
          },
        },