30 lines
1.1 KiB
Markdown
30 lines
1.1 KiB
Markdown
|
[](https://flattr.com/submit/auto?user_id=sidorares&url=https://github.com/sidorares/named-placeholders&title=named-placeholders&language=&tags=github&category=software)
|
||
|
|
|
||
|
|
[](https://nodei.co/npm/named-placeholders/)
|
||
|
|
|
||
|
|
[](http://travis-ci.org/sidorares/named-placeholders)
|
||
|
|
|
||
|
|
# 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
|
||
|
|
|
||
|
|
```sh
|
||
|
|
npm install named-placeholders
|
||
|
|
```
|
||
|
|
|
||
|
|
see [this mysql2 discussion](https://github.com/sidorares/node-mysql2/issues/117)
|
||
|
|
|
||
|
|
```js
|
||
|
|
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](https://github.com/mscdex/node-mariasql) library
|