Java ViewQuery类代码示例

import org.ektorp.ViewQuery; //导入依赖的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.ViewQuery; //导入依赖的package包/类
@Ignore
public void testConnectRoomNoConflict() {

    List<Site> sites = Arrays.asList(site);

    new Expectations() {{
        dbc.queryView((ViewQuery) any); returns(sites);
    }};

    docs.connectRoom(owner, info);
    System.out.println(site);

    new Verifications() {{
        dbc.update(site); times = 1;
        dbc.create(any); times = 4;
        assertNotNull( "createdOn should be set: " + site, site.getCreatedOn());
        assertNotNull( "assignedOn should be set: " + site, site.getAssignedOn());

    }};
}
 

import org.ektorp.ViewQuery; //导入依赖的package包/类
@Test(expected=MapModificationException.class)
public void testConnectRoomUpdateConflict() {

    List<Site> sites = Arrays.asList(site, site);

    new Expectations() {{
        dbc.queryView((ViewQuery) any, Site.class); returns(sites);
        dbc.queryView((ViewQuery) any, JsonNode.class); returns(Collections.emptyList(), sites);
        dbc.update(site); result = new UpdateConflictException(); result = null;
    }};

    docs.connectRoom(owner, info);
    System.out.println(site);

    new Verifications() {{
        dbc.create(any); times = 4;
        dbc.update(site); times = 2;
        assertNotNull( "createdOn should be set: " + site, site.getCreatedOn());
        assertNotNull( "assignedOn should be set: " + site, site.getAssignedOn());
    }};
}
 

import org.ektorp.ViewQuery; //导入依赖的package包/类
@Test
public void testGetExits(@Mocked ViewResult queryResult, @Mocked ViewResult.Row row, @Mocked JsonNode key) throws Exception {

    List<ViewResult.Row> rows = Arrays.asList(row);
    Exits exits = new Exits();
    exits.setN(new Exit(site, "n"));
    site.setExits(exits);

    final ObjectMapper anyInstance = new ObjectMapper();

    new Expectations(ObjectMapper.class) {{
        anyInstance.treeToValue((TreeNode) any, Site.class); returns(site);
    }};

    new Expectations() {{
        dbc.queryView((ViewQuery) any); returns(queryResult);
        queryResult.getRows(); returns(rows);
        row.getKeyAsNode(); returns(key);
        key.get(2); returns(JsonNodeFactory.instance.textNode("n"));
     }};

    Exits e = docs.getExits(new Coordinates(1,2));
    Assert.assertEquals("Site should be bound to the north", site.getId(), e.getN().getId());
}
 

import org.ektorp.ViewQuery; //导入依赖的package包/类
public List<AppInstanceMetrics> findByAppIdBetween(String appId, long startTimestamp, long endTimestamp)
		throws Exception {

	ComplexKey startKey = ComplexKey.of(appId, startTimestamp);
	ComplexKey endKey = ComplexKey.of(appId, endTimestamp);
	ViewQuery q = createQuery("by_appId_between").includeDocs(true).startKey(startKey).endKey(endKey);

	List<AppInstanceMetrics> returnvalue = null;
	String[] input = beforeConnection("QUERY", new String[] { "by_appId_between", appId,
			String.valueOf(startTimestamp), String.valueOf(endTimestamp) });
	try {
		returnvalue = db.queryView(q, AppInstanceMetrics.class);
	} catch (Exception e) {
		e.printStackTrace();
	}
	afterConnection(input);

	return returnvalue;
}
 

import org.ektorp.ViewQuery; //导入依赖的package包/类
public List<AppInstanceMetrics> findByServiceIdBefore(String serviceId, long olderThan) throws Exception {
	ComplexKey startKey = ComplexKey.of(serviceId, 0);
	ComplexKey endKey = ComplexKey.of(serviceId, olderThan);
	ViewQuery q = createQuery("by_serviceId_before").includeDocs(true).startKey(startKey).endKey(endKey);

	List<AppInstanceMetrics> returnvalue = null;
	String[] input = beforeConnection("QUERY",
			new String[] { "by_serviceId_before", serviceId, String.valueOf(0), String.valueOf(olderThan) });
	try {
		returnvalue = db.queryView(q, AppInstanceMetrics.class);
	} catch (Exception e) {
		e.printStackTrace();
	}
	afterConnection(input);

	return returnvalue;
}
 

import org.ektorp.ViewQuery; //导入依赖的package包/类
public List<ScalingHistory> findByScalingTime(String appId, long startTime, long endTime) {
	ComplexKey startKey = ComplexKey.of(appId, endTime);
	ComplexKey endKey = ComplexKey.of(appId, startTime);
	ViewQuery q = createQuery("findByScalingTime").includeDocs(true).startKey(startKey).endKey(endKey)
			.descending(true);

	List<ScalingHistory> returnvalue = null;
	String[] input = beforeConnection("QUERY",
			new String[] { "findByScalingTime", appId, String.valueOf(startTime), String.valueOf(endTime) });
	try {
		returnvalue = db.queryView(q, ScalingHistory.class);
	} catch (Exception e) {
		e.printStackTrace();
	}
	afterConnection(input);

	return returnvalue;
}
 

