User Tools

Site Tools


sib:callers:mysqlcaller

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
sib:callers:mysqlcaller [2019/05/13 11:39]
hubbe
sib:callers:mysqlcaller [2019/06/12 06:50] (current)
ozzy
Line 4: Line 4:
  
 The mySQL SIB Caller is a specific mySQL caller that performs operations on a mySQL database. The mySQL SIB Caller is a specific mySQL caller that performs operations on a mySQL database.
-The caller simply performs the [msg.sql] operation on the database and returns the result. It is recommended to generate the [msg.sql] field in the inputFormat,​ overwriting whatever value was received from the MQTT transport, for safety reasons. The [msg.sql] field can then be deleted in the outpuFormat ​method if needed.+The caller simply performs the [msg.sql] operation on the database and returns the result. It is recommended to generate the [msg.sql] field in the inputFormat,​ overwriting whatever value was received from the MQTT transport, for safety reasons. The [msg.sql] field can then be deleted in the outputFormat ​method if needed.
  
 If the [msg.sql] contains //?// placeholders the [msg.placeholder] must contain the array of values to substitute the placeholders with. If the [msg.sql] contains //?// placeholders the [msg.placeholder] must contain the array of values to substitute the placeholders with.
sib/callers/mysqlcaller.txt ยท Last modified: 2019/06/12 06:50 by ozzy