Search in sources :

Example 21 with Filter

use of io.jans.orm.search.filter.Filter in project jans by JanssenProject.

the class ManualSpannerEntryManagerTest method searchPagedSessionIdWithRanges.

@Test(dependsOnMethods = "deleteSessionId", enabled = false)
public void searchPagedSessionIdWithRanges() throws IOException {
    String outsideSid = UUID.randomUUID().toString();
    for (int i = 0; i < 20; i++) {
        SessionId sessionId = buildSessionId();
        sessionId.setOutsideSid(outsideSid);
        manager.persist(sessionId);
    }
    Filter filter = Filter.createEqualityFilter("sid", outsideSid);
    PagedResult<SessionId> sessionIdList = manager.findPagedEntries("o=jans", SessionId.class, filter, null, "sid", SortOrder.DESCENDING, 0, -1, -1);
    assertNotNull(sessionIdList);
    assertEquals(sessionIdList.getTotalEntriesCount(), 20);
    PagedResult<SessionId> sessionIdList2 = manager.findPagedEntries("o=jans", SessionId.class, filter, null, "sid", SortOrder.DESCENDING, 0, 5, -1);
    assertNotNull(sessionIdList2);
    assertEquals(sessionIdList2.getStart(), 0);
    assertEquals(sessionIdList2.getEntriesCount(), 5);
    assertEquals(sessionIdList2.getTotalEntriesCount(), 20);
    PagedResult<SessionId> sessionIdList4 = manager.findPagedEntries("o=jans", SessionId.class, filter, null, "sid", SortOrder.DESCENDING, 14, 7, 3);
    assertNotNull(sessionIdList4);
    assertEquals(sessionIdList4.getStart(), 14);
    assertEquals(sessionIdList4.getEntriesCount(), 6);
    assertEquals(sessionIdList4.getTotalEntriesCount(), 20);
    PagedResult<SessionId> sessionIdList5 = manager.findPagedEntries("o=jans", SessionId.class, filter, null, "sid", SortOrder.DESCENDING, 20, 10, 5);
    assertNotNull(sessionIdList5);
    assertEquals(sessionIdList5.getStart(), 20);
    assertEquals(sessionIdList5.getEntriesCount(), 0);
    assertEquals(sessionIdList5.getTotalEntriesCount(), 20);
    PagedResult<SessionId> sessionIdList6 = manager.findPagedEntries("o=jans", SessionId.class, filter, null, "sid", SortOrder.DESCENDING, 19, -1, 5);
    assertNotNull(sessionIdList6);
    assertEquals(sessionIdList6.getStart(), 19);
    assertEquals(sessionIdList6.getEntriesCount(), 1);
    assertEquals(sessionIdList6.getTotalEntriesCount(), 20);
}
Also used : Filter(io.jans.orm.search.filter.Filter) Test(org.testng.annotations.Test)

Example 22 with Filter

use of io.jans.orm.search.filter.Filter in project jans by JanssenProject.

the class ManualSpannerEntryManagerTest method deleteSessionIdByFilter.

@Test(dependsOnMethods = "deleteSessionId", enabled = false)
public void deleteSessionIdByFilter() throws IOException {
    String outsideSid = UUID.randomUUID().toString();
    for (int i = 0; i < 20; i++) {
        SessionId sessionId = buildSessionId();
        sessionId.setOutsideSid(outsideSid);
        manager.persist(sessionId);
    }
    Filter filter = Filter.createEqualityFilter("sid", outsideSid);
    int removedCount = manager.remove("ou=sessions,o=jans", SessionId.class, filter, 14);
    assertEquals(removedCount, 14);
    int removedCount2 = manager.remove("ou=sessions,o=jans", SessionId.class, filter, 5);
    assertEquals(removedCount2, 5);
    int removedCount3 = manager.remove("ou=sessions,o=jans", SessionId.class, filter, 1);
    assertEquals(removedCount3, 1);
}
Also used : Filter(io.jans.orm.search.filter.Filter) Test(org.testng.annotations.Test)

