{"_id":"@apigrate/dao","_rev":"20-2b27611eafc4a14501ae8f2b3540f61a","name":"@apigrate/dao","dist-tags":{"latest":"6.1.1"},"versions":{"5.0.0":{"name":"@apigrate/dao","version":"5.0.0","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.0.0","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"1a5d5d7abf471fc9de00aa99362c0d415ba0ca1e","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.0.0.tgz","fileCount":9,"integrity":"sha512-jqS7V+LkYE2nMmHTGwEhj0U7kecdjDGN8EOdF4eT9UAjYbqdxJncLP/FEP0ly38u8OK+0SCW6z6nnKDRkU/hCA==","signatures":[{"sig":"MEQCICV+Qs92MAmykunKxdf/Z1YwrwFHvzAkAg8vr+Shd2YfAiBs7vLokCTE1bpbjXYQiZ+obJThmSfTczh7baQPoHrzsg==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":85193,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJfoDWjCRA9TVsSAnZWagAAUtkP/jmw1wsxiIUKBtdx9J44\nunTbrr9rpkBwB1707YH7nuz4ANEp5Pkv72e/7MKvKQpvzo2depKceXP3nFP1\ngtDx7CdLZBZZd0cdGxBQ8r7WugxT6yvhXFYm17uDx9Qwv5+3C9DZvKwzOdg0\nu7hfBOnxw/if8Cqyu3Hus1ssoraOstmPKSyh8Eqp6/5gGspMK9xNyIZe9x7g\nDhanciHQ/DwkMKS2XSKN2oSBvZ6foRQBmuagGJOepxuQhExLBLzrKatcsGY8\ni3mZVKNZ6FTTvc2SKSDv8M7b9FNnO0ToA/yRRQVrrkDBw7f9QVHkD+hRJPQ/\nwvguO2tZ1xi1AdDPMeYoC+vSQnBH5dDIxtbnwov6Z27+nbpTGz5CrCX+pNRD\nt+8TX+s3CYcWDj3dsHlzQ4X7ZhXXKiPSyiz92nb5najJd+o+EBpJgGHymW2v\naDtgW0YPBejP3dsAOHj7wSSW0mMaiNu2pt0bPaVpFY28HjMrJEsZWj0zDRQh\nQpNDfni0y985WYAGxkRpoTWTV5W3e5A6ByPnsyvZL4YOAATzoNGS1LH4kmEM\n+FFRc0tozoga8jvTs1sr44PRXIKRWyGs2ZGex0rJPScnFQbf0QdIAGQNzY5i\nqZd+VbOhYBOUo6Tfc2wsaBVISK8MZ9MGDlh+BI0MxHCUbYXM+SJAbYrPH75v\nyfUf\r\n=5SSp\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"724c11f48ba7a985fc6f976007520290cf665458","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"6.14.7","description":"A Promise-based DAO implementation, designed for mysql databases (fomerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"12.16.3","dependencies":{"debug":"^4.2.0","lodash":"^4.17.20","moment":"^2.29.1","@fast-csv/format":"^4.3.3"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.0.0_1604335010870_0.6208697233338318","host":"s3://npm-registry-packages"}},"5.0.1":{"name":"@apigrate/dao","version":"5.0.1","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.0.1","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"cb8cea1c0d9b3930a7f4718b489817d47f50b2ce","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.0.1.tgz","fileCount":9,"integrity":"sha512-fOb2KOho0QUltuUi4yRpuvEtMY6GGpKKNrWmtZL3Cjm9oHhK5DjCqxwOSD+2HrFEGLLZ7waRYgt/csuaFdqvHg==","signatures":[{"sig":"MEQCIHIszkw4Vs9QnayEB9bpYKxhINmcedLXnLNqfpJq8k5HAiACfUfvnCt5qvBZ+6s9T08MVUhBQS0ISS9nkEor+ughxg==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":85243,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJfoD2tCRA9TVsSAnZWagAA36UP/1XL4uax41ZRbC/KhqAq\nRkIfy+LJ6FD61boXJKQZoMbWpgXTAoVvwXeQkiNNRa8ZJJ5DKZb4m7FPU5si\nCdkBX4ci6nTwEw/Ii3AwNyYX4UfF5Zp8A1eKBhH7wfkRM059OAFcvMo4XLcB\ngLLNHdYeoui0+c9+rwym0vTijmqlzMSL65cBS7dS/NBWTbtRqNSy91GjZUBu\nO2HRnPHUYe7BdSP2fuCSt0dPgQ0O2C1P2UaDei5YPvosqpaClMI2AOUsfXQD\nnO0ZcjqODr+RSs1LuPv28CsiTDW5XQ9bCtqCOpoXsl+XVZyEzt5l07IdDbeZ\n6VQBDc41bGuIX4/RHzgaNb5NRTcw5rgVTwsMRx/3KdzQ8mjvlRAi8Np9o19F\nP1AWxm3u8QAxy6Lk0NcnX8J98ZX1RFA7869RAexGHIATWr6c+LNDkYfcmnNg\nihs6Xj+vCP2M1j8sen06/TJP5BZZImFLEoBcrHZ2GrmLMi0uQ7qVZ1/ycNVT\n9b85xpp1I9N5uzYv2IPdHizQ5oiTO6bMNyo6b0gUlBl8QxNpTQFGEiJ3Q5mK\nYdVTuv5VmKJ6RM263zrsiuyjec+pMKRNr5gfl0Ou4fvxYiOs8Jc6UQmwl0B6\ntjujxoE7Ly5b6TsA4D/X2zd0QI159ZCWF6RSKPS/+Y+8xwdrCJrxejY74e5P\nqWrF\r\n=tV0x\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"046ba808ee1fe096753814f28eca96bc696ec886","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"6.14.7","description":"A Promise-based DAO implementation, designed for mysql databases (fomerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"12.16.3","dependencies":{"debug":"^4.2.0","lodash":"^4.17.20","moment":"^2.29.1","@fast-csv/format":"^4.3.3"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.0.1_1604337069438_0.38053965619959107","host":"s3://npm-registry-packages"}},"5.0.2":{"name":"@apigrate/dao","version":"5.0.2","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.0.2","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"36608fdfbbfe3b83fb20fe3718e66bee2efdd123","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.0.2.tgz","fileCount":9,"integrity":"sha512-eUfuiOQZW0mqcoDYhuE0uY+FG+zKx1+D3Yh3KBVTmD33IaEF6gOgbl3523J7SUupLqOR2PvS6GeKQg6IVE4now==","signatures":[{"sig":"MEUCIQDaeANeV415VsGlPnKzO2AHdkywCudzP4//n4n8QtYmnQIgCeJZPqgTv58mvLTo4qB7PebbWxx8Y5KWBKXJqlAukAE=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":85287,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJfpGHwCRA9TVsSAnZWagAAm+oP/0EgjrKA+Akn8Ra+yvJd\nvCbsNgJM/3J2ENEKQFKu7v0RtiWR5zBDROihjcB5u/yNCqPMtev1ut7eYA8h\n6NfpUiDz5+MYKMZd+dMZJ7t3AQaggBD4pMq6kAKxEle/0k/uBrHHpvyApJ71\nk2BdAseBSZe6TBA1gS0sxpwdbPxtcqOO5PEVZ0c+u+VbjjltKAsGQ04ZnppB\nZFXG6VYm9EVkn+20SiAJSWbzyNf1bhlJQh987lxn0FgbQ81QnhkykaenhUBm\naTFOkrKMm8Uu2izr4kw3WXyzqdaakttvgK5fm18ZhV/tRShaZ5Dttt/svHr/\nCf4JwQIRAQbjcaXNCSQcygMPple1dTEwh2wbfgLGKrc4Nt5snvNhq734G8zy\n6IzMeMq+R1l9ULJuSNOb0iQkbudfUc1ZDgq0oQ9pX4BdvvBMrFjvzqgLQYx3\niolS0KnRaJpAonTZMqALzM2L/suZcWWOZo//cSFKBiZf1rYJ6p21cZwiTR+I\nKQFidZ6nwShZW09673O2Gl8G+64tJHxKkXNN0T61j/ThQKpjS3eMoBvnapbE\nFFHalanF0dzyG6mWkYjWg69e/rB9nFVDtfNkbFnuoS8/L+YpSjBLBDqvZ1EV\nA9lmcuSeM57AkFgivKuI9u4R3q6eT5TMhO0ZpM/V0Bv8udBZflHBe8z+U3qb\nj64+\r\n=3FfF\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"55df77e749fa547897838b5c21b3c27abb9499f2","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"6.14.7","description":"A Promise-based DAO implementation, designed for mysql databases (fomerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"12.16.3","dependencies":{"debug":"^4.2.0","lodash":"^4.17.20","moment":"^2.29.1","@fast-csv/format":"^4.3.3"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.0.2_1604608496234_0.6475223976063096","host":"s3://npm-registry-packages"}},"5.0.3":{"name":"@apigrate/dao","version":"5.0.3","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.0.3","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"2510fece09bd8a199c4e21e2d59bdeb0f166628a","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.0.3.tgz","fileCount":8,"integrity":"sha512-FUEyhirN1Crj03COmZumjrrfNZzv2gGSMh4SRJCB3r938s61XUCCYf3w1ovSaujX6C+t20jX79MTmJTi5imFDw==","signatures":[{"sig":"MEYCIQDRs32YfFrEUtUQc7f5jBpFu5G+ZC52bZfNtLLB/xdpuQIhAImi5ka2Mds3AIAjw0tkLgYvjPc9pcK81UfB/uigyWYa","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":81175,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJfpGK1CRA9TVsSAnZWagAAlF8QAIWyl7w4vtIJzsQ9yKJp\nmNsmZTEAoPW/C+ZwBIb/qT40xl/Z0YK/8oxAe/ZZ3fWiKeolVwaWZWoN+ppY\niExUxZPly7PR9cXrW7VjNmhTOsgOGkUBbvGT0LX4VDlu/o3ur2VQ09KD5+AL\nRJ0oHS4KpCnSW7YxeUFRMPvQcn97yO8+71BFciIbMDeC2xFJ8gb6m0KxYZ5c\nbpVXm7t5booYUnihCJasu1PyrAM2H3QSZq8C0QrwLrbj/rYvwIS4yrKMAUKi\nWeGf/kTb/8ObvUtNgPa4h1JJD7/nrDwdBy5niYpLmK/pmROeUFgVKlM5NNoK\naV7tP4FHWvnNjIwLqzNJAhB61Ix6jbwqp41TzxYRN8wISpZTtr2UzewAdwCi\nDHYF7oAAOyIon504Jf9P/opWAQ9UODJnh4rFXFKxDjP4Klz8AGeZBD4BfzjG\nomzdCy9aY5x+xEAD+iuw2e+j/duk0uePU6uLuqnkqZjmso15wYsnJY/fWgPM\nI4iusHmfxZ/K6E7DRazFzk37EmJakPSZ/zdpqwkwfCjahiUgKQAdIBxvtoJq\nJS4vU/E6cvdM8TgoVEft2MDFWpC5pieNUL9nNNkM2iqX7xU+jKop5tPxkCQA\nLS/HTaZHQhJqALNFA7YtXahD9A//FV5Qv4gcUerz+wcI/NKKOvdu8VMgyjcC\n3448\r\n=U9e/\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"997d363f6c2d4026dd868009b28eb11b80db7955","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"6.14.7","description":"A Promise-based DAO implementation, designed for mysql databases (fomerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"12.16.3","dependencies":{"debug":"^4.2.0","lodash":"^4.17.20","moment":"^2.29.1","@fast-csv/format":"^4.3.3"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.0.3_1604608693162_0.617866982418521","host":"s3://npm-registry-packages"}},"5.0.4":{"name":"@apigrate/dao","version":"5.0.4","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.0.4","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"3e47c88bd892cfda403b362409c368e6ee446fae","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.0.4.tgz","fileCount":8,"integrity":"sha512-RPxCV4SgYrMY5q1yTWiX/lQUnhQZlduF6vLLncc9MlFM1eBco34JFs0+zZvqNWXO4rsaB8c3Uh9y8t/x9n5mrg==","signatures":[{"sig":"MEQCIG/F0K+qhRnGeJee+xJQyd1do7xrpW7ur8bkAFBjxVA3AiBwPkLV63ddFRR7TQm6k3kE8Ik3XKTm2P83+9+uS8mHzw==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":81020,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJfruC+CRA9TVsSAnZWagAA94QP/0hqPNkHi17j5o+9pJY4\n9cmqut2fmWfLJIdiIdLAln5kfPLRrxBZRy4SvnyIppFDSg3O9sqQgFkx1OI6\n+8hgLPCNhrwisPUUgwTwEqcTKkKlUMLcaXgKfJGux1bjUnN2hDrLnphbp+ln\npuGs0+lnYYwmFDdPoI4KNUHAuzwHcb2TJh5DNcqbrYPGiLf4HSt/ucqx/OEb\nUTrZ+ADzu7fam2f/0Q5TxL8fb1lw5OmIGlqQl5Hlf44KQOomRWHlYNd017YV\njNP6+vPB31AyzUj1PCW/+IaSoleozOXy7V0tRq4GRLAdLFJ/S2Qv/fsZSfKQ\nDrnzkt19DhnWtxDNshNXCmCMvUqt0RU9RNv1CmeLzIFujAZLYbVwSnYJzkWC\n39x1Ond0kKg+7I26exeZQPBxkLOVX1XoKp6poNwVhVfJuIrHW2oDkXgXVP05\ng9AnslY2XudDdEi28ulTIdK/FdzS9zpyryC8bj7r9zuIfJZEN8J78FfMRILO\nynKhQzOLrtJOoHbCgRjLMmT/A0KekLwNrIatHMpJ9/zVZV3s+Tr6iDUq3UUv\nr2oqzlyr3TJscQ7EBkakkewhGA7wg3rOOruVCqvN7qqhKh68+PC2PHrtFbRi\nklXEsOnlnnvFuu71cEUbHlWUhzZEgSqrk3HTqqEqH7RSCIY31fKWgydtiIJM\nz1qG\r\n=SgfR\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"1c64db82a6491ade16bcd6ed39725a4e21128721","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"6.14.7","description":"A Promise-based DAO implementation, designed for mysql databases (fomerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"12.16.3","dependencies":{"debug":"^4.2.0","lodash":"^4.17.20","moment":"^2.29.1","@fast-csv/format":"^4.3.3"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.0.4_1605296317991_0.5352408419804646","host":"s3://npm-registry-packages"}},"5.0.5":{"name":"@apigrate/dao","version":"5.0.5","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.0.5","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"3b8c38af113d0c5aba6e662df169894ffb67f7f9","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.0.5.tgz","fileCount":8,"integrity":"sha512-lWpPEW82V11z7UO7IWnUC//eK4BbnWYN4OLXrshjcThW28SM5DEg7adfjMAI22JOYIlf9Ufe/mWf+z7NsAKq7g==","signatures":[{"sig":"MEUCIDTCrnvzUUl2qOQevq6PQLLD6zoXctfuDyIUjnCjfhMrAiEAz7tVBaZmFlMdTDIxDsDNYxhvW2kU4RWWGU6cKeFSo90=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":81238,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJfsGaYCRA9TVsSAnZWagAA3qQQAJpTOg8YCLYPeMyrTRL5\ncDL7Y9McCgle0VbUrLq4MuuzakD2uMGA59vJ9M1kthqZTMESDa6P2+RSfrcT\nIugxAeiTcCaVQS8PDw0ZYqX2v5MssmCAZnF0NFw3cVvhri0Q6W0Pu1Mloaij\ndOTh/x3s/FsYfJ3ajF8DekMVmtbKeW1lyjeMQZbqFgViulk0pig2glrPks9G\nXvK2zwpga5jOgZ2m04WOZWMHxLJwx3xpNhMK37lrvQmPeSjHeK0bYn2NVWk7\nVBiIq5HZuo+mParZFc8xNkLX6cawCv7wXgEO1Pf776ExbKDydLZv4VVpBXKu\nQpbAHMKKeqX1m1P4brwSY9C24g2XGY00KMgzMQEm0pGxyeukr92LfBnzfZT5\nYlMCj9n1JE762UkySKlz/n6/nCSQWyrxGg5C+4FFDf8FStGx3hCf0Ih69P5F\n5PXEu7HvuGSY9AxBlQ2llY8XjG6ny2f9DZu0KHdbjpsfUs/eFojGqLtVFbBV\nbklLYPlWlruxKi34WVAMjrYdb7d3EnasRkTryuCUPWUMvPToVZkjzGOgemaD\n1ElMy8+CoOYOxqJi5+WjDXagre7PRb55BuSxy4WsealGyjtskRHGOHVdVabR\n3LA+twCYup31VjUva15E6U0t1Msig3R2O4jyaxuC/jwDxnNbKryz8gSIOJyY\nOOLa\r\n=xS3i\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"c5617afbe00ec5622f4c6b692b3a8a7b0ada1248","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"6.13.4","description":"A Promise-based DAO implementation, designed for mysql databases (fomerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"12.16.1","dependencies":{"debug":"^4.2.0","lodash":"^4.17.20","moment":"^2.29.1","@fast-csv/format":"^4.3.3"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.0.5_1605396120131_0.8673657458778854","host":"s3://npm-registry-packages"}},"5.1.0":{"name":"@apigrate/dao","version":"5.1.0","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.1.0","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"1973965ff816971b34368050e6cded5ae8dfd099","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.1.0.tgz","fileCount":8,"integrity":"sha512-9kvRogLqftyXlkRRd4xNMIgIilKf8uBPvV4tWuMbO9s4W8SGoRkCm0EiJFzt1KAMWbVvGwLVQyaefOntrewdrQ==","signatures":[{"sig":"MEUCIGcBPfXmkNrDWVwBZueR08D37r+ypvlqlGizaSXbB0jUAiEA3GQtSjupg720eFIQ4lfL5gv6KA75cATWuNatnG/fHnU=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":81845,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJfwm/XCRA9TVsSAnZWagAAkXYP/2MAKp2N+X4Z7KOsXpqh\nY3TVt2g6QqccYGQodjuAHt3PkwhAozNRS9rnfQVJrasQkRgDbl1p7QcxIPUR\n4tZgHSg7CB6E9jtI9Ejd5uoGJm8sI5D1fyHCPy5tKMVRn4JdaSEdfpPd4Wns\nLYmejvxgo0bzLJak/AzYu5sLnUsUf0nMoUF1YZ8Pw+Jf2gNiaJRr+6XX5/Wk\nISpZki1mihmcmGWJ6u1xojvzpuXY7Y41rgd1JNII+Pb9JpqIxesKip1XoVI/\nfJHHzXI7QSPmacC0/WiIwLeKV/Gm9b0E5FajFCLrOVn1eJ6D3RP8NR5Ks1KK\ntHVNgRDqaQMKYzEOyndjYzOtRzCPNJoxCGAohJGnyh1g4gAi5lJoBSjtdEIr\nXuCCL82Ego8PCisyRF/8xnGp+mE2ATFbLpBBbdCVIvJCvOcJhPDtqAHEsa8A\noK1YojTfLZ5fhC8WlWrvnyVTD2GlsVkpIWGR3NYbq5g5MN9JDNx7oghRRMig\nzE1Zpr3rFiD7iScr5kXWWLzu/Xiv6qOABGoyE4mycZgpTZ8EGyWhajwxTZPa\nlI2jHfp5RDtguYdz+GtFRaCi9LfH9UovyXrqljmLcKMfRnBDkNa9dHa7Pl2Q\n4uu4QOzgIGS8hCJ0lE3LpPQIc4DfLy8IWam+2de+Xzidt/jZwNIX/zFQyL68\nZWZW\r\n=KMuk\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"66299baca3ce52aa0a60503cfa22a706e7e67c24","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"6.13.4","description":"A Promise-based DAO implementation, designed for mysql databases (fomerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"12.16.1","dependencies":{"debug":"^4.2.0","lodash":"^4.17.20","moment":"^2.29.1","@fast-csv/format":"^4.3.3"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.1.0_1606578134574_0.8995622285910025","host":"s3://npm-registry-packages"}},"5.1.1":{"name":"@apigrate/dao","version":"5.1.1","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.1.1","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"ce49361fdd026ef9bece9cf4ad042f4397a5fc97","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.1.1.tgz","fileCount":8,"integrity":"sha512-36HlUo48bm3aOLtU9+XvBsaFP6/j3wgPoHoo6JDSo2LttTfCVxilRMlyLt2hp9zVd9aB7qmH4SCq14Es1g/wQQ==","signatures":[{"sig":"MEUCIHWKbAUfuu1wQNXd9L7reci2qQng1+APWTQiVcYrBvo7AiEAg+0ez33LzJ230d9IjfOWWIoKVKBuLTULm3v/r5rUkuk=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":80916,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJf15gsCRA9TVsSAnZWagAAthcP/3f75/6lZhowkug1B9XQ\nviPeYq5nDpzqJSkCKUcrkb+cvSDGsqaO3GoaaswqDepduRnWstgVoMRQoKcz\n8dW1vRUhDmr/LvbUje3mHo0aVzFXmcax5OpRlmeKjb9TP2UUJm1ht34Pmbxj\nKTxoWT8bzei7CVnnI3qQCnekhQrAk3KibZfVTLQqHkvSrVoJbMCuJNV2/d02\nbZQQSB4fCCojR3yM0moVtj5w450fW+3ZmnktWC5WRntW9WweJyaCioFKmuet\nPIJ0JDajSnV7j0KYiitRwQqfVlN/f6axQFMKh2lOp1Gx+7BMpr47aEWiyrpj\nAJtULC67UrW9DcQWDH0ktTBnQCv5GAQSbtNFtiYAkf3wYVgCu6dq/dNYv2Gx\nbeno4iULtktntCrmCDJxLKBwpELURu9TuzUxJbCWoNx46x5yxfH90NH+BFt+\nZ1keCXZjeCAm1p1we+yqZNF3mtC/16O70rRh7PtX0cZfm2Z8fdCRwBdDE580\nxhzuAEqqGXWhw9XzazxfdB18W6MCNXgq152tti3jV0b5wnfSHXP4tOFgt3lY\nWhgZYc0HYuw8aQrD/ZqQu7kz3AlUu2t82BLP5BDGLoEd7plZ788J1FDT6YZU\noSnRd8J10os/jVix9gQ/yST86b3JLForXczaq1huIAY8f1+D28Ep9qNotju9\nxe0X\r\n=n9PZ\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"d4e682d71efd50685b02acd61def18861d320721","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"6.14.7","description":"A Promise-based DAO implementation, designed for mysql databases (fomerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"12.16.3","dependencies":{"debug":"^4.3.1","lodash":"^4.17.20","moment":"^2.29.1","@fast-csv/format":"^4.3.5"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.1.1_1607964715547_0.8304055220085238","host":"s3://npm-registry-packages"}},"5.2.0":{"name":"@apigrate/dao","version":"5.2.0","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.2.0","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"ed106a6a366ca0224ec7d5fd37c46e7d56ed543e","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.2.0.tgz","fileCount":8,"integrity":"sha512-e3gwQAo0gihx68Kd9VWEOfc/9NMloE8jAnldNHj5uA89eyPovpe5w0QILTottx2wBbASdXUoWtvGpzmpSTDkxQ==","signatures":[{"sig":"MEYCIQCTCdpwvrst5nxesV5SdGUcP+309I6Wmsvr2IapoFX8wgIhANHjvaOI2saVAJTG5EYz5MUD3q35dGTSrIA+Xnv867wg","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":81684,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJf8yojCRA9TVsSAnZWagAAjo4P/3uhgcvW/SRCtF+bzWBd\nmstkXe/2dnWOS+Mu8pN0c4hfhZUjO93JklwRmu+xKWf5LGL93k3CoqAoGb6l\nL6YzJmrmvg+7UGH9Vnty7XC+7EbbF6D4oBf1Eo7iJO8b4i/ugrWwRJ5+QFVN\noGp/hJ8ME4zB/uNBLsw9QHcd7+mO5Pry6OaUBn6INpkybVKM2+KvX90TAuwf\nQADbWtTrTPwk8LDMpALeMV2TLoj7RzBsbw+FvTCw/l52UiK98no5VsjcVu/L\n+6bS+/yAryTib0nj3NKOT9ZjpRzuioHjfjRa9a9iyiGcSlacThX95/4DVAay\nEV9+LizGF2ZY6PnLAHrHxpcHBZJSoQd66NNeHJbEKD7NyrLTI6sdcJcfiALv\n3mqI2/4PrVJLZPVWeGKfAZhSHOjSg08zDEzV+oOTsUrhtemoJb4WWuGY6AMX\n8wmNjDWvWo3rlMnV4nw0ayt7mMYXXpMr3FZTsWZFi3v5pTT5WaLdsfnO7ck+\nFIwEDPXp7XpkMF7Zh0pdhCdEZl59CKFGYVj3wFgOYXLQF9PBBQotAfDKeBvl\nhmh2tfq72FbbiNjSFIWRcc/Lm7rhiE1YmDM1zEMoi9/VgsdLK827mYg5oHOt\nODqNkuwZqstVwwTVD27kPMuWyp7LYghsMjuIHcroQ7xEtmruepgI0yn4cN9A\ngFXR\r\n=axsP\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"48505189c1f4c5c58c624ed0dff680201fc951e9","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"6.14.7","description":"A Promise-based DAO implementation, designed for mysql databases (fomerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"12.16.3","dependencies":{"debug":"^4.3.1","lodash":"^4.17.20","moment":"^2.29.1","@fast-csv/format":"^4.3.5"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.2.0_1609771554967_0.11197941628478225","host":"s3://npm-registry-packages"}},"5.2.1":{"name":"@apigrate/dao","version":"5.2.1","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.2.1","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"3ef41f4cee313d9aa7594f737eb6b24b3a01a021","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.2.1.tgz","fileCount":8,"integrity":"sha512-9lrwHtGmMlIMUa3BEngwwpIhlH2MXE7Rphc2FQFfhuzRn3AWNRrNGKXj8drGiqWD1n03WRfDhuXbijhYa8Ut6g==","signatures":[{"sig":"MEYCIQC+DJifkKTuCWm8iVujr1kl5H9NQ8g3ammuWC/1edPTBwIhAMkOiVv1W/XQHXJ/YiC0iiZn9/KO907ySNXiujNQob8h","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":84780,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJgOR9ACRA9TVsSAnZWagAAb6YQAIr6hqOBOn31zIDQa/IK\nXYPRALK6uTwc1teG5Et85PbfmG9os2pqbKNYwads0s+TW4nTfw98FFplTD5C\nlZnsR/OOhy0+Nl12M6fzAy7vq0A8H+mhLRf1+IGaWr8Z0056RfArnWuvS+wa\nRn0gKhhZJT1Ybb+3bqqzxXVPFY8QpFtasr+OvFBIWPgQ8vUBAH4NQ4ON4u8u\nvmDFJD/D+t9uN5yxHaWUN4IcWpSKRXK3I/tvhg52oVAIC+4PxWrGbdgMYUcH\nvAmZ+DFhDcXzIV1yokpDb3nlFki335ClD1puC612hUjGyq/se1BSbV9QdcFJ\n/LJqzpMnCvD/Gp1OGc1WzBQ461Dgpd2jijoOUhZ2zRoxVLjh4n8HSjQ7XzDw\nmotitTsh22D1J3cOb3YE2fI6w+3PtGGKY2C56xHYlRz8dLRegoF42CRaHaiU\nxJjopkkIMk7mH4QBheQs6vg890bzHcHbLO2bEf6HoYtfteC+8gOYM2jzuAZl\njlVn2oiCXEa0G7QF+j5ZTdj9B9Ljotbk6bAdcysK/BwWFPixjMU9kaPu5lQz\npOcvKSRCBPSiMoO53KYmi9LPtMWlbI41JQDLVqeHDxdhCrGNuKfuymh8qR2Z\nnxJfWpXjf5vJnwSEni8zJ0FALpNgMaVpQ37+POE6el7AOKJTIrQk7b278Ikj\nrMWH\r\n=l0dH\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"982bfc2c8d6909afeddb63344f25e88cace869f2","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"6.14.7","description":"A Promise-based DAO implementation, designed for mysql databases (fomerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"12.16.3","dependencies":{"debug":"^4.3.1","lodash":"^4.17.21","moment":"^2.29.1","@fast-csv/format":"^4.3.5"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.2.1_1614356288033_0.5357513145584649","host":"s3://npm-registry-packages"}},"5.2.3":{"name":"@apigrate/dao","version":"5.2.3","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.2.3","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"bc72504849f2672ad8f1d617e044ea64d3e67727","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.2.3.tgz","fileCount":8,"integrity":"sha512-3ceHRrwS6bBFKiqHm8O7PPFi5/0f+kJ72MJCUhwkwpE9daYNb3TJro+44wJnlIuV/36eJOKjHaf8W2l3wsfBvQ==","signatures":[{"sig":"MEYCIQCn/wsBOWMw0OJ5XiJrdmCpNjbT3WR6UFXVlLA/DmPTDAIhAODWeXQ6BBcxYJcrY8OHhz6k+8EHflxmKdGJZu9ZdNYp","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":85309,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhrnF/CRA9TVsSAnZWagAAdWcP/iNYE2zo7ASf2x86vPs5\nMyyZQ95LsUnO+UMPuMw5kSUDQSlv6f2a29Q36e5NI1VusEAy5VSfV2ZWCe1X\nSFlQ/L3CpTpt7SQst8fVxhl/3kQPgLeQbqRa4cjC0V1SIEYToqs0z52WQPkz\nQVxhaBOGoyozJsqNTkSTEL7vCg1rz0y6J/Fj5III9hV0LWkYHFwfsxO/fClY\nAg0lMcBMltgX7+8aDE587hHpFOVjH8DT90JIOK2rNpwH2uGIgMbu7WS84dca\nzsOUr6LlHe9xGGYif3vesxscjTC7tCingzM4pRn/E3AEmuVJwX0qZuGihCBg\nQUQphasF99k0897kALoOkHReG5yab6PeuaKmDi/RGU7oXIwoUIhiSwjTqN5F\nRTY0U+rTH19Gboorxhhc0E8Sr3MiCe8z4C0tLGqt/WXqZ5vJHv/oMGWTFoKh\nf6s2bCfJjziAFoTzx9xdCZP3BR9YwmFxP9co/sjp4a7B/phDPtVmg+As3lb2\nPg3mJhzpE69Qy7F9JYLevZ94VwWNIV7+t8LybpR4Ps9CElyFebKQVHswsULq\nNLF3B4Dj73aSBUdfrPXySpRAEablcDoMcpa0FlXW/6l4MpelXD7iBah14p0r\nEk3cCw4Nx1rTsPJe8+/ci7MRaH5KWP9aC89FKQGTR+UiaH6JBFQQKAT3v5Iw\nnCbf\r\n=SLtW\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"9673076d56828ae806604ff712f74571139a1f7c","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"8.1.3","description":"A Promise-based DAO implementation, designed for mysql databases (fomerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"14.17.6","dependencies":{"debug":"^4.3.1","lodash":"^4.17.21","moment":"^2.29.1","@fast-csv/format":"^4.3.5"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.2.3_1638822271715_0.5282650911130258","host":"s3://npm-registry-packages"}},"5.3.0":{"name":"@apigrate/dao","version":"5.3.0","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.3.0","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"69e644df9f26884dbab9d5afa82d680112e3ebff","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.3.0.tgz","fileCount":8,"integrity":"sha512-kKfkU3PiGdvXr8dfPrCWj//1mYoqqcMW8A/sgCQP/w5qe0WZX96+pzwZAexETlN+XbaNg4AI/ytPTKB7x/s99g==","signatures":[{"sig":"MEUCIQDyp+uGhRiX+aO8BY20ygKG3x0qnPOkjImyFn2yR/YK1AIgCJIUf5agzKrbhjN8jDqaQz70u3pmyen8tJwymJmvM60=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":86703,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJi1wSvACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmoI7BAAi6E9KmAg2EvgCAxWQMHOqtwufVwLqIlCC0V+HR6uy5Sul0w8\r\nJIBl0geXyzS84FEO3OvySSYWzFGIXIgaPKkTTWI6srB2rwfSqLuQSRmxQqmo\r\nwnbmDSfHKpG8msH4ZyrmeBVrrTao6f6NKlVORXP15FQu+4ZKwcA9MiHcNXY0\r\nj6LD+QJY3fDmLlNR5S93G1RAzF75HCHs9kXaLhT7Hv0iMcEew59cNb0YJQsr\r\nz4ti17dqz351tuH1oFcDX8NrYamrm6W/79HDqYk5j1oPOqR7h4KVSghoSfLw\r\n8RHp35/TUbx308IxJiNDO5kD5hndhLmPhxQ8/7q7s1YQuNBH+b1905f+IRBH\r\noSoknXNylDirlheotmb9rSQKNztZ/X9Ihrzt07+nYPoVhzkB+AzC0o681fBy\r\nbaxTUuysICM5QT0UxeM1jg7VOJlITYVz9XWXjcZhoSBRBDnrkZDc+sgeNKlO\r\n2JiXfS0tHvkfRNKGU4wI9gQsvmu08ysITZDYlsRJLjOPIgt7KPRSOh05OlZD\r\nUDsU3gMlUThf6flOhUi29kY6aUyeasfcvQQMBaC4k1gzYEaYaW7Xqu9rzGXY\r\nnVdIga9GRdXaOR1sgu7fvu6vpTOtA1lrEnXBhhZcw7ihC/+RSomwl0jONNbR\r\nLM/Em21elf4q9a68dlQhQJVCQnvG8qU+tv0=\r\n=ULYj\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"82a8e68e6adde2c76d609cb43d266bff8d0cbde9","scripts":{"test":"echo \"No test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"8.1.3","description":"A Promise-based DAO implementation, designed for mysql databases (formerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"14.17.6","dependencies":{"debug":"^4.3.1","lodash":"^4.17.21","moment":"^2.29.1","@fast-csv/format":"^4.3.5"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.3.0_1658258607358_0.4987326090682962","host":"s3://npm-registry-packages"}},"5.3.1":{"name":"@apigrate/dao","version":"5.3.1","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.3.1","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"54299bc67b21ba3af5ac5b7b206b4d000e5b662a","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.3.1.tgz","fileCount":8,"integrity":"sha512-jaWzfnouxCt9Gl6E3rkQhQXua3U42yZkTukU3fqqkdDKRguwplxvRgimg0TUOk3E3CIDiQCtI0UWLVc2nFAV4g==","signatures":[{"sig":"MEUCIQCy733vUWDpZvffulrRcfes0zlRfxFk9W5M5O2s4pvg9QIgdHPn6n+SgnnYdosEcz6LV6XH9HQcoKzf1d2l6gNfxO4=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":86677,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJi1w5yACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmpCiA/8DsHNQGxFRAjloCpSxXfABpi8Swy+fygzag2oplJK+lwJ7vKG\r\n0MVnMUtSYAf4midHNl3k/j2KBB20kCeHcGiBy0jcQkc+vdD9urRAbTNYoTP/\r\nevSv5Dj7Iw957AtQ5tXwoRrIV27olPB53uUT1grTPZsRM7u0rzzKoPmVjFCY\r\n4z+F/rFF7jE1LHRxZ4SaNC1lX/SaXtpZkfSiqNqAkbZOhV0qyda+JITSiuZt\r\ndxea6/0LwRTKcizaahgrpoQzy9nC5h3tTcJ6nSRE7u5ggcVNVj6KiFBt5N1d\r\nPW8qHp/ZmU60TePq2YtwHK40V5hDk6Ut+aC9xwXtGma77800ya/yCRTC4DK2\r\nVIzM8+Lrjjxf9lermUwMIX/US46neMBKJzywqRAf1uw7ozXGbyxlcb4Z1Ril\r\nTqtXtoCMqISUeXMAqFDrTdgpqHLbErmzpY4aJegI5r+0OVFGc+tYD2SNQOLV\r\n/KjjoTruuV2DKkY7qREBmLxBadxhJrhv8P4qbrNCszuXZuPa2pegd3KAPEhv\r\nTkn+whV7OPCynA7oOp5i3n+TqZwnf3UBbBpK3vZC4BfpDZg2gB1087FaLTpW\r\nOfgjVhQmokIpd8fVgHk2Tito8L6vEw1wncXKSXxdI40y8PZF4W7yiqKTli12\r\nIH5fK0v7MRaS1dlxGg/ZjMeJjJWIQo34yO4=\r\n=DqwG\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"740266769dfa26468a2935f1d3372d8990bc3a26","scripts":{"test":"echo \"No test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"8.1.3","description":"A Promise-based DAO implementation, designed for mysql databases (formerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"14.17.6","dependencies":{"debug":"^4.3.1","lodash":"^4.17.21","moment":"^2.29.1","@fast-csv/format":"^4.3.5"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.3.1_1658261106102_0.0015353711602668074","host":"s3://npm-registry-packages"}},"5.3.2":{"name":"@apigrate/dao","version":"5.3.2","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@5.3.2","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"ae978c6377cf2554a19974875b27acd895421950","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-5.3.2.tgz","fileCount":8,"integrity":"sha512-yEYPo2CRnf4+2btgmp4kjYKnczt0NCNRh0fnfS7NfRiKRW3Df769L8W0htBuVqHtP4dPMOg7YMdTYoyKGCsesw==","signatures":[{"sig":"MEUCIQD+DrpqtgtEKp83fdoQ8mDLbMMH/MnLE8xkeK9S7RqSvAIgYEE0tZILLEPKOd/LMSQk6LbtTW16k0RhXUn+qW1hrrA=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":86685},"main":"index.js","gitHead":"a7e45e7318c6829d7371eb5f2c7f7a4e061fc7ac","scripts":{"test":"echo \"No test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"8.19.4","description":"A Promise-based DAO implementation, designed for mysql databases (formerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"16.20.1","dependencies":{"debug":"^4.3.1","lodash":"^4.17.21","moment":"^2.29.1","@fast-csv/format":"^4.3.5"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_5.3.2_1691598782858_0.2612046680261413","host":"s3://npm-registry-packages"}},"6.0.0":{"name":"@apigrate/dao","version":"6.0.0","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@6.0.0","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"2435682efa496086e08b78010ba2eb3f59ff1a11","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-6.0.0.tgz","fileCount":7,"integrity":"sha512-x/GYYq1qTsLCVcuGoiiHapmevpieo7mx9tAt7hWpIN/z0ngQ6g0SP5v/2+fBSIZXcB4R+pAepbGXoUyHZw2rBA==","signatures":[{"sig":"MEYCIQDn4p6LW0dvwQ3RPKwKzq1K7v3cjZgI/KQhyZ4fAA1R1QIhAP/rfIFfYQC0cIylJv0WSzBETEmTYi6AKtUE2eVNl40q","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":56695},"main":"index.js","gitHead":"27c970254a669384e1dc1e7c1a34633b22a45332","scripts":{"test":"echo \"No test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"9.5.1","description":"A Promise-based DAO implementation, designed for mysql databases (formerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"18.16.1","dependencies":{"debug":"^4.3.4"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_6.0.0_1701310105435_0.9631399216596357","host":"s3://npm-registry-packages"}},"6.0.1":{"name":"@apigrate/dao","version":"6.0.1","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@6.0.1","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"98850e0059aec575a1cc46ba79a5dfa84fdf3538","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-6.0.1.tgz","fileCount":7,"integrity":"sha512-WNIFM23e+SRxAFXd0QBFa/UG+BTrbA1ZO63tBr6wzKCZHDHJMSu6bJTFAQXiACB3VrRlcvftvBpvm5vqaGl+bA==","signatures":[{"sig":"MEYCIQCUq3fAtPrbSFAn1SwaDT9pjth5sJ69DSR/sKHycgmlzgIhAP0/KruYACAv1WXGSgau+peAAp2nTck4mxygwa7ilXoB","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":56792},"main":"index.js","gitHead":"278d0bbd91abcc5709513793f4ac2337ce77c226","scripts":{"test":"echo \"No test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"9.5.1","description":"A Promise-based DAO implementation, designed for mysql databases (formerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"18.16.1","dependencies":{"debug":"^4.3.4"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_6.0.1_1701310632312_0.5824633327872615","host":"s3://npm-registry-packages"}},"6.1.0":{"name":"@apigrate/dao","version":"6.1.0","keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","_id":"@apigrate/dao@6.1.0","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"homepage":"https://github.com/gaumeister/mysqlutils#readme","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"dist":{"shasum":"3b2ca8932d824e28ea8e5ac16658297c8885d05d","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-6.1.0.tgz","fileCount":7,"integrity":"sha512-KeRk6bXRqCsveOXwMMleKMu3E0BsCwwW69NPtGiyKo9qwTd2RGYu+LSUFFDNst7C0l1T73o6cYCD6d2g71I2yA==","signatures":[{"sig":"MEUCICqQLJ2DvCDjXfIHoceAv57dm7Gwcm/b/23+uAsjbAnlAiEAvRjE8dkBLG1MKxuNwhzDHT+xXgqoekTM8cPZHrFoH3o=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":59278},"main":"index.js","gitHead":"278d0bbd91abcc5709513793f4ac2337ce77c226","scripts":{"test":"echo \"No test specified\" && exit 1"},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com"},"repository":{"url":"git+https://github.com/gaumeister/mysqlutils.git","type":"git"},"_npmVersion":"10.2.5","description":"A Promise-based DAO implementation, designed for mysql databases (formerly @apigrate/mysqlutils).","directories":{},"_nodeVersion":"18.19.0","dependencies":{"debug":"^4.3.4"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^8.2.0"},"peerDependencies":{"mysql":"^2.18.1"},"_npmOperationalInternal":{"tmp":"tmp/dao_6.1.0_1740941741929_0.5732613687127004","host":"s3://npm-registry-packages-npm-production"}},"6.1.1":{"name":"@apigrate/dao","version":"6.1.1","description":"A Promise-based DAO implementation, designed for mysql databases (formerly @apigrate/mysqlutils).","main":"index.js","scripts":{"test":"echo \"No test specified\" && exit 1"},"repository":{"type":"git","url":"git+https://github.com/gaumeister/mysqlutils.git"},"keywords":["database","data access","dao","db","mysql"],"author":{"name":"Derek Gau"},"license":"Apache-2.0","bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"homepage":"https://github.com/gaumeister/mysqlutils#readme","dependencies":{"debug":"^4.4.1"},"peerDependencies":{"mysql":"^2.18.1"},"devDependencies":{"dotenv":"^8.2.0"},"_id":"@apigrate/dao@6.1.1","gitHead":"1e3b9834a55106808fd375f61eaa31c3d75b86f4","_nodeVersion":"22.14.0","_npmVersion":"10.9.2","dist":{"integrity":"sha512-gxB6uMQnLkuOPS8woqHbvkBvRDJEsI8aVJmY9P82bDd6kwRr4B5ULt8jRJQI5nV9C7PQ11uhO89cO7MeDhykmw==","shasum":"da5a40a5add38ca11188dbc49d225e80e67aeff3","tarball":"https://registry.npmjs.org/@apigrate/dao/-/dao-6.1.1.tgz","fileCount":7,"unpackedSize":59681,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIQDsgRNv6OJrrna4owKE8zXssBZ3l1j52b/5bdEibYavYAIgKIJ+CG67RhxaCegWFLpkFmbfaHTaiXDmbgBvJ59gl3w="}]},"_npmUser":{"name":"apigratedev","email":"derek@apigrate.com","actor":{"name":"apigratedev","email":"derek@apigrate.com","type":"user"}},"directories":{},"maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/dao_6.1.1_1750260345077_0.9299713268462746"},"_hasShrinkwrap":false}},"time":{"created":"2020-11-02T16:36:50.870Z","modified":"2025-06-18T15:25:45.476Z","5.0.0":"2020-11-02T16:36:51.018Z","5.0.1":"2020-11-02T17:11:09.560Z","5.0.2":"2020-11-05T20:34:56.390Z","5.0.3":"2020-11-05T20:38:13.304Z","5.0.4":"2020-11-13T19:38:38.117Z","5.0.5":"2020-11-14T23:22:00.260Z","5.1.0":"2020-11-28T15:42:14.694Z","5.1.1":"2020-12-14T16:51:55.748Z","5.2.0":"2021-01-04T14:45:55.168Z","5.2.1":"2021-02-26T16:18:08.156Z","5.2.3":"2021-12-06T20:24:31.861Z","5.3.0":"2022-07-19T19:23:27.572Z","5.3.1":"2022-07-19T20:05:06.346Z","5.3.2":"2023-08-09T16:33:03.061Z","6.0.0":"2023-11-30T02:08:25.580Z","6.0.1":"2023-11-30T02:17:12.527Z","6.1.0":"2025-03-02T18:55:42.123Z","6.1.1":"2025-06-18T15:25:45.270Z"},"bugs":{"url":"https://github.com/gaumeister/mysqlutils/issues"},"author":{"name":"Derek Gau"},"license":"Apache-2.0","homepage":"https://github.com/gaumeister/mysqlutils#readme","keywords":["database","data access","dao","db","mysql"],"repository":{"type":"git","url":"git+https://github.com/gaumeister/mysqlutils.git"},"description":"A Promise-based DAO implementation, designed for mysql databases (formerly @apigrate/mysqlutils).","maintainers":[{"name":"apigratedev","email":"derek@apigrate.com"}],"readme":"# @apigrate/dao\nA library that simplifies working with relational database databases, using a Data Access Object (DAO) pattern.\nIt provides promise-based functions making it easy to get objects out of database table rows with intuitive language.\n\n## v6 changes\n\n### breaking changes\n\n- Removed `lodash`, `@fast-csv/format`, `moment` dependencies.\n- Removed ExpressJS `db-api.js` helper library.\n\n### other changes\n\n- Removed unnecessary type casting for dates.\n- Introduce `query` method for better clarity. \n- Deprecated `filter` method. Use `query` instead.\n- Remove unused `log_category` Dao option.\n\n\n# What it does.\nCreate a DAO for each table in your database. Once instantiated, you can use any of the available methods outlined below\n to query, create, update, and delete rows from that table.\n> Note, this library is currently designed to work with mysql databases (note the peer dependency).\n> Support for additional databases may become available in the future.\n\n## Single Row Queries\n\n* __get__ - selects a single row by id\n* __exists__ - similar to __get__, but returns a 1 if found or 0 if not found.\n\n## Multiple Row Queries\n\n* __all__ - selects all rows in a table (offset and limit are supported for paging)\n* __query__ - selects rows that meet criteria\n* __count__ - similar to __query__, but returns a count of the rows that match the criteria\n* __one__ - selects and returns only *one* of a list of rows that meet criteria\n* __selectWhere__ - same as __query__, but an explicit where clause is used as input.\n* __select__ - supports a fully parameterized SQL select statement\n\n## Insert and Update\n* __create__ - inserts a row in a table (returns an autogenerated id if applicable)\n* __update__ - updates a row in a table by primary key (supports sparse updates)\n* __save__ - \"upserts\" a row in a table (i.e. performs an update if an primary keys match an existing row, else performs an insert)\n\n## Delete\n\n* __delete__ - delete a single row by its id\n* __deleteOne__ - same as delete, but supports multi-column primary keys\n* __deleteMatching__ - deletes anything that matches the provided criteria\n* __deleteWhere__ - deletes anything that matches the provided WHERE clause\n\n## Generic\n* __sqlCommand__ - issues any kind of parameterized SQL command.\n\n# How to use it.\n\n## Instantiate\n\n__Important Prerequsite__: your app should configure a [mysql connection pool](https://www.npmjs.com/package/mysql#pooling-connections) that it can pass to this library. This library is not opinionated about connection management. It does not close or otherwise manage pool connections directly.\n\n\n```javascript\n//var pool = (assumed to be provided by your app)\nconst {Dao} = require('@apigrate/dao');\n\n//An optional configuration object containing some options that you might want to use on a table.  \n\nvar opts = {\n  created_timestamp_column: 'created',\n  updated_timestamp_column: 'updated',\n  version_number_column: 'version'\n};\n\nvar Customer = new Dao('t_customer', 'customer', opts, pool);\n//Note, in addition to tables, you use this on views as well...\n```\n\n## Read/Query\n\n### Get by id.\nGet a single table row by id and return it as an object. Returns `null` when not found.\n```javascript\n//Get a customer by id = 27\nlet result = await Customer.get(27);\n//result --> {id: 27, name: 'John Smith', city: 'Chicago', active: true ... }\n```\n\n### Query\n\n#### Count\n\nSimplest form of query. Retrieves a count rows from DB matching the query object.\n\n```javascript\n//Search for customers where status='active' and city='Chicago'\nlet result = await Customer.count({status: 'active', city: 'Chicago'})\n//result --> 2 \n```\n\n#### Query\n\nSimple matches-all query. Retrieves all rows from DB matching the query object as an array. Returns an empty array when not found.\n\n```javascript\n//Search for customers where status='active' and city='Chicago'\nlet result = await Customer.query({status: 'active', city: 'Chicago'})\n//result --> [ {id: 27, name: 'John Smith', city: 'Chicago' active: true ... }, {id: 28, name: 'Sally Woo', city: 'Chicago', active: true ... }, ...]\n```\n\n#### One\n\nIdentical to query, except only the first entity from results is returned as an object. Returns `null` when not found.\n\n```javascript\n//Search for customers where status='active' and city='Chicago'\nlet result = await Customer.one({status: 'active', city: 'Chicago'})\n//result --> {id: 27, name: 'John Smith', city: 'Chicago' active: true ... }\n```\n\n### Advanced Query\n\nSelect multiple entities matching a where clause and parameters.\n\n```javascript\n//Retrieve active customers in Chicago, Indianpolis.\nlet result = await Customer.selectWhere(\"active=? AND (city=? or city=?)\"  [true, \"Chicago\", \"Indianapolis\"]); \n//result --> [ {id: 27, name: 'John Smith', city: 'Chicago' active: true ... }, {id: 28, name: 'Sally Woo', city: 'Chicago', active: true ... }, {id: 28, name: 'Jake Plumber', city: 'Indianapolis', active: true ... }, ...]\n```\n\n## Create\n\nCreates a new entity.\n\n```javascript\n//Create a new customer\nlet customerToSave = { name: 'Acme, Inc.', city: 'Chicago', active: true}; \nlet result = await Customer.create(customerToSave); \n//result --> {id: 27, name: 'Acme, Inc.', city: 'Chicago', active: true}; (assuming id is auto-generated)\n```\n\n## Update\n\nUpdates an entity by primary key (which must be included on the payload).\n\n```javascript\n//Update an existing customer by id.\nlet customerToSave = {id: 27, name: 'Acme, Inc.', city: 'Chicago', active: true};\ncustomerToSave.active = false;\nlet result = await Customer.update(customerToSave); \n//result --> {id: 27, name: 'Acme, Inc.', city: 'Chicago', active: false, _affectedRows: 1};\n```\n\n## Delete\n\n### Delete by ID\n\nDeletes an entity by primary key.\n\n```javascript\n//Delete customer id = 27\nlet result = await Customer.delete(27); \n//result --> {_affectedRows: 1, ...}\n```\n\n### Delete Matching\n\nDeletes multiple entities matching the query object.\n\n```javascript\n//Delete inactive customers in Chicago\nlet result = await Customer.deleteMatching({active: false, city: \"Chicago\"}); \n//result --> {_affectedRows: 3, active: false, city: \"Chicago\"}\n```\n\n### Advanced Delete\n\nDeletes multiple entities matching a where clause and parameters.\n\n```javascript\n//Delete inactive customers in Chicago, Indianpolis.\nlet result = await Customer.deleteWhere(\"active=? AND (city=? or city=?)\"  [false, \"Chicago\", \"Indianapolis\"]); \n//result --> {_affectedRows: 4}\n```\n\n## Generic SQL Support\n\nUse the `sqlCommand` method to issue any kind of parameterized SQL command (SELECT, INSERT, UPDATE, DELETE, etc.). The result\nreturned is simply the result returned from the underlying [mysql](https://www.npmjs.com/package/mysql) library callback function.\n\n```javascript\n//Custom query example\nlet result = await Customer.sqlCommand(\"SELECT id, name from my_customer_view where active=? AND (city=? or city=?)\"  [false, \"Chicago\", \"Indianapolis\"]); \n//result --> [{id: 27, name: \"Acme, Inc.\"}, {id: 33, name: \"American Finance Corporation\"}, {id: 35, name: \"Integrity Engineering\"}]\n```\n\n\n### Support for Logging\nThe [debug](https://www.npmjs.org/debug) library is used. Use `process.env.NODE_ENV='gr8:db'` for general debugging. For verbose logging (outputs raw responses on create, update, delete operations) use `gr8:db:verbose`.\n\nNote: as of version 3.x logger injection is no longer supported and will be ignored.\n#### What gets logged?\n1. error messages (database exceptions) are logged to `console.error`\n4. at `DEBUG='gr8:db'`, the following is logged:\n   * method call announcement\n   * SQL used for query/execution\n   * a count of the results (if any).\n5. at `DEBUG='gr8:db:verbose'`, the following is logged:\n   * raw SQL command output from the underlying mysql library create, update, and delete statements.\n   * parameters used in queries\n#### Log Suppression\nThere are two ways to suppress log output:\n1. Use the `DB_SUPPRESS_LOGGING_TABLES` environment to provide a comma-separated list of tables/views for which SQL/parameter logging output will be suppressed entirely.\n1. You can suppress logging on individual statements by using the option `{suppressLogging: true}` on the sqlCommand `opts` parameter\n","readmeFilename":"README.md"}