node-red-node-sqlite
Advanced tools
Comparing version 0.3.7 to 0.4.0
{ | ||
"name": "node-red-node-sqlite", | ||
"version": "0.3.7", | ||
"version": "0.4.0", | ||
"description": "A sqlite node for Node-RED", | ||
"dependencies": { | ||
"sqlite3": "^4.0.6" | ||
"sqlite3": "^4.1.0" | ||
}, | ||
@@ -8,0 +8,0 @@ "repository": { |
@@ -52,3 +52,3 @@ module.exports = function(RED) { | ||
var doQuery = function(msg) { | ||
if (node.sqlquery == "msg.topic"){ | ||
if (node.sqlquery == "msg.topic") { | ||
if (typeof msg.topic === 'string') { | ||
@@ -88,3 +88,3 @@ if (msg.topic.length > 0) { | ||
} | ||
if (node.sqlquery == "fixed"){ | ||
if (node.sqlquery == "fixed") { | ||
if (typeof node.sql === 'string') { | ||
@@ -101,3 +101,3 @@ if (node.sql.length > 0) { | ||
} | ||
else{ | ||
else { | ||
if (node.sql === null || node.sql == "") { | ||
@@ -109,3 +109,3 @@ node.error("SQL statement config not set up",msg); | ||
} | ||
if (node.sqlquery == "prepared"){ | ||
if (node.sqlquery == "prepared") { | ||
if (typeof node.sql === 'string' && typeof msg.params !== "undefined" && typeof msg.params === "object") { | ||
@@ -112,0 +112,0 @@ if (node.sql.length > 0) { |
22614
Updatedsqlite3@^4.1.0