/** Internal query to resolve the "toManyJoinTwo" to-many relationship of ToManyEntity. */ public List<ToManyTargetEntity> _queryToManyEntity_ToManyJoinTwo(Long toManyId, String targetJoinProperty) { synchronized (this) { if (toManyEntity_ToManyJoinTwoQuery == null) { QueryBuilder<ToManyTargetEntity> queryBuilder = queryBuilder(); queryBuilder.where(Properties.ToManyId.eq(null)); queryBuilder.where(Properties.TargetJoinProperty.eq(null)); queryBuilder.orderRaw("T.'TARGET_JOIN_PROPERTY' DESC,T.'_id' DESC"); toManyEntity_ToManyJoinTwoQuery = queryBuilder.build(); } } Query<ToManyTargetEntity> query = toManyEntity_ToManyJoinTwoQuery.forCurrentThread(); query.setParameter(0, toManyId); query.setParameter(1, targetJoinProperty); return query.list(); }
/** Internal query to resolve the "toManyTarget2List" to-many relationship of RelationSource2. */ public List<ToManyTarget2> _queryRelationSource2_ToManyTarget2List(Long fkId) { synchronized (this) { if (relationSource2_ToManyTarget2ListQuery == null) { QueryBuilder<ToManyTarget2> queryBuilder = queryBuilder(); queryBuilder.where(Properties.FkId.eq(null)); relationSource2_ToManyTarget2ListQuery = queryBuilder.build(); } } Query<ToManyTarget2> query = relationSource2_ToManyTarget2ListQuery.forCurrentThread(); query.setParameter(0, fkId); return query.list(); }
/** Internal query to resolve the "children" to-many relationship of TreeEntity. */ public List<TreeEntity> _queryTreeEntity_Children(Long parentId) { synchronized (this) { if (treeEntity_ChildrenQuery == null) { QueryBuilder<TreeEntity> queryBuilder = queryBuilder(); queryBuilder.where(Properties.ParentId.eq(null)); treeEntity_ChildrenQuery = queryBuilder.build(); } } Query<TreeEntity> query = treeEntity_ChildrenQuery.forCurrentThread(); query.setParameter(0, parentId); return query.list(); }
/** Internal query to resolve the "toManyDescList" to-many relationship of ToManyEntity. */ public List<ToManyTargetEntity> _queryToManyEntity_ToManyDescList(Long toManyIdDesc) { synchronized (this) { if (toManyEntity_ToManyDescListQuery == null) { QueryBuilder<ToManyTargetEntity> queryBuilder = queryBuilder(); queryBuilder.where(Properties.ToManyIdDesc.eq(null)); queryBuilder.orderRaw("T.'_id' DESC"); toManyEntity_ToManyDescListQuery = queryBuilder.build(); } } Query<ToManyTargetEntity> query = toManyEntity_ToManyDescListQuery.forCurrentThread(); query.setParameter(0, toManyIdDesc); return query.list(); }
/** Internal query to resolve the "toManyTargetEntityList" to-many relationship of ToManyEntity. */ public List<ToManyTargetEntity> _queryToManyEntity_ToManyTargetEntityList(Long toManyId) { synchronized (this) { if (toManyEntity_ToManyTargetEntityListQuery == null) { QueryBuilder<ToManyTargetEntity> queryBuilder = queryBuilder(); queryBuilder.where(Properties.ToManyId.eq(null)); queryBuilder.orderRaw("T.'_id' ASC"); toManyEntity_ToManyTargetEntityListQuery = queryBuilder.build(); } } Query<ToManyTargetEntity> query = toManyEntity_ToManyTargetEntityListQuery.forCurrentThread(); query.setParameter(0, toManyId); return query.list(); }
/** Internal query to resolve the "toManyByJoinProperty" to-many relationship of ToManyEntity. */ public List<ToManyTargetEntity> _queryToManyEntity_ToManyByJoinProperty(String targetJoinProperty) { synchronized (this) { if (toManyEntity_ToManyByJoinPropertyQuery == null) { QueryBuilder<ToManyTargetEntity> queryBuilder = queryBuilder(); queryBuilder.where(Properties.TargetJoinProperty.eq(null)); queryBuilder.orderRaw("T.'_id' ASC"); toManyEntity_ToManyByJoinPropertyQuery = queryBuilder.build(); } } Query<ToManyTargetEntity> query = toManyEntity_ToManyByJoinPropertyQuery.forCurrentThread(); query.setParameter(0, targetJoinProperty); return query.list(); }
@Override public void run() { QueryBuilder<TestEntity> builder = dao.queryBuilder(); builder.where(Properties.SimpleInteger.eq(getSimpleInteger(1))); queryFromOtherThread = builder.buildDelete(); } };
@Override public void run() { QueryBuilder<TestEntity> builder = dao.queryBuilder(); builder.where(Properties.SimpleInteger.eq(getSimpleInteger(1))); queryFromOtherThread = builder.buildCount(); } };
public void testNotEqString() { ArrayList<TestEntity> inserted = insert(3); String value = getSimpleString(1); List<TestEntity> result = dao.queryBuilder().where(Properties.SimpleString.notEq(value)).list(); assertEquals(2, result.size()); TestEntity resultEntity1 = result.get(0); TestEntity resultEntity2 = result.get(1); long loId = Math.min(resultEntity1.getId(), resultEntity2.getId()); long hiId = Math.max(resultEntity1.getId(), resultEntity2.getId()); assertEquals((long) inserted.get(0).getId(), loId); assertEquals((long) inserted.get(2).getId(), hiId); }
public void testEqStringAndInteger() { ArrayList<TestEntity> inserted = insert(3); String valueStr = getSimpleString(1); int valueInt = getSimpleInteger(1); List<TestEntity> result = dao.queryBuilder() .where(Properties.SimpleString.eq(valueStr), Properties.SimpleInteger.eq(valueInt)).list(); assertEquals(1, result.size()); TestEntity resultEntity = result.get(0); assertEquals(inserted.get(1).getId(), resultEntity.getId()); }
public void testBuildTwice() { insert(3); String value = getSimpleString(1); QueryBuilder<TestEntity> builder = dao.queryBuilder().where(Properties.SimpleString.eq(value)); Query<TestEntity> query1 = builder.build(); Query<TestEntity> query2 = builder.build(); List<TestEntity> list1 = query1.list(); List<TestEntity> list2 = query2.list(); assertEquals(1, list1.size()); assertEquals(1, list2.size()); assertEquals(list1.get(0).getId(), list2.get(0).getId()); }
public void testEqInteger() { ArrayList<TestEntity> inserted = insert(3); int value = getSimpleInteger(1); List<TestEntity> result = dao.queryBuilder().where(Properties.SimpleInteger.eq(value)).list(); assertEquals(1, result.size()); TestEntity resultEntity = result.get(0); assertEquals(value, (int) resultEntity.getSimpleInteger()); assertEquals(inserted.get(1).getId(), resultEntity.getId()); }
public void testEqString() { ArrayList<TestEntity> inserted = insert(3); String value = getSimpleString(1); List<TestEntity> result = dao.queryBuilder().where(Properties.SimpleString.eq(value)).list(); assertEquals(1, result.size()); TestEntity resultEntity = result.get(0); assertEquals(value, resultEntity.getSimpleString()); assertEquals(inserted.get(1).getId(), resultEntity.getId()); }
public void testDeleteQuerySimple() { ArrayList<TestEntity> inserted = insert(3); int value = getSimpleInteger(1); inserted.get(2).setSimpleInteger(value); dao.update(inserted.get(2)); DeleteQuery<TestEntity> deleteQuery = dao.queryBuilder().where(Properties.SimpleInteger.eq(value)) .buildDelete(); deleteQuery.executeDeleteWithoutDetachingEntities(); List<TestEntity> allAfterDelete = dao.loadAll(); assertEquals(1, allAfterDelete.size()); assertEquals(getSimpleInteger(0), (int) allAfterDelete.get(0).getSimpleInteger()); }
public void testBuildQueryAndDeleteQuery() { insert(3); int value = getSimpleInteger(1); QueryBuilder<TestEntity> builder = dao.queryBuilder().where(Properties.SimpleInteger.eq(value)); Query<TestEntity> query = builder.build(); DeleteQuery<TestEntity> deleteQuery = builder.buildDelete(); assertEquals(1, query.list().size()); deleteQuery.executeDeleteWithoutDetachingEntities(); assertEquals(0, query.list().size()); }
public void testDistinct() { TestEntity entity = insert(3).get(1); Query<TestEntity> query = dao.queryBuilder().distinct() .where(Properties.SimpleString.eq(entity.getSimpleString())).build(); TestEntity entity2 = query.uniqueOrThrow(); assertEquals(entity.getId(), entity2.getId()); // TODO improve test to check functionality }
public void testCountQuerySimple() { int value = getSimpleInteger(1); CountQuery<TestEntity> query = dao.queryBuilder().where(Properties.SimpleInteger.eq(value)).buildCount(); assertEquals(0, query.count()); ArrayList<TestEntity> inserted = insert(3); assertEquals(1, query.count()); inserted.get(2).setSimpleInteger(value); dao.update(inserted.get(2)); assertEquals(2, query.count()); dao.deleteAll(); assertEquals(0, query.count()); }
public void testGetForCurrentThread_ParametersAreReset() { insert(3); int value = getSimpleInteger(1); CountQuery<TestEntity> query = dao.queryBuilder().where(Properties.SimpleInteger.eq(value)).buildCount(); query.setParameter(0, value + 100); assertEquals(0, query.count()); query = query.forCurrentThread(); assertEquals(1, query.count()); }
public void testDeleteQueryChangeParameter() { insert(3); String value = getSimpleString(1); DeleteQuery<TestEntity> deleteQuery = dao.queryBuilder().where(Properties.SimpleString.eq(value)).buildDelete(); deleteQuery.executeDeleteWithoutDetachingEntities(); assertEquals(2, dao.count()); deleteQuery.setParameter(0, getSimpleString(0)); deleteQuery.executeDeleteWithoutDetachingEntities(); assertEquals(1, dao.count()); TestEntity remaining = dao.loadAll().get(0); assertEquals(getSimpleString(2), remaining.getSimpleString()); }
public void testGetForCurrentThread_ParametersAreReset() { insert(3); int value = getSimpleInteger(1); Query<TestEntity> query = dao.queryBuilder().where(Properties.SimpleInteger.eq(value)).build(); query.setParameter(0, value + 1); TestEntity entityFor2 = query.unique(); assertEquals(value + 1, (int) entityFor2.getSimpleInteger()); query = query.forCurrentThread(); assertNotNull(query.unique()); }