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 Find a Unique Record in an SQL Table
Public Function: SQLTableFindUniqueRecord
publicSQLTableFindUniqueRecord(objSQLTable:SQLTable,arrExample:any[]):SQLActiveRecord{
letobjSQLActiveRecord:SQLActiveRecord=objSQLTable.findUniqueRecord(arrExample);
if (objSQLActiveRecord!==null||undefined){
this.objLogger.info(`Found an SQLActiveRecord records from${objSQLTable.name}.`);
}else{
this.objLogger.info(`Failed to find an SQLActiveRecord records from${objSQLTable.name}.`);
}
returnobjSQLActiveRecord;
}Discover more from Cloud Build Tools
Subscribe to get the latest posts sent to your email.