pg - npm Package Compare versions

Comparing version 0.8.1 to 0.8.2

lib/defaults.js

@@ -17,3 +17,7 @@ module.exports = {
   rows: 0,
+
+  // binary result mode
+  binary: false,
   
+  //Connection pool options - see https://github.com/coopernurse/node-pool
   //number of connections to use in connection pool
@@ -30,4 +34,4 @@ //0 will disable connection pooling
 
-  // binary result mode
-  binary: false
+  //pool log function / boolean
+  poolLog: false
 }

lib/index.js

@@ -72,3 +72,4 @@ var EventEmitter = require('events').EventEmitter;
     idleTimeoutMillis: defaults.poolIdleTimeout,
-    reapIntervalMillis: defaults.reapIntervalMillis
+    reapIntervalMillis: defaults.reapIntervalMillis,
+    log: defaults.poolLog
   });
@@ -75,0 +76,0 @@ return pool.acquire(cb);

lib/textParsers.js

@@ -11,3 +11,10 @@ var arrayParser = require(__dirname + "/arrayParser.js");
   if(!match) {
-    return null;
+    dateMatcher = /^(\d{4})-(\d{2})-(\d{2})$/;
+    match = dateMatcher.test(isoDate);
+    if(!match) {
+      return null;
+    } else {
+      //it is a date in YYYY-MM-DD format
+      return new Date(isoDate);
+    }
   }
@@ -141,2 +148,3 @@ var year = match[1];
     register(16, parseBool);
+    register(1082, parseDate);
     register(1114, parseDate);
@@ -143,0 +151,0 @@ register(1184, parseDate);

package.json

 { "name": "pg",
-  "version": "0.8.1",
+  "version": "0.8.2",
   "description": "PostgreSQL client - pure javascript & libpq with the same API",
@@ -13,6 +13,6 @@ "keywords" : ["postgres", "pg", "libpq", "postgre", "database", "rdbms"],
   "dependencies" : {
-    "generic-pool" : "1.0.9"
+    "generic-pool" : "1.0.12"
   },
   "scripts" : { 
-    "test" : "make test",
+    "test" : "make test-all connectionString=pg://postgres@localhost:5432/postgres",
     "install" : "node-gyp rebuild || (exit 0)"
@@ -19,0 +19,0 @@ },

README.md

 #node-postgres
 
+[![Build Status](https://secure.travis-ci.org/brianc/node-postgres.png)](http://travis-ci.org/brianc/node-postgres)
+
 Non-blocking PostgreSQL client for node.js.  Pure JavaScript and native libpq bindings.  Active development,  well tested, and production use.
@@ -4,0 +6,0 @@

test/cli.js

@@ -1,2 +0,12 @@
-var config = require(__dirname + '/../lib/utils').parseConnectionString(process.argv[2])
+var config = {};
+if(process.argv[2]) {
+  config = require(__dirname + '/../lib/utils').parseConnectionString(process.argv[2]);
+}
+//TODO use these environment variables in lib/ code
+//http://www.postgresql.org/docs/8.4/static/libpq-envars.html
+config.host = config.host || process.env['PGHOST'] || process.env['PGHOSTADDR'];
+config.port = config.port || process.env['PGPORT'];
+config.database = config.database || process.env['PGDATABASE'];
+config.user = config.user || process.env['PGUSER'];
+config.password = config.password || process.env['PGPASSWORD'];
 
@@ -3,0 +13,0 @@ for(var i = 0; i < process.argv.length; i++) {

test/integration/client/type-coercion-tests.js

@@ -148,1 +148,16 @@ var helper = require(__dirname + '/test-helper');
 }))
+
+if(!helper.config.binary) {
+  test("postgres date type", function() {
+    var client = helper.client();
+    client.on('error', function(err) {
+      console.log(err);
+      client.end();
+    });
+    client.query("SELECT '2010-10-31'::date", assert.calls(function(err, result){
+      assert.isNull(err);
+      assert.UTCDate(result.rows[0].date, 2010, 9, 31, 0, 0, 0, 0);
+    }));
+    client.on('drain', client.end.bind(client));
+  });
+}

test/unit/client/typed-query-results-tests.js

@@ -118,2 +118,10 @@ var helper = require(__dirname + '/test-helper');
   },{
+    name: 'date',
+    format: 'text',
+    dataTypeID: 1082,
+    actual: '2010-10-31',
+    expected: function(val) {
+      assert.UTCDate(val, 2010, 9, 31, 0, 0, 0, 0);
+    }
+  },{
     name: 'interval time',
@@ -120,0 +128,0 @@ format: 'text',

New alerts

Environment variable access

Supply chain risk

Package accesses environment variables, which may be a sign of credential stuffing or data theft.

Found 6 instances in 1 package

Improved metrics

Total package byte prevSize

220709

increased by0.83%

Number of package files

92

increased by1.1%

Lines of code

5933

increased by0.75%

Number of lines in readme file

173

increased by1.17%

Worsened metrics

Number of low supply chain risk alerts

150

increased by4.17%

Dependency changes

• + Addedgeneric-pool@1.0.12(transitive)

• - Removedgeneric-pool@1.0.9(transitive)

• Updatedgeneric-pool@1.0.12