Search in sources :

Example 1 with DominoQuery

use of lotus.domino.DominoQuery in project org.openntf.xsp.jakartaee by OpenNTF.

the class DefaultDominoDocumentCollectionManager method delete.

@Override
public void delete(DocumentDeleteQuery query) {
    try {
        Database database = supplier.get();
        List<String> unids = query.getDocuments();
        if (unids != null && !unids.isEmpty()) {
            for (String unid : unids) {
                if (unid != null && !unid.isEmpty()) {
                    lotus.domino.Document doc = database.getDocumentByUNID(unid);
                    doc.remove(true);
                }
            }
        } else if (query.getCondition().isPresent()) {
            // Then do it via DQL
            DQLTerm dql = QueryConverter.getCondition(query.getCondition().get());
            DominoQuery dominoQuery = database.createDominoQuery();
            DocumentCollection docs = dominoQuery.execute(dql.toString());
            docs.removeAll(true);
        }
    } catch (NotesException e) {
        throw new RuntimeException(e);
    }
}
Also used : NotesException(lotus.domino.NotesException) Database(lotus.domino.Database) DominoQuery(lotus.domino.DominoQuery) DocumentCollection(lotus.domino.DocumentCollection) DQLTerm(org.openntf.xsp.nosql.communication.driver.DQL.DQLTerm)

Example 2 with DominoQuery

use of lotus.domino.DominoQuery in project org.openntf.xsp.jakartaee by OpenNTF.

the class DefaultDominoDocumentCollectionManager method select.

@Override
public Stream<DocumentEntity> select(DocumentQuery query) {
    try {
        QueryConverterResult queryResult = QueryConverter.select(query);
        long skip = queryResult.getSkip();
        long limit = queryResult.getLimit();
        List<Sort> sorts = query.getSorts();
        Stream<DocumentEntity> result;
        if (sorts != null && !sorts.isEmpty()) {
            Database database = supplier.get();
            Session sessionAsSigner = sessionSupplier.get();
            Database qrpDatabase = getQrpDatabase(sessionAsSigner, database);
            String userName = database.getParent().getEffectiveUserName();
            // $NON-NLS-1$
            String viewName = getClass().getName() + "-" + (String.valueOf(sorts) + skip + limit + userName).hashCode();
            View view = qrpDatabase.getView(viewName);
            try {
                if (view != null) {
                    // Check to see if we need to "expire" it based on the data mod time of the DB
                    DateTime created = view.getCreated();
                    try {
                        long dataMod = NotesSession.getLastDataModificationDateByName(database.getServer(), database.getFilePath());
                        if (dataMod > (created.toJavaDate().getTime() / 1000)) {
                            view.remove();
                            view.recycle();
                            view = null;
                        }
                    } catch (NotesAPIException e) {
                        throw new RuntimeException(e);
                    } finally {
                        recycle(created);
                    }
                }
                if (view != null) {
                    result = EntityConverter.convert(database, view);
                } else {
                    DominoQuery dominoQuery = database.createDominoQuery();
                    QueryResultsProcessor qrp = qrpDatabase.createQueryResultsProcessor();
                    try {
                        qrp.addDominoQuery(dominoQuery, queryResult.getStatement().toString(), null);
                        for (Sort sort : sorts) {
                            int dir = sort.getType() == SortType.DESC ? QueryResultsProcessor.SORT_DESCENDING : QueryResultsProcessor.SORT_ASCENDING;
                            qrp.addColumn(sort.getName(), null, null, dir, false, false);
                        }
                        if (skip == 0 && limit > 0 && limit <= Integer.MAX_VALUE) {
                            qrp.setMaxEntries((int) limit);
                        }
                        view = qrp.executeToView(viewName, 24);
                        try {
                            result = EntityConverter.convert(database, view);
                        } finally {
                            recycle(view);
                        }
                    } finally {
                        recycle(qrp, dominoQuery, qrpDatabase);
                    }
                }
            } finally {
                recycle(view);
            }
        } else {
            Database database = supplier.get();
            DominoQuery dominoQuery = database.createDominoQuery();
            DocumentCollection docs = dominoQuery.execute(queryResult.getStatement().toString());
            try {
                result = EntityConverter.convert(docs);
            } finally {
                recycle(docs, dominoQuery);
            }
        }
        if (skip > 0) {
            result = result.skip(skip);
        }
        if (limit > 0) {
            result = result.limit(limit);
        }
        return result;
    } catch (NotesException e) {
        throw new RuntimeException(e);
    }
}
Also used : QueryResultsProcessor(lotus.domino.QueryResultsProcessor) QueryConverterResult(org.openntf.xsp.nosql.communication.driver.QueryConverter.QueryConverterResult) DocumentCollection(lotus.domino.DocumentCollection) View(lotus.domino.View) DateTime(lotus.domino.DateTime) NotesException(lotus.domino.NotesException) DocumentEntity(jakarta.nosql.document.DocumentEntity) Database(lotus.domino.Database) Sort(jakarta.nosql.Sort) NotesAPIException(com.ibm.designer.domino.napi.NotesAPIException) DominoQuery(lotus.domino.DominoQuery) NotesSession(com.ibm.designer.domino.napi.NotesSession) Session(lotus.domino.Session)

Example 3 with DominoQuery

use of lotus.domino.DominoQuery in project org.openntf.xsp.jakartaee by OpenNTF.

the class DefaultDominoDocumentCollectionManager method count.

@Override
public long count(String documentCollection) {
    try {
        Database database = supplier.get();
        DominoQuery dominoQuery = database.createDominoQuery();
        DQLTerm dql = DQL.item(EntityConverter.NAME_FIELD).isEqualTo(documentCollection);
        DocumentCollection result = dominoQuery.execute(dql.toString());
        return result.getCount();
    } catch (NotesException e) {
        throw new RuntimeException(e);
    }
}
Also used : NotesException(lotus.domino.NotesException) Database(lotus.domino.Database) DominoQuery(lotus.domino.DominoQuery) DocumentCollection(lotus.domino.DocumentCollection) DQLTerm(org.openntf.xsp.nosql.communication.driver.DQL.DQLTerm)

Aggregations

Database (lotus.domino.Database)3 DocumentCollection (lotus.domino.DocumentCollection)3 DominoQuery (lotus.domino.DominoQuery)3 NotesException (lotus.domino.NotesException)3 DQLTerm (org.openntf.xsp.nosql.communication.driver.DQL.DQLTerm)2 NotesAPIException (com.ibm.designer.domino.napi.NotesAPIException)1 NotesSession (com.ibm.designer.domino.napi.NotesSession)1 Sort (jakarta.nosql.Sort)1 DocumentEntity (jakarta.nosql.document.DocumentEntity)1 DateTime (lotus.domino.DateTime)1 QueryResultsProcessor (lotus.domino.QueryResultsProcessor)1 Session (lotus.domino.Session)1 View (lotus.domino.View)1 QueryConverterResult (org.openntf.xsp.nosql.communication.driver.QueryConverter.QueryConverterResult)1