/** * Shorthand for {@link QueryBuilder#build() build()}.{@link Query#list() list()}; see {@link Query#list()} for * details. To execute a query more than once, you should build the query and keep the {@link Query} object for * efficiency reasons. */ public List<T> list() { return build().list(); }
@Override public List<T> call() throws Exception { return query.forCurrentThread().list(); } });
@Override public void run() { synchronized (query) { query.list(); } } });
@Override public void run() { query.list(); } });
@Override public void run() { query.list(); } });
@Override public void run() { query.forCurrentThread().list(); } };
@Override public void run() { query.forCurrentThread().list(); } };
@Override public void run() { try { queryHolder[0] = minimalEntityDao.queryBuilder().build(); queryHolder[0].list(); } finally { latch.countDown(); } } }.start();
/** 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(); }
public void testRawQueryEmptySql() { insert(3); Query<TestEntity> query = dao.queryRawCreate(""); List<TestEntity> result = query.list(); assertEquals(3, result.size()); }
/** 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 "dateEntityList" to-many relationship of ToManyEntity. */ public List<DateEntity> _queryToManyEntity_DateEntityList(Long idToMany) { synchronized (this) { if (toManyEntity_DateEntityListQuery == null) { QueryBuilder<DateEntity> queryBuilder = queryBuilder(); queryBuilder.join(JoinManyToDateEntity.class, JoinManyToDateEntityDao.Properties.IdDate) .where(JoinManyToDateEntityDao.Properties.IdToMany.eq(idToMany)); toManyEntity_DateEntityListQuery = queryBuilder.build(); } } Query<DateEntity> query = toManyEntity_DateEntityListQuery.forCurrentThread(); query.setParameter(0, idToMany); 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(); }
public void testRawQueryCreate_setParameterInQuery() { insert(3); String value = getSimpleString(2); String sql = "WHERE " + Properties.SimpleString.columnName + "=?"; Query<TestEntity> query = dao.queryRawCreate(sql, getSimpleString(1)); query.list(); query.setParameter(0, value); List<TestEntity> result = query.list(); assertEquals(1, result.size()); assertEquals(value, result.get(0).getSimpleString()); }
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 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()); }
/** 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(); }
public void testBuildQueryAndCountQuery() { insert(3); int value = getSimpleInteger(1); QueryBuilder<TestEntity> builder = dao.queryBuilder().where(Properties.SimpleInteger.eq(value)); Query<TestEntity> query = builder.build(); CountQuery<TestEntity> countQuery = builder.buildCount(); assertEquals(1, query.list().size()); assertEquals(1, countQuery.count()); }