{"_id":"@candyjs/db-mysql2","_rev":"13-15dab4a05e5abc22af7f858ce22297d9","name":"@candyjs/db-mysql2","dist-tags":{"latest":"0.2.10"},"versions":{"0.1.0":{"name":"@candyjs/db-mysql2","version":"0.1.0","description":"database interface","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"afu"},"license":"MIT","homepage":"https://github.com/douyu-beijing/candyjs-db-mysql2","dependencies":{"mysql2":"^2.2.5"},"devDependencies":{"@types/node":"^14.0.13","typescript":"^3.9.5"},"gitHead":"d72989b7d0a260c4f01b846cb5fa875d89d73fd0","_id":"@candyjs/db-mysql2@0.1.0","_nodeVersion":"12.16.3","_npmVersion":"6.14.4","dist":{"integrity":"sha512-t4XKECF7bkSxbRRSyqyphkJU01/CLNrNAGPqEZ3n+ojcJM9LWrI+gIwv1fp/jiweOj5CV2mYshUoeH8D9Jdkng==","shasum":"012e34489de6de8239e8a14d56cfd5a2a7c4c042","tarball":"https://registry.npmjs.org/@candyjs/db-mysql2/-/db-mysql2-0.1.0.tgz","fileCount":11,"unpackedSize":26785,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJfoUVLCRA9TVsSAnZWagAAeI8P/3U+lcWIl7WCfQE/9/qP\n8V2WsUjkIPQ8D3lp11VrwxYroqeoQzs6KbIoOffvmo0gPp8GJVzw1wgli9kX\nDHKoBe3bdeaE0I4Ozv9cCiP1uLse2SXnQL9JmtcO/TxUl6/M2fuSBuupTpVM\n48zSfKn6m91sabsDeGtw16xwKGAa9KgkitzbYNxhIfSu5xsdQkvtKQi1njUt\n7k4MA8DbS0cCTcyFSbSbJC06iZBuEZt7FfBO1IlYBaaAztSq0KjhWcEGdNn8\npYqUkH4TgHoeccxMrDJOVgGUXwLG1kwoi4ClhTIjVSxXmvR/K31g5gBhw7Bh\nB5woqNNp674i1U01tAQ2M5jI6kCFx7ijSm27KjUbjYyBCMcEnSJKnpc1hXBA\nsRNviInqjubxa/FVyHIVKdp2RZqC3oozVBpbeAozov1vjMd/36//X/ufO94w\nlftiLpODYiWlyCTvqReTyVfHrPwtqCMOn8DX3eENsRXGZUFW1oHImZik16zY\nP/Sxzl11w4jjcTx9W4HZotkB8rTTBUIGX0LvKEv+Niunwf3JY32XlM6Zibdj\nwkcmda6cfKZFbd2uPvKkP3Ddqv4oCqShXAlzcLi0ztwLwh5epxdfH2+fPhfZ\n/JwA6mEdhqIBTaUaqiJj4aa6wQtz3ki0GoQRzda2dvdnMFh1UIIVHdlwDB7D\niVml\r\n=SqVs\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBjNO/7ZqeJurTUUxurE6EOZsXhonKyjm0xXRILKf9whAiAG1Z6APZXD9FGFYtIE6w4pfkoa0xV+qWEf+efbqgnhCA=="}]},"maintainers":[{"name":"candyjs","email":"ylp1127@126.com"}],"_npmUser":{"name":"candyjs","email":"ylp1127@126.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-mysql2_0.1.0_1604404554591_0.585094541912696"},"_hasShrinkwrap":false},"0.2.0":{"name":"@candyjs/db-mysql2","version":"0.2.0","description":"database interface","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"afu"},"license":"MIT","homepage":"https://github.com/douyu-beijing/candyjs-db-mysql2","dependencies":{"mysql2":"^2.2.5"},"devDependencies":{"@types/node":"^14.0.13","typescript":"^3.9.5"},"gitHead":"d9fba742bd7253b26c88648e70d2656f2fc5799a","_id":"@candyjs/db-mysql2@0.2.0","_nodeVersion":"12.16.3","_npmVersion":"6.14.4","dist":{"integrity":"sha512-3TwViVN+R8zdWPM/wBb1voVGyZUI+Ju8JIgVLCdgg1tvpf+s6lggvZJpK/z2WSooqFO8/g+VUZk1FVhmmkSNPA==","shasum":"23c9c71570e96d0a564964064e5ed48321a629cb","tarball":"https://registry.npmjs.org/@candyjs/db-mysql2/-/db-mysql2-0.2.0.tgz","fileCount":11,"unpackedSize":27438,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJf2YZQCRA9TVsSAnZWagAA9+wP/3zivEh1Uhx/2PqKjgGm\nMDihjPfcG83lVEX+/SGRtyx1BwH4W3SCSYj2z+CYs/Qe5b+lEAJsfY6Yz03f\nVI4Umz5CtN6U2MOuxT11nZnS6Vx25uQvaxwvvEWUutW81fx62woKtATNMDBz\nNNkco6OZSyQSOZs9mjDbtfl90zrjo9Zrfmb5/woiMr0HAgxycHlSzcPUyaht\nsiKpV5OQYyuRut/vUKAKTOmqcHvST9SEBZwoZQyDe0XWiB3Px8tubkCqj4gG\n9nPfP0avzmHTYuK8eDi5Dm09Xs7nbF71VWA/rs6+Jo2bxnmR5fyogyDYEZ88\ns7IDTuZdyncDSAgKMiSWlXKOkJESrXv7GiqiVfHExqV/3Dc9sgbP1tEeo7kU\nKJJInl1jeGnacEC38K7TrmwKVHaWcGPpbP2Bun5TwFsCfwxMXDdftkYsmi+g\nvP5ASWgaxOCIYRs+VFvHcjdqHKRXHDdd5jOroXj7ev9OVrleqWx99L1ERSmU\nTt2hAC81DjKuGj+fk6Y0RacU/UPX1fVajKLiyw3LEt7Bw0aySMQ3CZTEpS+e\nFjWqRFzrFnrqBpPD5pXqyGks09ODsAc0N0D47WbTLls3OIjM2++2YyxK7XRH\ngQlw5dzBWwYQE2UuK1vijje2uXl9uv8KJf94+XRlhRRdYPwkmCpYVaoBief5\n66tB\r\n=cmT/\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBKGI0iuBZgQdgP/g3J6n7ToxBqJ71ICc5P/rl41Eh93AiAgYheEbiAsOH4i84gr5JUg9H/UTRG8TfCxsNIyQjgV4g=="}]},"_npmUser":{"name":"candyjs","email":"ylp1127@126.com"},"directories":{},"maintainers":[{"name":"candyjs","email":"ylp1127@126.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-mysql2_0.2.0_1608091216021_0.0910639558861146"},"_hasShrinkwrap":false},"0.2.1":{"name":"@candyjs/db-mysql2","version":"0.2.1","description":"database interface","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"afu"},"license":"MIT","homepage":"https://github.com/douyu-beijing/candyjs-db-mysql2","dependencies":{"mysql2":"^2.2.5"},"devDependencies":{"@types/node":"^14.0.13","typescript":"^3.9.5"},"gitHead":"9fabd0338c2722a150ef2ee35818766f508c6be6","_id":"@candyjs/db-mysql2@0.2.1","_nodeVersion":"12.16.3","_npmVersion":"6.14.4","dist":{"integrity":"sha512-SjfGD9MUiqjnbang7YWh4MrkoGic3UToY9nuzV3JGBviqDdrbKunEykePyxXfseLJGje4Gy+Yq3t0hRjnWHbcQ==","shasum":"e7f70080dc7e724aad0ee420f4013b822c6d2477","tarball":"https://registry.npmjs.org/@candyjs/db-mysql2/-/db-mysql2-0.2.1.tgz","fileCount":11,"unpackedSize":27651,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIDxemYzJ8caEAFquT3OJkfQxvavTyRwWTd/GoC653UVjAiAtKLrR98XYpebGylotGrtqTijffZtdntr6of51XYZvHg=="}]},"_npmUser":{"name":"candyjs","email":"ylp1127@126.com"},"directories":{},"maintainers":[{"name":"candyjs","email":"ylp1127@126.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-mysql2_0.2.1_1632751257859_0.9821873004372217"},"_hasShrinkwrap":false},"0.2.2":{"name":"@candyjs/db-mysql2","version":"0.2.2","description":"database interface","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"afu"},"license":"MIT","homepage":"https://github.com/douyu-beijing/candyjs-db-mysql2","dependencies":{"mysql2":"^2.2.5"},"devDependencies":{"@types/node":"^14.0.13","typescript":"^3.9.5"},"gitHead":"29a56e86b13a49cafaba4de202bd91eb6df6c3e5","_id":"@candyjs/db-mysql2@0.2.2","_nodeVersion":"12.16.3","_npmVersion":"6.14.4","dist":{"integrity":"sha512-KRv14EN1izSqHC90IMsIqZ17i7D7Jh08GV33kGS0qaP9SpusPuLlJj5G7Ay+vF7zLnpUnWTorw9/PGsjGojbMQ==","shasum":"c18381d70b5d2ca81ddb8fdd49f47e0f5e3f4391","tarball":"https://registry.npmjs.org/@candyjs/db-mysql2/-/db-mysql2-0.2.2.tgz","fileCount":11,"unpackedSize":27814,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJh2CKQCRA9TVsSAnZWagAALgoQAI0WDL2ku9VJzn0bISh+\nNi2Wge4RmKVHMSigty/5lrJ8BxNmjFn7YUpyu3JbNlOvUoHbnQgw8+jMxb5w\nEcPvqAyYpsopVV3fmj2XvLW7Y1SB769yccEX8WAqw6QYBTkpZC33XHpxTm5O\nd024POA7uWgNFYteAJTrLQ6KNHtqFHWVSPvaPzZGOHmyIm/brD4ruKQZDZpx\nVZAbZ2X1uPvQfxyXIYU9TgDqo+kkcTbfJvLvH7hYbN5CkRTmqJgHtozpAM1q\nqsLNAgQJ3RfL+3b70HsEW29y5svBFbXSMAx8gjeHNL4u0BATJUHXpB9+C3xK\nyt0vKMiIPqtnYc5nyKpmtH/46SCFQfPLXfMs4fo4/IwkS91F8geh31yCvOR/\n9Q/E/yJGYrsA7X7XXj9XYWtmQRE1kOrBRVTap3T/QXUGvj4eknC9HIreaglP\nyY7oxS4Q1TumQVeWoW9/ARNnsIx/yjk0J48RyNGPkSpJM3Kfr4hQbSD22AQa\nIrIIqOe7GyAiee//GRfxLzDQFOZYwYLMRUaNCR3NI2Wg1EvQx3ukyl96S+wL\n+Wip0GHAQB2PssCc+OnbhbF6B8DExOPcaSXN0o1PW78XgNSro8oPd/vsThEH\nwnDDqKUy4z65ak6JIjWQvVIUMUpaCl2dMgQY5qpJnUfm9E5PUYWZOSSpWkap\nAyg2\r\n=XrR4\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBNFGUI5AScF6DCQqC88tvXyoUmTMblw1IoZ7QARKD/SAiAPZrIYl9GCAycdCK7Sfba4cctJv/aaqzE/z+N5vddPhA=="}]},"_npmUser":{"name":"candyjs","email":"ylp1127@126.com"},"directories":{},"maintainers":[{"name":"candyjs","email":"ylp1127@126.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-mysql2_0.2.2_1634197706250_0.08333782856943195"},"_hasShrinkwrap":false},"0.2.3":{"name":"@candyjs/db-mysql2","version":"0.2.3","description":"database interface","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"afu"},"license":"MIT","homepage":"https://github.com/douyu-beijing/candyjs-db-mysql2","dependencies":{"mysql2":"^2.2.5"},"devDependencies":{"@types/node":"^14.0.13","typescript":"^3.9.5"},"gitHead":"0f99356a95c3ab3817da5a957d939e389a91593e","_id":"@candyjs/db-mysql2@0.2.3","_nodeVersion":"12.16.3","_npmVersion":"6.14.4","dist":{"integrity":"sha512-gBVPuPJSxxU1vgLs6+U6sm8sIH7GpBvhY1QU3tLJTeA4+YLYIkkE4+RSCZxRXAd8rv36WV8/9Qm0xIqyxKD2rg==","shasum":"9d6e4f7828f1b9adf808862693ff1f20de0413ad","tarball":"https://registry.npmjs.org/@candyjs/db-mysql2/-/db-mysql2-0.2.3.tgz","fileCount":11,"unpackedSize":27784,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJh4TXRCRA9TVsSAnZWagAA/64QAIdpaKWGfS2iyCk4ERJA\nXbEfGwn8MgQNsPnnxtJOmYmsFRNL5XPF8Obr+boHbSVptrHqd9TxFNE7+6j4\n21WzHHo6CFqKBr5DFStaYMRxZf3ngWRC3rxbBQMah1H4hgTzoaJHDcajVRyj\nufdUdWrQJdD+tTl2RLMWEmr06xnpz1msnHzw0zeBkAxI82GDsaTrFtSb4ZhV\n1ZBhJuAf5o2bwtsk075nyuvCTQhcdgOkMn7QIzzjdmJQwFZ415rvSp9RSrYR\n5AtzErrCxwBsw9BGGCxAIBjgmKChG6IViiN5VD+eVhq/tMpGC6AQmDLYeDUq\n3yejqwOrIIRcgF+w5L7CxavRzmuU6/tqWcqO9JaRditpLfiKjryk+7ihafnh\nmEr3JqQvs8F2h7IDFB6JPxz+n/7zVaqajY0EO3xvrRjJhZUn6n1CA6u6SzBB\nWYE0NLTTxlhjByue5lLlYtxl7q411ScpQteOv8WU+74jyTYuMDaPkxTdoG/E\n5VhHvMUwZ4ltJX89BNy8kGAGRcMsm4U98SYSvf2ryLjmWL8ICMsU9C3diTM9\nEmRlIFjLJyrgEcHw9HRRm9JNngD9Ig9BV8qOEbk+MSzFCTGqLyHHtrADPWLx\nZFfCoEQD500YH1YwQopwUL6nvNfjrtm5qIssNT72WL+NjQ00KHhn4b8hoqkX\ndnFU\r\n=WRfu\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDLOZSfJYc+eplb0aSlah6mAkOxcDcfRHDknJ0PgWvD8AIgP/vF6WL5cA2LbSs+DxDRlAaAg/l/hnqU9tFb4CdhLek="}]},"_npmUser":{"name":"candyjs","email":"ylp1127@126.com"},"directories":{},"maintainers":[{"name":"candyjs","email":"ylp1127@126.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-mysql2_0.2.3_1642149329190_0.662407754193644"},"_hasShrinkwrap":false},"0.2.4":{"name":"@candyjs/db-mysql2","version":"0.2.4","description":"database interface","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"afu"},"license":"MIT","homepage":"https://github.com/douyu-beijing/candyjs-db-mysql2","dependencies":{"mysql2":"^2.2.5"},"devDependencies":{"@types/node":"^14.0.13","typescript":"^3.9.5"},"gitHead":"fc9c199aa64e912d2ebc0610e05bb174f28fa803","_id":"@candyjs/db-mysql2@0.2.4","_nodeVersion":"12.16.3","_npmVersion":"6.14.4","dist":{"integrity":"sha512-CSm4QhOoOq7xW8Tc5M7BOrekHcjExxCAzjhX4iM/GmO2GG29QIrvi4sdgcMhEZ/7ktSq6QDWxnNj3rCxk6ikSg==","shasum":"28e83217679583f72d9ecaab2a1ed96060aba169","tarball":"https://registry.npmjs.org/@candyjs/db-mysql2/-/db-mysql2-0.2.4.tgz","fileCount":11,"unpackedSize":30966,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJh5nbYCRA9TVsSAnZWagAAHRAP/3DBK/fI//q7A+bIyCMC\nfIVDO7GbMRySVJdnOK6ofllpYQIoOQz9wZBDSrtdAd8eFD0SaTwsqwmxNHBV\nO17vraEY4/bFC12woqYvNB5x6znwaYEKeVll0bswK4EO9vrxvhtasSgdCfa0\nspbi0yp1m0FrOzgTK+4FaVo5H0vsxAla21X/M+XbxBtzHcwW3PYY6oYOzR0L\n3JSToChDcnWPYcNlFLjctRYTz69slXYnHTONWtkcMSGV/3X2Fo1U5vl/sdsb\nJLRATlN/tBufShBv5Pye5UbSjqaP0wzpA9vD1bYd6NrsQPIZIXfvkyO/9wSx\ncilKuhW3+tgyswogAkOXUHbnwr1IV0hGC73gveYWoVBzAVBP1sISnOyYXRBc\ndW4uJ0B/f9c2v7InSizVjtgtgiaY4HKj8+cGRe2yWScdaCADPnOw+vneU2iH\nQxwLxiK6N8osaROy4D8WoUZessyUZTTB1hlhuem1oNrVsgsxCpeFbtMBsR9v\nofhJBytTQm6vcf83AujYX4LQVSZCADnrdw76DEvFlbvpVHjn/19tSr4hfq+5\nECqeRMXRky8rxjGir/MNN4+mnCORDLaXDbHjK2fqQVBQAOnhdTS5bNU/KvEy\nPjcR4L0pLx4dS3/nzVTgI9lV8ZHn8Uex5yKGYFEuCR30Tf/FlnK0AkIMt2vd\nFVO5\r\n=R9mz\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD7eaYuWrPcu106webM2IywIwo02H9sdynUSAXwodJdVQIhAJEyEEO4770f+yQufQOxNE907kDrLDRLRlfKY75HQAhN"}]},"_npmUser":{"name":"candyjs","email":"ylp1127@126.com"},"directories":{},"maintainers":[{"name":"candyjs","email":"ylp1127@126.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-mysql2_0.2.4_1642493655845_0.2275972984243242"},"_hasShrinkwrap":false},"0.2.5":{"name":"@candyjs/db-mysql2","version":"0.2.5","description":"database interface","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"afu"},"license":"MIT","homepage":"https://github.com/douyu-beijing/candyjs-db-mysql2","dependencies":{"mysql2":"^2.3.3"},"devDependencies":{"@types/node":"^14.0.13","typescript":"^3.9.5"},"gitHead":"b333ddde4f917ef5dffe0e86c60eabcba45804fe","_id":"@candyjs/db-mysql2@0.2.5","_nodeVersion":"14.18.3","_npmVersion":"6.14.15","dist":{"integrity":"sha512-S9NKLcy1V2bLhMLaMz6IkUZwH1VGshsD/n7xA3oQzDN3eTjpEBbSVExYdSoC3u8WsBApmGK+6XJV7BeWM1CSqA==","shasum":"1c04d82a10feec0d36dfaa667bfd766f20083128","tarball":"https://registry.npmjs.org/@candyjs/db-mysql2/-/db-mysql2-0.2.5.tgz","fileCount":11,"unpackedSize":31117,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJiFyc8ACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmqRag/+LqhV82tB7UUPnCbRY/kRn7WTKDZfrGOW0CFT7YcxAmGsZHft\r\n2gfy4QHNL6zJhrVdQheH9DdLka7zzziNpFuMeI1CoPHyTGqtlHLR6M0vP9p/\r\no8hNQNPFkheaM7t6mhN9UEPv5jimnQvnaNMlaYgjc4vfTySOpZSVZ2SxiHN5\r\nYmR6MymSQQRDChkhR/ssvHEleqhR437pApt116whWpcmXzt/66xtRNwnRLdd\r\nrBu5whWBp6iU1X5vkBsRassq8xvCfGQ2Fydle8y00c6j991ukv7Ll0P9MnTH\r\nUIMvXovwvj3sISVEYSf/uXQbGmy+9u92z/FkHqpxTXjmtnQiTyny6HZKxNFP\r\niXNrxQfjsTAz0AZUpzPt55hppP+2sO8tiB5cIribK3KRdYKruRRggeDl9JG4\r\nC08jSCtCxe0hOHqIxNsOgViUQNw5aZ58dY19QDP3ydNdSnSvKzVEDA/jowTO\r\n2VryELv9/VDfv/65wUeEMTY/qubaSDCOvQzhd4NIQDrMHLlA+flpWcEFiy07\r\ntsrkgc/BIGT87dN330k2ShHJ6FZB9LPRD9n0gluKlypAfA9rbS6a5JmioZ5X\r\n8CeDh7UwFm4qeg9c4t0ZNb7THf+C2qLfikehzsLwosq6pOt9qm7PQCx9I/8z\r\nl92H8zPSTyKd+g6A6VVXRxrsabffARXJgP4=\r\n=E8au\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDzDs0K3uO/6mcutRMmzyRjCs+7wzrvIHukIpacbpHYBwIhAPHzQqAj5vcLiwGqGsWIMOAi/n3P3wDbWv0VktttLpKW"}]},"_npmUser":{"name":"candyjs","email":"ylp1127@126.com"},"directories":{},"maintainers":[{"name":"candyjs","email":"ylp1127@126.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-mysql2_0.2.5_1645684540388_0.9702325002427321"},"_hasShrinkwrap":false},"0.2.6":{"name":"@candyjs/db-mysql2","version":"0.2.6","description":"database interface","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"afu"},"license":"MIT","homepage":"https://github.com/douyu-beijing/candyjs-db-mysql2","dependencies":{"mysql2":"^2.3.3"},"devDependencies":{"@types/node":"^14.0.13","typescript":"^3.9.5"},"gitHead":"485338c69983c808508660372b37aed0b6a4b906","_id":"@candyjs/db-mysql2@0.2.6","_nodeVersion":"14.18.3","_npmVersion":"6.14.15","dist":{"integrity":"sha512-ukyO9/jsO5RpPj8zP/bgtG3FHZer4bK2QsLTwI/fFz6GxAj5ZqjoVPsauBUPp6Lq8pBiNKkVrN1CAASAlxUPcA==","shasum":"31c09a102fe487e8bab02903a967057e8d5d2efd","tarball":"https://registry.npmjs.org/@candyjs/db-mysql2/-/db-mysql2-0.2.6.tgz","fileCount":11,"unpackedSize":31614,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJiIXw/ACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2Vmo0Tg//ctJyjy6yDjiati6o3zFOE4m95fIufA1FFhe15eItt38ig0bO\r\niqRefZpf37g5AYTv/4NwSZHXyHTEBLvhSdFWIK1DIR8VUKt3gRXQ3gsVtd6j\r\nUCPuuwIlOid2aH8HGy2jZEZtjwPmEGUcodUHiIfh0s5ON3VbcgeJKxoXbZt9\r\nyNxKkPo1x9hQMSboKIdH1adS3yYHEmczzPIi+ft4cd/ZJym6cSUZaqdg52Rq\r\nJfcdWV9btnjGnQ6AvwJGCmVw0vxq/5gm40VDoNx9p8gx2w2Czrgh9mXTvk/8\r\nufQPh1lSxwu2gWQu8xH/E1x4m7XymlBrNVPIxziDh0svWPuRWFgmYvdnyu0T\r\nMLpOfVIcoOGVT0ulrReKg58dugOylR3o45nLh9SdHbrEH3/6cSb6NWgSq8b+\r\n7qLXcnLM8mNZHBzcAHX8pegdd7G4Dy+QzDQAqT0iXwGF2eTof0lz9uAeZ6f+\r\nI9x5nTUC668CqGZaGzTZlkUFVDA3uga0Jii1CAh6sTX+VoFAHhlO332Pee33\r\nGbzY3ny/aJ83u8YQ8NCKouEUy4DDZ9clXzafIPDDGI6/dh0uyUTXHp6+/HBX\r\nwp0i5Rh0syqIil2BjJFQmy1tOuBFMDiHjTQeFMCzaN5wVwmqxLR0xNt+PPxB\r\nWybjGA8zSW7fc8nKITGC4dgoJYEyGQ/cHcE=\r\n=K5ex\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICsMxmznCvB9fs4HJr+QVwAp/YEoH2whaQpMF2dpAPkVAiAydX0VDXhhwyfoZuMX2BiTJ3GmHLQBR/GlME3HlTTbYg=="}]},"_npmUser":{"name":"candyjs","email":"ylp1127@126.com"},"directories":{},"maintainers":[{"name":"candyjs","email":"ylp1127@126.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-mysql2_0.2.6_1646361663524_0.298518114117563"},"_hasShrinkwrap":false},"0.2.7":{"name":"@candyjs/db-mysql2","version":"0.2.7","description":"database interface","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"afu"},"license":"MIT","homepage":"https://github.com/douyu-beijing/candyjs-db-mysql2","dependencies":{"mysql2":"^2.3.3"},"devDependencies":{"@types/node":"^14.0.13","typescript":"^3.9.5"},"gitHead":"f8b4ebca2b465758332df07c50b399d62ce0a063","_id":"@candyjs/db-mysql2@0.2.7","_nodeVersion":"14.18.3","_npmVersion":"6.14.15","dist":{"integrity":"sha512-yaqIJTSaHs2frdA11ezNQVcjUt88riSIE8iOkjCUcE6tA3+FD00eANEnV+mHNVFu3+tMGsrY4Ed4LZ2zsiA5kw==","shasum":"c295a268808fb4f0d1c9e9a800031b8e4b88c8fb","tarball":"https://registry.npmjs.org/@candyjs/db-mysql2/-/db-mysql2-0.2.7.tgz","fileCount":11,"unpackedSize":31744,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDgucS+8AHPCeqQpPh4DoMaReiH87M015b7vl+G5EIZigIhANcqPn/qefBU1bHDm8oV/VedHfcznzJtcZVGntN+vPod"}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJiU9HCACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmqWQg/6Awu52c0prwnosGtMYSHVSzMkj4Dw3x7lNlm/oIwDSEl+qOmw\r\nEMGXY8HFqd6qlfRtiq2MCldv/7j2FD8YBqW/sgv2OfMU7+jqyl52/7DyB/54\r\n7ts3HCdJjwYFOnCxeeyPnkV8onM8V82IdmAMZi19j0qN3mpwF3uHM08jkBrg\r\n644yoN/8s3lc5SQrisfC+ii2hhzTu2qPu1Iix8L4ZjfP3toCrspqvUJW+QFQ\r\nke9yESUuLhq+42NUD5sJI81Eo4Toc9fwKdEMflDO//mgJ+MlAUdz6q7rxmWd\r\nuvcGok5o75WtppqMXMJnI8pgX9jYe0vv3k8+Ttc4xEvpwCb/HwSXpYk5AbZj\r\na7xk7JCSQpkf+pm/5D/KLdGVGLeL1eui2aPrDhk98H7L92ox7ywOnBaSB3S5\r\nirKpaX0eALpELtKsSetq7sIxPam4yPD4uKSiL8+YzaOqnwJmWe6gPm35MKYo\r\nYRmoxkijJRDI6QoewZ0h2AVahOYaPOD2GM7cAxZCciZijd6vUrxTsloU4Yt0\r\nJ9z9ekTN0dpCHSXZ2DrswECoT+DyaYvhaFEjiEM7Ir1T4Ji4iUmft6+xZXxC\r\nG4jKzupOhMfBSj+GrzUx9tLsZnU3SWQFKj0+yV1DehxKoWX7bvpxa3uItGWt\r\nQpCLin1QNS9Gf5AMwlx/t1VetTcTknLMMuQ=\r\n=Eofb\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"candyjs","email":"ylp1127@126.com"},"directories":{},"maintainers":[{"name":"candyjs","email":"ylp1127@126.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-mysql2_0.2.7_1649660354338_0.13520184848934447"},"_hasShrinkwrap":false},"0.2.8":{"name":"@candyjs/db-mysql2","version":"0.2.8","description":"database interface","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"afu"},"license":"MIT","homepage":"https://github.com/douyu-beijing/candyjs-db-mysql2","dependencies":{"mysql2":"^2.3.3"},"devDependencies":{"@types/node":"^14.0.13","typescript":"^3.9.5"},"gitHead":"f1093b6d6e8d2936e45f08fa30aa836e4cdae433","_id":"@candyjs/db-mysql2@0.2.8","_nodeVersion":"14.18.3","_npmVersion":"6.14.15","dist":{"integrity":"sha512-u8o5VA+H//GeRgcEeIZAQ18ihU5VAKDQ7DSg5vSLjmeYOvj4LiBPSIvxwySGhOAnVembiXkRlz26uHPU46Oopw==","shasum":"3a12c625fc797f76f9f1337cde5e8e343c04b04c","tarball":"https://registry.npmjs.org/@candyjs/db-mysql2/-/db-mysql2-0.2.8.tgz","fileCount":11,"unpackedSize":31734,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIB43UXcvtQAkGaU3J8IyPmjOS6Hw2REDTpcLC+6ZLmgCAiEAuNY6DTLL3/sTdQBDOP3dRcsGjGgyy+d9h5b44IpkBjs="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJii2BgACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmpZSQ//c+4JBanWq/t99Ab4Dhv+puWFjfgNm1sEPpEPJmvDET8VoY1J\r\nkSjFrvthXKksh2y0Z6/h9boZVtOpTa7l99pazbIwLNtTo+/z0fwmO2uw5qto\r\nkDWf7Z705KI15vxcTGW/fX6rZL6hzRsF55sFIcZkbsMg2ML3XGyboXbNmZ+b\r\n6JkYAWaLyFnfcCY1qMzLK8j6btnQ332TlFmmCgl/Brtb9ercdSTUgEJPaUyo\r\nNOOgxJAJbGAaABP8wU1Jiy2NbZIdsOg0R09TW1sRir4MMQcCE1ko3B3HSFIr\r\n1hcFZzM3qLB0oNaBS1mTca9AAg7l/cwZ5bqXSLjMaorRV0lPPoE9geaknGSw\r\nLXEBeKmH6TE+SblwNyBbrZn/Ac0MjGVcW0/eyXRJ+2miID8Nyv3Jckl6O3W+\r\nJe4HHMELClBdtTbSc0MkzWnWFF8pUPAkMQKrimFSJbclovkzAPrGRk7nJmb3\r\nhk8js1bOO+QR2PalICw6jmNOFB+Y/c7xQgK8juxEP/zbi5YscJtBXzKvttM1\r\nmG4cm4GjdHLIDLaXFtkLBYjJjN9OjuVp1Rmkp9NC0GNvfL0OwInNxsLLtRjX\r\nJ8kls6OhTYC5aF6S0fm/jQSJxtxMKd9KgXZl3ULveYbgm4Oh5bUEsh5LH0eF\r\nTSDcq4QgScA8e4MYOXA9fy0a57EmOFA6Pi8=\r\n=PGex\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"candyjs","email":"ylp1127@126.com"},"directories":{},"maintainers":[{"name":"candyjs","email":"ylp1127@126.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-mysql2_0.2.8_1653301343951_0.7999319611740574"},"_hasShrinkwrap":false},"0.2.9":{"name":"@candyjs/db-mysql2","version":"0.2.9","description":"database interface","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"afu"},"license":"MIT","homepage":"https://github.com/douyu-beijing/candyjs-db-mysql2","dependencies":{"mysql2":"^2.3.3"},"devDependencies":{"@types/node":"^14.0.13","typescript":"^3.9.5"},"gitHead":"e44ca3ecfce42f8086ec500e1165bb141c595da2","_id":"@candyjs/db-mysql2@0.2.9","_nodeVersion":"14.18.3","_npmVersion":"6.14.15","dist":{"integrity":"sha512-8ZJurOJpHF/YzcymcjSGt7d67CHdqvUBRF52s9Z/TLhy6unGxrjEvgFvjxqU0E5V8ZSYeZdaShqpLVJgUUC0QQ==","shasum":"2483935abc181c95a07ff4e0615791d158ee0469","tarball":"https://registry.npmjs.org/@candyjs/db-mysql2/-/db-mysql2-0.2.9.tgz","fileCount":11,"unpackedSize":31927,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIAl2RxgHMGppGluom18pjN3JvfkXE9vBRVAtTnz2cM0OAiEAhENco6NCgwrZ/xiH4QXr481ECUJJL0S3DpdU7NBG7no="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJijZVOACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2Vmr8kQ//U4heEtjRhfhk6riu3Oa4wVOuGqOKs6ub/jXrZp7q9YX36ElC\r\n7AW3vjzC7Q0utOTa+rENxgnp6PPraY7MVjizGhe+EIb1dKfcv0O+ji9HCbhY\r\ndAiCCqMl57F73jCqq7jUkfcND4/QYY9ce+AJFpSaRgXzXa6u7Q7Th0Cy9Wdb\r\nrOx55SI7xzdUp7ehyCAnM6oV3MIM3XlRBR+xOUq4btafpidaaxdgpQlLERYe\r\noRZaSmceJ4xG96ZSZ5l55pj2zcAKvCS1LbP0u+azTLWYonIrD9MmdlsVdqTg\r\nZV+NJ62yh8V8x6bR/MsqiScBqXdaCTjMDOI9CbLxtJAP9SLqQ1+MPYWPBzgp\r\nCsaWhmMavuyHi/LEdEl8Tv6UYBr4H19izjH+pEtDm0k/bStraVRj7VUwYBuT\r\nuRNbiU4gyaNsHOa2mJVFCUy3mQ3L0tX9a7v3WZzSHHKjIAbEKCDfGn/fTt/N\r\nGzZ8/nxFoG3EdXFp1tFBSUCdzFY6/FylefVrvLiLoVbqZaXx/B9hfkvRZI6C\r\nWQqghJSg32RdO83+aV9+AbiCSFj+TBKV6dsgiUmDxlnnrJh5tWM9/izX1jSr\r\nqlToNgx2ujvjMlhLA1lE49Dv1Sc2FlsvieqcD2Ax5gG/ZGR/B2I9yU+k0eBO\r\nFGwEAZfpFW+IT57GCnFCSZOWvvpkkXPO2VM=\r\n=MKHp\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"candyjs","email":"ylp1127@126.com"},"directories":{},"maintainers":[{"name":"candyjs","email":"ylp1127@126.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-mysql2_0.2.9_1653445965854_0.49860239964553443"},"_hasShrinkwrap":false},"0.2.10":{"name":"@candyjs/db-mysql2","version":"0.2.10","description":"database interface","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"afu"},"license":"MIT","homepage":"https://github.com/candyframework/candyjs-db-mysql2","dependencies":{"mysql2":"^2.3.3"},"devDependencies":{"@types/node":"^14.0.13","typescript":"^3.9.5"},"gitHead":"a7b7bb549d4dcd28e5b598a403f638d23d90c8f6","_id":"@candyjs/db-mysql2@0.2.10","_nodeVersion":"14.18.3","_npmVersion":"6.14.15","dist":{"integrity":"sha512-ECHwWIVTfu/Jzwj6oUxaLhnysFMdoCiyseF1zF52JKGn49+HCvF44NEWzk3CRsi4Ir3po622vyw6sHXB1CAo8Q==","shasum":"7e4cfc8dab986f536e0e1a923bf39fbb025ac458","tarball":"https://registry.npmjs.org/@candyjs/db-mysql2/-/db-mysql2-0.2.10.tgz","fileCount":11,"unpackedSize":31929,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDuX4qUd8CyuEUzzQ6BkkmJW6d742N8hlFDeTcmwOnZ6QIgN6/YoPlKGk3CfE1LnIHYKLNGHksXjfaUIk9CQz2HYvE="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJilsNKACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmrnJg/+J/Xk+rqDb/onJ89vfyl+WwqUF6PPJNeHfAn24FtOYfjT6GHp\r\nYfvmiepQiXOMpvWGZHCeL64vL9RZNG6/Vw+YijojXm8wShOVuSCexi4qqUFf\r\nAeSgAG84pAHS9nUqzD9sxuYWuaAVRTiiSbE5WVWV/y9+s2+MLcafiSmtLdjv\r\nUhs7qexM1zwLDdGwKQujwj8iY2J5T1wnXcgr5vGGryg3LPMbPmhi7TV70Oz7\r\nu12A0comsWxxdd73DOORYo761+bt5Y+w6qG2iL90PeNsWYxG9eULPxuE1heP\r\n3oVU5FwKnjgv+b2uTEZniflgwPdezBh8t7Juu6eKZG69bCGCDAnGqGp/Am9G\r\nM+tow9kDPquAppoaWQECoCRqoGWFRo2vLf9yeGvMkf2uAmE8aFgQ+VMtTyp/\r\nG+JMU9fAvy7olocUuijWicVolu43xckFHE78oIT5yJlJQUgU6sxCkJGnjgqi\r\nuXjJ8r4jBbJ2gqZ+wZTiyTQ0EOpwQ4CqHH7zXzy+2OJbiLE18LHiKqzlFoq5\r\ns4qabup7v63ZgDmmrLqdr8hrNYZU+K2VLzAYnIjxDfi2pXvenyina+s2LoeC\r\n+m71FDJRoUhDaUqbEl1FoFX49nM3+DkDnUHxgY85jwa9epJ4WCpi3+Yox1Kg\r\nx66GIjkzGpmgWnpUbTasbGrhqiytrpjT25o=\r\n=qQ9d\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"candyjs","email":"ylp1127@126.com"},"directories":{},"maintainers":[{"name":"candyjs","email":"ylp1127@126.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/db-mysql2_0.2.10_1654047561743_0.9729898277212063"},"_hasShrinkwrap":false}},"time":{"created":"2020-11-03T11:55:54.534Z","0.1.0":"2020-11-03T11:55:54.721Z","modified":"2022-06-01T01:39:22.057Z","0.2.0":"2020-12-16T04:00:16.149Z","0.2.1":"2021-09-27T14:00:58.003Z","0.2.2":"2021-10-14T07:48:26.431Z","0.2.3":"2022-01-14T08:35:29.348Z","0.2.4":"2022-01-18T08:14:16.015Z","0.2.5":"2022-02-24T06:35:40.529Z","0.2.6":"2022-03-04T02:41:03.666Z","0.2.7":"2022-04-11T06:59:14.487Z","0.2.8":"2022-05-23T10:22:24.344Z","0.2.9":"2022-05-25T02:32:46.043Z","0.2.10":"2022-06-01T01:39:21.975Z"},"maintainers":[{"name":"candyjs","email":"ylp1127@126.com"}],"description":"database interface","homepage":"https://github.com/candyframework/candyjs-db-mysql2","author":{"name":"afu"},"license":"MIT","readme":"## candyjs-db-mysql2\n\ndatabase interface\n\n## 使用说明\n\n+ [安装](#安装)\n\n+ [使用](#使用)\n\n    + 配置\n\n    + 使用 Command\n\n    + 使用 Query builder\n\n    + 使用 Transaction\n\n+ [配合 candyjs 使用](#配合 candyjs 使用)\n\n\n\n## 安装\n\n`@candyjs/db-mysql2` 依赖 `candyjs`，所以需要同时安装 `candyjs`\n\n> 担心安装 `candyjs` 增加很多额外依赖？不必担心，`candyjs` 默认没有依赖其他第三方库文件\n\n```bash\n$ npm install candyjs\n$ npm install @candyjs/db-mysql2\n```\n\n\n\n## 使用\n\n#### 配置\n\n`@candyjs/db-mysql2` 使用主从架构操作数据库，按照一主多从进行数据库配置。\n\n> 目前虽然可以实现主从配置，但是数据库 API 并不会自动进行主从切换，需要手动选择，具体用法参照使用章节。\n\n\n```javascript\nconst Db = require('@candyjs/db-mysql2');\n\nconst db = new Db({\n    // 主库配置\n    main: {\n        host: 'localhost',\n        port: 3306,\n        database: 'mydb',\n        user: '',\n        password: ''\n    },\n    // 多个从库配置\n    slaves: [\n        {\n            host: 'localhost',\n            port: 3306,\n            database: 'mydb_slave1',\n            user: '',\n            password: ''\n        }, {\n            host: 'localhost',\n            port: 3306,\n            database: 'mydb_slave2',\n            user: '',\n            password: ''\n        }\n    ]\n})\n```\n\n\n\n#### 使用 Command\n\nAPI 汇总\n\n```javascript\n// 准备 sql 语句\nprepareSql(sql: string): Command\n// 准备预处理 sql 语句\nprepareStatement(sql: string): Command\n// 为预处理 sql 赋值\nbindValues(arr: any[]): Command\n// 获取多条记录\nqueryAll(): Promise<any>\n// 获取单条记录\nqueryOne(): Promise<any>\n// 获取一列记录\nqueryColumn(): Promise<any>\n// 执行更新操作\nexecute(): Promise<number>\ngetLastSql(): string\n```\n\n一般情况下，应当使用从库进行读操作，使用主库进行写操作。\n\n```javascript\n// 获得一个从库链接\nconst comm = db.getSlave();\n\nlet data = null;\ntry {\n    data = await comm.prepareSql('select * from t_users where id=1').queryOne();\n} catch(e) {\n    // todo\n}\n\nconsole.log(data);\n```\n\n为了避免 sql 注入问题（ SQL injection attacks ），建议使用预处理语句\n\n```javascript\n// 获得一个从库链接\nconst comm = db.getSlave();\n\nlet data = null;\ntry {\n    data = await comm.prepareStatement('select * from t_users where id=?').bindValues([1]).queryOne();\n} catch(e) {\n    // todo\n}\n\nconsole.log(data);\n```\n\n使用主库进行修改操作\n\n```javascript\n// 获得一个主库链接\nconst comm = db.getMain();\n\nlet data = null;\ntry {\n    data = await comm.prepareStatement('update t_users set age=? where id=?').bindValues([20, 1]).execute();\n} catch(e) {\n    // todo\n}\n\nconsole.log(data);\n```\n\n\n\n#### 使用 Query builder\n\nQuery builder 是对 sql 语句的函数封装，它只能进行查询操作，无法进行修改操作\n\nAPI 汇总\n\n```javascript\ngetAll(): Promise<any>\ngetOne(): Promise<any>\ngetColumn(): Promise<string>\ncount(column: string = '*'): Promise<number>\nselect(columns: string): Query\nfrom(table: string): Query\nwhere(condition: string, parameters: any[] = null): Query\ngroupBy(column: string): Query\nhaving(condition: string): Query\norderBy(columns: string): Query\nlimit(limit: string): Query\n```\n\n使用\n\n```javascript\nlet q = new Db.Query(command);\ntry {\n    let data1 = await q.select('*').from('user').where('id=1').getOne();\n    let data2 = await q.select('*').from('user').where('id=?', [2]).getOne();\n    let data3 = await q.from('user').count('id');\n} catch(e) {\n    // todo\n}\n```\n\n> 注意：使用 query builder 时系统默认最大查询数量为 2333 条，可以通过 `Db.Query.MAX_LIMIT` 修改该值\n>\n\n#### 使用 Transaction\n\n使用事务需要借助 `mysql2` 的原生 API，目前本库中对外可以获取经 promise 包装的 mysql2 api\n\n\n```\nconst db = new Db(someConfigs);\n\nconst internalDb = db.getMain().db;\nlet conn = null;\n\ntry {\n    conn = await internalDb.getConnection();\n    await conn.beginTransaction();\n\n    await conn.execute(sql1, params);\n    await conn.execute(sql2, params);\n\n    await conn.commit();\n\n} catch(e) {\n    conn && conn.rollback();\n}\n```\n\n## 配合 candyjs 使用\n\n```javascript\nconst CandyJs = require('candyjs');\nconst App = require('candyjs/web/Application');\nconst Db = require('@candyjs/db-mysql2');\n\nnew CandyJs(new App({\n    'id': 1,\n    'appPath': __dirname + '/app',\n    'db': new Db({\n        main: {\n            host: 'localhost',\n            port: 3306,\n            database: 'mydb',\n            user: '',\n            password: ''\n        },\n        slaves: [\n            {\n                host: 'localhost',\n                port: 3306,\n                database: 'mydb_slave1',\n                user: '',\n                password: ''\n            }, {\n                host: 'localhost',\n                port: 3306,\n                database: 'mydb_slave2',\n                user: '',\n                password: ''\n            }\n        ]\n    })\n})).listen(2333, function(){\n    console.log('listen on 2333');\n});\n\n\n\n// in some business\nconst Db = require('@candyjs/db-mysql2');\n\nmodule.exports = class IDao {\n    constructor() {\n        this.table = '';\n    }\n\n    /**\n     * 获取 mysql 链接\n     *\n     * @private\n     * @returns {Db}\n     */\n    getConnection() {\n        return Candy.app.db;\n    }\n\n    /**\n     * 统计表中记录数\n     */\n    async count(where = '1=1') {\n        const conn = this.getConnection();\n        const comm = conn.getSlave();\n\n        let num = 0;\n\n        try {\n            num = await comm.prepareSql(`SELECT count(*) as c FROM ${this.table} WHERE ${where}`).queryColumn();\n\n        } catch(err) {\n            CandyJs.getLogger().error(err.message);\n        }\n\n        return num;\n    }\n}\n```\n\n","readmeFilename":"README.md"}