...
Action | Parameter | Example Usage |
---|---|---|
executeQueryAndStoreResults
To execute the query (mentioned in Parameter 2) on database, with database connection string (mentioned in Parameter 1) and store the result in variable (mentioned in Parameter 3) for further use. | Param 1 : Database connection string | Example : Suppose the DB Connect variable created is bqdbString with values MySQL | 192.9.9.9 | 9999 | Schema 1 | abcde | xxxxxxxx
Executes query (select xxxx from Table where xxxx= xxx) on database, with database connection string (bqdbString) and stores the result in (bqVariable) variable. |
executeUpdateQuery
To execute the update query (mentioned in Parameter 2) on database, with database connection string (mentioned in Parameter 1). | Param 1 : Database Connection String | Example : Suppose the DB Connectvariable created is bqdbString with values MySQL | 192.9.9.9 | 9999 | Schema 1 | abcde | xxxxxxxx
Executes query (update Table set xxxx= xxx where yyyy=yyyy) on database, with database connection string (bqdbString). |
executeDeleteQuery
To execute the delete query (mentioned in Parameter 2) on database, with database connection string (mentioned in Parameter 1). | Param 1 : Database Connection String | Example : Suppose the DB Connectvariable created is bqdbString with values MySQL | 192.9.9.9 | 9999 | Schema 1 | abcde | xxxxxxxx.
Execute query (delete from Table where yyyy=yyyy) on database, with database connection string (bqdbString). |
executeInsertQuery
To execute the insert query (mentioned in Parameter 2) on database, with database connection string (mentioned in Parameter 1). | Param 1 : Database Connection String | Example : Suppose the DB Connectvariable created is bqdbString with values MySQL | 192.9.9.9 | 9999 | Schema 1 | abcde | xxxxxxxx.
Execute query (Insert into Table values (xxxxxxxx)) on database, with database connection string (bqdbString). |
executeStoredProcedureAndStoreResult
To execute the stored procedure (mentioned in Parameter 2) on database, with database connection string (mentioned in Parameter 1). | Param 1 : Database Connection String | Example : Suppose the DB Connectvariable created is bqdbString with values MySQL | 192.9.9.9 | 9999 | Schema 1 | abcde | xxxxxxxx.
Executes stored procedure SP1 on database, with database connection string bqdbString. |
setDbInputParameter
To set the input parameter name (mentioned in parameter 1) and parameter value (mentioned in parameter 2), of data type (mentioned in parameter 3). The default parameter type is String. If no value is provided in param 3, String will be used as parameter type. If parameter type is mentioned as Date, default date format will be used unless user provides a date format in param 4. | Param 1 : Name of the parameter | Example 1 :
Sets input parameter name userName with parameter value bqurious of parameter type String. Example 2 :
Suppose the default date format mentioned in App config. is MM/dd/yy. Sets input parameter name setDate with parameter value 04/16/20 (date converted to default format) of parameter type Date. Example 3 :
Sets input parameter name setDate with parameter value 16/04/20 (date converted to the provided format in param 4) of parameter type Date. |
setDbOutputParameter
To set the output parameter (name mentioned in parameter 1) of data type (type mentioned in Parameter 3. The default parameter type is String. If no value is provided in param 2, String will be used as parameter type. | Param 1 : Name of the parameter | Example 1 :
Sets output parameter userName of type String. Example 2 :
Sets output parameter setDate of type Date. |
verifyQueryResults
To verify the query (mentioned in Parameter 2) on database, with database connection string (mentioned in Parameter 1), returns the value (mentioned in Parameter 3). | Param 1 : Database connection string | Example : Suppose the DB Connectvariable created is bqdbString with values MySQL | 192.9.9.9 | 9999 | Schema 1 | abcde | xxxxxxxx.
Verifies query (select xyz from Table where xx = yyyy) returns value (bqResults) on database with database connection string (bqdbString). |
Related articles
Filter by label (Content by label) | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
hidden | true |
---|
...