public void Subselect()
{
Student gavin = null;
Enrolment enrolment = null;
using (ISession s = OpenSession())
using (ITransaction t = s.BeginTransaction())
{
Course course = new Course();
course.CourseCode = "HIB";
course.Description = "Hibernate Training";
s.Persist(course);
Course coursePreferred = new Course();
coursePreferred.CourseCode = "JBOSS";
coursePreferred.Description = "JBoss";
s.Persist(coursePreferred);
gavin = new Student();
gavin.Name = "Gavin King";
gavin.StudentNumber = 232;
gavin.PreferredCourse = coursePreferred;
s.Persist(gavin);
enrolment = new Enrolment();
enrolment.Course = course;
enrolment.CourseCode = course.CourseCode;
enrolment.Semester = 3;
enrolment.Year = 1998;
enrolment.Student = gavin;
enrolment.StudentNumber = gavin.StudentNumber;
gavin.Enrolments.Add(enrolment);
s.Persist(enrolment);
t.Commit();
}
using (ISession s = OpenSession())
using (ITransaction t = s.BeginTransaction())
{
DetachedCriteria dc = NHibernate.Criterion.DetachedCriteria.For<Student>()
.Add(Property.ForName("StudentNumber").Eq(232L))
.SetProjection(Property.ForName("Name"));
gavin = s.CreateCriteria<Student>()
.Add(Subqueries.Exists(dc))
.SetReadOnly(true)
.UniqueResult<Student>();
Assert.That(s.DefaultReadOnly, Is.False);
Assert.That(s.IsReadOnly(gavin), Is.True);
Assert.That(NHibernateUtil.IsInitialized(gavin.PreferredCourse), Is.False);
CheckProxyReadOnly(s, gavin.PreferredCourse, true);
Assert.That(NHibernateUtil.IsInitialized(gavin.PreferredCourse), Is.False);
NHibernateUtil.Initialize(gavin.PreferredCourse);
Assert.That(NHibernateUtil.IsInitialized(gavin.PreferredCourse), Is.True);
CheckProxyReadOnly(s, gavin.PreferredCourse, true);
Assert.That(NHibernateUtil.IsInitialized(gavin.Enrolments), Is.False);
NHibernateUtil.Initialize(gavin.Enrolments);
Assert.That(NHibernateUtil.IsInitialized(gavin.Enrolments), Is.True);
Assert.That(gavin.Enrolments.Count, Is.EqualTo(1));
IEnumerator<Enrolment> enrolments = gavin.Enrolments.GetEnumerator();
enrolments.MoveNext();
enrolment = enrolments.Current;
Assert.That(s.IsReadOnly(enrolment), Is.False);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Course), Is.False);
CheckProxyReadOnly(s, enrolment.Course, false);
NHibernateUtil.Initialize(enrolment.Course);
CheckProxyReadOnly(s, enrolment.Course, false);
t.Commit();
}
using (ISession s = OpenSession())
using (ITransaction t = s.BeginTransaction())
{
DetachedCriteria dc = NHibernate.Criterion.DetachedCriteria.For<Student>("st")
.Add(Property.ForName("st.StudentNumber").EqProperty("e.StudentNumber"))
.SetProjection(Property.ForName("Name"));
enrolment = s.CreateCriteria<Enrolment>("e")
.Add(Subqueries.Eq("Gavin King", dc))
.SetReadOnly(true)
.UniqueResult<Enrolment>();
Assert.That(s.IsReadOnly(enrolment), Is.True);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Course), Is.False);
CheckProxyReadOnly(s, enrolment.Course, true);
NHibernateUtil.Initialize(enrolment.Course);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Course), Is.True);
CheckProxyReadOnly(s, enrolment.Course, true);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Student), Is.False);
CheckProxyReadOnly(s, enrolment.Student, true);
NHibernateUtil.Initialize(enrolment.Student);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Student), Is.True);
CheckProxyReadOnly(s, enrolment.Student, true);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Student.PreferredCourse), Is.False);
CheckProxyReadOnly(s, enrolment.Student.PreferredCourse, false);
NHibernateUtil.Initialize(enrolment.Student.PreferredCourse);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Student.PreferredCourse), Is.True);
CheckProxyReadOnly(s, enrolment.Student.PreferredCourse, false);
t.Commit();
}
using (ISession s = OpenSession())
using (ITransaction t = s.BeginTransaction())
{
DetachedCriteria dc = NHibernate.Criterion.DetachedCriteria.For<Student>("st")
.CreateCriteria("Enrolments")
.CreateCriteria("Course")
.Add(Property.ForName("Description").Eq("Hibernate Training"))
.SetProjection(Property.ForName("st.Name"));
enrolment = s.CreateCriteria<Enrolment>("e")
.Add(Subqueries.Eq("Gavin King", dc))
.SetReadOnly(true)
.UniqueResult<Enrolment>();
Assert.That(s.IsReadOnly(enrolment), Is.True);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Course), Is.False);
CheckProxyReadOnly(s, enrolment.Course, true);
NHibernateUtil.Initialize(enrolment.Course);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Course), Is.True);
CheckProxyReadOnly(s, enrolment.Course, true);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Student), Is.False);
CheckProxyReadOnly(s, enrolment.Student, true);
NHibernateUtil.Initialize(enrolment.Student);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Student), Is.True);
CheckProxyReadOnly(s, enrolment.Student, true);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Student.PreferredCourse), Is.False);
CheckProxyReadOnly(s, enrolment.Student.PreferredCourse, false);
NHibernateUtil.Initialize(enrolment.Student.PreferredCourse);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Student.PreferredCourse), Is.True);
CheckProxyReadOnly(s, enrolment.Student.PreferredCourse, false);
t.Commit();
}
using (ISession s = OpenSession())
using (ITransaction t = s.BeginTransaction())
{
s.Delete(gavin.PreferredCourse);
s.Delete(gavin);
s.Delete(gavin.Enrolments.First().Course);
s.Delete(gavin.Enrolments.First());
t.Commit();
}
}
private void DefaultTestSetup()
{
using (ISession s = OpenSession())
using (ITransaction t = s.BeginTransaction())
{
Course course = new Course();
course.CourseCode = "HIB";
course.Description = "Hibernate Training";
s.Persist(course);
Course coursePreferred = new Course();
coursePreferred.CourseCode = "JBOSS";
coursePreferred.Description = "JBoss";
s.Persist(coursePreferred);
Student gavin = new Student();
gavin.Name = "Gavin King";
gavin.StudentNumber = 232;
gavin.PreferredCourse = coursePreferred;
s.Persist(gavin);
Enrolment enrolment = new Enrolment();
enrolment.Course = course;
enrolment.CourseCode = course.CourseCode;
enrolment.Semester = 3;
enrolment.Year = 1998;
enrolment.Student = gavin;
enrolment.StudentNumber = gavin.StudentNumber;
gavin.Enrolments.Add(enrolment);
s.Persist(enrolment);
t.Commit();
}
}
public void ModifiableCriteriaReturnsExistingReadOnlyProxyInit()
{
Course coursePreferred = null;
using (ISession s = OpenSession())
using (ITransaction t = s.BeginTransaction())
{
Course course = new Course();
course.CourseCode = "HIB";
course.Description = "Hibernate Training";
s.Persist(course);
coursePreferred = new Course();
coursePreferred.CourseCode = "JBOSS";
coursePreferred.Description = "JBoss";
s.Persist(coursePreferred);
Student gavin = new Student();
gavin.Name = "Gavin King";
gavin.StudentNumber = 232;
gavin.PreferredCourse = coursePreferred;
s.Persist(gavin);
Enrolment enrolment = new Enrolment();
enrolment.Course = course;
enrolment.CourseCode = course.CourseCode;
enrolment.Semester = 3;
enrolment.Year = 1998;
enrolment.Student = gavin;
enrolment.StudentNumber = gavin.StudentNumber;
gavin.Enrolments.Add(enrolment);
s.Persist(enrolment);
t.Commit();
}
using (ISession s = OpenSession())
using (ITransaction t = s.BeginTransaction())
{
Assert.That(s.DefaultReadOnly, Is.False);
coursePreferred = s.Load<Course>(coursePreferred.CourseCode);
Assert.That(NHibernateUtil.IsInitialized(coursePreferred), Is.False);
CheckProxyReadOnly(s, coursePreferred, false);
NHibernateUtil.Initialize(coursePreferred);
CheckProxyReadOnly(s, coursePreferred, false);
s.SetReadOnly(coursePreferred, true);
CheckProxyReadOnly(s, coursePreferred, true);
ICriteria criteria = s.CreateCriteria<Student>().SetReadOnly(false);
Assert.That(criteria.IsReadOnlyInitialized, Is.True);
Assert.That(criteria.IsReadOnly, Is.False);
Student gavin = criteria.UniqueResult<Student>();
Assert.That(s.DefaultReadOnly, Is.False);
Assert.That(criteria.IsReadOnlyInitialized, Is.True);
Assert.That(criteria.IsReadOnly, Is.False);
Assert.That(s.IsReadOnly(gavin), Is.False);
Assert.That(NHibernateUtil.IsInitialized(coursePreferred), Is.True);
CheckProxyReadOnly(s, coursePreferred, true);
Assert.That(NHibernateUtil.IsInitialized(gavin.Enrolments), Is.False);
NHibernateUtil.Initialize(gavin.Enrolments);
Assert.That(NHibernateUtil.IsInitialized(gavin.Enrolments), Is.True);
Assert.That(gavin.Enrolments.Count, Is.EqualTo(1));
IEnumerator<Enrolment> enrolments = gavin.Enrolments.GetEnumerator();
enrolments.MoveNext();
Enrolment enrolment = enrolments.Current;
Assert.That(s.IsReadOnly(enrolment), Is.False);
Assert.That(NHibernateUtil.IsInitialized(enrolment.Course), Is.False);
CheckProxyReadOnly(s, enrolment.Course, false);
NHibernateUtil.Initialize(enrolment.Course);
CheckProxyReadOnly(s, enrolment.Course, false);
s.Delete(gavin.PreferredCourse);
s.Delete(gavin);
s.Delete(enrolment.Course);
s.Delete(enrolment);
t.Commit();
}
}
public void TwoAliasesCache()
{
ISession s = OpenSession();
ITransaction t = s.BeginTransaction();
Course course = new Course();
course.CourseCode = "HIB";
course.Description = "Hibernate Training";
s.Save(course);
Student gavin = new Student();
gavin.Name = "Gavin King";
gavin.StudentNumber = 666;
s.Save(gavin);
Student xam = new Student();
xam.Name = "Max Rydahl Andersen";
xam.StudentNumber = 101;
s.Save(xam);
Enrolment enrolment1 = new Enrolment();
enrolment1.Course = course;
enrolment1.CourseCode = course.CourseCode;
enrolment1.Semester = 1;
enrolment1.Year = 1999;
enrolment1.Student = xam;
enrolment1.StudentNumber = xam.StudentNumber;
xam.Enrolments.Add(enrolment1);
s.Save(enrolment1);
Enrolment enrolment2 = new Enrolment();
enrolment2.Course = course;
enrolment2.CourseCode = course.CourseCode;
enrolment2.Semester = 3;
enrolment2.Year = 1998;
enrolment2.Student = gavin;
enrolment2.StudentNumber = gavin.StudentNumber;
gavin.Enrolments.Add(enrolment2);
s.Save(enrolment2);
t.Commit();
s.Close();
s = OpenSession();
t = s.BeginTransaction();
IList list = s.CreateCriteria<Enrolment>()
.CreateAlias("Student", "s")
.CreateAlias("Course", "c")
.Add(Restrictions.IsNotEmpty("s.Enrolments"))
.SetCacheable(true)
.SetReadOnly(true)
.List();
Assert.That(list.Count, Is.EqualTo(2));
Enrolment e = (Enrolment)list[0];
if (e.Student.StudentNumber == xam.StudentNumber)
{
enrolment1 = e;
enrolment2 = (Enrolment)list[1];
}
else if (e.Student.StudentNumber == xam.StudentNumber)
{
enrolment2 = e;
enrolment1 = (Enrolment)list[1];
}
else
{
Assert.Fail("Enrolment has unknown student number: " + e.Student.StudentNumber);
}
Assert.That(s.IsReadOnly(enrolment1), Is.True);
Assert.That(s.IsReadOnly(enrolment2), Is.True);
Assert.That(s.IsReadOnly(enrolment1.Course), Is.True);
Assert.That(s.IsReadOnly(enrolment2.Course), Is.True);
Assert.That(enrolment1.Course, Is.SameAs(enrolment2.Course));
Assert.That(s.IsReadOnly(enrolment1.Student), Is.True);
Assert.That(s.IsReadOnly(enrolment2.Student), Is.True);
t.Commit();
s.Close();
s = OpenSession();
t = s.BeginTransaction();
list = s.CreateCriteria<Enrolment>()
.CreateAlias("Student", "s")
.CreateAlias("Course", "c")
.SetReadOnly(true)
.Add(Restrictions.IsNotEmpty("s.Enrolments"))
.SetCacheable(true)
.SetReadOnly(true)
.List();
Assert.That(list.Count, Is.EqualTo(2));
e = (Enrolment)list[0];
if (e.Student.StudentNumber == xam.StudentNumber)
{
enrolment1 = e;
enrolment2 = (Enrolment)list[1];
}
else if (e.Student.StudentNumber == xam.StudentNumber) {
enrolment2 = e;
enrolment1 = (Enrolment)list[1];
}
else
{
Assert.Fail("Enrolment has unknown student number: " + e.Student.StudentNumber);
}
Assert.That(s.IsReadOnly(enrolment1), Is.True);
Assert.That(s.IsReadOnly(enrolment2), Is.True);
Assert.That(s.IsReadOnly(enrolment1.Course), Is.True);
Assert.That(s.IsReadOnly(enrolment2.Course), Is.True);
Assert.That(enrolment1.Course, Is.SameAs(enrolment2.Course));
Assert.That(s.IsReadOnly(enrolment1.Student), Is.True);
Assert.That(s.IsReadOnly(enrolment2.Student), Is.True);
t.Commit();
s.Close();
s = OpenSession();
t = s.BeginTransaction();
list = s.CreateCriteria<Enrolment>()
.SetReadOnly(true)
.CreateAlias("Student", "s")
.CreateAlias("Course", "c")
.Add(Restrictions.IsNotEmpty("s.Enrolments"))
.SetCacheable(true)
.List();
Assert.That(list.Count, Is.EqualTo(2));
e = (Enrolment)list[0];
if (e.Student.StudentNumber == xam.StudentNumber)
{
enrolment1 = e;
enrolment2 = (Enrolment)list[1];
}
else if (e.Student.StudentNumber == xam.StudentNumber)
{
enrolment2 = e;
enrolment1 = (Enrolment)list[1];
}
else
{
Assert.Fail("Enrolment has unknown student number: " + e.Student.StudentNumber);
}
Assert.That(s.IsReadOnly(enrolment1), Is.True);
Assert.That(s.IsReadOnly(enrolment2), Is.True);
Assert.That(s.IsReadOnly(enrolment1.Course), Is.True);
Assert.That(s.IsReadOnly(enrolment2.Course), Is.True);
Assert.That(enrolment1.Course, Is.SameAs(enrolment2.Course));
Assert.That(s.IsReadOnly(enrolment1.Student), Is.True);
Assert.That(s.IsReadOnly(enrolment2.Student), Is.True);
s.Delete(enrolment1);
s.Delete(enrolment2);
s.Delete(enrolment1.Course);
s.Delete(enrolment1.Student);
s.Delete(enrolment2.Student);
t.Commit();
s.Close();
}
