public void SQLiteUnit_RollbackUnitWithOneCommand_ReturnTrue()
{
// Arrange
var unit = new SQLiteUnit(this.PathToDataBase);
string command =
$"INSERT INTO {this.DbTableName}({this.DbFieldId}, {this.DbFieldFirstName}, {this.DbFieldLastName}) "
+ $"VALUES (1, '{this.FirstName1}', '{this.LastName1}')";
string rollbackCommand = $"DELETE FROM {this.DbTableName} WHERE {DbFieldId} = 1";
unit.AddSqliteCommand(command, rollbackCommand);
// Act
unit.Commit();
unit.Rollback();
// Assert
var personsInDatabase = this.GetInfOfDataBase();
Assert.IsTrue(!personsInDatabase.Any());
}
public void SQLiteUnit_RollbackUnitWithSeveralCommands_ReturnTrue()
{
// Arrange
var unit = new SQLiteUnit(this.PathToDataBase);
for (int i = 0; i < this.Names.Length; i++)
{
int id = i + 1;
string command =
$"INSERT INTO {this.DbTableName}({this.DbFieldId}, {this.DbFieldFirstName}, {this.DbFieldLastName}) "
+ $"VALUES ({id}, '{Names[i]}', '{this.LastNames[i]}')";
string rollbackComand = $"DELETE FROM {this.DbTableName} WHERE {DbFieldId} = {id}";
unit.AddSqliteCommand(command, rollbackComand);
}
// Act
unit.Commit();
unit.Rollback();
// Assert
var personsInDatabase = this.GetInfOfDataBase();
Assert.IsTrue(!personsInDatabase.Any());
}