import org.ektorp.ViewQuery; //导入依赖的package包/类
@View(name = "get_attachments", map = "function(doc) {if (doc._attachments) {"
        + "emit(doc._id, doc._attachments)}}")
public byte[] getAttachments(String id) {
    ViewQuery q = new ViewQuery()
            .viewName("get_attachments")
            .designDocId("_design/JsonNode")
            .key(id);

    ViewResult result = db.queryView(q);
    try {
        return mapper.writeValueAsBytes(result.getRows().get(0).getValueAsNode());
    } catch (JsonProcessingException ex) {
        logger.error(ex);
    }
    return null;
}
 

import org.ektorp.ViewQuery; //导入依赖的package包/类
@Override
@View(name = "get_data", map = "function(doc) {if (doc.data) {"
        + "emit(doc._id, doc.data)}}")
public byte[] getDataFromDoc(String id) {
    ViewQuery q = new ViewQuery()
            .viewName("get_data")
            .designDocId("_design/JsonNode")
            .key(id);

    ViewResult result = db.queryView(q);
    try {
        return mapper.writeValueAsBytes(result.getRows().get(0).getValueAsNode());
    } catch (JsonProcessingException ex) {
        logger.error(ex);
    }
    return null;
}
 

import org.ektorp.ViewQuery; //导入依赖的package包/类
@Override
@View(name = "get_attachments_revs", map = "function(doc) {if (doc._attachments) { var revs = [];"
        + " for(var key in doc._attachments) {revs.push(key);}"
        + "emit(doc._id, revs)}}")
public List<String> getAttachmentRevisions(String id) {
    ViewQuery q = new ViewQuery()
            .viewName("get_attachments_revs")
            .designDocId("_design/JsonNode")
            .key(id);

    ViewResult result = db.queryView(q);
    try {
        return mapper.treeToValue(result.getRows().get(0).getValueAsNode(), List.class);
    } catch (JsonProcessingException ex) {
        logger.error(ex);
    }
    return null;
}
 

import org.ektorp.ViewQuery; //导入依赖的package包/类
@Override
@View(name = "get_permissions", map = "function(doc) {if (doc.workflow) { "
        + "emit(doc._id, doc.workflow.permissions)}}")
public Set<String> getPermissionsFromDoc(String id) {
    ViewQuery q = new ViewQuery()
            .viewName("get_permissions")
            .designDocId("_design/JsonNode")
            .key(id);

    ViewResult result = db.queryView(q);
    try {
        return mapper.treeToValue(result.getRows().get(0).getValueAsNode(), Set.class);
    } catch (JsonProcessingException ex) {
        logger.error(ex);
    }
    return null;
}
 

import org.ektorp.ViewQuery; //导入依赖的package包/类
private void doIndexingQueryIgnoreTimeout() throws DbAccessException {
	boolean done = false;
	while (!done) {
		try {
			connector.queryView(new ViewQuery()
					.designDocId("_design/statements")
					.viewName(VerbRegistrationQuery.VIEWNAME).limit(1)
					.startKey("").descending(true));
			done = true;
		} catch (DbAccessException e) {
			// TODO review, seems dangerous
			if (e.getCause() instanceof SocketTimeoutException) {
				continue;
			} else {
				throw e;
			}
		}
	}
}
 

import org.ektorp.ViewQuery; //导入依赖的package包/类
@Override
protected DataSet materializeMainSchemaTable(Table table, List<Column> columns, int firstRow, int maxRows) {
    // the connector represents a handle to the the couchdb "database".
    final String databaseName = table.getName();
    final CouchDbConnector connector = _couchDbInstance.createConnector(databaseName, false);

    ViewQuery query = new ViewQuery().allDocs().includeDocs(true);

    if (maxRows > 0) {
        query = query.limit(maxRows);
    }
    if (firstRow > 1) {
        final int skip = firstRow - 1;
        query = query.skip(skip);
    }

    final StreamingViewResult streamingView = connector.queryForStreamingView(query);

    final List<SelectItem> selectItems = columns.stream().map(SelectItem::new).collect(Collectors.toList());
    return new CouchDbDataSet(selectItems, streamingView);
}
 

import org.ektorp.ViewQuery; //导入依赖的package包/类
private ViewQuery createQueryToAppropriateView(String owner, String name) {
    if (owner == null && name == null) {
        return all;
    } else if (owner != null) {
        return createQueryToOwnerNameView(owner, name);
    } else {
        return createQueryToNameView(name);
    }
}
 

import org.ektorp.ViewQuery; //导入依赖的package包/类
private ViewQuery createQueryToOwnerNameView(String owner, String name) {
    ViewQuery ownerNameQuery = createQueryWithoutKeys("owner_name");
    if (name == null) {
        ownerNameQuery = addKeyRangeForAllWithSameFirstEntryInComplexKey(ownerNameQuery, owner);
    } else {
        ownerNameQuery = addComplexKey(ownerNameQuery, owner, name);
    }
    return ownerNameQuery;
}