@Override public Iterable<Rule> getRules() { final List<Rule> rules = newArrayList(); for (RuleEntity ruleEntity : ao.find(RuleEntity.class, Query.select().order("RULE_NAME ASC"))) { rules.add(transformRule(ruleEntity)); } return rules; }
@Override public List<JobMapping> doInTransaction() { Query query = Query.select(); if (!includeDeleted) { query.where(DELETED + " = ?", Boolean.FALSE); } query.order(NAME); return Arrays.asList(ao.find(JobMapping.class, query)); } });
@Override public List<BuildMapping> doInTransaction() { return Arrays.asList(ao.find(BuildMapping.class, Query.select() .where(JOB_ID + " = ?", jobId) .order(TIME_STAMP))); } });
@Nonnull @Override public Collection<ProjectConfiguration> getProjectConfigurations(int startIndex, int maxConfigurationGroup) { final List<String> configurationGroupIds = getConfigurationGroupIds(startIndex, maxConfigurationGroup); if (configurationGroupIds.size() == 0) { return Collections.emptyList(); } final String inClause = Joiner.on(",").join(Collections2.transform(configurationGroupIds, new Function<String, String>() { @Override public String apply(@Nullable String input) { return "'" + input + "'"; } })); final Query query = Query.select() .where(ProjectConfigurationAO.COLUMN_CONFIGURATION_GROUP_ID + " IN (" + inClause + ")") .order(ProjectConfigurationAO.COLUMN_CONFIGURATION_GROUP_ID); ProjectConfigurationAO[] allProjectConfigurationItems = getAO().find(ProjectConfigurationAO.class, query); return Arrays.<ProjectConfiguration>asList(allProjectConfigurationItems); }
@Override public List<JobMapping> doInTransaction() { Query query = Query.select(); if (includeDeleted) { query.where(SITE_ID + " = ?", siteId); } else { query.where(SITE_ID + " = ? AND " + DELETED + " = ?", siteId, Boolean.FALSE); } query.order(NAME); return Arrays.asList(ao.find(JobMapping.class, query)); } });
.from(BuildMapping.class) .where(whereClaus.toString()) .order(TIME_STAMP + DESC);
@Override public List<BuildMapping> doInTransaction() { return Arrays.asList(ao.find(BuildMapping.class, Query.select() .where(JOB_ID + " = ? AND " + BUILD_NUMBER + " >= ? AND " + BUILD_NUMBER + " <= ?", jobId, buildRange.getMinimumInteger(), buildRange.getMaximumInteger()) .order(TIME_STAMP))); } });
public WebHookConfiguration[] getWebHookConfigurations(Repository repo) { return activeObjects.find(WebHookConfiguration.class, Query.select() .where(COLUMN_REPO_ID + " = ?", repo.getId()) .order(COLUMN_TITLE)); }
public WebHookConfiguration[] getEnabledWebHookConfigurations(Repository repo, EventType eventType) { return activeObjects.find(WebHookConfiguration.class, Query.select() .where(COLUMN_REPO_ID + " = ? AND " + COLUMN_ENABLED + " = ? AND " + eventType.getQueryColumn() + " = ?", repo.getId(), true, true) .order(COLUMN_TITLE)); }
.from(IssueMapping.class) .where(finalClaus.toString()) .order(BUILD_DATE + DESC);
query.offset(search.getOffset()); query.distinct(); query.order("ID ASC");
ao.stream(AdminAuditMessageEntity.class, Query.select("ID, DATE, ACTOR, RULE_ID, MESSAGE").offset(startAt).limit(resultsLimit).order("DATE DESC"), new EntityStreamCallback<AdminAuditMessageEntity, Integer>()
List<AuditMessage> messages = Lists.newArrayList(); for (AuditMessageEntity msgEntity : ao.find(AuditMessageEntity.class, Query.select().offset(startAt).limit(resultsLimit).order("DATE DESC")))