manage/uuspider/createFileForZML/ComponentUuidForProperty.py

# coding=utf-8
'''
Created on 2016年4月28日
应邹美玲的要求，为每个property查找至少10个UUID
@author: ChenHao
'''
from util_common import Constant
from pymongo.mongo_client import MongoClient


cli = MongoClient(Constant.MONGODB_URL)
# cli = MongoClient("mongodb://localhost:27017/")

# cli = MongoClient("mongodb://113.105.74.140:27017/")

db = cli.spider

rs_property = db.property.find({}, {"id": True})
propertyid_set = set(r["id"] for r in rs_property)

print (propertyid_set)

for propertyid in propertyid_set:
    rs_propertyvalue = db.propertyvalue.find({"propertyid": propertyid}, {"componentid": True}).limit(10)
    componentid_list = list(r["componentid"] for r in rs_propertyvalue)
    if len(componentid_list) == 0:
        print (propertyid, "为0")
    



























cli.close()