public async Task TestExcludingQBEAsync() { using (ISession s = OpenSession()) using (ITransaction t = s.BeginTransaction()) { Componentizable master = GetMaster("hibernate", null, "ope%"); ICriteria crit = s.CreateCriteria(typeof(Componentizable)); Example ex = Example.Create(master).EnableLike() .ExcludeProperty("Component.SubComponent"); crit.Add(ex); IList result = await(crit.ListAsync()); Assert.IsNotNull(result); Assert.AreEqual(3, result.Count); master = GetMaster("hibernate", "ORM tool", "fake stuff"); crit = s.CreateCriteria(typeof(Componentizable)); ex = Example.Create(master).EnableLike() .ExcludeProperty("Component.SubComponent.SubName1"); crit.Add(ex); result = await(crit.ListAsync()); Assert.IsNotNull(result); Assert.AreEqual(1, result.Count); await(t.CommitAsync()); } }
public async Task TestEnableLikeWithMatchmodeAnywhereAsync() { using (ISession s = OpenSession()) using (ITransaction t = s.BeginTransaction()) { Componentizable master = GetMaster("bern", null, null); ICriteria crit = s.CreateCriteria(typeof(Componentizable)); Example ex = Example.Create(master).EnableLike(MatchMode.Anywhere); crit.Add(ex); IList result = await(crit.ListAsync()); Assert.IsNotNull(result); Assert.AreEqual(3, result.Count); await(t.CommitAsync()); } }
public void TestEnableLikeWithMatchmodeEnd() { using (ISession s = OpenSession()) using (ITransaction t = s.BeginTransaction()) { Componentizable master = GetMaster("nate", null, "ORM tool1"); ICriteria crit = s.CreateCriteria(typeof(Componentizable)); Example ex = Example.Create(master).EnableLike(MatchMode.End); crit.Add(ex); IList result = crit.List(); Assert.IsNotNull(result); Assert.AreEqual(1, result.Count); t.Commit(); } }
public async Task TestSimpleQBEAsync() { using (ISession s = OpenSession()) using (ITransaction t = s.BeginTransaction()) { Componentizable master = GetMaster("hibernate", null, "ope%"); ICriteria crit = s.CreateCriteria(typeof(Componentizable)); Example ex = Example.Create(master).EnableLike(); crit.Add(ex); IList result = await(crit.ListAsync()); Assert.IsNotNull(result); Assert.AreEqual(1, result.Count); await(t.CommitAsync()); } }
private Componentizable GetMaster(String name, String subName, String subName1) { Componentizable master = new Componentizable(); if (name != null) { NHibernate.DomainModel.Component masterComp = new NHibernate.DomainModel.Component(); masterComp.Name = name; if (subName != null || subName1 != null) { SubComponent subComponent = new SubComponent(); subComponent.SubName = subName; subComponent.SubName1 = subName1; masterComp.SubComponent = subComponent; } master.Component = masterComp; } return(master); }
public async Task TestJunctionNotExpressionQBEAsync() { using (ISession s = OpenSession()) using (ITransaction t = s.BeginTransaction()) { Componentizable master = GetMaster("hibernate", null, "ope%"); ICriteria crit = s.CreateCriteria(typeof(Componentizable)); Example ex = Example.Create(master).EnableLike(); crit.Add(Expression.Or(Expression.Not(ex), ex)); IList result = await(crit.ListAsync()); Assert.IsNotNull(result); //if ( !(dialect is HSQLDialect - h2.1 test Assert.AreEqual(2, result.Count, "expected 2 objects"); await(t.CommitAsync()); } }
public void CanUseDetachedCriteriaToQuery() { using (ISession s = OpenSession()) { Componentizable master = new Componentizable(); master.NickName = "master"; s.Save(master); s.Flush(); } DetachedCriteria detachedCriteria = DetachedCriteria.For(typeof(Componentizable)); detachedCriteria.Add(Expression.Eq("NickName", "master")); using (ISession s = OpenSession()) { Componentizable componentizable = (Componentizable)detachedCriteria.GetExecutableCriteria(s).UniqueResult(); Assert.AreEqual("master", componentizable.NickName); s.Delete(componentizable); s.Flush(); } }
public async Task CanUseDetachedCriteriaToQueryAsync() { using (ISession s = OpenSession()) { Componentizable master = new Componentizable(); master.NickName = "master"; await(s.SaveAsync(master)); await(s.FlushAsync()); } DetachedCriteria detachedCriteria = DetachedCriteria.For(typeof(Componentizable)); detachedCriteria.Add(Expression.Eq("NickName", "master")); using (ISession s = OpenSession()) { Componentizable componentizable = (Componentizable)await(detachedCriteria.GetExecutableCriteria(s).UniqueResultAsync()); Assert.AreEqual("master", componentizable.NickName); await(s.DeleteAsync(componentizable)); await(s.FlushAsync()); } }
private void InitData() { using (ISession s = OpenSession()) { Componentizable master = GetMaster("hibernate", "ORM tool", "ORM tool1"); s.Save(master); s.Flush(); } using (ISession s = OpenSession()) { Componentizable master = GetMaster("hibernate", "open source", "open source1"); s.Save(master); s.Flush(); } using (ISession s = OpenSession()) { Componentizable master = GetMaster("hibernate", null, null); s.Save(master); s.Flush(); } }
private async Task InitDataAsync(CancellationToken cancellationToken = default(CancellationToken)) { using (ISession s = OpenSession()) { Componentizable master = GetMaster("hibernate", "ORM tool", "ORM tool1"); await(s.SaveAsync(master, cancellationToken)); await(s.FlushAsync(cancellationToken)); } using (ISession s = OpenSession()) { Componentizable master = GetMaster("hibernate", "open source", "open source1"); await(s.SaveAsync(master, cancellationToken)); await(s.FlushAsync(cancellationToken)); } using (ISession s = OpenSession()) { Componentizable master = GetMaster("hibernate", null, null); await(s.SaveAsync(master, cancellationToken)); await(s.FlushAsync(cancellationToken)); } }
private void ComponentTest(string sql) { ISession session = OpenSession(); Componentizable c = new Componentizable(); c.NickName = "Flacky"; NHibernate.DomainModel.Component component = new NHibernate.DomainModel.Component(); component.Name = "flakky comp"; SubComponent subComponent = new SubComponent(); subComponent.SubName = "subway"; component.SubComponent = subComponent; c.Component = component; session.Save(c); session.Flush(); session.Clear(); IQuery q = session.CreateSQLQuery(sql).AddEntity("comp", typeof(Componentizable)); IList list = q.List(); Assert.AreEqual(list.Count, 1); Componentizable co = (Componentizable)list[0]; Assert.AreEqual(c.NickName, co.NickName); Assert.AreEqual(c.Component.Name, co.Component.Name); Assert.AreEqual(c.Component.SubComponent.SubName, co.Component.SubComponent.SubName); session.Delete(co); session.Flush(); session.Close(); }
private async Task ComponentTestAsync(string sql, CancellationToken cancellationToken = default(CancellationToken)) { ISession session = OpenSession(); Componentizable c = new Componentizable(); c.NickName = "Flacky"; NHibernate.DomainModel.Component component = new NHibernate.DomainModel.Component(); component.Name = "flakky comp"; SubComponent subComponent = new SubComponent(); subComponent.SubName = "subway"; component.SubComponent = subComponent; c.Component = component; await(session.SaveAsync(c, cancellationToken)); await(session.FlushAsync(cancellationToken)); session.Clear(); IQuery q = session.CreateSQLQuery(sql).AddEntity("comp", typeof(Componentizable)); IList list = await(q.ListAsync(cancellationToken)); Assert.AreEqual(list.Count, 1); Componentizable co = (Componentizable)list[0]; Assert.AreEqual(c.NickName, co.NickName); Assert.AreEqual(c.Component.Name, co.Component.Name); Assert.AreEqual(c.Component.SubComponent.SubName, co.Component.SubComponent.SubName); await(session.DeleteAsync(co, cancellationToken)); await(session.FlushAsync(cancellationToken)); session.Close(); }