public void SaveIntoDatabaseTest()
{
//set high verbosity
//hardcode string connection for database
//build database configuration
var _connectionString = "Server=localhost\\SQLEXPRESS;Database=tarmacChallenge;Trusted_Connection=true";
var dbConfig = new DatabaseConfiguration(_connectionString, "JobLogger");
var _logger = new DatabaseLogger(
Verbosity.VerbosityTypes.high,
dbConfig
);
//messages as error
var typeOfMessages = TypeOfMessage.error;
foreach (var msg in _listOfMessages)
{
var toWrite = _logger.BuildMessage(msg, typeOfMessages);
var resultOperation = _logger.LogMessage(toWrite);
// check that ran withtou error
Assert.Equal(0, resultOperation);
}
}
public void CheckContentIntoDatabaseTest()
{
var _connectionString = "Server=localhost\\SQLEXPRESS;Database=tarmacChallenge;Trusted_Connection=true";
var dbConfig = new DatabaseConfiguration(_connectionString, "JobLogger");
var _logger = new DatabaseLogger(
Verbosity.VerbosityTypes.low,
dbConfig
);
var _messagesToWrite = new List <string>();
foreach (var msg in _listOfMessages)
{
var msgResult = _logger.BuildMessage(msg, TypeOfMessage.message);
_logger.LogMessage(msgResult);
_messagesToWrite.Add(msgResult);
}
using (var _connection = new SqlConnection(dbConfig.ConnectionString))
{
//we take the first message to compare
var checkMessage = _messagesToWrite.First();
_connection.Open();
// we keep only the message that are equal to checkMessage
var cmdText = string.Format(@"SELECT [message] FROM {0} WHERE message = '{1}'",
dbConfig.InsertTableName,
checkMessage);
SqlCommand selectCmd = new SqlCommand(cmdText, _connection);
var result = selectCmd.ExecuteScalar();
//should exist
Assert.NotEqual(string.Empty, result);
// and be equal
Assert.Equal(checkMessage, result);
_connection.Close();
}
}