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.component.ComponentDao.java

License:Open Source License

public List<ComponentDto> selectGhostProjects(DbSession session, int offset, int limit,
        @Nullable String query) {
    Map<String, Object> parameters = newHashMapWithExpectedSize(2);
    addProjectQualifier(parameters);//  w  w  w.j  a va 2s  .co  m
    addPartialQueryParameterIfNotNull(parameters, query);

    return mapper(session).selectGhostProjects(parameters, new RowBounds(offset, limit));
}

From source file:org.sonar.db.component.ComponentDaoTest.java

License:Open Source License

@Test
public void select_provisioned() {
    OrganizationDto organization = db.organizations().insert();
    ComponentDto provisionedProject = db.components().insertComponent(
            newProjectDto(organization).setKey("provisioned.project").setName("Provisioned Project"));
    ComponentDto provisionedView = db.components().insertView(organization);
    String projectUuid = db.components().insertProjectAndSnapshot(ComponentTesting.newProjectDto(organization))
            .getComponentUuid();//from  w ww  .  java  2 s. com
    String disabledProjectUuid = db.components()
            .insertProjectAndSnapshot(ComponentTesting.newProjectDto(organization).setEnabled(false))
            .getComponentUuid();
    String viewUuid = db.components().insertProjectAndSnapshot(ComponentTesting.newView(organization))
            .getComponentUuid();

    Set<String> projectQualifiers = newHashSet(Qualifiers.PROJECT);
    assertThat(underTest.selectProvisioned(dbSession, organization.getUuid(), null, projectQualifiers,
            new RowBounds(0, 10))).extracting(ComponentDto::uuid).containsOnly(provisionedProject.uuid());

    // pagination
    assertThat(underTest.selectProvisioned(dbSession, organization.getUuid(), null, projectQualifiers,
            new RowBounds(2, 10))).isEmpty();

    // filter on qualifiers
    assertThat(underTest.selectProvisioned(dbSession, organization.getUuid(), null, newHashSet("XXX"),
            new RowBounds(0, 10))).isEmpty();
    assertThat(underTest.selectProvisioned(dbSession, organization.getUuid(), null,
            newHashSet(Qualifiers.PROJECT, "XXX"), new RowBounds(0, 10))).extracting(ComponentDto::uuid)
                    .containsOnly(provisionedProject.uuid());
    assertThat(underTest.selectProvisioned(dbSession, organization.getUuid(), null,
            newHashSet(Qualifiers.PROJECT, Qualifiers.VIEW), new RowBounds(0, 10)))
                    .extracting(ComponentDto::uuid)
                    .containsOnly(provisionedProject.uuid(), provisionedView.uuid());

    // match key
    assertThat(underTest.selectProvisioned(dbSession, organization.getUuid(), provisionedProject.getKey(),
            projectQualifiers, new RowBounds(0, 10))).extracting(ComponentDto::uuid)
                    .containsExactly(provisionedProject.uuid());
    assertThat(underTest.selectProvisioned(dbSession, organization.getUuid(), "pROvisiONed.proJEcT",
            projectQualifiers, new RowBounds(0, 10))).extracting(ComponentDto::uuid)
                    .containsExactly(provisionedProject.uuid());
    assertThat(underTest.selectProvisioned(dbSession, organization.getUuid(), "missing", projectQualifiers,
            new RowBounds(0, 10))).isEmpty();
    assertThat(underTest.selectProvisioned(dbSession, organization.getUuid(), "to be escaped '\"\\%",
            projectQualifiers, new RowBounds(0, 10))).isEmpty();

    // match name
    assertThat(underTest.selectProvisioned(dbSession, organization.getUuid(), "ned proj", projectQualifiers,
            new RowBounds(0, 10))).extracting(ComponentDto::uuid).containsExactly(provisionedProject.uuid());
}

From source file:org.sonar.db.component.SnapshotDao.java

License:Open Source License

@CheckForNull
public SnapshotDto selectOldestSnapshot(DbSession session, long componentId) {
    List<SnapshotDto> snapshotDtos = mapper(session).selectOldestSnapshots(componentId, new RowBounds(0, 1));
    return snapshotDtos.isEmpty() ? null : snapshotDtos.get(0);
}

From source file:org.sonar.db.measure.custom.CustomMeasureDao.java

License:Open Source License

public List<CustomMeasureDto> selectByComponentUuid(DbSession session, String componentUuid, int offset,
        int limit) {
    return mapper(session).selectByComponentUuid(componentUuid, new RowBounds(offset, limit));
}

From source file:org.sonar.db.metric.MetricDao.java

License:Open Source License

public List<MetricDto> selectEnabled(DbSession session, @Nullable Boolean isCustom, int offset, int limit) {
    Map<String, Object> properties = Maps.newHashMapWithExpectedSize(1);
    if (isCustom != null) {
        properties.put("isCustom", isCustom);
    }//from   w  ww  .j  av a2s.c  o m

    return mapper(session).selectAllEnabled(properties, new RowBounds(offset, limit));
}

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

License:Open Source License

/**
 * Returns the names of the groups that match the given query, for the given organization.
 * The virtual group "Anyone" may be returned as the value {@link DefaultGroups#ANYONE}.
 * @return group names, sorted in alphabetical order
 *//*from  www. j  a  va 2  s  .  c o m*/
public List<String> selectGroupNamesByQuery(DbSession dbSession, PermissionQuery query) {
    return mapper(dbSession).selectGroupNamesByQuery(query,
            new RowBounds(query.getPageOffset(), query.getPageSize()));
}

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

License:Open Source License

/**
 * @return a paginated list of users./*from w ww.  jav a2s . c o m*/
 */
public List<UserWithPermissionDto> selectUsers(DbSession session, PermissionQuery query,
        @Nullable Long componentId, int offset, int limit) {
    Map<String, Object> params = usersParameters(query, componentId);

    return mapper(session).selectUsers(params, new RowBounds(offset, limit));
}

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

License:Open Source License

/**
 * @return a paginated list of users./*ww w. j  av a  2  s  . c o m*/
 */
public List<UserWithPermissionDto> selectUsers(DbSession session, PermissionQuery query, Long templateId,
        int offset, int limit) {
    Map<String, Object> params = newHashMap();
    params.put(QUERY_PARAMETER, query);
    params.put(TEMPLATE_ID_PARAMETER, templateId);
    return mapper(session).selectUsers(params, new RowBounds(offset, limit));
}

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

License:Open Source License

public List<GroupWithPermissionDto> selectGroups(DbSession session, PermissionQuery query, Long templateId,
        int offset, int limit) {
    Map<String, Object> params = groupsParameters(query, templateId);
    return mapper(session).selectGroups(params, new RowBounds(offset, limit));
}

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

License:Open Source License

/**
 * @return a paginated list of user logins.
 *//*from w ww  .  j av a 2  s  . c o  m*/
public List<String> selectUserLoginsByQueryAndTemplate(DbSession session, PermissionQuery query,
        long templateId) {
    return mapper(session).selectUserLoginsByQueryAndTemplate(query, templateId,
            new RowBounds(query.getPageOffset(), query.getPageSize()));
}