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