Skip to main content
Version: 8.1

system.db.runSFUpdateQuery

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

TypeParameterDescription
StringqueryA query (typically an UPDATE, INSERT, or DELETE) to run.
String[]datasourcesList of datasources to run the query through.

Returns

Boolean - Returns true if successful and 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