a7b9380f25
fix mysql node error scope
2022-07-22 10:18:37 +01:00
0b3b918528
mysql faster/tidier closing of pool if never connected.
2022-07-11 14:39:16 +01:00
22d1ec2c19
bump for pr connection fix
2022-02-21 20:10:28 +00:00
87e50f2b76
Mysql fix ( #886 )
...
* Check if there is a connection before release
Fixes #885
2022-02-21 20:08:33 +00:00
3d750a59eb
mysql - update to 1.0.0
2022-01-05 10:59:40 +00:00
fea47843d7
Change mysql library to mysql2 as it is more maintained and support latest mysql authention ( #862 )
...
* Use mysql2 lib
* fix pool on acquire event cause MaxListenersExceededWarning (#854 )
before: every query need to register pool on acquire event to specify queryFormat based on payload type
will cause MaxListenersExceededWarning
after:
from https://www.npmjs.com/package/mysql#pooling-connections
pool.query is a shortcut for pool.getConnection() -> connection.query() -> connection.release()
so use pool.getConnection and then
set queryFormat before query method be called
Co-authored-by: Dave Conway-Jones <dceejay@users.noreply.github.com>
* fix mysql require
* Add decimalNumbers flag true to mysql beta
* mysql remove old Timeout option, clarify timezone options
* add mysqlConnectionLimit settings option.
Co-authored-by: saknarak <saknarak@gmail.com>
2022-01-05 10:56:14 +00:00
d1f04a74ad
Add Japanese translation to MySQL node ( #849 )
2021-11-18 08:23:57 +00:00
2d28a2304f
Update package.jsons for mono-repo ( #851 )
...
Update the package.json for each node to point to the directory within the repo that hosts the code for the package in question. as per https://docs.npmjs.com/cli/v7/configuring-npm/package-json#repository
2021-11-02 15:22:30 +00:00
9cb6255b16
bump for Ja language PR
2021-10-27 13:50:15 +01:00
b95ae5dc63
Add Japanese translations for mysql Node ( #841 )
2021-10-27 13:42:27 +01:00
70e04763da
bump mysql for PR fix
2021-10-21 15:11:47 +01:00
b18c32f037
Fix #811 ( #847 )
2021-10-21 15:08:23 +01:00
799eee3873
Mysql - Only call done if it exists.
2021-06-19 14:47:44 +01:00
bb6491942e
Merge Pool PR.
2021-05-18 09:11:41 +01:00
d8ba11ccdf
query by pool instead of using the connection directly ( #806 )
2021-05-18 09:09:33 +01:00
b37d215659
mysql - revert trying to fixup RowDataPackets introduced in 0.1.8
2021-05-10 08:53:08 +01:00
fdfdbb17b7
Fix mysql multiple return queries type
...
to close #797
2021-04-23 22:23:16 +01:00
2c5cc5f70c
Fixup mysql node done calls
2021-04-08 17:07:23 +01:00
040bf24c4b
node-red-node-mysq add done() callback ( #793 )
...
This fix adds the done() callback when the query has been executed.
2021-04-08 09:11:59 +01:00
c1c82a623e
mysql, actually make the if else do something sensible...
2021-03-21 17:30:14 +00:00
a194c56acb
refix copy results array
2021-03-21 10:10:45 +00:00
868d641064
Update 68-mysql.js
2021-03-16 08:24:06 +00:00
fabd3753b4
undo mysql change again
2021-03-14 17:54:31 +00:00
c2613cfeb0
mysql test before releasing connection
2021-03-14 09:05:23 +00:00
9e7701dc33
Update 68-mysql.js
2021-03-13 13:59:00 +00:00
6095723308
fix mysql array handling
2021-03-12 21:01:54 +00:00
0772b545ea
added i18n help files ( #766 )
2021-03-12 13:17:23 +00:00
4641d10beb
mysql: add charset option (defaults as-is to old UTF8)
2020-04-18 18:03:59 +01:00
397b7cdaec
bump mysql thanks to PR
2020-04-10 22:56:28 +01:00
0351441075
MySQL allows to pass named parameters as object ( #565 )
...
* add check isobj
* added example to readme.md
* edit if Syntax
* add Documentation link to readme.md
* fixed Syntax and edit readme.md
2020-04-10 22:53:17 +01:00
fa8e174d0b
mysql - slightly overzealous closing of connections - causes crash. backed off slightly
2020-04-05 12:35:15 +01:00
705dd1ffc1
mysql - ensure connection released back to pool more often
...
and try to ensure status is shown more correctly on error.
2020-04-05 11:44:27 +01:00
e3e6c41030
Add Name field to mysql server config so can be made unique
...
to close #635
2020-03-20 14:59:08 +00:00
eb9d379014
bump mysql package and lib
2020-03-01 17:06:22 +00:00
f2e28e715f
fix mysql node OkPacket handling
...
to close #583
2019-10-16 11:24:33 +01:00
d153034232
slow down status updates from mysql to better handle fast updates
...
to close #515
2019-02-01 22:15:22 +00:00
493061e6f0
bump mysql lib version
2018-08-13 12:30:52 +01:00
9c9af2952c
Update to the latest mysql package ( #476 )
...
Updating from mysql 2.13 to 2.16 fixed for me a problem with error msg "Error: pool is closed" produced every few seconds in NR debug window.
2018-08-13 12:29:42 +01:00
5a07f29ebd
remove invalid error parameter from mysql callback
2017-03-17 13:45:47 +00:00
20f7cb0a3d
remove console logging from mysql
2017-02-26 10:20:30 +00:00
c6d214fcfe
mysql set to try to keep server connection alive
2017-02-26 10:18:07 +00:00
fe1a96d67d
tidy up mysql some more
...
remove listeners on close and update status on partial deploy
2016-11-27 19:21:57 +00:00
738eada16b
Update Mysql Node status reporting
2016-11-27 17:03:03 +00:00
a7247e898a
Update licenses and packages for all nodes
2016-11-06 20:26:19 +00:00
afec508980
Catch "not connected" to database in Mysql node
...
also to close #172 - as multiple statements now also supported
2016-09-14 22:44:53 +01:00
69b471b0f1
let mysql node allow multiple statements
2016-07-20 20:11:50 +01:00
86049c20cb
update storage nodes info style
2016-03-02 13:27:52 +00:00
e1b02c90dd
let mysql report errors to catch node
2015-11-01 15:04:42 +00:00
76f55af264
Update Package.json file for all node-red-nodes to be Apache-2.0
2015-05-29 14:58:34 +01:00
5982da8495
Add bind capability to sqlite and mysql nodes
...
Thanks to Scott Penrose for the patch.
2015-01-26 10:57:13 +00:00
Dave Conway-Jones
Ben Hardill
Dave Conway-Jones
Kazuhito Yokoi
Sam Machin
Wataru Sato
Nicolas Glassey
Eric Dum
Daniele
heikokue
Marco
tmdoit
Dave Conway-Jones
Dave Conway-Jones