Java CouchDbConnector.queryView方法代码示例

import org.ektorp.CouchDbConnector; //导入方法依赖的package包/类
private JSONArray getComments(String itemNumber) {
	JSONArray returnArray = new JSONArray();
	CouchDbConnector dbc = _db.createConnector(dbname, true);

	Map<String, String> doc = new HashMap<String, String>();

	ViewQuery query = new ViewQuery().allDocs().includeDocs(true);
	List<Map> result = dbc.queryView(query, Map.class);
	JSONArray jsonresult = new JSONArray();
	for (Map element : result) {
		JSONObject obj = new JSONObject();
		obj.putAll(element);
		if(itemNumber==null || obj.get("itemNumber").equals(itemNumber))
			jsonresult.add(obj);
	}

	System.out.println(jsonresult.toString());

	return jsonresult;

}
 

import org.ektorp.CouchDbConnector; //导入方法依赖的package包/类
@Override
public final StatementResult getQueryResult(CouchDbConnector connector,
		StatementFilter filter, QueryStrategy strategy) {

	int limit = resolveLimit(filter.getLimit());
	boolean isAscending = resolveAscending(filter.getAscending());

	ViewQuery viewQuery = getViewQuery(filter, limit, isAscending);
	viewQuery.staleOk(strategy == QueryStrategy.STALE);
	List<StatementDocument> docs = connector.queryView(viewQuery,
			StatementDocument.class);

	StatementDocument nextDoc = null;
	if (docs.size() > limit) {
		nextDoc = docs.remove(docs.size() - 1);
	}

	StatementResult result = new StatementResult(docsToStatement(docs),
			null);

	if (nextDoc != null) {
		StatementFilter moreFilter = new StatementFilter(filter);
		copyStartKeyValuesToFilter(moreFilter, nextDoc, isAscending);
		moreFilter.setStartId(nextDoc.getId());
		result.setMore(StatementFilterUtil.toMoreUrl(moreFilter));
	}
	return result;
}
 

import org.ektorp.CouchDbConnector; //导入方法依赖的package包/类
public static StatementDocument getLastIndexed(CouchDbConnector connector) {
	String nowDateStr = MapQuery.date2String(new Date());

	ViewQuery query = new ViewQuery()
			.viewName(VerbRegistrationQuery.VIEWNAME)
			.designDocId("_design/statements")
			. startKey(ComplexKey.of("ALL", null, null, nowDateStr))
			.limit(1).staleOk(true).descending(true).inclusiveEnd(true)
			.includeDocs(true);

	List<StatementDocument> qResult = connector.queryView(query,
			StatementDocument.class);
	return qResult.size() > 0 ? qResult.get(0) : null;
}
 

import org.ektorp.CouchDbConnector; //导入方法依赖的package包/类
public void testViewQueryFromWeb() throws IOException {

        HttpClient httpClient = new CBLiteHttpClient(manager);
        CouchDbInstance dbInstance = new StdCouchDbInstance(httpClient);

        CouchDbConnector couchDbConnector = dbInstance.createConnector(DEFAULT_TEST_DB, true);

        String dDocName = "ddoc";
        String viewName = "people";
        View view = database.getView(String.format("%s/%s", dDocName, viewName));

        view.setMapReduce(new Mapper() {
                              @Override
                              public void map(Map<String, Object> document, Emitter emitter) {
                                  String type = (String) document.get("type");
                                  if ("person".equals(type)) {
                                      emitter.emit(null, document.get("_id"));
                                  }
                              }
                          }, new Reducer() {
                              @Override
                              public Object reduce(List<Object> keys, List<Object> values, boolean rereduce) {
                                  return null;
                              }
                          }, "1"
        );

        ViewQuery viewQuery = new ViewQuery().designDocId("_design/" + dDocName).viewName(viewName);
        //viewQuery.descending(true); //use this to reverse the sorting order of the view
        ViewResult viewResult = couchDbConnector.queryView(viewQuery);

        Assert.assertEquals(0, viewResult.getTotalRows());

    }
 

import org.ektorp.CouchDbConnector; //导入方法依赖的package包/类
public void testViewReduceQuery() throws IOException {

        HttpClient httpClient = new CBLiteHttpClient(manager);
        CouchDbInstance dbInstance = new StdCouchDbInstance(httpClient);

        CouchDbConnector dbConnector = dbInstance.createConnector(DEFAULT_TEST_DB, true);

        putDocs(dbConnector);
        createViewWithReduce(database);


        //because this view has a reduce function it should default to reduce=true
        ViewQuery query = new ViewQuery().designDocId(dDocId).viewName(viewReduceName);
        ViewResult result = dbConnector.queryView(query);

        Assert.assertEquals(1, result.getTotalRows());
        Assert.assertEquals(5, result.getRows().get(0).getValueAsInt());

        //we should still be able to override it and force reduce=false
        query = new ViewQuery().designDocId(dDocId).viewName(viewReduceName).reduce(false);
        result = dbConnector.queryView(query);

        Assert.assertEquals(5, result.getTotalRows());
    }