Example 23 with Filter

use of io.jans.orm.search.filter.Filter in project jans by JanssenProject.

the class ManualSpannerEntryManagerTest method searchSessionIdWithRanges.

@Test(dependsOnMethods = "deleteSessionId", enabled = false)
public void searchSessionIdWithRanges() throws IOException {
    String outsideSid = UUID.randomUUID().toString();
    for (int i = 0; i < 20; i++) {
        SessionId sessionId = buildSessionId();
        sessionId.setOutsideSid(outsideSid);
        manager.persist(sessionId);
    }
    Filter filter = Filter.createEqualityFilter("sid", outsideSid);
    List<SessionId> sessionIdList = manager.findEntries("o=jans", SessionId.class, filter);
    assertNotNull(sessionIdList);
    assertEquals(sessionIdList.size(), 20);
    List<SessionId> sessionIdList2 = manager.findEntries("o=jans", SessionId.class, filter, 5);
    assertNotNull(sessionIdList2);
    assertEquals(sessionIdList2.size(), 5);
    List<SessionId> sessionIdList3 = manager.findEntries("o=jans", SessionId.class, filter, 25);
    assertNotNull(sessionIdList3);
    assertEquals(sessionIdList3.size(), 20);
    List<SessionId> sessionIdList4 = manager.findEntries("o=jans", SessionId.class, filter, null, null, 14, 7, 3);
    assertNotNull(sessionIdList4);
    assertEquals(sessionIdList4.size(), 6);
    List<SessionId> sessionIdList5 = manager.findEntries("o=jans", SessionId.class, filter, null, null, 20, 10, 5);
    assertNotNull(sessionIdList5);
    assertEquals(sessionIdList5.size(), 0);
    List<SessionId> sessionIdList6 = manager.findEntries("o=jans", SessionId.class, filter, null, null, 19, -1, 5);
    assertNotNull(sessionIdList6);
    assertEquals(sessionIdList6.size(), 1);
}
Also used : Filter(io.jans.orm.search.filter.Filter) Test(org.testng.annotations.Test)

Example 24 with Filter

use of io.jans.orm.search.filter.Filter in project jans by JanssenProject.

the class SpannerSample method main.

