use of org.apache.syncope.core.persistence.api.dao.search.AnyCond in project syncope by apache.
the class AnySearchTest method issueSYNCOPE433.
@Test
public void issueSYNCOPE433() {
AttributeCond isNullCond = new AttributeCond(AttributeCond.Type.ISNULL);
isNullCond.setSchema("loginDate");
AnyCond likeCond = new AnyCond(AttributeCond.Type.LIKE);
likeCond.setSchema("username");
likeCond.setExpression("%ossin%");
SearchCond searchCond = SearchCond.getOrCond(SearchCond.getLeafCond(isNullCond), SearchCond.getLeafCond(likeCond));
Integer count = searchDAO.count(SyncopeConstants.FULL_ADMIN_REALMS, searchCond, AnyTypeKind.USER);
assertNotNull(count);
assertTrue(count > 0);
}
use of org.apache.syncope.core.persistence.api.dao.search.AnyCond in project syncope by apache.
the class AnySearchTest method searchByUsernameAndKey.
@Test
public void searchByUsernameAndKey() {
AnyCond usernameLeafCond = new AnyCond(AnyCond.Type.LIKE);
usernameLeafCond.setSchema("username");
usernameLeafCond.setExpression("%ini");
AnyCond idRightCond = new AnyCond(AnyCond.Type.LT);
idRightCond.setSchema("id");
idRightCond.setExpression("2");
SearchCond searchCondition = SearchCond.getAndCond(SearchCond.getLeafCond(usernameLeafCond), SearchCond.getLeafCond(idRightCond));
List<User> matching = searchDAO.search(searchCondition, AnyTypeKind.USER);
assertNotNull(matching);
assertEquals(1, matching.size());
assertEquals("rossini", matching.iterator().next().getUsername());
assertEquals("1417acbe-cbf6-4277-9372-e75e04f97000", matching.iterator().next().getKey());
}
use of org.apache.syncope.core.persistence.api.dao.search.AnyCond 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());
}
use of org.apache.syncope.core.persistence.api.dao.search.AnyCond 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());
}
use of org.apache.syncope.core.persistence.api.dao.search.AnyCond in project syncope by apache.
the class AnySearchTest method issue242.
@Test
public void issue242() {
AnyCond cond = new AnyCond(AttributeCond.Type.LIKE);
cond.setSchema("id");
cond.setExpression("test%");
SearchCond searchCondition = SearchCond.getLeafCond(cond);
assertTrue(searchCondition.isValid());
List<User> users = searchDAO.search(searchCondition, AnyTypeKind.USER);
assertNotNull(users);
assertTrue(users.isEmpty());
}
Aggregations