public void PetaPocoRepository_Delete_Does_Nothing_With_Invalid_ID_Using_FluentMapper() { //Arrange var db = 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_Update_Updates_Item_In_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_UpdateDogId, Age = Constants.PETAPOCO_UpdateDogAge, Name = Constants.PETAPOCO_UpdateDogName }; //Act repository.Update(dog); //Assert int actualCount = DataUtil.GetRecordCount(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); Assert.AreEqual(Constants.PETAPOCO_RecordCount, actualCount); }
public void PetaPoco_Delete_Deletes_Item_Using_FluentMapper() { //Arrange DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var dog = new Dog { ID = Constants.PETAPOCO_DeleteDogId, Age = Constants.PETAPOCO_DeleteDogAge, Name = Constants.PETAPOCO_DeleteDogName }; using (var dataContext = new PetaPocoDataContext(ConnectionStringName, String.Empty, _mappers)) { IRepository <Dog> dogRepository = dataContext.GetRepository <Dog>(); //Act dogRepository.Delete(dog); } //Assert int actualCount = DataUtil.GetRecordCount(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); Assert.AreEqual(Constants.PETAPOCO_RecordCount - 1, actualCount); }
public void PetaPoco_Add_Inserts_Item() { //Arrange DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var dog = new Dog { Age = Constants.PETAPOCO_InsertDogAge, Name = Constants.PETAPOCO_InsertDogName }; using (var dataContext = new PetaPocoDataContext(ConnectionStringName)) { IRepository <Dog> dogRepository = dataContext.GetRepository <Dog>(); //Act dogRepository.Insert(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 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_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_Add_Inserts_Item_Into_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 { Age = Constants.PETAPOCO_InsertDogAge, Name = Constants.PETAPOCO_InsertDogName, }; // Act repository.Insert(dog); // 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 = 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 PetaPoco_Delete_Overload_Deletes_Item() { //Arrange DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); using (var dataContext = new PetaPocoDataContext(ConnectionStringName)) { IRepository <Dog> dogRepository = dataContext.GetRepository <Dog>(); //Act dogRepository.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_Update_Overload_Updates_Item_In_DataBase() { // 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.Update("SET Age=@1, Name=@2 WHERE ID=@0", Constants.PETAPOCO_UpdateDogId, Constants.PETAPOCO_UpdateDogAge, Constants.PETAPOCO_UpdateDogName); // Assert int actualCount = DataUtil.GetRecordCount( Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); Assert.AreEqual(Constants.PETAPOCO_RecordCount, actualCount); }
public static void RecordCountIsEqual(SqlConnection connection, string tableName, int expectedCount) { Assert.AreEqual(expectedCount, DataUtil.GetRecordCount(connection, tableName)); }
public static void RecordWithIdNotPresent(string databaseName, string tableName, string primaryKeyField, int id) { var count = DataUtil.GetRecordCount(databaseName, tableName, primaryKeyField, id.ToString()); Assert.IsTrue(count == 0); }