public static void main(String[] args) {
    // Prepare sample connection details
    SpannerEntryManagerSample sqlEntryManagerSample = new SpannerEntryManagerSample();
    // Create SQL entry manager
    SpannerEntryManager sqlEntryManager = sqlEntryManagerSample.createSpannerEntryManager();
    SimpleUser newUser = new SimpleUser();
    newUser.setDn(String.format("inum=%s,ou=people,o=jans", System.currentTimeMillis()));
    newUser.setUserId("sample_user_" + System.currentTimeMillis());
    newUser.setUserPassword("pwd");
    newUser.getCustomAttributes().add(new CustomObjectAttribute("address", Arrays.asList("London", "Texas", "Kiev")));
    newUser.getCustomAttributes().add(new CustomObjectAttribute("transientId", "transientId"));
    newUser.getCustomAttributes().add(new CustomObjectAttribute("memberOf", Arrays.asList("1", "2", "3", "3")));
    sqlEntryManager.persist(newUser);
    SimpleUser dummyUser = sqlEntryManager.find(SimpleUser.class, newUser.getDn());
    LOG.info("Dummy User '{}'", dummyUser);
    String[] values = new String[] { "Somewhere: " + System.currentTimeMillis(), "Somewhere2: " + System.currentTimeMillis() };
    dummyUser.getCustomAttributes().add(new CustomObjectAttribute("address", Arrays.asList(values)));
    dummyUser.getCustomAttributes().add(new CustomObjectAttribute("transientId", "new_transientId"));
    dummyUser.getCustomAttributes().add(new CustomObjectAttribute("jansGuid", "test_guid"));
    dummyUser.getCustomAttributes().add(new CustomObjectAttribute("memberOf", Arrays.asList("1", "9")));
    dummyUser.setUserId("user1");
    dummyUser.setUserPassword("test_pwd");
    sqlEntryManager.merge(dummyUser);
    /*
        Filter filterX1 = Filter.createEqualityFilter("transientId", "new_transientId");
        List<SimpleUser> usersss = sqlEntryManager.findEntries("ou=people,o=jans", SimpleUser.class, filterX1);
        System.out.println(usersss.size());
*/
    Filter filterX = Filter.createEqualityFilter("memberOf", "1");
    List<SimpleUser> userss = sqlEntryManager.findEntries("ou=people,o=jans", SimpleUser.class, filterX, new String[] { "memberOf", "uid" }, 10);
    System.out.println(userss.size());
    Filter filterR = Filter.createEqualityFilter("jansGuid", "test_guid");
    int removed = sqlEntryManager.remove("ou=people,o=jans", SimpleUser.class, filterR, 10);
    System.out.println(removed);
    // sqlEntryManager.remove(dummyUser);
    sqlEntryManager.destroy();
    System.exit(0);
    // Find all users which have specified object classes defined in SimpleUser
    List<SimpleUser> users = sqlEntryManager.findEntries("ou=people,o=jans", SimpleUser.class, null);
    for (SimpleUser user : users) {
        LOG.info("User with uid: '{}' with DN: '{}'", user.getUserId(), user.getDn());
    }
    /*
        if (users.size() > 0) {
            // Add attribute "address" to first user
            SimpleUser user = users.get(0);
            LOG.info("Updating: " + user.getUserId());
 
            String[] values = new String[] { "Somewhere: " + System.currentTimeMillis(), "Somewhere2: " + System.currentTimeMillis() };
            user.getCustomAttributes().add(new CustomObjectAttribute("address", Arrays.asList(values)));
            user.getCustomAttributes().add(new CustomObjectAttribute("transientId", "new_transientId"));
            user.getCustomAttributes().add(new CustomObjectAttribute("jansGuid", "test_guid"));
            user.setUserId("user1");
            user.setUserPassword("test_pwd");

            sqlEntryManager.merge(user);
        }
*/
    for (SimpleUser user : users) {
        boolean result1 = sqlEntryManager.authenticate(user.getDn(), SimpleUser.class, "test_pwd");
        boolean result2 = sqlEntryManager.authenticate("ou=people,o=jans", SimpleUser.class, user.getUserId(), "test");
        System.out.println("authetication result: " + result1 + ", " + result2);
    }
    Filter filter = Filter.createEqualityFilter("jansStatus", "active");
    List<SimpleAttribute> attributes = sqlEntryManager.findEntries("o=jans", SimpleAttribute.class, filter, SearchScope.SUB, null, null, 10, 0, 0);
    for (SimpleAttribute attribute : attributes) {
        LOG.info("Attribute with displayName: " + attribute.getCustomAttributes().get(1));
    }
    Filter filter2 = Filter.createEqualityFilter("jansState", "authenticated");
    List<SimpleSession> sessions = sqlEntryManager.findEntries("o=jans", SimpleSession.class, filter2, SearchScope.SUB, null, null, 10, 0, 0);
    LOG.info("Found sessions: " + sessions.size());
    List<SimpleGrant> grants = sqlEntryManager.findEntries("o=jans", SimpleGrant.class, null, SearchScope.SUB, new String[] { "grtId" }, null, 1, 0, 0);
    LOG.info("Found grants: " + grants.size());
    try {
        PagedResult<SimpleUser> listViewResponse = sqlEntryManager.findPagedEntries("o=jans", SimpleUser.class, null, new String[] { "uid", "displayName", "jansStatus" }, "uid", SortOrder.ASCENDING, 0, 6, 4);
        LOG.info("Found persons: " + listViewResponse.getEntriesCount() + ", total persons: " + listViewResponse.getTotalEntriesCount());
        for (SimpleUser user : listViewResponse.getEntries()) {
            System.out.println(user.getUserId());
        }
    } catch (Exception ex) {
        LOG.info("Failed to search", ex);
    }
    try {
        PagedResult<SimpleUser> listViewResponse = sqlEntryManager.findPagedEntries("o=jans", SimpleUser.class, null, new String[] { "uid", "displayName", "jansStatus" }, "uid", SortOrder.DESCENDING, 0, 6, 4);
        LOG.info("Found persons: " + listViewResponse.getEntriesCount() + ", total persons: " + listViewResponse.getTotalEntriesCount());
        for (SimpleUser user : listViewResponse.getEntries()) {
            System.out.println(user.getUserId());
        }
    } catch (Exception ex) {
        LOG.info("Failed to search", ex);
    }
}
Also used : CustomObjectAttribute(io.jans.orm.model.base.CustomObjectAttribute) SimpleUser(io.jans.orm.cloud.spanner.model.SimpleUser) SimpleAttribute(io.jans.orm.cloud.spanner.model.SimpleAttribute) SimpleGrant(io.jans.orm.cloud.spanner.model.SimpleGrant) Filter(io.jans.orm.search.filter.Filter) SpannerEntryManagerSample(io.jans.orm.cloud.spanner.persistence.SpannerEntryManagerSample) SimpleSession(io.jans.orm.cloud.spanner.model.SimpleSession) SpannerEntryManager(io.jans.orm.cloud.spanner.impl.SpannerEntryManager)

