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); }