java mongodb 原生_spring data mongoDB原生查询

最新推荐文章于 2024-03-17 22:23:23 发布

原创最新推荐文章于 2024-03-17 22:23:23 发布 · 774 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#java mongodb 原生

博客给出了MongoDB原生查询语句，对特定时间范围和区域的数据进行筛选、抽样、分组和排序操作。同时提供了Java代码示例，将查询语句解析为对象列表，通过MongoTemplate执行聚合查询，并将结果存储在列表中。

mongodb原生查询语句

db.getCollection('chillerDB').aggregate([

{$match:{'timestamp':{'$gte':1575907200000,'$lte':1575993600000},'regionId':2}},

{'$sample':{'size':49}},

{$group:

{_id:

{'time':'$createTime',

'timestamp':'$timestamp',

'chillerPower':{$sum:'$listChiller.chillerPower'},

'frozenPumPower':{$sum:'$listFrozenPum.frozenPumPower'},

'coolingPumpPower':{$sum:'$listCoolingPump.coolingPumpPower'},

'coolingTowerPower':{$sum:'$listCoolingTower.coolingTowerPower'},

'totalPower':'$totalPower',

}

{'$sort':{'_id.timestamp':1}},])

Java代码示例

String tableName = "chillerDB";

String sql = "[{$match:{'timestamp':{'$gte':1575907200000,'$lte':1575993600000},'regionId':2}},{'$sample':{'size':1000}},{$group:{_id:{'time':'$createTime','timestamp':'$timestamp','chillerPower':{$sum:'$listChiller.chillerPower'},'frozenPumPower':{$sum:'$listFrozenPum.frozenPumPower'},'coolingPumpPower':{$sum:'$listCoolingPump.coolingPumpPower'},'coolingTowerPower':{$sum:'$listCoolingTower.coolingTowerPower'},'totalPower':'$totalPower',}}},{'$sort':{'_id.timestamp':1}}]";

List basicDBObjectList = JSONArray.parseArray(sql,BasicDBObject.class);

AggregateIterable aggregate = mongoTemplate.getDb().getCollection(tableName).aggregate(basicDBObjectList);

MongoCursor mongoCursor = aggregate.iterator();

List documentList = new ArrayList<>(1000);

while (mongoCursor.hasNext()){

Document doc = mongoCursor.next();

documentList.add(doc);

}