This function is used in Python Scripting.

Description

Runs a query through the Store and Forward system and to multiple datasources at the same time.

Client Permission Restrictions

Permission Type: Legacy Database Access

Client access to this scripting function is blocked to users that do not meet the role/zone requirements for the above permission type. This function is unaffected when run in the Gateway scope.

Syntax

system.db.runSFUpdateQuery(query, datasources)

  • Parameters

String query - A query (typically an UPDATE, INSERT, or DELETE) to run.

List[String] datasources - List of datasources to run the query through.

  • Returns

Boolean - Returns True if successful, False if not.

  • Scope

Gateway, Vision Client, Perspective Session

Code Examples
Code Snippet
# Example 1: Run through single datasource
print system.db.runSFUpdateQuery("INSERT INTO recipes (name, sp1, sp2, sp3) VALUES ('A Name', 1032, 234, 1)", ["MySQLDatasource"])
Code Snippet
# Example 2: Run through two datasources
print system.db.runSFUpdateQuery("INSERT INTO recipes (name, sp1, sp2, sp3) VALUES ('A Name', 1032, 234, 1)", ["MySQLDatasource", "SQLServerDatasource"])
Keywords

system db runSFUpdateQuery, db.runSFUpdateQuery