MYSQL Named Params Escape
Install
npm install mysql-named-params-escape
Usage
var npEscape = ;
Writing queries
var query = "SELECT ::something FROM ::table WHERE ::table.::whatever = :value";var params = something: 'title' table: 'foo' whatever: 'id' value: 123; // SELECT `title` FROM `foo` WHERE `foo`.`id` = 123;
Manual escaping
query = ; connection;
Setting queryFormat
connectionconfigqueryFormat = npEscape; connection;
Parameters
query
Type: String
The string of MYSQL code to be escaped.
::
followed by a word denotes an identifier to be escaped.
:
followed by a word denotes a value to be escaped.
params
Type: Object
An object in which the keys correspond to placeholders in the query. The placeholders will be replaced with the values from the object.