better-sqlite3 - npm Package Compare versions

Comparing version 1.3.9 to 1.4.0

index.js

 'use strict';
 module.exports = require('./lib/database');
-var Int64 = module.exports.Int64 = require('bindings')('better_sqlite3').Int64;
-
-defineFrozen(Int64, 'MAX_VALUE', new Int64(-1, 0x7fffffff));
-defineFrozen(Int64, 'MIN_VALUE', new Int64(0, -0x80000000));
-defineFrozen(Int64, 'ZERO', new Int64(0, 0));
-defineFrozen(Int64, 'ONE', new Int64(1, 0));
-defineFrozen(Int64, 'NEG_ONE', new Int64(-1, -1));
-
-Int64.prototype.equals = function equals(other) {
-	if (typeof other === 'string') {
-		return this.toString() === other;
-	}
-	if (!(other instanceof Int64)) {
-		return +this == other;
-	}
-	return this.low === other.low && this.high === other.high;
-};
-Int64.prototype.value = function value() {
-	return new Int64(this.low, this.high);
-};
-
-function defineFrozen(obj, key, value) {
-	Object.defineProperty(obj, key, {
-		writable: false,
-		enumerable: true,
-		configurable: false,
-		value: value
-	});
-}
+module.exports.Int64 = require('./lib/int64');

lib/database.js

 'use strict';
+var path = require('path');
 var EventEmitter = require('events').EventEmitter;
 var toDescriptor = require('to-descriptor');
-var CPPDatabase = require('bindings')('better_sqlite3').Database;
+var CPPDatabase = require('bindings')({
+	bindings: 'better_sqlite3.node',
+	module_root: path.resolve(__dirname, '..'),
+}).Database;
 
