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
public SQLTableFindUniqueRecord(objSQLTable: SQLTable, arrExample: any[]): SQLActiveRecord {
let objSQLActiveRecord: 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}.`);
}
return objSQLActiveRecord;
}Discover more from Cloud Build Tools
Subscribe to get the latest posts sent to your email.