Example 25 with Filter

use of io.jans.orm.search.filter.Filter in project jans by JanssenProject.

the class SqlDeleteSample method main.

public static void main(String[] args) {
    // Prepare sample connection details
    SqlEntryManagerSample sqlEntryManagerSample = new SqlEntryManagerSample();
    // Create SQL entry manager
    SqlEntryManager sqlEntryManager = sqlEntryManagerSample.createSqlEntryManager();
    String baseDn = "ou=people,o=jans";
    Filter filter = Filter.createANDFilter(Filter.createEqualityFilter("del", true), Filter.createLessOrEqualFilter("exp", sqlEntryManager.encodeTime(baseDn, new Date())));
    int result = sqlEntryManager.remove(baseDn, SimpleSession.class, filter, 5);
    System.out.println(result);
}
Also used : Filter(io.jans.orm.search.filter.Filter) SqlEntryManagerSample(io.jans.orm.sql.persistence.SqlEntryManagerSample) SqlEntryManager(io.jans.orm.sql.impl.SqlEntryManager) Date(java.util.Date)

Aggregations

Filter (io.jans.orm.search.filter.Filter)188 Test (org.testng.annotations.Test)50 EntryPersistenceException (io.jans.orm.exception.EntryPersistenceException)32 ConvertedExpression (io.jans.orm.couchbase.model.ConvertedExpression)28 SearchException (io.jans.orm.exception.operation.SearchException)25 ConvertedExpression (io.jans.orm.sql.model.ConvertedExpression)24 MappingException (io.jans.orm.exception.MappingException)22 ArrayList (java.util.ArrayList)21 AuthenticationException (io.jans.orm.exception.AuthenticationException)20 PropertyAnnotation (io.jans.orm.reflect.property.PropertyAnnotation)19 EntryDeleteException (io.jans.orm.exception.EntryDeleteException)18 Date (java.util.Date)14 List (java.util.List)14 SqlEntryManager (io.jans.orm.sql.impl.SqlEntryManager)11 SqlEntryManagerSample (io.jans.orm.sql.persistence.SqlEntryManagerSample)11 CustomAttribute (io.jans.orm.model.base.CustomAttribute)9 CustomObjectAttribute (io.jans.orm.model.base.CustomObjectAttribute)9 DateTimeParseException (java.time.format.DateTimeParseException)9 SpannerEntryManager (io.jans.orm.cloud.spanner.impl.SpannerEntryManager)8 SpannerEntryManagerSample (io.jans.orm.cloud.spanner.persistence.SpannerEntryManagerSample)8