Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
en:sw:01-mervis:08-sscp-bridge [2021/08/06 12:50] avsetula |
en:sw:01-mervis:08-sscp-bridge [2024/04/18 10:41] (current) avsetula |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== SSCP to SQL Bridge ====== | + | ====== SSCP to MySQL Bridge ====== |
- | This daemon-based service allows bi-directional data transfer between an Unipi unit running Mervis and a SQL database through an SSCP protocol (the proprietary protocol used by Mervis). The daemon can run on any Linux machine (database server or another remote machine) or directly on the unit. | + | This daemon-based service allows bi-directional data transfer between an Unipi unit running Mervis and a MySQL database through an SSCP protocol (the proprietary protocol used by Mervis). The daemon can run on any Linux machine (database server or another remote machine) or directly on the unit. |
{{ :en:sw:01-mervis:sscp-sql-bridge.png?direct |}} | {{ :en:sw:01-mervis:sscp-sql-bridge.png?direct |}} | ||
Line 23: | Line 23: | ||
- **UPDATE** - This action will update a row in the specified table with the variable values in the unit. The row can be specified using the "where" parameter, which will be directly used as a "WHERE" clause in the SQL query. (Set DB row according to the Mervis variable) | - **UPDATE** - This action will update a row in the specified table with the variable values in the unit. The row can be specified using the "where" parameter, which will be directly used as a "WHERE" clause in the SQL query. (Set DB row according to the Mervis variable) | ||
- **INSERT** - This action will insert a row with current unit values into the specified table each time the variable state is read from the unit. (Log Mervis variable to the DB) | - **INSERT** - This action will insert a row with current unit values into the specified table each time the variable state is read from the unit. (Log Mervis variable to the DB) | ||
+ | |||
+ | <WRAP center round tip 90%> | ||
+ | Currently it is not supported to send long data types (LREAL, LINT, ULINT, etc.), or STRING and DT. | ||
+ | </WRAP> | ||
+ | |||
===== Supported platforms ===== | ===== Supported platforms ===== |