Simple bytea support, returning buffers instead of escaped strings.

drdaeman · drdaeman · commit f0aa7ccaea73 · 2011-07-20T02:14:40.000+04:00
diff --git a/lib/types.js b/lib/types.js
@@ -122,6 +122,12 @@ var parseInterval = function(val) {
   return i;
 };
 
+var parseByteA = function(val) {
+  return new Buffer(val.replace(/\\([0-7]{3})/g, function (full_match, code) {
+    return String.fromCharCode(parseInt(code, 8));
+  }).replace(/\\\\/g, "\\"), "binary");
+}
+
 //default string type parser registrations
 registerStringTypeParser(20, parseInt);
 registerStringTypeParser(21, parseInt);
@@ -136,6 +142,7 @@ registerStringTypeParser(1184, parseDate);
 registerStringTypeParser(1007, parseIntegerArray);
 registerStringTypeParser(1009, parseStringArray);
 registerStringTypeParser(1186, parseInterval);
+registerStringTypeParser(17, parseByteA);
 
 module.exports = {
   registerStringTypeParser: registerStringTypeParser,
diff --git a/test/unit/client/typed-query-results-tests.js b/test/unit/client/typed-query-results-tests.js
@@ -119,6 +119,20 @@ test('typed results', function() {
     expected: function(val) {
       assert.deepEqual(val, {'days':1, 'seconds':-3})
     }
+  },{
+    name: 'bytea',
+    dataTypeID: 17,
+    actual: 'foo\\000\\200\\\\\\377',
+    expected: function(val) {
+      assert.deepEqual(val, new Buffer([102, 111, 111, 0, 128, 92, 255]));
+    }
+  },{
+    name: 'empty bytea',
+    dataTypeID: 17,
+    actual: '',
+    expected: function(val) {
+      assert.deepEqual(val, new Buffer(0));
+    }
   }];
 
 
