named-placeholders

sql named placeholders to unnamed compiler

Downloads in past

Stats

StarsIssuesVersionUpdatedCreatedSize
named-placeholders
17101.1.318 days ago8 years agoMinified + gzip package size for named-placeholders in KB

Readme

Flattr this git repo
NPM
CI
named-placeholders
compiles "select foo where foo.id = :bar and foo.baz < :baz" into "select foo where foo.id = ? and foo.baz < ?" + "bar", "baz"

usage

npm install named-placeholders

see this mysql2 discussion
var mysql = require('mysql');
var toUnnamed = require('named-placeholders')();

var q = toUnnamed('select 1+:test', { test: 123});
mysql.createConnection().query(q[0], q[1]);

credits

parser is based on @mscdex code of his excellent node-mariasql library