{"_id":"@botbuildercommunity/storage-mssql","_rev":"4-fca196a705d4bf2bef089e7cf106e4ce","name":"@botbuildercommunity/storage-mssql","dist-tags":{"latest":"1.0.1"},"versions":{"1.0.0":{"name":"@botbuildercommunity/storage-mssql","version":"1.0.0","description":"Microsoft SQL Server storage option for the Microsoft Bot Framework","keywords":["botbuilder","bots","chatbots","mssql","microsoft sql server","storage"],"contributors":[{"name":"Bot Builder Community"}],"license":"MIT","bugs":{"url":"https://github.com/BotBuilderCommunity/botbuilder-community-js/issues"},"repository":{"type":"git","url":"git+https://github.com/BotBuilderCommunity/botbuilder-community-js.git"},"scripts":{"build":"tsc","test":"mocha"},"main":"./lib/index.js","typings":"./lib/index.d.ts","dependencies":{"botbuilder":"^4.5.3","botbuilder-core":"^4.5.3","mssql":"^5.1.0"},"devDependencies":{"@types/mssql":"^4.3.0","@types/node":"^7.10.6","mocha":"^6.2.0","rewire":"^4.0.1","typescript":"^3.5.2"},"publishConfig":{"access":"public"},"homepage":"https://github.com/BotBuilderCommunity/botbuilder-community-js#readme","_id":"@botbuildercommunity/storage-mssql@1.0.0","_nodeVersion":"10.16.1","_npmVersion":"6.11.3","dist":{"integrity":"sha512-YPQ+WYZYnOfSuuMcpWLyYO0ZbIqpyvTtPrRyLIwIss1IJtN+UObmmI8li1t+l+GTTpl22BLl7sDCJ6KHUWBl4A==","shasum":"9967afa8ff837d3e4bb7a79e97cfe3b45eed8494","tarball":"https://registry.npmjs.org/@botbuildercommunity/storage-mssql/-/storage-mssql-1.0.0.tgz","fileCount":17,"unpackedSize":17221,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdnhyYCRA9TVsSAnZWagAAThUP/RU8R/yHH1Xsb849HXS9\nzO/Jl96CwPHDh6viouJcMFK5pDLKSl3ntPlk74+3DMDiKCpCuS7Ha/gGPS2W\nlabMRRiEZPcEsAB42OahwroQFqHpjb84U5hLNrdfK7ZKwjOjqrVnzbphqLVo\nHsbdXShaeUL7h7TLigFVKJzCd+VlrHgut9g1XDUvT+5EUtX/rNVXJjwtxV+L\nt7ImtcJeDOS5JHZKd3YGhB0aV1rnEDDCQiExJeqINOqM1Lm7zh/k/aQdwX0u\nYK45HvqKUINYGBAhSar7sPlclmfP1WRUMUSXQQ51eOnmVAmWbIR9+PUzk2Tw\nxZ7GFEwEtgdBbqf2Nq1vpNJLIw3UDPB7ys8Ub2q4Yt2YU4rniCw9yA3e/6ag\nfZ93dnM9s7iMeBPR+6HhtRBx/sFvl4nD18wcIPB1AYjjORXEfqX5t5PLbcJA\nvNHtsABW9pUwUE0bRX+sPNlNOgpVr3UEhddaC+uSUDCV9s6VoxLJJ1r64HdO\n7jOvyrh68X1L/DK6CEUr5vy5uaBhBrvTTfDOtWaeOmFOWzweJfHiwt9jinaz\nbuiBDVAmYa9kTYeTM5C9z2TbLGam+hzFHJR6H2rb15BJFSx6GlmVhpgZpF8s\nxGKnuq7J41imdlO0SgKFsqEwlP1izBFkjAI1RmlhIMhUSoIjVovNQYZyBnOY\n3llF\r\n=7ExX\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCX7mJ2aePx1oRmrLz1AvpgYZGZMBWW3rhHwWuUPeUf5wIhAKUtSiULhV65Q4wucqU3z1xvwaiBAr/FcG4JsdZCchTT"}]},"maintainers":[{"name":"cloudguy_pro","email":"stephan@bisser.at"},{"name":"szul","email":"michael@szul.us"},{"name":"jamesemann","email":"james.mann@bcs.org"}],"_npmUser":{"name":"szul","email":"michael@szul.us"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/storage-mssql_1.0.0_1570643095852_0.35903078663509636"},"_hasShrinkwrap":false},"1.0.1":{"name":"@botbuildercommunity/storage-mssql","version":"1.0.1","description":"Microsoft SQL Server storage option for the Microsoft Bot Framework","keywords":["botbuilder","bots","chatbots","mssql","microsoft sql server","storage"],"contributors":[{"name":"Bot Builder Community"}],"license":"MIT","bugs":{"url":"https://github.com/BotBuilderCommunity/botbuilder-community-js/issues"},"repository":{"type":"git","url":"git+https://github.com/BotBuilderCommunity/botbuilder-community-js.git"},"nyc":{"extends":"@istanbuljs/nyc-config-typescript","all":true,"check-coverage":true,"lines":0,"statements":0,"functions":0,"branches":0,"exclude":["**/*.d.ts","**/*.test.js"],"reporter":["text","cobertura","html"],"report-dir":"./.nyc_output/coverage"},"scripts":{"build":"tsc","test":"tsc && nyc mocha","test-ci":"tsc && nyc mocha --reporter xunit --reporter-options output=./test-results.xml --reporter-options suiteName=$npm_package_name"},"main":"./lib/index.js","typings":"./lib/index.d.ts","dependencies":{"botbuilder":"^4.8.0","botbuilder-core":"^4.8.0","mssql":"^5.1.0"},"devDependencies":{"@istanbuljs/nyc-config-typescript":"^0.1.3","@types/mssql":"^4.3.0","@types/node":"^7.10.6","mocha":"^7.1.1","nyc":"^15.0.0","rewire":"^5.0.0","typescript":"^3.5.2"},"publishConfig":{"access":"public"},"gitHead":"1066f5f7752f3298e575aa495afa4592d5f54a44","homepage":"https://github.com/BotBuilderCommunity/botbuilder-community-js#readme","_id":"@botbuildercommunity/storage-mssql@1.0.1","_nodeVersion":"12.14.0","_npmVersion":"lerna/3.20.2/node@v12.14.0+x64 (darwin)","dist":{"integrity":"sha512-tbnTyjdw3GyAPwnuFv9GWypiNoglrPXHlLA20sV4LRijXhDGDSCIVfBQQza22AhGN48ktY52eYFfFYiAMLSUcg==","shasum":"dcbca504cd342a98d5d060f4c80a5cb5510ba29e","tarball":"https://registry.npmjs.org/@botbuildercommunity/storage-mssql/-/storage-mssql-1.0.1.tgz","fileCount":33,"unpackedSize":111489,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJefMsbCRA9TVsSAnZWagAAvmgP+wWJ1vSQI/1qtmBJxiYE\n1aw7sfpjZHiMq6dfILpG3Kx0YZNSKvZPYADnlQooJKOlyf5zCgQFIxLmsH+i\nAkqXeozzZS6J85vAfBZ9R5XQwyn1UBlOfcjNgmcUVKQCouetF17YPGsBsPQX\n50dRxlNLwCJkdxXtwNUexnNqHE31ZdKyQXHHSOYQuRUaUd+46Dcr7Xa23DaE\nsBr3wfkT4gNIvqsLMuXMu6TmVKNP0gSTew2rL+xSxkuNkGfUwzgxkifKtz58\nrEFPyuhXi/t/vBePdF7kEkdian/VDHYv/gXTGlJblJqPPD1hKylfWyVbbkwC\n2klGqPqfcuXcWOT4jwLE1vdVgfOjH3WYMF2rQUwEBLNHUv5Vshbj7na79KG5\nreae3rGFWJ22GgKA5o6qfHPm+1GlbsK4O1HEB5vZc/y6WBcjgWQ1Y9yknoVa\nf74zI2z/TfZCwWRfIM6NIZmgLgPiMij4aiFVMDFR9I9VlTTjzeIM5NcM+4u8\npPhHDm1RdompKkTc8/+rqjpsmWOB8ODCAFipI77WvGVJ13uAutcUQwl26hxL\nlvySTsYNEib4SCPA3GdYMvJtH+EQoM1E0Fw2eykBI2VqMsPkPzRhiOUCJZpe\nv4uSy7f8YxO8T6VjmcEXDiVZAFQgyolGptmWN1QWo35lg0NXZLfrSR3LI5va\nFCbh\r\n=u/xm\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD51tmsPLaSjBR382tXZNQ/ijsBJELVhQCs++oIAt5gqwIhAPOlE1VAQINv9Jt2aGeIrzUgOETAqkiQeddvy8JSFZ0o"}]},"maintainers":[{"email":"stephan@bisser.at","name":"cloudguy_pro"},{"email":"mick@imick.nl","name":"imick"},{"email":"james.mann@bcs.org","name":"jamesemann"},{"email":"michael@szul.us","name":"szul"}],"_npmUser":{"name":"imick","email":"mick@imick.nl"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/storage-mssql_1.0.1_1585236762706_0.23491922461375658"},"_hasShrinkwrap":false}},"time":{"created":"2019-10-09T17:44:55.766Z","1.0.0":"2019-10-09T17:44:55.974Z","modified":"2022-04-04T20:13:44.672Z","1.0.1":"2020-03-26T15:32:42.871Z"},"maintainers":[{"email":"james.mann@bcs.org","name":"jamesemann"},{"email":"stephan@bisser.at","name":"cloudguy_pro"},{"email":"mick@imick.nl","name":"imick"}],"description":"Microsoft SQL Server storage option for the Microsoft Bot Framework","homepage":"https://github.com/BotBuilderCommunity/botbuilder-community-js#readme","keywords":["botbuilder","bots","chatbots","mssql","microsoft sql server","storage"],"repository":{"type":"git","url":"git+https://github.com/BotBuilderCommunity/botbuilder-community-js.git"},"contributors":[{"name":"Bot Builder Community"}],"bugs":{"url":"https://github.com/BotBuilderCommunity/botbuilder-community-js/issues"},"license":"MIT","readme":"# Bot Builder Microsoft SQL Server Storage\n\nThis is a simple storage adapter for Microsoft SQL Server.\n\n## Installation\n\n```powershell\nnpm install @botbuildercommunity/storage-mssql --save\n```\n\n## Usage\n\n```typescript\nimport { MSSQLStorage } from '@botbuildercommunity/storage-mssql';\n\nconst storage = new MSSQLStorage({ \n user: ,\n password: ,\n server: ,\n database: ,\n table: \n});\n\nconst conversationState = new ConversationState(storage);\nconst userState = new UserState(storage);\n```\n\n> This module uses the [node-mssql](https://www.npmjs.com/package/mssql) package for SQL connectivity. The `MSSQLOptions` that is passed to the `MSSQLStorage` object extends the `config` object of that package. All options from that `config` option can be passed in.\n\n> This module assumes two string-based columns in your database table: `id` and `data`.\n","readmeFilename":"README.md"}