sql-query - npm Package Compare versions

Comparing version 0.1.26 to 0.1.27

Changelog.md

@@ -0,1 +1,5 @@
+### v0.1.27 - 27 Jun 2018
+
+- Handle objects & symbols causing crash in driver 'escapeVal' (#54)
+
 ### v0.1.26 - 16 May 2015
@@ -2,0 +6,0 @@

lib/Dialects/mssql.js

@@ -33,3 +33,3 @@ var util    = require("util");
 exports.escapeVal = function (val, timeZone) {
-	if (val === undefined || val === null) {
+	if (val === undefined || val === null || typeof val === "symbol") {
 		return 'NULL';
@@ -64,2 +64,6 @@ }
 			return val(exports);
+		case "string":
+			break;
+		default:
+			val = JSON.stringify(val);
 	}
@@ -66,0 +70,0 @@

lib/Dialects/mysql.js

@@ -33,3 +33,3 @@ var util    = require("util");
 exports.escapeVal = function (val, timeZone) {
-	if (val === undefined || val === null) {
+	if (val === undefined || val === null || typeof val === "symbol") {
 		return 'NULL';
@@ -36,0 +36,0 @@ }

lib/Dialects/postgresql.js

@@ -33,3 +33,3 @@ var util    = require("util");
 exports.escapeVal = function (val, timeZone) {
-	if (val === undefined || val === null) {
+	if (val === undefined || val === null || typeof val === "symbol") {
 		return 'NULL';
@@ -64,2 +64,6 @@ }
 			return val(exports);
+		case "string":
+			break;
+		default:
+			val = JSON.stringify(val);
 	}
@@ -66,0 +70,0 @@ // No need to escape backslashes with default PostgreSQL 9.1+ config.

lib/Dialects/sqlite.js

@@ -21,3 +21,3 @@ var util    = require("util");
 exports.escapeVal = function (val, timeZone) {
-	if (val === undefined || val === null) {
+	if (val === undefined || val === null || typeof val === "symbol") {
 		return 'NULL';
@@ -52,2 +52,6 @@ }
 			return val(exports);
+		case "string":
+			break;
+		default:
+			val = JSON.stringify(val);
 	}
@@ -54,0 +58,0 @@

lib/Helpers.js

@@ -38,3 +38,3 @@
 
-	if (opts.dialect == 'mysql') {
+	if (opts.dialect == 'mysql' || timeZone == 'local') {
 		return year + '-' + month + '-' + day + ' ' + hour + ':' + minute + ':' + second + '.' + milli;
@@ -41,0 +41,0 @@ } else {

package.json

@@ -8,4 +8,4 @@ {
 		"query"
-  	],
-	"version": "0.1.26",
+	],
+	"version": "0.1.27",
 	"license": "MIT",
@@ -16,4 +16,9 @@ "repository": {
 	"contributors": [
-		{ "name" : "Benjamin Pannell", "email" : "[e-mail]" },
-		{ "name" : "Arek W" }
+		{
+			"name": "Benjamin Pannell",
+			"email": "[e-mail]"
+		},
+		{
+			"name": "Arek W"
+		}
 	],
@@ -29,5 +34,5 @@ "scripts": {
 	"devDependencies": {
-		"utest": "0.0.6",
-		"urun": "0.0.6"
+		"utest": "0.0.8",
+		"urun": "0.0.8"
 	}
 }

Readme.md

@@ -1,2 +0,2 @@
-## NodeJS SQL query builder
+# NodeJS SQL query builder
 
@@ -8,3 +8,3 @@ [![Build Status](https://secure.travis-ci.org/dresende/node-sql-query.png?branch=master)](http://travis-ci.org/dresende/node-sql-query)
 ```sh
-npm install sql-query
+npm install sql-query --save
 ```
@@ -21,2 +21,738 @@
 
-This module is used by [ORM](http://dresende.github.com/node-orm2) to build SQL queries in the different supported dialects. Sorry there is no API documentation but there are a couple of tests you can read and find out how to use it if you want.
+This module is used by [ORM](http://dresende.github.com/node-orm2) to build SQL queries in the different supported dialects.
+Sorry the API documentation is not complete. There are tests in ./test/integration that you can read.
+
+
+# Usage
+```js
+var sql = require('sql-query'),
+  sqlQuery = sql.Query(); //for dialect: sql.Query('postgresql')
+```
+
+## Create
+```js
+var sqlCreate = sqlQuery.create();
+
+sqlCreate
+  .table('table1')
+  .build()
+
+"CREATE TABLE 'table1'()"
+
+
+sqlCreate
+  .table('table1')
+  .field('id','id')
+  .build()
+
+"CREATE TABLE 'table1'('id' INTEGER PRIMARY KEY AUTO_INCREMENT)"
+
+
+sqlCreate
+  .table('table1')
+  .fields({id: 'id', a_text: 'text'})
+  .build()
+
+"CREATE TABLE 'table1'('id' INTEGER PRIMARY KEY AUTO_INCREMENT,'a_text' TEXT)"
+
+
+sqlCreate
+  .table('table1')
+  .fields({id: 'id', a_num: 'int'})
+  .build()
+
+"CREATE TABLE 'table1'('id' INTEGER PRIMARY KEY AUTO_INCREMENT,'a_num' INTEGER)"
+
+
+sqlCreate
+  .table('table1')
+  .fields({id: 'id', a_num: 'float'})
+  .build()
+
+"CREATE TABLE 'table1'('id' INTEGER PRIMARY KEY AUTO_INCREMENT,'a_num' FLOAT(12,2))"
+
+
+sqlCreate
+  .table('table1')
+  .fields({id: 'id', a_bool: 'bool'})
+  .build()
+
+"CREATE TABLE 'table1'('id' INTEGER PRIMARY KEY AUTO_INCREMENT,'a_bool' TINYINT(1))"
+```
+
+## Select
+```js
+var sqlSelect = sqlQuery.select();
+
+sqlSelect
+  .from('table1')
+  .build();
+
+"SELECT * FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .select('id', 'name')
+  .build();
+
+"SELECT `id`, `name` FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .select('id', 'name')
+  .as('label')
+  .build();
+
+"SELECT `id`, `name` AS `label` FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .select('id', 'name')
+  .select('title')
+  .as('label')
+  .build();
+
+"SELECT `id`, `name`, `title` AS `label` FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .select('id', 'name')
+  .as('label')
+  .select('title')
+  .build();
+
+"SELECT `id`, `name` AS `label`, `title` FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .select([ 'id', 'name' ])
+  .build();
+
+"SELECT `id`, `name` FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .select()
+  .build();
+
+"SELECT * FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .select(['abc','def', { a: 'ghi', sql: 'SOMEFUNC(ghi)' }])
+  .build();
+
+"SELECT `abc`, `def`, (SOMEFUNC(ghi)) AS `ghi` FROM `table1`"
+
+
+sqlSelect
+  .calculateFoundRows()
+  .from('table1')
+  .build();
+
+"SELECT SQL_CALC_FOUND_ROWS * FROM `table1`"
+
+
+sqlSelect
+  .calculateFoundRows()
+  .from('table1')
+  .select('id')
+  .build();
+
+"SELECT SQL_CALC_FOUND_ROWS `id` FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .select('id1', 'name')
+  .from('table2', 'id2', 'id1')
+  .select('id2')
+  .build();
+
+"SELECT `t1`.`id1`, `t1`.`name`, `t2`.`id2` FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`"
+
+
+sqlSelect
+  .from('table1')
+  .select('id1')
+  .from('table2', 'id2', 'id1', { joinType: 'left inner' })
+  .select('id2')
+  .build();
+
+"SELECT `t1`.`id1`, `t2`.`id2` FROM `table1` `t1` LEFT INNER JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`"
+
+
+sqlSelect
+  .from('table1')
+  .select('id1', 'name')
+  .from('table2', 'id2', 'table1', 'id1')
+  .select('id2')
+  .build();
+
+"SELECT `t1`.`id1`, `t1`.`name`, `t2`.`id2` FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`"
+
+
+sqlSelect
+  .from('table1')
+  .from('table2', 'id2', 'table1', 'id1')
+  .count()
+  .build();
+
+"SELECT COUNT(*) FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`"
+
+
+sqlSelect
+  .from('table1')
+  .from('table2', 'id2', 'table1', 'id1')
+  .count(null, 'c')
+  .build();
+
+"SELECT COUNT(*) AS `c` FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`"
+
+
+sqlSelect
+  .from('table1')
+  .from('table2', 'id2', 'table1', 'id1')
+  .count('id')
+  .build();
+
+"SELECT COUNT(`t2`.`id`) FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`"
+
+
+sqlSelect
+  .from('table1')
+  .count('id')
+  .from('table2', 'id2', 'table1', 'id1')
+  .count('id')
+  .build();
+
+"SELECT COUNT(`t1`.`id`), COUNT(`t2`.`id`) FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`"
+
+
+sqlSelect
+  .from('table1')
+  .from('table2', 'id2', 'table1', 'id1')
+  .count('id')
+  .count('col')
+  .build();
+
+"SELECT COUNT(`t2`.`id`), COUNT(`t2`.`col`) FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`"
+
+
+sqlSelect
+  .from('table1')
+  .from('table2', 'id2', 'table1', 'id1')
+  .fun('AVG', 'col')
+  .build();
+
+"SELECT AVG(`t2`.`col`) FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`"
+
+
+sqlSelect
+  .from('table1')
+  .from('table2',['id2a', 'id2b'], 'table1', ['id1a', 'id1b'])
+  .count('id')
+  .build();
+
+"SELECT COUNT(`t2`.`id`) FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2a` = `t1`.`id1a` AND `t2`.`id2b` = `t1`.`id1b`"
+```
+
+## Where
+```js
+var sqlSelect = sqlQuery.select();
+
+sqlSelect
+  .from('table1')
+  .where()
+  .build();
+
+"SELECT * FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .where(null)
+  .build();
+
+"SELECT * FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: 1 })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` = 1"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: 0 })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` = 0"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: null })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` IS NULL"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: sql.eq(null) })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` IS NULL"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: sql.ne(null) })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` IS NOT NULL"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: undefined })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` IS NULL"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: false })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` = false"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: "" })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` = ''"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: true })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` = true"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: 'a' })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` = 'a'"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: 'a\'' })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` = 'a\\''"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: [ 1, 2, 3 ] })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` IN (1, 2, 3)"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: [] })
+  .build();
+
+"SELECT * FROM `table1` WHERE FALSE"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col1: 1, col2: 2 })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col1` = 1 AND `col2` = 2"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col1: 1 }, { col2: 2 })
+  .build();
+
+"SELECT * FROM `table1` WHERE (`col1` = 1) AND (`col2` = 2)"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: 1 }).where({ col: 2 })
+  .build();
+
+"SELECT * FROM `table1` WHERE (`col` = 1) AND (`col` = 2)"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col1: 1, col2: 2 }).where({ col3: 3 })
+  .build();
+
+"SELECT * FROM `table1` WHERE (`col1` = 1 AND `col2` = 2) AND (`col3` = 3)"
+
+
+sqlSelect
+  .from('table1')
+  .from('table2', 'id', 'id')
+  .where('table1', { col: 1 }, 'table2', { col: 2 })
+  .build();
+
+"SELECT * FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id` = `t1`.`id` WHERE (`t1`.`col` = 1) AND (`t2`.`col` = 2)"
+
+
+sqlSelect
+  .from('table1')
+  .from('table2', 'id', 'id')
+  .where('table1', { col: 1 }, { col: 2 })
+  .build();
+
+"SELECT * FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id` = `t1`.`id` WHERE (`t1`.`col` = 1) AND (`col` = 2)"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: sql.gt(1) })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` > 1"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: sql.gte(1) })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` >= 1"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: sql.lt(1) })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` < 1"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: sql.lte(1) })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` <= 1"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: sql.eq(1) })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` = 1"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: sql.ne(1) })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` <> 1"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: sql.between('a', 'b') })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` BETWEEN 'a' AND 'b'"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: sql.not_between('a', 'b') })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` NOT BETWEEN 'a' AND 'b'"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: sql.like('abc') })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` LIKE 'abc'"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: 
+  sql.not_like('abc') })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` NOT LIKE 'abc'"
+
+
+sqlSelect
+  .from('table1')
+  .where({ col: sql.not_in([ 1, 2, 3 ]) })
+  .build();
+
+"SELECT * FROM `table1` WHERE `col` NOT IN (1, 2, 3)"
+
+
+sqlSelect
+  .from('table1')
+  .where({ __sql: [["LOWER(`stuff`) LIKE 'peaches'"]] })
+  .build();
+
+"SELECT * FROM `table1` WHERE LOWER(`stuff`) LIKE 'peaches'"
+
+
+sqlSelect
+  .from('table1')
+  .where({ __sql: [["LOWER(`stuff`) LIKE ?", ['peaches']]] })
+  .build();
+
+"SELECT * FROM `table1` WHERE LOWER(`stuff`) LIKE 'peaches'"
+
+
+sqlSelect
+  .from('table1')
+  .where({ __sql: [["LOWER(`stuff`) LIKE ? AND `number` > ?", ['peaches', 12]]] })
+  .build();
+
+"SELECT * FROM `table1` WHERE LOWER(`stuff`) LIKE 'peaches' AND `number` > 12"
+
+
+sqlSelect
+  .from('table1')
+  .where({ __sql: [["LOWER(`stuff`) LIKE ? AND `number` == ?", ['peaches']]] })
+  .build();
+
+"SELECT * FROM `table1` WHERE LOWER(`stuff`) LIKE 'peaches' AND `number` == NULL"
+```
+
+## Order
+```js
+var sqlSelect = sqlQuery.select();
+
+sqlSelect
+  .from('table1')
+  .order('col')
+  .build();
+
+"SELECT * FROM `table1` ORDER BY `col` ASC"
+
+
+sqlSelect
+  .from('table1')
+  .order('col', 'A')
+  .build();
+
+"SELECT * FROM `table1` ORDER BY `col` ASC"
+
+
+sqlSelect
+  .from('table1')
+  .order('col', 'Z')
+  .build();
+
+"SELECT * FROM `table1` ORDER BY `col` DESC"
+
+
+sqlSelect
+  .from('table1')
+  .order('col').order('col2', 'Z')
+  .build();
+
+"SELECT * FROM `table1` ORDER BY `col` ASC, `col2` DESC"
+
+
+sqlSelect
+  .from('table1')
+  .order('col', [])
+  .build();
+
+"SELECT * FROM `table1` ORDER BY col"
+
+
+sqlSelect
+  .from('table1')
+  .order('?? DESC', ['col'])
+  .build();
+
+"SELECT * FROM `table1` ORDER BY `col` DESC"
+
+
+sqlSelect
+  .from('table1')
+  .order('ST_Distance(??, ST_GeomFromText(?,4326))', ['geopoint', 'POINT(-68.3394 27.5578)'])
+  .build();
+
+"SELECT * FROM `table1` ORDER BY ST_Distance(`geopoint`, ST_GeomFromText('POINT(-68.3394 27.5578)',4326))"
+```
+
+## Limit
+
+```js
+var sqlSelect = sqlQuery.select();
+
+sqlSelect
+  .from('table1')
+  .limit(123)
+  .build();
+
+"SELECT * FROM `table1` LIMIT 123"
+
+
+sqlSelect
+  .from('table1')
+  .limit('123456789')
+  .build();
+
+"SELECT * FROM `table1` LIMIT 123456789"
+```
+
+## Select function
+
+```js
+var sqlSelect = sqlQuery.select();
+
+sqlSelect
+  .from('table1')
+  .fun('myfun', 'col1')
+  .build();
+
+"SELECT MYFUN(`col1`) FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .fun('myfun', [ 'col1', 'col2'])
+  .build();
+
+"SELECT MYFUN(`col1`, `col2`) FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .fun('dbo.fnBalance', [ 80, null, null], 'balance')
+  .build();
+
+"SELECT DBO.FNBALANCE(80, NULL, NULL) AS `balance` FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .fun('myfun', [ 'col1', 'col2'], 'alias')
+  .build();
+
+"SELECT MYFUN(`col1`, `col2`) AS `alias` FROM `table1`"
+
+
+sqlSelect
+  .from('table1')
+  .fun('myfun', [ 'col1', sqlQuery.Text('col2') ], 'alias')
+  .build();
+
+"SELECT MYFUN(`col1`, 'col2') AS `alias` FROM `table1`"
+```
+
+## Insert
+
+```js
+var sqlInsert = sqlQuery.insert();
+
+sqlInsert
+  .into('table1')
+  .build();
+
+"INSERT INTO `table1`"
+
+
+sqlInsert
+  .into('table1')
+  .set({})
+  .build();
+
+"INSERT INTO `table1` VALUES()"
+
+
+sqlInsert
+  .into('table1')
+  .set({ col: 1 })
+  .build();
+
+"INSERT INTO `table1` (`col`) VALUES (1)"
+
+
+sqlInsert
+  .into('table1')
+  .set({ col1: 1, col2: 'a' })
+  .build();
+
+"INSERT INTO `table1` (`col1`, `col2`) VALUES (1, 'a')"
+```
+
+## Update
+
+```js
+var sqlUpdate = sqlQuery.update()
+
+sqlUpdate
+  .into('table1')
+  .build();
+
+"UPDATE `table1`"
+
+
+sqlUpdate
+  .into('table1')
+  .set({ col: 1 })
+  .build();
+
+"UPDATE `table1` SET `col` = 1"
+
+
+sqlUpdate
+  .into('table1')
+  .set({ col1: 1, col2: 2 })
+  .build();
+
+"UPDATE `table1` SET `col1` = 1, `col2` = 2"
+
+
+sqlUpdate
+  .into('table1')
+  .set({ col1: 1, col2: 2 }).where({ id: 3 })
+  .build();
+
+"UPDATE `table1` SET `col1` = 1, `col2` = 2 WHERE `id` = 3"
+```

