{"_id":"i-mysql","_rev":"64-8ab3c0ee102c8f9b19c2ee2cfa7972b9","name":"i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","dist-tags":{"latest":"0.2.13"},"versions":{"0.0.1":{"name":"i-mysql","version":"0.0.1","description":"a powerful nodejs module, we called be i-mysql","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql"],"author":{"name":"zhangyanbing"},"license":"BSD-2-Clause","_id":"i-mysql@0.0.1","dist":{"shasum":"6333de5707a2238984c401aee5217d461b9e5516","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.0.1.tgz","integrity":"sha512-45ApChzC9ADJ3VaEDZv3LCUPBwaEeZbuWkkx2BUp1O7bu1sVVOzESS50ywOyGHoJs6DbhTY2MOVkHM9KwJlByg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDTbIUAs5dKXB9aTUa2dKzVjMK3h0S68C233SbslHL8aAIhAMxsLpjFdD+ZAsNFN1MJ0g7abY7w8sluwtrHhr7/2Wwp"}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.0.2":{"name":"i-mysql","version":"0.0.2","description":"a powerful nodejs module, we called be i-mysql","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql"],"author":{"name":"zhangyanbing"},"license":"BSD-2-Clause","_id":"i-mysql@0.0.2","dist":{"shasum":"42e17a17843fbb7abad6a9bd267bfc48b6a3ba0b","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.0.2.tgz","integrity":"sha512-3ogULdwLikLqTFAdYooP/YNcZJc/g/WcW9xSSI6hq5p+1vm/pOyH2ZgRUa2zc40wulhM5fGjs/LRQNLgmafW1Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCUE3VqhuNiX2vqC1ctSSJprDdEOiv+eLR7ScUAUg1ThgIhALlvsLH7OjCWDjG4yVSZkkJQ82LR6hY6CGPqcRxUSNU1"}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.0.3":{"name":"i-mysql","version":"0.0.3","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"a powerful nodejs module, we called be i-mysql","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql"],"author":{"name":"zhangyanbing"},"license":"BSD-2-Clause","_id":"i-mysql@0.0.3","dist":{"shasum":"59206000c02099febbcd32cd46aaa4f0256778a5","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.0.3.tgz","integrity":"sha512-5vBUc4dVxA9RY72MTVOhGfMb1JTjXk1qjF2eAm6BktW/k3C67Io9U1qXj0fswhLucyce4ZHdgC0+R9UACi8ZgA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIH9DNoiCS0GkGqskMi3tPfmNQqfcfbBhvi6i+muLV5PQAiAFLKLNbYk0vTb9I5DusbPD66Yo6Pk9xc0dfx1UklCM6w=="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.0.4":{"name":"i-mysql","version":"0.0.4","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"a powerful nodejs module, we called be i-mysql","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql"],"author":{"name":"zhangyanbing"},"license":"BSD-2-Clause","_id":"i-mysql@0.0.4","dist":{"shasum":"cc5aea226e3863f544134c9df9de5a3fb9c59a63","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.0.4.tgz","integrity":"sha512-SFI82ZI7t7OwVdaTp+ttNxJgIxVdIerPl/h5wRMEOjsP6GFJE6qi4nVptK7hTBmUqp1kqZJsg1YR7s6RqXnf4Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIEf5TKDbIWLdJkj74y+pDxN3mYP23CYlWEucIp/uu3l8AiADfqfhRw4j0MQsEbNG+ueW2YB8AxJqb7Kk4QOSvb3h0g=="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.0.5":{"name":"i-mysql","version":"0.0.5","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"a powerful nodejs module, we called be i-mysql","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql"],"author":{"name":"zhangyanbing"},"license":"BSD-2-Clause","_id":"i-mysql@0.0.5","dist":{"shasum":"895ad90d2b360a20f6f419e1f445dc109f5d8872","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.0.5.tgz","integrity":"sha512-A1Hi+ktodfNBZVkulAucVN0FWlLORIMlBKGNAUaiNmDLVnzYmvd4JsFJHrHRLqU1uwG5IcDxETsRqm8xTOSm7A==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCdHkD4rWUj2koAxWucZL1/vevaov2inoFb76TJz36HhQIgK3k+2CxoLqNZJKIgoZOxYMTuPEqIvzfKSHGEk7uPxRE="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.0.6":{"name":"i-mysql","version":"0.0.6","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"a powerful nodejs module, we called be i-mysql","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql"],"author":{"name":"zhangyanbing"},"license":"BSD-2-Clause","_id":"i-mysql@0.0.6","dist":{"shasum":"e7cb976373d0b316665578edc1ad34ddce1d7c42","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.0.6.tgz","integrity":"sha512-TlyMc9U18gQlKo4Kz3lNA6RMb6Qa6txlxyY8EFW4704x1PuNdm6onPY7poKLv7fjfaL5YY7Rnl9IBkfSIYNVmg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQC40HON9mWkGvrsZy377M1u7IYfSbBjkgcBky6VNhqoMAIgK4yWewHe/Ogf+cENJgdsLyYLBpo4Nji24ZDXCi1Btns="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.0.7":{"name":"i-mysql","version":"0.0.7","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"a powerful nodejs module, we called be i-mysql","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.0.7","dist":{"shasum":"f86e9822d56c9d549d63b7039a6c9c8b77635c40","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.0.7.tgz","integrity":"sha512-v5Q5A09gg9c94V5M63A6BB/GmFmD7gJ5Lg3T4rFTpjMvU7bDnCgk3M3SMIMYr7aL9QKmAW7uXles58HEWc2pWA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCzIM1zMjNUt13Zil9Jf3h/yYAWgtPFgz147HghbLsNDQIgSMzZBZwnzZlukhiouPp/rH8DlRltI3yzhnIGnAd+2cI="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.0.8":{"name":"i-mysql","version":"0.0.8","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"a powerful nodejs module, we called be i-mysql","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.0.8","dist":{"shasum":"5d826589c1d6512c9a97e6a0457adf6ea422c728","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.0.8.tgz","integrity":"sha512-TS1Q/r9kMQw9uoiFzLqmpT6L+PJ2l98MUNpCBNDZQgjPTyuEN5Gih2bPQSGTAk1IJSLboqhVib4/EVUYslcqQA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIGXBkvF5l/Ilq6KX7RTsRkoivThmBW+a3aKUELjpmyAMAiBh3vCfwdS5PN6sUJq7O08qiMj2OoXSs5ffJVRgFW6V6w=="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.0.9":{"name":"i-mysql","version":"0.0.9","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"a powerful nodejs module, we called be i-mysql","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.0.9","dist":{"shasum":"ca563ecce09abf9a0bee0adc5d4b8d722791bbdc","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.0.9.tgz","integrity":"sha512-BRl5rRA6tBZA4Ydtc0TdH+cWqZY/tLs81Iv2u3d88czlYYHqBvFYmb7Tc+qUwJBeMgJIboZvlTptA2qnVwOpXg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIHhcujFevO0BVw3Q8yjO/n5Q21L5StA7tQn8TK46s+CMAiAvojZ0wv63WphzurSbuA5lQTe5/o4steCGrhmjCnZ+NQ=="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.0.10":{"name":"i-mysql","version":"0.0.10","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"a powerful nodejs module, we called be i-mysql","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.0.10","dist":{"shasum":"8a8645b9fac83b5f3e2e2698eb51184c6b3fa65f","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.0.10.tgz","integrity":"sha512-u5nge6CIltwM07JWj3Xr5uXSQ4xRNV8uUKoWLogzKI5HJQhpRjD1dUxyRYMYRu+4LFirq0iJTVu2qrn4fDxodA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCe8Y5loiZTij14ohBeXqRIjVnq0jIDAZ4eRDe6kTGZDgIhAO7MUSmAZHbGLzCxE0TqyLSO6Lm9BMhlQCL92Rt48JpF"}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.0.11":{"name":"i-mysql","version":"0.0.11","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"a powerful nodejs module, we called be i-mysql","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.0.11","dist":{"shasum":"f20fd12cdfaae90e115b47f72c37ae1f3d90be3e","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.0.11.tgz","integrity":"sha512-8NJQ8AZYxc1p+yg761a4dGrp3HQeMMX9qmJLgWNdrkpHpMrZi0GNQ/HhZYxvOAwRAzBqmi3z0t9iyUGfrA3HVA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIBwXEaZhcX7Bw9WLAsINmPQkmaj/8Cx3Q7T+BDjdDkkVAiEAl+CCZm8g64W10nrTAt1AfoSGCGntrNnQ87OZtNPJAJU="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.0.12":{"name":"i-mysql","version":"0.0.12","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"a powerful nodejs module, we called be i-mysql","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.0.12","dist":{"shasum":"496af82c49f8a6c8e8b7bbebbc7acfc9ec301001","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.0.12.tgz","integrity":"sha512-H/ZUEGGn257PH2KH4DKUJlq6xk4I68ACJMh+ucN0idObot+Xxh9W7MuIdx/9DqDMFZxEN0P5ss7aUvYpoDW2og==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCID7h4V6q/KCzQtC9Z6P/BZ8DumFou3UJCZdNsSDS9yj7AiEA0plX87rOvXSAucQqmSdqzhfszOL5v30e1chjWREblBY="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.1.4":{"name":"i-mysql","version":"0.1.4","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"a powerful nodejs module, we called be i-mysql","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.1.4","dist":{"shasum":"ad8f592da74b1614d87d45e1d04f2adaef59e132","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.1.4.tgz","integrity":"sha512-zaiPVHNx1ix3AM3xY8YEge0/ogSMdJbeHqqKp5n6aH6Me/mSbP8mHGR3s6SHSnDAlrPAjVO5yFzx+8us7cW64w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIHDXDYb5mpZaX2IO2R54fJAhfOOlhkgGmZW6fNEjOA9fAiEAwlBc5CRVxojje7ZaGsuqtyA+2lLtyfpzBt11szvujx4="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.1.5":{"name":"i-mysql","version":"0.1.5","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.1.5","dist":{"shasum":"f68d0ff00c3b5e141bc012f2e8ab55d110104f26","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.1.5.tgz","integrity":"sha512-LxA7dXgiqDRtuKZpKoH88Fy/MfRLt/nTdpD2pWkxtSQ7NIZ8cQ+z+btOgTajECK35w7H+YrdaZbIAZMtWBHI2w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCuhxjLlLDcfw50l/UnLfjK3lwFWkiK0XPmZxSuJ4+QyQIhANzYgeaKmKLl2icjH6boJHTyVvxsV8eiIA458IeyCwU+"}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.1.6":{"name":"i-mysql","version":"0.1.6","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.1.6","dist":{"shasum":"da459cf507dc2657a740fe8c4ccc1338b0612a25","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.1.6.tgz","integrity":"sha512-iP8LKKtLKX0KM5ZDha123j0zE10r8hgwc/4iNkxcyuCz92l4C3Gaxu3iUSu/Ol8m0kybEDVNaTjpxVXQYl3/mw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIENem5vYZEHKhFZWz6uklP8yuMCRPuBix24S3vWa248NAiEA/tdX8vtinlwORjpUN5Ba71gP2Up6SneLeWObDN8G54o="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.1.7":{"name":"i-mysql","version":"0.1.7","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.1.7","dist":{"shasum":"c02cbdd3b8d198788ee39f7d49a5a32cf2c1194b","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.1.7.tgz","integrity":"sha512-nSj/s53091W26omT+9qM0I52rKQeo0+OzA1/+66LhopLx72oWqY2V2QdvV3Ud0EAgDJQ7Cw96mdB9MZpdzDAsw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCXFw7coLOXirHZ+cs36knBGiVf6Vew7LoVgjQbS/g4NwIhAPeOaEsci22v9tgoB9IT/lHNeh4h68SPJEfdJCesPEUa"}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.1.8":{"name":"i-mysql","version":"0.1.8","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.1.8","dist":{"shasum":"cfaaad31f06d70b6d6c8de8eb7097f9e361d78fb","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.1.8.tgz","integrity":"sha512-gMOqcRW6os08bhskOAL1DCyI2XbgNYdqFt8bfizAiBFmHW7OPpFNJBQg271gG2yOrHm7Qm4mum+1EZl0RLgolw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICwakdbu7dFPQ9WktjF/fac0zScEN9Rg2wc0VC9KVoA1AiAUzmQoST+vcscOUUQSo6wRHYro3o6GefNMGBMHbUcmSw=="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.1.9":{"name":"i-mysql","version":"0.1.9","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.1.9","dist":{"shasum":"0fec2759c2a865d8125e71c654bf6de758f2e01f","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.1.9.tgz","integrity":"sha512-Vq8t0HLhe/RhcOKNoDrFFmV9EA4xctqnXzyeW8RpyTv0LkmvAnwew6CLVFxlfAYFBDJwjlDw+u0lGx2GUUqakQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCy5EUKwPL4Z8luk1gB4Bp+HsgV/RqpnO7Z7YniCkeSbAIhALeO787lIaWaQ6YpXeXPQjBJZUqgdKKWT7WftynQw8Hz"}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.2.0":{"name":"i-mysql","version":"0.2.0","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.2.0","dist":{"shasum":"a679aba49ba10451317bbbfdba35688a096a1e1f","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.2.0.tgz","integrity":"sha512-3COVMwVQqhGrogayDgWTBni0uzk9bg2rL7K9LPbkKKQ9TrHF6bfnfjyGdY6Em4OnN4adtmomBgFmnalo79tu8A==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIA9CtkIomEsDEW+gBt/OEVVT2fLKdqSLigYZCMMCXdf7AiEA5lGKk5rvOwavmrpQNnVsYHIxbKmfSsLF7KUbxU4YJg0="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.2.1":{"name":"i-mysql","version":"0.2.1","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.2.1","dist":{"shasum":"01cb1d05fcfcb0460437ca785430a0e519fea9ad","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.2.1.tgz","integrity":"sha512-7JsyCtQSbZaDhZI8+tFJkZqEBUPWC3Y+yd2Pwx1hJUlekvg/FZqINsgcDVmMm5SMw8ySVfPyS5HEfqZHoUXCxw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCTpX/8DmMoGVewCTVyc/cDgbZhaoWmTVM07spHzAO14gIhAI/SgIg6ajc4my2Tx8P+mysEfcytAuHtEN2JWHlijk7e"}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.2.2":{"name":"i-mysql","version":"0.2.2","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.2.2","dist":{"shasum":"69a5dd25e123b40b78f5be245a09235fd51d04c7","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.2.2.tgz","integrity":"sha512-0iOokItX4P9ovw012JiaK4Gu4mlHFG44ud7Fu4uojQEJ8nZjv3DIsjz+9WL7BUNExbfYY+K74KtZeSnkvWE1ag==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD3fAz7Ypmd9uYnJN2tjO9+oKDSBTsT0uJqDz7hNkYNUQIhAP35X007kp1JyYUXNugtg1tFqDr7XyerDbCHmTUrFDxI"}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.2.3":{"name":"i-mysql","version":"0.2.3","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":"~1.1.5","moment":"~2.5.0","mysql":"~2.0.0-rc2"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.2.3","dist":{"shasum":"2524e00d37f96b260565dcff13d14694d108f84d","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.2.3.tgz","integrity":"sha512-IFq+ndroYLmhv+ypmRSPI8PZTqE6OMhnq2I7dUXzJTGPSoNKKVCSUpUr0flVeIYzZ2wOEPz92aY1rseoTTH7lA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCoBJxKwAwQpHWuuGsBtTNbzAHEUFXPHKZEDJG0wQLE1gIgH0mOezeSkcG8j6j+eHSkBJtH90qgoEWaL0OU7qv01bo="}]},"_from":".","_npmVersion":"1.3.14","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.2.4":{"name":"i-mysql","version":"0.2.4","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":">=1.1.5","moment":">=2.5.0","mysql":">=2.0.1"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.2.4","dist":{"shasum":"2972fa4815d89ae9c3ced1e5f84782a0748ba77a","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.2.4.tgz","integrity":"sha512-mWRhLlWsIiiNILoGsMJzkndGUGUQz5SXWWoPofT6o09jZu9yA4VvAZTLbGu1ELcF1nGsdvnS62AJkaOW1xKdog==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIBLPwio+rWRfPD+kI9O6ie2fiRVLNml2BmIDHXf1zhxMAiEAljp+6/QIzj3u208J9FRlQvO3Az3IdY4oUSpvbgooCJk="}]},"_from":".","_npmVersion":"1.3.21","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.2.5":{"name":"i-mysql","version":"0.2.5","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":">=1.1.5","moment":">=2.5.0","mysql":">=2.0.1"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.2.5","dist":{"shasum":"209247c807727ec60f5a59e5c66805e0a1dc3f16","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.2.5.tgz","integrity":"sha512-b42/CNKKIdp6GIRYyk1MVGM6A8k770k3UoW0eIFPueP5es4zbfwozM8ZjGt8PIfqRju3h1m0xMHuzA2Ls3mqEA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDroKU5+YGlGBWl39nn2i9RTfVm48gXGgLdbTIbXOImYgIhAJaoAC0ZicvzLh65TkkUpJHKgN8h5giWTHAhVFR0G2lW"}]},"_from":".","_npmVersion":"1.3.21","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.2.6":{"name":"i-mysql","version":"0.2.6","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":">=1.1.5","moment":">=2.5.0","mysql":">=2.0.1"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.2.6","dist":{"shasum":"13987fafa56ef352607de685eff165f29a8f62f3","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.2.6.tgz","integrity":"sha512-dQAo3Bzr0LCVbA8KM7B+18yo+7cSehsFO515GZckKfQMfNReXJT87W93x9fi6imDcmj/EFUfdG7RrIPgn5ymTQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIFXEjjy1oC3G+Fiy706keZsWZJMYMIO40rBdG1tRsQp6AiBoVbKvambPbfnMLEs/lGC2+xxOoc+FUY+Jd6SNjbnKaQ=="}]},"_from":".","_npmVersion":"1.3.21","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"directories":{}},"0.2.7":{"name":"i-mysql","version":"0.2.7","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":">=1.1.5","moment":">=2.5.0","mysql":">=2.0.1"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.2.7","dist":{"shasum":"0c05a4e0aa03fb9ed468769b45c610f56e9c5586","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.2.7.tgz","integrity":"sha512-bWcp9G7kXpM9Tl9u3TGSy2evXw/8aLy0zcb9mMYC1giSH5dXWJwbYRrAtbJbGpRKZELtcUAlpsB3zIVl/CGdBw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIDeue13RjYnHxOo3vaqHPpye1eYORZqBrd/fJiw8zdg/AiEAk+T8FwD1tKFz97RNPOibjNZl4H5TqqffZcnwlhOrn1w="}]},"_from":".","_npmVersion":"1.3.21","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}]},"0.2.8":{"name":"i-mysql","version":"0.2.8","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":">=1.1.5","moment":">=2.5.0","mysql":">=2.0.1"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.2.8","dist":{"shasum":"57ca180222a9a468d0f38fa21960598db5a85c6e","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.2.8.tgz","integrity":"sha512-tCTn16wDwOxuysWphARkkrZWD6qAGE53VCrgc4AVRFbxVaI45Jqs7WA0WB+UoblwlrQhkB+RLiLrVX1qk4mwkg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIGtuzBKUGNaGsp0s1sgZJgjKpXNWX+9mSwTWmwQqXX+bAiEAhAtkwFDykcrSuvMEsJuRjLcQwmY5CbDFuSFQnsREb30="}]},"_from":".","_npmVersion":"1.3.21","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}]},"0.2.9":{"name":"i-mysql","version":"0.2.9","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":">=1.1.5","moment":">=2.5.0","mysql":">=2.0.1"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.2.9","dist":{"shasum":"068d40662b5710626de4b463b8a01999c6e67cb4","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.2.9.tgz","integrity":"sha512-toku9iQ5VDcwHt3AeRvFi3z0M5DJG0jp1sjmGtDbQ1B9DYccHhPIOQCQOe0bCR/1mT8r7yQPryls/4FSdKX5fA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIEhcpUT8OQRSkZUoCg636BqFkedkGHC45KQ5ic4eZ0tsAiBn8hQf83L2IE19wEFo7c56PFACNB4MWHguZgydihtWJw=="}]},"_from":".","_npmVersion":"1.3.21","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}]},"0.2.12":{"name":"i-mysql","version":"0.2.12","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":">=1.1.5","moment":">=2.5.0","mysql":">=2.0.1"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.2.12","dist":{"shasum":"d8917b27cc1c8d035e81ec9a7207273eb72b16cf","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.2.12.tgz","integrity":"sha512-ntSzYQlOAybSaNF4TOcH0F/la30mcqTXc8bOVelMorUDEUIq5Bf2jOWdymp9EAqdvh6zAfyB+/WM3A2xsEjujg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCYRIsFMBY73RSYeLC/5OteEYbbV3Vf0qu3KLLi0oAkzQIgdL++xmYiQa9BzHzIrfkE/hYHoDhziTyH2fo0LPNwMRw="}]},"_from":".","_npmVersion":"1.3.21","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}]},"0.2.13":{"name":"i-mysql","version":"0.2.13","repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"bugs":{"url":"https://github.com/zybn2004/i-mysql/issues"},"homepage":"https://github.com/zybn2004/i-mysql","description":"A powerful nodejs module for mysql, we called be i-mysql.Including single table CRUD, transaction operations, multi- database switch function, etc.    i-mysql 是将mysql进行二次封装的一个强大的nodejs模块，主要包括了单表的CRUD、事务相关操作、多数据库切换等功能！","main":"index.js","dependencies":{"big-integer":">=1.1.5","moment":">=2.5.0","mysql":">=2.0.1"},"devDependencies":{},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["i-mysql","mysql","switch","crud","transaction","table"],"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"license":"BSD-2-Clause","_id":"i-mysql@0.2.13","dist":{"shasum":"95a6e3e84a1d6f37eacba74cd95f198c1eb75302","tarball":"https://registry.npmjs.org/i-mysql/-/i-mysql-0.2.13.tgz","integrity":"sha512-ChpPfY6oIyM1Iim4fw//pYKnBtpCxCkkg9M96uzoa5yuPwWarwZoWExC0lIBaYmsTrF03429g3BOR+Rp53l9mw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDiSRcMq2/K1vu7qI3ri5PA9BHPwGnKSlncSBHv1LMd3QIhAKKJLvhbzbemEwqu/aKWsyTxbj9njY/ztwp3zQx9z0jB"}]},"_from":".","_npmVersion":"1.3.21","_npmUser":{"name":"zybn2004","email":"zybn2004@qq.com"},"maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}]}},"readme":"i-mysql\n=======\n\n\n# 安装\n```bash\nnpm install i-mysql\n```\n# 介绍\n\n\n##i-mysql的主要特点：\n* 1.多数据库自由切换。\n* 2.数据库托管。\n* 3.简单的数据库执行方法封装。\n* 4.单表CRUD封装。\n* 5.事务封装（超时自动提交、错误自动回滚）。\n* 6.支持连缀写法。\n\n\n##方法总览：\n> i-mysql\n>\n> > config\n>\n> > defaultDb\n>\n> > db\n>\n> > > getDbIndex\n>\n> > > switch\n>\n> > > sql\n>\n> > table\n>\n> > > getTableName\n>\n> > > getDbIndex\n>\n> > > switch\n>\n> > > insert\n>\n> > > select\n>\n> > > update\n>\n> > > delete\n>\n> > transaction\n>\n> > > getId\n>\n> > > getDbIndex\n>\n> > > autoCommit\n>\n> > > destroy\n>\n> > > switch\n>\n> > > commit\n>\n> > > rollback\n>\n> > > table\n>\n> > > > insert\n>\n> > > > select\n>\n> > > > update\n>\n> > > > delete\n>\n> > > sql\n\n\n##一、数据库配置\ni-mysql必须在执行config之后才可以进行其它操作，且只能config一次。<br />\nfunction config(configs) config方法的configs参数可以为空（为空时config方法会返回上次调用config方法成功时的configs参数），也可接收如下例子中的数组，当然也可以是只有单个数据库配置的json对象（这个时候就不存在数据库切换的情况了）。<br />\n\n```js\nvar iMysql = require('i-mysql');\n//配置\niMysql.config([\n    {host:'127.0.0.1',port:3306,database:'db0',user:'root',password:'123456'},\n    {host:'127.0.0.1',port:3306,database:'db1',user:'root',password:'123456'}\n]);\n\n//获取配置(可用来判断是否已经配置过i-mysql)\nconsole.log(iMysql.config());\n```\n\n\n##二、数据库索引\n成功配置了i-mysql之后，会默认将第一个数据库作为默认数据库，您也可以通过defaultDb方法获取当前默认数据库的索引或者设置新的默认数据库索引给i-mysql。<br />\n数据库索引值从0开始，即为config时数组的索引，如果只有单数据库，那么有效的数据库索引值只能为0。<br />\n获取或设置数据库索引的方法，function defaultDb(dbIndex) defaultDb方法支持数字型参数或者一个返回数字型数据的function参数。<br />\n\n获取默认数据库的索引：\n```js\nvar defaultDbIndex = iMysql.defaultDb();\n```\n\n设置新的默认数据库索引：\n```js\niMysql.defaultDb(1);\n```\n\n动态指定默认的数据库索引：\n```js\nfunction chooseDb(){\n    return 1;\n}\n\niMysql.defaultDb(chooseDb);\n```\n\n##三、简单的数据库执行对象\n* 1)获取简单数据库执行对象，function db(dbIndex) db方法支持数字型参数或者一个返回数字型数据的function参数。\n* 2)获取简单数据库执行对象所在数据库索引，function db.getDbIndex() getDbIndex方法返回当下简单数据库对象所在的数据库索引。\n* 3)数据库执行对象切换数据库，function db.switch(dbIndex) switch方法支持数字型参数或者一个返回数字型数据的function参数。\n* 4)简单数据库执行对象执行sql，function db.sql(sql,options,cb) sql方法可接受3个参数（与mysql包的query方法相同）：\n  * ①必填参数sql：可以是字符串或者一个返回字符串数据的function。\n  * ②可选参数options：用来填充sql的对象。\n  * ③可选参数cb：执行sql之后的回调函数。\n\n###1.简单数据库对象的获得途径\n\n获得一个简单数据库执行对象：\n```js\nvar defaultDbObj = iMysql.db();//db方法没有传入时，i-mysql会根据默认的数据库获得一个简单数据库执行对象\n```\n\n指定从某个数据库中获得一个简单数据库执行对象：\n```js\nvar db1Obj = iMysql.db(1);\n```\n\n动态指定从某个数据库中获得一个简单数据库执行对象：\n```js\nfunction chooseDb(){\n    return 1;\n}\n\nvar dbObj = iMysql.db(chooseDb);\n```\n\n###2.简单数据库对象获取当下所在的数据库索引\n\n```js\nvar db1Obj = iMysql.db(1);\nconsole.log(db1Obj.getDbIndex());\n```\n\n###3.简单数据库对象切换数据库\n\n```js\nvar db1Obj = iMysql.db(1);\ndb1Obj.switch(0);\n```\n\n###4.简单数据库对象执行sql\n\n```js\nvar db1Obj = iMysql.db(1);\ndb1Obj.sql('select c1 from test_table where id = ?','3',function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n```\n\n###5.简单数据库对象连缀写法\n\n```js\nvar db1Obj = iMysql.db(1);\ndb1Obj.sql('select c1 from test_table where id = ?','3',function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n}).sql('select c1 from test_table where ?',{id:'4'},function(err){//第二个参数如果是json对象，比如{id:'4',name:'t1'}，那么在执行时会格式化成`id`='4',`name`='t1'\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n}).switch(0).sql('select c1 from test_table where id = 5',function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n```\n\n\n##四、table对象\n* 1)获取table对象，function table(dbIndex,tableName) table支持2个参数，dbIndex可选，tableName必填，如果只有1个参数传入则被认为该参数表示的是tableName，其中dbIndex支持数字型参数或者一个返回数字型数据的function参数，没有传入dbIndex时默认为i-mysql的默认数据库索引，tableName可以是表示表名的字符串或者一个可以返回表名字符串数据的方法。\n* 2)从table对象获取表名，function table.getTableName()。\n* 3)从table对象获取所在数据库索引，function table.getDbIndex()。\n* 4)table对象切换数据库，function table.switch(dbIndex) switch方法支持数字型参数或者一个返回数字型数据的function参数。\n* 5)table对象insert数据，function table.insert(options,cb) insert方法支持2个参数：\n  * ①可选参数options：{data:...,fields:...,values:...,freestyleFields:...}，data优先与field和values，data为如{'字段':字段值}的json对象，fields和values配套使用，其中fields表示字段(可支持如['字段1']的数组或者以逗号间隔的字符串)，values表示对应的值(可支持如['字段值','字段值']的数组或者[['字段值','字段值1'],['字段值','字段值2']]这样的二维数组从而进行批量插入)，freestyleFields表示那些字段对应的值不需要做合法性校验和escape的自由字段(可支持如['字段1']的数组或者以逗号间隔的字符串)，其作用在data和values中有效。\n  * ②可选参数cb：执行sql之后的回调函数，该回调函数的参数同mysql包的query方法中cb的参数。\n* 6)table对象select数据，function table.select(options,cb) select方法支持2个参数：\n  * ①可选参数options：{fieldset:...,fields:...,where:...,groupBy:...,orderBy:...,limit:...,freestyleFields:...}，其中fieldset可以为字符串，fields表示字段(可支持如['字段1']的数组或者以逗号间隔的字符串，为空时默认查询所有字段)，where支持如{'字段1':字段值,'字段2':字段值}的json对象或者字符串（where为json对象时只支持and的拼接），groupBy可以为数组对象如['字段1','字段2']，orderBy可以为json对象如{'字段1':'desc','字段2':''}，limit可以为json对象如{start:10,total:20}也可以为[10,20]，它们都支持字符串，limit还支持数字（此时表示的即是total的值），freestyleFields表示那些字段对应的值不需要做合法性校验和escape的自由字段(可支持如['字段1']的数组或者以逗号间隔的字符串)，其作用在where中有效。\n  * ②可选参数cb：执行sql之后的回调函数，该回调函数的参数同mysql包的query方法中cb的参数。\n* 7)table对象update数据，function table.update(options,cb) update方法支持2个参数：\n  * ①必填参数options：{data:...,fields:...,values:...,where:...,freestyleFields:...}，data优先与field和values，data为如{'字段':字段值}的json对象，fields和values配套使用，其中fields表示字段(可支持如['字段1']的数组或者以逗号间隔的字符串)，values表示对应的值(可支持如['字段值','字段值']的数组)，where支持如{'字段1':字段值,'字段2':字段值}的json对象或者字符串（where为json对象时只支持and的拼接），freestyleFields表示那些字段对应的值不需要做合法性校验和escape的自由字段(可支持如['字段1']的数组或者以逗号间隔的字符串)，其作用在data、values和where中有效。\n  * ②可选参数cb：执行sql之后的回调函数，该回调函数的参数同mysql包的query方法中cb的参数。\n* 8)table对象delete数据，function table.delete(options,cb) delete方法支持2个参数：\n  * ①可选参数options：{where:...,freestyleFields:...}，where支持如{'字段1':字段值,'字段2':字段值}的json对象或者字符串（where为json对象时只支持and的拼接），freestyleFields表示那些字段对应的值不需要做合法性校验和escape的自由字段(可支持如['字段1']的数组或者以逗号间隔的字符串)，其作用在where中有效。\n  * ②可选参数cb：执行sql之后的回调函数，该回调函数的参数同mysql包的query方法中cb的参数。\n\n###1.table对象获得途径\n\n从默认数据库中获得一个table对象：\n```js\nvar testTable = iMysql.table('test_table');\n```\n\n指定从某个数据库中获得一个table对象：\n```js\nvar testTable = iMysql.table(1,'test_table');\n```\n\n动态指定从某个数据库中获得一个table对象：\n```js\nfunction chooseDb(){\n    return 1;\n}\n\nvar testTable = iMysql.table(chooseDb,'test_table');\n```\n\n动态指定表名获得一个table对象：\n```js\nfunction chooseTableName(){\n    return 'test_table';\n}\n\nvar testTable = iMysql.table(1,chooseTableName);\n```\n\n###2.table对象获取表名\n\n```js\nvar testTable = iMysql.table('test_table');\nconsole.log(testTable.getTableName());\n```\n\n###3.table对象获取当下所在的数据库索引\n\n```js\nvar testTable = iMysql.table('test_table');\nconsole.log(testTable.getDbIndex());\n```\n\n###4.table对象切换数据库\n\n```js\nvar testTable = iMysql.table('test_table');\ntestTable.switch(0);\n```\n\n###5.table对象执行insert\n\n```js\nvar testTable = iMysql.table('test_table');\n//使用data插入(注意其中的freestyleFields的用法，它指定了data中的create_time字段的值是自由的即i-mysql是不会对它进行值合法性校验和escape的，table的insert、select、update、delete中都支持类似的freestyleFields用法，详细请看之前table对象中的介绍)\ntestTable.insert({data:{id:1,c1:'t1',create_time:'CURDATE()'},freestyleFields:'create_time'},function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n//配套使用fields和values插入\ntestTable.insert({fields:['id','c1','create_time'],values:[2,'t2','CURDATE()'],freestyleFields:['create_time']},function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n//批量插入\ntestTable.insert({fields:['id','c1','create_time'],values:[[3,'t3','CURDATE()'],[4,'t4','CURDATE()']],freestyleFields:'create_time'},function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n```\n\n###6.table对象执行select\n\n```js\nvar testTable = iMysql.table('test_table');\n//查询所有数据\ntestTable.select(function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n//一个复杂的查询\ntestTable.select({fieldset:'count(*) as countNum',fields:['id','c1'],where:'id<100',groupBy:{c1:'desc'},limit:{start:2,total:100}},function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n```\n\n###7.table对象执行update\n\n```js\nvar testTable = iMysql.table('test_table');\n//使用data修改\ntestTable.update({data:{c1:'update_value1'},where:{id:3}},function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n//配套使用fields和values修改\ntestTable.update({fields:['id','c1'],values:[2,'update_value2'],where:{id:3}},function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n```\n\n###8.table对象执行delete\n\n```js\nvar testTable = iMysql.table('test_table');\ntestTable.delete({where:{id:3}},function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n```\n\n###9.table对象连缀写法\n\n```js\nvar testTable = iMysql.table('test_table');\ntestTable.insert({data:{id:1,c1:'t1'}},function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n}).switch(1).select(function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n```\n\n\n##五、transaction对象\n* 1)获取transaction对象，function transaction(dbIndex,transactionId) transaction方法可接受2个参数，dbIndex和transactionId（transactionId参数比较特殊，如果为负数，那么i-mysql会认为事务id不是去获取一个可能已经存在的事务，而是去获得一个全新的事务）都是可选的，如果只有1个参数传入则被认为该参数表示的是transactionId，其中dbIndex支持数字型参数或者一个返回数字型数据的function参数(dbIndex默认为i-mysql的默认数据库索引)，transactionId可以是事务id或者一个可以返回事务id数据的方法。\n* 2)从transaction对象获取事务id，function transaction.getId()。\n* 3)从transaction对象获取所在数据库索引，function transaction.getDbIndex()。\n* 4)transaction对象获取是否超时或者设置事务超时时的自动提交时间并返回是否超时，function transaction.autoCommit(autoCommitTimeout) autoCommit方法如传入参数时表示需要设置超时自动提交时间（单位为毫秒）并返回事务在当下是否已经超时(boolean)，未传入参数（默认为10秒）则只返回事务在当下是否已经超时(boolean)。\n* 5)transaction对象获取是否应该被销毁或者设置应该被销毁的闲置持续时间并返回是否应该被销毁，function transaction.destroy(destroyTimeout) destroy方法如传入参数时表示需要设置应该被销毁的闲置持续时间（单位为毫秒）并返回在当下是否已经应该被销毁(boolean)，未传入参数（默认为10分钟）则只返回在当下是否已经应该被销毁(boolean)。\n* 6)transaction对象切换数据库，function transaction.switch(dbIndex,forceNewTransaction) switch方法接受2个参数，第一个参数dbIndex支持数字型参数或者一个返回数字型数据的function参数，switch在首次switch之后，只有在调用过commit或者rollback之后才能再次switch成不同的数据库（switch成同一个数据库多次则忽略），第二个参数forceNewTransaction(boolean)为真时，switch之后的事务将是一个全新的事务。\n* 7)transaction对象事务提交，function transaction.commit(cb) commit方法支持传入一个回调函数，该函数与mysql包的commit方法的回调函数相同，当处于transaction的sql、insert、select、update、delete方法的回调函数中在不发生错误时调用则会强制提交。\n* 8)transaction对象事务回滚，function transaction.rollback(cb) rollback方法支持传入一个回调函数，该函数与mysql包的rollback方法的回调函数相同，当处于transaction的sql、insert、select、update、delete方法的回调函数中在不发生错误时调用则会强制回滚。\n* 9)transaction对象包装table，function transaction.table(tableObj_or_tableName) table方法支持table对象或者表示表名的字符串或者一个可以返回表名字符串数据或者table对象的方法，如传入为table对象时会校验它所在的数据库索引是否与当前事务所在的数据库索引一致，不一致则直接抛异常。\n* 10)transaction对象包装table之后，则可以调用table的insert、select、update、delete方法，详细请参考之前的介绍，而在调用了transaction的sql方法之后就不能再次使用insert、select、update、delete这些方法了，只能通过再次调用transaction的table方法后才能再次使用。\n* 11)transaction对象执行sql，function transaction.sql(sql,options,cb) sql方法可接受3个参数（与mysql包的query方法相同）：\n  * ①必填参数sql：可以是字符串或者一个返回字符串数据的function。\n  * ②可选参数options：用来填充sql的对象。\n  * ③可选参数cb：执行sql之后的回调函数。\n\n###1.transaction对象获得途径\n注意：如果因业务需要您尝试通过事务id获取一个曾经获得过的transaction对象，那么请注意需要try catch，因为该事务如果不存在或者应该被销毁时会抛异常（destroy方法也许能帮助你解决部分问题）！实际上每次都获取一个全新的事务程序运行的效率反而高，所以不到万不得已请不要重复使用曾经的事务！\n\n从默认数据库中获得一个全新的transaction对象：\n```js\nvar trans1 = iMysql.transaction();\n//或者\nvar trans1 = iMysql.transaction(-1);\n```\n\n在设置默认数据库后获得一个全新的transaction对象（不推荐这种写法，您可以尝试下面介绍的“从指定数据库中获得一个全新的transaction对象”的写法）：\n```js\n//如果只是临时改变默认数据库，那么请记得在调用transaction之后重新设置回原来的默认数据库\nvar oldDefaultDbIndex = iMysql.defaultDb();\nvar trans1 = iMysql.defaultDb(1).transaction();\niMysql.defaultDb(oldDefaultDbIndex);\n```\n\n从默认数据库中获得一个指定事务id的transaction对象（该事务可能是之前使用过的，但是如果该事务id的事务不存在或者已经被销毁则返回的是null）：\n```js\nvar trans1 = iMysql.transaction(11);\n```\n\n从默认数据库中获得一个动态指定事务id的transaction对象：\n```js\nfunction chooseTransId(){\n    return 23;\n}\n\nvar trans1 = iMysql.transaction(chooseTransId);\n```\n\n从指定数据库中获得一个全新的transaction对象：\n```js\nvar trans1 = iMysql.transaction(1,-1);\n```\n\n从指定数据库中获得一个指定事务id的transaction对象：\n```js\nvar trans1 = iMysql.transaction(1,23);\n```\n\n从指定数据库中获得一个动态指定事务id的transaction对象：\n```js\nfunction chooseTransId(){\n    return 23;\n}\n\nvar trans1 = iMysql.transaction(1,chooseTransId);\n```\n\n###2.transaction对象获取事务id\n\n```js\nvar trans1 = iMysql.transaction();\nconsole.log(trans1.getId());\n```\n\n###3.transaction对象获取当下所在的数据库索引\n\n```js\nvar trans1 = iMysql.transaction();\nconsole.log(trans1.getDbIndex());\n```\n\n###4.transaction对象自动提交\n\n判断transaction对象事务是否超时：\n```js\nvar trans1 = iMysql.transaction();\nconsole.log(trans1.autoCommit());\n```\n\n设置transaction对象事务超时时的自动提交时间并返回是否超时：\n```js\nvar trans1 = iMysql.transaction();\nconsole.log(trans1.autoCommit(5000));\n```\n\n###5.transaction对象自动销毁\n\n判断transaction对象是否应该被销毁：\n```js\nvar trans1 = iMysql.transaction();\nconsole.log(trans1.destroy());\n```\n\n设置transaction对象应该被销毁的闲置持续时间并返回是否应该被销毁：\n```js\nvar trans1 = iMysql.transaction();\nconsole.log(trans1.destroy(60000));\n```\n\n###6.transaction对象切换数据库\n\n```js\nvar trans1 = iMysql.transaction();\ntrans1.switch(1);//如果该trans1对象是首次切换数据库到‘1’这个数据库索引，那么切换之后事务id会与切换之前的事务id不同，否则即为上次切换过的事务id\n\ntrans1.switch(1,true);//第二个参数为真时，表示无论如何都会获得一个全新的transaction对象，所以此时该对象的事务id必定变化了\n```\n\n###7.transaction对象提交事务\n\n注意：一定要注意在一个事务代码书写到最后时加上commit或者rollback的调用（在使用async包这类同步方法时除外，因为您可能在中途commit或者rollback，i-mysql称之为强制commit和强制rollback，执行了这些强制方法之后，如果还想做事务操作建议重新获得一个全新的事务对象来调用相关事务方法或者通过process.nextTick等方法在下一瞬调用原事务对象的sql、或者table的相关方法等，否则不会执行强制方法之后调用的方法和回调），以保证事务的完整性，否则会在占用一段时间的连接后自动提交事务！\n```js\nvar trans1 = iMysql.transaction();\ntrans1.sql('insert into test_table(c1)values(\\'insert_value1\\')',function(err){\n    if(err){\n        //SQL执行发生错误是不需要执行rollback的，因为i-mysql已经帮您自动回滚了\n        console.log(err);\n    }else{\n        //如果因流程控制需要，此处也可以调用commit或者rollback，调用之后除非发生错误否则该事务中的后续步骤和回调将都不被执行（为什么存在后续步骤及其回调呢？因为是异步的，下面代码中的“trans1.commit”其实已经在堆栈中了）\n        console.log(arguments);\n    }\n});\ntrans1.sql('insert into test_table(c1)values(\\'insert_value2\\')',function(err){\n    if(err){\n        //SQL执行发生错误是不需要执行rollback的，因为i-mysql已经帮您自动回滚了\n        console.log(err);\n    }else{\n        //如果因流程控制需要，此处也可以调用commit或者rollback，调用之后除非发生错误否则该事务中的后续步骤和回调将都不被执行（为什么存在后续步骤及其回调呢？因为是异步的，下面代码中的“trans1.commit”其实已经在堆栈中了）\n        console.log(arguments);\n    }\n});\ntrans1.commit(function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n```\n\n###8.transaction对象回滚事务\n\n注意：i-mysql具备SQL执行错误时自动回滚的，当然在SQL执行未发生错误时您也可以手动强制回滚，强制回滚调用之后除非发生错误否则该事务中的后续步骤和回调将都不被执行！\n```js\nvar trans1 = iMysql.transaction();\ntrans1.sql('insert into test_table(c1)values(\\'insert_value1\\')',function(err){\n    if(err){\n        //SQL执行发生错误是不需要执行rollback的，因为i-mysql已经帮您自动回滚了\n        console.log(err);\n    }else{\n        //如果因流程控制需要，此处也可以调用commit或者rollback，调用之后除非发生错误否则该事务中的后续步骤和回调将都不被执行（为什么存在后续步骤及其回调呢？因为是异步的，下面代码中的“trans1.commit”其实已经在堆栈中了）\n        console.log(arguments);\n    }\n});\ntrans1.sql('insert into test_table(c1)values(\\'insert_value2\\')',function(err){\n    if(err){\n        //SQL执行发生错误是不需要执行rollback的，因为i-mysql已经帮您自动回滚了\n        console.log(err);\n    }else{\n        console.log(arguments);\n        //在此处强制回滚，调用之后除非发生错误否则该事务中的后续步骤和回调将都不被执行（为什么存在后续步骤及其回调呢？因为是异步的，下面代码中的“trans1.commit”其实已经在堆栈中了）\n        this.rollback(function(err){\n            if(err){\n                console.log(err);\n            }else{\n                console.log(arguments);\n            }\n        });\n    }\n});\ntrans1.sql('insert into test_table(c1)values(\\'insert_value3\\')',function(err){\n    if(err){\n        //SQL执行发生错误是不需要执行rollback的，因为i-mysql已经帮您自动回滚了\n        console.log(err);\n    }else{\n        //如果因流程控制需要，此处也可以调用commit或者rollback，调用之后除非发生错误否则该事务中的后续步骤和回调将都不被执行（为什么存在后续步骤及其回调呢？因为是异步的，下面代码中的“trans1.commit”其实已经在堆栈中了）\n        console.log(arguments);\n    }\n});\ntrans1.commit(function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n```\n\n###9.transaction对象包装table\n\ntransaction对象使用table对象进行包装：\n```js\nvar testTable = iMysql.table('test_table');\nvar trans1 = iMysql.transaction();\ntrans1.table(testTable);\n```\n\ntransaction对象使用tableName进行包装：\n```js\nvar trans1 = iMysql.transaction();\ntrans1.table('test_table');\n```\n\ntransaction对象动态表名进行包装：\n```js\nfunction chooseTableName(){\n    return 'test_table';\n}\nvar trans1 = iMysql.transaction();\ntrans1.table(chooseTableName);\n```\n\ntransaction对象动态表对象进行包装：\n```js\nfunction chooseTable(){\n    return iMysql.table('test_table');\n}\nvar trans1 = iMysql.transaction();\ntrans1.table(chooseTable);\n```\n\n###10.transaction对象使用table对象的insert、select、update、delete\n\n注意：在调用了transaction的sql方法之后就不能再次使用insert、select、update、delete这些方法了，只能通过再次调用transaction的table方法后才能再次使用！\n```js\nvar trans1 = iMysql.transaction();\ntrans1.table('test_table');\ntrans1.insert({data:{c1:'trans_insert_value1'}},function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\ntrans1.commit(function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n```\n\n###11.transaction对象执行sql\n\n```js\nvar trans1 = iMysql.transaction();\ntrans1.sql('insert into test_table(c1)values(\\'insert_value4\\')',function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\ntrans1.commit(function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n```\n\n###12.transaction对象连缀写法\n\n```js\nvar trans1 = iMysql.transaction();\ntrans1.switch(1).sql('insert into test_table(c1)values(\\'insert_value1\\')',function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n}).sql('insert into test_table(c1)values(\\'insert_value2\\')',function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n}).table('test_table').insert({data:{c1:'trans_insert_value1'}},function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n}).sql('insert into test_table(c1)values(\\'insert_value3\\')',function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n}).commit(function(err){\n    if(err){\n        console.log(err);\n    }else{\n        console.log(arguments);\n    }\n});\n```","maintainers":[{"name":"zybn2004","email":"zybn2004@qq.com"}],"time":{"modified":"2022-06-18T23:44:38.283Z","created":"2014-01-06T03:36:00.204Z","0.0.1":"2014-01-06T03:36:02.355Z","0.0.2":"2014-01-06T04:16:26.643Z","0.0.3":"2014-01-06T07:33:00.332Z","0.0.4":"2014-01-06T07:35:32.523Z","0.0.5":"2014-01-06T11:15:38.816Z","0.0.6":"2014-01-06T11:19:51.213Z","0.0.7":"2014-01-06T17:55:45.497Z","0.0.8":"2014-01-06T18:03:18.279Z","0.0.9":"2014-01-06T18:32:05.050Z","0.0.10":"2014-01-06T18:36:20.319Z","0.0.11":"2014-01-06T18:38:51.922Z","0.0.12":"2014-01-06T18:48:01.477Z","0.1.4":"2014-01-07T03:44:02.310Z","0.1.5":"2014-01-07T04:07:09.695Z","0.1.6":"2014-01-07T07:00:22.828Z","0.1.7":"2014-01-08T04:08:36.633Z","0.1.8":"2014-01-09T03:13:54.894Z","0.1.9":"2014-01-12T10:45:44.792Z","0.2.0":"2014-01-12T11:33:58.396Z","0.2.1":"2014-01-12T13:09:08.001Z","0.2.2":"2014-01-12T14:01:58.539Z","0.2.3":"2014-01-17T07:19:17.648Z","0.2.4":"2014-01-20T14:48:24.760Z","0.2.5":"2014-01-22T15:53:35.653Z","0.2.6":"2014-01-29T10:15:17.983Z","0.2.7":"2014-02-06T15:20:25.054Z","0.2.8":"2014-02-11T14:37:12.143Z","0.2.9":"2014-02-11T14:44:05.287Z","0.2.12":"2014-02-11T15:13:34.975Z","0.2.13":"2014-02-11T15:15:27.915Z"},"author":{"name":"zhangyanbing","email":"zybn2004@qq.com"},"repository":{"type":"git","url":"https://github.com/zybn2004/i-mysql.git"},"readmeFilename":"readme.md","users":{"zybn2004":true}}