mongodb runCommand返回的数据

[sanergogogo]

ret = db:runCommand("aggregate", "testcoll", "pipeline", pipeline, "cursor", {})
assert(ret and ret.cursor.firstBatch[1].test_key_total == 4)
assert(ret and ret.cursor.firstBatch[1].test_key2_total == 6)

有2个问题不太清楚想请教下

1. ret.cursor.firstBatch返回的是否会返回所有数据？如果不是返回所有，应该怎么操作
2. ret = db:runCommand("aggregate", "testcoll", "pipeline", pipeline, "cursor", {batchSize=1}) 如果给cursor加上batchSize则只会返回一条数据，假设有10条数据，后面的数据返回应该要怎么操作

[sanergogogo]

local result = {}
local response = self.db[tablename]:aggregate(pipeline, options)
if response.ok ~= 1 then
    error(response["$err"] or "Reply from mongod error")
else
    result = response.cursor.firstBatch or response.cursor.nextBatch
    while response.cursor.id > 0 do
        response = self.db:runCommand("getMore", bson.int64(response.cursor.id), "collection", tablename)
        if response.ok ~= 1 then
            error(response["$err"] or "Reply from mongod error")
        end
        local document = response.cursor.firstBatch or response.cursor.nextBatch
        for index, value in ipairs(document) do
            table.insert(result, value)
        end
    end
    return result
end

可以了。有点小不方便 要另外封装一下