public void SqlLoggerInvalidConnectionStringProcedure()
{
DateTime testStart = DateTime.Now;
Log.DefaultMemoryLogger.ValidLevels = LogLevels.All;
// Create a new SQL logger
SqlLogger sqlLogger = new SqlLogger("Test SQL Logger", Guid.NewGuid(), ConnectionStringInvalid);
// Add the SQL logger
Log.GetOrAddLogger(sqlLogger);
AddTestLogItems(testStart);
Thread.Sleep(15000);
// Now retrieve the logs.
IEnumerable<Log> logs = Log.GetForward(testStart, 10);
Assert.IsTrue(
logs.Any(l => l.Level == LogLevel.Critical) &&
logs.Any(
l =>
l.Level == LogLevel.Information && l.ExceptionType != null &&
l.ExceptionType.Equals("System.Data.SqlClient.SqlException")));
}
public void TestSqlLogger()
{
DateTime testStart = DateTime.Now;
Log.DefaultMemoryLogger.ValidLevels = LogLevels.All;
// Create a new SQL logger
SqlLogger sqlLogger = new SqlLogger("Test SQL Logger",
new Guid("E12A1F4A-6F69-4F35-B2A0-96B112C495D5"),
ConnectionString);
// Add the SQL logger
Log.GetOrAddLogger(sqlLogger);
// Every 500ms log some items.
int x = 0;
while (x < 50)
{
AddTestLogItemsWrapper(testStart);
x++;
Thread.Sleep(500);
}
// TODO: Retrieve and check we havent added the latest every time.
//foreach (string expectedOutput in testLogItems.Select(test => test.ExpectedOutput))
//{
// string output = expectedOutput;
// Assert.IsTrue(logs.Any(l => l.Operation.Name == OPERATION_NAME
// && l.Operation.CategoryName == OPERATION_CATEGORY_NAME
// && l.Operation.Parent != null
// && l.Operation.Parent.Name == OPERATION_NAME_WRAPPER
// && l.Message.Equals(output)));
//}
}
public void TestSqlLoggerMemoryCacheExpired()
{
DateTime testStart = DateTime.Now;
Log.DefaultMemoryLogger.ValidLevels = LogLevels.All;
// Create a new sql logger
SqlLogger sqlLogger = new SqlLogger("Test SQL Logger",
new Guid("E12A1F4A-6F69-4F35-B2A0-96B112C495D5"),
ConnectionString);
// Add the sql logger
Log.GetOrAddLogger(sqlLogger);
// Add the test log items
var testLogItems = AddTestLogItemsWrapper(testStart);
Thread.Sleep(2100000);
// Force an immediate GC of all generations.
GC.Collect(0, GCCollectionMode.Forced);
GC.Collect(1, GCCollectionMode.Forced);
GC.Collect(2, GCCollectionMode.Forced);
// Give the GC 120s econds (just to be safe).
Thread.Sleep(120000);
IEnumerable<Log> logs = Log.GetForward(sqlLogger, testStart, 10);
//foreach (string expectedOutput in testLogItems.Select(test => test.ExpectedOutput))
//{
// string output = expectedOutput;
// Assert.IsTrue(logs.Any(l => l.Operation.Name == OPERATION_NAME
// && l.Operation.CategoryName == OPERATION_CATEGORY_NAME
// && l.Operation.Parent != null
// && l.Operation.Parent.Name == OPERATION_NAME_WRAPPER
// && l.Message.Equals(output)));
//}
}
public void SqlLoggerInvalidGetStoredProcedure()
{
DateTime testStart = DateTime.Now;
Log.DefaultMemoryLogger.ValidLevels = LogLevels.All;
// Create a new SQL logger
SqlLogger sqlLogger = new SqlLogger(
"Test SQL Logger", Guid.NewGuid(), ConnectionString, getStoredProcedure: Guid.NewGuid().ToString());
// Add the SQL logger
Log.GetOrAddLogger(sqlLogger);
AddTestLogItems(testStart);
}