private void CloseTestDBConnection(TDataBase ADBAccessObject, string AConnectionName = null, bool ALogNumberOfConnections = false)
{
if (ALogNumberOfConnections)
{
if (FDBType == TDBType.PostgreSQL)
{
TLogging.Log(" CloseTestDBConnection: Number of open DB Connections on PostgreSQL BEFORE closing Database connection: " +
TDataBase.GetNumberOfDBConnections(FDBType) + ADBAccessObject.GetDBConnectionIdentifier());
}
}
TLogging.Log(" CloseTestDBConnection: Closing connection to Database..." + ADBAccessObject.GetDBConnectionIdentifier());
ADBAccessObject.CloseDBConnection();
TLogging.Log(" CloseTestDBConnection: Database connection closed." + TDataBase.GetDBConnectionName(AConnectionName));
if (ALogNumberOfConnections)
{
if (FDBType == TDBType.PostgreSQL)
{
TLogging.Log(" CloseTestDBConnection: Number of open DB Connections on PostgreSQL AFTER closing Database connection: " +
TDataBase.GetNumberOfDBConnections(FDBType) + TDataBase.GetDBConnectionName(AConnectionName));
}
}
}
/// <summary>
/// modified version taken from Ict.Petra.Server.App.Main::TServerManager
/// </summary>
private TDataBase EstablishDBConnectionAndReturnIt(string AConnectionName = null, bool ALogNumberOfConnections = false)
{
TDataBase ReturnValue;
if (ALogNumberOfConnections)
{
if (FDBType == TDBType.PostgreSQL)
{
TLogging.Log(" EstablishDBConnectionAndReturnIt: Number of open DB Connections on PostgreSQL BEFORE Connecting to Database: " +
TDataBase.GetNumberOfDBConnections(FDBType) + TDataBase.GetDBConnectionName(AConnectionName));
}
}
TLogging.Log(" EstablishDBConnectionAndReturnIt: Establishing connection to Database..." + TDataBase.GetDBConnectionName(AConnectionName));
ReturnValue = new TDataBase();
TLogging.DebugLevel = TAppSettingsManager.GetInt16("Server.DebugLevel", 10);
try
{
ReturnValue.EstablishDBConnection(FDBType,
TAppSettingsManager.GetValue("Server.DBHostOrFile"),
TAppSettingsManager.GetValue("Server.DBPort"),
TAppSettingsManager.GetValue("Server.DBName"),
TAppSettingsManager.GetValue("Server.DBUserName"),
TAppSettingsManager.GetValue("Server.DBPassword"),
"", AConnectionName);
}
catch (Exception Exc)
{
TLogging.Log(" EstablishDBConnectionAndReturnIt: Encountered Exception while trying to establish connection to Database " +
TDataBase.GetDBConnectionName(AConnectionName) + Environment.NewLine +
Exc.ToString());
throw;
}
TLogging.Log(" EstablishDBConnectionAndReturnIt: Connected to Database." + ReturnValue.GetDBConnectionIdentifier());
if (ALogNumberOfConnections)
{
if (FDBType == TDBType.PostgreSQL)
{
TLogging.Log(" EstablishDBConnectionAndReturnIt: Number of open DB Connections on PostgreSQL AFTER Connecting to Database: " +
TDataBase.GetNumberOfDBConnections(FDBType) + ReturnValue.GetDBConnectionIdentifier());
}
}
return(ReturnValue);
}
