Examples with AttributeCond org.apache.syncope.core.persistence.api.dao.search.AttributeCond used on opensource projects

Example 31 with AttributeCond

use of org.apache.syncope.core.persistence.api.dao.search.AttributeCond in project syncope by apache.

the class AnySearchTest method searchByBooleanAnyCond.

@Test
public void searchByBooleanAnyCond() {
    AttributeCond booleanCond = new AttributeCond(AnyCond.Type.EQ);
    booleanCond.setSchema("show");
    booleanCond.setExpression("true");
    List<Group> matchingGroups = searchDAO.search(SearchCond.getLeafCond(booleanCond), AnyTypeKind.GROUP);
    assertNotNull(matchingGroups);
    assertFalse(matchingGroups.isEmpty());
}

Example 32 with AttributeCond

use of org.apache.syncope.core.persistence.api.dao.search.AttributeCond in project syncope by apache.

the class AnySearchTest method searchByUsernameAndFullnameIgnoreCase.

@Test
public void searchByUsernameAndFullnameIgnoreCase() {
    AnyCond usernameLeafCond = new AnyCond(AnyCond.Type.IEQ);
    usernameLeafCond.setSchema("username");
    usernameLeafCond.setExpression("RoSsini");
    AttributeCond idRightCond = new AttributeCond(AttributeCond.Type.ILIKE);
    idRightCond.setSchema("fullname");
    idRightCond.setExpression("gIuseppe v%");
    SearchCond searchCondition = SearchCond.getOrCond(SearchCond.getLeafCond(usernameLeafCond), SearchCond.getLeafCond(idRightCond));
    List<User> matchingUsers = searchDAO.search(searchCondition, AnyTypeKind.USER);
    assertNotNull(matchingUsers);
    assertEquals(2, matchingUsers.size());
}

Example 33 with AttributeCond

use of org.apache.syncope.core.persistence.api.dao.search.AttributeCond in project syncope by apache.

the class AnySearchTest method searchByIsNull.

@Test
public void searchByIsNull() {
    AttributeCond coolLeafCond = new AttributeCond(AttributeCond.Type.ISNULL);
    coolLeafCond.setSchema("cool");
    List<User> users = searchDAO.search(SearchCond.getLeafCond(coolLeafCond), AnyTypeKind.USER);
    assertNotNull(users);
    assertEquals(4, users.size());
    coolLeafCond = new AttributeCond(AttributeCond.Type.ISNOTNULL);
    coolLeafCond.setSchema("cool");
    users = searchDAO.search(SearchCond.getLeafCond(coolLeafCond), AnyTypeKind.USER);
    assertNotNull(users);
    assertEquals(1, users.size());
}

Example 34 with AttributeCond

use of org.apache.syncope.core.persistence.api.dao.search.AttributeCond in project syncope by apache.

the class AnySearchTest method searchByPageAndSize.

@Test
public void searchByPageAndSize() {
    AttributeCond fullnameLeafCond = new AttributeCond(AttributeCond.Type.LIKE);
    fullnameLeafCond.setSchema("fullname");
    fullnameLeafCond.setExpression("%o%");
    MembershipCond groupCond = new MembershipCond();
    groupCond.setGroup("root");
    AttributeCond loginDateCond = new AttributeCond(AttributeCond.Type.EQ);
    loginDateCond.setSchema("loginDate");
    loginDateCond.setExpression("2009-05-26");
    SearchCond subCond = SearchCond.getAndCond(SearchCond.getLeafCond(fullnameLeafCond), SearchCond.getLeafCond(groupCond));
    assertTrue(subCond.isValid());
    SearchCond cond = SearchCond.getAndCond(subCond, SearchCond.getLeafCond(loginDateCond));
    assertTrue(cond.isValid());
    List<User> users = searchDAO.search(SyncopeConstants.FULL_ADMIN_REALMS, cond, 1, 2, Collections.<OrderByClause>emptyList(), AnyTypeKind.USER);
    assertNotNull(users);
    assertEquals(1, users.size());
    users = searchDAO.search(SyncopeConstants.FULL_ADMIN_REALMS, cond, 2, 2, Collections.<OrderByClause>emptyList(), AnyTypeKind.USER);
    assertNotNull(users);
    assertTrue(users.isEmpty());
}

Example 35 with AttributeCond

use of org.apache.syncope.core.persistence.api.dao.search.AttributeCond in project syncope by apache.

the class AnySearchTest method userOrderBy.

@Test
public void userOrderBy() {
    AnyCond usernameLeafCond = new AnyCond(AnyCond.Type.EQ);
    usernameLeafCond.setSchema("username");
    usernameLeafCond.setExpression("rossini");
    AttributeCond idRightCond = new AttributeCond(AttributeCond.Type.LIKE);
    idRightCond.setSchema("fullname");
    idRightCond.setExpression("Giuseppe V%");
    SearchCond searchCondition = SearchCond.getOrCond(SearchCond.getLeafCond(usernameLeafCond), SearchCond.getLeafCond(idRightCond));
    List<OrderByClause> orderByClauses = new ArrayList<>();
    OrderByClause orderByClause = new OrderByClause();
    orderByClause.setField("username");
    orderByClause.setDirection(OrderByClause.Direction.DESC);
    orderByClauses.add(orderByClause);
    orderByClause = new OrderByClause();
    orderByClause.setField("fullname");
    orderByClause.setDirection(OrderByClause.Direction.ASC);
    orderByClauses.add(orderByClause);
    List<User> users = searchDAO.search(searchCondition, orderByClauses, AnyTypeKind.USER);
    assertEquals(searchDAO.count(SyncopeConstants.FULL_ADMIN_REALMS, searchCondition, AnyTypeKind.USER), users.size());
}