To use this function add it to the class library file named OrchestratorPluginSQLService.ts
GitHub Repository: https://github.com/SimonSparksUK/Orchestrator
Filename: OrchestratorPluginSQLService.ts
Description: Orchestrator Function to Execute Custom Query on an SQL Database
Private Function: SQLDatabaseExecuteCustomQuery
private SQLDatabaseExecuteCustomQuery(objSQLDatabase: SQLDatabase, strSQLQuery: string): number {
this.objLogger.debug(`SQLDatabase Execute Custom SQL Query: \r\n${strSQLQuery}`);
let intQueryResult: number = objSQLDatabase.executeCustomQuery(strSQLQuery);
this.objLogger.info(`SQLDatabase Execute Custom SQL Query Result ${intQueryResult.toString()}.`);
return intQueryResult;
}Discover more from Cloud Build Tools
Subscribe to get the latest posts sent to your email.