@Nullable public T uniqueResult() { if (conditions.getValue() != null) { return session.from(entityPath).where(conditions).uniqueResult(entityPath); } else { return null; } }
@Test public void UniqueResult() { assertTrue(session.from(var).limit(1).uniqueResult(projection) instanceof SimpleType); }
@Test public void ByLiteralProperty() { System.out.println("byLiteralProperty"); instance = where(var.directProperty.eq("propertymap")).uniqueResult(var); assertNotNull(instance); assertEquals("propertymap", instance.getDirectProperty()); }
@Test public void ById() { System.out.println("byId"); String id = session.from(var).list(var.id).get(0); instance = where(var.id.eq(id)).uniqueResult(var); assertNotNull(instance); assertEquals(id, instance.getId()); }
@Test public void ByIdNegated() { System.out.println("byIdNegated"); instances = session.from(var).list(var); instance = where(var.id.ne(instances.get(0).getId())).uniqueResult(var); assertNotNull(instance); assertEquals(instances.get(1).getId(), instance.getId()); }
@Test public void test() { Literals literals = new Literals(); literals.byteValue = (byte) 1; literals.dateValue = new Date(); literals.doubleValue = 2.0; literals.floatValue = (float) 3.0; literals.intValue = 4; literals.longValue = 5l; literals.shortValue = (short) 6; literals.stringValue = "7"; session.save(literals); Literals l = Alias.alias(Literals.class); assertEquals(Byte.valueOf(literals.getByteValue()), session.from($(l)).uniqueResult($(l.getByteValue()))); assertEquals(literals.getDateValue(), session.from($(l)).uniqueResult($(l.getDateValue()))); assertEquals(Double.valueOf(literals.getDoubleValue()), session.from($(l)).uniqueResult($(l.getDoubleValue()))); assertEquals(Float.valueOf(literals.getFloatValue()), session.from($(l)).uniqueResult($(l.getFloatValue()))); assertEquals(Integer.valueOf(literals.getIntValue()), session.from($(l)).uniqueResult($(l.getIntValue()))); assertEquals(Long.valueOf(literals.getLongValue()), session.from($(l)).uniqueResult($(l.getLongValue()))); assertEquals(Short.valueOf(literals.getShortValue()), session.from($(l)).uniqueResult($(l.getShortValue()))); assertEquals(literals.getStringValue(), session.from($(l)).uniqueResult($(l.getStringValue()))); }
@Test public void test() { Entity1 entity1 = new Entity1(); Entity2 entity2 = new Entity2(); session.save(entity1); session.save(entity2); Entity1 e1 = Alias.alias(Entity1.class); Entity2 e2 = Alias.alias(Entity2.class); SimplePath<ID> idPath = new SimplePath<ID>(ID.class, $(e1), "id"); assertEquals(entity1, session.from($(e1)).where(idPath.eq(entity1.getId())).uniqueResult($(e1))); assertEquals(entity2, session.from($(e2)).where($(e2.getId()).eq(entity2.getId())).uniqueResult($(e2))); }
@Test public void test() { EntityRevision revision = new EntityRevision(); revision.text = "a bcd e"; session.save(revision); session.flush(); session.clear(); EntityRevision var = Alias.alias(EntityRevision.class); assertNotNull(session.from($(var)).where($(var.getText()).containsIgnoreCase("a bcd e")).uniqueResult($(var))); }
@Test public void Query() throws IOException { ConfigurationBuilder builder = new ConfigurationBuilder(); builder.addClass(TEST.NS, Person.class).addId("id").addProperties(); builder.addClass(new UID(TEST.NS, "Dept"), Department.class).addId("id").addProperties(); builder.addClass(TEST.NS, Company.class).addId("id").addProperties(); Configuration configuration = builder.build(); Session session = SessionUtil.openSession(new MiniRepository(), Collections.<Locale> emptySet(), configuration); Person person = new Person(); person.firstName = "Bob"; person.lastName = "Smith"; session.save(person); session.clear(); // getById Person other = session.getById(person.id, Person.class); assertNotNull(other.id); assertEquals(person.firstName, other.firstName); assertEquals(person.lastName, other.lastName); // query PathBuilder<Person> personPath = new PathBuilderFactory().create(Person.class); assertEquals(other, session.from(personPath).where(personPath.getString("firstName").eq("Bob")).uniqueResult(personPath)); assertEquals(other, session.from(personPath).where(personPath.getString("lastName").eq("Smith")).uniqueResult(personPath)); // list assertEquals(1, session.from(personPath).list(personPath).size()); // findInstances assertEquals(1, session.findInstances(Person.class).size()); session.close(); }
assertEquals(literals.date, session.from($(l)).where($(l.getDate()).eq(literals.date)).uniqueResult($(l.getDate()))); assertEquals(literals.date2, session.from($(l)).where($(l.getDate2()).eq(literals.date2)).uniqueResult($(l.getDate2()))); assertEquals(literals.dateTime.getMillis(), session.from($(l)).where($(l.getDateTime()).eq(literals.dateTime)).uniqueResult($(l.getDateTime())).getMillis()); assertEquals(literals.localDate, session.from($(l)).where($(l.getLocalDate()).eq(literals.localDate)).uniqueResult($(l.getLocalDate()))); assertEquals(literals.localTime, session.from($(l)).where($(l.getLocalTime()).eq(literals.localTime)).uniqueResult($(l.getLocalTime()))); assertEquals(literals.time, session.from($(l)).where($(l.getTime()).eq(literals.time)).uniqueResult($(l.getTime()))); assertEquals(literals.timestamp, session.from($(l)).where($(l.getTimestamp()).eq(literals.timestamp)).uniqueResult($(l.getTimestamp())));