{"_id":"@ac-moore-inc/mssql-wrapper","_rev":"10-17902f38e32fe3ae84aff8c8c2fb5452","name":"@ac-moore-inc/mssql-wrapper","dist-tags":{"latest":"1.0.4"},"versions":{"1.0.0":{"name":"@ac-moore-inc/mssql-wrapper","version":"1.0.0","description":"An easy to use mssql wrapper.","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"repository":{"type":"git","url":"git+https://github.com/ACMooreInc/mssql-wrapper.git"},"author":{"name":"A.C. Moore"},"license":"MIT","bugs":{"url":"https://github.com/ACMooreInc/mssql-wrapper/issues"},"dependencies":{"async":"^2.6.0","mssql":"^4.1.0"},"gitHead":"3c094b2f386fbeb60e0b3c84532b4551d0d81885","homepage":"https://github.com/ACMooreInc/mssql-wrapper#readme","_id":"@ac-moore-inc/mssql-wrapper@1.0.0","_shasum":"24528a444970c5a51e0761740d0eb77a0945ae9b","_from":".","_npmVersion":"3.10.8","_nodeVersion":"6.8.1","_npmUser":{"name":"bclipper","email":"rclipper@acmoore.com"},"dist":{"shasum":"24528a444970c5a51e0761740d0eb77a0945ae9b","tarball":"https://registry.npmjs.org/@ac-moore-inc/mssql-wrapper/-/mssql-wrapper-1.0.0.tgz","fileCount":4,"unpackedSize":9656,"integrity":"sha512-EdtDouGIOLt+4kvheYWd2/zeB+oGRCbiGznMTLH17PaiNg7yoawEdjhGyeV/Km0YP7fm82iktsEyD8IEanE5jw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICD6ybvJt9Km+Mgn53zzxsgCvkLYpl3rVcfvFg3pDv9iAiEAgpLOv4Jv3PDXiyG4TN8FHwmYf/aj+sN41PObPhgbmUo="}]},"maintainers":[{"name":"acmoore","email":"softwareengineering@acmoore.com"},{"name":"bclipper","email":"rclipper@acmoore.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/mssql-wrapper_1.0.0_1522764493063_0.1775681312316919"},"_hasShrinkwrap":false},"1.0.1":{"name":"@ac-moore-inc/mssql-wrapper","version":"1.0.1","description":"An easy to use mssql wrapper.","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"repository":{"type":"git","url":"git+https://github.com/ACMooreInc/mssql-wrapper.git"},"author":{"name":"A.C. Moore"},"license":"MIT","bugs":{"url":"https://github.com/ACMooreInc/mssql-wrapper/issues"},"dependencies":{"async":"^2.6.0","mssql":"^4.1.0"},"gitHead":"3c094b2f386fbeb60e0b3c84532b4551d0d81885","homepage":"https://github.com/ACMooreInc/mssql-wrapper#readme","_id":"@ac-moore-inc/mssql-wrapper@1.0.1","_shasum":"3949fa2a36124f8611ad2da103d5f97400671947","_from":".","_npmVersion":"3.10.8","_nodeVersion":"6.9.0","_npmUser":{"name":"bclipper","email":"rclipper@acmoore.com"},"dist":{"shasum":"3949fa2a36124f8611ad2da103d5f97400671947","tarball":"https://registry.npmjs.org/@ac-moore-inc/mssql-wrapper/-/mssql-wrapper-1.0.1.tgz","integrity":"sha512-L2wjH7qrq3u6yHEfdMgMeLA5yCYkXUDoFDLyMF6Q5O2pDrbVEYK30MbUPQaC/HfxTwsBRT4RwXOZ6kxpTLIQlA==","fileCount":4,"unpackedSize":9656,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJbbY46CRA9TVsSAnZWagAAspAP/0UxBRNyHuNTkKYbCSEV\nQQwqmV/lpexI/IGxpb4kV2Qiiu4ANmRmesScTqUkKl5IJxfRVfJXzjLQfaXZ\nwbcJHVKTZedlLldNsLBHTObH0w6X08gs++phpRuxA2F1+RsjcCF0nwJe9FZ5\nHnnugdib5//gVm/FwN5P7EokbkzTbbo0qfE85RS1XksxXIFEa2yt21NxLJ5s\n6Zbtcqsa0MyQ0AcZFH7sMAOOHd1XBLSrNrEw+bdeBQe83N+DLvl8u/GiiTn3\nqrX/ji2juSJB6RrHoIpcEx7jpBB3UQnMffH9x7MCcG70qa6l4cab2XEpoN7V\nWAWlmtgpHYP+v5oI41R11qCwvWEEL6Jc4Slv6Tj3/kgZxXX9Gl3OuzlL5jvO\nQZ3Vud5FeFT9D+hZ4W6HtlY6qXd5QipbTAmpAS2tEqWpwzN1xHQky1/3wVCA\nUH0BsBG+VHQxK+Djw7hVJSlVmWAPMshvm9IvTk/8wWh6296nL04DR6XSmPlu\nTbhZcxwsvAEsydmoY/TKRNxOisNqD/TqjM6cOq4UC8KXvq1y0PETXP0i3zib\n51VgUjJ+ZOewMaoByJb4BhBS8LYMRhJoSO0gXnN3expUM+oCSLx9pi3hHMhj\nutM+NckilMOnSWh4//Vzmt9EV3ArCbgQTZ4wfF+bXjq9X0SreE+ZfVcuTEJs\n311b\r\n=/2sG\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIDoYexd8ZfJIqtnjra6MNp79LHHmLf1As8wHQ9xUJ4rWAiEAicNUkNxXsJFOTogJrI9pG0ifjzw1RBsP1YrYtP2Rkl8="}]},"maintainers":[{"name":"acmoore","email":"softwareengineering@acmoore.com"},{"name":"bclipper","email":"rclipper@acmoore.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/mssql-wrapper_1.0.1_1533906489827_0.09499569274420772"},"_hasShrinkwrap":false},"1.0.2":{"name":"@ac-moore-inc/mssql-wrapper","version":"1.0.2","description":"An easy to use mssql wrapper.","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"repository":{"type":"git","url":"git+https://github.com/ACMooreInc/mssql-wrapper.git"},"author":{"name":"A.C. Moore"},"license":"MIT","bugs":{"url":"https://github.com/ACMooreInc/mssql-wrapper/issues"},"dependencies":{"async":"^2.6.0","mssql":"^4.1.0"},"gitHead":"cdce05c39e61aa5175ac3c45ac2772698cb853fb","homepage":"https://github.com/ACMooreInc/mssql-wrapper#readme","_id":"@ac-moore-inc/mssql-wrapper@1.0.2","_shasum":"cdd235374cea8c764a13faa64a59ebb66e20f197","_from":".","_npmVersion":"3.10.8","_nodeVersion":"6.9.0","_npmUser":{"name":"bclipper","email":"rclipper@acmoore.com"},"dist":{"shasum":"cdd235374cea8c764a13faa64a59ebb66e20f197","tarball":"https://registry.npmjs.org/@ac-moore-inc/mssql-wrapper/-/mssql-wrapper-1.0.2.tgz","integrity":"sha512-fbwIrG02VAkGvnI8ybSwoGve+OH/zoYLMI/nfyppGXCf+wwcVYk6RcLMFEZ6tGG19Bob1C9BQ4CuMgSbvmmRtw==","fileCount":4,"unpackedSize":9705,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJbbZNjCRA9TVsSAnZWagAAMUUP/04jArsfaYsXQtpmhZ2m\n0nxdFwaOWRQvdsLR9y74yjcK2EEEC5qkdDVOmWv+Tj07n66tO9F9GNHpZ1Pm\nIFdRJ57952Pb6YPdvey54ur6vxTs43rcF9ajLThXkQBYzO7QI7HNYKEWX9t4\nyeFFdfDUQLEjfXe9Nalt2GNIAdno75lZqCeIHWEJDKUEewZhJkcwGaymKN04\ncHvFiJ7bt3b+eQSo/1t3Cy98ExO7HfPdOG8PCOQLR+xBbkYtdTisgbGA9c5E\nO9ol1q9rC9S1j+o6xT+RKq8RPR/FRNbfxz+bOm3hTPSMRJTWaORJy58eX2dJ\n5Kp1EpyK/ESWht8kNvIPOIFAJqZEYhV9Xdy08icI37212Lqj498mmhZdnou5\nUK6JeUAOkJdAVtG+80XTSQF9Es2pitp7NdQE+7mXKpvTgDunD1u6HFEM1nF6\nItRoTSE/VtQVrGGnj00jSdFQn15Z3IUJh5+Tf4HEDHTlTnAoLXJ4gUtBx21t\nqzXCCX8GS+XznH/2D/cBJdsPXBlBmd8UNscjTogT3Foa9usmQks1nDON1anp\n0lMGwoaScaysDPvfThPqR23APbCTJPdqePpsgfudgQUJVPgTb1cbemNYjB6B\n0lYLZGTm1U6TShNop7LDTR6S+WVb7W4z/ORu0vQVgTOzihMtYyPErpoejEd6\ngHqg\r\n=iRSp\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIGXI5KL33TIob6i5mufII/NGYgz0IUUYZLaoA7RPP3ZLAiBey52XArr7if+aANbBA/bTnfbLQ3IN1zisIi0/OHjZKQ=="}]},"maintainers":[{"name":"acmoore","email":"softwareengineering@acmoore.com"},{"name":"bclipper","email":"rclipper@acmoore.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/mssql-wrapper_1.0.2_1533907811139_0.12040574138965265"},"_hasShrinkwrap":false},"1.0.3":{"name":"@ac-moore-inc/mssql-wrapper","version":"1.0.3","description":"An easy to use mssql wrapper.","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"repository":{"type":"git","url":"git+https://github.com/ACMooreInc/mssql-wrapper.git"},"author":{"name":"A.C. Moore"},"license":"MIT","bugs":{"url":"https://github.com/ACMooreInc/mssql-wrapper/issues"},"dependencies":{"async":"^2.6.0","mssql":"^4.1.0"},"gitHead":"6ea4dd97992aad1107407c999663e94bbc0cef41","homepage":"https://github.com/ACMooreInc/mssql-wrapper#readme","_id":"@ac-moore-inc/mssql-wrapper@1.0.3","_shasum":"57252aa81f9b9d4258985f882eff7bc5a8c7b6be","_from":".","_npmVersion":"3.10.10","_nodeVersion":"6.9.4","_npmUser":{"name":"gpatel","email":"gpatel@acmoore.com"},"dist":{"shasum":"57252aa81f9b9d4258985f882eff7bc5a8c7b6be","tarball":"https://registry.npmjs.org/@ac-moore-inc/mssql-wrapper/-/mssql-wrapper-1.0.3.tgz","integrity":"sha512-3UcYnA+rYQT8OjkGgsxg5LtaQsBg/artQGr/PlabcsU4z6EdSYU22AiJCUNUrrg/On2Q8Axa4cDNBVHdCHXJCw==","fileCount":4,"unpackedSize":9474,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJbzjmKCRA9TVsSAnZWagAA1xMP/2Sly+/B8DRoYnREucfK\nJPSIntp6m0BUzbACuOtIWhApQ938mdLHpC16Wzm5YQfO3BrXggVhqcY67S4g\nXyEeNRO4bF22F8JSTL2IJAfnz4VaDFXkTadk7zpob5ToFkG+sOb/syKXx/MT\nFIxz7f7s5s3C4p5fDhmnAPrYY1nPK0IBBxVoptD3v1YjOS+MybB/CrnEyTFO\niWSzK6xhBye1fHOF9bhLdQ4k/qH6dEHbJTpvteQiiZ5gdVPfRTpEoDF6RrtE\n7TqqNnW/kOIKo/oxAc710LI+WOZhpEUFDBNI1qzcXNMRGNSikryjBhpW1fMD\nIueli979+FQ7tRnoD9Af6O+wY3aTYfzra6x6MfAbFFAmQMLorL1OgQ878ms4\nVOxBZRC5yM6kJWfoLMYBSOmb9M7NWwTnuygsIt8PQZFBBol2W5GMAbU1ZLgt\nJ6cMkMk1AfZoRjjocRx3dgJ8Us4WB6YnHtvSqZdkkgWzLT7ScA94KKRpqae2\nyksdRE10scCAdEhQy9CczTVbB7a4us1BLKxmoWu4D5UUOC8zrJjps2U/0qsM\nqV1aPFHqJwWkZQCs5j7wbE1+K56Qyj2WdJuPKawEB7TVMfu5RJvaXcg/dH9G\nIiKOkHYwaYMPj9GoUT7SthhtB9Uw863bMz+2o8QVfd48+lDirNk78qLt2LU/\nAQRc\r\n=sGgS\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCvI3C3gRI548VpAFY0FMwVmFBp3kDigub2Z49pksXmLQIgah//JSyMjMhLhR0TJvqDGqGZBOi7/CtgwicKSP2IMdo="}]},"maintainers":[{"email":"softwareengineering@acmoore.com","name":"acmoore"},{"email":"ari@acmoore.com","name":"ari-acm"},{"email":"rclipper@acmoore.com","name":"bclipper"},{"email":"gpatel@acmoore.com","name":"gpatel"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/mssql-wrapper_1.0.3_1540241801515_0.3713881715774874"},"_hasShrinkwrap":false},"1.0.4":{"name":"@ac-moore-inc/mssql-wrapper","version":"1.0.4","description":"An easy to use mssql wrapper.","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"repository":{"type":"git","url":"git+https://github.com/ACMooreInc/mssql-wrapper.git"},"author":{"name":"A.C. Moore"},"license":"MIT","bugs":{"url":"https://github.com/ACMooreInc/mssql-wrapper/issues"},"dependencies":{"async":"^2.6.0","mssql":"^4.1.0"},"gitHead":"6ea4dd97992aad1107407c999663e94bbc0cef41","homepage":"https://github.com/ACMooreInc/mssql-wrapper#readme","_id":"@ac-moore-inc/mssql-wrapper@1.0.4","_shasum":"a3bafedbbaa7f6794bb7da2bf3534ff0ce329bab","_from":".","_npmVersion":"3.10.10","_nodeVersion":"6.9.4","_npmUser":{"name":"gpatel","email":"gpatel@acmoore.com"},"dist":{"shasum":"a3bafedbbaa7f6794bb7da2bf3534ff0ce329bab","tarball":"https://registry.npmjs.org/@ac-moore-inc/mssql-wrapper/-/mssql-wrapper-1.0.4.tgz","integrity":"sha512-TDNHjpbSDz+GBcDAu9deTvdfTL+RPz0iLVqwAWlgbVd//6ma7dCyAKk4RjJNWSK7whsSLJQ7xysY9NcMHhuJrw==","fileCount":4,"unpackedSize":9316,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJb0P6aCRA9TVsSAnZWagAAnk0P/0y4YZBTqvvEd7uJpiX6\noTsQj3sTNY05gwmCi0JiHKBn2X3F5CaDl/zit33TH2xwzUYRmAgMzyPjpG8W\n1tMW8BuGYG6o4Yqq2Cp+1cTEz1S4ZfIlYrIh4Mu6HWOpqm/gvTHjmpGOBW3G\nOXyMd1etIez4jJXNMmyeMwdoYNXIsufuBqaAieZDwt40B5SYqywDpGFplFac\n+OKTOwQnpGLrR0OnXYg4L1Lu9SVkaH5trtudg+UVRKpXKx71f0adDwwqneTA\nAoZMvv6r452mqI2MLAMIXviRIUo1K/t0ZvBtiMd0q7HNzCCtImjeJEPy7oOH\n6s+8+/DBcDoVxPn104AK4Os3jG4wclhRjW0C9Sy3/gsmWP381yPY/Nh4TT5l\n16PyVOZbIA5RDpats31v1w1xJviGZhw6xUIIvUUpyYnsqqMcNhuinxnq6w4U\ngLpPSVOXDmQoqiitvVAK3Cn3akC93ZFU1HPy1mdjqUdHS/vZwWvbWHV7mFcF\njDMuBn1XvL3AaVFWSbOIUOyj0A3hQaEHPKitHZ/ki1O/ID3LwU9uhdlLf3Fv\nyAKMwwsu/ioLcwXhOQl9GZCiLRlUnduhX+ssEz7t/UvX8r6y/7dA5UBg+0JI\nC5giyPi7JD1x/QCk+rD5+NLMxzm6Nsj8eNEOnmROU82EwZXMDhmz549IDYJ/\nbYqk\r\n=80ra\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIF+O++1oUvMKAZSqgvLcYQBz3pwt0b8ETyjJ9DpRnorxAiAgxriasCyvdhIEoK7K57uInxA3uBh7H2BqvHia6YMe2w=="}]},"maintainers":[{"email":"softwareengineering@acmoore.com","name":"acmoore"},{"email":"ari@acmoore.com","name":"ari-acm"},{"email":"rclipper@acmoore.com","name":"bclipper"},{"email":"gpatel@acmoore.com","name":"gpatel"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/mssql-wrapper_1.0.4_1540423321962_0.01633434373231979"},"_hasShrinkwrap":false}},"time":{"created":"2018-04-03T14:08:12.991Z","1.0.0":"2018-04-03T14:08:13.122Z","modified":"2022-06-12T14:15:36.156Z","1.0.1":"2018-08-10T13:08:09.899Z","1.0.2":"2018-08-10T13:30:11.218Z","1.0.3":"2018-10-22T20:56:41.648Z","1.0.4":"2018-10-24T23:22:02.060Z"},"maintainers":[{"email":"softwareengineering@acmoore.com","name":"acmoore"},{"email":"ari@acmoore.com","name":"ari-acm"},{"email":"rclipper@acmoore.com","name":"bclipper"},{"email":"gpatel@acmoore.com","name":"gpatel"}],"description":"An easy to use mssql wrapper.","homepage":"https://github.com/ACMooreInc/mssql-wrapper#readme","repository":{"type":"git","url":"git+https://github.com/ACMooreInc/mssql-wrapper.git"},"author":{"name":"A.C. Moore"},"bugs":{"url":"https://github.com/ACMooreInc/mssql-wrapper/issues"},"license":"MIT","readme":"# MSSQL Wrapper\r\n\r\nAn easy to use MSSQL wrapper.\r\n\r\nCreated and maintained by the A.C. Moore software engineering team.  \r\n\r\n## Methods\r\n\r\n### prepareService\r\nCreate the connection pools for provided databases\r\n```javascript\r\nprepareService(config, callback);\r\n```\r\n#### Parameters:\r\n##### config: *object*\r\nA configuration object containing information related to the database is required to connect.\r\n###### config Example:\r\n```javascript\r\n{\r\n    databaseName: {\r\n        'user': 'db_user_name',\r\n        'password': 'db_pass',\r\n        'server': 'PATH\\\\TOSERVER'\r\n        'database': 'DATABASE_NAME'\r\n        'pool': {\r\n            'max': 10,\r\n            'min': 4,\r\n            'idleTimeoutMillis': 30000\r\n        }\r\n    },\r\n    other db connections...\r\n}\r\n```\r\n___\r\n\r\n### executePSQuery\r\nExecute prepared statement\r\n```javascript\r\nexecutePSQuery(options, callback);\r\n```\r\n#### Parameters:\r\n##### options: *Object*\r\n\r\n|Field | Type | Required | Value |\r\n| --- | --- |--- | --- |\r\n|db   | string | true | database name as defined in the config object used to prepare the service|\r\n|qrydata | object | true | object containing query fields, from_objects, and where_clause |\r\n|server | string | false | sever location of the database |\r\n|input | array | false | array of objects containing input name and type (as defined by mssql)|\r\n|params | object | false | key value pairs defining any parameters, where key is the given input name and value is the parameter value |\r\n___\r\n\r\n### exeuteSP\r\nExecute a stored procedure\r\n```javascript\r\nexecuteSP(options, callback);\r\n```\r\n#### Parameters:\r\n##### options: *Object*\r\n\r\n|Field | Type | Required | Value |\r\n| --- | --- |--- | --- |\r\n|db   | string | true | database name as defined in the config object used to prepare the service |\r\n|procedure | string | true | procedure name |\r\n|input | array | false | array of objects containing input name, type (as defined by mssql), and value (key: val) |\r\n|output | array | false | array of objects containing output name and type (as defined by mssql) |\r\n\r\n___\r\n\r\n### executeQuery\r\ncall a basic query\r\n```javascript\r\nexecuteQuery(options, callback);\r\n```\r\n#### Parameters:\r\n##### options: *Object*\r\n\r\n|Field | Type | Required | Value |\r\n| --- | --- |--- | --- |\r\n|db   | string | true | database name as defined in the config object used to prepare the service|\r\n|qrydata | array | true | array of objects containing query: fields, from_objects, join_condition, where_clause, group_by, order_by |\r\n|server | string | false | sever location of the database |\r\n|outFormat | array | false | array of objects containing output name and type (as defined by mssql)|\r\n\r\n___\r\n","readmeFilename":"readme.md"}