@Override public Long doInSession(Session session) { BeanQuery countQry = session.from(sources); if (condition != null) { countQry.where(condition); } return countQry.count(); } });
@Override public Integer doInSession(Session session) { BeanQuery beanQuery = session.from(entityPath); if (conditions != null) { beanQuery.where(conditions); } return (int) beanQuery.count(); } });
@Test public void In() { Employee emp = Alias.alias(Employee.class); assertEquals(3l, session.from($(emp)).where($(emp).in(emp1, emp2, emp3)).count()); }
@Test public void Contains() { Department dep = Alias.alias(Department.class); assertEquals(1l, session.from($(dep)).where($(dep.getEmployees()).contains(emp1)).count()); }
@Test public void test() { Company company = new Company(); Department department = new Department(); Employee employee = new Employee(); employee.department = department; department.company = company; session.save(company); session.save(department); session.save(employee); session.flush(); session.clear(); Company c = Alias.alias(Company.class); Department d = Alias.alias(Department.class); Employee e = Alias.alias(Employee.class); // count instances assertEquals(1l, session.from($(c)).count()); assertEquals(1l, session.from($(d)).count()); assertEquals(1l, session.from($(e)).count()); // direct assertEquals(1l, session.from($(d)).where($(d.getCompany()).eq(company)).count()); assertEquals(1l, session.from($(d)).where($(d.getCompany()).eq(company)).count()); assertEquals(1l, session.from($(e)).where($(e.getDepartment()).eq(department)).count()); // inverse assertEquals(1l, session.from($(c)).where($(c.getDepartment()).eq(department)).count()); assertEquals(1l, session.from($(c)).where($(c.getDepartments()).contains(department)).count()); assertEquals(1l, session.from($(d)).where($(d.getEmployees()).contains(employee)).count()); }
@Test public void ResultSetAssertions() { assertEquals(1l, from($(u)).count()); assertEquals(1l, from($(u)).list($(u.getUserName())).size()); // where 1 assertEquals(1l, from($(u)).where($(u).eq(sample)).count()); assertEquals(0l, from($(u)).where($(u).ne(sample)).count()); assertEquals(1, from($(u)).where($(u).eq(sample)).list($(u)).size()); assertEquals(0, from($(u)).where($(u).ne(sample)).list($(u)).size()); // where 2 assertEquals(1l, from($(u)).where($(u.getUserName()).eq("Bobby")).count()); assertEquals(0l, from($(u)).where($(u.getUserName()).ne("Bobby")).count()); assertEquals(1, from($(u)).where($(u.getUserName()).eq("Bobby")).list($(u)).size()); assertEquals(0, from($(u)).where($(u.getUserName()).ne("Bobby")).list($(u)).size()); }
@Test public void test() { Entity entity = new Entity(); entity.text1 = "a"; entity.text2 = "a"; Entity entity2 = new Entity(); entity2.text1 = "a"; entity2.text2 = "b"; session.saveAll(entity, entity2); Entity e1 = Alias.alias(Entity.class, "e1"); Entity e2 = Alias.alias(Entity.class, "e2"); assertEquals(1l, session.from($(e1)).where($(e1.getText1()).eq($(e1.getText2()))).count()); assertEquals(2l, session.from($(e1), $(e2)).where($(e1.getText1()).eq($(e2.getText1())), $(e1).ne($(e2))).count()); } }
assertEquals(literals.timestamp, session.from($(l)).where($(l.getTimestamp()).eq(literals.timestamp)).uniqueResult($(l.getTimestamp()))); assertEquals(1, session.from($(l)).where($(l.getDate()).eq(literals.date)).count()); assertEquals(1, session.from($(l)).where($(l.getDate2()).eq(literals.date2)).count()); assertEquals(1, session.from($(l)).where($(l.getDateTime()).eq(literals.dateTime)).count()); assertEquals(1, session.from($(l)).where($(l.getLocalDate()).eq(literals.localDate)).count()); assertEquals(1, session.from($(l)).where($(l.getLocalTime()).eq(literals.localTime)).count()); assertEquals(1, session.from($(l)).where($(l.getTime()).eq(literals.time)).count()); assertEquals(1, session.from($(l)).where($(l.getTimestamp()).eq(literals.timestamp)).count());
@Test public void test() { User u = Alias.alias(User.class, "u"); User u2 = Alias.alias(User.class, "u2"); // assertEquals(6, // session.from($(u),$(u2)).where($(u).ne($(u2))).count()); assertEquals(2, session.from($(u), $(u2)).where($(u).ne($(u2)), $(u.getUserName()).eq($(u2.getUserName()))).count()); assertEquals(2, session.from($(u), $(u2)).where($(u).ne($(u2)), $(u.getUserName()).eq($(u2.getUserName()))).list($(u), $(u2)).size()); }