{"_id":"slicks-mysql","_rev":"32-44439368f8bc788c3c3235f136805bec","name":"slicks-mysql","description":"Allows the writing of expressive database queries.","dist-tags":{"latest":"1.2.6"},"versions":{"0.2.0":{"name":"slicks-mysql","version":"0.2.0","description":"Allows the writing of expressive database queries and routines for MySQL.","main":"dist/slicks-mysql","scripts":{"test":"make test"},"dependencies":{"mysql":"~2.0.1","underscore":"~1.5.2","string-format-js":"~0.1.1"},"keywords":["slicks","slickers","db","database","mysql","node","javascript"],"repository":{"type":"git","url":"git://github.com/steveesamson/slicks-mysql.git"},"author":{"name":"Steve Samson","email":"stevee.samson@gmail.com"},"licenses":[{"type":"MIT","url":"https://github.com/steveesamson/slicks-mysql/blob/master/MIT-License.txt"}],"devDependencies":{"mocha":"~1.17.1","chai":"~1.9.0"},"bugs":{"url":"https://github.com/steveesamson/slicks-mysql/issues"},"_id":"slicks-mysql@0.2.0","dist":{"shasum":"08616f660b59d06faca758f545250dc08d69f4ae","tarball":"https://registry.npmjs.org/slicks-mysql/-/slicks-mysql-0.2.0.tgz","integrity":"sha512-s+bEMG2gr/1l0zCKs87FyRShcClbLOkEGwMMiewtm5wtOSu5NqVH3H0R3vm+5Hf0CSs7kRfVyCETuWOtzNDsbA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAnrF4+dUGTsb8lGTVqTvUtrFv47H7rU29NypB005tXEAiB7BXFsQBzRSqwF8NslgjpOh385ummxnZJjdQhgy8wNRg=="}]},"_from":".","_npmVersion":"1.3.6","_npmUser":{"name":"steveesamson","email":"stevee.samson@gmail.com"},"maintainers":[{"name":"steveesamson","email":"stevee.samson@gmail.com"}],"directories":{}},"0.1.1":{"name":"slicks-mysql","version":"0.1.1","description":"Allows the writing of expressive database queries and routines for MySQL.","main":"dist/slicks-mysql","scripts":{"test":"make test"},"dependencies":{"mysql":"~2.0.1","underscore":"~1.5.2","string-format-js":"~0.1.1"},"keywords":["slicks","slickers","db","database","mysql","node","javascript"],"repository":{"type":"git","url":"git://github.com/steveesamson/slicks-mysql.git"},"author":{"name":"Steve Samson","email":"stevee.samson@gmail.com"},"licenses":[{"type":"MIT","url":"https://github.com/steveesamson/slicks-mysql/blob/master/MIT-License.txt"}],"devDependencies":{"mocha":"~1.17.1","chai":"~1.9.0"},"bugs":{"url":"https://github.com/steveesamson/slicks-mysql/issues"},"_id":"slicks-mysql@0.1.1","dist":{"shasum":"5b1a576bcccb9c9bd979eba020cfeb400860426b","tarball":"https://registry.npmjs.org/slicks-mysql/-/slicks-mysql-0.1.1.tgz","integrity":"sha512-BcV/rL9BCFoBBLaryxykg80oljGGMsrEa/RlnMkyECfXtpnviqs39k9+zZzBiVupHJnQ7+sGqc7pkBcCfBtJvg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCdEt3gFeZQ/7lqiJVaiMPdwN597ujh5pH9gEvmnfoAfgIhAMvn3aFN7T2sigrH3v97+Ia1Qu52eEBXUVjlfgvPkj6B"}]},"_from":".","_npmVersion":"1.3.6","_npmUser":{"name":"steveesamson","email":"stevee.samson@gmail.com"},"maintainers":[{"name":"steveesamson","email":"stevee.samson@gmail.com"}],"directories":{}},"1.0.0":{"name":"slicks-mysql","version":"1.0.0","description":"Allows the writing of expressive database queries.","main":"dist/slicks-mysql","scripts":{"test":"make test"},"keywords":["slicks","db","database","mysql","nodejs","javascript"],"repository":{"type":"git","url":"git://github.com/steveesamson/slicks-mysql.git"},"author":{"name":"Steve Samson","email":"stevee.samson@gmail.com"},"licenses":[{"type":"MIT","url":"https://github.com/steveesamson/slicks-mysql/blob/master/MIT-License.txt"}],"devDependencies":{"mocha":"~1.17.1","chai":"~1.9.0"},"bugs":{"url":"https://github.com/steveesamson/slicks-mysql/issues"},"_id":"slicks-mysql@1.0.0","_from":".","dependencies":{"mysql":"^2.11.1","string-format-js":"^0.1.8","underscore":"^1.8.3"},"homepage":"https://github.com/steveesamson/slicks-mysql#readme","_shasum":"8dbf6fccd9e6eb10e225b6e95baab3f986b9dfdb","_npmVersion":"2.15.5","_nodeVersion":"4.4.5","_npmUser":{"name":"steveesamson","email":"stevee.samson@gmail.com"},"dist":{"shasum":"8dbf6fccd9e6eb10e225b6e95baab3f986b9dfdb","tarball":"https://registry.npmjs.org/slicks-mysql/-/slicks-mysql-1.0.0.tgz","integrity":"sha512-Hepba3jizJIm6kfspQXSFhLOGneDcjdOwZB9sCyna0DlK6M2g+N7dWk2hGaCa256TNIqkhsxdm/wbeLahUQeKg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDcgM7kfnIdjusQWFDeghw+qQuTpcpt+WJpAfCbz4muKwIgPCPf0hBNynIZspr1TGh0mOdaXpsp2HugGKbCoKjADuM="}]},"maintainers":[{"name":"steveesamson","email":"stevee.samson@gmail.com"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/slicks-mysql-1.0.0.tgz_1466514259691_0.7449314740952104"},"directories":{}},"1.1.0":{"name":"slicks-mysql","version":"1.1.0","description":"Allows the writing of expressive database queries.","main":"dist/slicks-mysql","scripts":{"test":"make test"},"keywords":["slicks","db","database","mysql","nodejs","javascript"],"repository":{"type":"git","url":"git://github.com/steveesamson/slicks-mysql.git"},"author":{"name":"Steve Samson","email":"stevee.samson@gmail.com"},"licenses":[{"type":"MIT","url":"https://github.com/steveesamson/slicks-mysql/blob/master/MIT-License.txt"}],"devDependencies":{"mocha":"~1.17.1","chai":"~1.9.0"},"bugs":{"url":"https://github.com/steveesamson/slicks-mysql/issues"},"_id":"slicks-mysql@1.1.0","_from":".","dependencies":{"mysql":"^2.11.1","string-format-js":"^0.1.8","underscore":"^1.8.3"},"homepage":"https://github.com/steveesamson/slicks-mysql#readme","_shasum":"5f1b0e247d0ab122c91cc38654527080ff3d5968","_npmVersion":"2.15.5","_nodeVersion":"4.4.5","_npmUser":{"name":"steveesamson","email":"stevee.samson@gmail.com"},"dist":{"shasum":"5f1b0e247d0ab122c91cc38654527080ff3d5968","tarball":"https://registry.npmjs.org/slicks-mysql/-/slicks-mysql-1.1.0.tgz","integrity":"sha512-O5/Hb072Riwt4koe5Duicr/zrtfTHVsifCllYFl5Wsg8yiS9vLg6zHgbx87EC4SuKZUdOMe0iqTidiXqY5pM6Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICyBc4hGXKHBnXcnAhaqarXjA03qTuZoQ/00H+A+M6hjAiEAv4fkd1fwVFthhWp7wcNhd6ghVR4QXkW19uu+2oRh28o="}]},"maintainers":[{"name":"steveesamson","email":"stevee.samson@gmail.com"}],"_npmOperationalInternal":{"host":"packages-16-east.internal.npmjs.com","tmp":"tmp/slicks-mysql-1.1.0.tgz_1466514606761_0.5005972811486572"},"directories":{}},"1.2.0":{"name":"slicks-mysql","version":"1.2.0","description":"Allows the writing of expressive database queries.","main":"dist/slicks-mysql","license":"MIT","scripts":{"test":"make test"},"keywords":["slicks","db","database","mysql","nodejs","javascript"],"repository":{"type":"git","url":"git://github.com/steveesamson/slicks-mysql.git"},"author":{"name":"Steve Samson","email":"stevee.samson@gmail.com"},"licenses":[{"type":"MIT","url":"https://github.com/steveesamson/slicks-mysql/blob/master/MIT-License.txt"}],"devDependencies":{"mocha":"~1.17.1","chai":"~1.9.0"},"bugs":{"url":"https://github.com/steveesamson/slicks-mysql/issues"},"_id":"slicks-mysql@1.2.0","_from":".","dependencies":{"mysql":"^2.11.1","string-format-js":"^0.1.8","underscore":"^1.8.3"},"gitHead":"cea0ed573d5525d4528249a493f72d41b7b8221e","homepage":"https://github.com/steveesamson/slicks-mysql#readme","_shasum":"e8ee114e95d8968a51b9c6ee469878ce6e682cdb","_npmVersion":"2.15.5","_nodeVersion":"4.4.5","_npmUser":{"name":"steveesamson","email":"stevee.samson@gmail.com"},"dist":{"shasum":"e8ee114e95d8968a51b9c6ee469878ce6e682cdb","tarball":"https://registry.npmjs.org/slicks-mysql/-/slicks-mysql-1.2.0.tgz","integrity":"sha512-a/PG00xo8XEYqlb/PzJSnjqzqAObxFWkZCuAS5J5zMveg0BvjqJk2WtAr0zbPr0n4ltsvRVebvW7ZAgdE5tdSA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDS6Pb/piudF3mRvHbwWnqM6BCKzcvnK+OiqZWnCf3wrwIhAMI5ZlX02lN/L93MsvbqrOOwkqt3MLXesCbiWM/v2fzq"}]},"maintainers":[{"name":"steveesamson","email":"stevee.samson@gmail.com"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/slicks-mysql-1.2.0.tgz_1466516345395_0.8354864409193397"},"directories":{}},"1.2.1":{"name":"slicks-mysql","version":"1.2.1","description":"Allows the writing of expressive database queries.","main":"dist/slicks-mysql","license":"MIT","scripts":{"test":"./node_modules/mocha/bin/mocha --ui tdd --recursive ./test"},"keywords":["slicks","db","database","mysql","nodejs","javascript"],"repository":{"type":"git","url":"git://github.com/steveesamson/slicks-mysql.git"},"author":{"name":"Steve Samson","email":"stevee.samson@gmail.com"},"licenses":[{"type":"MIT","url":"https://github.com/steveesamson/slicks-mysql/blob/master/MIT-License.txt"}],"devDependencies":{"mocha":"~1.17.1","chai":"~1.9.0"},"bugs":{"url":"https://github.com/steveesamson/slicks-mysql/issues"},"_id":"slicks-mysql@1.2.1","_from":".","dependencies":{"mysql":"^2.11.1","string-format-js":"^0.1.8","underscore":"^1.8.3"},"gitHead":"f63a29064e82c93019ec2e8bc35918d0a1544a88","homepage":"https://github.com/steveesamson/slicks-mysql#readme","_shasum":"4ef4460a8a21aa7374225e20d5def2b761076ee9","_npmVersion":"3.9.5","_nodeVersion":"6.2.2","_npmUser":{"name":"steveesamson","email":"stevee.samson@gmail.com"},"dist":{"shasum":"4ef4460a8a21aa7374225e20d5def2b761076ee9","tarball":"https://registry.npmjs.org/slicks-mysql/-/slicks-mysql-1.2.1.tgz","integrity":"sha512-p29SO8spcu+VNyyYi+m5HBk09yhy7jFzf52KvEmABlcbyOe1ruZj3AAz2IJJ83Zjio/B7cN5ZAlX6zSjzWRzug==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIDoteQTHUpmYfaYDnDU4RO9rOt/3DCdkJLlubO6TcCI4AiB7t7fGjFZ9iJ75Y4nXJ/fNa6kap/4TKd7L9RbrOu8Q2w=="}]},"maintainers":[{"name":"steveesamson","email":"stevee.samson@gmail.com"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/slicks-mysql-1.2.1.tgz_1489400370548_0.6035719828214496"},"directories":{}},"1.2.2":{"name":"slicks-mysql","version":"1.2.2","description":"Allows the writing of expressive database queries.","main":"dist/slicks-mysql","license":"MIT","scripts":{"test":"./node_modules/mocha/bin/mocha --ui tdd --recursive ./test"},"keywords":["slicks","db","database","mysql","nodejs","javascript"],"repository":{"type":"git","url":"git://github.com/steveesamson/slicks-mysql.git"},"author":{"name":"Steve Samson","email":"stevee.samson@gmail.com"},"licenses":[{"type":"MIT","url":"https://github.com/steveesamson/slicks-mysql/blob/master/MIT-License.txt"}],"devDependencies":{"mocha":"~1.17.1","chai":"~1.9.0"},"bugs":{"url":"https://github.com/steveesamson/slicks-mysql/issues"},"_id":"slicks-mysql@1.2.2","_from":".","dependencies":{"mysql":"^2.11.1","string-format-js":"^0.1.8","underscore":"^1.8.3"},"gitHead":"44402a8b63f1fd3b81299a5fb5c29d316b55c156","homepage":"https://github.com/steveesamson/slicks-mysql#readme","_shasum":"9e687e1d7353d7c431ffd354cf6ee8015d0f5026","_npmVersion":"3.9.5","_nodeVersion":"6.2.2","_npmUser":{"name":"steveesamson","email":"stevee.samson@gmail.com"},"dist":{"shasum":"9e687e1d7353d7c431ffd354cf6ee8015d0f5026","tarball":"https://registry.npmjs.org/slicks-mysql/-/slicks-mysql-1.2.2.tgz","integrity":"sha512-3I/8vT0Hm+CDvr0QgvPoDdyVioKjYtPzjco7luyg4ATRfz+a6uMYUvt6TidKMgOkijCh1bF27T8V7okQEH9tTA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDBMVamw6EmUey+v5IdncxpYvKzGASZeLViNZpHRzU5SwIhALKHkAO5H7ferYwObllJw79Jy19K8rGU/E+OB5Fy9l2G"}]},"maintainers":[{"name":"steveesamson","email":"stevee.samson@gmail.com"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/slicks-mysql-1.2.2.tgz_1489672231310_0.9370828492101282"},"directories":{}},"1.2.3":{"name":"slicks-mysql","version":"1.2.3","description":"Allows the writing of expressive database queries.","main":"dist/slicks-mysql","license":"MIT","scripts":{"test":"./node_modules/mocha/bin/mocha --ui tdd --recursive ./test"},"keywords":["slicks","db","database","mysql","nodejs","javascript"],"repository":{"type":"git","url":"git://github.com/steveesamson/slicks-mysql.git"},"author":{"name":"Steve Samson","email":"stevee.samson@gmail.com"},"licenses":[{"type":"MIT","url":"https://github.com/steveesamson/slicks-mysql/blob/master/MIT-License.txt"}],"devDependencies":{"mocha":"~1.17.1","chai":"~1.9.0"},"bugs":{"url":"https://github.com/steveesamson/slicks-mysql/issues"},"_id":"slicks-mysql@1.2.3","_from":".","dependencies":{"mysql":"^2.11.1","string-format-js":"^0.1.8","underscore":"^1.8.3"},"gitHead":"ebbbe4055d37a142e004b827ffb65aa2480b90ce","homepage":"https://github.com/steveesamson/slicks-mysql#readme","_shasum":"0457acf570aee02bf1917b5e294209b7361794ea","_npmVersion":"3.9.5","_nodeVersion":"6.2.2","_npmUser":{"name":"steveesamson","email":"stevee.samson@gmail.com"},"dist":{"shasum":"0457acf570aee02bf1917b5e294209b7361794ea","tarball":"https://registry.npmjs.org/slicks-mysql/-/slicks-mysql-1.2.3.tgz","integrity":"sha512-+n+AD+ejBcyQCulXtW1k5M7n+LtHdI/Lzv02QTRPurR6I9zN9Kf1xmh0OBcBX9SGb25gKLFGIh4k1yH7WauT5w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCVJGn31ZO9wWH6faMgwfsf+aK2gzGx6Xg6PIM9UmbFJAIgWvg45Qz90vbT6qIN66TkYTYW4nIrpZ3C4zXnNttagUs="}]},"maintainers":[{"name":"steveesamson","email":"stevee.samson@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/slicks-mysql-1.2.3.tgz_1498420114458_0.41169070499017835"},"directories":{}},"1.2.4":{"name":"slicks-mysql","version":"1.2.4","description":"Allows the writing of expressive database queries.","main":"dist/slicks-mysql","license":"MIT","scripts":{"test":"./node_modules/mocha/bin/mocha --ui tdd --recursive ./test"},"keywords":["slicks","db","database","mysql","nodejs","javascript"],"repository":{"type":"git","url":"git://github.com/steveesamson/slicks-mysql.git"},"author":{"name":"Steve Samson","email":"stevee.samson@gmail.com"},"licenses":[{"type":"MIT","url":"https://github.com/steveesamson/slicks-mysql/blob/master/MIT-License.txt"}],"devDependencies":{"mocha":"~1.17.1","chai":"~1.9.0"},"bugs":{"url":"https://github.com/steveesamson/slicks-mysql/issues"},"_id":"slicks-mysql@1.2.4","_from":".","dependencies":{"mysql":"^2.11.1","string-format-js":"^0.1.8","underscore":"^1.8.3"},"gitHead":"4273949d752d9187f7f15427cbb03dd27146fd1e","homepage":"https://github.com/steveesamson/slicks-mysql#readme","_shasum":"7da5fdf4aeeb2aabc3f73cc2a424791bf921d080","_npmVersion":"3.10.10","_nodeVersion":"6.12.0","_npmUser":{"name":"steveesamson","email":"stevee.samson@gmail.com"},"dist":{"shasum":"7da5fdf4aeeb2aabc3f73cc2a424791bf921d080","tarball":"https://registry.npmjs.org/slicks-mysql/-/slicks-mysql-1.2.4.tgz","fileCount":8,"unpackedSize":53490,"integrity":"sha512-7Vf2Z2N5QMj2mY+GiFrW0lpkPl70dkJPdHzhuSJTTSUE/uGJqfXEicJQsr4mLd1lm06xbPJj0gV0tIphyXCN3g==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDPPoXqr26/B4fRCe9LKAaDkBdc/Ae4gLYbNuRuzIEvQwIhAKLUGxQp5uQM/beqGI4jrYlbqivHihKYrNB1NceiOdVi"}]},"maintainers":[{"name":"steveesamson","email":"stevee.samson@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/slicks-mysql_1.2.4_1519918714935_0.8470674265149565"},"_hasShrinkwrap":false},"1.2.5":{"name":"slicks-mysql","version":"1.2.5","description":"Allows the writing of expressive database queries.","main":"dist/slicks-mysql","license":"MIT","scripts":{"test":"./node_modules/mocha/bin/mocha --ui tdd --recursive ./test"},"keywords":["slicks","db","database","mysql","nodejs","javascript"],"repository":{"type":"git","url":"git://github.com/steveesamson/slicks-mysql.git"},"author":{"name":"Steve Samson","email":"stevee.samson@gmail.com"},"licenses":[{"type":"MIT","url":"https://github.com/steveesamson/slicks-mysql/blob/master/MIT-License.txt"}],"devDependencies":{"mocha":"~1.17.1","chai":"~1.9.0"},"bugs":{"url":"https://github.com/steveesamson/slicks-mysql/issues"},"_id":"slicks-mysql@1.2.5","_from":".","dependencies":{"mysql":"^2.11.1","string-format-js":"^0.1.8","underscore":"^1.8.3"},"gitHead":"7b43dac49739ddb44e44496dbb826b56dfe0d7c4","homepage":"https://github.com/steveesamson/slicks-mysql#readme","_shasum":"2da8b95a8f96cb2bede359b552279c0114200c61","_npmVersion":"3.9.5","_nodeVersion":"6.2.2","_npmUser":{"name":"steveesamson","email":"stevee.samson@gmail.com"},"dist":{"shasum":"2da8b95a8f96cb2bede359b552279c0114200c61","tarball":"https://registry.npmjs.org/slicks-mysql/-/slicks-mysql-1.2.5.tgz","integrity":"sha512-kTl9lBt5r9IlVR9qVG7HwkQCmRke0wUbM+BsznFZRAPZh+zYXDvZx2Gbw/NTU3hq6UCEc2HCxXi5Opoxc0F9Uw==","fileCount":8,"unpackedSize":53498,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJbfE9QCRA9TVsSAnZWagAAR5UP/itVDwdqkgqoUSYZiIQL\n21zoI+y7izyvoJjf9U/ev9ft3im9QiKnhS73XcVZVwCt9bGw+Q3DMzGVNPe8\nh1M1YRZulVtCxOO21INN5K+7V94ZQX7I71sKBlZfhYHkrEjEcqne0EzVzuja\n8cns7NhtGU1xzFbzAYpjdH78rn+4RVAvW5p2ogMEXJf1hWkkEQboVmkATXVT\nJDNU83ICO3/OPQnLK9HA94JgMhAD8zM7ItyjsAMeUMhlilK3FpY4gLuNA+fK\nElPRqIb7VqUasR4PlIq5AjarnvlaAA/LlSlQDyUfyvba9BRj1WOgiMa75Cy2\nhlU+Y08p9lC63efHzUTahVWSv/wP9QakeSP6JV7TcHqrA4uav/Bh+s4TGV2w\nzuhYlKTcwx2Gnhvi8shWcsyqVkHjq3l26wTEq93agifmRpYrkv6gue8QPKbS\nPKNn+mLm75VHRqNyg2r4GLYCAyiRMA/rtIInVItwntecbXRkXB3vN7OgNV0H\n/vuYvDadMvgoAzHDe18tZObJml85siz9JW+l4Cuio1aiUhUN8yNqO4MxkypA\nN8lmH2OcKSIjX+KJe6Wobf6k3iH7zDt4aO7ugJZd3S+WHcTsqMxDve1DDW2y\ngmJFvwsWaTGtw6BuBIEv6T8WAcdRVgfTtLwvnSlYFgIkGiAGbfetEu4q47ol\nissf\r\n=MwP4\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICxFa+kj7qfwIHn5HDQf7hmSHg/5y9QsV/0Qfg276Xi0AiEAtgcRgBsxrwTNoJqzvRMKWkLAfynYEm4BKLfu4zDz504="}]},"maintainers":[{"name":"steveesamson","email":"stevee.samson@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/slicks-mysql_1.2.5_1534873423708_0.6233575433736522"},"_hasShrinkwrap":false},"1.2.6":{"name":"slicks-mysql","version":"1.2.6","description":"Allows the writing of expressive database queries.","main":"dist/slicks-mysql","license":"MIT","scripts":{"test":"./node_modules/mocha/bin/mocha --ui tdd --recursive ./test"},"keywords":["slicks","db","database","mysql","nodejs","javascript"],"repository":{"type":"git","url":"git://github.com/steveesamson/slicks-mysql.git"},"author":{"name":"Steve Samson","email":"stevee.samson@gmail.com"},"licenses":[{"type":"MIT","url":"https://github.com/steveesamson/slicks-mysql/blob/master/MIT-License.txt"}],"devDependencies":{"mocha":"~1.17.1","chai":"~1.9.0"},"bugs":{"url":"https://github.com/steveesamson/slicks-mysql/issues"},"_id":"slicks-mysql@1.2.6","_from":".","dependencies":{"mysql":"^2.11.1","string-format-js":"^0.1.8","underscore":"^1.8.3"},"gitHead":"bd9c61d193f0f98c066d8c9b926bcdc383c0a323","homepage":"https://github.com/steveesamson/slicks-mysql#readme","_shasum":"0b1ae89cc4a2722a9d06325b92bf14c25825d65e","_npmVersion":"3.10.10","_nodeVersion":"6.12.0","_npmUser":{"name":"steveesamson","email":"stevee.samson@gmail.com"},"dist":{"shasum":"0b1ae89cc4a2722a9d06325b92bf14c25825d65e","tarball":"https://registry.npmjs.org/slicks-mysql/-/slicks-mysql-1.2.6.tgz","integrity":"sha512-2Klbes9Xth0T4ECddp1mll/MMERtxfd4Z0Y3R+9fONRpLFqrDu8gDdNMhhJazF6QRQ7QibJntntfw8FjC6PR0w==","fileCount":8,"unpackedSize":53610,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJcTewXCRA9TVsSAnZWagAA6wIP/0iDFo5BhgcBIypuPSRc\nbxDJKbX3hjRwKxXKSQLI8jjsqKK1lS29g3WBE93jv12aKBmUz8kwwI2d7kbe\n/fkDsEGsRQFK9yIVPwzbrQ5vXpEsCMN6dbdF19q/CpJeKChNapc/ZVOjleYT\nstJKPmOcQoYt97nOwYVpQoo63mAtfUDTQAly0CelrfueR+0vPJqIVH/Lk5rO\nJMDJeOZ2W4sJeW3GV+Ru63UwuuKTVf6lvAUrfI9Xx87Xdx275vGdB1V7i1+A\nXZWNjOi6Xevo8J2DBJTo5P3HXht+WbnVBiIqwYqVdsV+1RlX9oPFY04eQOqp\nKZosWpYtYa3kWJlpFBKnXGyObvNsLj1nP6V0sb9QAz3+pBaJVkGlkNPWBvlu\nmharxAN66L1IuYl2Hq+98Soc6YhCm5WEz3ES+K+pzJhvCdQXVRnHpv8CQSqY\n3DpoF20TwuKG7hZSd+be3iT4KNpw4tTErKqVZrmNEw8wJHA0psGiQPgGQgDW\nQ9asp8VbnnytRYPQX3YOSRarKjcAJJ3vidFkbr/WX5C+DvgaLP9k746CQq1C\nEE+7eJFrFg+P3/MpGMH+PupykRuo7s9so5wBiM0ZcAgI8PSinbnj3HbyG8UB\nsbfBNv/IoiiiIdrp0zHB/GfDx+0ueEjRcJgoxHMs3Rzw+MqXHCm2iTlCkoBu\nWjAs\r\n=mNfb\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBuxztrnuBf8qkJynj0EeFhRZsAwixtkl5HhNg9GeQ1wAiAdfC2SeLjqjMuWCfqMgRCsF4SyuFREnneAaKETZJhLoQ=="}]},"maintainers":[{"name":"steveesamson","email":"stevee.samson@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/slicks-mysql_1.2.6_1548610582503_0.053496910402761166"},"_hasShrinkwrap":false}},"readme":"#slicks-mysql\n\nslicks-mysql allows the expressive writing of database queries and routines. slicks-mysql permit chaining, which is intuitive as you can nearly guess what should come next even if you are just getting started with slicks-mysql. slicks-mysql is not an ORM. It was developed to allow folks coming from relational databases background write expressive queries with object interactions in mind.\nInspired by **`Codeigniter Active Record`**.\n\n##slicks-mysql options\nslicks-mysql takes all the options/config allowed by `node-mysql`. Please see https://www.npmjs.org/package/mysql for details. It also has, in addition, `debug_db` option which could be `true/false`. `debug_db` enables the logging of the raw queries to the console when it is set to *true*, useful while developing.\n\n\n## Installation\n\n```cli\n  npm install slicks-mysql --save\n```\n\n## Usage\n\nUsing slicks-mysql is pure joy:\n\n```javascript\n\n       var options = {\n                host: 'localhost',\n                user: 'steve',\n                dateStrings: true,\n                database: 'todo',\n                password: 'steve-secret',\n                //If the following was enabled, your queries will be logged to console\n                //debug_db: true\n            },\n           slicks_mysql = require('slicks-mysql')(options);\n           //Let us now connect and get a db object\n           slicks_mysql.connect(function(err, db){\n                if(err){\n                    throw err;\n                }\n                console.log('Connected!');\n\n                //Do db stuffs here\n\n           });\n```\n\n##slicks-mysql management\n\nNow that we have a valid `db` object, how do we manage it? Well, all connections on `db` are automatically pooled, thus, to release a `db` object, it is done with `db.release()`; this returns the current connection on the `db` to the pool, however, to actually close the connection, use `db.destroy()`; this does the cleanup and closes the underlying connection to database.\n\n\n##`fetch`ing records\n\n```javascript\n\n     db.fetch('todo', function (err, rows) {\n        if (err) {\n            throw err;\n        }\n        console.log(rows);\n\n    });\n```\n\nThe above is used when all record fields are needed. However, if a subset of the fields are of interest, **`select`** with **`from`** and **`fetch`** is the way to go.\n\n##`select`ing records\n\n```javascript\n\n      db.select('task, task_owner')\n         .from('todo')\n         .fetch(function (err, rows) {\n             if (err) {\n                 throw err;\n             }\n             console.log(rows);\n         });\n```\n\n##`query`ing records with `query`\n\n```javascript\n\n    var q = \"select * from todo\";\n        db.query(q, function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n        });\n```\n\n**Note:** The use of ONLY **`fetch`** or in conjunction with **`select`** and **`from`** does not change the outcome. I think it just depends on what flavour you like or the need at hand. That being said, all the examples are written in one or other flavour but what was done in one flavour can equally be done in the other flavour.\n\n###`where`\n```javascript\n\n     db.where('id', 1)\n       .fetch('todo', function (err, rows) {\n             if (err) {\n                 throw err;\n             }\n              console.log(rows);\n         });\n```\n\n```javascript\n\n     db.where('id >', 1)\n       .fetch('todo', function (err, rows) {\n             if (err) {\n                 throw err;\n             }\n              console.log(rows);\n         });\n```\n\n```javascript\n\n     db.where('id <', 10)\n       .fetch('todo', function (err, rows) {\n             if (err) {\n                 throw err;\n             }\n              console.log(rows);\n         });\n```\n\n```javascript\n\n     db.where('id >=', 1)\n       .fetch('todo', function (err, rows) {\n             if (err) {\n                 throw err;\n             }\n              console.log(rows);\n         });\n```\n\n```javascript\n\n     db.where('id <=', 10)\n       .fetch('todo', function (err, rows) {\n             if (err) {\n                 throw err;\n             }\n              console.log(rows);\n         });\n```\n\n###`where`, `orWhere`, `whereIn`, `orWhereIn`, `whereNotIn`, `orWhereNotIn` conditions\nPlease, note that all the variations that apply to **`where`** also apply to the following: `orWhere`, `whereIn`, `orWhereIn`, `whereNotIn`, `orWhereNotIn`.\n\n###`orWhere`\n```javascript\n\n     db.where('id', 10)\n       .orWhere('task_owner', 1)\n       .fetch('todo', function (err, rows) {\n             if (err) {\n                 throw err;\n             }\n              console.log(rows);\n         });\n```\n\n###`whereIn`\n\n```javascript\n\n    db.select('todo.*') //I could have used fetch directly here too\n      .from('todo')\n      .whereIn('id', \"1,3\")\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`orWhereIn`\n\n```javascript\n\n    db.select('todo.*') //I could have used fetch directly here too\n      .from('todo')\n      .where('id', 2)\n      .orWhereIn('id', \"1,3\")\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`whereNotIn`\n\n```javascript\n\n    db.select('todo.*') //I could have used fetch directly here too\n      .from('todo')\n      .whereNotIn('id', \"1,2,3\")\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`orWhereNotIn`\n\n```javascript\n\n    db.select('todo.*') //I could have used fetch directly here too\n      .from('todo')\n      .where('id', 2)\n      .orWhereNotIn('id', \"1,3\")\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`like`\n\nGenerates `task like %vacuum%` , **`b`** or **`both`**  for both ends are allowed.\n\n```javascript\n\n    db.select('todo.*') //I could have used fetch directly here too\n      .from('todo')\n      .like('task', 'vacuum', 'b')\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`orLike`\n\nGenerates `task like '%vacuum' or task like 'iron%'` , **`l`** or **`left`**  for left end are allowed, while **`r`** or **`right`**  for right end are allowed.\n\n```javascript\n\n    db.select('todo.*') //I could have used fetch directly here too\n      .from('todo')\n      .like('task', 'vacuum', 'l')\n      .orLike('task', 'iron', 'r')\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`notLike`\n\nGenerates `task NOT like '%vacuum%'` , **`b`** or **`both`**  for both ends are allowed.\n\n```javascript\n\n    db.select('todo.*') //I could have used fetch directly here too\n      .from('todo')\n      .notLike('task', 'vacuum', 'b')\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`orNotLike`\n\nGenerates `OR task NOT like '%dishes'` , **`l`** or **`left`**  for left end are allowed.\n\n```javascript\n\n    db.select('todo.*') //I could have used fetch directly here too\n      .from('todo')\n      .where('id', 2)\n      .orNotLike('task', 'dishes', 'l')\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`limit`\n\n```javascript\n\n    db.limit(2) //I could have used select, from + fetch here too\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`limit` with `offset`\n\n```javascript\n\n    db.limit(2, 0) //I could have used select, from + fetch here too\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`orderBy (desc)`\n\n```javascript\n\n    db.orderBy('id', 'desc') //I could have used select, from + fetch here too\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`orderBy ([asc])` the direction is optional if ascending order is desired\n\n```javascript\n\n    db.orderBy('id', 'asc') //I could have used select, from + fetch here too\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\nSame as below:\n\n```javascript\n\n    db.orderBy('id') //I could have used select, from + fetch here too\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`join`ing tables\n\n```javascript\n\n    db.select('t.*, o.name')\n      .from('todo t')\n      //'left', for left join, also 'right', 'outer' etc are allowed\n      .join('task_owners o', 't.task_owner = o.id', 'left')\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`groupBy` for aggregates\n\n```javascript\n\n    db.select('o.name, count(*) tasks')\n      .from('task_owners o')\n      .join('todo t', 't.task_owner = o.id', 'left')\n      .groupBy('o.name')\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`having` for aggregates\n\n```javascript\n\n    db.select('o.name, count(*) tasks')\n      .from('task_owners o')\n      .join('todo t', 't.task_owner = o.id', 'left')\n      .groupBy('o.name')\n      .having('tasks >', 2)\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n###`orHaving` for aggregates\n\n```javascript\n\n    db.select('o.name, count(*) tasks')\n      .from('task_owners o')\n      .join('todo t', 't.task_owner = o.id', 'left')\n      .groupBy('o.name')\n      .having('tasks >', 2)\n      .orHaving('tasks', 3)\n      .fetch(function (err, rows) {\n            if (err) {\n                throw err;\n            }\n            console.log(rows);\n    });\n```\n\n##`insert`ing records\n\n###`insert` - single record per insert\n\n```javascript\n\n    db.insert('task_owners', {id: 1, name: 'Test owner'}, function (err, res) {\n        if (err) {\n            throw err;\n        }\n        console.log(res.id);\n    });\n```\n\n###inserting multiple records with `query`\n\n```javascript\n\n    var q = \"insert into todo (id, task, task_owner)\n            values\n            (2,'Vacuum the floor',1),\n            (3, 'Iron my shirt', 1)\";//could be more\n\n        db.query(q, function (err, res) {\n            if (err) {\n                throw err;\n            }\n            console.log('records inserted!');\n        });\n```\n\n\n\n###`update`ing records\n\n```javascript\n\n       db.set('task', 'Updated Todo')\n          .whereIn('id', '1,3')\n          .update(function (err, res) {\n            if (err) {\n                throw err;\n            }\n            console.log(res.affectedRows);\n        });\n```\n\n###`delete`ing records\n\n```javascript\n\n       db.where('id', 2)\n         .delete(function (err, res) {\n            if (err) {\n                throw err;\n            }\n            console.log(res.affectedRows);\n        });\n```\n\n\n##Test\nBefore running the tests, load the included script **test_scripts.sql** onto your mysql database. Ensure to load the script as 'root' for you need to grant privileges. Thereafter, run;\n\n```cli\n    npm test\n```","maintainers":[{"name":"steveesamson","email":"stevee.samson@gmail.com"}],"time":{"modified":"2022-06-26T20:56:22.514Z","created":"2014-02-20T14:54:57.691Z","0.1.0":"2014-02-20T14:55:04.717Z","0.2.0":"2014-02-22T14:10:43.822Z","0.1.1":"2014-02-22T14:18:32.903Z","1.0.0":"2016-06-21T13:04:22.027Z","1.1.0":"2016-06-21T13:10:08.295Z","1.2.0":"2016-06-21T13:39:08.293Z","1.2.1":"2017-03-13T10:19:32.493Z","1.2.2":"2017-03-16T13:50:32.015Z","1.2.3":"2017-06-25T19:48:35.540Z","1.2.4":"2018-03-01T15:38:35.085Z","1.2.5":"2018-08-21T17:43:43.823Z","1.2.6":"2019-01-27T17:36:22.629Z"},"readmeFilename":"README.md","keywords":["slicks","db","database","mysql","nodejs","javascript"],"repository":{"type":"git","url":"git://github.com/steveesamson/slicks-mysql.git"},"author":{"name":"Steve Samson","email":"stevee.samson@gmail.com"},"bugs":{"url":"https://github.com/steveesamson/slicks-mysql/issues"},"users":{"nguru":true},"homepage":"https://github.com/steveesamson/slicks-mysql#readme","license":"MIT"}