{"_id":"@autocodingsystems/node-red-contrib-mssql-ps","_rev":"1-f8ea65754be88868b05620e6bdef0b3d","name":"@autocodingsystems/node-red-contrib-mssql-ps","dist-tags":{"latest":"1.0.0"},"versions":{"1.0.0":{"author":{"name":"AutoCoding Systems Ltd"},"name":"@autocodingsystems/node-red-contrib-mssql-ps","version":"1.0.0","description":"Execute MSSQL Prepared Statements from Node-RED. Forked from (https://github.com/atsage/node-red-contrib-mssql-ps)","dependencies":{"mssql":"6.*"},"license":"MIT","keywords":["node-red","MSSQL","Prepared Statement"],"node-red":{"nodes":{"node-red-contrib-acs-mssql-ps":"mssql-ps/mssql-ps.js","mssql-ps-serverconf":"mssql-ps/mssql-ps-serverconf.js"}},"devDependencies":{"jest":"^26.1.0","jest-each":"^26.1.0","node-red":"^1.1.2","node-red-node-test-helper":"^0.2.5","should":"^13.2.3"},"scripts":{"test":"jest --config ./jest.config.json --forceExit"},"gitHead":"3abacea92402d3befa3b8a5d0d1dbe416975b285","_id":"@autocodingsystems/node-red-contrib-mssql-ps@1.0.0","_nodeVersion":"10.22.0","_npmVersion":"6.14.6","dist":{"integrity":"sha512-t1n6Q2ine/Ccxb0H+jidihYMVzlYoeLcrX7qy2VNi8buG+dxPA/Rl8yFGafGM/cV2vPrazD00Vu08zWEZR/GZA==","shasum":"c982dd9687c82f8cd25b374c67ef7ce23802b85f","tarball":"https://registry.npmjs.org/@autocodingsystems/node-red-contrib-mssql-ps/-/node-red-contrib-mssql-ps-1.0.0.tgz","fileCount":7,"unpackedSize":35504,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJfM7CDCRA9TVsSAnZWagAA694P/1S4untpTalA5sbNQRAt\naqQ69rxg5SgyJxQpS2e1QbeE6HeZHJjTxA1uX48xNT+hlVDOJivaahNxbcdT\nkx1WQ1QuYXEfaN4agMdBf9nf94D6xivVg7P+hK8nYttFsH47ihBfwdaYlGv0\nWH/A/31qzrM5+7+6VFF0c1rdpAVqO1TLY7+Qmt8q+XH4+pkCIz5hoRl3JLNB\n90f7fRjzJ1aKEJg3/YQ+2Q8ghPbOLw/rjGw4NdXNR5I9qtcZ2/Q5J8xeOnMO\nrUwO6wN8R99gBFvUHuDFEY9NKKx8M6S23pXubwoMZiFFzhpDoYcZrDAm9OtS\nXmSbaOWlTPIR3dxsp2nZpLele9ozLwc0rd+axgx09qiCWGyri89+ci2rdC7L\n7+WztpGwCXrHpN4HB9Bq+k0kieRgopabuPRqFpaaB3KL93aF9skU6wxC68A7\nHBawNgFhEL1XhPaxHy1073lPi2KBCjYHp8D2JOp9AuDplRdo11gJiIxE1xKp\n/MO6Nw/6diTsdUz+9BiOURAfWyvt9zsxMor3xVTCZ5jv2LPwOP41t7qmHRsr\nNeqlNVqPW0fF5NfvlXTEUhb3pNb8CqHFxM3WcKy5IOIqLD4W7T3vVd6HE+xv\nbSoDarYlFqBnkFJxT5Eq1Vh+7ccR4Feu09maN5GnH9WdRfzhI4lkZtazrDAT\nSQhP\r\n=tp7R\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDsiQ0lAaNo5/JwoH0BcITH612h3UCJeefKl096zOlwagIhALF6HrvTqXiEiz5mwNtyhUdAvLI1VbvuW7iAPl9rO5Cn"}]},"maintainers":[{"name":"autocodingadmin","email":"jimtupper@autocodingsystems.com"}],"_npmUser":{"name":"autocodingadmin","email":"jimtupper@autocodingsystems.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-red-contrib-mssql-ps_1.0.0_1597223042822_0.24584608318662138"},"_hasShrinkwrap":false}},"time":{"created":"2020-08-12T09:04:02.737Z","1.0.0":"2020-08-12T09:04:02.966Z","modified":"2022-04-04T16:35:52.004Z"},"maintainers":[{"name":"autocodingadmin","email":"jimtupper@autocodingsystems.com"}],"description":"Execute MSSQL Prepared Statements from Node-RED. Forked from (https://github.com/atsage/node-red-contrib-mssql-ps)","keywords":["node-red","MSSQL","Prepared Statement"],"author":{"name":"AutoCoding Systems Ltd"},"license":"MIT","readme":"This node was created to execute prepared statements from Node-RED using the node.js node mssql. Pass in the parameters for the prepared statement as an object in `msg.params` Ex:\r\n```\r\nmsg.params = {\r\n    id:1,\r\n    name:\"John Doe\"\r\n}\r\n```\r\nParameter object names must match parameters set up in the Prepared Statement and can be any string. Depending on the parameter type selected there may be options required. In the SQL Statement reference parameters by using @(parameter name) Ex:\r\n```\r\nSELECT *\r\nFROM users\r\nWHERE userid = @id OR name = @name;\r\n```\r\n\r\nThis node was forked from https://github.com/atsage/node-red-contrib-mssql-ps to add behaviour \r\n","readmeFilename":"README.md"}