@@ -6,0 +10,0 @@ function Database(filenameGiven, options) {

package.json

 {
   "name": "better-sqlite3",
-  "version": "1.3.9",
+  "version": "1.4.0",
   "description": "The fastest and simplest library for SQLite3 in Node.js.",
@@ -14,3 +14,3 @@ "homepage": "http://github.com/JoshuaWise/better-sqlite3",
     "bindings": "^1.2.1",
-    "nan": "^2.4.0",
+    "nan": "^2.5.1",
     "to-descriptor": "^1.0.1"
@@ -17,0 +17,0 @@ },

test/20.statement.run.js

@@ -97,11 +97,11 @@ 'use strict';
 		db.prepare("CREATE TABLE entries (a TEXT CHECK(typeof(a)=='text'), b INTEGER CHECK(typeof(b)=='integer' OR typeof(b)=='real'), c REAL CHECK(typeof(c)=='real' OR typeof(c)=='integer'), d BLOB CHECK(typeof(d)=='blob'))").run();
-		db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run('foo', 25, 25, Buffer.alloc(8).fill(0xdd));
-		db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run(['foo', 25, 25, Buffer.alloc(8).fill(0xdd)]);
-		db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run(['foo', 25], [25], Buffer.alloc(8).fill(0xdd));
-		db.prepare('INSERT INTO entries VALUES (@a, @b, @c, @d)').run({a: 'foo', b: 25, c: 25, d: Buffer.alloc(8).fill(0xdd)});
-		db.prepare('INSERT INTO entries VALUES ($a, $b, $c, $d)').run({a: 'foo', b: 25, c: 25, d: Buffer.alloc(8).fill(0xdd)});
-		db.prepare('INSERT INTO entries VALUES (:a, :b, :c, :d)').run({a: 'foo', b: 25, c: 25, d: Buffer.alloc(8).fill(0xdd)});
-		db.prepare('INSERT INTO entries VALUES (?, @a, @a, ?)').run({a: 25}, ['foo'], Buffer.alloc(8).fill(0xdd));
+		db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run('foo', 25, 25, bufferOfSize(8).fill(0xdd));
+		db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run(['foo', 25, 25, bufferOfSize(8).fill(0xdd)]);
+		db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run(['foo', 25], [25], bufferOfSize(8).fill(0xdd));
+		db.prepare('INSERT INTO entries VALUES (@a, @b, @c, @d)').run({a: 'foo', b: 25, c: 25, d: bufferOfSize(8).fill(0xdd)});
+		db.prepare('INSERT INTO entries VALUES ($a, $b, $c, $d)').run({a: 'foo', b: 25, c: 25, d: bufferOfSize(8).fill(0xdd)});
+		db.prepare('INSERT INTO entries VALUES (:a, :b, :c, :d)').run({a: 'foo', b: 25, c: 25, d: bufferOfSize(8).fill(0xdd)});
+		db.prepare('INSERT INTO entries VALUES (?, @a, @a, ?)').run({a: 25}, ['foo'], bufferOfSize(8).fill(0xdd));
 		expect(function () {
-			db.prepare('INSERT INTO entries VALUES (?, @a, @a, ?)').run({a: 25}, ['foo'], Buffer.alloc(8).fill(0xdd), Buffer.alloc(8).fill(0xdd));
+			db.prepare('INSERT INTO entries VALUES (?, @a, @a, ?)').run({a: 25}, ['foo'], bufferOfSize(8).fill(0xdd), bufferOfSize(8).fill(0xdd));
 		}).to.throw(Error);
@@ -112,16 +112,16 @@ expect(function () {
 		expect(function () {
-			db.prepare('INSERT INTO entries VALUES (?, @a, @a, ?)').run({a: 25, c: 25}, ['foo'], Buffer.alloc(8).fill(0xdd));
+			db.prepare('INSERT INTO entries VALUES (?, @a, @a, ?)').run({a: 25, c: 25}, ['foo'], bufferOfSize(8).fill(0xdd));
 		}).to.throw(Error);
 		expect(function () {
-			db.prepare('INSERT INTO entries VALUES (?, @a, @a, ?)').run({}, ['foo'], Buffer.alloc(8).fill(0xdd));
+			db.prepare('INSERT INTO entries VALUES (?, @a, @a, ?)').run({}, ['foo'], bufferOfSize(8).fill(0xdd));
 		}).to.throw(Error);
 		expect(function () {
-			db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run(25, 'foo', 25, Buffer.alloc(8).fill(0xdd));
+			db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run(25, 'foo', 25, bufferOfSize(8).fill(0xdd));
 		}).to.throw(Error);
 		expect(function () {
-			db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run('foo', 25, 25, Buffer.alloc(8).fill(0xdd), {foo: 'foo'});
+			db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run('foo', 25, 25, bufferOfSize(8).fill(0xdd), {foo: 'foo'});
 		}).to.throw(Error);
-		db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run('foo', 25, 25, Buffer.alloc(8).fill(0xdd), {});
+		db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run('foo', 25, 25, bufferOfSize(8).fill(0xdd), {});
 		expect(function () {
-			db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run('foo', 25, 25, {4: Buffer.alloc(8).fill(0xdd)});
+			db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run('foo', 25, 25, {4: bufferOfSize(8).fill(0xdd)});
 		}).to.throw(Error);
@@ -132,9 +132,9 @@ expect(function () {
 		expect(function () {
-			db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run({length: 4, 0: 'foo', 1: 25, 2: 25, 3: Buffer.alloc(8).fill(0xdd)});
+			db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run({length: 4, 0: 'foo', 1: 25, 2: 25, 3: bufferOfSize(8).fill(0xdd)});
 		}).to.throw(Error);
 		expect(function () {
-			db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run('foo', 25, new Number(25), Buffer.alloc(8).fill(0xdd));
+			db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run('foo', 25, new Number(25), bufferOfSize(8).fill(0xdd));
 		}).to.throw(Error);
 		expect(function () {
-			db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run('foo', {low: 25, high: 25}, 25, Buffer.alloc(8).fill(0xdd));
+			db.prepare('INSERT INTO entries VALUES (?, ?, ?, ?)').run('foo', {low: 25, high: 25}, 25, bufferOfSize(8).fill(0xdd));
 		}).to.throw(Error);
@@ -145,3 +145,3 @@ function Foo() {
 			this.c = 25;
-			this.d = Buffer.alloc(8).fill(0xdd);
+			this.d = bufferOfSize(8).fill(0xdd);
 		}
@@ -156,3 +156,3 @@ expect(function () {
 		while (row = db.prepare('SELECT * FROM entries WHERE rowid=' + ++i).get()) {
-			expect(row).to.deep.equal({a: 'foo', b: 25, c: 25, d: Buffer.alloc(8).fill(0xdd)});
+			expect(row).to.deep.equal({a: 'foo', b: 25, c: 25, d: bufferOfSize(8).fill(0xdd)});
 		}
@@ -162,1 +162,5 @@ expect(i).to.equal(9);
 });
+
+function bufferOfSize(size) {
+	return Buffer.alloc ? Buffer.alloc(+size) : new Buffer(+size);
+}

test/21.statement.get.js

@@ -32,10 +32,10 @@ 'use strict';
 		expect(stmt.returnsData).to.be.true;
-		expect(stmt.get()).to.deep.equal({a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd), e: null});
+		expect(stmt.get()).to.deep.equal({a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd), e: null});
 		
 		stmt = db.prepare("SELECT * FROM entries WHERE b > 5");
-		expect(stmt.get()).to.deep.equal({a: 'foo', b: 6, c: 3.14, d: Buffer.alloc(4).fill(0xdd), e: null});
+		expect(stmt.get()).to.deep.equal({a: 'foo', b: 6, c: 3.14, d: bufferOfSize(4).fill(0xdd), e: null});
 	});
 	it('should obey the current pluck setting', function () {
 		var stmt = db.prepare("SELECT * FROM entries");
-		var row = {a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd), e: null};
+		var row = {a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd), e: null};
 		expect(stmt.get()).to.deep.equal(row);
@@ -55,22 +55,22 @@ expect(stmt.pluck(true).get()).to.equal('foo');
 	it('should accept bind parameters', function () {
-		var row = {a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd), e: null};
+		var row = {a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd), e: null};
 		var SQL1 = 'SELECT * FROM entries WHERE a=? AND b=? AND c=? AND d=? AND e IS ?';
 		var SQL2 = 'SELECT * FROM entries WHERE a=@a AND b=@b AND c=@c AND d=@d AND e IS @e';
-		var result = db.prepare(SQL1).get('foo', 1, 3.14, Buffer.alloc(4).fill(0xdd), null);
+		var result = db.prepare(SQL1).get('foo', 1, 3.14, bufferOfSize(4).fill(0xdd), null);
 		expect(result).to.deep.equal(row);
 		
-		result = db.prepare(SQL1).get(['foo', 1, 3.14, Buffer.alloc(4).fill(0xdd), null]);
+		result = db.prepare(SQL1).get(['foo', 1, 3.14, bufferOfSize(4).fill(0xdd), null]);
 		expect(result).to.deep.equal(row);
 		
-		result = db.prepare(SQL1).get(['foo', 1], [3.14], Buffer.alloc(4).fill(0xdd), [,]);
+		result = db.prepare(SQL1).get(['foo', 1], [3.14], bufferOfSize(4).fill(0xdd), [,]);
 		expect(result).to.deep.equal(row);
 		
-		result = db.prepare(SQL2).get({a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd), e: undefined});
+		result = db.prepare(SQL2).get({a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd), e: undefined});
 		expect(result).to.deep.equal(row);
 		
