{"_id":"yesql","_rev":"24-3297d4a42ef373d5ad576a60b68a5797","name":"yesql","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","dist-tags":{"latest":"7.0.0"},"versions":{"2.5.11":{"name":"yesql","version":"2.5.11","description":"Read named SQL statements from .sql files","main":"yesql.js","scripts":{"test":"oops"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","pokemon","growth","hack"],"author":{"name":"I"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","gitHead":"8f808bf32edffc801d7d450fc8bc309c545cbe86","_id":"yesql@2.5.11","_shasum":"b455f0021dd38ffb2dd04b64639335e738b4bb21","_from":".","_npmVersion":"3.10.3","_nodeVersion":"4.4.3","_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"dist":{"shasum":"b455f0021dd38ffb2dd04b64639335e738b4bb21","tarball":"https://registry.npmjs.org/yesql/-/yesql-2.5.11.tgz","integrity":"sha512-mhNUIna1jcKnASwOvaS2jwkOhPSjT7psDS/J5rMgEgcb38nDRy6Ww1j6aje7Wv6Gk/tPQv/GUN6QibFArWC+/g==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDEhDEBAnNOL6IpYFkE7NIZer1si3I3z7FtvP7oQnduUwIgPmJaDY2uegb/EcoSJeZHjF6A1SSNNppnVANHjHSc5zY="}]},"_npmOperationalInternal":{"host":"packages-16-east.internal.npmjs.com","tmp":"tmp/yesql-2.5.11.tgz_1471221218623_0.2594704458024353"},"directories":{}},"2.6.0":{"name":"yesql","version":"2.6.0","description":"Read named SQL statements from .sql files","main":"yesql.js","scripts":{"test":"oops"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"I"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","dependencies":{"pg-prepared":"^2.5.13"},"gitHead":"b7f83ebcf190391d05369556082fd7cae72afcff","_id":"yesql@2.6.0","_shasum":"a7ee1fe4a1aa9471393c8fd0ac098119b50d021c","_from":".","_npmVersion":"3.10.3","_nodeVersion":"6.4.0","_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"dist":{"shasum":"a7ee1fe4a1aa9471393c8fd0ac098119b50d021c","tarball":"https://registry.npmjs.org/yesql/-/yesql-2.6.0.tgz","integrity":"sha512-0J3DpEKJipRCFDj7hQdySCqfRalijKmZgpDMf0lhLqpBGhC2JI0mMAh6v+c96bSb5UvMNUlFSImi+hf5uagTqQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAa3PlocmXhKBUXoL6Vgs0SSf8FRSF+dY1htXgHy1DzdAiBBXus0BsbSPOey7ZxXuDk8waOiIGzb3Qn4RMJO9QNHHQ=="}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/yesql-2.6.0.tgz_1472424619029_0.03990580793470144"},"directories":{}},"3.1.1":{"name":"yesql","version":"3.1.1","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"1.1.0","mocha":"3.1.2"},"gitHead":"2c9c28b9819881412eb284374a04e36e4d93b97c","_id":"yesql@3.1.1","_shasum":"f66cf6de67b9a16586d275c0f67390deaa369856","_from":".","_npmVersion":"3.10.9","_nodeVersion":"6.9.1","_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"dist":{"shasum":"f66cf6de67b9a16586d275c0f67390deaa369856","tarball":"https://registry.npmjs.org/yesql/-/yesql-3.1.1.tgz","integrity":"sha512-RjmyjU4XJ3OiFFJhGzQVykzDJjrc/9/EzBOFseALM7DuZnaBOap+0eOkNYMxklNmwow6CBWLAj/KVRl0SzcBcw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCoXiqFcU6rucv+kzcg5F76da/jDgppKY6r4Sl6CrJz8wIhAPaOgcYRlHZCgdEZScxN2UYcy5UY+yMlMZIELBsgzdlf"}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/yesql-3.1.1.tgz_1479323667575_0.2251072998624295"},"directories":{}},"3.1.2":{"name":"yesql","version":"3.1.2","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"1.1.0","mocha":"3.1.2"},"gitHead":"168b2dd3f7f2fa973741572bfffe582900c3d776","_id":"yesql@3.1.2","_shasum":"7e77e012b3dd449ae544cff6beb6f8b7435577b8","_from":".","_npmVersion":"3.10.9","_nodeVersion":"6.9.1","_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"dist":{"shasum":"7e77e012b3dd449ae544cff6beb6f8b7435577b8","tarball":"https://registry.npmjs.org/yesql/-/yesql-3.1.2.tgz","integrity":"sha512-6Ks5wFP1pBybByAtVa7KTOhdfea929Ev/dtcu+3DyND+yRERE+ZXEr0lv7YtmTxwAOMJNf6VNF22fGlmYkerUg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIA7NQJWFtn46BEECRZphSvVckHUw03Ubq2nj4S8xB7LQAiAwAr6tXVyozDW67rUGeS1IfTvqD7b4qqlVCH6SljFaVw=="}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/yesql-3.1.2.tgz_1479333324815_0.4544179409276694"},"directories":{}},"3.1.3":{"name":"yesql","version":"3.1.3","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"1.1.0","mocha":"3.1.2"},"gitHead":"18b541995d2d1bdc9b16e6d807ef342687e79dbe","_id":"yesql@3.1.3","_shasum":"35a99eb51156a142130fff093ece9db66b21de58","_from":".","_npmVersion":"3.10.9","_nodeVersion":"6.9.1","_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"dist":{"shasum":"35a99eb51156a142130fff093ece9db66b21de58","tarball":"https://registry.npmjs.org/yesql/-/yesql-3.1.3.tgz","integrity":"sha512-C7+eruwEZ3jMc3pQui2B1YOBOG6i0goNR2U1cD/fEemH6LOHNFjfq/RLrpH6yp/WktYY4qTbR8QxKrXU/7sTaw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDwLz84MnOPKf8yjcMBp3kyLv5CtytvIff1wRAelhIn1wIgNchlG8/eUD23ilOep1T4XKZg1cE5jWp/UBqTjZUYkT4="}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/yesql-3.1.3.tgz_1479335689972_0.9183475943282247"},"directories":{}},"3.1.4":{"name":"yesql","version":"3.1.4","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"1.1.0","mocha":"3.1.2"},"gitHead":"4489c148129611a957d9243834f78464d1c7652f","_id":"yesql@3.1.4","_shasum":"315427aa55ab048340d59ad639b4d1b79c18f0d3","_from":".","_npmVersion":"3.10.9","_nodeVersion":"6.9.1","_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"dist":{"shasum":"315427aa55ab048340d59ad639b4d1b79c18f0d3","tarball":"https://registry.npmjs.org/yesql/-/yesql-3.1.4.tgz","integrity":"sha512-3nBJhFY8jVDre4hZwDVW+bAVFfv9JLwMh9zBvu1C5x1mZRJKhJzvcydGtD9bDAEseUCf9foPO5Dn1ZtwaHE1BA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQD+o/uQ6lusvZC92TRCjvtgSLWdr1rQgCwy4DaddAqt+gIgA4OSJAewuJusjS2p66kGfOkuf2AJDqugaC6xvwESdqQ="}]},"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/yesql-3.1.4.tgz_1479335907759_0.3468943915795535"},"directories":{}},"3.1.5":{"name":"yesql","version":"3.1.5","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"1.1.0","mocha":"3.1.2"},"gitHead":"548b7d045135af5748bcf0c00038efb42600d3d7","_id":"yesql@3.1.5","_shasum":"b53fe889146eb35fd1fdc34e8ab6a8da5ccd5c5b","_from":".","_npmVersion":"4.2.0","_nodeVersion":"6.10.0","_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"dist":{"shasum":"b53fe889146eb35fd1fdc34e8ab6a8da5ccd5c5b","tarball":"https://registry.npmjs.org/yesql/-/yesql-3.1.5.tgz","integrity":"sha512-D2GJiWLSowbKKTUETjdIPh6Jdr0VV/5QSdNfPEv9OS+NScfVC7P5E2DaerhVzhrQoPp/2BFGIrlEXjlnEzkgtw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDENWHph79aa4LfgL2hKA6/HqyHbBnpL1UQVoYaT49jewIhAJvns12pNsQwMMs+1BRKMpLesv4KV5GH5ytEnB2TeWBR"}]},"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/yesql-3.1.5.tgz_1492165617564_0.19655567361041903"},"directories":{}},"3.1.6":{"name":"yesql","version":"3.1.6","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"1.2.5","mocha":"5.0.5"},"gitHead":"0a3ee875402c103f1df019cb31119282c13bdbed","_id":"yesql@3.1.6","_npmVersion":"5.6.0","_nodeVersion":"8.11.1","_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"dist":{"integrity":"sha512-6dvkkSx8qQzbSzocYtiMQNSbj7OJzUFRE3nuYyirfmOwZoX72rW8jbg8Dc+oSwY3Bjh1Fx8xR7yob1lHzB//rg==","shasum":"b4ae027e459258a63be6d5c0d4168dd5353a3cea","tarball":"https://registry.npmjs.org/yesql/-/yesql-3.1.6.tgz","fileCount":6,"unpackedSize":6429,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD6YO+T6gEGuS7fph3v9LZb2lrfjLwqw2YbtWfbUheCHQIhANU25VESHcDCLJrJEg0V4aEDnZcelThyIde6ygSo542s"}]},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/yesql_3.1.6_1523459353240_0.08215159871242328"},"_hasShrinkwrap":false},"3.2.0":{"name":"yesql","version":"3.2.0","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"1.2.5","mocha":"5.0.5"},"gitHead":"9ee94e2a01a3b7af3b3c2740542c1e1f71af3879","_id":"yesql@3.2.0","_npmVersion":"5.6.0","_nodeVersion":"8.11.1","_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"dist":{"integrity":"sha512-nfPfRlJsCGuqba3ym3QfTpL76krYKbnamx20LRPhINpW90/y5NonnC0YZBUN/Pwgd2QfRY6M9nL1PhMq2a8AzA==","shasum":"24df98fbf6b08ffadfd491f03026b514b8ea447a","tarball":"https://registry.npmjs.org/yesql/-/yesql-3.2.0.tgz","fileCount":6,"unpackedSize":6511,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDdaBJL19d/NbVc0QoWGy71bS/qu9kOZKsyTry8KUUrWQIhANoT3BpJKcZyw882JzeZL+748NtcQ30Lc+Yaf2LkXx2P"}]},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/yesql_3.2.0_1523459971500_0.5201753265204201"},"_hasShrinkwrap":false},"3.2.1":{"name":"yesql","version":"3.2.1","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"1.2.5","mocha":"5.1.0"},"gitHead":"9c6f26c753b454a1063b665f79205eaa8e88ba9e","_id":"yesql@3.2.1","_npmVersion":"5.6.0","_nodeVersion":"8.11.1","_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"dist":{"integrity":"sha512-zowedkz4QG4Y8gCxfxn1KsVWhJNsyhDgvuvQeiLqSGoDJwr19M7hJ9CsoFvGGXnRdTsLITZ21IaNpwPjIk43rg==","shasum":"ec54da6883a1752612614de66ad93787659d121a","tarball":"https://registry.npmjs.org/yesql/-/yesql-3.2.1.tgz","fileCount":6,"unpackedSize":6680,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJa0ZjECRA9TVsSAnZWagAAk98P+gNQ2eORwZAyrYqHoTlR\nm5fJ+7DxiYynfl18u0j9y78SiaLJwfs/AaEoFkbTTZhYFhfSPIxSOYAxH/a5\nQOK3DQ2/hVTn/uTKFY8pr/OKroFMa/qz+sUUAgI3Nsl0PEXP5mb7jlssMUuE\n5aPKdzbUOlHCsJlvH7RaNPb4JTUqbzbHP97z3IvH+2khdYYyV9Tqm+Hl+pys\nB4ZLg+tk2k/iyVcEwEe+PjPvJbXnYfIFmwuxFdwlEtaWWytP94HX9nByVs6W\nULodCKRzMn/9FhXXY8J84kPuQBpBfRLdwTujNHNeQNm9dAOOGy7LETJxwRUj\nDz/OWDJ5HS1YUVHtgGYZgtUlwadged0Fe9SYZ5FNvEThxewp3o6K0WHCrdV+\nO2E68u8Wu3j/M3NZJn2uliCgf51LWUsVwouRe0EffCUK4rs8Ii2h/hY+LlE4\nFNUyf4FXqguoznWd5tRkosiEFBJZFgCUrqd/tlTTg57tL6niDMs9J/WOirYJ\n4R+f6mg+Ww7Nxblk2eZCljti0xfEezCitEx1g1ShtiIoIiyxM6c0v5cuXo3t\nnE6xOIfubUAMVCAlvKDOdM/zocYodKiD/J9HUWovJCSeYUEPxJUf3uw12/kC\nAvz7rW7jOaMWp0RDFGHJIAk5AZ/rQQklxs5dA5COPapz38ajPNj6pi+181W0\nveUq\r\n=5LW7\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDHEOzihgQIfbENzhQurBuzNoiz+4NogfGnlS638p/wTAIgW6rsKdhpMHDXl6CRzq3ydbl9afcMANVKpmeSiQYQl78="}]},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/yesql_3.2.1_1523685572319_0.1255405302741417"},"_hasShrinkwrap":false},"3.2.2":{"name":"yesql","version":"3.2.2","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"2.0.3","mocha":"5.2.0"},"gitHead":"b72c4e79a2563b8c657dc15f8e96999de08724bb","_id":"yesql@3.2.2","_npmVersion":"6.4.1","_nodeVersion":"8.11.4","_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"dist":{"integrity":"sha512-KPlImZRUdX6TRN1YVbqT/4qLiB/briQpSluDO3ob9Grdi6xUtmNu+gOksuJWAsVj2/hVtpSiE5/KSjRw5OuZEw==","shasum":"fd77c1cb1d67b21ed1148ce3f3ef2984d91c70ec","tarball":"https://registry.npmjs.org/yesql/-/yesql-3.2.2.tgz","fileCount":6,"unpackedSize":6832,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJbrlt1CRA9TVsSAnZWagAA8QwP+QC4MG8RQ1J/+dNp8Eyk\nQN9AzJ4SykycOC39GOpzjYG/Iuap2pEesRh7OtJde+iFO1hB6V24tZYiy/il\nP6OQfM0OnB+I7kRYLJJ4Pdqi89KEoeTONw0ttjLpW4lVRhZ9k0lP+ZV7cNgI\nmZFpJpraDITnCBL3yKY2ZP6aVrSUntshcplHI7yzfnmJYJL5pLah5ErtAuqq\nkWwwgS3/WjbkZO1JL7/0VowWb3HcmRVb4J9dzv29PeWcA3ngUkGQC3EU/liI\nqZiXp7M7gudZTI91lVcrfgiRUqMyPlS7GIh1TGL4V3CCQ4C6k9I/k7Dd6HbE\nVnqFput1Ee+m4UUeqvmYvcRYaRd4q9+oEAnGbD2VTweKViIquxeXYB9wiums\n2Ee9AKp+KPw0mlS97bJYBWblELGWUqZ7aAKXrZIIa8RtPHuxkE1aAy5g2bfu\nEU3W0LW4lTjjBbcf7BoAA5mAAzeI9fhTXBgnkSVmMx8+gFKIy1ggqlGUgS/M\nws9KzuVPg+qOcuOrDgbWGnyey/J7C8/3SgfGAV7zatASXGzarnJ97AxzgZlQ\nndAb662wRpFwB0J8jlAVKYvQbx4Jlaahg/7pi+7ZxnTGHOGJ4gbs8Dh5oOmJ\nZfRVUdM2k7EgIuM7Ky+v/Q1iHVglS666BJFtCi9d30h3TWQlAukd2Z0z0jyW\n2eLc\r\n=sFQa\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIDY+pmWoSXFhx79bcWVa16D4+wunBT4RN5WcSbCxHyybAiA3+RETx+vrWxADIXYl8uEnWWITl4cGk/5Gg+yHUYaliw=="}]},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/yesql_3.2.2_1538153332738_0.41830653072272206"},"_hasShrinkwrap":false},"4.0.0":{"name":"yesql","version":"4.0.0","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"2.0.3","mocha":"6.2.2"},"gitHead":"60d87d1ff27fa9a82fb813b7cb9ddaf28a11d030","_id":"yesql@4.0.0","_nodeVersion":"12.13.0","_npmVersion":"6.13.2","dist":{"integrity":"sha512-nHn7iKiiyHp3WApxQKOOO3AUXrm+FaTFWUC0d8dPFxLILC9x6+BCGA+KWiK+i+YBK8FNnrEdup5JuFkTz3U5nw==","shasum":"4383b1492214a81fb2d73aca6ed50cb44def02e6","tarball":"https://registry.npmjs.org/yesql/-/yesql-4.0.0.tgz","fileCount":6,"unpackedSize":7680,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJd+89GCRA9TVsSAnZWagAApPkP/A06YgIWJNiVENnkDOzv\n0cCByQ4pxfNC9Zn3YA68mG6HykSo5gX/61iF2JR1wC8HUiirCrAjrHjVW8cW\nCO/gs25NZz/TWSedfAxz+aZEjnB2i/ex5gOrxeXgEe2Uomxybqs2zPSu1dYW\nzRve8CLvR2ZTjgXyA9HTi55GJ4yFNcC1OTnkhnrxu0j0tyRmFcqpSNAhVIAh\nuwyslRdEsjRyPVB4V6QWvSjUE7dGzAPBBcxZNfADO+s+F4sjUZJZ4d+GC3eg\nSNsNtsspWKJaf9Vtg1AjVtk303jRJUlKjqjlC4l+BqY6SlE5pBBHeSBJCKdi\nrayWY29BMXGpcviAEJviZcmvwVNNnO+P43yGzpXAlzM+E6iMcxwsOl2vrW5H\ni5WKUdAAt/Bc5slG2ZxLweUi/9U3UWLE05GCrnEyiQtQ8lMxPlTamR7aWfPn\nvlx+S1Y5wjSpcZ35XIQvpzasIbVVvXTjYgxZSfVZo3MkPweG9X+ygm4zqcwm\nsfF4+6/KkkZ+pTp6WKaDqSO7nAEvJiXBMiN6uXiJMBTxTurXWZw8Lxr3K9yi\n+Dk2kVTVfPJ3w1HlE1RQ2o0UBalq8mQfXWkATYqorwpE8eXo8EYq73xjXSVm\nEdSJlE5M/nQNec3BC0iatkFHRbrCo3FWcVKQcSpogL7ZsTA0tDcriATYm6Mv\nJ6zO\r\n=VYZ2\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIDKPJctkKzlgWDCkBrQC5gLr7+9uueHQ5BPOjWsYUvQDAiByhu+P80onRRLhd/tZroMHUpsoa01Zd2iaXxAGUFnccA=="}]},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/yesql_4.0.0_1576783685646_0.5810581495637432"},"_hasShrinkwrap":false},"4.1.0":{"name":"yesql","version":"4.1.0","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"2.0.3","mocha":"6.2.2"},"gitHead":"12601044a9321a18a885a6d042469cb5d6868adc","_id":"yesql@4.1.0","_nodeVersion":"12.13.0","_npmVersion":"6.13.2","dist":{"integrity":"sha512-ORr6uBR0r6rlbn+A9utrjIAQMO4mti6RAxJiVmwDyYrfBOB7YWuFyLUU9ypMnHDOBRLyvuU2clC0U+kPdHUYPQ==","shasum":"2c42d1cb7a02de7383bbe7a1821121546d3bbecd","tarball":"https://registry.npmjs.org/yesql/-/yesql-4.1.0.tgz","fileCount":6,"unpackedSize":10403,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJd/NfyCRA9TVsSAnZWagAA8OAP/1snrW/w9UOFkBNwHBzr\nss+lrsR2+8sXAO1cGtHJAe0g4IkIF7mp+9KMnq0vMO73b5gP4Re9ji5j1Ai1\nQNxHeiYfK3OqsAXymtfMub+CUIP6+IREHophSzyHYLnzWwAOYWpIIO6jNCM0\nWqZGU6Q2fQZ+XIt6rzrTPRCek0lRTBeAWCaOiEs+3VRraqjnCgsA4G7GyGsk\n7UMffl8lhi20gPmvaGz9npb7A7LRdhIdfP0/Teps7NO42qD1yuR0Au5yX9es\n1zoWqyBPg9sa6yJr3yVAOBxxQP24d1BxDj8jt4LV4wXlyffewI0RK+z/ZFom\n70vQ97glBEVAqM0EDa0uNVwYlzrbEfz/liceb5hd3SceE0wjDx7Wd+6BiKlL\nRLyVU7phNg20kDdw0K+upRB3kBZ9XHdXUFhtJVZSfKQOAAVmY0k7sIEQ855/\ngaAt/zr2k6q5i6hLMQ/pqumsS/+nDSKAUwW9shyJkFF4SqQ9+JxjEZCkwU+Y\nDP/BNzJ2vSBrHRnIeILopgv78oFqBba+QMUTKXZjVJwOKb9NHYgfc+KUdbD9\nbpzCmkgTSp94DqYZcQhey3no1LLJZzz/vmlwQY+k/89DYpqwQwKjoQqlGGPl\nk4C/sCmmsloYrwuy0wY7EXY8lbhESrWUnamkTfAQXxs/Ssfk6WC8wmcc3D3v\nEp7d\r\n=t5pA\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCrNNPRdoICitXMA1gIeVvw+8z4g54HYK1+8vRP5AgmOwIhAJLbJqqIjU9wObkup537gyjExI7qSfzatpbI9zuuxrAs"}]},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/yesql_4.1.0_1576851441970_0.1627785487632154"},"_hasShrinkwrap":false},"4.1.1":{"name":"yesql","version":"4.1.1","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"2.0.3","mocha":"6.2.2"},"gitHead":"1932d3a1f33c6265405d233e32b4fce266491f10","_id":"yesql@4.1.1","_nodeVersion":"12.14.1","_npmVersion":"6.13.4","dist":{"integrity":"sha512-FJBRsF/9vvklgC+mj+nL1zXq9f/RvjTSersvspsmlZYI4RyuNBBG7/7S/y9vrNilfPMwNZVTwOE3E3hLqxKagA==","shasum":"164a4b5a03af3b4db81056dba69eee16c607d349","tarball":"https://registry.npmjs.org/yesql/-/yesql-4.1.1.tgz","fileCount":6,"unpackedSize":11220,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJeJ8qiCRA9TVsSAnZWagAAJVkQAJjXK3Eu7eGBVHTI5XWp\nbxroXMZdfiM2vfGBm7eF+748pTB6cc+GW2dGze4Mj29mvk02j6jrroRjFFMg\n0opod9VzqW2rArHWKgZLALlz7CCgpBvbkcOr71rx3nTuU0Houat+632d3yuw\n9RAR8sQsemWq7IcBWCxqBoQYp47lUH/CtCwYQlJoS2K93Ce8XoqFWv8jd7bC\nyIeK0MzSmNPq8MidlwWcERTIPWeeHeYe2eG5kMWFXuNsndpc7n8ig4kMyckp\n2jSIYOLkZbqAHC+XRxNwAN4bMVsmN/YNDG/C78l++GQEERIxRfV4CozIKwgq\n5VsbcLxzGC9SYCEhRtv7SyCEUwNXcuqIGynnZJdc6cUQLvhck12nrtv5TIBw\nIQiFuDWEi0FlTNhh3Fn72Nu5nv79aaa9p1iMSPkZJphBMWdQ+lMHwQKiRpmu\nn0qm8LU3H+ICpITf/SSjhYD7Q44DJl7FmsJ8jdHP741wzqMf7jugEfdFgUL2\nSQAN7tl/um1YcGpOC69RitHBpQC3v7hel/YeWBulh5cBbulM9B36QTjMoWKy\nrfFI9MSmUP1r1Im0G3H5YIVQm3x5ayabl7l2WirxLamnTqlGneTD4RPfS5FG\nycIV/dnpjeX2NWukVObFSmqY6HC5UaSp2Bm8o53iRamy6b0ExzCAvwYWutWw\n8boD\r\n=oo3M\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDhy9dUQEIN8ia4+kf/SUvzGLJZaPLJY1b+W9zk7bRvPwIgOAElvMBlUUeOAbzsRBzLASjJZbV2IPH7pUZQKfKcdKc="}]},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/yesql_4.1.1_1579666082007_0.27221094375442734"},"_hasShrinkwrap":false},"4.1.2":{"name":"yesql","version":"4.1.2","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"3.0.1","mocha":"7.1.2"},"gitHead":"b254e03b8cc9425968d44cb950a036d9bc4694ad","_id":"yesql@4.1.2","_nodeVersion":"12.16.3","_npmVersion":"6.14.4","dist":{"integrity":"sha512-+VtlGQ5rHHOULwj+7p2Mreq0ZxPvFygZ+DYVmfMikgSLIVZu+ma5h6/fI28aF0+B+uexWkbPMSFZd0drmXa/sg==","shasum":"9ad37787d08b27ac4e41f3bce48e9d8a513c5b5d","tarball":"https://registry.npmjs.org/yesql/-/yesql-4.1.2.tgz","fileCount":6,"unpackedSize":13120,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJexmzLCRA9TVsSAnZWagAAdfYP/1/TLzmN/xweZn7iVP6D\nc3hvANUEyq7LUzg8i9yio2q+N7weujqge5XZHldS9EAt/9aOU3rh9jQYsUw4\nSfJE1bQ6tBjUNY2Gl629pKIUVyZpWGZDN/iqhn6OLwGtN23zOI5LRnMPBzQ8\nCJ8KHolxPCJ0qwaP9ucBobjbEx9n32u70zOYoTVhN1RfEwRMRW0WyOTsDWdo\nr+fFbaomr6DkkpjVWGfMSuPjzJYLDvmkBRkq1zph1ruMShSxg3GAmKj1r8tE\nsCc5m7/8p5bti+CLWTkUbKkIRz3efsJyg0G4UQQT7+2VLgEGgx6kUwR0JeUG\ns3Iz1LYlYU9EexhpYYBh05HLExNzhkIl4sfk7Lt/mj057EmLNwNXGBLk9cfr\nN/lFBrviKUljbduX8D4jniDgjtXNzsw7hZEpch/YC7mpwIaTl2+2l1O08PfU\nu2telJ22HSrVNWGG+CXssqKKi5c/MCrrXA8XbzEkrElQRU6d+V9htcMi99tJ\nH5+yDkQ4k29mE2OlsdgK/D1yHhPPK7xkSzSWAOeXahLBAWVCm75dyeP+LSOC\nMwsFyjlnTaotwZRlhnFLgdPJHe9kASw1sNc9lpFQel1eeI/q7J2vFdou4t4a\nzdkNFzitW5yhmdlKr7NyfYY0TktZ8iCDH1aQpUDPSLYISeuaoVjIDz3+Ed63\nCqlM\r\n=Wuk+\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDFK2YBIvbx+LzKUp8VkGdexKZF3FFhE+TecjNwGzBIQQIhAIqReeGG2hITqYRo2Yd8Vf3jDm+s9bH3R+yY6dvi5Rn6"}]},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/yesql_4.1.2_1590062282524_0.6975456824634372"},"_hasShrinkwrap":false},"4.1.3":{"name":"yesql","version":"4.1.3","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"3.0.1","mocha":"8.0.1"},"gitHead":"b4dd0a75ede8bcd507e028c601e1c8989d6ffa79","_id":"yesql@4.1.3","_nodeVersion":"12.18.1","_npmVersion":"6.14.5","dist":{"integrity":"sha512-AqKwYcyjWmjzNYNSah53siLLt3xTblCQcAMuw5E9TX8P4X/tRmBUFtryhjP1NwmwHEqiYHhIPGtWUdkqqPkVig==","shasum":"eb64c6e3b80c30960de0b464ae1a9780746388df","tarball":"https://registry.npmjs.org/yesql/-/yesql-4.1.3.tgz","fileCount":6,"unpackedSize":14343,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJe95wXCRA9TVsSAnZWagAAoYkP/0N29JYbY8CbgYmDIVWY\nbDNtJJ4yR0b8BQx/bdlRW0Ybp4VZDaMCXyRQx0hSyQpYnAWh9p93rp3ugGui\nLPtUe/Zbperq7duEhf7uIVKoUw2gralm7+t0C+ekNkmA+GKuXaCAUyszq4SQ\nQRTiWabcvk1/fx8JNw9awYzmO7v9SU2ypzIoich4kwR4RVUuOsZGIcucLPuW\np7SkxmOnrLExhdQ9zRr/I8RSpmzBrmCQqitrHinuqp5cvJU7fONPY0w93L9j\ndG7vZON3sDx9Z1Ax2UAu6ZwUuaKfoyuP58YG3DfK3J+srjD3yQNDLHMrkGBb\nAkhkJRIRhX1jOUpnAme+K6utjEXaYOTC7mT/p4brXa855VdPAlJ46zjI4nAB\n6HebLXhu/fVEqxGO8jCAglSZ139i9GBTYMKC4cLltJ/zecRvjac5ewoR/ZHy\nslsxtVRlKI5ax0SoUOsul0Q6RzQ2YzhHr1M2ouSCk5X8NYTB0lDe6P+W7NxQ\njMA26yM0vNWvZiO/MvHYrEB0h5JIZYmUAHQGEeUaIXRbu7a4+5zCsqDUcR6A\nHHPW7SeJH7JFpp8xdZ0LebWh1wJyvRKxF0KbzRhcFdVfnnsAGIcAzW/zEmV0\np2Ufa6dtWBNkpL5SQZjq3x7PpzyFbqvBZg4jKkNtoBZVxZl5ZT2GB9GDJkKd\nbHCQ\r\n=BWD0\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIDoCrykgEGtts7Ss95T9OWj/egTNGNcv//ah/XKRNDFjAiBEbz90/kPDcCHZY/99SQ7WRjspuEkfPcaPzMTc9teqLw=="}]},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/yesql_4.1.3_1593285654449_0.9266034943355121"},"_hasShrinkwrap":false},"5.0.0":{"name":"yesql","version":"5.0.0","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"3.0.2","mocha":"8.2.1"},"gitHead":"dcd0fa0f1d277ed2a2165f0ddb6426a8cd6f7b67","_id":"yesql@5.0.0","_nodeVersion":"12.20.0","_npmVersion":"7.0.15","dist":{"integrity":"sha512-ua4Ok0hv6Q+KPn2oJrGNRfsubYnKPLJAt6kvawG6Aqb6yg4Cm1T2JIBveFNx0aDhCIansNVq/9MFzuvmNdnJnw==","shasum":"aa6f206ff0d77618404b37567b66ca82a76bd8c8","tarball":"https://registry.npmjs.org/yesql/-/yesql-5.0.0.tgz","fileCount":6,"unpackedSize":16369,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJf1ARMCRA9TVsSAnZWagAAVEQQAJ1bBFvx9df5FSZVC+E1\nbSz1a4vkvy2l3RBAHdTcZSVqgegkUt0rUVzUVmcrS+r/X5qc/BIzhwJbpmIP\njpgggKl08+JZZmjNHefuktwLfVpQ9C4m6/JRV6Z/BWp1kz7BAxgnk8tYqKep\n8Ua1UJ4FH8xF6UzsLJckgLZ94nLOp29yYsyTVxKgI5Mf47EqNxkjgSt3ohii\nhLa1XvM321hD9oDCQv8Nh2GXpQ7SohcWa5mJBm5BZl6uWdMnKm0RmzWJR/F6\n8t8Rk2mEOa6ZV7wPi3XXl5YArQSEGKWq8fT5s3kSSg5fPt9SfwMkGypq+TFy\nx7uLJW66+QN4kEGEFsrDDWFagShYsTJSs5AftAc+lKRhMaEujM0BybPOY7Wy\nnwZLSfFPyWC1wNOxf7NAj5w08faBsYw4oN8mz2O0yRQon7wVHPem26OM9ojn\nbuuQBpcxkIZzu2yS8y+66bg7Y/CBPIy6SfBWxpkAzgYcBnGdHkS0itkU5I1e\nl7FTocfE25CfJZ15ExmNyl5q8SsjOAAR+gSUSDMkghzUl3HngAfTELj8qrAH\nPO3L3vpAhh6FnsD7AP39MX84SnD9xyeJsxJ+ZnDZqPz2GD5P/OSlBWv3mrFo\nCZXg9DxCsJct3gcRJSCYmOVY4cFE5cF5ullJkvGRmIEy1dBxgTFFmCwDpL2n\n9TTd\r\n=2LZL\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCbKywXe2V9NOvrIRzLpcXbYJ/kg9V3bLmYIvC1Zz/ERQIhAKU1fSlCNDwmR55q80vgOqn2O9lZn+qvHsQZ0cddz0YX"}]},"_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"directories":{},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/yesql_5.0.0_1607730251816_0.09511488207930086"},"_hasShrinkwrap":false},"6.0.0":{"name":"yesql","version":"6.0.0","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"3.0.3","mocha":"10.2.0"},"gitHead":"862f02328371b00837e4116c931f487a9cf95b23","_id":"yesql@6.0.0","_nodeVersion":"18.15.0","_npmVersion":"8.1.0","dist":{"integrity":"sha512-dAaWtkzbioijVYP0EK3iKcDRS5ptM5MoOT5XCvTBUUDu55lzJPBJBsN4/yJa5UFNCviNj/tqK5L8/y0zUF3xxA==","shasum":"8fa22273e5f773ce12e5512189d5e758759c3dd6","tarball":"https://registry.npmjs.org/yesql/-/yesql-6.0.0.tgz","fileCount":6,"unpackedSize":16729,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIEPW8byccAvVZpFm1CzQfOhbhzKQ9Gmh5YBym7J0OOoiAiBcCDOX+pT9Spz3A7+SEjxPVKQcj36WugSM7xmSni7+9A=="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkKYTaACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmoPHg//ZZlDh+Qt9uKVH0q9n+X9G0aL440aqavGpIucQE4all0x/OQu\r\nCw0cPlfBIBx4Go06xNceKtbd82pp7HiaeJG2RbzKXsiAk7hEKetA9G89OLQR\r\nJ2wSVKLHt20NedwBrjuqDZIOGRcg+ZViym/CilvYqm+eLiWvm9ec4StQ4nkv\r\nK5iZ5IoFuc/kHYGUK0PSUo8KvMfWgp/d+LhtXyL3LuJGTjWgdbl+z8STLRMi\r\nHiiqih40wJHNBhUOrs/yh6wNgU++wNtd2BsF1O3FABEI3y0hSu8BDpx6M+1p\r\nKeuNzdRZlGAtlFAvyhk1A07NaG/O+0vZS6jk6Mxkc9tArllChDVXtIXegn3f\r\nBGOinQtRAr3Em6xpuc4jypQvQd7vXfM6NY8Pnj65M81YhKO1RF9QCMxdVydT\r\nNsm1S5VLtRHdoDc+GD3oFOs7icWWBhRTwJ3OC8InhDWS/yerx+t+4+hHRDhv\r\nA1YcGd/2322cXqoGkwgKZJuEUpOvNkISLXcgiEaFra2huAKxVkpSnFBJYadN\r\n1VHORbc2648UverGs0KJ9QHCudXUyOhQA79ONpwsQyxXbpTELV//0KRpuE9v\r\n+a2GCQ+mEldU0san2M4gUU78X5h5MgVk/Kmq+SsIvgBXPLRikCh2zsOAE/74\r\nJTJjxDKhlwAgZfYQgXtEGGx0K+OjUw8Lh9E=\r\n=+/I1\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"directories":{},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/yesql_6.0.0_1680442586309_0.3618594441725176"},"_hasShrinkwrap":false},"6.1.0":{"name":"yesql","version":"6.1.0","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"3.0.3","mocha":"10.2.0"},"gitHead":"84546c6cec2ad63329a26008fd2263e91d3afe69","_id":"yesql@6.1.0","_nodeVersion":"16.20.0","_npmVersion":"8.1.0","dist":{"integrity":"sha512-5J0iIW2GCnIG/KsMe2tF+tMMfTAjVycxX0fX6rfI30sSGTw2AhSX6gIU6aJnk7d4bsH+d57AnAlqE+NHwH/o+w==","shasum":"7b152e488a4a9456c6910671be108b5e5bbc81f7","tarball":"https://registry.npmjs.org/yesql/-/yesql-6.1.0.tgz","fileCount":6,"unpackedSize":16930,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIFznpmVqEW79TGWB2jlhx0BKwxPz6KGwAhipojjIFFvOAiBc4CAcJAjxtW63Zk14d8OcHJNN/EIEor6tjoihqeZMsA=="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkKnmRACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmpDUA//T+W+vetkdCWnYLEfQlhn/SLOSihvbq5q7TnkVGrIFI2hFyV1\r\nodh/aizyzxV9vY0ZX0sYGqhMAKz4oAlywnNYfpWjRW9Z6gFxmTw0avpnCEda\r\nUG8+SKyRCc1YFn0HVXa0bFnzXgCjxZj7PdxW7IxKgsD7FBWQq4ERZ7UXGs9a\r\nBEPU18hSk/cLp7wlQVbu+ld1zF+rH+TOdz/DzK4u7zk51/gq+wWr0CE/TJoR\r\nA6yJZN1Gy0t3Nz0v3dGLLkqb0Up8ePulg0Vld6lV8Jt0MHujSQXZY6IIdzyB\r\ns42AINNmbT6W6NR6JHxBp2aYTaM+zZ5f/oBr7lpuKibBoRGCZSfABgv5qbtB\r\nvT/n1TGf70Gi6CrFHcZoNL/cRFkKJT6KTtrNIFuQlN+VIVYTq/5mrOwFMaQD\r\ncvt8j/pJ4lQJSZXchdFS+qEpgd5IYt5CbJup3WOkkq5x3PFD88q/hOHiWYpV\r\nJ3raOnzZPWevYQI4t6YCq7zZniWn9wmJJCG0SIkuFUuIUsjqJ5aBz9mPRp2K\r\npBYvu+n17/rUAovX+jQu6G1gUeZk9U+EbD2TeuLXim/ZJzUUFABcHf61fWXq\r\nfBgs5tjcRE183D0iZuS806WCw0vKazEkPMigOnEqlPrKHwXJCJNFMLBbhKzV\r\nB73nkIzIgjTy5SKZdLQtZUMz1T+S2Y4urAE=\r\n=qoqF\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"directories":{},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/yesql_6.1.0_1680505233144_0.29692529457603634"},"_hasShrinkwrap":false},"7.0.0":{"name":"yesql","version":"7.0.0","description":"Read named SQL statements from .sql files. Also named parameters for prepared statements.","main":"yesql.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"author":{"name":"pihvi"},"license":"ISC","bugs":{"url":"https://github.com/pihvi/yesql/issues"},"homepage":"https://github.com/pihvi/yesql#readme","devDependencies":{"assert-diff":"3.0.3","mocha":"10.2.0"},"gitHead":"8a9db42f6e5f535b8f172419b45a32a92cf1c83c","_id":"yesql@7.0.0","_nodeVersion":"18.16.0","_npmVersion":"8.1.0","dist":{"integrity":"sha512-sosfr7agy4ibLM7BvXBkM6BpBmKMGuBO8DUYQEuey+QqaqrgW+2bsSg6D050ocBYIz0PuHxUyehyzEztZTU4pw==","shasum":"7d17a73e11d6c9469c411c7be8cbff85c9ba3c27","tarball":"https://registry.npmjs.org/yesql/-/yesql-7.0.0.tgz","fileCount":6,"unpackedSize":17800,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCY3EF+YsXGdj2mo/NzbOiY4XuTnXuLqirKdyp6JSU39QIgfAY70RRWusfbTPQiC2CvOn0HckUS9YI84yl5Q3Wccls="}]},"_npmUser":{"name":"pihvi","email":"pihvi@live.com"},"directories":{},"maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/yesql_7.0.0_1690028206868_0.30814101372645397"},"_hasShrinkwrap":false}},"readme":"[![Greenkeeper badge](https://badges.greenkeeper.io/pihvi/yesql.svg)](https://travis-ci.org/pihvi/yesql) [![Known Vulnerabilities](https://snyk.io/test/npm/yesql/badge.svg)](https://snyk.io/test/npm/yesql)\n\n### Read named SQL statements from .sql files and/or use named parameters in prepared statements.\n- [Statements in .sql files](#read-named-sql-statements-from-sql-files)\n- [Raw SQL / SQLite](#raw--sqlite)\n- [MySQL / MariaDB](#mysql--mariadb)\n- [PostgreSQL](#postgresql)\n- [Handling missing parameters](#handling-missing-parameters)\n\n### Read named SQL statements from .sql files\nPut your statements in a .sql file and name them with a comment above.\ne.g. `/myproject/sql/pokemon.sql`\n```sql\n-- getPokemon\nSELECT * from pokemon\n  WHERE id = ?; -- raw style\n\n-- addPokemon\nINSERT INTO pokemon(name, price)\n  VALUES ($name, $price); -- SQLite named parameter style\n\n-- updatePokemon\nUPDATE pokemon\n  SET price = :price; -- PostgreSQL / MySQL named parameter style\n```\n\n### Raw / SQLite\nUse them in code by giving the directory where .sql files(s) are\n```javascript\nconst sql = require('yesql')('/myproject/sql/')\nconst db = new sqlite3.Database('/myproject/sql/db.sqlite3')\n\ndb.all(sql.getPokemon, 1337, (err, rows) => {...})\n\ndb\n  .prepare(sql.addPokemon)\n  .run({name: 'pikachu', price: 99}, err => {...}\n```\n\n### MySQL / MariaDB\nPrepared statements for MySQL / MariaDB are supported\n```javascript\nconst sql = require('yesql')('/myproject/sql/', {type: 'mysql'})\nconst named = require('yesql').mysql\nconst mysql = require('mysql').createConnection...\n\n// read from file\nmysql.query(sql.updatePokemon({price: 5}), (err, result) => {...})\n\n// use only named parameters\nmysql.query(named('UPDATE ::ptable SET price = :price;')({price: 5, ptable: 'pokemon'}), (err, result) => {...})\n```\n\n### PostgreSQL\nPrepared statements for node-postgres (pg) are supported\n```javascript\nconst sql = require('yesql')('/myproject/sql/',  {type: 'pg'})\nconst named = require('yesql').pg\nconst pg = require('pg').connect...\n\n// read from file\npg.query(sql.updatePokemon({price: 5}), (err, result) => {...})\n\n// use only named parameters\npg.query(named('UPDATE pokemon SET price = :price;')({price: 5}), (err, result) => {...})\n```\n\n### Handling missing parameters\nBy default MySQL and PG versions throw an error if a parameter is not given.\nPassing a flag \"useNullForMissing\" a null value is used instead.\nExample only for PG, but works for MySQL also.\n```javascript\nconst sql = require('yesql')('/myproject/sql/',  {type: 'pg', useNullForMissing: true})\nconst named = require('yesql').pg\nconst pg = require('pg').connect...\n\n// read from file and insert null values for missing parameters (price)\npg.query(sql.updatePokemon(), (err, result) => {...})\n\n// use only named parameters with nulls for missing values\npg.query(named('UPDATE pokemon SET price = :price;', {useNullForMissing: true})({}), (err, result) => {...})\n```\n\n#### Changelog\n\n##### 7.0.0\n- MySQL supports quoted strings\n  - Thanks @tbantle22 https://github.com/pihvi/yesql/issues/31\n\n##### 6.1.0\n- PG statement returning string with escaped backslash\n  - Now also working with double quoted strings\n  - Thanks @t-sky https://github.com/pihvi/yesql/issues/30\n\n##### 6.0.0\n- PG statement returning string with escaped backslash\n  - Thanks @t-sky https://github.com/pihvi/yesql/issues/30\n\n##### 5.0.0\n- Fail fast on duplicate SQL query name\n- Thanks @asafyish https://github.com/pihvi/yesql/pull/26\n- Support comments in PG\n- Thanks @dwelch2344 https://github.com/pihvi/yesql/pull/23\n\n##### 4.1.3\n- Support fully double quoted strings\n- thanks @AcerLaurinum  https://github.com/pihvi/yesql/issues/22\n\n##### 4.1.2\n- Support fully quoted strings\n- Fix regression, thanks @besk-cerity https://github.com/pihvi/yesql/issues/18\n\n##### 4.1.1\n- Fix close by parameter names in PG\n- Thanks @rockdriven https://github.com/pihvi/yesql/issues/14\n\n##### 4.1.0\n- With \"useNullForMissing\" flag enabled, use null for missing parameter\n- Thanks @dwelch2344 https://github.com/pihvi/yesql/pull/10\n\n##### 4.0.0\n- Moderner JS with arrow functions and consts\n- Support PG date format function\n- Thanks @ericxinzhang https://github.com/pihvi/yesql/issues/13\n\n##### 3.2.2\n- Allow missing slash on directory path\n- Thanks @critocrito https://github.com/pihvi/yesql/pull/9\n\n##### 3.2.1\n- Add security build and badge\n- Update deps\n\n##### 3.2.0\n- Support Windows new lines\n\n##### 3.1.6\n- Add CI build and Greenkeeper check\n- Update dev dependencies\n\n##### 3.1.5\n- Add MySQL table name as parameter to example\n\n##### 3.1.4\n- Fix pg type cast and docs\n\n##### 3.1.1\n- Support mysql prepared statements\n\n##### 2.6.0\n- Support pg prepared statements\n","maintainers":[{"name":"pihvi","email":"pihvi@live.com"}],"time":{"modified":"2023-07-22T12:16:47.274Z","created":"2016-08-15T00:33:40.269Z","2.5.11":"2016-08-15T00:33:40.269Z","2.6.0":"2016-08-28T22:50:20.841Z","3.1.1":"2016-11-16T19:14:29.468Z","3.1.2":"2016-11-16T21:55:26.866Z","3.1.3":"2016-11-16T22:34:51.676Z","3.1.4":"2016-11-16T22:38:28.427Z","3.1.5":"2017-04-14T10:26:58.199Z","3.1.6":"2018-04-11T15:09:13.310Z","3.2.0":"2018-04-11T15:19:31.612Z","3.2.1":"2018-04-14T05:59:32.407Z","3.2.2":"2018-09-28T16:48:52.916Z","4.0.0":"2019-12-19T19:28:05.740Z","4.1.0":"2019-12-20T14:17:22.128Z","4.1.1":"2020-01-22T04:08:02.167Z","4.1.2":"2020-05-21T11:58:02.670Z","4.1.3":"2020-06-27T19:20:54.597Z","5.0.0":"2020-12-11T23:44:11.968Z","6.0.0":"2023-04-02T13:36:26.516Z","6.1.0":"2023-04-03T07:00:33.295Z","7.0.0":"2023-07-22T12:16:47.088Z"},"homepage":"https://github.com/pihvi/yesql#readme","keywords":["sql","named","parameter","prepared","statement","pg","postgres","node-pg","node-postgres","mysql","pokemon","hack","growth"],"repository":{"type":"git","url":"git+ssh://git@github.com/pihvi/yesql.git"},"author":{"name":"pihvi"},"bugs":{"url":"https://github.com/pihvi/yesql/issues"},"license":"ISC","readmeFilename":"README.md","users":{"aliem":true}}