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
privateSQLDatabaseExecuteCustomQuery(objSQLDatabase:SQLDatabase,strSQLQuery:string):number{
this.objLogger.debug(`SQLDatabase Execute Custom SQL Query:\r\n${strSQLQuery}`);
letintQueryResult:number=objSQLDatabase.executeCustomQuery(strSQLQuery);
this.objLogger.info(`SQLDatabase Execute Custom SQL Query Result${intQueryResult.toString()}.`);
returnintQueryResult;
}Discover more from Cloud Build Tools
Subscribe to get the latest posts sent to your email.