public void UpdateLazyCollections()
{
// if (dialect is HSQLDialect) return;
ISession s = OpenSession();
Master m = new Master();
Detail d1 = new Detail();
Detail d2 = new Detail();
d2.X = 14;
object mid = s.Save(m);
// s.Flush(); commented out in h2.0.3 also
d1.Master = m;
d2.Master = m;
m.AddDetail(d1);
m.AddDetail(d2);
if ((Dialect is SybaseDialect) || (Dialect is MsSql2000Dialect))
{
s.Save(d1);
s.Save(d2);
}
else
{
s.Save(d1, 666L);
s.Save(d2, 667L);
}
s.Flush();
s.Close();
s = OpenSession();
m = (Master)s.Load(typeof(Master), mid);
s.Close();
m.Name = "New Name";
s = OpenSession();
s.Update(m, mid);
IEnumerator enumer = m.Details.GetEnumerator();
int i = 0;
while (enumer.MoveNext())
{
Assert.IsNotNull(enumer.Current);
i++;
}
Assert.AreEqual(2, i);
enumer = m.Details.GetEnumerator();
while (enumer.MoveNext())
{
s.Delete(enumer.Current);
}
s.Delete(m);
s.Flush();
s.Close();
}
public async Task UpdateLazyCollectionsAsync()
{
// if (dialect is HSQLDialect) return;
ISession s = OpenSession();
Master m = new Master();
Detail d1 = new Detail();
Detail d2 = new Detail();
d2.X = 14;
object mid = await(s.SaveAsync(m));
// s.Flush(); commented out in h2.0.3 also
d1.Master = m;
d2.Master = m;
m.AddDetail(d1);
m.AddDetail(d2);
if (Dialect is MsSql2000Dialect)
{
await(s.SaveAsync(d1));
await(s.SaveAsync(d2));
}
else
{
await(s.SaveAsync(d1, 666L));
await(s.SaveAsync(d2, 667L));
}
await(s.FlushAsync());
s.Close();
s = OpenSession();
m = (Master)await(s.LoadAsync(typeof(Master), mid));
s.Close();
m.Name = "New Name";
s = OpenSession();
await(s.UpdateAsync(m, mid));
IEnumerator enumer = m.Details.GetEnumerator();
int i = 0;
while (enumer.MoveNext())
{
Assert.IsNotNull(enumer.Current);
i++;
}
Assert.AreEqual(2, i);
enumer = m.Details.GetEnumerator();
while (enumer.MoveNext())
{
await(s.DeleteAsync(enumer.Current));
}
await(s.DeleteAsync(m));
await(s.FlushAsync());
s.Close();
}
public void MultiLevelCascade()
{
//if( dialect is Dialect.HSQLDialect ) return;
object mid;
object m0id;
using (ISession s = OpenSession())
{
Detail detail = new Detail();
SubDetail subdetail = new SubDetail();
Master m = new Master();
Master m0 = new Master();
m0id = s.Save(m0);
m0.AddDetail(detail);
detail.Master = m0;
m.MoreDetails.Add(detail);
detail.SubDetails = new HashedSet();
detail.SubDetails.Add(subdetail);
mid = s.Save(m);
s.Flush();
}
using (ISession s = OpenSession())
{
Master m = (Master)s.Load(typeof(Master), mid);
IEnumerator enumer = m.MoreDetails.GetEnumerator();
enumer.MoveNext();
Assert.IsTrue(((Detail)enumer.Current).SubDetails.Count != 0);
s.Delete(m);
s.Delete(s.Load(typeof(Master), m0id));
s.Flush();
}
}
public async Task MultiLevelCascadeAsync()
{
//if( dialect is Dialect.HSQLDialect ) return;
object mid;
object m0id;
using (ISession s = OpenSession())
{
Detail detail = new Detail();
SubDetail subdetail = new SubDetail();
Master m = new Master();
Master m0 = new Master();
m0id = await(s.SaveAsync(m0));
m0.AddDetail(detail);
detail.Master = m0;
m.MoreDetails.Add(detail);
detail.SubDetails = new HashSet <SubDetail> {
subdetail
};
mid = await(s.SaveAsync(m));
await(s.FlushAsync());
}
using (ISession s = OpenSession())
{
Master m = (Master)await(s.LoadAsync(typeof(Master), mid));
IEnumerator enumer = m.MoreDetails.GetEnumerator();
enumer.MoveNext();
Assert.IsTrue(((Detail)enumer.Current).SubDetails.Count != 0);
await(s.DeleteAsync(m));
await(s.DeleteAsync(await(s.LoadAsync(typeof(Master), m0id))));
await(s.FlushAsync());
}
}
public void Cascading()
{
//HSQLDialect return;
ISession s = OpenSession();
Detail d1 = new Detail();
Detail d2 = new Detail();
d2.I = 22;
Master m = new Master();
Master m0 = new Master();
object m0id = s.Save(m0);
m0.AddDetail(d1);
m0.AddDetail(d2);
d1.Master = m0;
d2.Master = m0;
m.MoreDetails.Add(d1);
m.MoreDetails.Add(d2);
object mid = s.Save(m);
s.Flush();
s.Close();
s = OpenSession();
m = (Master)s.Load(typeof(Master), mid);
Assert.AreEqual(2, m.MoreDetails.Count, "cascade save");
IEnumerator enumer = m.MoreDetails.GetEnumerator();
enumer.MoveNext();
Assert.AreEqual(2, ((Detail)enumer.Current).Master.Details.Count, "cascade save");
s.Delete(m);
s.Delete(s.Load(typeof(Master), m0id));
s.Flush();
s.Close();
}
private void CreateMaster()
{
Master m = new Master();
m.Name = "Pepe";
for (int i = 1; i <= 3; i++)
{
Detail d = new Detail("d" + i, m);
m.AddDetail(d);
}
using (ISession s = OpenSession())
using (ITransaction t = s.BeginTransaction())
{
s.Save(m);
savedId = m.Id;
t.Commit();
}
}
public void Serialization()
{
ISession s = OpenSession();
Master m = new Master();
Detail d1 = new Detail();
Detail d2 = new Detail();
object mid = s.Save(m);
d1.Master = (m);
d2.Master = (m);
m.AddDetail(d1);
m.AddDetail(d2);
if ((Dialect is SybaseDialect) || (Dialect is MsSql2000Dialect))
{
s.Save(d1);
}
else
{
s.Save(d1, 666L);
}
s.Flush();
s.Disconnect();
MemoryStream stream = new MemoryStream();
BinaryFormatter f = new BinaryFormatter();
f.Serialize(stream, s);
stream.Position = 0;
Console.WriteLine(stream.Length);
s = (ISession)f.Deserialize(stream);
stream.Close();
s.Reconnect();
Master m2 = (Master)s.Load(typeof(Master), mid);
Assert.IsTrue(m2.Details.Count == 2, "serialized state");
foreach (Detail d in m2.Details)
{
Assert.IsTrue(d.Master == m2, "deserialization");
try
{
s.GetIdentifier(d);
s.Delete(d);
}
catch (Exception e)
{
Assert.IsNotNull(e); //getting ride of 'e' is never used compile warning
}
}
s.Delete(m2);
s.Flush();
s.Close();
s = OpenSession();
mid = s.Save(new Master());
object mid2 = s.Save(new Master());
s.Flush();
s.Disconnect();
stream = new MemoryStream();
f.Serialize(stream, s);
stream.Position = 0;
s = (ISession)f.Deserialize(stream);
stream.Close();
s.Reconnect();
s.Delete(s.Load(typeof(Master), mid));
s.Delete(s.Load(typeof(Master), mid2));
s.Flush();
s.Close();
s = OpenSession();
string db = s.Connection.Database; //force session to grab a connection
try
{
stream = new MemoryStream();
f.Serialize(stream, s);
}
catch (Exception e)
{
Assert.IsTrue(e is InvalidOperationException, "illegal state");
s.Close();
return;
}
finally
{
stream.Close();
}
Assert.IsTrue(false, "serialization should have failed");
}
public void MasterDetail()
{
//if( dialect is Dialect.HSQLDialect ) return;
ISession s = OpenSession();
ITransaction t = s.BeginTransaction();
Master master = new Master();
Assert.IsNotNull(s.Save(master), "save returned native id");
object mid = s.GetIdentifier(master);
Detail d1 = new Detail();
d1.Master = master;
object did = s.Save(d1);
Detail d2 = new Detail();
d2.I = 12;
d2.Master = master;
Assert.IsNotNull(s.Save(d2), "generated id returned");
master.AddDetail(d1);
master.AddDetail(d2);
if (Dialect.SupportsSubSelects)
{
string hql = "from d in class NHibernate.DomainModel.Detail, m in class NHibernate.DomainModel.Master " +
"where m = d.Master and m.Outgoing.size = 0 and m.Incoming.size = 0";
Assert.AreEqual(2, s.CreateQuery(hql).List().Count, "query");
}
t.Commit();
s.Close();
s = OpenSession();
t = s.BeginTransaction();
master = (Master)s.Load(typeof(Master), mid);
IEnumerator enumer = master.Details.GetEnumerator();
int i = 0;
while (enumer.MoveNext())
{
Detail d = (Detail)enumer.Current;
Assert.AreSame(master, d.Master, "master-detail");
i++;
}
Assert.AreEqual(2, i, "master-detail count");
t.Commit();
s.Close();
s = OpenSession();
t = s.BeginTransaction();
Assert.AreEqual(2, s.CreateQuery("select elements(master.Details) from Master master").List().Count);
t.Commit();
s.Close();
s = OpenSession();
t = s.BeginTransaction();
IList list = s.CreateQuery("from Master m left join fetch m.Details").List();
Master m = (Master)list[0];
Assert.IsTrue(NHibernateUtil.IsInitialized(m.Details), "joined fetch should initialize collection");
Assert.AreEqual(2, m.Details.Count);
list = s.CreateQuery("from Detail d inner join fetch d.Master").List();
Detail dt = (Detail)list[0];
object dtid = s.GetIdentifier(dt);
Assert.AreSame(m, dt.Master);
t.Commit();
s.Close();
s = OpenSession();
t = s.BeginTransaction();
list = s.CreateQuery("select m from Master m1, Master m left join fetch m.Details where m.Name=m1.Name").List();
Assert.IsTrue(NHibernateUtil.IsInitialized(((Master)list[0]).Details));
dt = (Detail)s.Load(typeof(Detail), dtid);
Assert.IsTrue(((Master)list[0]).Details.Contains(dt));
t.Commit();
s.Close();
s = OpenSession();
t = s.BeginTransaction();
list =
s.CreateQuery("select m, m1.Name from Master m1, Master m left join fetch m.Details where m.Name=m1.Name").List();
Master masterFromHql = (Master)((object[])list[0])[0];
Assert.IsTrue(NHibernateUtil.IsInitialized(masterFromHql.Details));
dt = (Detail)s.Load(typeof(Detail), dtid);
Assert.IsTrue(masterFromHql.Details.Contains(dt));
// This line is commentend in H3.2 tests because it work in the classic parser
// even if it as no sense ('join fetch' where the 'select' is a scalar)
// The AST check the case with an Exception
//list = s.CreateQuery("select m.id from Master m inner join fetch m.Details").List();
t.Commit();
s.Close();
s = OpenSession();
t = s.BeginTransaction();
Detail dd = (Detail)s.Load(typeof(Detail), did);
master = dd.Master;
Assert.IsTrue(master.Details.Contains(dd), "detail-master");
Assert.AreEqual(2, s.CreateFilter(master.Details, "order by this.I desc").List().Count);
Assert.AreEqual(2, s.CreateFilter(master.Details, "select this where this.id > -1").List().Count);
IQuery q = s.CreateFilter(master.Details, "where this.id > :id");
q.SetInt32("id", -1);
Assert.AreEqual(2, q.List().Count);
q = s.CreateFilter(master.Details, "where this.id > :id1 and this.id < :id2");
q.SetInt32("id1", -1);
q.SetInt32("id2", 99999999);
Assert.AreEqual(2, q.List().Count);
q.SetInt32("id2", -1);
Assert.AreEqual(0, q.List().Count);
q = s.CreateFilter(master.Details, "where this.id in (:ids)");
list = new ArrayList();
list.Add(did);
list.Add((long)-1);
q.SetParameterList("ids", list);
Assert.AreEqual(1, q.List().Count);
Assert.IsTrue(q.Enumerable().GetEnumerator().MoveNext());
Assert.AreEqual(2, s.CreateFilter(master.Details, "where this.id > -1").List().Count);
Assert.AreEqual(2, s.CreateFilter(master.Details, "select this.Master where this.id > -1").List().Count);
Assert.AreEqual(2,
s.CreateFilter(master.Details, "select m from m in class Master where this.id > -1 and this.Master=m")
.List().Count);
Assert.AreEqual(0, s.CreateFilter(master.Incoming, "where this.id > -1 and this.Name is not null").List().Count);
IQuery filter = s.CreateFilter(master.Details, "select max(this.I)");
enumer = filter.Enumerable().GetEnumerator();
Assert.IsTrue(enumer.MoveNext());
Assert.IsTrue(enumer.Current is Int32);
filter = s.CreateFilter(master.Details, "select max(this.I) group by this.id");
enumer = filter.Enumerable().GetEnumerator();
Assert.IsTrue(enumer.MoveNext());
Assert.IsTrue(enumer.Current is Int32);
filter = s.CreateFilter(master.Details, "select count(*)");
enumer = filter.Enumerable().GetEnumerator();
Assert.IsTrue(enumer.MoveNext());
Assert.IsTrue(enumer.Current is Int64);
Assert.AreEqual(2, s.CreateFilter(master.Details, "select this.Master").List().Count);
IQuery f = s.CreateFilter(master.Details, "select max(this.I) where this.I < :top and this.I>=:bottom");
f.SetInt32("top", 100);
f.SetInt32("bottom", 0);
enumer = f.Enumerable().GetEnumerator();
Assert.IsTrue(enumer.MoveNext());
Assert.AreEqual(12, enumer.Current);
f.SetInt32("top", 2);
enumer = f.Enumerable().GetEnumerator();
Assert.IsTrue(enumer.MoveNext());
Assert.AreEqual(0, enumer.Current);
f = s.CreateFilter(master.Details, "select max(this.I) where this.I not in (:list)");
IList coll = new ArrayList();
coll.Add(-666);
coll.Add(22);
coll.Add(0);
f.SetParameterList("list", coll);
enumer = f.Enumerable().GetEnumerator();
Assert.IsTrue(enumer.MoveNext());
Assert.AreEqual(12, enumer.Current);
i = 0;
foreach (Detail d in master.Details)
{
Assert.AreSame(master, d.Master, "master-detail");
s.Delete(d);
i++;
}
Assert.AreEqual(2, i, "master-detail");
s.Delete(master);
t.Commit();
s.Close();
}
public async Task SerializationAsync()
{
ISession s = OpenSession();
Master m = new Master();
Detail d1 = new Detail();
Detail d2 = new Detail();
object mid = await(s.SaveAsync(m));
d1.Master = (m);
d2.Master = (m);
m.AddDetail(d1);
m.AddDetail(d2);
if (Dialect is MsSql2000Dialect)
{
await(s.SaveAsync(d1));
}
else
{
await(s.SaveAsync(d1, 666L));
}
await(s.FlushAsync());
s.Disconnect();
MemoryStream stream = new MemoryStream();
BinaryFormatter f = new BinaryFormatter();
f.Serialize(stream, s);
s.Close();
stream.Position = 0;
Console.WriteLine(stream.Length);
s = (ISession)f.Deserialize(stream);
stream.Close();
s.Reconnect();
Master m2 = (Master)await(s.LoadAsync(typeof(Master), mid));
Assert.IsTrue(m2.Details.Count == 2, "serialized state");
foreach (Detail d in m2.Details)
{
Assert.IsTrue(d.Master == m2, "deserialization");
try
{
s.GetIdentifier(d);
await(s.DeleteAsync(d));
}
catch (Exception)
{
// Why are we ignoring exceptions here? /Oskar 2014-08-24
}
}
await(s.DeleteAsync(m2));
await(s.FlushAsync());
s.Close();
s = OpenSession();
mid = await(s.SaveAsync(new Master()));
object mid2 = await(s.SaveAsync(new Master()));
await(s.FlushAsync());
s.Disconnect();
stream = new MemoryStream();
f.Serialize(stream, s);
s.Close();
stream.Position = 0;
s = (ISession)f.Deserialize(stream);
stream.Close();
s.Reconnect();
await(s.DeleteAsync(await(s.LoadAsync(typeof(Master), mid))));
await(s.DeleteAsync(await(s.LoadAsync(typeof(Master), mid2))));
await(s.FlushAsync());
s.Close();
s = OpenSession();
string db = s.Connection.Database; //force session to grab a connection
try
{
stream = new MemoryStream();
f.Serialize(stream, s);
}
catch (Exception e)
{
Assert.IsTrue(e is InvalidOperationException, "illegal state");
s.Close();
return;
}
finally
{
stream.Close();
}
Assert.IsTrue(false, "serialization should have failed");
}