{"_id":"mysql-activerecord","_rev":"69-4012a57f5b634a1ce3f8079e92aa0cea","name":"mysql-activerecord","dist-tags":{"latest":"0.8.6"},"versions":{"0.1.1":{"name":"mysql-activerecord","version":"0.1.1","devDependencies":{"node-mysql":"0.9.1"},"main":"./","_id":"mysql-activerecord@0.1.1","engines":{"node":"*"},"_engineSupported":true,"_npmVersion":"0.3.15","_nodeVersion":"v0.4.7","directories":{},"files":[""],"_defaultsLoaded":true,"dist":{"shasum":"c59881be958a22427e916775d5754d99d0e830f2","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.1.1.tgz","integrity":"sha512-xfRLHoK7sqine4SZX7ZYxm0dNmQ5mgKJJZXTjukOIIEqXJlQW3kyJ71VG8l2kPhdfTOIHe0G339i4X+3HVZtnQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCnj7PA4qN9Q4786j+UX0RPduJp06Pi55YiTH0VRBbduwIgFa04mdEiHoGHfPioq3gFwScKY14xg91A0yzMU9FYJ+g="}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.1.2":{"name":"mysql-activerecord","version":"0.1.2","devDependencies":{"node-mysql":"0.9.1"},"main":"./","_id":"mysql-activerecord@0.1.2","engines":{"node":"*"},"_engineSupported":true,"_npmVersion":"0.3.15","_nodeVersion":"v0.4.7","directories":{},"files":[""],"_defaultsLoaded":true,"dist":{"shasum":"6b1703aaf26b932df19360492592202c9315fedd","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.1.2.tgz","integrity":"sha512-9qAnqgBT9KnVeuoly5LpjTaP/BfIUdiSjjRSz3WWdfCPoGeUzk0mR3mWfP8WV/r13dPHwjiMFtuuLhyCkHChVg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIEConhFkTy6SZpXeniLYZtxQmpxWBLm2N5AQ82KNVMP5AiEAihWcrz/8Ax4h4mjd+3wVxyp9eAvuO54tEhwWg+tUdoc="}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.2.1":{"name":"mysql-activerecord","version":"0.2.1","devDependencies":{"node-mysql":"0.9.1"},"main":"./","_id":"mysql-activerecord@0.2.1","engines":{"node":"*"},"_engineSupported":true,"_npmVersion":"0.3.15","_nodeVersion":"v0.4.7","directories":{},"files":[""],"_defaultsLoaded":true,"dist":{"shasum":"121f5dd8d0736e36f7b6a659b2fa9fba43935af6","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.2.1.tgz","integrity":"sha512-82ZV9U1bMYcJCySEG7Ss5jiEVhUht28QkWJ30lydRMPpm5WlevMXOtbgwMFNDTRn4if2dABRrBw6stMk6IP7DQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIEzI5k2X54rpf+KZohz7YRIK6230rG7m+1KRgflyu71IAiALG/O8pAF5NtyxWL4rDeNxCrj30HO1ubG9YEylxwIbtg=="}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.2.9":{"name":"mysql-activerecord","version":"0.2.9","devDependencies":{"node-mysql":"0.9.1"},"main":"./","_id":"mysql-activerecord@0.2.9","engines":{"node":"*"},"_engineSupported":true,"_npmVersion":"0.3.15","_nodeVersion":"v0.4.7","directories":{},"files":[""],"_defaultsLoaded":true,"dist":{"shasum":"8b55761781d9caa17d1f01d226140c8e037522f8","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.2.9.tgz","integrity":"sha512-oxw0FsOwpVLnC7IGU9rO/f2Oz+qRDIs0pIXrHK6Fx+V8P1DqlGP8ASKpJj30xerLhNDm9gM1xGcBH9P0GZgtdg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBuWH3mFXrkaWq2IV4/CqwKlGHn34RBz/gdt49IWP4pWAiBpgZBbKoO6185eLM3hVGvYgGJaBkeUAvWxOu4o5Ad5zw=="}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.3.1":{"name":"mysql-activerecord","version":"0.3.1","devDependencies":{"node-mysql":"0.9.1"},"main":"./","_id":"mysql-activerecord@0.3.1","engines":{"node":"*"},"_engineSupported":true,"_npmVersion":"0.3.15","_nodeVersion":"v0.5.5","directories":{},"files":[""],"_defaultsLoaded":true,"dist":{"shasum":"a7d6e53e73c2fe4a50a5361a03762650045e10f2","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.3.1.tgz","integrity":"sha512-/O0dVzx85tc1txOkd18Feq3JQylUth8Xyr2k+i9glv93iGvsO6+grwqKZP5rCQ2Al7lXQhao+QDs+VoPsx4VwQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCBQY3nf7I4PddYK+ea+J6FJOfTWw6QGGipqQ7tN12ZwwIgNA5s15OOYXsuYWwYPMs/8wTXZPWNFCrxFyvfi/mxt0I="}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.3.2":{"name":"mysql-activerecord","version":"0.3.2","devDependencies":{"node-mysql":"0.9.4"},"main":"./","_id":"mysql-activerecord@0.3.2","engines":{"node":"*"},"_engineSupported":true,"_npmVersion":"0.3.15","_nodeVersion":"v0.5.5","directories":{},"files":[""],"_defaultsLoaded":true,"dist":{"shasum":"19e2815aee53679ebc662a6feda4c9929f808849","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.3.2.tgz","integrity":"sha512-A61JRWFb4lN/bfYglYTCVcHbezjLEWaaLKYoX3DfCX40jl84kMz4ftJuWYJOwbotSvXepoCUvaMQ4LnWkpRBsw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIDPhB4CtC3R45h5LYp8iuDUQR9PQa22oT9g732/3rj2jAiBTEvZOA4g1pkcwMS5N4djU70Q5lykXwHBQzGFd24K43Q=="}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.3.3":{"name":"mysql-activerecord","version":"0.3.3","devDependencies":{"node-mysql":"0.9.4"},"main":"./","_id":"mysql-activerecord@0.3.3","engines":{"node":"*"},"_engineSupported":true,"_npmVersion":"0.3.15","_nodeVersion":"v0.5.5","directories":{},"files":[""],"_defaultsLoaded":true,"dist":{"shasum":"1700aa0fe89ca4927aefe199e63f281ae2f57f90","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.3.3.tgz","integrity":"sha512-kV59hgbU+uDQhbFm6S6OxrAEvZNWohUViA9JInig3uF7OuVK0lXo8+9c64xH+yA2KY8AsQGco+yLk5p/b6yw0Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCOgMt5MOvmqDTU9u5VCQmfgJfxi/KfNYcjmU5LYVEVIAIhAM1yo2aiSvMYhk90UXlntYH9JgoGXUjk2NhgJb68M92F"}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.3.4":{"name":"mysql-activerecord","version":"0.3.4","devDependencies":{"node-mysql":"0.9.4"},"main":"./","_id":"mysql-activerecord@0.3.4","engines":{"node":"*"},"_engineSupported":true,"_npmVersion":"0.3.15","_nodeVersion":"v0.5.5","directories":{},"files":[""],"_defaultsLoaded":true,"dist":{"shasum":"68b12c8f2c3ee0d4f135d5dfa032c15ba6a9231a","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.3.4.tgz","integrity":"sha512-WsrfTpCXIpMb62UypI3L3m1yMUYVOPl/Wi+/x8P4yrdFuX7ZQgAwRkhl947uv6ME/5iHeD3zN/v4Kgz2edlD5w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDxNZjcrfLoNoQl2WxwL/wP/XAKvG5XaFXK2OBSalnmOwIhAMArC8b5I5Kbuzrth+1CdIu8gK+o+LWAgBZ++Tcx4+Nl"}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.3.5":{"name":"mysql-activerecord","version":"0.3.5","dependencies":{"node-mysql":">= 0.9.4"},"main":"./","_id":"mysql-activerecord@0.3.5","engines":{"node":"*"},"_engineSupported":true,"_npmVersion":"0.3.15","_nodeVersion":"v0.5.5","directories":{},"files":[""],"_defaultsLoaded":true,"dist":{"shasum":"4340b878a9f880a62a456ddb029b922d07469dec","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.3.5.tgz","integrity":"sha512-3CWBh5dqi3ga2d+nauQfw52sRE3QEmL1i5wzYxK+vMRFqrNaLS0ZsvqStUHhVhOIQkzE4R4SBWFBFzCQ8pvXjQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDsPop51q34FF0Kw1syqeR034n16Pg7DBQWgCPx1TfhywIgUCl4TaOdvm+uyfJQOqPTWA2s0QMTz7e5foBmrtmgdyc="}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.3.6":{"name":"mysql-activerecord","version":"0.3.6","devDependencies":{"node-mysql":">= 0.9.4"},"main":"./","_id":"mysql-activerecord@0.3.6","engines":{"node":"*"},"_engineSupported":true,"_npmVersion":"0.3.15","_nodeVersion":"v0.5.5","directories":{},"files":[""],"_defaultsLoaded":true,"dist":{"shasum":"37e4eb36ee206744b4a3f132fac86372eab9bc81","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.3.6.tgz","integrity":"sha512-fksdCQvxHtv/RUxkxFVSGccOu1mxSrZke5/3MZTuaXViSFbxd24Q2K7b/7AcPuK2QZzKIOqlDHtmeSGa5pYoRg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEMCIDJbwLKaO63c87VbGahqC8eOFEU36pcrfadMGcadhavhAh9H59z52Hsd88H7DJXlz4ZuPKc9Ec0iPPuN48Cy7i2B"}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.4.1":{"name":"mysql-activerecord","version":"0.4.1","devDependencies":{"mysql":"0.9.4"},"main":"./","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"_id":"mysql-activerecord@0.4.1","dependencies":{},"engines":{"node":"*"},"_engineSupported":true,"_npmVersion":"1.0.103","_nodeVersion":"v0.5.4","_defaultsLoaded":true,"dist":{"shasum":"f2edad8d768e94abb93970f7db5b54c00a6af42f","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.4.1.tgz","integrity":"sha512-6Rgsh3zPYEEKe05Bg1ihA3coAiDI+7KaXOwRtAr9Nnz2pQS2t2kvq1Hkpniwq9GtRGdOZHU6e+0RlJhf36hpYQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIF7y+M4JbIwij68MEANMlYOFn3YSOWPK8W4vktjXY1aLAiA3ugLWZLCgJ4oaNnxb3upagxgR9LryFFnHB/bEl14NPQ=="}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.5.1":{"name":"mysql-activerecord","version":"0.5.1","devDependencies":{"mysql":"0.9.4"},"main":"./","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"_id":"mysql-activerecord@0.5.1","dependencies":{},"engines":{"node":"*"},"_engineSupported":true,"_npmVersion":"1.0.103","_nodeVersion":"v0.5.4","_defaultsLoaded":true,"dist":{"shasum":"014c3401a361ed3b705d6478cdc9f34fe2c35297","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.5.1.tgz","integrity":"sha512-0msMGDLUo0WgeWnRA8ErQfjk1pJZFQTS1q0Yks3dxAlk+Qez7NwB1wGbvm5VyvopOvAS0Bq/D0ZSUAN7lwK3EA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICaxT4CNM2YRtQuSVXrOnJe5xK51168Cthv8SF0Tf4NVAiAzcunpXllNe/KgcYWbqCUOcVaGi7IgefGtVctjMxw2bA=="}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.5.2":{"name":"mysql-activerecord","version":"0.5.2","devDependencies":{"mysql":"0.9.4"},"main":"./","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"_id":"mysql-activerecord@0.5.2","dependencies":{},"engines":{"node":"*"},"_engineSupported":true,"_npmVersion":"1.0.103","_nodeVersion":"v0.5.4","_defaultsLoaded":true,"dist":{"shasum":"75cf818a542c377bfe293e888f964383593b78d7","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.5.2.tgz","integrity":"sha512-v1aZcP6AQEJYtuQOqs5KPS862/G4jLL+CBNoy7cL/FumfLEhevwx3y5aECFnh80cjnoQ4xeVjQsXFzkOdwZjTw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICkbQ9lS10L5Ua51h/ljwBh44qbAJSQ/nPUetx8EnLLxAiEAz92lQJd50BNKaOy8CxLfwTBawNCKOa20+fMFtHXoxW0="}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.6.1":{"name":"mysql-activerecord","version":"0.6.1","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"MySQL ActiveRecord pattern implementation on top of the mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"dependencies":{"mysql":"0.9.5"},"main":"./","engines":{"node":"*"},"_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"_id":"mysql-activerecord@0.6.1","devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.104","_nodeVersion":"v0.6.0","_defaultsLoaded":true,"dist":{"shasum":"ab6fb029f88bb94ad7481f8d426f7a6fdc6524c9","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.6.1.tgz","integrity":"sha512-lk2QLaqd/edORs8qiFJ0+IPTi+/aGluJEGZ1t8Pll3BnYgPETxWJzuZVfqGgw9BDIMrvpC5yoeaW+4wihie9Hg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCsX8s9vzVgnU6ihayj665Nv/ENLiYp6ROUkgZCmVIqTgIgaWBQZj7LxK5AGeuHV1nWPVTrvWvEvtIjbjb13UOGUwI="}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.6.2":{"name":"mysql-activerecord","version":"0.6.2","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"MySQL ActiveRecord pattern implementation on top of the mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"dependencies":{"mysql":"0.9.5"},"main":"./","engines":{"node":"*"},"_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"_id":"mysql-activerecord@0.6.2","devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.104","_nodeVersion":"v0.6.0","_defaultsLoaded":true,"dist":{"shasum":"eeb51ba83bdd8b1df1d6c43593b3ca57fd0c2bca","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.6.2.tgz","integrity":"sha512-OogqdWfUgtEf2nU5eg2SU90hE0Njdh/harp0XQNyCWKo+9sMimTU004VLbPtTzh8RPL3NXprXsx74vl/tZFLMw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDogx4xPz2S8dFSGLgdPNCw5/FYATQsFsbi4PPqS1BepgIgbcS3bPS0+yrQUyudHKeKR3go39R2aL88Z8I4G0r0Yms="}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.6.3":{"name":"mysql-activerecord","version":"0.6.3","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"MySQL ActiveRecord pattern implementation on top of the mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"dependencies":{"mysql":"0.9.5"},"main":"./","engines":{"node":"*"},"_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"_id":"mysql-activerecord@0.6.3","devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.104","_nodeVersion":"v0.6.0","_defaultsLoaded":true,"dist":{"shasum":"5bc8be4375e785192390bf4f84b1d5ced518810c","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.6.3.tgz","integrity":"sha512-IB9bCIQapXR1i6QAIXCVNhj6j9t5fQatYpYiFxOXacwu+DZJLjQRzrnnXYUpgCsjbSX3EUg+dqg7AbhbWzFg6Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQC0eW1BF4H4SGtQmPxRcGB5ge4NJc8syA/XJ+JUy10itwIgYpyX8w3ay2FfWVRDa6WDD8JyvQvPWvOaI0tzAfIlpPI="}]},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.6.4":{"name":"mysql-activerecord","version":"0.6.4","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"MySQL ActiveRecord pattern implementation on top of the mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"dependencies":{"mysql":"0.9.5"},"main":"./","engines":{"node":"*"},"_id":"mysql-activerecord@0.6.4","dist":{"shasum":"9cd1b3b652268dc1169003f796ae2bf67142a0b7","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.6.4.tgz","integrity":"sha512-UHgfydLjMGYO2eD/4o/N/BirvEe+4azbjWegpvjgG85/Td9nA5wP6hycvHO5b2O3MbCkC6SPzykYvNsVsVvoeQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDAZHup/wFURc4ggbK19pai00aeC2U7FCC8CtbcSEvdNAIgOBLaubN6zfmLkRA/zOGEJmHFiC++tSvN7tm/JaUz0hc="}]},"_npmVersion":"1.1.59","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.6.5":{"name":"mysql-activerecord","version":"0.6.5","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"MySQL ActiveRecord pattern implementation on top of the mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"contributors":[{"name":"Daniel Bretoi","email":"daniel@bretoi.com"}],"dependencies":{"mysql":"0.9.5"},"main":"./","engines":{"node":"*"},"_id":"mysql-activerecord@0.6.5","dist":{"shasum":"e1e752af0682b1c3582c8ab5152b51ef5447b3c2","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.6.5.tgz","integrity":"sha512-fsNujHoLxVe20xS4jNc4TjMjtpkJKgjlVSfxveeA0+3V/mUT3l/Oovhkrqmc3cZVZyaY4iKvLNHFqMVDL69/EQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDfx/16jh2dsR3G46QibM+89KT/BS9chH2NTbdZHk8N/AIhAKmqmCoGECyx2nNzQCyx7gYKChCUnqM4HIQe5EBsmMnK"}]},"_npmVersion":"1.1.65","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.7.1":{"name":"mysql-activerecord","version":"0.7.1","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"MySQL ActiveRecord pattern implementation on top of the mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"contributors":[{"name":"Daniel Bretoi","email":"daniel@bretoi.com"}],"dependencies":{"mysql":"0.9.6"},"main":"./","engines":{"node":"*"},"_id":"mysql-activerecord@0.7.1","dist":{"shasum":"67d7bf48548b265af04a0fae50561a71db4b77c0","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.7.1.tgz","integrity":"sha512-lH8vCVRW/N2UkrgWWmHIbXYrVNDgIN7k9SFpzBIIRztMigYu8BlebtHF/zjfzNSlfkOid8ZeknJVvd5n1vtD9Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDebCfsLF4iM0fwN7ZeTRlrJgLAXjSeHapy9d0YBttKygIhAML+3M5/pW5+la02g1v2u0JaQu1hHilHss9TkzxyLmeO"}]},"_npmVersion":"1.1.65","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.7.2":{"name":"mysql-activerecord","version":"0.7.2","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"MySQL ActiveRecord pattern implementation on top of the mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"contributors":[{"name":"Daniel Bretoi","email":"daniel@bretoi.com"}],"dependencies":{"mysql":"0.9.6"},"main":"./","engines":{"node":"*"},"_id":"mysql-activerecord@0.7.2","dist":{"shasum":"d297953c0ec35c6fdf44e8d910e7413f55a83d69","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.7.2.tgz","integrity":"sha512-DiIk0tw+b5Obbc0cneJKXEl5SOvdIDAUaKXlSayiVzQZuo6jaQldbkTJVvl67ZimZMwhGbc55UQSxErPYoYHbQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDRn9i+oz0T2ADMhI6LdfYhfLvhNenxE+52PW8n6jqQcAIhAKo977w9OgaYntkxYeLvejB0JGQfKzVPQ2TPWn8yrssO"}]},"_npmVersion":"1.1.65","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.7.3":{"name":"mysql-activerecord","version":"0.7.3","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"MySQL ActiveRecord pattern implementation on top of the mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"contributors":[{"name":"Daniel Bretoi","email":"daniel@bretoi.com"}],"dependencies":{"mysql":"0.9.6"},"main":"./","engines":{"node":"*"},"_id":"mysql-activerecord@0.7.3","dist":{"shasum":"7cf87db6d45cc4b46f5745c70f6ac43013ea26f4","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.7.3.tgz","integrity":"sha512-MLZKNa4Rr1IxQC/3adO+t6z1gbQC5gGv9+US3eTjpMX17GQ3pGIWJRYvBuWPg74YSSAgLVsaycyLiuE4CqaFJQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIGg88ZLH0RXR0kyD34zcxkJNthPpUuiq8PB3B+o33G6sAiEA1g672Fxb8OcJu7CsWAL7yyH+Tkak8wNUa/ZKFufncg8="}]},"_from":".","_npmVersion":"1.2.10","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.7.4":{"name":"mysql-activerecord","version":"0.7.4","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"MySQL ActiveRecord pattern implementation on top of the mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"contributors":[{"name":"Daniel Bretoi","email":"daniel@bretoi.com"}],"dependencies":{"mysql":"0.9.6"},"main":"./","engines":{"node":"*"},"_id":"mysql-activerecord@0.7.4","dist":{"shasum":"e16429fd9b224fc5e95df6b66a0fb8ce695887bd","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.7.4.tgz","integrity":"sha512-hKJSAIO3lTUW2fa8S0velBAliF43Gb/IOxxTDxuKA2tMYFzNstozZZ/ngHQp0Mw0sCpW+DmJ0PrPR9shmecPTA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICWXjPkCmA6G0gnZVOpx1coteiwstt0sMdWsy4QPBibOAiAJXJylLgvOcUwpd09exVU+X6V+hjkrltwVSRArpwKJlw=="}]},"_from":".","_npmVersion":"1.2.10","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.8.1":{"name":"mysql-activerecord","version":"0.8.1","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"MySQL ActiveRecord pattern implementation on top of the mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"contributors":[{"name":"Daniel Bretoi","email":"daniel@bretoi.com"}],"dependencies":{"mysql":"2.0.0-alpha8"},"main":"./","engines":{"node":"*"},"_id":"mysql-activerecord@0.8.1","dist":{"shasum":"b49bea8212ee31665af6a7bedf33b026dd2f5068","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.8.1.tgz","integrity":"sha512-5U4cEA9b7gRMWhvXVhrrOpwQlWXECDjn7Icw0uWU7zR9Cu4fJOW9nbX9WI0QskbX7myK0czqtIh3OdpH8Px6ZA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIB5+lv3cWrlEtNHjJOOdrfXRCKxCXxzZGwj3ncmpznpuAiBFkvC3vnwU9c0pp0imc4RQpg477n9nf9CAG+R55oSoJA=="}]},"_from":".","_npmVersion":"1.2.15","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.8.2":{"name":"mysql-activerecord","version":"0.8.2","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"MySQL ActiveRecord pattern implementation on top of the mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"contributors":[{"name":"Daniel Bretoi","email":"daniel@bretoi.com"}],"dependencies":{"mysql":"2.0.0-alpha8"},"main":"./","engines":{"node":"*"},"_id":"mysql-activerecord@0.8.2","dist":{"shasum":"b45c1b9733adf9ce190a45d59b90ce2e827e77e9","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.8.2.tgz","integrity":"sha512-UPwhMXoksqxltQLyG3Tn6+OGUSpV1GxwNn3wwCkhwuSu1bYejRtcpRUhDsdZdOAqI0l+JNkWoaXPJpVPISqljw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCvpyUiP9boiB3knoEBS4CNtr9WGysL/kbPFW5XYKfqzwIhAOyVtiVfCgUsDHzVtBUi1Lkw+yGYDUPW/EQxWysP/xHz"}]},"_from":".","_npmVersion":"1.2.15","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.8.3":{"name":"mysql-activerecord","version":"0.8.3","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"MySQL ActiveRecord pattern implementation on top of the mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"contributors":[{"name":"Daniel Bretoi","email":"daniel@bretoi.com"}],"dependencies":{"mysql":"2.0.0-alpha8"},"main":"./","engines":{"node":"*"},"_id":"mysql-activerecord@0.8.3","dist":{"shasum":"0fc8ea1948974b4075db48e2be420be94694523f","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.8.3.tgz","integrity":"sha512-sp96ecZYXIJ3FbrzFul6dnqK6wB3ev6njlAwXPfc8ZfyuEqdG9kfaheCwpx9U7QkoY+1huQuwelvNBqoJ0RVBQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDvODqpaiFGd7M0TvpDoAtmU0IxfPXE3+bnvlmBV7DwegIgE1kVPOUl6hODbomAglBQP295VhLS5xSdYKNwQ49K7q4="}]},"_from":".","_npmVersion":"1.2.15","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.8.4":{"name":"mysql-activerecord","version":"0.8.4","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"MySQL ActiveRecord pattern implementation on top of the mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"contributors":[{"name":"Daniel Bretoi","email":"daniel@bretoi.com"},{"name":"Kyle Farris","email":"kyle@chomponllc.com"},{"name":"Daehyub Kim","email":"lateau@gmail.com"}],"dependencies":{"mysql":"~2.1"},"main":"./","engines":{"node":"*"},"bugs":{"url":"https://github.com/martintajur/node-mysql-activerecord/issues"},"_id":"mysql-activerecord@0.8.4","dist":{"shasum":"668aa5674cca8140302a59e6398bf687cf558ae3","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.8.4.tgz","integrity":"sha512-Bfg1xEYRElydMWjqmQLLp7dRaAjB/khel+DFH/DvXmsgkYjPYzCJtn0kags5YPiESmHHXYGqJ7iw/ygDF0+BKQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD9hRLdY/tWCw9xitB9JT+/wSr64sNi1lItzyktJvnEAwIhAPZZptM2N3MBk3VWehntkISF5XRSsJ+C7vaqhT3Kdt0/"}]},"_from":".","_npmVersion":"1.3.21","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}]},"0.8.5":{"name":"mysql-activerecord","version":"0.8.5","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"A lightweight MySQL query builder on top of the node-mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"contributors":[{"name":"Daniel Bretoi","email":"daniel@bretoi.com"},{"name":"Kyle Farris","email":"kyle@chomponllc.com"},{"name":"Daehyub Kim","email":"lateau@gmail.com"}],"dependencies":{"mysql":"2.5.2"},"main":"./","engines":{"node":"*"},"gitHead":"9369eb4ed4acd103b50e84226f9d3b77e20dbdf5","bugs":{"url":"https://github.com/martintajur/node-mysql-activerecord/issues"},"_id":"mysql-activerecord@0.8.5","scripts":{},"_shasum":"1924e14ed07a05e55ecdcc527672dd7f664bc476","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}],"dist":{"shasum":"1924e14ed07a05e55ecdcc527672dd7f664bc476","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.8.5.tgz","integrity":"sha512-xth+6Ydxw4/bIQxE9tZG6PwA8LJbHtrCpc6ClQh3hT324hCCfeEALyn5lh4DePphdwG9guI/gCkfBD3JLrTNhA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCiO1ZdGxI5BO+Ahue0hF3oNiHselnhuZ0x6aar0XBapwIhAMl3TJnWoNzecVVEut7QtZezMp5AC0nwQXFxncXJNYMW"}]}},"0.8.6":{"name":"mysql-activerecord","version":"0.8.6","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"description":"A lightweight MySQL query builder on top of the node-mysql module.","homepage":"https://github.com/martintajur/node-mysql-activerecord","repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"contributors":[{"name":"Daniel Bretoi","email":"daniel@bretoi.com"},{"name":"Kyle Farris","email":"kyle@chomponllc.com"},{"name":"Daehyub Kim","email":"lateau@gmail.com"}],"dependencies":{"mysql":"2.5.2"},"main":"./","engines":{"node":"*"},"gitHead":"22d61ae244f7436747ecd700bd262fb705a3235e","bugs":{"url":"https://github.com/martintajur/node-mysql-activerecord/issues"},"_id":"mysql-activerecord@0.8.6","scripts":{},"_shasum":"47f012c30bdd052a87711ca1e99e0fe8ec71e4ed","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"martin.tajur","email":"martin@tajur.ee"},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}],"dist":{"shasum":"47f012c30bdd052a87711ca1e99e0fe8ec71e4ed","tarball":"https://registry.npmjs.org/mysql-activerecord/-/mysql-activerecord-0.8.6.tgz","integrity":"sha512-Zy7O3Hpx+CfUDTxiEZm7ikfYTJNbN5ct3RXEi01Pm2Qm+hVINQiJBHr6m3pi6IZT8B1W6TEg1fxVv4nKugoWRQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAZOK5UYJs6xztNSe6fdFATzq0x/rP2R9LTIO3Q4kJXTAiB+V74RhqgkOHkN0pPJe56fdItnKut9PrQvk6FdcGgRfw=="}]}}},"maintainers":[{"name":"martin.tajur","email":"martin@tajur.ee"}],"time":{"modified":"2022-06-20T18:04:54.485Z","created":"2011-08-04T10:46:15.593Z","0.1.1":"2011-08-04T10:46:16.030Z","0.1.2":"2011-08-04T11:00:38.345Z","0.2.1":"2011-08-04T11:09:20.980Z","0.2.9":"2011-08-08T12:53:11.141Z","0.3.1":"2011-09-05T17:35:06.119Z","0.3.2":"2011-09-05T17:54:23.668Z","0.3.3":"2011-09-05T17:55:26.265Z","0.3.4":"2011-09-06T06:14:54.631Z","0.3.5":"2011-10-17T17:52:24.804Z","0.3.6":"2011-10-17T17:53:04.130Z","0.4.1":"2011-11-02T17:28:21.882Z","0.5.1":"2011-11-03T13:22:36.414Z","0.5.2":"2011-11-03T13:36:45.935Z","0.6.1":"2012-02-07T08:54:43.563Z","0.6.2":"2012-02-07T09:02:18.974Z","0.6.3":"2012-03-20T12:19:51.474Z","0.6.4":"2012-08-29T12:05:32.153Z","0.6.5":"2013-01-20T17:37:04.778Z","0.7.1":"2013-01-24T09:59:39.343Z","0.7.2":"2013-01-24T10:22:09.518Z","0.7.3":"2013-02-11T08:38:42.345Z","0.7.4":"2013-02-11T08:46:17.861Z","0.8.1":"2013-05-17T00:06:23.067Z","0.8.2":"2013-05-17T00:44:27.956Z","0.8.3":"2013-09-19T13:55:11.346Z","0.8.4":"2014-04-14T10:03:53.391Z","0.8.5":"2014-10-21T12:12:09.590Z","0.8.6":"2014-10-21T12:40:55.463Z"},"description":"A lightweight MySQL query builder on top of the node-mysql module.","author":{"name":"Martin Tajur","email":"martin@tajur.ee"},"repository":{"type":"git","url":"git://github.com/martintajur/node-mysql-activerecord.git"},"readme":"MySQL ActiveRecord Adapter for Node.js\n======================================\n\nQuery builder on top of node-mysql module (https://github.com/felixge/node-mysql).\n\nTo me, the main benefit of  is the ability to direct JavaScript objects straight to MySQL query components without having to worry about constructing the query itself. Although this query builder is a tiny step towards an ORM, I see a lot of value in the query builder as it allows more control over database queries than traditional ORM where queries are hidden behind the business logic and may become executed in an unoptimized way. (It is named after a popular PHP framework CodeIgniter's \"Active Record\" class, and thus the whole library does not have much in common with the active record pattern as such.)\n\nThis query builder is\n \n * Light-weight\n * Supports all basic MySQL commands\n * Supports method chaining\n * Automatically escapes field values\n * Has no dependencies (it already includes the node-mysql module)\n * Supports raw queries\n\nHow to install\n==============\n\n\tnpm install mysql-activerecord\n\n\nGet started\n-----------\n\n\tvar Db = require('mysql-activerecord');\n\tvar db = new Db.Adapter({\n\t\tserver: 'localhost',\n\t\tusername: 'root',\n\t\tpassword: '12345',\n\t\tdatabase: 'test',\n\t\treconnectTimeout: 2000\n\t});\n\n * `server`: the IP address or hostname to connect to\n * `username`: MySQL username to connect with\n * `password`: MySQL password to connect with\n * `database`: database to switch to initially (optional). If omitted, no database will be selected.\n * `port`: which port to connect to (optional). If omitted, 3306 will be used.\n * `reconnectTimeout`: milliseconds after which to try to reconnect to the MySQL server if a disconnect happens (optional). If omitted, the default value of 2000 will be used. If set to `false`, no reconnecting will take place.\n\nSupport of MySQL commands\n=========================\n\n * SELECT\n * UPDATE\n * INSERT (single-row and multi-row)\n * INSERT IGNORE\n * DELETE\n * JOIN\n * LIMIT and OFFSET\n * ORDER BY\n * GROUP BY\n * COUNT\n * HAVING\n\nMethods\n=======\n\n# .select()\n\n## .select(selectFieldName)\nSpecifies the field(s) to use in the SELECT query as a atring.\n\n\tdb.select(\"id, CONCAT(first_name, ' ', last_name) as full_name, email\");\n\t// This would produce: SELECT id, CONCAT(first_name, ' ', last_name) as full_name, email …\n\nYou can call .select() multiple times within the scope of one query — all parameters will be used in the final query. E.g.\n\n\tdb.select('id');\n\t// do some advanced checking and calculations here (only synchronous work, though!)\n\tdb.select('first_name, last_name');\n\t// This would procude: SELECT id, first_name, last_name …\n\n## .select([selectFieldName, selectFieldName, … ])\nSame as above, with a difference of taking in fields list as an array.\n\n\tdb.select(['id', 'first_name', 'last_name']);\n\t// This would produce: SELECT id, first_name, last_name …\n\n# .where()\n\n## .where(rawClause)\nSpecifies a where clause component.\n\n\tdb.where('add_time is null');\n\t// This would produce: … WHERE add_time is null …\n\nYou can call .where() multiple times within the scope of one query — all parameters will be used in the final query.\n\n## .where(fieldName, [possibleWhereInValue, possibleWhereInValue])\nSpecifies a WHERE IN structure to use in the query.\n\n\tdb.where('first_name', ['John', 'Maria', 'Jason', 'Herbert']);\n\t// This would produce: … WHERE first_name in ('John', 'Maria', 'Jason', 'Herbert') …\n\n## .where(fieldName, fieldValue)\nSpecifies a single WHERE condition to use in the query.\n\n\tdb.where('first_name', 'John');\n\t// This would produce: … WHERE first_name = 'John' …\n\n## .where({ fieldName: fieldValue, fieldName: fieldValue, … })\nSpecifies multiple WHERE conditions to use in the query.\n\n\tvar conditions = {\n\t\tfirst_name: 'John',\n\t\tlast_name: 'Smith'\n\t};\n\tdb.where(conditions);\n\t// This would produce: … WHERE first_name = 'John' AND last_name = 'Smith' …\n\n# .order_by()\n\n## .order_by(orderByCondition)\nSpecifies the ORDER BY condition as a full string.\n\n\tdb.order_by('name asc');\n\t// This would produce: … ORDER BY name asc …\n\nYou can call .order_by() multiple times within the scope of one query — all parameters will be used in the final query.\n\n## .order_by([orderByCondition, orderByCondition, … ])\nSpecifies multiple ORDER BY conditions as an array.\n\n\tdb.order_by(['name asc', 'last_name desc']);\n\t// This would produce: … ORDER BY name asc, last_name desc …\n\n# .group_by()\n\n## .group_by(groupByCondition)\nSpecifies the GROUP BY condition as a full string.\n\n\tdb.group_by('name asc');\n\t// This would produce: … GROUP BY name asc …\n\nYou can call .group_by() multiple times within the scope of one query — all parameters will be used in the final query.\n\n## .group_by([groupByCondition, groupByCondition, … ])\nSpecifies the GROUP BY condition as a full string.\n\n\tdb.group_by(['name asc', 'last_name desc']);\n\t// This would produce: … GROUP BY name asc, last_name desc …\n\n# .join()\n\n## .join(tableName, joinCondition, joinDirection)\nJoin additional tables to the query.\n\n\tdb.join('pets', 'pets.owner_id = people.id', 'LEFT');\n\t// This would produce: … LEFT JOIN pets ON pets.owner_id = people.id …\n\n\tdb.join('pets', 'pets.owner_id = people.id');\n\t// This would produce: … JOIN pets ON pets.owner_id = people.id …\n\n# .limit()\n\n## .limit(limitNumber)\nAdds a row limit to query results.\n\n\tdb.limit(10);\n\t// Limits query results to 10 rows.\n\n## .limit(limitNumber, offsetNumber)\nAdds a row limit with an offset pointer position to query results.\n\n\tdb.limit(10, 30);\n\t// Limits query results to 10 rows, starting from the 30th row in the full matching set.\n\n# Query execution commands\n\nAfter execution of a query, all query conditions are cleared. Results are passed down to responseCallback function. The parameters handed over to responseCallback match exactly what the underlying node-mysql module produces. See documentation from https://github.com/felixge/node-mysql\n\n## .update(tableName, newData, responseCallback)\nProduces and executes UPDATE query. \n\n\tdb.update('people', { first_name: 'John', last_name: 'Smith' }, function(err) { ... });\n\t// This would produce: … UPDATE people SET first_name = 'John', last_name = 'Smith' …\n\n## .delete(tableName, responseCallback)\nProduces and executes DELETE query. Be sure to specify some WHERE clause components using .where() not to truncate an entire table. ✌\n\n\tdb.delete('people', function(err) { ... });\n\t\n## .insert(tableName, newData, responseCallback)\nProduces and executes a single-row INSERT query. \n\n\tdb.insert('people', { first_name: 'John', last_name: 'Smith' }, function(err, info) { ... });\n\t// This would produce: … INSERT INTO people SET first_name = 'John', last_name = 'Smith' …\n\n## .insert(tableName, [newData, newData, newData, …], responseCallback)\nProduces and executes a multi-row INSERT query. \n\t\n\tvar person1 = { first_name: 'John', last_name: 'Smith' };\n\tvar person2 = { first_name: 'Jason', last_name: 'Binder' };\n\tvar person3 = { first_name: 'Herbert', last_name: 'von Kellogg' };\n\tdb.insert('people', [person1, person2, person3], function(err, info) { ... });\n\t// This would produce: … INSERT INTO people (first_name, last_name) VALUES (('John','Smith'),('Jason','Binder'),('Herbert','von Kellogg')) …\n\n## .insert_ignore(tableName, newData, responseCallback, onDuplicateKeyClause)\nProduces and executes an INSERT IGNORE query. Note that the newData parameter can be either a string (produces single-row INSERT) or an array (produces multi-row INSERT). You can also specify an optional onDuplicateKeyClause, e.g.\n\t\n\tdb.insert_ignore('people', { first_name: 'John', last_name: 'Smith' }, function(err, info) { ... }, 'ON DUPLICATE KEY UPDATE duplicate_count = duplicate_count + 1');\n\t// This would produce: … INSERT IGNORE INTO people SET first_name = 'John', last_name = 'Smith' … ON DUPLICATE KEY UPDATE duplicate_count = duplicate_count + 1\n\n## .get(tableName, responseCallback)\nProduces and executes a SELECT query.\n\n\tdb.get('people', function(err, rows, fields) { ... });\n\t// This would produce: SELECT … FROM people …\n\n## .count(tableName, responseCallback)\nProduces and executes a SELECT query with count.\n\n\tdb.get('people', function(err, rows, fields) { ... });\n\t// This would produce: SELECT count(*) FROM people …\n\n## .query(sqlQueryString, responseCallback)\nProduces and executes a raw query. Note that while no set query conditions will be used in this query, they will all be reset nevertheless with the execution.\n\n\tdb.query('SHOW TABLES FROM test_database', function(err, results) { ... });\n\n## .ping()\nPings the connection. This is useful when extending idle timeouts.\n\n## ._last_query()\nReturns the last executed query as a string.\n\n## .connection()\nReturns the underlying database connection object, ultimately what https://github.com/felixge/node-mysql .createConnection() returns.\n\nPooling connections\n===================\n\nSingle or multiple connections can be pooled with the Pool object.\n\n\tvar Db = require('mysql-activerecord');\n\n\tvar pool = new Db.Pool({\n\t\tserver: 'localhost',\n\t\tusername: 'root',\n\t\tpassword: '12345',\n\t\tdatabase: 'test'\n\t});\n\t\n\tpool.getNewAdapter(function(db) {\n\t\tdb\n\t\t\t.where({ name: 'Martin' })\n\t\t\t.get('people', function(err, results, fields) {\n\t\t\t\tconsole.log(results);\n\t\t\t\tdb.releaseConnection();\n\t\t\t\t// do not do anything with db that has been released.\n\t\t\t});\n\t});\n\nSome more usage examples\n========================\n\nEstablishing a connection\n-------------------------\n\n\tvar Db = require('mysql-activerecord');\n\tvar db = new Db.Adapter({\n\t\tserver: 'localhost',\n\t\tusername: 'root',\n\t\tpassword: '12345',\n\t\tdatabase: 'test'\n\t});\n\t\nBasic SELECT query\n------------------\n\n\tdb.get('people', function(err, results, fields) {\n\t\tconsole.log(results);\n\t});\n\nINSERT query\n------------\n\t\n\tvar data = {\n\t\tname: 'Martin',\n\t\temail: 'martin@example.com'\n\t};\n\t\n\tdb.insert('people', data, function(err, info) {\n\t\tconsole.log('New row ID is ' + info.insertId);\n\t});\n\nINSERT IGNORE query with ON DUPLICATE KEY clause\n------------------------------------------------\n\t\n\tvar data = {\n\t\tname: 'Martin',\n\t\temail: 'martin@example.com'\n\t};\n\t\n\tdb.insert_ignore('people', data, function(err, info) {\n\t\tconsole.log('New row ID is ' + info.insertId);\n\t}, 'ON DUPLICATE KEY SET counter = counter + 1');\n\t\nSELECT query with WHERE clause\n------------------------------\n\n\tdb\n\t\t.where({ name: 'Martin' })\n\t\t.get('people', function(err, results, fields) {\n\t\t\tconsole.log(results);\n\t\t});\n\nSELECT query with custom fields, WHERE, JOIN and LIMIT\n------------------------------------------------------\n\n\tdb\n\t\t.select(['people.id', 'people.name', 'people.email', 'songs.title'])\n\t\t.join('songs', 'people.favorite_song_id', 'left')\n\t\t.where({\n\t\t\t'people.name': 'Martin',\n\t\t\t'songs.title': 'Yesterday'\n\t\t})\n\t\t.limit(5, 10)\n\t\t.order_by('people.name asc')\n\t\t.get('people', function(err, results, fields) {\n\t\t\tconsole.log(results);\n\t\t});\n\nBasic counting\n------------------------------------------------------\n\n\tdb\n\t\t.where({\n\t\t\t'people.name': 'Martin',\n\t\t\t'songs.title': 'Yesterday'\n\t\t})\n\t\t.count('people', function(err, results, fields) {\n\t\t\tconsole.log(results);\n\t\t});\n\nSELECT query with custom fields and GROUP BY\n--------------------------------------------\n\n\tdb\n\t\t.select('name, COUNT(name) AS name_count')\n\t\t.group_by('name')\n\t\t.order_by('name_count DESC')\n\t\t.get('people', function(err, results, fields) {\n\t\t\tconsole.log(results);\n\t\t});\n\nBasic UPDATE query\n------------------\n\t\n\tvar newData = {\n\t\tname: 'John',\n\t\temail: 'john@doe.com'\n\t};\n\t\n\tdb\n\t\t.where({ id: 1 });\n\t\t.update('people', newData, function(err) {\n\t\t\tif (!err) {\n\t\t\t\tconsole.log('Updated!');\n\t\t\t}\n\t\t});\n\nBasic DELETE query\n------------------\n\n\tdb\n\t\t.where({ id: 1 })\n\t\t.delete('people', function(err) {\n\t\t\tif (!err) {\n\t\t\t\tconsole.log('Deleted!')\n\t\t\t}\n\t\t});\n\n\nAdvanced WHERE conditions\n-------------------------\n\n\tdb\n\t\t.where(\"title not like '%Jackson%'\")\n\t\t.where(\"date_created > '2012-03-10'\")\n\t\t.where({ owner_id: 32 })\n\t\t.delete('records', function(err) {\n\t\t\tif (!err) {\n\t\t\t\tconsole.log('Deleted!')\n\t\t\t}\n\t\t});\n\n\nContribute\n==========\n\nGot a missing feature you'd like to use? Found a bug? Go ahead and fork this repo, build the feature and issue a pull request.\n\n\nLicence info\n============\n\nLicensed under the GPL license and MIT:\n\n* http://www.opensource.org/licenses/GPL-license.php\n* http://www.opensource.org/licenses/mit-license.php\n\n","homepage":"https://github.com/martintajur/node-mysql-activerecord","contributors":[{"name":"Daniel Bretoi","email":"daniel@bretoi.com"},{"name":"Kyle Farris","email":"kyle@chomponllc.com"},{"name":"Daehyub Kim","email":"lateau@gmail.com"}],"bugs":{"url":"https://github.com/martintajur/node-mysql-activerecord/issues"},"readmeFilename":"README.md","users":{"paulomcnally":true,"feryardiant":true,"theturtle32":true,"f124275809":true,"mmachine":true,"karrdy":true,"andriecool":true,"kairess":true,"zcdll":true}}