public static void ExportServiceCenterLogs(string dbEngine, OSDiagToolConf.ConfModel.strConfModel configurations, OSDiagToolForm.OsDiagFormConfModel.strFormConfigurationsModel FormConfigurations,
DBConnector.SQLConnStringModel sqlConnString = null, DBConnector.OracleConnStringModel oracleConnString = null, string adminSchema = null)
{
FileLogger.TraceLog(string.Format("Exporting Platform logs ({0} records)...", FormConfigurations.osLogTopRecords));
Directory.CreateDirectory(_osPlatformLogs);
List <string> platformLogs = new List <string>();
foreach (string table in configurations.tableNames) // add only oslog tables to list
{
if (table.ToLower().StartsWith("oslog"))
{
platformLogs.Add(table);
}
}
if (dbEngine.Equals("sqlserver"))
{
Platform.LogExporter.PlatformLogExporter(dbEngine, platformLogs, FormConfigurations, _osPlatformLogs, configurations.queryTimeout, sqlConnString, null);
}
else if (dbEngine.Equals("oracle"))
{
Platform.LogExporter.PlatformLogExporter(dbEngine, platformLogs, FormConfigurations, _osPlatformLogs, configurations.queryTimeout, null, oracleConnString, adminSchema);
}
}
public static void ExportPlatformMetamodel(string dbEngine, OSDiagToolConf.ConfModel.strConfModel configurations, OSDiagToolForm.OsDiagFormConfModel.strFormConfigurationsModel FormConfigurations,
DBConnector.SQLConnStringModel sqlConnString = null, DBConnector.OracleConnStringModel oracleConnString = null)
{
FileLogger.TraceLog("Exporting Platform Metamodel...");
Directory.CreateDirectory(_osMetamodelTablesDest);
if (dbEngine.Equals("sqlserver"))
{
var connector = new DBConnector.SLQDBConnector();
SqlConnection connection = connector.SQLOpenConnection(sqlConnString);
using (connection) {
bool isLifeTimeEnvironment = Platform.PlatformUtils.IsLifeTimeEnvironment(dbEngine, configurations.queryTimeout, connection);
FileLogger.TraceLog("Starting exporting tables: ");
foreach (string table in FormConfigurations.metamodelTables)
{
if ((isLifeTimeEnvironment && table.ToLower().StartsWith("osltm") || table.ToLower().StartsWith("ossys")))
{
FileLogger.TraceLog(table + ", ", writeDateTime: false);
string selectAllQuery = "SELECT * FROM " + table;
CSVExporter.SQLToCSVExport(dbEngine, table, _osMetamodelTablesDest, configurations.queryTimeout, selectAllQuery, connection, null);
}
}
}
}
else if (dbEngine.Equals("oracle"))
{
var connector = new DBConnector.OracleDBConnector();
OracleConnection connection = connector.OracleOpenConnection(oracleConnString);
string platformDBAdminUser = Platform.PlatformUtils.GetPlatformDBAdminUser();
using (connection) {
bool isLifeTimeEnvironment = Platform.PlatformUtils.IsLifeTimeEnvironment(dbEngine, configurations.queryTimeout, null, connection, platformDBAdminUser);
FileLogger.TraceLog("Starting exporting tables: ");
foreach (string table in FormConfigurations.metamodelTables)
{
if ((isLifeTimeEnvironment && table.ToLower().StartsWith("osltm") || table.ToLower().StartsWith("ossys")))
{
FileLogger.TraceLog(table + ", ", writeDateTime: false);
string selectAllQuery = "SELECT * FROM " + platformDBAdminUser + "." + table;
CSVExporter.ORCLToCsvExport(connection, table, _osMetamodelTablesDest, configurations.queryTimeout, platformDBAdminUser, selectAllQuery);
}
}
}
}
}
