public void PetaPocoRepository_Delete_Does_Nothing_With_Invalid_ID()
{
//Arrange
var db = CreatePecaPocoDatabase();
var mapper = new PetaPocoMapper(String.Empty);
DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository <Dog>(db, mapper);
var dog = new Dog
{
ID = Constants.PETAPOCO_InvalidDogId,
Age = Constants.PETAPOCO_DeleteDogAge,
Name = Constants.PETAPOCO_DeleteDogName
};
//Act
repository.Delete(dog);
//Assert
//Assert
int actualCount = DataUtil.GetRecordCount(Constants.PETAPOCO_DatabaseName,
Constants.PETAPOCO_DogTableName);
Assert.AreEqual(Constants.PETAPOCO_RecordCount, actualCount);
}
public void PetaPocoRepository_Delete_Does_Nothing_With_Invalid_ID_Using_FluentMapper()
{
// Arrange
var db = this.CreatePecaPocoDatabase();
var mapper = new FluentMapper <Dog>(string.Empty);
mapper.TableName(Constants.PETAPOCO_DogTableName);
mapper.PrimaryKey("ID");
mapper.Property(d => d.ID, "ID");
mapper.Property(d => d.Age, "Age");
mapper.Property(d => d.Name, "Name");
DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository <Dog>(db, mapper);
var dog = new Dog
{
ID = Constants.PETAPOCO_InvalidDogId,
Age = Constants.PETAPOCO_DeleteDogAge,
Name = Constants.PETAPOCO_DeleteDogName,
};
// Act
repository.Delete(dog);
// Assert
// Assert
int actualCount = DataUtil.GetRecordCount(
Constants.PETAPOCO_DatabaseName,
Constants.PETAPOCO_DogTableName);
Assert.AreEqual(Constants.PETAPOCO_RecordCount, actualCount);
}
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase_With_Correct_ID()
{
//Arrange
var db = CreatePecaPocoDatabase();
var mapper = new PetaPocoMapper(String.Empty);
DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository <Dog>(db, mapper);
var dog = new Dog
{
ID = Constants.PETAPOCO_DeleteDogId,
Age = Constants.PETAPOCO_DeleteDogAge,
Name = Constants.PETAPOCO_DeleteDogName
};
//Act
repository.Delete(dog);
//Assert
DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName);
foreach (DataRow row in table.Rows)
{
Assert.IsFalse((int)row[Constants.TABLENAME_Key] == Constants.PETAPOCO_DeleteDogId);
}
}
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase()
{
// Arrange
var db = this.CreatePecaPocoDatabase();
var mapper = new PetaPocoMapper(string.Empty);
DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository <Dog>(db, mapper);
var dog = new Dog
{
ID = Constants.PETAPOCO_DeleteDogId,
Age = Constants.PETAPOCO_DeleteDogAge,
Name = Constants.PETAPOCO_DeleteDogName,
};
// Act
repository.Delete(dog);
// Assert
int actualCount = DataUtil.GetRecordCount(
Constants.PETAPOCO_DatabaseName,
Constants.PETAPOCO_DogTableName);
Assert.AreEqual(Constants.PETAPOCO_RecordCount - 1, actualCount);
}
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase_With_Correct_ID_Using_FluentMapper()
{
// Arrange
var db = this.CreatePecaPocoDatabase();
var mapper = new FluentMapper <Dog>(string.Empty);
mapper.TableName(Constants.PETAPOCO_DogTableName);
mapper.PrimaryKey("ID");
mapper.Property(d => d.ID, "ID");
mapper.Property(d => d.Age, "Age");
mapper.Property(d => d.Name, "Name");
DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository <Dog>(db, mapper);
var dog = new Dog
{
ID = Constants.PETAPOCO_DeleteDogId,
Age = Constants.PETAPOCO_DeleteDogAge,
Name = Constants.PETAPOCO_DeleteDogName,
};
// Act
repository.Delete(dog);
// Assert
DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName);
foreach (DataRow row in table.Rows)
{
Assert.IsFalse((int)row[Constants.TABLENAME_Key] == Constants.PETAPOCO_DeleteDogId);
}
}
public void PetaPocoRepository_Delete_Does_Nothing_With_Invalid_ID()
{
//Arrange
var mockCache = new Mock <ICacheProvider>();
SetUpDatabase(TestConstants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository <Dog>(_petaPocoUnitOfWork, mockCache.Object);
var dog = new Dog
{
ID = TestConstants.PETAPOCO_InvalidDogId,
Age = TestConstants.PETAPOCO_DeleteDogAge,
Name = TestConstants.PETAPOCO_DeleteDogName
};
//Act
repository.Delete(dog);
//Assert
//Assert
int actualCount = DataUtil.GetRecordCount(TestConstants.PETAPOCO_DatabaseName,
TestConstants.PETAPOCO_TableName);
Assert.AreEqual(TestConstants.PETAPOCO_RecordCount, actualCount);
}
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase_With_Correct_ID()
{
//Arrange
var mockCache = new Mock <ICacheProvider>();
SetUpDatabase(TestConstants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository <Dog>(_petaPocoUnitOfWork, mockCache.Object);
var dog = new Dog
{
ID = TestConstants.PETAPOCO_DeleteDogId,
Age = TestConstants.PETAPOCO_DeleteDogAge,
Name = TestConstants.PETAPOCO_DeleteDogName
};
//Act
repository.Delete(dog);
//Assert
DataTable table = DataUtil.GetTable(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName);
foreach (DataRow row in table.Rows)
{
Assert.IsFalse((int)row["ID"] == TestConstants.PETAPOCO_DeleteDogId);
}
}
public void PetaPocoRepository_Delete_Overload_Deletes_Item_From_DataBase()
{
//Arrange
var db = CreatePecaPocoDatabase();
var mapper = new PetaPocoMapper(String.Empty);
DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository <Dog>(db, mapper);
//Act
repository.Delete("WHERE ID = @0", Constants.PETAPOCO_DeleteDogId);
//Assert
int actualCount = DataUtil.GetRecordCount(Constants.PETAPOCO_DatabaseName,
Constants.PETAPOCO_DogTableName);
Assert.AreEqual(Constants.PETAPOCO_RecordCount - 1, actualCount);
}
public void PetaPocoRepository_Delete_Overload_Does_Nothing_With_Invalid_ID()
{
// Arrange
var db = this.CreatePecaPocoDatabase();
var mapper = new PetaPocoMapper(string.Empty);
DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository <Dog>(db, mapper);
// Act
repository.Delete("WHERE ID = @0", Constants.PETAPOCO_InvalidDogId);
// Assert
int actualCount = DataUtil.GetRecordCount(
Constants.PETAPOCO_DatabaseName,
Constants.PETAPOCO_DogTableName);
Assert.AreEqual(Constants.PETAPOCO_RecordCount, actualCount);
}
public void PetaPocoRepository_Delete_Overload_Does_Nothing_With_Invalid_ID()
{
//Arrange
var db = CreatePecaPocoDatabase();
var mapper = new PetaPocoMapper(String.Empty);
DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository<Dog>(db, mapper);
//Act
repository.Delete("WHERE ID = @0", Constants.PETAPOCO_InvalidDogId);
//Assert
int actualCount = DataUtil.GetRecordCount(Constants.PETAPOCO_DatabaseName,
Constants.PETAPOCO_DogTableName);
Assert.AreEqual(Constants.PETAPOCO_RecordCount, actualCount);
}
public void PetaPocoRepository_Delete_Overload_Deletes_Item_From_DataBase_With_Correct_ID()
{
//Arrange
var db = CreatePecaPocoDatabase();
var mapper = new PetaPocoMapper(String.Empty);
DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository<Dog>(db, mapper);
//Act
repository.Delete("WHERE ID = @0", Constants.PETAPOCO_DeleteDogId);
//Assert
DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName);
foreach (DataRow row in table.Rows)
{
Assert.IsFalse((int)row[Constants.TABLENAME_Key] == Constants.PETAPOCO_DeleteDogId);
}
}
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase()
{
//Arrange
var db = CreatePecaPocoDatabase();
var mapper = new PetaPocoMapper(String.Empty);
DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository<Dog>(db, mapper);
var dog = new Dog
{
ID = Constants.PETAPOCO_DeleteDogId,
Age = Constants.PETAPOCO_DeleteDogAge,
Name = Constants.PETAPOCO_DeleteDogName
};
//Act
repository.Delete(dog);
//Assert
int actualCount = DataUtil.GetRecordCount(Constants.PETAPOCO_DatabaseName,
Constants.PETAPOCO_DogTableName);
Assert.AreEqual(Constants.PETAPOCO_RecordCount - 1, actualCount);
}
public void PetaPocoRepository_Delete_Does_Nothing_With_Invalid_ID()
{
//Arrange
var mockCache = new Mock<ICacheProvider>();
SetUpDatabase(TestConstants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository<Dog>(_petaPocoUnitOfWork, mockCache.Object);
var dog = new Dog
{
ID = TestConstants.PETAPOCO_InvalidDogId,
Age = TestConstants.PETAPOCO_DeleteDogAge,
Name = TestConstants.PETAPOCO_DeleteDogName
};
//Act
repository.Delete(dog);
//Assert
//Assert
int actualCount = DataUtil.GetRecordCount(TestConstants.PETAPOCO_DatabaseName,
TestConstants.PETAPOCO_TableName);
Assert.AreEqual(TestConstants.PETAPOCO_RecordCount, actualCount);
}
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase_With_Correct_ID()
{
//Arrange
var mockCache = new Mock<ICacheProvider>();
SetUpDatabase(TestConstants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository<Dog>(_petaPocoUnitOfWork, mockCache.Object);
var dog = new Dog
{
ID = TestConstants.PETAPOCO_DeleteDogId,
Age = TestConstants.PETAPOCO_DeleteDogAge,
Name = TestConstants.PETAPOCO_DeleteDogName
};
//Act
repository.Delete(dog);
//Assert
DataTable table = DataUtil.GetTable(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName);
foreach (DataRow row in table.Rows)
{
Assert.IsFalse((int)row["ID"] == TestConstants.PETAPOCO_DeleteDogId);
}
}
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase()
{
//Arrange
var mockCache = new Mock<ICacheProvider>();
SetUpDatabase(TestConstants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository<Dog>(_pecaPocoDb, mockCache.Object);
var dog = new Dog
{
ID = TestConstants.PETAPOCO_DeleteDogId,
Age = TestConstants.PETAPOCO_DeleteDogAge,
Name = TestConstants.PETAPOCO_DeleteDogName
};
//Act
repository.Delete(dog);
//Assert
int actualCount = DataUtil.GetRecordCount(TestConstants.PETAPOCO_DatabaseName,
TestConstants.PETAPOCO_TableName);
Assert.AreEqual(TestConstants.PETAPOCO_RecordCount - 1, actualCount);
}
