test.py 609 B

123456789101112131415161718192021
  1. from pymongo import MongoClient
  2. client = MongoClient('mongodb://172.20.45.129:27002/')
  3. db = client['data_quality']
  4. collection = db['bidding_202505']
  5. # 删除 comeintime 在 [1747152000, 1747238400] 范围内的文档
  6. # result = collection.delete_many({
  7. # "comeintime": {
  8. # "$gte": 1747152000, # 大于等于 from
  9. # "$lte": 1747238400 # 小于等于 to
  10. # }
  11. # })
  12. count = collection.count_documents({
  13. "comeintime": {
  14. "$gte": 1747152000,
  15. "$lte": 1747238400
  16. }
  17. })
  18. print(f"符合条件的数据量: {count}")
  19. # print(f"删除了 {result.deleted_count} 条文档")