sql - npm Package Compare versions

Comparing version 0.63.0 to 0.63.1

lib/dialect/postgres.js

		@@ -665,3 +665,3 @@ 'use strict';
		// create another query builder of the current class to build the subquery
		var subQuery = new this._myClass();
		var subQuery = new this._myClass(this.config);

		@@ -668,0 +668,0 @@ // let the subquery modify this instance's params array

package.json

		@@ -5,3 +5,3 @@ {
		"description": "sql builder",
		"version": "0.63.0",
		"version": "0.63.1",
		"homepage": "https://github.com/brianc/node-sql",
		@@ -8,0 +8,0 @@ "license": "MIT",

test/dialects/subquery-tests.js

		@@ -88,3 +88,33 @@ 'use strict';

		// Subquery with a date
		Harness.test({
		query: Sql.select('*').from(post.subQuery().where(post.content.equals(new Date('Sat, 01 Jan 2000 00:00:00 GMT')))),
		pg: {
		text : 'SELECT * FROM (SELECT * FROM "post" WHERE ("post"."content" = $1))',
		string: 'SELECT * FROM (SELECT * FROM "post" WHERE ("post"."content" = \'2000-01-01T00:00:00.000Z\'))'
		},
		sqlite: {
		text : 'SELECT * FROM (SELECT * FROM "post" WHERE ("post"."content" = $1))',
		string: 'SELECT * FROM (SELECT * FROM "post" WHERE ("post"."content" = 946684800000))',
		config: {
		dateTimeMillis: true
		}
		},
		mysql: {
		text : 'SELECT * FROM (SELECT * FROM `post` WHERE (`post`.`content` = ?))',
		string: 'SELECT * FROM (SELECT * FROM `post` WHERE (`post`.`content` = \'2000-01-01T00:00:00.000Z\'))'
		},
		mssql: {
		text : 'SELECT * FROM (SELECT * FROM [post] WHERE ([post].[content] = @1))',
		string: 'SELECT * FROM (SELECT * FROM [post] WHERE ([post].[content] = \'2000-01-01T00:00:00.000Z\'))'
		},
		oracle: {
		text : 'SELECT * FROM (SELECT * FROM "post" WHERE ("post"."content" = :1))',
		string: 'SELECT * FROM (SELECT * FROM "post" WHERE ("post"."content" = \'2000-01-01T00:00:00.000Z\'))'
		},
		params: [new Date('Sat, 01 Jan 2000 00:00:00 GMT')]
		});


		Harness.test({
		query: Sql.select('*').from(customer.subQuery('T1')).from(user.subQuery('T2')),
		@@ -91,0 +121,0 @@ pg: {

New alerts