@envidatec/node-red-contrib-logger 1.0.13
Logs Data into SQL-Lite
SQL Lite config node
| name | meaning |
|---|---|
| path | path to database file |
| table_data | name of table |
| name | name of config node |
| table_trend | name of table where trend config is stored |
Logger
On receiving Creates Messages Object (Create Sample, Update Trend, Delete Samples) to interacting with Sql-Lite Node
Properties
| name | meaning |
|---|---|
| TrendID | Trend ID which represents this instance of node |
| Logsize in Days | how many days the data will remain in the Database |
Input
| message object | meaning |
|---|---|
| msg.payload | Value written into the SQL-Lite |
| msg.error | if error is present writes Value with staus code 16 |
Status Codes
| Code | meaning |
|---|---|
| 0 | OK |
| 16 | msg.error present |
| 16 | empty Payload |
SQL-Lite
Actions
| topic | meaning |
|---|---|
| Delete Samples | Deletes Samples for a trend id before a specific date |
| Update Trend | update Trend configuration |
| Create Sample | creates sample |
| Delete Trend | Deletes all sample + Trend configuration |
| Get Data | Returns Requested Samples |
| Get All Trends | Deletes all sample + Trend configuration |
Delete Samples
Payload
| Payload | meaning |
|---|---|
| deleteDate | Delete Until when Samples will be deleted |
| id | Trend Id |
Output
None
Update Trend
Payload
| Payload | meaning |
|---|---|
| name | name of the trend |
| config | config of update intervall of Trend(cron tab expression / asynchronous |
| id | id of trend |
Output
None
Create Sample
Payload
| Payload | meaning |
|---|---|
| trend_id | Id of Trend |
| status | status of sample for further Information on Status Code Section |
| value | Value of Sample |
| date_time | Date Time when the Value was logged |
Output
None
Delete Trend
Payload
Trend ID of the trend which should be deleted
Output
None
Get Data
Payload
| Payload | meaning |
|---|---|
| aggregation | aggregation (NONE,DIFF,MAX,MIN,SUM) |
| from | Start Date Time |
| until | End Date Time |
| limit | maximum amount of Samples |
| listTrendIds | Array of Trend Ids |
Output
Array with the requested Samples
Get All Trends
Payload
None
Array of Trends
Rest-Server
| attribute | meaning |
|---|---|
| port | Port on which Rest Server is running |
| SQL-DB Connection | Connection to SQL-Lite |
| Username | Username for api authentication (basicAuth) |
| Password | Password for api authentication (basicAuth) |
Paylaod
| payload | meaning |
|---|---|
| START | Starts Web Server |
| STOP | Stops Web Server |
Api Documentation
url:port/doc
