public void TestCRUD()
{
// skip test if picture data was not read (check the PATH constant above!)
if (runTest && picture != null)
{
mp1 = new MemberPicture(picture, 1);
// insert
mp1.Persist();
Assert.AreEqual(mp1.MemberId, 1, "The object was not properly inserted!");
Assert.AreEqual(GetSize(mp1.Picture), pictureSize, "The object was not properly inserted!");
// select
mp2 = MemberPicture.Retrieve(mp1.Id);
// verify select/insert
Assert.IsNotNull(mp2.Id, "The object could not be retrieved from the database!");
Assert.AreEqual(mp1.Id, mp2.Id, "The object could not be retrieved from the database!");
Assert.AreEqual(pictureSize, GetSize(mp2.Picture), "The object was not properly retrieved on construction!");
Assert.AreEqual(mp1.MemberId, mp2.MemberId,
"The object was not properly retrieved on construction!");
// update
mp2.MemberId = 2;
mp2.Persist();
// verify update
mp1 = MemberPicture.Retrieve(mp2.Id);
Assert.AreEqual(mp2.MemberId, mp1.MemberId, "MemberId not updated!");
// delete
mp2.Remove();
// verify delete by counting the number of rows
SqlBuilder sb = new SqlBuilder(StatementType.Count, typeof(MemberPicture));
sb.AddConstraint(Operator.Equals, "Id", mp1.Id);
SqlResult sr = Broker.Execute(sb.GetStatement(true));
Assert.AreEqual(0, sr.Count, "Object not removed");
}
}
public void TestCRUD()
{
// skip test if picture data was not read (check the PATH constant above!)
if( runTest && picture != null )
{
mp1 = new MemberPicture( picture, 1 );
// insert
mp1.Persist();
Assert.AreEqual( mp1.MemberId, 1, "The object was not properly inserted!" );
Assert.AreEqual( GetSize( mp1.Picture ), pictureSize, "The object was not properly inserted!" );
// select
mp2 = MemberPicture.Retrieve( mp1.Id );
// verify select/insert
Assert.IsNotNull( mp2.Id, "The object could not be retrieved from the database!" );
Assert.AreEqual( mp1.Id, mp2.Id, "The object could not be retrieved from the database!" );
Assert.AreEqual( pictureSize, GetSize( mp2.Picture ), "The object was not properly retrieved on construction!" );
Assert.AreEqual( mp1.MemberId, mp2.MemberId,
"The object was not properly retrieved on construction!" );
// update
mp2.MemberId = 2;
mp2.Persist();
// verify update
mp1 = MemberPicture.Retrieve( mp2.Id );
Assert.AreEqual( mp2.MemberId, mp1.MemberId, "MemberId not updated!" );
// delete
mp2.Remove();
// verify delete by counting the number of rows
SqlBuilder sb = new SqlBuilder( StatementType.Count, typeof(MemberPicture) );
sb.AddConstraint( Operator.Equals, "Id", mp1.Id );
SqlResult sr = Broker.Execute( sb.GetStatement( true ) );
Assert.AreEqual( 0, sr.Count, "Object not removed" );
}
}
