🚀 Big News: Socket Acquires Coana to Bring Reachability Analysis to Every Appsec Team.Learn more
Socket
Sign inDemoInstall
Socket

sql-string-template

Package Overview
Dependencies
Maintainers
1
Versions
6
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

sql-string-template - npm Package Compare versions

Comparing version

to
1.0.2

2

package.json
{
"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 @@