executesql

RPLib – executesql

RPLib.executesql(Workspace=None, SQLStatement=None)

Execute one or multiple SQL statements against an enterprise geodatabase.

Parameter	Type	Description	Required
Workspace	String	Path to SDE connection file.	Yes
SQLStatement	String	String of SQL statements to execute, statements separated by a semi-colon	Yes

Returns: Boolean

Usage

• Execute raw SQL statements/queries using an SDE connection file.

Example 1

Simple call with all parameters specified. Only one SQL statement.

import RPLib

sdeOwner = "C:/GIS/SDEADMIN@GIS.sde"

sqlStatement = "select count(*) from sde.SDE_states;"

RPLib.executesql(sdeOwner,sqlStatement)

Example 2

Simple call with only required parameters specified. Multiple SQL statements.

import RPLib

sdeOwner = "C:/GIS/SDEADMIN@GIS.sde"

sqlStatement = "select count(*) from sde.SDE_states;select state_id from sde.SDE_states;"

RPLib.executesql(sdeOwner,sqlStatement)

Example 3

If Else logic with all parameters specified. Multiple SQL statements.

import RPLib

sdeOwner = "C:/GIS/SDEADMIN@GIS.sde"

sqlStatement = "select count(*) from sde.SDE_states;select state_id from sde.SDE_states;"

if RPLib.executesql(sdeOwner,sqlStatement):
    print("successful, run another tool")
else:
    print("failed, run another tool")