test/integration/test-dialect-mssql.js

@@ -73,4 +73,14 @@ var common         = require('../common');
 assert.equal(
+  dialect.escapeVal({ key: 'value' }),
+  "'{\"key\":\"value\"}'"
+);
+
+assert.equal(
+  dialect.escapeVal(Symbol("why does this exist")),
+  "NULL"
+)
+
+assert.equal(
   dialect.escapeVal(new Date(d.getTime() + tzOffsetMillis)),
-  "'2013-09-04T19:15:11.133Z'"
+  "'2013-09-04 19:15:11.133'"
 );
@@ -107,2 +117,2 @@
   true
-);
+);

test/integration/test-dialect-mysql.js

@@ -73,2 +73,12 @@ var common         = require('../common');
 assert.equal(
+  dialect.escapeVal({ key: 'value' }),
+  "`key` = 'value'"
+);
+
+assert.equal(
+	dialect.escapeVal(Symbol("why does this exist")),
+	"NULL"
+)
+
+assert.equal(
 	dialect.escapeVal(new Date(d.getTime() + tzOffsetMillis)),
@@ -75,0 +85,0 @@ "'2013-09-04 19:15:11.133'"

test/integration/test-dialect-postgresql.js

@@ -78,4 +78,14 @@ var common         = require('../common');
 assert.equal(
+  dialect.escapeVal({ key: 'value' }),
+  "'{\"key\":\"value\"}'"
+);
+
+assert.equal(
+	dialect.escapeVal(Symbol("why does this exist")),
+	"NULL"
+)
+
+assert.equal(
 	dialect.escapeVal(new Date(d.getTime() + tzOffsetMillis)),
-	"'2013-09-04T19:15:11.133Z'"
+	"'2013-09-04 19:15:11.133'"
 );
@@ -112,2 +122,2 @@
   false
-);
+);

test/integration/test-dialect-sqlite.js

@@ -73,4 +73,14 @@ var common         = require('../common');
 assert.equal(
+  dialect.escapeVal({ key: 'value' }),
+  "'{\"key\":\"value\"}'"
+);
+
+assert.equal(
+	dialect.escapeVal(Symbol("why does this exist")),
+	"NULL"
+)
+
+assert.equal(
 	dialect.escapeVal(new Date(d.getTime() + tzOffsetMillis)),
-	"'2013-09-04T19:15:11.133Z'"
+	"'2013-09-04 19:15:11.133'"
 );
@@ -107,2 +117,2 @@
   false
-);
+);

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

76126

increased by20.96%

Lines of code

2195

increased by2.19%

Number of lines in readme file

757

increased by3504.76%

Worsened metrics

Number of package files

41

decreased by-2.38%

No dependency changes