Example usage for org.apache.ibatis.session RowBounds RowBounds

Introduction

In this page you can find the example usage for org.apache.ibatis.session RowBounds RowBounds.

Prototype

public RowBounds(int offset, int limit)

Source Link

Usage

From source file:org.sonar.db.permission.template.PermissionTemplateDao.java

License:Open Source License

public List<String> selectGroupNamesByQueryAndTemplate(DbSession session, PermissionQuery query,
        long templateId) {
    return mapper(session).selectGroupNamesByQueryAndTemplate(templateId, query,
            new RowBounds(query.getPageOffset(), query.getPageSize()));
}

From source file:org.sonar.db.permission.UserPermissionDao.java

License:Open Source License

/**
 * List of user permissions ordered by alphabetical order of user names
 *  @param query non-null query including optional filters.
 * @param userLogins if null, then filter on all active users. If not null, then filter on logins, including disabled users.
 *                   Must not be empty. If not null then maximum size is {@link DatabaseUtils#PARTITION_SIZE_FOR_ORACLE}.
 *//* w  w  w  .j  av a2  s. c o m*/
public List<UserPermissionDto> select(DbSession dbSession, PermissionQuery query,
        @Nullable Collection<String> userLogins) {
    if (userLogins != null) {
        if (userLogins.isEmpty()) {
            return emptyList();
        }
        checkArgument(userLogins.size() <= DatabaseUtils.PARTITION_SIZE_FOR_ORACLE,
                "Maximum 1'000 users are accepted");
    }

    RowBounds rowBounds = new RowBounds(query.getPageOffset(), query.getPageSize());
    return mapper(dbSession).selectByQuery(query, userLogins, rowBounds);
}

From source file:org.sonar.db.qualitygate.ProjectQgateAssociationDao.java

License:Open Source License

public List<ProjectQgateAssociationDto> selectProjects(ProjectQgateAssociationQuery query, Long gateId,
        int offset, int limit) {
    SqlSession session = mybatis.openSession(false);
    try {/*w  ww .  j av a2  s .c o m*/
        Map<String, Object> params = ImmutableMap.of("query", query, "gateId", gateId.toString());
        return mapper(session).selectProjects(params, new RowBounds(offset, limit));
    } finally {
        MyBatis.closeQuietly(session);
    }
}

From source file:org.sonar.db.user.GroupDao.java

License:Open Source License

public List<GroupDto> selectByQuery(DbSession session, @Nullable String query, int offset, int limit) {
    return mapper(session).selectByQuery(groupSearchToSql(query), new RowBounds(offset, limit));
}

From source file:org.sonar.db.user.GroupMembershipDao.java

License:Open Source License

public List<GroupMembershipDto> selectGroups(SqlSession session, GroupMembershipQuery query, Long userId,
        int offset, int limit) {
    Map<String, Object> params = ImmutableMap.of("query", query, "userId", userId);
    return mapper(session).selectGroups(params, new RowBounds(offset, limit));
}

From source file:org.sonar.db.user.GroupMembershipDao.java

License:Open Source License

public List<UserMembershipDto> selectMembers(SqlSession session, UserMembershipQuery query, int offset,
        int limit) {
    Map<String, Object> params = ImmutableMap.of("query", query, "groupId", query.groupId());
    return mapper(session).selectMembers(params, new RowBounds(offset, limit));
}

From source file:org.sonar.db.webhook.WebhookDeliveryDao.java

License:Open Source License

/**
 * All the deliveries for the specified webhook. Results are ordered by descending date.
 *///from ww w .  ja v a  2s.  com
public List<WebhookDeliveryLiteDto> selectByWebhookUuid(DbSession dbSession, String webhookUuid, int offset,
        int limit) {
    return mapper(dbSession).selectByWebhookUuid(webhookUuid, new RowBounds(offset, limit));
}

From source file:org.sonar.db.webhook.WebhookDeliveryDao.java

License:Open Source License

/**
 * All the deliveries for the specified component. Results are ordered by descending date.
 *///from  ww  w.j  a  v a 2  s .  co m
public List<WebhookDeliveryLiteDto> selectOrderedByComponentUuid(DbSession dbSession, String componentUuid,
        int offset, int limit) {
    return mapper(dbSession).selectOrderedByComponentUuid(componentUuid, new RowBounds(offset, limit));
}

From source file:org.sonar.db.webhook.WebhookDeliveryDao.java

License:Open Source License

/**
 * All the deliveries for the specified CE task. Results are ordered by descending date.
 *//*from  w  ww.  j  ava  2  s  . c o m*/
public List<WebhookDeliveryLiteDto> selectOrderedByCeTaskUuid(DbSession dbSession, String ceTaskUuid,
        int offset, int limit) {
    return mapper(dbSession).selectOrderedByCeTaskUuid(ceTaskUuid, new RowBounds(offset, limit));
}

From source file:org.sonar.server.component.db.ComponentDao.java

License:Open Source License

public List<ComponentDto> selectProvisionedProjects(DbSession session, SearchOptions searchOptions,
        @Nullable String query) {
    Map<String, String> parameters = newHashMapWithExpectedSize(2);
    addProjectQualifier(parameters);//from w w w. ja va 2s  .  c om
    addPartialQueryParameterIfNotNull(parameters, query);

    return mapper(session).selectProvisionedProjects(parameters,
            new RowBounds(searchOptions.getOffset(), searchOptions.getLimit()));
}