{"_id":"@ais_automation/node-red-contrib-odbc","_rev":"2-6b933168cb5b44933b95ad5bc326f703","name":"@ais_automation/node-red-contrib-odbc","dist-tags":{"latest":"2.0.0"},"versions":{"1.0.4":{"name":"@ais_automation/node-red-contrib-odbc","version":"1.0.4","description":"Node for node-red to unixODBC and its supported drivers. (MS SQL, PostgreSQL, ...)","main":"odbc.js","dependencies":{"odbc":"github:AISAutomation/node-odbc","mustache":"latest"},"node-red":{"nodes":{"odbc":"odbc.js"}},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"repository":{"type":"git","url":"git+https://github.com/AISAutomation/node-red-contrib-odbc.git"},"keywords":["node-red","odbc","unixodbc","mssql","mysql","sql","PostgreSQL"],"author":{"name":"efa2000"},"license":"ISC","bugs":{"url":"https://github.com/AISAutomation/node-red-contrib-odbc/issues"},"homepage":"https://github.com/AISAutomation/node-red-contrib-odbc","gitHead":"d28c2983ab5533f73886a769970987c39a4fe58a","_id":"@ais_automation/node-red-contrib-odbc@1.0.4","_nodeVersion":"12.13.0","_npmVersion":"6.12.0","dist":{"integrity":"sha512-qyx+S8zA6w3ASWoHCQoLKwpAleBbAv7Ia+Z5AUD48Ba819i5WCpF5oWrqVO9Dlqgw8lhkQSPNiQosQZGARGEqA==","shasum":"d079e5514039b5c26ca002cf84d2ab6e4e295a03","tarball":"https://registry.npmjs.org/@ais_automation/node-red-contrib-odbc/-/node-red-contrib-odbc-1.0.4.tgz","fileCount":7,"unpackedSize":47152,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJduDQLCRA9TVsSAnZWagAA66oP/jtMnfJsFPMAI2+EtUMJ\niJ6f/7ePPXLjMa7h6W++w1iagdjgz8Y1anPRMcuKBDtVJja1nSbjg/9mIV7Z\noGCK5iUAp9TjEJf58lFW9syhmIKQM5ZSwiIDXq6HIVNFYXk85JQsZf0JF5kk\nuNNk5d1gE1I2y4JxsTpe2f2VCWHSCTzuypsm6kCKUI2RIfCUvgAahGzCD2pT\nQFTfeidNuOywNYZ/F42rCFx6h7mexroiGMwuVmpRsrSAoSZLh+uS7un0wtK4\nf5YPBJG+j8VpOUlkhmDKRS/isWg9oO7V5gATZSHaoFcXhHupYvjpOE6lwrWH\nqkMJqU5DMKQNZnVOkchWT/8WeP7pYx+Q703vcF9FlyEp6S/c92aHNJ2aPbYn\nDDSEyKQG82i6Lo4NWW2/3jo664cPCUpDdWqXWMecKk5APWNcvbBLEkvqcXXm\nHKI2s6koky30WkvMbUGIa0Vn5YMNf13LTfe1r61t39dRYq7L8WNNFhMBRvCq\n0wZsLKMDDyoV2AZOGTAwpw43XgRASPz8mam2FHnvRcp+68HKersYLw11a+pI\nWTUERSvaNUpuXs8HYccE+hks2siBOlQk20Aw0sK7srIYD2byK95kkHtFLOzy\nWivVPu8kQGeCpO2gU61iHTFtrKCihf4p7MhUgaiPoXq8+T5Qp7z+Sfiuxwc7\nnjzt\r\n=Wk91\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCENxcOTX9nYwzm5RLrkOVwC44522arfHbPLVL/EwARjQIgOYGiInZkB5VSUY4qQhi7pMKf7EqgvvJrRLNqOhYXeDU="}]},"maintainers":[{"name":"mcrange","email":"matthias.range@ais-automation.com"},{"name":"dirkzp","email":"info@weri-design.de"},{"name":"stephan-wolf-ais","email":"stephan.wolf@ais-automation.com"},{"name":"aisautomation","email":"dirk.richter@ais-automation.com"}],"_npmUser":{"name":"stephan-wolf-ais","email":"stephan.wolf@ais-automation.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-red-contrib-odbc_1.0.4_1572353034636_0.9500218727155934"},"_hasShrinkwrap":false},"2.0.0":{"name":"@ais_automation/node-red-contrib-odbc","version":"2.0.0","description":"Node for node-red to unixODBC and its supported drivers. (MS SQL, PostgreSQL, ...)","main":"odbc.js","dependencies":{"odbc":"latest","mustache":"latest"},"node-red":{"nodes":{"odbc":"odbc.js"}},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"repository":{"type":"git","url":"git+https://github.com/AISAutomation/node-red-contrib-odbc2.git"},"keywords":["node-red","odbc","unixodbc","mssql","mysql","sql","PostgreSQL"],"author":{"name":"stephan-wolf-ais"},"license":"ISC","bugs":{"url":"https://github.com/AISAutomation/node-red-contrib-odbc2/issues"},"homepage":"https://github.com/AISAutomation/node-red-contrib-odbc2","gitHead":"f493da346a5edad9bb8b84a5ada478501780413b","_id":"@ais_automation/node-red-contrib-odbc@2.0.0","_nodeVersion":"12.13.0","_npmVersion":"6.12.0","dist":{"integrity":"sha512-zYhnCHMOFbl7BEcK4cIqIe0hw6rg6MfnkxFYsdU9IWhsRWjZAYUaaF0cfj2r/fza/G2GsV6jfpqFUt2hpTbMuQ==","shasum":"27e236acc64a256772b6a5b15cb402b9e2f194c6","tarball":"https://registry.npmjs.org/@ais_automation/node-red-contrib-odbc/-/node-red-contrib-odbc-2.0.0.tgz","fileCount":7,"unpackedSize":45257,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJd27VjCRA9TVsSAnZWagAA96sP/A+CjGP518sfU1WDUHu1\nUmilwm+MY+q9zoCy0t/Uds7/Int4+dvPr1BxAr3DZr31JpgpkYHD2tDumHhC\nhcsTZbIKVlQyo8v/Q9NTYuJEg4WmuydiVdQBZ/bKU6FvtDWu45mzwpyqwbCs\ndEDYeejPpqfwTzj7aq/CdxqwOByDKy3KQWVxxzELzvLC+aFaPSqJg+v/zAyg\nkFSRON9IgVb7XF7oTE6TGF7kek3uMuNEKJe9AmINiHZ/JzNsG5kJgLa49quO\nIf1OF6lNkZjH3vT1Pqo9/l1kvyyCgX7bLxhtRVVelmALYRyeKR6yAfUlMSJe\nbHV0lgz/yMdfXdplsQWubY6B0btXdcjXP1ofnPGQfFt1NJQPDxVS3soNZUwi\n70peT6kFJ0yKKxIhXzM8XQ32n92fj3hKLn/uiW4kKPVJ8cVjW9yaRx65KMgT\nwPvUqVA+1mCFdvLdEnIez1lwy2JTyw1VxYBrVRHR6Hwzgm2Ds4DTEPG3agng\nb4CJpt32F52nHG9L6ao3uz485A7J7mrktFMPZtAueQ/gH+45ICdpG0xHXrI5\nKA8m3FoQitlVlf5cwolHqViNZrdUgriNb3H7qdYTvv0T8s5f6BgKTl5ufHRe\ndDPQzdnj7+2wqd0donwxI53/RtdGAKoowNTG9otqkCG50idxqPiF27clgDon\nZwWC\r\n=Y4i6\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICU3rJcwoV+D+05QtC4hiS5oPFPvNux8QJ6oiJ7ECHxlAiEAnU9h6dO8pllMNL4zY6lWIcY+IeeRGO10VaydFy4oYuM="}]},"maintainers":[{"name":"aisautomation","email":"dirk.richter@ais-automation.com"},{"name":"dirkzp","email":"info@weri-design.de"},{"name":"mcrange","email":"matthias.range@ais-automation.com"},{"name":"stephan-wolf-ais","email":"stephan.wolf@ais-automation.com"}],"_npmUser":{"name":"stephan-wolf-ais","email":"stephan.wolf@ais-automation.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-red-contrib-odbc_2.0.0_1574679906527_0.25229812541108654"},"_hasShrinkwrap":false}},"time":{"created":"2019-10-29T12:43:54.427Z","1.0.4":"2019-10-29T12:43:54.818Z","modified":"2022-04-04T12:23:52.582Z","2.0.0":"2019-11-25T11:05:06.657Z"},"maintainers":[{"name":"aisautomation","email":"dirk.richter@ais-automation.com"},{"name":"dirkzp","email":"info@weri-design.de"},{"name":"mcrange","email":"matthias.range@ais-automation.com"},{"name":"stephan-wolf-ais","email":"stephan.wolf@ais-automation.com"}],"description":"Node for node-red to unixODBC and its supported drivers. (MS SQL, PostgreSQL, ...)","homepage":"https://github.com/AISAutomation/node-red-contrib-odbc2","keywords":["node-red","odbc","unixodbc","mssql","mysql","sql","PostgreSQL"],"repository":{"type":"git","url":"git+https://github.com/AISAutomation/node-red-contrib-odbc2.git"},"author":{"name":"stephan-wolf-ais"},"bugs":{"url":"https://github.com/AISAutomation/node-red-contrib-odbc2/issues"},"license":"ISC","readme":"# node-red-contrib-odbc\r\nNode for Node-RED to unixODBC and its supported drivers.\r\nBased on node-odbc https://github.com/wankdanker/node-odbc \r\n\r\n## NOT SUPPORTED!\r\n\r\nRequirements\r\n------------\r\n\r\n* unixODBC binaries and development libraries for module compilation\r\n  * on Ubuntu/Debian `sudo apt-get install unixodbc unixodbc-dev`\r\n  * on OSX using macports.org `sudo port unixODBC`\r\n* odbc drivers for target database\r\n* properly configured odbc.ini and odbcinst.ini.\r\n\r\nExample of odbcinst.ini\r\n\r\n\t\t[PostgreSQL]\r\n\t\tDescription=ODBC for PostgreSQL\r\n\t\tDriver=/usr/lib/psqlodbc.so\r\n\t\tSetup=/usr/lib/libodbcpsqlS.so\r\n\t\tFileUsage=1\r\n\r\n\t\t[MySQL]\r\n\t\tDescription=ODBC for MySQL\r\n\t\tDriver=/usr/lib/libmyodbc5.so\r\n\t\tSetup=/usr/lib/libodbcmyS.so\r\n\t\tFileUsage=1\r\n\r\n\t\t[FreeTDS]\r\n\t\tDescription=ODBC for MS SQL\r\n\t\tDriver=/usr/lib64/libtdsodbc.so.0\r\n\r\n\t\t[MSSQL]\r\n\t\tDescription=Microsoft ODBC Driver 11 for SQL Server\r\n\t\tDriver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0\r\n\t\tThreading=1\r\n\t\tUsageCount=1\r\n\r\nInstall\r\n-------\r\n\r\nAfter insuring that all requirements are installed run the following command in the root directory of your Node-RED install\r\n\r\n\r\n\t\tnpm install node-red-contrib-odbc\r\n\r\nConfigure node\r\n-------\r\n\r\n####Connection string\r\n\r\n[![Config](https://raw.githubusercontent.com/efa2000/node-red-contrib-odbc/master/Config_CN.png)](https://raw.githubusercontent.com/efa2000/node-red-contrib-odbc/master/Config_CN.png)\r\n\r\n####Query\r\n\r\n[![Config](https://raw.githubusercontent.com/efa2000/node-red-contrib-odbc/master/query.png)](https://raw.githubusercontent.com/efa2000/node-red-contrib-odbc/master/query.png)\r\n\r\nYou can uses the mustache format.\r\n","readmeFilename":"README.md"}