-		result = db.prepare(SQL2).get({a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xaa), e: undefined});
+		result = db.prepare(SQL2).get({a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xaa), e: undefined});
 		expect(result).to.be.undefined;
 		
 		expect(function () {
-			db.prepare(SQL2).get({a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd)});
+			db.prepare(SQL2).get({a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd)});
 		}).to.throw(Error);
@@ -87,1 +87,5 @@
 });
+
+function bufferOfSize(size) {
+	return Buffer.alloc ? Buffer.alloc(+size) : new Buffer(+size);
+}

test/22.statement.all.js

@@ -29,3 +29,3 @@ 'use strict';
 		db.prepare("INSERT INTO entries WITH RECURSIVE temp(a, b, c, d, e) AS (SELECT 'foo', 1, 3.14, x'dddddddd', NULL UNION ALL SELECT a, b + 1, c, d, e FROM temp LIMIT 10) SELECT * FROM temp").run();
-		var row = {a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd), e: null};
+		var row = {a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd), e: null};
 		
@@ -64,22 +64,22 @@ var stmt = db.prepare("SELECT * FROM entries");
 	it('should accept bind parameters', function () {
-		var rows = [{a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd), e: null}];
+		var rows = [{a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd), e: null}];
 		var SQL1 = 'SELECT * FROM entries WHERE a=? AND b=? AND c=? AND d=? AND e IS ?';
 		var SQL2 = 'SELECT * FROM entries WHERE a=@a AND b=@b AND c=@c AND d=@d AND e IS @e';
