pg-types - npm Package Compare versions

Comparing version 1.11.0 to 1.12.0

lib/textParsers.js

@@ -17,3 +17,9 @@ var array = require('postgres-array')
   if (value === null) return value
-  return value === 't';
+  return value === 'TRUE' ||
+    value === 't' ||
+    value === 'true' ||
+    value === 'y' ||
+    value === 'yes' ||
+    value === 'on' ||
+    value === '1';
 }
@@ -38,2 +44,14 @@
 
+var parsePointArray = function(value) {
+  if(!value) { return null; }
+  var p = arrayParser.create(value, function(entry) {
+    if(entry !== null) {
+      entry = parsePoint(entry);
+    }
+    return entry;
+  });
+
+  return p.parse();
+};
+
 var parseFloatArray = function(value) {
@@ -153,2 +171,3 @@ if(!value) { return null; }
   register(600, parsePoint); // point
+  register(651, parseStringArray); // cidr[]
   register(718, parseCircle); // circle
@@ -161,2 +180,3 @@ register(1000, parseBoolArray);
   register(1016, parseBigIntegerArray); // _int8
+  register(1017, parsePointArray); // point[]
   register(1021, parseFloatArray); // _float4
@@ -169,2 +189,4 @@ register(1022, parseFloatArray); // _float8
   register(1009, parseStringArray);
+  register(1040, parseStringArray); // macaddr[]
+  register(1041, parseStringArray); // inet[]
   register(1115, parseDateArray); // timestamp without time zone[]
@@ -179,5 +201,7 @@ register(1182, parseDateArray); // _date
   register(3807, parseJsonArray); // jsonb[]
+  register(3907, parseStringArray); // numrange[]
   register(2951, parseStringArray); // uuid[]
   register(791, parseStringArray); // money[]
   register(1183, parseStringArray); // time[]
+  register(1270, parseStringArray); // timetz[]
 };
@@ -184,0 +208,0 @@

package.json

 {
   "name": "pg-types",
-  "version": "1.11.0",
+  "version": "1.12.0",
   "description": "Query result type converters for node-postgres",
@@ -34,4 +34,4 @@ "main": "index.js",
     "postgres-date": "~1.0.0",
-    "postgres-interval": "~1.0.0"
+    "postgres-interval": "^1.1.0"
   }
 }

test/types.js

