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 Update an SQL Database
Public Function: SQLDatabaseUpdate
publicSQLDatabaseUpdate(objSQLDatabase:SQLDatabase,strName:string,strType:string,strConnectionURL:string,strUusername:string,strPassword:string,strSessionMode:string):SQLDatabase{
try{
objSQLDatabase=SQLDatabaseManager.getDatabaseById(objSQLDatabase.id);
objSQLDatabase.name=strName;
objSQLDatabase.type=strType;
objSQLDatabase.connectionURL=strConnectionURL;
objSQLDatabase.username=strUusername;
objSQLDatabase.password=strPassword;
objSQLDatabase.sessionMode=strSessionMode;
objSQLDatabase=SQLDatabaseManager.updateDatabase(objSQLDatabase);
this.objLogger.info(`SQLDatabase Update of:${objSQLDatabase} Successfull.`);
}
catch (objException){
this.objLogger.info(`SQLDatabase Update of:${objSQLDatabase} Failed.`);
}
returnobjSQLDatabase;
}Discover more from Cloud Build Tools
Subscribe to get the latest posts sent to your email.