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