User Tools

Site Tools


sib:listeners:mssqllistener

Differences

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

Link to this comparison view

Last revision Both sides next revision
sib:listeners:mssqllistener [2019/06/12 08:13]
ozzy created
sib:listeners:mssqllistener [2019/06/12 08:14]
ozzy
Line 57: Line 57:
  mqtt: "​mqtt://​localhost",​  mqtt: "​mqtt://​localhost",​
  schedules: [  schedules: [
- {handler: "​testFind",​ schedule: "* * * * *", topic: "​SIB/​Samples/​mySQLListener/​testFind"​}+ {handler: "​testFind",​ schedule: "* * * * *", topic: "​SIB/​Samples/​MSSQLListener/​testFind"​}
  ],  ],
- topic: "​SIB/​Samples/​mySQLListener"+ topic: "​SIB/​Samples/​MSSQLListener"
 }; };
    
Line 71: Line 71:
   * inputFormat(topic,​ msg, callback): The method that is run on service activation. The original message is passed as the argument and the return value from this method must be a JSON formatted message conforming to the SIB message standard.   * inputFormat(topic,​ msg, callback): The method that is run on service activation. The original message is passed as the argument and the return value from this method must be a JSON formatted message conforming to the SIB message standard.
   * loggerCfg: A JSON Object defining what logger actions should be active for this service (see [[sib:​loggerConfiguraton|Logger Configuration]]   * loggerCfg: A JSON Object defining what logger actions should be active for this service (see [[sib:​loggerConfiguraton|Logger Configuration]]
-  * mssql: Database configuration. ​The below fields are required but everything that can be passed to //​mysql.connect//​ can be set here+  * mssql: Database configuration.
     * host: The host of the database server     * host: The host of the database server
     * user: The user to log in as     * user: The user to log in as
     * password: The base64 encoded password for the user     * password: The base64 encoded password for the user
     * database: The database to connect to  ​     * database: The database to connect to  ​
-  ​* publishInput:​ If defined overrides the standard publishing to the internal MQTT transfer+  * publishInput:​ If defined overrides the standard publishing to the internal MQTT transfer
   * schedules: An array of JSON Objects describing the scheduling and topics to publish messages to   * schedules: An array of JSON Objects describing the scheduling and topics to publish messages to
     * schedule: The CRON schedule that decides how often to trigger the data flow     * schedule: The CRON schedule that decides how often to trigger the data flow
sib/listeners/mssqllistener.txt ยท Last modified: 2019/09/20 07:31 by hubbe