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