{"_id":"mssql-helper","_rev":"31-1032c75489f3e605cf10f687f7a7efd2","name":"mssql-helper","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","dist-tags":{"latest":"0.2.1"},"versions":{"0.0.1":{"name":"mssql-helper","version":"0.0.1","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"lib/db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"mssql":"^1.2.0"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"97860c696edeab1f3a887602fdc126eac030aa2c","_id":"mssql-helper@0.0.1","scripts":{},"_shasum":"91c0b9083c9bdd22847826401dc8dfbeff9bf2fb","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"91c0b9083c9bdd22847826401dc8dfbeff9bf2fb","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.0.1.tgz","integrity":"sha512-9/0SBNI0eapPIIHIO1Kfm3DhiJLiriL6G7+4QxrHrE66x4a825eDUPNcFnpMtWlI0mvctlHCxDno/ANPTapP4Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCv8uRXTP2WZb411ri2j9QT4vIbyp5PnPLfMwO+eBIICQIhANSKvMcz6ez5phDe6DTkqynGcLiePZIJ3ENv0duqtVVM"}]}},"0.0.2":{"name":"mssql-helper","version":"0.0.2","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"mssql":"^1.2.0"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"39dd50877279d20418c56860b948fb8f98ec12ea","_id":"mssql-helper@0.0.2","scripts":{},"_shasum":"e5b72b19cfff569da0d9fd703348471b8a24922a","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"e5b72b19cfff569da0d9fd703348471b8a24922a","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.0.2.tgz","integrity":"sha512-TbucPKjUPKzx8B29IO5jJAqVCS+PSWwGRTnzF1rC3sFUyxCfXtMXb4EgkWPK9aAP37E9kQEd7v9mymhuyVXgMg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIHXGOKVxW77sMF+jMWcVTBN7CDKP+R0szcOtkwwN2mczAiEAvvdcxcXCvRuC5Zf1ejH5fkSB7/GHMcSNCYr0fE9Il04="}]}},"0.0.3":{"name":"mssql-helper","version":"0.0.3","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"mssql":"^1.2.0"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"572e06eed975fd6ec9093f331b80e4759ee7f1ab","_id":"mssql-helper@0.0.3","scripts":{},"_shasum":"decf1ed2b946b2e0099dbcbf9c7cfe3726aa3bca","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"decf1ed2b946b2e0099dbcbf9c7cfe3726aa3bca","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.0.3.tgz","integrity":"sha512-DvtaFwJlvDIfEA66bfFlQehXChBcQYcI4NG8Ovi0r29wSSI05QyQBJxKwoH8fSWhGRnqlHDP6X/xumjdFHCfOw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCID6WkOeD/MGxp7ATO3FEA2gDg/XtTGEEUKpfriIktGgyAiEAwZaNuEsBHMIUW+MT8QVrvCumBjwTz0XqW1PUmIB4QcQ="}]}},"0.0.4":{"name":"mssql-helper","version":"0.0.4","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"mssql":"^1.2.0"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"572e06eed975fd6ec9093f331b80e4759ee7f1ab","_id":"mssql-helper@0.0.4","scripts":{},"_shasum":"818a3fc9a0d1ba4622d964fc278f7457ca2f5241","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"818a3fc9a0d1ba4622d964fc278f7457ca2f5241","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.0.4.tgz","integrity":"sha512-t9sIOAQIbFxMhlWvasIZE+iVJhWRXfK23eVjARc9vDVOiO0cyAlVDaISIVso6TNQvGxcCH++Gy66KDhiOhflUg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCDbRZ1aHpkPc0jDVoxEM5ue49agm2J6dEZ8Ex5E6FKsgIgY37PtPCMYHGvCYGa6A3i0YDh+MLiba7TCpPJMrpZbig="}]}},"0.0.5":{"name":"mssql-helper","version":"0.0.5","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"mssql":"^1.2.0"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"572e06eed975fd6ec9093f331b80e4759ee7f1ab","_id":"mssql-helper@0.0.5","scripts":{},"_shasum":"1a4e9169c8d35c0f478fb9686dbcae71fa80cdcc","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"1a4e9169c8d35c0f478fb9686dbcae71fa80cdcc","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.0.5.tgz","integrity":"sha512-Q83+n+FSgRXaq4j7luaXu38LZ9r7o3jFEtaVfwHIR1GLqhaA+aXgWaX3HrFSsaUHgDmZT9J1hJTOF3H584A4Mg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDuJQKC0MdHnCG6vJB6QSVVy1zNaEzvBE+PN1D+VmyRtAIhAMOTu878MW+pL87+REets4z0/Ma+eI6RHHt3+e66045i"}]}},"0.0.6":{"name":"mssql-helper","version":"0.0.6","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"mssql":"^1.2.0"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"2be712fd1fbfa9e41415069b02cd16479d7b90e7","_id":"mssql-helper@0.0.6","scripts":{},"_shasum":"b189df50929a40827214b2c34d4350040d82b5d4","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"b189df50929a40827214b2c34d4350040d82b5d4","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.0.6.tgz","integrity":"sha512-Ak20449J+woQeAW1yEbaAtYCgW3kWaLSLWDWuJjWSsXJmqLTdQ6DKZhKWeXWVFWLhA16V2mTAtsa6aw03Fzd4Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCAILYTt/seovzcBsn3XE8I08dHoOJ8Cbloe05Vmf0RgAIga6+EFzIg0RZLZTHuCFEBYaN6x9rw+AIRWVs8+HtVXEo="}]}},"0.0.7":{"name":"mssql-helper","version":"0.0.7","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"moment":"^2.8.3","mssql":"^1.2.0","winston":"^0.8.1"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"1741301e5ffce3f2f3eb9d22cc347c7bce534411","_id":"mssql-helper@0.0.7","scripts":{},"_shasum":"dfa2997778c1d222d59873f5bfc20393a3dd685f","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"dfa2997778c1d222d59873f5bfc20393a3dd685f","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.0.7.tgz","integrity":"sha512-rgiETQmmcZoi2vE3sIhB7YorwENgIMhmzPXSFDB47VBFilBMTlnub20ri8IciuC7K1tJLFPsQb/XLib6KCyANw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIFemociWmSVMGnJpL4IhYwFk8nEC2AfiDkF+iDVBmIeZAiEAzdLZs98TV42nkNYf+Gf72sjJrma1+EZlLnm/elp/uJQ="}]}},"0.1.0":{"name":"mssql-helper","version":"0.1.0","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"moment":"^2.8.3","mssql":"^1.2.0","winston":"^0.8.1"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"a7633ff4d4e75c151638360ad162435600d3d036","_id":"mssql-helper@0.1.0","scripts":{},"_shasum":"209c7126bd91156deae18b74afd6b98a5ef4041f","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"209c7126bd91156deae18b74afd6b98a5ef4041f","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.1.0.tgz","integrity":"sha512-VNp4znLMY/e5ZxCYGqF8HNIqDKGB1sc3Sq05zWQCWWH5fiDbcHUntsD3O8Ia2tYSo7CvKCUBZoprKt0iyOlwMQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIEhIrQQjThMZXlN3QsOpI3/0jDUh4RYiuAwzsK78/CcpAiEAtLokxDw2A0v1zM8841sYp0TItVwlK8IdoAvi/We1BaY="}]}},"0.1.1":{"name":"mssql-helper","version":"0.1.1","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"moment":"^2.8.3","mssql":"^1.2.0","winston":"^0.8.1"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"a7633ff4d4e75c151638360ad162435600d3d036","_id":"mssql-helper@0.1.1","scripts":{},"_shasum":"cef51dfaa5a57b519cd7bf5f3f7be29b6675a655","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"cef51dfaa5a57b519cd7bf5f3f7be29b6675a655","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.1.1.tgz","integrity":"sha512-NKvSyI3mayPOKp0v3RTPAK7bjyQHt10VFkOlT7wmSgsTEOi5EtEMAmq1HaBtJAktHIPC6HPwHg/6hG9W61+OsQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCCg+X0GuK6goe9gZqUaW5hVfxh7d/C48k1dIALjEyCNgIgKI3CPNhPpVzZ4HkJFqVJZ4S0xYhhn4ljk0MaFfu0WWc="}]}},"0.1.2":{"name":"mssql-helper","version":"0.1.2","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"moment":"^2.8.3","mssql":"^1.2.0","winston":"^0.8.1"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"6f2ab8753c5e5e404bcc03031b50257f20b3acd0","_id":"mssql-helper@0.1.2","scripts":{},"_shasum":"bced47b588906be5d7dfa57f7779bdd71ef11cd9","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"bced47b588906be5d7dfa57f7779bdd71ef11cd9","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.1.2.tgz","integrity":"sha512-3flBzUDXZVxSQzjOtKVWX7F8Q1dw4BtVGSt8nP3decKjIJR1cOXssaVHPseoq87YRHDjMYKT1pc8rr4G8mgxEw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICUJiIFKJTrODJA9YJ75Z6c33iTQ7HJ9RbXNcvtR1LauAiEAwjAS9QSzFFQJmRMhOhffasNrxdaNudIOHPZOuik4z/g="}]}},"0.1.3":{"name":"mssql-helper","version":"0.1.3","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"moment":"^2.8.3","mssql":"^1.2.0","winston":"^0.8.1"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"7166becec30ffcda39c970d129985b44f913fdc8","_id":"mssql-helper@0.1.3","scripts":{},"_shasum":"35829673ffdb95ddbbab4d928ed969576149dc34","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"35829673ffdb95ddbbab4d928ed969576149dc34","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.1.3.tgz","integrity":"sha512-FirCucWg74EWAfG7qRl40d1S+l6rejrEIg6H6UzN7p8bp8e+9M+ch/myDZNJ/61ZfK5zFZbNaA3gd64dQzYFhg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDeflAryYTvE3JwY/X6X+UQiYbnt80QRVDPu35lrg6hAgIhALF9VRI6JoDRu1chG8fXK7mMbCmEOu7KhDMr/gS5zyCs"}]}},"0.1.4":{"name":"mssql-helper","version":"0.1.4","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"moment":"^2.8.3","mssql":"^1.2.0","winston":"^0.8.1"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"7166becec30ffcda39c970d129985b44f913fdc8","_id":"mssql-helper@0.1.4","scripts":{},"_shasum":"c963f6494c5acb2cd78c8ecf5acae7dc0b290419","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"c963f6494c5acb2cd78c8ecf5acae7dc0b290419","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.1.4.tgz","integrity":"sha512-oA45r77DyY5hTY2SWLyAQJT1cyRk0aEuh/BQq0u2OGK230z/p5fPoDanO0EG8tqIRM02PO7RnfCN5S6fLoH80w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIH/CRJQb2FE3pHODO3sjA/FY/zvT2WxG4bA1NZQi7VHNAiBba7NC4YJ5r7HKRNfMBNWCCq4ZGj6jTlikh0a64Yc8Hw=="}]}},"0.2.0":{"name":"mssql-helper","version":"0.2.0","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"moment":"^2.8.3","mssql":"^1.2.0","winston":"^0.8.1"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"7166becec30ffcda39c970d129985b44f913fdc8","_id":"mssql-helper@0.2.0","scripts":{},"_shasum":"29d3b070211df814a2ab73431ce41d416caf5b35","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"29d3b070211df814a2ab73431ce41d416caf5b35","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.2.0.tgz","integrity":"sha512-vAH3iHf62pNnuDGGIdr4+EmBOxNKhQhcqZyRPLU4mdBTugtjG2dQelkzwCQeLf/UIRaNMpSzPVniLw2WH9Rhew==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICfrnAmeR1dQlcjsl03GhHb5Z3W7E8umGe9EC+H9/4gsAiEAmOziNWxKLgRtU6dmWbYrOH2KrbQ5a2ysz/qUJ5HZkBk="}]}},"0.2.1":{"name":"mssql-helper","version":"0.2.1","description":"data access layer for mssql that allows connection reuse per request or context, syncronization of commands","author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"main":"db.js","repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"licenses":[{"type":"MIT","url":"http://opensource.org/licenses/mit-license.php"}],"engines":{"node":">=0.6"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"dependencies":{"moment":"^2.8.3","mssql":"^1.2.0","winston":"^0.8.1"},"devDependencies":{"chai":"^1.9.2","mocha":"^1.21.4"},"gitHead":"5bcfb7efc9946597f1b040f7039d1f6203de8390","_id":"mssql-helper@0.2.1","scripts":{},"_shasum":"c3ed493c56fe817539306ad14fcbb99d0fa461c5","_from":".","_npmVersion":"2.5.1","_nodeVersion":"0.10.30","_npmUser":{"name":"mellibo","email":"mellibo@arsoft.com.ar"},"maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"dist":{"shasum":"c3ed493c56fe817539306ad14fcbb99d0fa461c5","tarball":"https://registry.npmjs.org/mssql-helper/-/mssql-helper-0.2.1.tgz","integrity":"sha512-P9YXPFN67N5nLIKSXeWw48dOS/otHIQ1ZsInJKZbmzebzAkCoxuC3J0kYo2lQLuGGKUqln50atqr0X6pn4fiYQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBE7waGVj73o7cRG7s+HTNUX2HdgwrbRNNoCT0Fdj9U3AiBPu9t+iqFPrUFmWXCOIrHfhL1vijblgIVkv7sdTQzsGA=="}]}}},"readme":"# mssql-helper\r\n\r\nMicrosoft Sql Server helper that support transactions per request, query queueing.\r\n\r\nFor use with Node.js and mssql: https://github.com/patriksimek/node-mssql\r\n\r\n## Background\r\n\r\nimplement a simple layer for mssql supporting queueing commands per request (or per object used as context)\r\n\r\n## Install\r\n\r\n`npm install mssql-helper`\r\n\r\n## Usage\r\n\r\n```javascript\r\nvar db = require('mssql-helper');\r\n\r\nvar dbConfig={};\r\ndbConfig.user= 'test';\r\ndbConfig.password= 'test';\r\ndbConfig.server= 'localhost';\r\ndbConfig.database = 'test';\r\n\r\nvar context = req; // the request obect or any object that you want to use to share a connection and syncronice commands. \r\ncontext.dbConfig = dbConfig;\r\ndb.executeQuery(context, 'SELECT TOP 1 * FROM test WHERE id = @id', [{name: 'id', value : '1'}], function (err, recordset) {\r\n  console.log(recordset[0].id);\r\n  console.log(recordset[0].test);\r\n});\r\n\r\n```\r\n### Transaction\r\n\r\n\tvar contexto = {}; //can be the request object\r\n\tcontexto.dbConfig = {user: 'test', password:'test', server: 'localhost', database: 'test'}\r\n\tdb.beginTran(contexto,function(err){\r\n\t\tconsole.log('BEGIN TRAN');\r\n\t});\r\n\tdb.executeQuery(contexto, \"WAITFOR DELAY '00:00:01'; insert into Table VALUES(1, 'text 1')\", function(err, recordset){\r\n\t\tconsole.log('first INSERT');\r\n\t});\r\n\tdb.executeQuery(contexto, \"insert into Table VALUES(2, 'text 2')\", function(err, recordset){\r\n\t\tconsole.log('second INSERT');\r\n\t});\r\n\tdb.commitTran(contexto, function(err){\r\n\t\tconsole.log('commit');\r\n\t});\r\n## How it works\r\n\r\n\r\n## API\r\n\r\n### client.executeQuery(context, sql, [params, callback])\r\n\r\npush the command into a queue made in context object and run it. The context param can be the request to use a connection (or transaction) per request. If there is no active connection in the context, a connection is created.\r\n\r\n### client.run(cn, sql, [params, callback])\r\n\r\nexecute a command without queuing.\r\n\r\n### client.isInTransaction(context)\r\n\r\nreturn true if it is in transaction.\r\n\r\n### client.beginTran(context, [callback])\r\n\r\nbegin a transaction.\r\n\r\n### client.commitTran(context, [callback])\r\n\r\ncommit a transaction.\r\n\r\n### client.rollbackTran(context, [callback])\r\n\r\nrollback a transaction.\r\n","maintainers":[{"name":"mellibo","email":"mellibo@arsoft.com.ar"}],"time":{"modified":"2022-06-20T12:22:16.518Z","created":"2014-10-06T19:16:20.604Z","0.0.1":"2014-10-06T19:16:20.604Z","0.0.2":"2014-10-06T19:25:58.338Z","0.0.3":"2014-10-08T15:11:49.643Z","0.0.4":"2014-10-08T15:12:52.475Z","0.0.5":"2014-10-08T15:13:57.942Z","0.0.6":"2014-10-10T13:42:25.640Z","0.0.7":"2014-10-14T14:14:31.879Z","0.1.0":"2014-10-17T12:07:58.006Z","0.1.1":"2014-10-18T11:32:56.176Z","0.1.2":"2014-10-24T14:20:49.543Z","0.1.3":"2014-10-24T15:20:34.737Z","0.1.4":"2014-10-24T15:21:55.016Z","0.2.0":"2014-10-28T18:56:35.417Z","0.2.1":"2015-10-09T14:53:37.067Z"},"homepage":"https://github.com/mellibo/mssql-helper","keywords":["mssql","helper","dal","sql server","ms sql","transaction","data access layer"],"repository":{"type":"git","url":"https://github.com/mellibo/mssql-helper"},"author":{"name":"Marcos Mellibovsky","email":"mellibo@arsoft.com.ar"},"bugs":{"url":"https://github.com/mellibo/mssql-helper/issues"},"readmeFilename":"readme.md","users":{"chaowei":true,"natarajanmca11":true}}