Commit Graph

1685 Commits

Author SHA1 Message Date
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
Dave Conway-Jones 8d8195ec02
Bump packages and tidy poplib linting 2022-01-03 17:33:14 +00:00
Dave Conway-Jones e6930274e2
Bump email
and include poplib to avoid example warning.
2022-01-01 19:11:01 +00:00
Dave Conway-Jones 4ee6e57111
let feedparser accept simple xml headers
to close #867
2021-12-23 10:59:21 +00:00
Dave Conway-Jones 1bb31ba7ad
set daemon node to use node.debug 2021-12-23 10:58:33 +00:00
Dave Conway-Jones fa69af298a
Bump to pickup PR and fix python 3 2021-12-12 17:06:24 +00:00
mw75 70ac42463c
fixed check for python2 module while using python3 (#866)
Excellent - thank for that.
2021-12-12 17:05:13 +00:00
Dave Conway-Jones 68ba586074
add check for python3 lib
to close #865
2021-12-08 09:38:50 +00:00
Dave Conway-Jones 1293a865c1
Let geohash handle null island
and add test
2021-11-29 21:26:24 +00:00
Olivier Girondel 121da5deae
Allow lat and lon to be 0 (#863)
Thanks
2021-11-29 21:16:06 +00:00
Dave Conway-Jones d4faa55ab8
tidy up mcp3008 init 2021-11-29 08:49:45 +00:00
Dave Conway-Jones 4868364860
Update package.json 2021-11-18 08:41:12 +00:00
Kazuhito Yokoi d1f04a74ad
Add Japanese translation to MySQL node (#849) 2021-11-18 08:23:57 +00:00
Dave Conway-Jones 8d0fdd9fbf
Fix mcp3xxx refs to new variables
to Close #856
2021-11-17 18:08:13 +00:00
Dave Conway-Jones 9f81067d7d
Fix Pi keyboard an mouse events 2021-11-16 22:57:09 +00:00
Dave Conway-Jones a5235c7d7d
bump datagenerator version 2021-11-16 10:59:50 +00:00
Dave Conway-Jones b0cc103f10
Add 230400 baud to default serialport options 2021-11-15 11:17:56 +00:00
Dave Conway-Jones ccdc125818
remove beta from pigpio 2021-11-13 13:50:03 +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 5db644bd57
bump some libs - email, annotate image, core 2021-10-27 14:03:49 +01:00
Dave Conway-Jones 9cb6255b16
bump for Ja language PR 2021-10-27 13:50:15 +01:00
Dave Conway-Jones d8e0a1803d
Bump for latest xmpp client lib 2021-10-27 13:50:02 +01:00
Dave Conway-Jones 29b8765de1
bump for multiple chip support PR 2021-10-27 13:49:15 +01:00
CD2468 ae4b6bb0bf
Problems with more than one MCP3008 (#823)
* Add files via upload

* Update pimcp3008.js

implementation of the discussion

* Update pimcp3008.js

Co-authored-by: Dave Conway-Jones <dceejay@users.noreply.github.com>
2021-10-27 13:46:00 +01:00
Wataru Sato b95ae5dc63
Add Japanese translations for mysql Node (#841) 2021-10-27 13:42:27 +01:00
Dave Conway-Jones 04465c1dca
tweak up exif node - nicer colours smaller icon 2021-10-25 16:11:22 +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
Dave Conway-Jones c78ac48fa5
Fix MCP3xxx Readme 2021-10-19 20:34:08 +01:00
Dave Conway-Jones 9b2ba970de
Add 3201 to mc3008 node. 2021-10-18 21:21:44 +01:00
Dave Conway-Jones b44676ef3c
bump daemon for Ja translations
make exit standalone
2021-10-18 21:13:52 +01:00
Wataru Sato eec57351d0
Add Japanese translations for daemon Node (#843)
* Separate language resources

* Add Japanese translations for daemon Node
2021-10-18 21:12:00 +01:00
Trise e6b9da52aa
social-pushover | add tags parameter (#846)
* social-pushover: Add "tags" parameter.

Add "tags" for emergency prio (2) messages, so you're able to cancel them by tag. (see doc / Pushover API)

* Add msg.tags to readme.
2021-10-18 21:09:35 +01:00
Wataru Sato 3e67ce628f
Add local/ja/66-mongodb.html (#839) 2021-10-10 22:13:44 +01:00
Wataru Sato a4c5697820
Add Japanese translations for exif node (#840) 2021-10-10 22:09:03 +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 1f2a25637b
bump pushover node to add callback PR 2021-08-30 12:12:45 +01:00
brianmangan 6ca70977d8
Social: pushover; add callback parameter w/ documentation (#832)
* adding callback parameter to pushover node.

* pushover: callback feature added

* social/pushover documentation

* PR: added callback parameter to pushover
2021-08-30 12:10:07 +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 c5bd7da8dc
bump for doc updates 2021-07-31 09:35:52 +01:00
meeki007 b12571527f
node-red-node-email: Added documentation use of: Use secure connection & update Readme documentation (#824)
Updated README,md to better reflect the updated documentation found in the node
2021-07-31 09:33:41 +01:00
Dave Conway-Jones e990b47c65
let discovery node not flag empty service type 2021-07-22 18:06:48 +01:00
crxporter 8604a783a4
Added to wol node: num_packets and interval options (#819) 2021-07-19 17:23:48 +01:00
Dave Conway-Jones 761bb30ada
Email node - better handling of criteria errors 2021-07-16 14:41:12 +01:00
JsBergbau 245109940c
PiSrf: Added decimal places option + stop bugfix + more keywords (#816)
* Added decimal places option + bugfix + keywords

Added option to output more decimal places. When no decimal places are configured output stays the same for full backward compatibility.

Fixed bug that on restart flows error "Error stopping node: Close timed out" occured. Also removed sudo, because no need to run code with root rights. On systems where you need password for sudo it wouldn't run then. 

Added Keywords for "HC-SR04" and "SR04", because this module is fully compatible with this node.

* Added decimal places option + bugfix + keywords

Added option to output more decimal places. When no decimal places are configured output stays the same for full backward compatibility.

Fixed bug that on restart flows error "Error stopping node: Close timed out" occured. Also removed sudo, because no need to run code with root rights. On systems where you need password for sudo it wouldn't run then. 

Added Keywords for "HC-SR04" and "SR04", because this module is fully compatible with this node.

* Added decimal places option + bugfix + keywords

Added option to output more decimal places. When no decimal places are configured output stays the same for full backward compatibility.

Fixed bug that on restart flows error "Error stopping node: Close timed out" occured. Also removed sudo, because no need to run code with root rights. On systems where you need password for sudo it wouldn't run then. 

Added Keywords for "HC-SR04" and "SR04", because this module is fully compatible with this node.
2021-07-08 08:32:55 +01:00
Dave Conway-Jones 4859a8bcc0
bump email deps for cve
to close #815
2021-06-30 09:08:09 +01:00
Ben Hardill ebd043cec6
fix for #813 (#814)
* Fix for #813

Ensure `msg.location` exists before populating

* Only add location data if location present
2021-06-29 09:03:46 +01:00
Dave Conway-Jones cdcafbad1d
remove old x-red style for better highlighting 2021-06-23 12:21:19 +01:00
Dennis Gaida eb8bae6782
blink1: added "blink1 in" node (#812)
* Added "blink1 in" node

* sets msg.payload to current RGB value or "off" if RGB = 0,0,0
* can also be used to pipe msg.payload to blink1 out
* blink1 category created
* blink1 label set to "blink1 out"
* Bumped version to 0.1.0
* Modified readme
2021-06-22 12:39:22 +01:00
Dave Conway-Jones 799eee3873
Mysql - Only call done if it exists. 2021-06-19 14:47:44 +01:00