-		var result = db.prepare(SQL1).all('foo', 1, 3.14, Buffer.alloc(4).fill(0xdd), null);
+		var result = db.prepare(SQL1).all('foo', 1, 3.14, bufferOfSize(4).fill(0xdd), null);
 		expect(result).to.deep.equal(rows);
 		
-		result = db.prepare(SQL1).all(['foo', 1, 3.14, Buffer.alloc(4).fill(0xdd), null]);
+		result = db.prepare(SQL1).all(['foo', 1, 3.14, bufferOfSize(4).fill(0xdd), null]);
 		expect(result).to.deep.equal(rows);
 		
-		result = db.prepare(SQL1).all(['foo', 1], [3.14], Buffer.alloc(4).fill(0xdd), [,]);
+		result = db.prepare(SQL1).all(['foo', 1], [3.14], bufferOfSize(4).fill(0xdd), [,]);
 		expect(result).to.deep.equal(rows);
 		
-		result = db.prepare(SQL2).all({a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd), e: undefined});
+		result = db.prepare(SQL2).all({a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd), e: undefined});
 		expect(result).to.deep.equal(rows);
 		
-		result = db.prepare(SQL2).all({a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xaa), e: undefined});
+		result = db.prepare(SQL2).all({a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xaa), e: undefined});
 		expect(result).to.deep.equal([]);
 		
 		expect(function () {
-			db.prepare(SQL2).all({a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd)});
+			db.prepare(SQL2).all({a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd)});
 		}).to.throw(Error);
@@ -96,1 +96,5 @@
 });
+
+function bufferOfSize(size) {
+	return Buffer.alloc ? Buffer.alloc(+size) : new Buffer(+size);
+}

test/23.statement.each.js

@@ -37,3 +37,3 @@ 'use strict';
 	it('should invoke the callback for each matching row', function () {
-		var row = {a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd), e: null};
+		var row = {a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd), e: null};
 		
@@ -60,3 +60,3 @@ var count = 0;
 	it('should obey the current pluck setting', function () {
-		var row = {a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd), e: null};
+		var row = {a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd), e: null};
 		var stmt = db.prepare("SELECT * FROM entries");
@@ -158,12 +158,12 @@ shouldHave(row);
 	it('should accept bind parameters', function () {
-		var row = {a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd), e: null};
+		var row = {a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd), e: null};
 		var SQL1 = 'SELECT * FROM entries WHERE a=? AND b=? AND c=? AND d=? AND e IS ?';
 		var SQL2 = 'SELECT * FROM entries WHERE a=@a AND b=@b AND c=@c AND d=@d AND e IS @e';
 		
-		shouldHave(SQL1, row, ['foo', 1, 3.14, Buffer.alloc(4).fill(0xdd), null])
-		shouldHave(SQL1, row, [['foo', 1, 3.14, Buffer.alloc(4).fill(0xdd), null]])
-		shouldHave(SQL1, row, [['foo', 1], [3.14], Buffer.alloc(4).fill(0xdd), [,]])
-		shouldHave(SQL2, row, [{a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd), e: undefined}])
+		shouldHave(SQL1, row, ['foo', 1, 3.14, bufferOfSize(4).fill(0xdd), null])
+		shouldHave(SQL1, row, [['foo', 1, 3.14, bufferOfSize(4).fill(0xdd), null]])
+		shouldHave(SQL1, row, [['foo', 1], [3.14], bufferOfSize(4).fill(0xdd), [,]])
+		shouldHave(SQL2, row, [{a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd), e: undefined}])
 		
-		db.prepare(SQL2).each({a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xaa), e: undefined}, function () {
+		db.prepare(SQL2).each({a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xaa), e: undefined}, function () {
 			throw new Error('This callback should not have been invoked.');
@@ -173,3 +173,3 @@ });
 		expect(function () {
-			db.prepare(SQL2).each({a: 'foo', b: 1, c: 3.14, d: Buffer.alloc(4).fill(0xdd)}, function () {});
+			db.prepare(SQL2).each({a: 'foo', b: 1, c: 3.14, d: bufferOfSize(4).fill(0xdd)}, function () {});
 		}).to.throw(Error);
