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);
}
