system.db.runSFUpdateQuery
note
This function was deprecated in 8.3. It is recommended to use system.db.execUpdateAsync or system.db.runSFPrepUpdate instead.
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
| Type | Parameter | Description |
|---|---|---|
| String | query | A query (typically an UPDATE, INSERT, or DELETE) to run. |
| String[] | datasources | List 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"])