@@ -204,1 +204,5 @@
 });
+
+function bufferOfSize(size) {
+	return Buffer.alloc ? Buffer.alloc(+size) : new Buffer(+size);
+}

test/24.statement.bind.js

@@ -15,3 +15,3 @@ 'use strict';
 		var stmt = db.prepare('INSERT INTO entries VALUES (?, ?, ?)');
-		var buffer = Buffer.alloc(4).fill(0xdd);
+		var buffer = bufferOfSize(4).fill(0xdd);
 		stmt.bind('foobar', 25, buffer)
@@ -29,3 +29,3 @@ stmt.run();
 		var stmt = db.prepare('INSERT INTO entries VALUES (?, ?, ?)');
-		var buffer = Buffer.alloc(4).fill(0xdd);
+		var buffer = bufferOfSize(4).fill(0xdd);
 		stmt.bind('foobar', 25, buffer)
@@ -111,1 +111,5 @@ expect(function () {stmt.run(null);}).to.throw(TypeError);
 });
+
+function bufferOfSize(size) {
+	return Buffer.alloc ? Buffer.alloc(+size) : new Buffer(+size);
+}

test/30.transaction.run.js

@@ -92,25 +92,25 @@ 'use strict';
 		db.transaction(['INSERT INTO entries VALUES (?, ?, ?, ?)', 'INSERT INTO entries VALUES (?, ?, ?, ?)'])
-			.run('foo', 25, 25, Buffer.alloc(8).fill(0xdd), 'foo', 25, 25, Buffer.alloc(8).fill(0xdd));
+			.run('foo', 25, 25, bufferOfSize(8).fill(0xdd), 'foo', 25, 25, bufferOfSize(8).fill(0xdd));
 			
 		db.transaction(['INSERT INTO entries VALUES (?, ?, ?, ?)', 'INSERT INTO entries VALUES (?, ?, ?, ?)'])
-			.run(['foo', 25, 25, Buffer.alloc(8).fill(0xdd), 'foo', 25, 25, Buffer.alloc(8).fill(0xdd)]);
+			.run(['foo', 25, 25, bufferOfSize(8).fill(0xdd), 'foo', 25, 25, bufferOfSize(8).fill(0xdd)]);
 			
 		db.transaction(['INSERT INTO entries VALUES (?, ?, ?, ?)', 'INSERT INTO entries VALUES (?, ?, ?, ?)'])
-			.run(['foo', 25], [25], Buffer.alloc(8).fill(0xdd), ['foo', 25, 25, Buffer.alloc(8).fill(0xdd)]);
+			.run(['foo', 25], [25], bufferOfSize(8).fill(0xdd), ['foo', 25, 25, bufferOfSize(8).fill(0xdd)]);
 			
 		db.transaction(['INSERT INTO entries VALUES (@a, @b, @c, @d)', 'INSERT INTO entries VALUES (@a, @b, @c, @d)'])
-			.run({a: 'foo', b: 25, c: 25, d: Buffer.alloc(8).fill(0xdd)});
+			.run({a: 'foo', b: 25, c: 25, d: bufferOfSize(8).fill(0xdd)});
 			
 		db.transaction(['INSERT INTO entries VALUES ($a, $b, $c, $d)', 'INSERT INTO entries VALUES ($a, $b, $c, $d)'])
-			.run({a: 'foo', b: 25, c: 25, d: Buffer.alloc(8).fill(0xdd)});
+			.run({a: 'foo', b: 25, c: 25, d: bufferOfSize(8).fill(0xdd)});
 			
 		db.transaction(['INSERT INTO entries VALUES (:a, :b, :c, :d)', 'INSERT INTO entries VALUES (:a, :b, :c, :d)'])
-			.run({a: 'foo', b: 25, c: 25, d: Buffer.alloc(8).fill(0xdd)});
+			.run({a: 'foo', b: 25, c: 25, d: bufferOfSize(8).fill(0xdd)});
 			
 		db.transaction(['INSERT INTO entries VALUES (?, @a, @a, ?)', 'INSERT INTO entries VALUES (?, @a, @a, ?)'])
