{"_id":"named-placeholders","_rev":"3618826","name":"named-placeholders","description":"sql named placeholders to unnamed compiler","dist-tags":{"latest":"1.1.3"},"maintainers":[{"name":"sidorares","email":""}],"time":{"modified":"2024-10-15T06:48:29.000Z","created":"2014-08-30T08:21:05.775Z","1.1.3":"2023-01-12T03:43:18.816Z","1.1.2":"2018-11-07T03:10:27.123Z","1.1.1":"2015-11-25T04:47:08.681Z","1.1.0":"2015-09-21T00:45:05.973Z","1.0.0":"2015-09-14T01:16:48.665Z","0.1.3":"2015-01-09T03:55:14.864Z","0.1.2":"2015-01-09T03:19:03.243Z","0.1.1":"2014-08-30T08:24:07.878Z","0.1.0":"2014-08-30T08:21:05.775Z"},"users":{"asaupup":true,"nuwaio":true},"author":{"name":"Andrey Sidorov","email":"sidorares@yandex.com"},"repository":{"type":"git","url":"git+https://github.com/sidorares/named-placeholders.git"},"versions":{"1.1.3":{"name":"named-placeholders","version":"1.1.3","description":"sql named placeholders to unnamed compiler","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+https://github.com/sidorares/named-placeholders.git"},"keywords":["sql","pdo","named","placeholders"],"engines":{"node":">=12.0.0"},"author":{"name":"Andrey Sidorov","email":"sidorares@yandex.com"},"license":"MIT","devDependencies":{"mocha":"^5.2.0","should":"^13.2.3"},"dependencies":{"lru-cache":"^7.14.1"},"gitHead":"8b78fcf6142355a2bbe6835a9e49caa9d1550ef7","bugs":{"url":"https://github.com/sidorares/named-placeholders/issues"},"homepage":"https://github.com/sidorares/named-placeholders#readme","_id":"named-placeholders@1.1.3","_nodeVersion":"18.9.0","_npmVersion":"8.19.1","dist":{"shasum":"df595799a36654da55dda6152ba7a137ad1d9351","size":3026,"noattachment":false,"key":"/named-placeholders/-/named-placeholders-1.1.3.tgz","tarball":"http://registry.cnpm.dingdandao.com/named-placeholders/download/named-placeholders-1.1.3.tgz"},"_npmUser":{"name":"sidorares","email":"sidorares@yandex.com"},"directories":{},"maintainers":[{"name":"sidorares","email":""}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/named-placeholders_1.1.3_1673494998658_0.9036744692151635"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2023-01-12T03:43:18.816Z","publish_time":1673494998816,"_cnpm_publish_time":1673494998816},"1.1.2":{"name":"named-placeholders","version":"1.1.2","description":"sql named placeholders to unnamed compiler","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+https://github.com/sidorares/named-placeholders.git"},"keywords":["sql","pdo","named","placeholders"],"engines":{"node":">=6.0.0"},"author":{"name":"Andrey Sidorov","email":"sidorares@yandex.com"},"license":"MIT","devDependencies":{"mocha":"^5.2.0","should":"^13.2.3"},"dependencies":{"lru-cache":"^4.1.3"},"gitHead":"d5134a305e9cdc6604153aa08275942e15895936","bugs":{"url":"https://github.com/sidorares/named-placeholders/issues"},"homepage":"https://github.com/sidorares/named-placeholders#readme","_id":"named-placeholders@1.1.2","_npmVersion":"6.1.0","_nodeVersion":"10.7.0","_npmUser":{"name":"sidorares","email":"sidorares@yandex.com"},"dist":{"shasum":"ceb1fbff50b6b33492b5cf214ccf5e39cef3d0e8","size":3221,"noattachment":false,"key":"/named-placeholders/-/named-placeholders-1.1.2.tgz","tarball":"http://registry.cnpm.dingdandao.com/named-placeholders/download/named-placeholders-1.1.2.tgz"},"maintainers":[{"name":"sidorares","email":""}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/named-placeholders_1.1.2_1541560227018_0.1282692527775109"},"_hasShrinkwrap":false,"publish_time":1541560227123,"_cnpm_publish_time":1541560227123},"1.1.1":{"name":"named-placeholders","version":"1.1.1","description":"sql named placeholders to unnamed compiler","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+https://github.com/sidorares/named-placeholders.git"},"keywords":["sql","pdo","named","placeholders"],"author":{"name":"Andrey Sidorov","email":"sidorares@yandex.com"},"license":"MIT","devDependencies":{"mocha":"1.21.4","mocha.md":"0.1.0","should":"4.0.4"},"dependencies":{"lru-cache":"2.5.0"},"gitHead":"89fd88865c39a6d825a0e2b54c5ce14e493c3876","bugs":{"url":"https://github.com/sidorares/named-placeholders/issues"},"homepage":"https://github.com/sidorares/named-placeholders#readme","_id":"named-placeholders@1.1.1","_shasum":"3b7a0d26203dd74b3a9df4c9cfb827b2fb907e64","_from":".","_npmVersion":"2.14.7","_nodeVersion":"4.2.1","_npmUser":{"name":"sidorares","email":"sidorares@yandex.com"},"maintainers":[{"name":"sidorares","email":""}],"dist":{"shasum":"3b7a0d26203dd74b3a9df4c9cfb827b2fb907e64","size":4184,"noattachment":false,"key":"/named-placeholders/-/named-placeholders-1.1.1.tgz","tarball":"http://registry.cnpm.dingdandao.com/named-placeholders/download/named-placeholders-1.1.1.tgz"},"directories":{},"publish_time":1448426828681,"_cnpm_publish_time":1448426828681,"_hasShrinkwrap":false},"1.1.0":{"name":"named-placeholders","version":"1.1.0","description":"sql named placeholders to unnamed compiler","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+https://github.com/sidorares/named-placeholders.git"},"keywords":["sql","pdo","named","placeholders"],"author":{"name":"Andrey Sidorov","email":"sidorares@yandex.com"},"license":"MIT","devDependencies":{"mocha":"1.21.4","mocha.md":"0.1.0","should":"4.0.4"},"dependencies":{"lru-cache":"2.5.0"},"gitHead":"ac3b6d83331600523ffaeb6d23179e8f19407997","bugs":{"url":"https://github.com/sidorares/named-placeholders/issues"},"homepage":"https://github.com/sidorares/named-placeholders#readme","_id":"named-placeholders@1.1.0","_shasum":"d23ac8d83a399ef0f33046522594e2f0eb0af34d","_from":".","_npmVersion":"2.14.3","_nodeVersion":"4.1.0","_npmUser":{"name":"sidorares","email":"sidorares@yandex.com"},"maintainers":[{"name":"sidorares","email":""}],"dist":{"shasum":"d23ac8d83a399ef0f33046522594e2f0eb0af34d","size":4052,"noattachment":false,"key":"/named-placeholders/-/named-placeholders-1.1.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/named-placeholders/download/named-placeholders-1.1.0.tgz"},"directories":{},"publish_time":1442796305973,"_cnpm_publish_time":1442796305973,"_hasShrinkwrap":false},"1.0.0":{"name":"named-placeholders","version":"1.0.0","description":"sql named placeholders to unnamed compiler","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+https://github.com/sidorares/named-placeholders.git"},"keywords":["sql","pdo","named","placeholders"],"author":{"name":"Andrey Sidorov","email":"sidorares@yandex.com"},"license":"MIT","devDependencies":{"mocha":"1.21.4","mocha.md":"0.1.0","should":"4.0.4"},"dependencies":{"lru-cache":"2.5.0"},"gitHead":"9d6529e134d5701c4827bcc5e74abd30b7f3f8ac","bugs":{"url":"https://github.com/sidorares/named-placeholders/issues"},"homepage":"https://github.com/sidorares/named-placeholders#readme","_id":"named-placeholders@1.0.0","_shasum":"7116209b234655ec698755932592912aceb516d8","_from":".","_npmVersion":"2.11.3","_nodeVersion":"2.3.3","_npmUser":{"name":"sidorares","email":"sidorares@yandex.com"},"maintainers":[{"name":"sidorares","email":""}],"dist":{"shasum":"7116209b234655ec698755932592912aceb516d8","size":3883,"noattachment":false,"key":"/named-placeholders/-/named-placeholders-1.0.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/named-placeholders/download/named-placeholders-1.0.0.tgz"},"directories":{},"publish_time":1442193408665,"_cnpm_publish_time":1442193408665,"_hasShrinkwrap":false},"0.1.3":{"name":"named-placeholders","version":"0.1.3","description":"sql named placeholders to unnamed compiler","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"https://github.com/sidorares/named-placeholders"},"keywords":["sql","pdo","named","placeholders"],"author":{"name":"Andrey Sidorov","email":"sidorares@yandex.com"},"license":"MIT","devDependencies":{"mocha":"1.21.4","mocha.md":"0.1.0","should":"4.0.4"},"dependencies":{"lru-cache":"2.5.0"},"gitHead":"78fb4ea2b3b5279e4778bd96c232a80fa18b0511","bugs":{"url":"https://github.com/sidorares/named-placeholders/issues"},"homepage":"https://github.com/sidorares/named-placeholders","_id":"named-placeholders@0.1.3","_shasum":"353776ee259ad105227e13852eef4215ac631e84","_from":".","_npmVersion":"1.4.28","_npmUser":{"name":"sidorares","email":"sidorares@yandex.com"},"maintainers":[{"name":"sidorares","email":""}],"dist":{"shasum":"353776ee259ad105227e13852eef4215ac631e84","size":3147,"noattachment":false,"key":"/named-placeholders/-/named-placeholders-0.1.3.tgz","tarball":"http://registry.cnpm.dingdandao.com/named-placeholders/download/named-placeholders-0.1.3.tgz"},"directories":{},"publish_time":1420775714864,"_cnpm_publish_time":1420775714864,"_hasShrinkwrap":false},"0.1.2":{"name":"named-placeholders","version":"0.1.2","description":"sql named placeholders to unnamed compiler","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"https://github.com/sidorares/named-placeholders"},"keywords":["sql","pdo","named","placeholders"],"author":{"name":"Andrey Sidorov","email":"sidorares@yandex.com"},"license":"MIT","devDependencies":{"mocha":"^1.21.4","mocha.md":"^0.1.0","should":"^4.0.4"},"dependencies":{"lru-cache":"^2.5.0"},"gitHead":"bc547444bb049415762c0749699f372bd9ba5fcf","bugs":{"url":"https://github.com/sidorares/named-placeholders/issues"},"homepage":"https://github.com/sidorares/named-placeholders","_id":"named-placeholders@0.1.2","_shasum":"7ad139c223d821a216ed3e6ef40760e291c8c8be","_from":".","_npmVersion":"1.4.28","_npmUser":{"name":"sidorares","email":"sidorares@yandex.com"},"maintainers":[{"name":"sidorares","email":""}],"dist":{"shasum":"7ad139c223d821a216ed3e6ef40760e291c8c8be","size":3149,"noattachment":false,"key":"/named-placeholders/-/named-placeholders-0.1.2.tgz","tarball":"http://registry.cnpm.dingdandao.com/named-placeholders/download/named-placeholders-0.1.2.tgz"},"directories":{},"publish_time":1420773543243,"_cnpm_publish_time":1420773543243,"_hasShrinkwrap":false},"0.1.1":{"name":"named-placeholders","version":"0.1.1","description":"sql named placeholders to unnamed compiler","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"https://github.com/sidorares/named-placeholders"},"keywords":["sql","pdo","named","placeholders"],"author":{"name":"Andrey Sidorov","email":"sidorares@yandex.com"},"license":"MIT","devDependencies":{"mocha":"^1.21.4","mocha.md":"^0.1.0","should":"^4.0.4"},"dependencies":{"lru-cache":"^2.5.0"},"gitHead":"7e4dc90792e0c9e823a11017601422283089ee33","bugs":{"url":"https://github.com/sidorares/named-placeholders/issues"},"homepage":"https://github.com/sidorares/named-placeholders","_id":"named-placeholders@0.1.1","_shasum":"c6765b3cc1cd37a609cb0fd35b7978b2ca63245f","_from":".","_npmVersion":"1.4.23","_npmUser":{"name":"sidorares","email":"sidorares@yandex.com"},"maintainers":[{"name":"sidorares","email":""}],"dist":{"shasum":"c6765b3cc1cd37a609cb0fd35b7978b2ca63245f","size":3185,"noattachment":false,"key":"/named-placeholders/-/named-placeholders-0.1.1.tgz","tarball":"http://registry.cnpm.dingdandao.com/named-placeholders/download/named-placeholders-0.1.1.tgz"},"directories":{},"publish_time":1409387047878,"_cnpm_publish_time":1409387047878,"_hasShrinkwrap":false},"0.1.0":{"name":"named-placeholders","version":"0.1.0","description":"sql named placeholders to unnamed compiler","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"https://github.com/sidorares/named-placeholders"},"keywords":["sql","pdo","named","placeholders"],"author":{"name":"Andrey Sidorov","email":"sidorares@yandex.com"},"license":"MIT","devDependencies":{"mocha":"^1.21.4","mocha.md":"^0.1.0","should":"^4.0.4"},"dependencies":{"lru-cache":"^2.5.0"},"gitHead":"8aab747ebf8786304a3227ac879088efbe554f3d","bugs":{"url":"https://github.com/sidorares/named-placeholders/issues"},"homepage":"https://github.com/sidorares/named-placeholders","_id":"named-placeholders@0.1.0","_shasum":"ed9ba6d747589dec25a3a978cfe41cb7a4a8de9f","_from":".","_npmVersion":"1.4.23","_npmUser":{"name":"sidorares","email":"sidorares@yandex.com"},"maintainers":[{"name":"sidorares","email":""}],"dist":{"shasum":"ed9ba6d747589dec25a3a978cfe41cb7a4a8de9f","size":3187,"noattachment":false,"key":"/named-placeholders/-/named-placeholders-0.1.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/named-placeholders/download/named-placeholders-0.1.0.tgz"},"directories":{},"publish_time":1409386865775,"_cnpm_publish_time":1409386865775,"_hasShrinkwrap":false}},"readme":"[![Flattr this git repo](http://api.flattr.com/button/flattr-badge-large.png)](https://flattr.com/submit/auto?user_id=sidorares&url=https://github.com/sidorares/named-placeholders&title=named-placeholders&language=&tags=github&category=software)\n\n[![NPM](https://nodei.co/npm/named-placeholders.png?downloads=true&stars=true)](https://nodei.co/npm/named-placeholders/)\n\n[![CI](https://github.com/mysqljs/named-placeholders/actions/workflows/ci.yml/badge.svg?branch=master)](https://github.com/mysqljs/named-placeholders/actions/workflows/ci.yml)\n\n# named-placeholders\n\ncompiles \"select foo where foo.id = :bar and foo.baz < :baz\" into \"select foo where foo.id = ? and foo.baz < ?\" + [\"bar\", \"baz\"]\n\n## usage\n\n```sh\nnpm install named-placeholders\n```\n\nsee [this mysql2 discussion](https://github.com/sidorares/node-mysql2/issues/117)\n\n```js\nvar mysql = require('mysql');\nvar toUnnamed = require('named-placeholders')();\n\nvar q = toUnnamed('select 1+:test', { test: 123});\nmysql.createConnection().query(q[0], q[1]);\n```\n\n## credits\n\nparser is based on @mscdex code of his excellent [node-mariasql](https://github.com/mscdex/node-mariasql) library\n","_attachments":{},"homepage":"https://github.com/sidorares/named-placeholders#readme","bugs":{"url":"https://github.com/sidorares/named-placeholders/issues"},"license":"MIT"}