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 Read Records from an SQL Table
Public Function: SQLTableReadReconds
publicSQLTableReadReconds(objSQLTable:SQLTable,arrSQLColumn:SQLColumn[],blnValidateUnique:boolean=true):SQLActiveRecord[]{
letarrSQLActiveRecord:SQLActiveRecord[]=objSQLTable.readRecords(arrSQLColumn,blnValidateUnique);
this.objLogger.info(`Read${arrSQLColumn.length.toString()} columns from${arrSQLActiveRecord.length.toString()} records from${objSQLTable.name}.`);
returnarrSQLActiveRecord;
}Discover more from Cloud Build Tools
Subscribe to get the latest posts sent to your email.