123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111 |
- // based on code from Brian White @mscdex mariasql library - https://github.com/mscdex/node-mariasql/blob/master/lib/Client.js#L272-L332
- // License: https://github.com/mscdex/node-mariasql/blob/master/LICENSE
- var RE_PARAM = /(?:\?)|(?::(\d+|(?:[a-zA-Z][a-zA-Z0-9_]*)))/g,
- DQUOTE = 34,
- SQUOTE = 39,
- BSLASH = 92;
- var parse = function(query) {
- var cqfn;
- if (this._queryCache && (cqfn = this._queryCache.get(query)))
- return cqfn;
- var ppos = RE_PARAM.exec(query), curpos = 0, start = 0, end, parts = [],
- i, chr, inQuote = false, escape = false, qchr, tokens = [], qcnt = 0, fn;
- if (ppos) {
- do {
- for (i=curpos,end=ppos.index; i<end; ++i) {
- chr = query.charCodeAt(i);
- if (chr === BSLASH)
- escape = !escape;
- else {
- if (escape) {
- escape = false;
- continue;
- }
- if (inQuote && chr === qchr) {
- if (query.charCodeAt(i + 1) === qchr) {
- // quote escaped via "" or ''
- ++i;
- continue;
- }
- inQuote = false;
- } else if (chr === DQUOTE || chr === SQUOTE) {
- inQuote = true;
- qchr = chr;
- }
- }
- }
- if (!inQuote) {
- parts.push(query.substring(start, end));
- tokens.push(ppos[0].length === 1 ? qcnt++ : ppos[1]);
- start = end + ppos[0].length;
- }
- curpos = end + ppos[0].length;
- } while (ppos = RE_PARAM.exec(query));
- if (tokens.length) {
- if (curpos < query.length)
- parts.push(query.substring(curpos));
- return [parts, tokens];
- }
- }
- return [query];
- };
- var EMPTY_LRU_FN = function(key, value) {};
- var createCompiler = function(config) {
- if (!config)
- config = {};
- if (!config.placeholder) {
- config.placeholder = '?';
- }
- var ncache = 100;
- var cache;
- if (typeof config.cache === 'number')
- ncache = config.cache;
- if (typeof config.cache === 'object')
- cache = config.cache;
- if (config.cache !== false && !cache) {
- cache = require('lru-cache')({ max: ncache, dispose: EMPTY_LRU_FN });
- }
- function toArrayParams(tree, params) {
- var arr = [];
- if (tree.length == 1)
- return [tree[0], []];
- var tokens = tree[1];
- for (var i=0; i < tokens.length; ++i)
- arr.push(params[tokens[i]]);
- return [tree[0], arr];
- }
- function join(tree) {
- if (tree.length == 1)
- return tree;
- var unnamed = tree[0].join(config.placeholder);
- if (tree[0].length == tree[1].length)
- unnamed += config.placeholder;
- return [unnamed, tree[1]];
- }
- var compile = function(query, paramsObj) {
- var tree;
- if (cache && (tree = cache.get(query))) {
- return toArrayParams(tree, paramsObj)
- }
- tree = join(parse(query));
- cache && cache.set(query, tree);
- return toArrayParams(tree, paramsObj);
- }
- compile.parse = parse;
- return compile;
- }
- module.exports = createCompiler;
|