sql-string-template - npm Package Compare versions

Comparing version 1.1.0 to 1.1.1

package.json

 {
   "name": "sql-string-template",
-  "version": "1.1.0",
+  "version": "1.1.1",
   "description": "ES2015 tagged template string for preparing statements",
@@ -5,0 +5,0 @@ "main": "index.js",

README.md

@@ -40,3 +40,3 @@ # SQL String Template
   INSERT INTO account ${values(data)}
-`.pack();
+`.spread();
 // sql: "INSERT INTO account (name, age) values (?, ?)"
@@ -55,3 +55,4 @@ // params:  ["jon", 12]
   })}
-`.pack();
+  WHERE id = ${1}
+`.spread();
 /*
@@ -84,2 +85,39 @@ sql: "UPDATE account SET name=?, age=?, school=?"
 */
+```
+
+
+## Keyword Functions
+
+#### values
+```javascript
+const data = {
+  name: 'fk',
+  age: 18
+};
+const stmt = SQL`insert into tbl ${SQL.values(data)}`;
+stmt.sql; /* insert into tbl (name, age) values (?, ?) */
+stmt.params; /* ['fk', 18] */
+```
+
+### set
+```javascript
+const data = {
+  name: 'fk',
+  age: 18
+};
+const stmt = SQL`update tbl set ${SQL.set(data)}`;
+stmt.sql; /* update tbl set name=?, age=? */
+stmt.params; /* ['fk', 18] */
+```
+
+### join
+```javascript
+const list = [
+  "Nick", 
+  "Adidas",
+  "Jordon"
+];
+const stmt = SQL`select * from tbl where a in (${SQL.join(list)})`;
+stmt.sql; /* select * from tbl where a in (?, ?, ?) */
+stmt.params; /* ["Nick", "Adidas", "Jordon"] */
 ```

No alert changes

Improved metrics

Total package byte prevSize

10844

7.38%

Number of lines in readme file

120

46.34%

No dependency changes