public void PetaPocoMapper_Constructor_Initialises_TablePrefix_Property() { //Arrange //Act var mapper = new PetaPocoMapper(Constants.TABLENAME_Prefix); //Assert Assert.AreEqual(Constants.TABLENAME_Prefix, Util.GetPrivateMember<PetaPocoMapper, string>(mapper, "_tablePrefix")); }
public void PetaPocoMapper_Maps_TableName_To_Plural_Of_ObjectName() { //Arrange var mapper = new PetaPocoMapper(String.Empty); //Act var ti = mapper.GetTableInfo(typeof(Dog)); //Assert Assert.AreEqual(Constants.TABLENAME_Dog, ti.TableName); }
public void PetaPocoMapper_GetTableInfo_Returns_TableInfo() { //Arrange var mapper = new PetaPocoMapper(Constants.TABLENAME_Prefix); //Act var ti = mapper.GetTableInfo(typeof(Dog)); //Assert Assert.IsInstanceOf<TableInfo>(ti); }
public void PetaPocoMapper_GetColumnInfo_Returns_ColumnInfo() { //Arrange var mapper = new PetaPocoMapper(Constants.TABLENAME_Prefix); var dogType = typeof(Dog); var dogProperty = dogType.GetProperty(Constants.COLUMNNAME_Name); //Act var ci = mapper.GetColumnInfo(dogProperty); //Assert Assert.IsInstanceOf <ColumnInfo>(ci); }
public void PetaPocoMapper_GetColumnInfo_Maps_ColumnName_To_PropertyName_If_No_Attribute() { //Arrange var mapper = new PetaPocoMapper(Constants.TABLENAME_Prefix); var dogType = typeof(Dog); var dogProperty = dogType.GetProperty(Constants.COLUMNNAME_Name); //Act var ci = mapper.GetColumnInfo(dogProperty); //Assert Assert.AreEqual(Constants.COLUMNNAME_Name, ci.ColumnName); }
public void PetaPocoRepository_Get_Returns_All_Rows(int count) { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(count); var repository = new PetaPocoRepository <Dog>(db, mapper); //Act IEnumerable <Dog> dogs = repository.Get(); //Assert Assert.AreEqual(count, dogs.Count()); }
public void PetaPocoRepository_GetById_Returns_Null_If_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 var dog = repository.GetById(Constants.PETAPOCO_InvalidDogId); //Assert Assert.IsNull(dog); }
public void PetaPocoRepository_Find_Returns_Correct_Rows(int count, string sqlCondition, object arg) { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); //Act IEnumerable <Dog> dogs = repository.Find(sqlCondition, arg); //Assert Assert.AreEqual(count, dogs.Count()); }
public void PetaPocoRepository_GetPage_Overload_Returns_Page_Of_Rows(int pageIndex, int pageSize) { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PAGE_TotalCount); var repository = new PetaPocoRepository <Dog>(db, mapper); //Act var dogs = repository.GetPage(pageIndex, pageSize); //Assert Assert.AreEqual(pageSize, dogs.PageSize); }
public void PetaPocoRepository_GetById_Returns_Model_With_Correct_Properties() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); 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_GetPage_Overload_Returns_Correct_Page(int pageIndex, int pageSize, int firstId) { // Arrange var db = this.CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(string.Empty); DataUtil.SetUpDatabase(Constants.PAGE_TotalCount); var repository = new PetaPocoRepository <Dog>(db, mapper); // Act var dogs = repository.GetPage(pageIndex, pageSize); // Assert var dog = dogs.First(); Assert.AreEqual(firstId, dog.ID); }
public void PetaPocoRepository_Get_Returns_List_Of_Models() { // Arrange var db = this.CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(string.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); // Act var dogs = repository.Get().ToList(); // Assert for (int i = 0; i < dogs.Count(); i++) { Assert.IsInstanceOf <Dog>(dogs[i]); } }
public void PetaPocoRepository_GetPage_Overload_Returns_List_Of_Models() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PAGE_TotalCount); var repository = new PetaPocoRepository <Dog>(db, mapper); //Act var dogs = repository.GetPage(Constants.PAGE_First, Constants.PAGE_RecordCount); //Assert for (int i = 0; i < dogs.Count(); i++) { Assert.IsInstanceOf <Dog>(dogs[i]); } }
public void PetaPocoRepository_Update_Overload_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); //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 void PetaPocoRepository_GetPage_Overload_Returns_Models_With_Correct_Properties() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PAGE_TotalCount); var repository = new PetaPocoRepository <Dog>(db, mapper); //Act var dogs = repository.GetPage(Constants.PAGE_First, Constants.PAGE_RecordCount); //Assert var dog = dogs.First(); Assert.AreEqual(_dogAges[0], dog.Age.ToString()); Assert.AreEqual(_dogNames[0], dog.Name); }
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_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); }
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_GetPage_Overload_Returns_List_Of_Models() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PAGE_TotalCount); var repository = new PetaPocoRepository<Dog>(db, mapper); //Act var dogs = repository.GetPage(Constants.PAGE_First, Constants.PAGE_RecordCount); //Assert for (int i = 0; i < dogs.Count(); i++) { Assert.IsInstanceOf<Dog>(dogs[i]); } }
public void PetaPocoMapper_GetColumnInfo_Maps_ColumnName_To_PropertyName_If_No_Attribute() { //Arrange var mapper = new PetaPocoMapper(Constants.TABLENAME_Prefix); var dogType = typeof(Dog); var dogProperty = dogType.GetProperty(Constants.COLUMNNAME_Name); //Act var ci = mapper.GetColumnInfo(dogProperty); //Assert Assert.AreEqual(Constants.COLUMNNAME_Name, ci.ColumnName); }
public void PetaPocoMapper_Adds_Prefix_To_Plural_Of_ObjectName() { //Arrange var mapper = new PetaPocoMapper(Constants.TABLENAME_Prefix); //Act var ti = mapper.GetTableInfo(typeof(Dog)); //Assert Assert.AreEqual(Constants.TABLENAME_Prefix + Constants.TABLENAME_Dog, ti.TableName); }
public void PetaPocoMapper_Maps_TableName_To_Attribute() { //Arrange var mapper = new PetaPocoMapper(String.Empty); //Act var ti = mapper.GetTableInfo(typeof(Person)); //Assert Assert.AreEqual(Constants.TABLENAME_Person, ti.TableName); }
public void PetaPocoRepository_Update_Overload_Updates_Item_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.Update("SET Age=@1, Name=@2 WHERE ID=@0", Constants.PETAPOCO_UpdateDogId, Constants.PETAPOCO_UpdateDogAge, Constants.PETAPOCO_UpdateDogName); //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_GetById_Returns_Null_If_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 var dog = repository.GetById(Constants.PETAPOCO_InvalidDogId); //Assert Assert.IsNull(dog); }
public void PetaPocoMapper_Sets_AutoIncrement_To_True() { //Arrange var mapper = new PetaPocoMapper(String.Empty); //Act var ti = mapper.GetTableInfo(typeof(Dog)); //Assert Assert.IsTrue(ti.AutoIncrement); }
public void PetaPocoRepository_GetById_Returns_Model_With_Correct_Properties() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); 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_Find_Returns_Correct_Rows(int count, string sqlCondition, object arg) { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository<Dog>(db, mapper); //Act IEnumerable<Dog> dogs = repository.Find(sqlCondition, arg); //Assert Assert.AreEqual(count, dogs.Count()); }
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 PetaPocoMapper_Sets_PrimaryKey_To_ID_If_No_Attribute() { //Arrange var mapper = new PetaPocoMapper(String.Empty); //Act var ti = mapper.GetTableInfo(typeof(Dog)); //Assert Assert.AreEqual(Constants.TABLENAME_Key, ti.PrimaryKey); }
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_With_Correct_ColumnValues() { //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 DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); DataRow row = table.Rows[table.Rows.Count - 1]; Assert.AreEqual(Constants.PETAPOCO_InsertDogAge, row["Age"]); Assert.AreEqual(Constants.PETAPOCO_InsertDogName, row["Name"]); }
public void PetaPocoRepository_GetPage_Overload_Returns_Models_With_Correct_Properties() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PAGE_TotalCount); var repository = new PetaPocoRepository<Dog>(db, mapper); //Act var dogs = repository.GetPage(Constants.PAGE_First, Constants.PAGE_RecordCount); //Assert var dog = dogs.First(); Assert.AreEqual(_dogAges[0], dog.Age.ToString()); Assert.AreEqual(_dogNames[0], dog.Name); }
public void PetaPocoRepository_GetPage_Overload_Returns_Correct_Page(int pageIndex, int pageSize, int firstId) { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PAGE_TotalCount); var repository = new PetaPocoRepository<Dog>(db, mapper); //Act var dogs = repository.GetPage(pageIndex, pageSize); //Assert var dog = dogs.First(); Assert.AreEqual(firstId, dog.ID); }
public void PetaPocoMapper_GetColumnInfo_Returns_ColumnInfo() { //Arrange var mapper = new PetaPocoMapper(Constants.TABLENAME_Prefix); var dogType = typeof (Dog); var dogProperty = dogType.GetProperty(Constants.COLUMNNAME_Name); //Act var ci = mapper.GetColumnInfo(dogProperty); //Assert Assert.IsInstanceOf<ColumnInfo>(ci); }
public void PetaPocoRepository_Update_Overload_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); //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 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_Get_Returns_All_Rows(int count) { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(count); var repository = new PetaPocoRepository<Dog>(db, mapper); //Act IEnumerable<Dog> dogs = repository.Get(); //Assert Assert.AreEqual(count, dogs.Count()); }
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 PetaPocoMapper_Adds_Prefix_To_Attribute() { //Arrange var mapper = new PetaPocoMapper(Constants.TABLENAME_Prefix); //Act var ti = mapper.GetTableInfo(typeof(Person)); //Assert Assert.AreEqual(Constants.TABLENAME_Prefix + Constants.TABLENAME_Person, ti.TableName); }