-			.run({a: 25}, ['foo'], [Buffer.alloc(8).fill(0xdd), 'foo'], Buffer.alloc(8).fill(0xdd));
+			.run({a: 25}, ['foo'], [bufferOfSize(8).fill(0xdd), 'foo'], bufferOfSize(8).fill(0xdd));
 		
 		expect(function () {
 			db.transaction(['INSERT INTO entries VALUES (?, @a, @a, ?)', 'INSERT INTO entries VALUES (?, @a, @a, ?)'])
-				.run({a: 25}, ['foo'], Buffer.alloc(8).fill(0xdd), 'foo', Buffer.alloc(8).fill(0xdd), Buffer.alloc(8).fill(0xdd));
+				.run({a: 25}, ['foo'], bufferOfSize(8).fill(0xdd), 'foo', bufferOfSize(8).fill(0xdd), bufferOfSize(8).fill(0xdd));
 		}).to.throw(Error);
@@ -120,3 +120,3 @@
 			db.transaction(['INSERT INTO entries VALUES (?, @a, @a, ?)', 'INSERT INTO entries VALUES (?, @a, @a, ?)'])
-				.run({a: 25}, ['foo'], Buffer.alloc(8).fill(0xdd), 'foo');
+				.run({a: 25}, ['foo'], bufferOfSize(8).fill(0xdd), 'foo');
 		}).to.throw(Error);
@@ -126,3 +126,3 @@
 			db.transaction(['INSERT INTO entries VALUES (?, @a, @a, ?)', 'INSERT INTO entries VALUES (?, @a, @a, ?)'])
-				.run({a: 25, c: 25}, ['foo'], Buffer.alloc(8).fill(0xdd), ['foo'], Buffer.alloc(8).fill(0xdd));
+				.run({a: 25, c: 25}, ['foo'], bufferOfSize(8).fill(0xdd), ['foo'], bufferOfSize(8).fill(0xdd));
 		}).to.throw(Error);
@@ -132,3 +132,3 @@
 			db.transaction(['INSERT INTO entries VALUES (?, @a, @a, ?)'])
-				.run({}, ['foo'], Buffer.alloc(8).fill(0xdd), ['foo'], Buffer.alloc(8).fill(0xdd));
+				.run({}, ['foo'], bufferOfSize(8).fill(0xdd), ['foo'], bufferOfSize(8).fill(0xdd));
 		}).to.throw(Error);
@@ -138,3 +138,3 @@
 			db.transaction(['INSERT INTO entries VALUES (?, ?, ?, ?)', 'INSERT INTO entries VALUES (?, ?, ?, ?)'])
-				.run(25, 'foo', 25, Buffer.alloc(8).fill(0xdd), 'foo', 25, 25, Buffer.alloc(8).fill(0xdd));
+				.run(25, 'foo', 25, bufferOfSize(8).fill(0xdd), 'foo', 25, 25, bufferOfSize(8).fill(0xdd));
 		}).to.throw(Error);
@@ -144,11 +144,11 @@
 			db.transaction(['INSERT INTO entries VALUES (?, ?, ?, ?)', 'INSERT INTO entries VALUES (?, ?, ?, ?)'])
-				.run('foo', 25, 25, Buffer.alloc(8).fill(0xdd), 'foo', 25, 25, Buffer.alloc(8).fill(0xdd), {foo: 'foo'});
+				.run('foo', 25, 25, bufferOfSize(8).fill(0xdd), 'foo', 25, 25, bufferOfSize(8).fill(0xdd), {foo: 'foo'});
 		}).to.throw(Error);
 		
 		db.transaction(['INSERT INTO entries VALUES (?, ?, ?, ?)', 'INSERT INTO entries VALUES (?, ?, ?, ?)'])
-			.run('foo', 25, 25, Buffer.alloc(8).fill(0xdd), 'foo', 25, 25, Buffer.alloc(8).fill(0xdd), {});
+			.run('foo', 25, 25, bufferOfSize(8).fill(0xdd), 'foo', 25, 25, bufferOfSize(8).fill(0xdd), {});
 		
 		expect(function () {
 			db.transaction(['INSERT INTO entries VALUES (?, ?, ?, ?)'])
-				.run('foo', 25, 25, {4: Buffer.alloc(8).fill(0xdd)});
+				.run('foo', 25, 25, {4: bufferOfSize(8).fill(0xdd)});
 		}).to.throw(Error);
