Archived

This repository has been archived on 2026-03-06. You can view files and clone it, but cannot push or open issues or pull requests.

History

houwq 38cd670902 Initial commit		2025-06-13 14:04:40 +08:00
..
index.js	Initial commit	2025-06-13 14:04:40 +08:00
LICENSE	Initial commit	2025-06-13 14:04:40 +08:00
package.json	Initial commit	2025-06-13 14:04:40 +08:00
README.md	Initial commit	2025-06-13 14:04:40 +08:00

README.md

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