sql-string-template
Advanced tools
Comparing version
{ | ||
"name": "sql-string-template", | ||
"version": "1.0.1", | ||
"version": "1.0.2", | ||
"description": "ES2015 tagged template string for preparing statements", | ||
@@ -5,0 +5,0 @@ "main": "index.js", |
@@ -16,9 +16,15 @@ # SQL String Template | ||
const SQL = require('sql-string-template'); | ||
const data = { name: "jon", age: 12 }; | ||
const [sql, params] = SQL` | ||
INSERT INTO account (name, age) values (${name}, ${age}) | ||
`.pack(); | ||
/* | ||
sql: "INSERT INTO account (name, age) values (?, ?)" | ||
params: ["jon", 12] | ||
const data = { | ||
name: "jon", | ||
age: 12 | ||
}; | ||
const stmt = SQL` | ||
INSERT INTO account | ||
(name, age) | ||
values | ||
(${data.name}, ${data.age}) | ||
`; | ||
// stmt.sql: "INSERT INTO account (name, age) values (?, ?)" | ||
// stmt.params: ["jon", 12] | ||
*/ | ||
@@ -36,6 +42,4 @@ ``` | ||
`.pack(); | ||
/* | ||
sql: "INSERT INTO account (name, age) values (?, ?)" | ||
params: ["jon", 12] | ||
*/ | ||
// sql: "INSERT INTO account (name, age) values (?, ?)" | ||
// params: ["jon", 12] | ||
``` | ||
@@ -42,0 +46,0 @@ |
9329
0.37%82
5.13%