private void TestSearchLogs(string server, string database, string user, string password)
{
var connectionString = TestDBTools.GetConnectionString(server, database, user, password);
var dbTools = new ExecuteDatabaseSP(connectionString);
var spCmd = new SqlCommand
{
CommandType = CommandType.StoredProcedure,
CommandText = "FindLogEntry"
};
spCmd.Parameters.Add(new SqlParameter("@Return", SqlDbType.Int)).Direction = ParameterDirection.ReturnValue;
var entryTypeParam = spCmd.Parameters.Add(new SqlParameter("@EntryType", SqlDbType.VarChar, 32));
entryTypeParam.Value = "Normal";
var messageTextParam = spCmd.Parameters.Add(new SqlParameter("@MessageText", SqlDbType.VarChar, 500));
messageTextParam.Value = "complete";
Console.WriteLine("Running stored procedure " + spCmd.CommandText + " against " + database + " as user " + user);
var returnCode = dbTools.ExecuteSP(spCmd, out var lstResults);
Assert.AreEqual(returnCode, 0, spCmd.CommandText + "Procedure did not return 0");
var rowsDisplayed = 0;
foreach (var result in lstResults)
{
Assert.GreaterOrEqual(result.Count, 5, "Result row has fewer than 5 columns");
for (var colIndex = 0; colIndex < result.Count; colIndex++)
{
Console.Write(result[colIndex] + " ");
if (colIndex == 5)
{
var completeFound = result[colIndex].ToLower().Contains("complete");
Assert.True(completeFound, "Result row does not have complete in the Message column");
break;
}
}
Console.WriteLine();
rowsDisplayed++;
if (rowsDisplayed > 10)
{
break;
}
}
Console.WriteLine("Rows returned: " + lstResults.Count);
}
private void TestDBLogger(string server, string database, string user, string password, string logDirectory, string logFileNameBase)
{
var connectionString = TestDBTools.GetConnectionString(server, database, user, password);
var logFilePath = Path.Combine(logDirectory, logFileNameBase);
var logger = new clsDBLogger(connectionString, logFilePath);
Console.WriteLine("Calling logger.PostEntry using " + database + " as user " + user);
// Call stored procedure PostLogEntry
logger.PostEntry("Test log entry on " + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), logMsgType.logDebug, false);
}
private void TestDBLogger(string server, string database, string user, string password)
{
var connectionString = TestDBTools.GetConnectionString(server, database, user, password);
var moduleName = DatabaseLogger.MachineName + ":" + "DatabaseLoggingTests";
var logger = new SQLServerDatabaseLogger(moduleName, connectionString)
{
EchoMessagesToFileLogger = true,
LogLevel = BaseLogger.LogLevels.DEBUG
};
Console.WriteLine("Calling logger.PostEntry using " + database + " as user " + user);
// Call stored procedure PostLogEntry
logger.WriteLog(BaseLogger.LogLevels.DEBUG, "Test log entry on " + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
}
private void TestGetAllPeptideDatabases(string server, string database, string user, string password)
{
var connectionString = TestDBTools.GetConnectionString(server, database, user, password);
var dbTools = new ExecuteDatabaseSP(connectionString);
var spCmd = new SqlCommand
{
CommandType = CommandType.StoredProcedure,
CommandText = "GetAllPeptideDatabases"
};
spCmd.Parameters.Add(new SqlParameter("@Return", SqlDbType.Int)).Direction = ParameterDirection.ReturnValue;
spCmd.Parameters.Add(new SqlParameter("@IncludeUnused", SqlDbType.Int)).Value = 0;
spCmd.Parameters.Add(new SqlParameter("@IncludeDeleted", SqlDbType.Int)).Value = 0;
Console.WriteLine("Running stored procedure " + spCmd.CommandText + " against " + database + " as user " + user);
var returnCode = dbTools.ExecuteSP(spCmd, out var lstResults);
Assert.AreEqual(returnCode, 0, spCmd.CommandText + "Procedure did not return 0");
var rowsDisplayed = 0;
foreach (var result in lstResults)
{
Assert.GreaterOrEqual(result.Count, 9, "Result row has fewer than 9 columns");
var dbName = result[0];
var showData = dbName.ToLower().Contains("human");
var organism = "??";
for (var colIndex = 0; colIndex < result.Count; colIndex++)
{
if (showData && colIndex < 4)
{
Console.Write(result[colIndex] + " ");
}
if (colIndex == 2)
{
organism = result[colIndex];
}
}
if (dbName.StartsWith("PT_Human", StringComparison.OrdinalIgnoreCase))
{
var humanFound = organism.ToLower().Contains("homo_sapiens");
Assert.True(humanFound, "Human PT database does not have organism Homo_Sapiens");
}
if (showData)
{
Console.WriteLine();
rowsDisplayed++;
if (rowsDisplayed > 10)
{
break;
}
}
}
Console.WriteLine("Rows returned: " + lstResults.Count);
}
