Releases: bestlong/node-red-contrib-mssql-plus
v0.9.0
v0.8.0
- fix: reformat test spec 8f822e7
- feat: docker for test 46fa84f
- feat: rename test config.json 4ae4505
- update npmignore f043d86
- fix: Update dependencies ab99a9a
- update documentation (zh-TW) 578949f
- Manually merge documentation (en-US) a649912
- Merge branch 'i18n' 9de8b9f
- (Fix: i18n message) parseJSON c473b7f
- Merge pull request #48 from bestlong/Add-locale-zh-TW bbe9cdc
- version bump f71031f
- fix [n]varchar(MAX) varbinary(MAX) for bulk params c57e6ff
- (attempt) to reduce logging noise 932d776
- ensure demos are included in installation b8004e0
- Fix #52 wrong user in "Disconnecting" log entry e47d29c
- Merge pull request #47 from bestlong/bestlong-patch-1 6d3bb9a
- update readme - remove bulk mode beta notice (now merged into master) 5fc0e54
- Merge branch 'mssql7' bc23ca9
- Merge branch 'mssql7' of https://github.com/bestlong/node-red-contrib-mssql-plus into mssql7 88c16c4
- version bump for new features and deps - mssql now V7.0.0 - new feature bulk 3214dc3
- add eslint config and fixup code 8759a0c
- Add dynamic tests 2f55473
- minor fixes - built in help tweak - properly destroy editor after closing 675509f
- Add locale zh-TW 5a7cb12
- fix typo de50987
- bump deps and version to beta.4 bc11f1c
- fix passing column params for bulk insert - fixes #45 1d796c7
- fix query editor not hiding - patch version bump to 0.6.4 4c9d4c1
- Merge branch 'master' of https://github.com/bestlong/node-red-contrib-mssql-plus 64773d2
- version bump eb20749
- fix params not hiding when NONE is selected. Fixes #37 f37da84
- version bump 0.7.0-beta.3 a1264c0
- layout tweaks db6242f
- tweak bulk demo cb49c17
- add options for build insert table columns - UI changes to permit user setting on column options per item - nullable, readOnly, primary, identity - length (captured from coerced parameter type) d09717f
- improve parameter type coercer ab61f4c
- Update README.md 3a8c88c
- version bump for NPM publish 5f0530b
- Merge branch 'master' of https://github.com/bestlong/node-red-contrib-mssql-plus 78d4527
- deps bump + version bump to V0.6.1 44839b9
- Add trustedServerCertificate option e1354ab
- preparation for Bulk Insert support 17cd26d
- ui tweaks 516d10b
- cause modefield on change to trigger on load 2f008d0
- prepare for bulk insert support 47ca1dc
- spelling, formatting, layout fixes 3f04e00
- fix trust cert option - bump to beta.2 aaecaa4
- update TVP demo to use same CN object as bulk demo 0a7b900
- update readme to reflect new version changes 140fce7
- Add new demo BULK 05cef34
- fix attempt 2 - output type choice - allow original return type for query and execute node - ignore output type for bulk mode (return driver output) 1bc73a7
- spelling, comments, corrections fb43fa4
- improve built in docs c7e107e
- fix query typedInput width (layout improvement) 2ba37b2
- bug fix - original return type - original return type compa should only apply to query ea17fe4
- Update built in help 2104573
- minor version bump (beta) 0.7.0-beta.1 - minor bump due to new backwards compatable features 4f87fa7
- overhaul promises and add bulk mode - change promises to async await - attempt to fix memory leak issue #42 - add bulk mode - helps avoid issue #42 - additional refactoring and bug fixes 944e2bb
- add trustServerCertificate param - required for MSSQL 7 8b37eec
- layout improvements 4c0d825
- update deps d66ffad
- preparing files for translation (WIP) 445a33c
Refinements
V0.6.1
-
Support Numeric(?,?) and Decimal(?,?)
- including better validation and feedback of parameter types
-
add more types to parameter values typedInput providing more flexibility of where parameter values come from
- jsonata
- MS Epoch (JS)
- Secs Epoch (Unix)
- UUID
-
permit port to be blank without showing an error
- The port could be left blank and connection would work but the connection node was always showing in error
UI improvements
V0.5.1
UI improvements …
- add "none" option to parameters
- make query window resize to available space
- add expand button to further increase query editing size
Add Execute mode and support Parameters
V0.5.0 New Features
Parameters
It is now possible to include parameters in a query. These can be entered in the updated UI or passed in via msg, flow, global etc.
Execute mode
It is now possible to call native execute method to run stored procedures. This includes the possibility of using TVPs (Table Valued Parameters)
Demo
A demo flow has been added to the node-red imports dialog. It demonstrates the various ways of sending parameters to the MSSQL node. It also demonstrates TVP parameter usage.
v0.4.4 Release
v0.4.0
v0.3.3
- upgrade gitignore e4aca1b
- use np run better publish flow b959fdc
- upgrade mssql dependency version 112b485
- Merge pull request #23 from bestlong/try-add-test f6d735f
- add test notes 78ef092
- add test config e9282d8
- update gitignore fd478a4
- rm package-lock.json 160460d
- Merge pull request #21 from bestlong/json-support df83313
- JSON Support b18ab71
v0.3.0
v0.2.1
Update of node-red-contrib-mssql-plus
Changes include...
Fix problem where configs get mixed up when more than one SQL Server config is used in a node-red installation (handles #2)
Add ability to return multiple record sets (optional return type to maintain compatibility with earlier versions)
Add ability to output results to field other than payload
Add ability to throw errors (handles #5, #9) (optional to maintain compatibility with earlier versions)
Improved documentation
Bug fixes
More info and screen shots here...
https://discourse.nodered.org/t/mssql-node-red-contrib-mssql-plus-behavior/7340/11