java mongo $where

最新推荐文章于 2023-05-12 17:00:00 发布

未来，值得期待

最新推荐文章于 2023-05-12 17:00:00 发布

阅读量843

点赞数

分类专栏：数据库文章标签： java mongo where

本文链接：https://blog.csdn.net/adam_wzs/article/details/78729796

版权

数据库专栏收录该内容

15 篇文章 0 订阅

订阅专栏

db.tsdataBak1710.find({
    "lastUpdateTime" :{"$gte": ISODate("2017-10-12T00:00:00.000+08:00"),"$lt": ISODate("2017-10-13T00:00:00.000+08:00")},
    "lastEvent":"ScheduleChange",
    "lastSubEvent":"UNTK",
    "$where": "this.seg.opFlightNumber == this.asssegs[0].operatingCarrier.flightNumber",  
}).count()

@Test
	public void testCount() throws ParseException {
		String startDate = "2017-10-1";// 开始时间
		String endDate = "2017-10-31";// 结束时间
		String collection = "tsdataBak1710";// 集合名字
		Date date1 = sdf.parse(startDate);
		Date date2 = sdf.parse(endDate);
		Calendar calendar = Calendar.getInstance();
		calendar.setTime(date1);
		long allCount = 0;
		long startTime = System.currentTimeMillis();
		while (!calendar.getTime().equals(date2)) {
			Date dateS1 = calendar.getTime();
			calendar.add(Calendar.DATE, 1);
			Date dateE1 = calendar.getTime();


			DBObject queryObject = (DBObject) JSON.parse("{}");
			queryObject.put("$where", "this.seg.opFlightNumber == this.asssegs[0].operatingCarrier.flightNumber");
			BasicQuery query = new BasicQuery(queryObject);
			query.addCriteria(Criteria.where("lastUpdateTime").gte(dateS1).lt(dateE1));
			query.addCriteria(Criteria.where("lastEvent").is("ScheduleChange"));
			query.addCriteria(Criteria.where("lastSubEvent").is("UNTK"));


			long count = mongoTemplate.count(query, Tsdata.class, collection);
			allCount += count;
			System.out.println(sdf.format(dateS1.getTime()) + "\t" + sdf.format(dateE1.getTime()) + "\tcount:" + count);
		}
		long endTime = System.currentTimeMillis();
		System.out.println("allCount=" + allCount);
		System.out.println("costTime=" + (endTime - startTime));
	}