@@ -72,3 +72,9 @@ 'use strict'
   tests: [
+    ['TRUE', true],
     ['t', true],
+    ['true', true],
+    ['y', true],
+    ['yes', true],
+    ['on', true],
+    ['1', true],
     ['f', false],
@@ -138,2 +144,49 @@ [null, null]
 
+exports.inet = {
+  format: 'text',
+  id: 869,
+  tests: [
+    ['8.8.8.8', '8.8.8.8'],
+    ['2001:4860:4860::8888', '2001:4860:4860::8888'],
+    ['127.0.0.1', '127.0.0.1'],
+    ['fd00:1::40e', 'fd00:1::40e'],
+    ['1.2.3.4', '1.2.3.4']
+  ]
+}
+
+exports.cidr = {
+  format: 'text',
+  id: 650,
+  tests: [
+    ['172.16.0.0/12', '172.16.0.0/12'],
+    ['fe80::/10', 'fe80::/10'],
+    ['fc00::/7', 'fc00::/7'],
+    ['192.168.0.0/24', '192.168.0.0/24'],
+    ['10.0.0.0/8', '10.0.0.0/8']
+  ]
+}
+
+exports.macaddr = {
+  format: 'text',
+  id: 829,
+  tests: [
+    ['08:00:2b:01:02:03', '08:00:2b:01:02:03'],
+    ['16:10:9f:0d:66:00', '16:10:9f:0d:66:00']
+  ]
+}
+
+exports.numrange = {
+  format: 'text',
+  id: 3906,
+  tests: [
+    ['[,]', '[,]'],
+    ['(,)', '(,)'],
+    ['(,]', '(,]'],
+    ['[1,)', '[1,)'],
+    ['[,1]', '[,1]'],
+    ['(1,2)', '(1,2)'],
+    ['(1,20.5]', '(1,20.5]']
+  ]
+}
+
 exports.interval = {
@@ -176,2 +229,12 @@ format: 'text',
 
+exports['array/boolean'] = {
+    format: 'text',
+    id: 1000,
+    tests: [
+        ['{true,false}', function (t, value) {
+            t.deepEqual(value, [true, false])
+        }]
+    ]
+}
+
 exports['array/char'] = {
@@ -268,2 +331,12 @@ format: 'text',
 
+exports['array/point'] = {
+  format: 'text',
+  id: 1017,
+  tests: [
+    ['{"(25.1,50.5)","(10.1,40)"}', function (t, value) {
+      t.deepEqual(value, [{x: 25.1, y: 50.5}, {x: 10.1, y: 40}])
+    }]
+  ]
+}
+
 exports['array/oid'] = {
@@ -318,2 +391,60 @@ format: 'text',
 
+exports['array/inet'] = {
+  format: 'text',
+  id: 1041,
+  tests: [
+    ['{8.8.8.8}', function (t, value) {
+      t.deepEqual(value, ['8.8.8.8']);
+    }],
+    ['{2001:4860:4860::8888}', function (t, value) {
+      t.deepEqual(value, ['2001:4860:4860::8888']);
+    }],
+    ['{127.0.0.1,fd00:1::40e,1.2.3.4}', function (t, value) {
+      t.deepEqual(value, ['127.0.0.1', 'fd00:1::40e', '1.2.3.4']);
+    }]
+  ]
+}
+
+exports['array/cidr'] = {
+  format: 'text',
+  id: 651,
+  tests: [
+    ['{172.16.0.0/12}', function (t, value) {
+      t.deepEqual(value, ['172.16.0.0/12']);
+    }],
+    ['{fe80::/10}', function (t, value) {
+      t.deepEqual(value, ['fe80::/10']);
+    }],
+    ['{10.0.0.0/8,fc00::/7,192.168.0.0/24}', function (t, value) {
+      t.deepEqual(value, ['10.0.0.0/8', 'fc00::/7', '192.168.0.0/24']);
+    }]
+  ]
+}
+
+exports['array/macaddr'] = {
+  format: 'text',
+  id: 1040,
+  tests: [
+    ['{08:00:2b:01:02:03,16:10:9f:0d:66:00}', function (t, value) {
+      t.deepEqual(value, ['08:00:2b:01:02:03', '16:10:9f:0d:66:00']);
+    }]
+  ]
+}
+
+exports['array/numrange'] = {
+  format: 'text',
+  id: 3907,
+  tests: [
+    ['{"[1,2]","(4.5,8)","[10,40)","(-21.2,60.3]"}', function (t, value) {
+      t.deepEqual(value, ['[1,2]', '(4.5,8)', '[10,40)', '(-21.2,60.3]']);
+    }],
+    ['{"[,20]","[3,]","[,]","(,35)","(1,)","(,)"}', function (t, value) {
+      t.deepEqual(value, ['[,20]', '[3,]', '[,]', '(,35)', '(1,)', '(,)']);
+    }],
+    ['{"[,20)","[3,)","[,)","[,35)","[1,)","[,)"}', function (t, value) {
+      t.deepEqual(value, ['[,20)', '[3,)', '[,)', '[,35)', '[1,)', '[,)']);
+    }]
+  ]
+}
+
 exports['binary-string/varchar'] = {
@@ -320,0 +451,0 @@ format: 'binary',

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

28773

increased by14.46%

Lines of code

948

increased by17.76%

Dependency changes

• + Addedpostgres-interval@1.2.0(transitive)

• - Removedpostgres-interval@1.0.2(transitive)

• Updatedpostgres-interval@^1.1.0