@@ -163,3 +163,3 @@
 			db.transaction(['INSERT INTO entries VALUES (?, ?, ?, ?)'])
-				.run({length: 4, 0: 'foo', 1: 25, 2: 25, 3: Buffer.alloc(8).fill(0xdd)});
+				.run({length: 4, 0: 'foo', 1: 25, 2: 25, 3: bufferOfSize(8).fill(0xdd)});
 		}).to.throw(Error);
@@ -169,3 +169,3 @@
 			db.transaction(['INSERT INTO entries VALUES (?, ?, ?, ?)'])
-				.run('foo', 25, new Number(25), Buffer.alloc(8).fill(0xdd));
+				.run('foo', 25, new Number(25), bufferOfSize(8).fill(0xdd));
 		}).to.throw(Error);
@@ -175,3 +175,3 @@
 			db.transaction(['INSERT INTO entries VALUES (?, ?, ?, ?)'])
-				.run('foo', {low: 25, high: 25}, 25, Buffer.alloc(8).fill(0xdd));
+				.run('foo', {low: 25, high: 25}, 25, bufferOfSize(8).fill(0xdd));
 		}).to.throw(Error);
@@ -181,3 +181,3 @@
 			db.transaction(['INSERT INTO entries VALUES (?, ?, ?, ?)', "INSERT INTO entries VALUES ('foo', 25, 25, x'dddddddd')", 'INSERT INTO entries VALUES (?, ?, ?, ?)'])
-				.run('foo', 25, 25, Buffer.alloc(8).fill(0xdd));
+				.run('foo', 25, 25, bufferOfSize(8).fill(0xdd));
 		}).to.throw(Error);
@@ -189,3 +189,3 @@
 			this.c = 25;
-			this.d = Buffer.alloc(8).fill(0xdd);
+			this.d = bufferOfSize(8).fill(0xdd);
 		}
@@ -199,3 +199,3 @@ expect(function () {
 		while (row = db.prepare('SELECT * FROM entries WHERE rowid=' + ++i).get()) {
-			expect(row).to.deep.equal({a: 'foo', b: 25, c: 25, d: Buffer.alloc(8).fill(0xdd)});
+			expect(row).to.deep.equal({a: 'foo', b: 25, c: 25, d: bufferOfSize(8).fill(0xdd)});
 		}
@@ -205,1 +205,5 @@ expect(i).to.equal(17);
 });
+
+function bufferOfSize(size) {
+	return Buffer.alloc ? Buffer.alloc(+size) : new Buffer(+size);
+}

test/31.transaction.bind.js

@@ -15,3 +15,3 @@ 'use strict';
 		var trans = db.transaction(['INSERT INTO entries VALUES (?, ?, ?)']);
-		var buffer = Buffer.alloc(4).fill(0xdd);
+		var buffer = bufferOfSize(4).fill(0xdd);
 		trans.bind('foobar', 25, buffer)
@@ -29,3 +29,3 @@ trans.run();
 		var trans = db.transaction(['INSERT INTO entries VALUES (?, ?, ?)']);
-		var buffer = Buffer.alloc(4).fill(0xdd);
+		var buffer = bufferOfSize(4).fill(0xdd);
 		trans.bind('foobar', 25, buffer)
@@ -96,1 +96,5 @@ expect(function () {trans.run(null);}).to.throw(TypeError);
 });
+
+function bufferOfSize(size) {
+	return Buffer.alloc ? Buffer.alloc(+size) : new Buffer(+size);
+}

test/50.int64.js

@@ -75,3 +75,3 @@ var expect = require('chai').expect;
 		expect(int.equals(new Int64(123, 123))).to.be.true;
-		expect(int.equals({low: 123, high: 123})).to.be.false;
+		expect(int.equals({low: 123, high: 123})).to.be.true;
 		expect(int.equals(528280977531)).to.be.true;
@@ -78,0 +78,0 @@ expect(int.equals('528280977531')).to.be.true;

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

2687592

increased by0.35%

Number of package files

155

increased by1.31%

Lines of code

2555

increased by1.43%

Dependency changes

• Updatednan@^2.5.1