Commit Graph

197 Commits

Author SHA1 Message Date
Dave Conway-Jones 8e2f8b60e0
bump sqlite3 libs and package
to include css bugfix
2023-09-16 19:16:35 +01:00
Kazuhito Yokoi 504bbda0a4
Fix height of description editor in sqlite node (#1030) 2023-09-16 19:12:20 +01:00
Dave Conway-Jones 2b50bf38ec
Fix tail to update status
and retry if file goes away and comes back
2022-12-14 11:45:33 +00:00
Dave Conway-Jones a7b9380f25
fix mysql node error scope 2022-07-22 10:18:37 +01:00
Dave Conway-Jones 0b3b918528
mysql faster/tidier closing of pool if never connected. 2022-07-11 14:39:16 +01:00
Dave Conway-Jones 22d1ec2c19
bump for pr connection fix 2022-02-21 20:10:28 +00:00
Ben Hardill 87e50f2b76
Mysql fix (#886)
* Check if there is a connection before release

Fixes #885
2022-02-21 20:08:33 +00:00
Dave Conway-Jones 456e573cd7
bump tail and xmpp packages 2022-01-17 09:54:38 +00:00
realgnark b92ca63f93
Issue #875 node red node tail potentially stops working (#877) 2022-01-16 17:23:45 +00:00
Dave Conway-Jones 28580c33ea
bump sqlite fro doc updates PR. 2022-01-05 16:23:01 +00:00
unborn-andy 7ff905d224
Sqlite Node - docs update (#869)
* Update README.md

1. Updated node readme to match node's html help.
2. Added Example clarifying the use of parameters in a msg.topic query.
2022-01-05 16:20:06 +00:00
Ben Hardill f9b4d2ec01
Sqlite3 fix (#872)
* Reset bind if msg.payload not an array
2022-01-05 11:43:16 +00:00
Dave Conway-Jones 3d750a59eb
mysql - update to 1.0.0 2022-01-05 10:59:40 +00:00
Dave Conway-Jones 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
Kazuhito Yokoi d1f04a74ad
Add Japanese translation to MySQL node (#849) 2021-11-18 08:23:57 +00:00
Sam Machin 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
Dave Conway-Jones 9cb6255b16
bump for Ja language PR 2021-10-27 13:50:15 +01:00
Wataru Sato b95ae5dc63
Add Japanese translations for mysql Node (#841) 2021-10-27 13:42:27 +01:00
Dave Conway-Jones 70e04763da
bump mysql for PR fix 2021-10-21 15:11:47 +01:00
Nicolas Glassey b18c32f037
Fix #811 (#847) 2021-10-21 15:08:23 +01:00
Wataru Sato 3e67ce628f
Add local/ja/66-mongodb.html (#839) 2021-10-10 22:13:44 +01:00
Dave Conway-Jones c6f37d19a8
fix sqlite array handling issue
to close #670
2021-09-13 11:10:04 +01:00
Dave Conway-Jones 96fa500ad6
bump sqlite to latest library, which also drops nodejs <v12 2021-08-17 10:34:51 +01:00
Dave Conway-Jones 799eee3873
Mysql - Only call done if it exists. 2021-06-19 14:47:44 +01:00
Dave Conway-Jones bb6491942e
Merge Pool PR. 2021-05-18 09:11:41 +01:00
Eric Dum d8ba11ccdf
query by pool instead of using the connection directly (#806) 2021-05-18 09:09:33 +01:00
Dave Conway-Jones b37d215659
mysql - revert trying to fixup RowDataPackets introduced in 0.1.8 2021-05-10 08:53:08 +01:00
Dave Conway-Jones fdfdbb17b7
Fix mysql multiple return queries type
to close #797
2021-04-23 22:23:16 +01:00
Dave Conway-Jones 8412beedf2
Bump tail node to pick up latest underlying library fixes for error handling
hopefully to address #795
2021-04-11 14:07:17 +01:00
Dave Conway-Jones 2c5cc5f70c
Fixup mysql node done calls 2021-04-08 17:07:23 +01:00
Daniele 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
Dave Conway-Jones 35fea0f1cc
bump tail for de translations 2021-03-25 09:49:52 +00:00
heikokue cb3b4c3c62
tail node: improved EN help and added DE help (#779) 2021-03-25 09:48:46 +00:00
Dave Conway-Jones c1c82a623e
mysql, actually make the if else do something sensible... 2021-03-21 17:30:14 +00:00
Dave Conway-Jones a194c56acb
refix copy results array 2021-03-21 10:10:45 +00:00
Dave Conway-Jones dceb33dc43
few remaining x-red to html tidy ups, both sentiment and redis nodes. 2021-03-16 09:57:46 +00:00
Dave Conway-Jones 868d641064
Update 68-mysql.js 2021-03-16 08:24:06 +00:00
Dave Conway-Jones fabd3753b4
undo mysql change again 2021-03-14 17:54:31 +00:00
Dave Conway-Jones c2613cfeb0
mysql test before releasing connection 2021-03-14 09:05:23 +00:00
Dave Conway-Jones 169be33591
bump tail, sqlite, email, feedparser, pigpiod for German translations 2021-03-13 14:15:58 +00:00
Dave Conway-Jones 9e7701dc33
Update 68-mysql.js 2021-03-13 13:59:00 +00:00
Dave Conway-Jones 6095723308
fix mysql array handling 2021-03-12 21:01:54 +00:00
heikokue 80b9316d92
added/improved DE translation of forms (#765) 2021-03-12 13:23:26 +00:00
heikokue 0772b545ea
added i18n help files (#766) 2021-03-12 13:17:23 +00:00
Dave Conway-Jones 12c485faaf
bump mongo node for close PR 2021-01-22 13:50:37 +00:00
Adrien GILLON 4cfc7b39be
Fix MongoDB connection close on node close (#737)
closes #738
2021-01-22 13:48:01 +00:00
Kazuhito Yokoi fa2ea96e67
Add Japanese translations for sqlite node (#725)
* Add Japanese translations for sqlite node

* Improve Japanese translations for sqlite node

* Restructure message catalog
2020-12-17 08:26:32 +00:00
Dave Conway-Jones e5f41880c3
ump mongo package for fix PR 2020-11-16 15:44:53 +00:00
Ross Cruickshank 8363a774e9
mongodb cusor handling #714 (#715)
match cursor handling with parameter
2020-11-16 15:43:53 +00:00
Dave Conway-Jones 395bf77441
bump mongo node for release 2020-10-28 11:25:03 +00:00