public void Test_GentleList()
{
Role r1 = fixedRoles[1];
Role r2 = fixedRoles[3];
// create a user with a known id
u1 = new User("John", "Doe", Roles.Customer);
u1.Persist();
// create 1:n type list
GentleList list = new GentleList(typeof(UserRole), u1);
Assert.AreEqual(0, list.Count, "Relation table not empty.");
// verify add
list.Add(new UserRole(u1.Id, r1.Id));
Assert.AreEqual(1, list.Count, "No element in relation table.");
list.Add(new UserRole(u1.Id, r2.Id));
Assert.AreEqual(2, list.Count, "Wrong number of elements in relation table.");
// verify read upon create
list = new GentleList(typeof(UserRole), u1);
Assert.AreEqual(2, list.Count, "Elements in relation table was not automatically retrieved.");
// verify remove
list.Remove(list[0]);
Assert.AreEqual(1, list.Count, "Relation element was not removed from list.");
list.Remove(list[0]);
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_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_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_GentleList()
{
Role r1 = fixedRoles[ 1 ];
Role r2 = fixedRoles[ 3 ];
// create a user with a known id
u1 = new User( "John", "Doe", Roles.Customer );
u1.Persist();
// create 1:n type list
GentleList list = new GentleList( typeof(UserRole), u1 );
Assert.AreEqual( 0, list.Count, "Relation table not empty." );
// verify add
list.Add( new UserRole( u1.Id, r1.Id ) );
Assert.AreEqual( 1, list.Count, "No element in relation table." );
list.Add( new UserRole( u1.Id, r2.Id ) );
Assert.AreEqual( 2, list.Count, "Wrong number of elements in relation table." );
// verify read upon create
list = new GentleList( typeof(UserRole), u1 );
Assert.AreEqual( 2, list.Count, "Elements in relation table was not automatically retrieved." );
// verify remove
list.Remove( list[ 0 ] );
Assert.AreEqual( 1, list.Count, "Relation element was not removed from list." );
list.Remove( list[ 0 ] );
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();
}
