public void TestCRUD()
{
u1 = new User("Ford", "Prefect", Roles.Employee);
// insert
u1.Persist();
Assert.IsTrue(u1.Id != 0, "No id generated for the User just inserted!");
// select
u2 = new User(u1.Id);
// verify select/insert
Assert.IsTrue(u2.Id != 0, "The object could not be retrieved from the database!");
Assert.AreEqual(u1.Id, u2.Id, "The object could not be retrieved from the database!");
Assert.AreEqual("Ford", u2.FirstName, "The object was not properly retrieved on construction!");
// update
u2.FirstName = "Arthur";
u2.LastName = "Dent";
u2.PrimaryRole = Roles.Customer;
u2.Persist();
// verify update
u1 = new User(u2.Id);
Assert.AreEqual(u2.FirstName, u1.FirstName, "FirstName not updated!");
Assert.AreEqual(u2.LastName, u1.LastName, "LastName not updated!");
Assert.AreEqual(u2.PrimaryRole, u1.PrimaryRole, "PrimaryRole not updated!");
// delete
u2.Remove();
// verify delete by selecting the now non-existing row
try
{
u2 = new User(u1.Id);
Assert.IsNull(u2, "Object not removed");
}
catch (GentleException fe)
{
Assert.AreEqual(Error.UnexpectedRowCount, fe.Error, "Unexpected error occurred!");
}
}
public void Test_NtoM_WithExtraRelationColumn()
{
// create a user with a known id
u1 = new User("John", "Doe", Roles.Customer);
u1.Persist();
Role r1 = fixedRoles[2];
Assert.IsNotNull(u1, "Test case invalid unless a record with UserId=" + u1.Id + " exists");
Member m = Member.Retrieve(1);
// add role
u1.MemberRoles.Add(r1, m);
// verify UserRole table
IList relations = Broker.RetrieveList(typeof(UserRole));
Assert.AreEqual(1, relations.Count, "No relation created.");
UserRole ur = relations[0] as UserRole;
Assert.AreEqual(m.Id, ur.MemberId, "Relation did not save additional type reference.");
// remove role
u1.MemberRoles.Remove(r1);
// verify UserRole table
relations = Broker.RetrieveList(typeof(UserRole));
Assert.AreEqual(0, relations.Count, "Relation not removed.");
u1.Remove();
}
public void Test_GentleRelation()
{
Role r1 = fixedRoles[1];
// create a user with a known id
u1 = new User("John", "Doe", Roles.Customer);
u1.Persist();
// create 1:n type list
GentleRelation list = new GentleRelation(typeof(UserRole), u1, typeof(Role));
Assert.AreEqual(0, list.Count, "Relation table not empty.");
// verify add
list.Add(r1);
list.Add(fixedRoles[2]);
Assert.AreEqual(2, list.Count, "Wrong number of elements in relation table.");
// verify read upon create
list = new GentleRelation(typeof(UserRole), u1, typeof(Role));
Assert.AreEqual(2, list.Count, "Elements in relation table not automatically retrieved.");
// verify remove
list.Remove(r1);
Assert.AreEqual(1, list.Count, "Relation element was not removed from list.");
list.Remove(fixedRoles[2]);
Assert.AreEqual(0, list.Count, "Relation element was not removed from list.");
list = new GentleRelation(typeof(UserRole), u1, typeof(Role));
Assert.AreEqual(0, list.Count, "Relation element was not removed from database.");
u1.Remove();
}
public void Test_GentleListWithCaching()
{
// enable all caching
GentleSettings.CacheObjects = true;
GentleSettings.CacheStatements = true;
GentleSettings.SkipQueryExecution = true;
CacheManager.Clear();
// create a user with a known id
u1 = new User("John", "Doe", Roles.Customer);
u1.Persist();
// create n:m type list
GentleList list = new GentleList(typeof(Role), u1, typeof(UserRole));
Assert.AreEqual(0, list.Count, "Test requires that tables are initially empty.");
// verify add
Role r1 = new Role(0, "Role 1");
r1.Persist();
list.Add(r1);
Assert.AreEqual(1, list.Count, "No element in relation table.");
Role r2 = new Role(0, "Role 2");
r2.Persist();
list.Add(r2);
Assert.AreEqual(2, list.Count, "Wrong number of elements in relation table.");
// verify read upon create
list = new GentleList(typeof(Role), u1, typeof(UserRole));
Assert.AreEqual(2, list.Count, "Elements in relation table were not automatically retrieved.");
// verify remove
list.Remove(r1);
Assert.AreEqual(1, list.Count, "Element was not removed from list.");
// verify add after remove
Role r3 = new Role(0, "Role 3");
r3.Persist();
list.Add(r3);
Assert.AreEqual(2, list.Count, "Wrong number of elements in relation table.");
// remove remaining elements
list.Remove(r2);
list.Remove(r3);
Assert.AreEqual(0, list.Count, "Relation element was not removed from list.");
list = new GentleList(typeof(UserRole), u1);
Assert.AreEqual(0, list.Count, "Relation element was not removed from database.");
u1.Remove();
}
public void Test_NtoM()
{
// create a user with a known id
u1 = new User("John", "Doe", Roles.Customer);
u1.Persist();
Role r1 = fixedRoles[2];
Assert.IsNotNull(u1, "Test case invalid unless a record with UserId=" + u1.Id + " exists");
// add role
u1.Roles.Add(r1);
// verify UserRole table
IList relations = Broker.RetrieveList(typeof(UserRole));
Assert.AreEqual(1, relations.Count, "No relation created.");
// remove role
u1.Roles.Remove(r1);
// verify UserRole table
relations = Broker.RetrieveList(typeof(UserRole));
Assert.AreEqual(0, relations.Count, "Relation not removed.");
u1.Remove();
}
public void Test_AutoRead()
{
// create a user with a known id
u1 = new User("John", "Doe", Roles.Customer);
u1.Persist();
Role r1 = fixedRoles[1];
Role r2 = fixedRoles[2];
// add a role (will insert the userrole relation)
Assert.AreEqual(0, u1.Roles.Count, "Roles list be empty when starting out.");
u1.Roles.Add(r1);
Assert.AreEqual(1, u1.Roles.Count, "Roles list must contain an entry after calling Add.");
u1.Roles.Add(r2);
Assert.AreEqual(2, u1.Roles.Count, "Roles list must contain an entry after calling Add.");
// read user 1 again
u2 = new User(u1.Id);
Assert.AreEqual(u1.Roles.Count, u2.Roles.Count, "Roles not auto-populated during list creation.");
// verify UserRole table
IList relations = Broker.RetrieveList(typeof(UserRole));
Assert.AreEqual(2, relations.Count, "Relations not added.");
// add the same role again
//u2.Roles.Add( r1 );
//u1 = new User( 1 );
//Assert.AreEqual( 1, u1.Roles.Count, "Roles was added twice - no duplicate filtering." );
// remove role
u1.Roles.Remove(r1);
u1 = new User(u1.Id);
Assert.AreEqual(1, u1.Roles.Count, "Role not removed.");
// remove role
u1.Roles.Remove(r2);
u1 = new User(u1.Id);
Assert.AreEqual(0, u1.Roles.Count, "Role not removed.");
// verify UserRole table
relations = Broker.RetrieveList(typeof(UserRole));
Assert.AreEqual(0, relations.Count, "Relations not removed.");
u1.Remove();
}
public void TestCRUD()
{
u1 = new User( "Ford", "Prefect", Roles.Employee );
// insert
u1.Persist();
Assert.IsTrue( u1.Id != 0, "No id generated for the User just inserted!" );
// select
u2 = new User( u1.Id );
// verify select/insert
Assert.IsTrue( u2.Id != 0, "The object could not be retrieved from the database!" );
Assert.AreEqual( u1.Id, u2.Id, "The object could not be retrieved from the database!" );
Assert.AreEqual( "Ford", u2.FirstName, "The object was not properly retrieved on construction!" );
// update
u2.FirstName = "Arthur";
u2.LastName = "Dent";
u2.PrimaryRole = Roles.Customer;
u2.Persist();
// verify update
u1 = new User( u2.Id );
Assert.AreEqual( u2.FirstName, u1.FirstName, "FirstName not updated!" );
Assert.AreEqual( u2.LastName, u1.LastName, "LastName not updated!" );
Assert.AreEqual( u2.PrimaryRole, u1.PrimaryRole, "PrimaryRole not updated!" );
// delete
u2.Remove();
// verify delete by selecting the now non-existing row
try
{
u2 = new User( u1.Id );
Assert.IsNull( u2, "Object not removed" );
}
catch( GentleException fe )
{
Assert.AreEqual( Error.UnexpectedRowCount, fe.Error, "Unexpected error occurred!" );
}
}
public void Test_GentleListWithCaching()
{
// enable all caching
GentleSettings.CacheObjects = true;
GentleSettings.CacheStatements = true;
GentleSettings.SkipQueryExecution = true;
CacheManager.Clear();
// create a user with a known id
u1 = new User( "John", "Doe", Roles.Customer );
u1.Persist();
// create n:m type list
GentleList list = new GentleList( typeof(Role), u1, typeof(UserRole) );
Assert.AreEqual( 0, list.Count, "Test requires that tables are initially empty." );
// verify add
Role r1 = new Role( 0, "Role 1" );
r1.Persist();
list.Add( r1 );
Assert.AreEqual( 1, list.Count, "No element in relation table." );
Role r2 = new Role( 0, "Role 2" );
r2.Persist();
list.Add( r2 );
Assert.AreEqual( 2, list.Count, "Wrong number of elements in relation table." );
// verify read upon create
list = new GentleList( typeof(Role), u1, typeof(UserRole) );
Assert.AreEqual( 2, list.Count, "Elements in relation table were not automatically retrieved." );
// verify remove
list.Remove( r1 );
Assert.AreEqual( 1, list.Count, "Element was not removed from list." );
// verify add after remove
Role r3 = new Role( 0, "Role 3" );
r3.Persist();
list.Add( r3 );
Assert.AreEqual( 2, list.Count, "Wrong number of elements in relation table." );
// remove remaining elements
list.Remove( r2 );
list.Remove( r3 );
Assert.AreEqual( 0, list.Count, "Relation element was not removed from list." );
list = new GentleList( typeof(UserRole), u1 );
Assert.AreEqual( 0, list.Count, "Relation element was not removed from database." );
u1.Remove();
}
public void Test_AutoRead()
{
// create a user with a known id
u1 = new User( "John", "Doe", Roles.Customer );
u1.Persist();
Role r1 = fixedRoles[ 1 ];
Role r2 = fixedRoles[ 2 ];
// add a role (will insert the userrole relation)
Assert.AreEqual( 0, u1.Roles.Count, "Roles list be empty when starting out." );
u1.Roles.Add( r1 );
Assert.AreEqual( 1, u1.Roles.Count, "Roles list must contain an entry after calling Add." );
u1.Roles.Add( r2 );
Assert.AreEqual( 2, u1.Roles.Count, "Roles list must contain an entry after calling Add." );
// read user 1 again
u2 = new User( u1.Id );
Assert.AreEqual( u1.Roles.Count, u2.Roles.Count, "Roles not auto-populated during list creation." );
// verify UserRole table
IList relations = Broker.RetrieveList( typeof(UserRole) );
Assert.AreEqual( 2, relations.Count, "Relations not added." );
// add the same role again
//u2.Roles.Add( r1 );
//u1 = new User( 1 );
//Assert.AreEqual( 1, u1.Roles.Count, "Roles was added twice - no duplicate filtering." );
// remove role
u1.Roles.Remove( r1 );
u1 = new User( u1.Id );
Assert.AreEqual( 1, u1.Roles.Count, "Role not removed." );
// remove role
u1.Roles.Remove( r2 );
u1 = new User( u1.Id );
Assert.AreEqual( 0, u1.Roles.Count, "Role not removed." );
// verify UserRole table
relations = Broker.RetrieveList( typeof(UserRole) );
Assert.AreEqual( 0, relations.Count, "Relations not removed." );
u1.Remove();
}
public void Test_NtoM_WithExtraRelationColumn()
{
// create a user with a known id
u1 = new User( "John", "Doe", Roles.Customer );
u1.Persist();
Role r1 = fixedRoles[ 2 ];
Assert.IsNotNull( u1, "Test case invalid unless a record with UserId=" + u1.Id + " exists" );
Member m = Member.Retrieve( 1 );
// add role
u1.MemberRoles.Add( r1, m );
// verify UserRole table
IList relations = Broker.RetrieveList( typeof(UserRole) );
Assert.AreEqual( 1, relations.Count, "No relation created." );
UserRole ur = relations[ 0 ] as UserRole;
Assert.AreEqual( m.Id, ur.MemberId, "Relation did not save additional type reference." );
// remove role
u1.MemberRoles.Remove( r1 );
// verify UserRole table
relations = Broker.RetrieveList( typeof(UserRole) );
Assert.AreEqual( 0, relations.Count, "Relation not removed." );
u1.Remove();
}
public void Test_NtoM()
{
// create a user with a known id
u1 = new User( "John", "Doe", Roles.Customer );
u1.Persist();
Role r1 = fixedRoles[ 2 ];
Assert.IsNotNull( u1, "Test case invalid unless a record with UserId=" + u1.Id + " exists" );
// add role
u1.Roles.Add( r1 );
// verify UserRole table
IList relations = Broker.RetrieveList( typeof(UserRole) );
Assert.AreEqual( 1, relations.Count, "No relation created." );
// remove role
u1.Roles.Remove( r1 );
// verify UserRole table
relations = Broker.RetrieveList( typeof(UserRole) );
Assert.AreEqual( 0, relations.Count, "Relation not removed." );
u1.Remove();
}
public void Test_GentleRelation()
{
Role r1 = fixedRoles[ 1 ];
// create a user with a known id
u1 = new User( "John", "Doe", Roles.Customer );
u1.Persist();
// create 1:n type list
GentleRelation list = new GentleRelation( typeof(UserRole), u1, typeof(Role) );
Assert.AreEqual( 0, list.Count, "Relation table not empty." );
// verify add
list.Add( r1 );
list.Add( fixedRoles[ 2 ] );
Assert.AreEqual( 2, list.Count, "Wrong number of elements in relation table." );
// verify read upon create
list = new GentleRelation( typeof(UserRole), u1, typeof(Role) );
Assert.AreEqual( 2, list.Count, "Elements in relation table not automatically retrieved." );
// verify remove
list.Remove( r1 );
Assert.AreEqual( 1, list.Count, "Relation element was not removed from list." );
list.Remove( fixedRoles[ 2 ] );
Assert.AreEqual( 0, list.Count, "Relation element was not removed from list." );
list = new GentleRelation( typeof(UserRole), u1, typeof(Role) );
Assert.AreEqual( 0, list.Count, "Relation element was not removed from database." );
u1.Remove();
}
