/node-mysql-es6-query

A helper function to build queries with ES6 template strings.

Primary LanguageJavaScript

node-mysql-es6-query

A helper function to build queries with ES6 template strings in node-mysql.

How it works

"use strict";

//require the node mysql module
let mysql = require("mysql");

//require the es6 query file and pass the mysql.escape fn
let SQL = require( "sql"))(mysql.escape);

//now you can write SQL in front of the ES6 Template Strings and they get escaped
 connection.query(SQL`SELECT username, password
                      FROM account
                      WHERE username = ${username}
                      LIMIT 1`, (err, rows) => {

 //more code
});