{"_id":"sequelize-sql-tag","_rev":"8-48d36e04ee2a5f6cb0b67680eb96db66","name":"sequelize-sql-tag","description":"A sequelize plugin for sql-tag","dist-tags":{"latest":"2.0.2"},"versions":{"0.0.1":{"name":"sequelize-sql-tag","version":"0.0.1","repository":{"type":"git","url":"https://github.com/seegno/sequelize-sql-tag.git"},"description":"A sequelize plugin for [sql-tag](https://www.npmjs.com/sql-tag]","keywords":["es6","multiline","plugin","sequelize","sql","string","strings","tagged","template"],"author":{"name":"Rui Marinho","email":"rui.marinho@seegno.com","url":"https://github.com/ruimarinho"},"homepage":"https://github.com/seegno/sequelize-sql-tag","bugs":{"url":"https://github.com/seegno/sequelize-sql-tag/issues"},"license":"MIT","scripts":{"changelog":"github-changes -o seegno -r sequelize-sql-tag -a --only-pulls --use-commit-body --title 'Changelog' --date-format '/ YYYY-MM-DD'","test":"NODE_ENV=test ./node_modules/.bin/mocha test/*_test.js --require should --reporter spec"},"devDependencies":{"github-changes":"0.0.16","mocha":"^2.1.0","should":"^5.0.1","sqlite3":"^3.0.5"},"peerDependencies":{"sequelize":">= 2.0.0 < 3"},"gitHead":"c6e15c588a00219d80e5e2a229dff3ff2dde94fe","_id":"sequelize-sql-tag@0.0.1","_shasum":"974ed538d11208a04103afa8b4ad4438529bbe39","_from":".","_npmVersion":"2.5.1","_nodeVersion":"1.3.0","_npmUser":{"name":"ruimarinho","email":"ruipmarinho@gmail.com"},"maintainers":[{"name":"ruimarinho","email":"ruipmarinho@gmail.com"}],"dist":{"shasum":"974ed538d11208a04103afa8b4ad4438529bbe39","tarball":"https://registry.npmjs.org/sequelize-sql-tag/-/sequelize-sql-tag-0.0.1.tgz","integrity":"sha512-2Or3Od9e8SdciFbqvOKdDIa5Y8gUquLIqBMiDPfVmg9ZssCNKGdjomjrAUuVv5zt6Se1OWO9ANJUX4R2QLLW/g==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQD5gHgR3We9Ej8+CiXKyzU6N2gtw+LvqqfLUNqsf28PxQIgWKTHpFkUxgxSz4tvk0xsUqxPxcybER7i+6ebNb4lJB4="}]}},"1.0.0":{"name":"sequelize-sql-tag","version":"1.0.0","description":"A sequelize plugin for sql-tag","license":"MIT","author":{"name":"Rui Marinho","email":"rui.marinho@seegno.com","url":"https://github.com/ruimarinho"},"homepage":"https://github.com/seegno/sequelize-sql-tag","bugs":{"url":"https://github.com/seegno/sequelize-sql-tag/issues"},"repository":{"type":"git","url":"git+https://github.com/seegno/sequelize-sql-tag.git"},"main":"./dist/index.js","keywords":["es6","multiline","plugin","sequelize","sql","sql-tag","string","strings","tagged","template"],"options":{"mocha":"--compilers js:babel/register --require should test"},"scripts":{"build":"rm -rf dist/* && ./node_modules/.bin/babel src/ --loose --out-dir dist/","changelog":"github_changelog_generator --no-issues","cover":"babel-node node_modules/.bin/isparta cover --report html node_modules/.bin/_mocha -- $npm_package_options_mocha","lint":"eslint src test","prepublish":"npm test && npm run build","test":"mocha $npm_package_options_mocha"},"devDependencies":{"babel":"^5.6.14","babel-eslint":"^3.1.23","eslint":"^0.24.1","eslint-plugin-babel":"^1.1.0","isparta":"^3.0.3","mocha":"^2.2.5","sequelize":"2.0.3","should":"^7.0.3","sqlite3":"^3.0.10"},"peerDependencies":{"sequelize":">=1.7.0 <2.0.4"},"engines":{"node":">= 0.10","iojs":">= 1.0.0"},"gitHead":"6bd67f50a8b15d247aaeefee464442322b5f0b94","_id":"sequelize-sql-tag@1.0.0","_shasum":"730c93291ff4f1e44ccd0c3a08483a92305e94c1","_from":".","_npmVersion":"2.13.4","_nodeVersion":"2.3.3","_npmUser":{"name":"ruimarinho","email":"ruipmarinho@gmail.com"},"dist":{"shasum":"730c93291ff4f1e44ccd0c3a08483a92305e94c1","tarball":"https://registry.npmjs.org/sequelize-sql-tag/-/sequelize-sql-tag-1.0.0.tgz","integrity":"sha512-Pj0ABb1tVltLTQHaOfpYp92nFz++USXWlcqrkhaSoyAFgKOMXNIf9waIUx9DI9gghxChS2+yeWGyTWFrBzwOVw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCVZYEwFPA8TfpYBEt9LnHho6qEaLCmfgw83HygMMA2mgIgExmve78qlrs0aTFGjwvALst3JQ23i8dlWJTDsNsSEVw="}]},"maintainers":[{"name":"ruimarinho","email":"ruipmarinho@gmail.com"}]},"2.0.0":{"name":"sequelize-sql-tag","version":"2.0.0","description":"A sequelize plugin for sql-tag","keywords":["es6","es2015","multiline","plugin","sequelize","sql","sql-tag","string","strings","tagged","template"],"homepage":"https://github.com/seegno/sequelize-sql-tag","bugs":{"url":"https://github.com/seegno/sequelize-sql-tag/issues"},"license":"MIT","author":{"name":"Rui Marinho","email":"rui.marinho@seegno.com","url":"https://github.com/ruimarinho"},"main":"dist/src/index.js","repository":{"type":"git","url":"git+https://github.com/seegno/sequelize-sql-tag.git"},"scripts":{"changelog":"github_changelog_generator --no-issues --header-label='# Changelog' --future-release=v$npm_config_future_release && sed -i '' -e :a -e '$d;N;2,4ba' -e 'P;D' CHANGELOG.md","lint":"eslint src test","prepublish":"npm run transpile","test":"NODE_ENV=test mocha $npm_package_options_mocha","testdocker":"docker-compose run --rm sut","transpile":"rm -rf dist/* && babel src --out-dir dist/src && cp package.json dist/","version":"npm run changelog --future-release=$npm_package_version && npm run transpile && git add -A CHANGELOG.md dist"},"dependencies":{"sql-tag":"^1.0.0"},"devDependencies":{"babel-cli":"^6.8.0","babel-plugin-add-module-exports":"^0.2.1","babel-preset-es2015-node4":"^2.1.0","babel-register":"^6.8.0","eslint":"^3.3.0","eslint-config-seegno":"^6.0.0","mocha":"^3.0.2","mysql":"^2.11.1","pg":"^6.1.0","pre-commit":"^1.1.2","sequelize":"3.14.0","should":"^11.0.0","sqlite3":"^3.0.10"},"peerDependencies":{"sequelize":">=3.14.0"},"engines":{"node":">=4"},"options":{"mocha":"--compilers js:babel-register --recursive --require should"},"pre-commit":["lint"],"gitHead":"7168238831036117e2b7093ddfcaf5059c84c0aa","_id":"sequelize-sql-tag@2.0.0","_shasum":"e03923c823baba01e3ade420d0b895aeb5a25847","_from":".","_npmVersion":"3.10.3","_nodeVersion":"6.3.0","_npmUser":{"name":"ruimarinho","email":"ruipmarinho@gmail.com"},"dist":{"shasum":"e03923c823baba01e3ade420d0b895aeb5a25847","tarball":"https://registry.npmjs.org/sequelize-sql-tag/-/sequelize-sql-tag-2.0.0.tgz","integrity":"sha512-VweStsraDyatjGHHPDc7fk6tBhdllMA4Hq35yoY0Qps81R0mpoArA+dGBLSmjwKAolrv2Z/bDS2qgCCLpUlMwA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIFUAfkNXABgS6d7peJMB01SOYCHxGiuiSjMrYyUb+VDkAiBA3ly5znY/eEGuZJBB8+goizFNa69tfy6XTG/YvSucQA=="}]},"maintainers":[{"name":"ruimarinho","email":"ruipmarinho@gmail.com"}],"_npmOperationalInternal":{"host":"packages-16-east.internal.npmjs.com","tmp":"tmp/sequelize-sql-tag-2.0.0.tgz_1471479131884_0.4245380947832018"}},"2.0.1":{"name":"sequelize-sql-tag","version":"2.0.1","description":"A sequelize plugin for sql-tag","keywords":["es6","es2015","multiline","plugin","sequelize","sql","sql-tag","string","strings","tagged","template"],"homepage":"https://github.com/seegno/sequelize-sql-tag","bugs":{"url":"https://github.com/seegno/sequelize-sql-tag/issues"},"license":"MIT","author":{"name":"Rui Marinho","email":"rui.marinho@seegno.com","url":"https://github.com/ruimarinho"},"main":"dist/src/index.js","repository":{"type":"git","url":"git+https://github.com/seegno/sequelize-sql-tag.git"},"scripts":{"changelog":"github_changelog_generator --no-issues --header-label='# Changelog' --future-release=v$npm_config_future_release && sed -i '' -e :a -e '$d;N;2,4ba' -e 'P;D' CHANGELOG.md","lint":"eslint src test","prepublish":"npm run transpile","test":"NODE_ENV=test mocha $npm_package_options_mocha","testdocker":"docker-compose run --rm sut","transpile":"rm -rf dist/* && babel src --out-dir dist/src && cp package.json dist/","version":"npm run changelog --future-release=$npm_package_version && npm run transpile && git add -A CHANGELOG.md dist"},"dependencies":{"sql-tag":"^1.0.1"},"devDependencies":{"babel-cli":"^6.8.0","babel-plugin-add-module-exports":"^0.2.1","babel-preset-es2015-node4":"^2.1.0","babel-register":"^6.8.0","eslint":"^3.3.0","eslint-config-seegno":"^6.0.0","mocha":"^3.0.2","mysql":"^2.11.1","pg":"^6.1.0","pre-commit":"^1.1.2","sequelize":"3.14.0","should":"^11.0.0","sqlite3":"^3.0.10"},"peerDependencies":{"sequelize":">=3.14.0"},"engines":{"node":">=4"},"options":{"mocha":"--compilers js:babel-register --recursive --require should"},"pre-commit":["lint"],"gitHead":"92741fc6089f49a7c4215e27df374e25c75f337b","_id":"sequelize-sql-tag@2.0.1","_shasum":"216f2d8434502988021880a0334ad5aab7c1cd3f","_from":".","_npmVersion":"3.10.8","_nodeVersion":"7.0.0","_npmUser":{"name":"ruimarinho","email":"ruipmarinho@gmail.com"},"dist":{"shasum":"216f2d8434502988021880a0334ad5aab7c1cd3f","tarball":"https://registry.npmjs.org/sequelize-sql-tag/-/sequelize-sql-tag-2.0.1.tgz","integrity":"sha512-m0Su90OI5AT35ITdA8aXbWmvwicghLmR3IYzwkL+ETe05l6SzUW0mUs1fqisvie1dv73iMleh3VfNt9T0rZzxA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIF1OC2WorF0iFCqKF6hz9CfX9akKb9S+M+LKE2A0jhauAiEApCspfTHHYPy9A7T5ZoJP5+g+THTI9P3djaXKZaiSgUU="}]},"maintainers":[{"name":"ruimarinho","email":"ruipmarinho@gmail.com"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/sequelize-sql-tag-2.0.1.tgz_1478224436534_0.1397540713660419"}},"2.0.2":{"name":"sequelize-sql-tag","version":"2.0.2","description":"A sequelize plugin for sql-tag","keywords":["es6","es2015","multiline","plugin","sequelize","sql","sql-tag","string","strings","tagged","template"],"homepage":"https://github.com/seegno/sequelize-sql-tag","bugs":{"url":"https://github.com/seegno/sequelize-sql-tag/issues"},"license":"MIT","author":{"name":"Rui Marinho","email":"rui.marinho@seegno.com","url":"https://github.com/ruimarinho"},"main":"dist/src/index.js","repository":{"type":"git","url":"git+https://github.com/seegno/sequelize-sql-tag.git"},"scripts":{"changelog":"github_changelog_generator --no-issues --header-label='# Changelog' --future-release=v$npm_config_future_release && sed -i '' -e :a -e '$d;N;2,4ba' -e 'P;D' CHANGELOG.md","lint":"eslint src test","prepublish":"npm run transpile","test":"NODE_ENV=test mocha $npm_package_options_mocha","testdocker":"docker-compose run --rm sut","transpile":"rm -rf dist/* && babel src --out-dir dist/src && cp package.json dist/","version":"npm run changelog --future-release=$npm_package_version && npm run transpile && git add -A CHANGELOG.md dist"},"dependencies":{"sql-tag":"^1.0.1"},"devDependencies":{"babel-cli":"^6.8.0","babel-plugin-add-module-exports":"^0.2.1","babel-preset-es2015-node4":"^2.1.0","babel-register":"^6.8.0","eslint":"^3.3.0","eslint-config-seegno":"^6.0.0","mocha":"^3.0.2","mysql":"^2.11.1","mysql2":"^1.1.2","pg":"^6.1.0","pre-commit":"^1.1.2","sequelize":"3.14.0","should":"^11.0.0","sqlite3":"^3.0.10"},"peerDependencies":{"sequelize":">=3.14.0 || >=4.0.0-0"},"engines":{"node":">=4"},"options":{"mocha":"--compilers js:babel-register --recursive --require should"},"pre-commit":["lint"],"gitHead":"fbff01c591c010b9cae66a39745734fbb7890423","_id":"sequelize-sql-tag@2.0.2","_shasum":"86058fc8059b5288a8227b8d552c17e9dcbdcb0d","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"ruimarinho","email":"ruipmarinho@gmail.com"},"dist":{"shasum":"86058fc8059b5288a8227b8d552c17e9dcbdcb0d","tarball":"https://registry.npmjs.org/sequelize-sql-tag/-/sequelize-sql-tag-2.0.2.tgz","integrity":"sha512-nyl8WKkukweLIsZczFDMiYNnjgqVNikumfOJzL4kZLzoMoerIIuEvg79csniGXs3UqQ1ChetS6XFIvmJE3e3ag==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIGMl02eR1RTQ2pdu1C0TbzzSxksw18TcAS7p1bn9yX4eAiBPc51PAr+qTseW9WXrqwMWXiwYNg58xk/HAVbbT0+1Hg=="}]},"maintainers":[{"name":"ruimarinho","email":"ruipmarinho@gmail.com"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/sequelize-sql-tag-2.0.2.tgz_1485631086838_0.48008303181268275"}}},"readme":"# sequelize-sql-tag\n\nA template tag for writing elegant parameterized SQL queries based on [ES2015 tagged template literals](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Template_literals#Tagged_template_literals) using [sequelize](https://github.com/sequelize/sequelize).\n\n## Status\n\n[![npm version][npm-image]][npm-url]\n[![build status][travis-image]][travis-url]\n\n## Installation\n\nInstall the package via `npm`:\n\n```sh\nnpm install --save sequelize-sql-tag\n```\n\n## Compatibility\n\nDue to the constant changes in `sequelize`, the usage of this module varies significantly.\n\nSince versions `>=3.14.0` sequelize supports *parameterized queries*, i.e., queries that can be sent to the server separately from the arguments, which is a recommended form of protection against SQL injections. This requires installing [sequelize-sql-tag@2.0.0](https://github.com/seegno/sequelize-sql-tag/tree/v2.0.0) only as exemplified below.\n\nFrom versions `>=2.0.4 <3.14.0`, sequelize only supports text queries, i.e., queries that are sent to the server in plain text and escaped by the client (or framework). Version [sql-tag@0.0.1](https://github.com/seegno/sql-tag/tree/v0.0.1) outputs a format that is directly compatible with sequelize without requiring any additional patching.\n\nFor versions `>=1.7.0 <2.0.4`, in addition to `sql-tag@0.0.1`, a patch is required to make sequelize understand text queries as output by `sql-tag`. This patch was made available on an earlier version of this module ([sequelize-sql-tag@1.0.0](https://github.com/seegno/sequelize-sql-tag/tree/v1.0.0)).\n\n## Usage\n\n```js\nconst Sequelize = require('sequelize');\nconst sql = require('./dist/src/index.js');\nconst sequelize = new Sequelize('sqlite', 'sqlite', 'sqlite', { dialect: 'sqlite', logging: false });\n\nsequelize.query(sql`SELECT ${1 + 1} as foo`).then(console.log);\n// => [ [ { foo: 2 } ], Statement { sql: 'SELECT $1 as foo' } ]\n```\n\n## Tests\n\n```sh\nnpm test\n```\n\n## Release\n\n```sh\nnpm version [<newversion> | major | minor | patch] -m \"Release %s\"\n```\n\n## License\n\nMIT\n\n[npm-image]: https://img.shields.io/npm/v/sequelize-sql-tag.svg?style=flat-square\n[npm-url]: https://www.npmjs.com/package/sequelize-sql-tag\n[travis-image]: https://img.shields.io/travis/seegno/sequelize-sql-tag/v2.0.0.svg?style=flat-square\n[travis-url]: https://travis-ci.org/seegno/sequelize-sql-tag\n","maintainers":[{"name":"ruimarinho","email":"ruipmarinho@gmail.com"}],"time":{"modified":"2022-06-26T17:50:45.923Z","created":"2015-02-24T00:21:13.852Z","0.0.1":"2015-02-24T00:21:13.852Z","1.0.0":"2015-08-11T15:02:44.000Z","2.0.0":"2016-08-18T00:12:12.638Z","2.0.1":"2016-11-04T01:53:57.073Z","2.0.2":"2017-01-28T19:18:08.769Z"},"homepage":"https://github.com/seegno/sequelize-sql-tag","keywords":["es6","es2015","multiline","plugin","sequelize","sql","sql-tag","string","strings","tagged","template"],"repository":{"type":"git","url":"git+https://github.com/seegno/sequelize-sql-tag.git"},"author":{"name":"Rui Marinho","email":"rui.marinho@seegno.com","url":"https://github.com/ruimarinho"},"bugs":{"url":"https://github.com/seegno/sequelize-sql-tag/issues"},"license":"MIT","readmeFilename":"README.md"}