public async Task HqlClassKeywordAsync()
{
// test the Save
ISession s = OpenSession();
ITransaction t = s.BeginTransaction();
int oneId;
int baseId;
SubclassOne one1 = new SubclassOne();
one1.TestDateTime = new DateTime(2003, 10, 17);
one1.TestString = "the test one string";
one1.TestLong = 6;
one1.OneTestLong = 1;
oneId = (int)await(s.SaveAsync(one1));
SubclassBase base1 = new SubclassBase();
base1.TestDateTime = new DateTime(2003, 10, 17);
base1.TestString = "the test string";
base1.TestLong = 5;
baseId = (int)await(s.SaveAsync(base1));
await(t.CommitAsync());
s.Close();
s = OpenSession();
IList list = await(s.CreateQuery("from SubclassBase as sb where sb.class=SubclassBase").ListAsync());
Assert.AreEqual(1, list.Count);
Assert.AreEqual(typeof(SubclassBase), list[0].GetType(), "should be base");
list = await(s.CreateQuery("from SubclassBase as sb where sb.class=SubclassOne").ListAsync());
Assert.AreEqual(1, list.Count);
Assert.AreEqual(typeof(SubclassOne), list[0].GetType(), "should be one");
s.Close();
s = OpenSession();
await(s.DeleteAsync(one1));
await(s.DeleteAsync(base1));
await(s.FlushAsync());
s.Close();
}
public void Learn_SubclassBehavior()
{
using (ISession s = OpenSession())
using (ITransaction tx = s.BeginTransaction())
{
SubclassOne one = new SubclassOne();
one.TestDateTime = DateTime.Now;
s.Save(one);
s.Flush();
s.Clear();
SubclassOne result = (SubclassOne) s.Get(typeof (SubclassBase), one.Id);
Assert.IsNotNull(result);
Assert.IsTrue(result is SubclassOne);
s.Delete(result);
tx.Commit();
}
}
internal static void AreEqual(SubclassOne expected, SubclassOne actual)
{
AreEqual( (SubclassBase)expected, (SubclassBase)actual );
Assert.AreEqual( expected.OneTestLong, actual.OneTestLong );
}
public void TestCRUD()
{
// test the Save
ISession s1 = OpenSession();
ITransaction t1 = s1.BeginTransaction();
int oneId;
int baseId;
SubclassOne one1 = new SubclassOne();
one1.TestDateTime = new DateTime(2003, 10, 17);
one1.TestString = "the test one string";
one1.TestLong = 6;
one1.OneTestLong = 1;
oneId = (int) s1.Save(one1);
SubclassBase base1 = new SubclassBase();
base1.TestDateTime = new DateTime(2003, 10, 17);
base1.TestString = "the test string";
base1.TestLong = 5;
baseId = (int) s1.Save(base1);
t1.Commit();
s1.Close();
// lets verify the correct classes were saved
ISession s2 = OpenSession();
ITransaction t2 = s2.BeginTransaction();
// perform a load based on the base class
SubclassBase base2 = (SubclassBase) s2.Load(typeof(SubclassBase), baseId);
SubclassBase oneBase2 = (SubclassBase) s2.Load(typeof(SubclassBase), oneId);
// do some quick checks to make sure s2 loaded an object with the same data as s2 saved.
SubclassAssert.AreEqual(base1, base2);
// the object with id=2 was loaded using the base class - lets make sure it actually loaded
// the subclass
SubclassOne one2 = oneBase2 as SubclassOne;
Assert.IsNotNull(one2);
// lets update the objects
base2.TestString = "Did it get updated";
// update the properties from the subclass and base class
one2.TestString = "Updated SubclassOne String";
one2.OneTestLong = 21;
// save it through the base class reference and make sure that the
// subclass properties get updated.
s2.Update(base2);
s2.Update(oneBase2);
t2.Commit();
s2.Close();
// lets test the Criteria interface for subclassing
ISession s3 = OpenSession();
ITransaction t3 = s3.BeginTransaction();
IList results3 = s3.CreateCriteria(typeof(SubclassBase))
.Add(Expression.In("TestString", new string[] {"Did it get updated", "Updated SubclassOne String"}))
.List();
Assert.AreEqual(2, results3.Count);
SubclassBase base3 = null;
SubclassOne one3 = null;
foreach (SubclassBase obj in results3)
{
if (obj is SubclassOne)
one3 = (SubclassOne) obj;
else
base3 = obj;
}
// verify the properties got updated
SubclassAssert.AreEqual(base2, base3);
SubclassAssert.AreEqual(one2, one3);
s3.Delete(base3);
s3.Delete(one3);
t3.Commit();
s3.Close();
}
public void HqlClassKeyword()
{
// test the Save
ISession s = OpenSession();
ITransaction t = s.BeginTransaction();
int oneId;
int baseId;
SubclassOne one1 = new SubclassOne();
one1.TestDateTime = new DateTime(2003, 10, 17);
one1.TestString = "the test one string";
one1.TestLong = 6;
one1.OneTestLong = 1;
oneId = (int) s.Save(one1);
SubclassBase base1 = new SubclassBase();
base1.TestDateTime = new DateTime(2003, 10, 17);
base1.TestString = "the test string";
base1.TestLong = 5;
baseId = (int) s.Save(base1);
t.Commit();
s.Close();
s = OpenSession();
IList list = s.CreateQuery("from SubclassBase as sb where sb.class=SubclassBase").List();
Assert.AreEqual(1, list.Count);
Assert.AreEqual(typeof(SubclassBase), list[0].GetType(), "should be base");
list = s.CreateQuery("from SubclassBase as sb where sb.class=SubclassOne").List();
Assert.AreEqual(1, list.Count);
Assert.AreEqual(typeof(SubclassOne), list[0].GetType(), "should be one");
s.Close();
s = OpenSession();
s.Delete(one1);
s.Delete(base1);
s.Flush();
s.Close();
}
public async Task TestCRUDAsync()
{
// test the Save
ISession s1 = OpenSession();
ITransaction t1 = s1.BeginTransaction();
int oneId;
int baseId;
SubclassOne one1 = new SubclassOne();
one1.TestDateTime = new DateTime(2003, 10, 17);
one1.TestString = "the test one string";
one1.TestLong = 6;
one1.OneTestLong = 1;
oneId = (int)await(s1.SaveAsync(one1));
SubclassBase base1 = new SubclassBase();
base1.TestDateTime = new DateTime(2003, 10, 17);
base1.TestString = "the test string";
base1.TestLong = 5;
baseId = (int)await(s1.SaveAsync(base1));
await(t1.CommitAsync());
s1.Close();
// lets verify the correct classes were saved
ISession s2 = OpenSession();
ITransaction t2 = s2.BeginTransaction();
// perform a load based on the base class
SubclassBase base2 = (SubclassBase)await(s2.LoadAsync(typeof(SubclassBase), baseId));
SubclassBase oneBase2 = (SubclassBase)await(s2.LoadAsync(typeof(SubclassBase), oneId));
// do some quick checks to make sure s2 loaded an object with the same data as s2 saved.
SubclassAssert.AreEqual(base1, base2);
// the object with id=2 was loaded using the base class - lets make sure it actually loaded
// the subclass
SubclassOne one2 = oneBase2 as SubclassOne;
Assert.IsNotNull(one2);
// lets update the objects
base2.TestString = "Did it get updated";
// update the properties from the subclass and base class
one2.TestString = "Updated SubclassOne String";
one2.OneTestLong = 21;
// save it through the base class reference and make sure that the
// subclass properties get updated.
await(s2.UpdateAsync(base2));
await(s2.UpdateAsync(oneBase2));
await(t2.CommitAsync());
s2.Close();
// lets test the Criteria interface for subclassing
ISession s3 = OpenSession();
ITransaction t3 = s3.BeginTransaction();
IList results3 = await(s3.CreateCriteria(typeof(SubclassBase))
.Add(Expression.In("TestString", new string[] { "Did it get updated", "Updated SubclassOne String" }))
.ListAsync());
Assert.AreEqual(2, results3.Count);
SubclassBase base3 = null;
SubclassOne one3 = null;
foreach (SubclassBase obj in results3)
{
if (obj is SubclassOne)
{
one3 = (SubclassOne)obj;
}
else
{
base3 = obj;
}
}
// verify the properties got updated
SubclassAssert.AreEqual(base2, base3);
SubclassAssert.AreEqual(one2, one3);
await(s3.DeleteAsync(base3));
await(s3.DeleteAsync(one3));
await(t3.CommitAsync());
s3.Close();
}
internal static void AreEqual(SubclassOne expected, SubclassOne actual)
{
AreEqual((SubclassBase)expected, (SubclassBase)actual);
Assert.AreEqual(expected.OneTestLong, actual.OneTestLong);
}