public void PetaPocoRepository_GetById_Returns_Null_If_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); //Act var dog = repository.GetById(Constants.PETAPOCO_InvalidDogId); //Assert Assert.IsNull(dog); }
public void PetaPocoRepository_GetById_Returns_Model_With_Correct_Properties_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); //Act var dog = repository.GetById(Constants.PETAPOCO_ValidDogId); //Assert Assert.AreEqual(Constants.PETAPOCO_ValidDogAge, dog.Age); Assert.AreEqual(Constants.PETAPOCO_ValidDogName, dog.Name); }
public void PetaPocoRepository_Get_Returns_Models_With_Correct_Properties_Using_FluentMapper() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new FluentMapper <Dog>(String.Empty); mapper.TableName(Constants.PETAPOCO_DogTableName); mapper.Property(d => d.Age, "Age"); mapper.Property(d => d.Name, "Name"); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); //Act var dogs = repository.Get(); //Assert var dog = dogs.First(); Assert.AreEqual(_dogAges[0], dog.Age.ToString()); Assert.AreEqual(_dogNames[0], dog.Name); }
public void PetaPocoRepository_Update_Updates_Item_With_Correct_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_UpdateDogId, Age = Constants.PETAPOCO_UpdateDogAge, Name = Constants.PETAPOCO_UpdateDogName }; //Act repository.Update(dog); //Assert DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); foreach (DataRow row in table.Rows) { if ((int)row[Constants.TABLENAME_Key] == Constants.PETAPOCO_UpdateDogId) { Assert.AreEqual(Constants.PETAPOCO_UpdateDogAge, row["Age"]); Assert.AreEqual(Constants.PETAPOCO_UpdateDogName, row["Name"]); } } }
public void PetaPocoRepository_Add_Inserts_Item_Into_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 { Age = Constants.PETAPOCO_InsertDogAge, Name = Constants.PETAPOCO_InsertDogName }; //Act repository.Insert(dog); //Assert int newId = DataUtil.GetLastAddedRecordID(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName, Constants.TABLENAME_Key); Assert.AreEqual(Constants.PETAPOCO_RecordCount + 1, newId); }
public void PetaPocoRepository_Add_Inserts_Item_Into_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 { 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); }