& (FieldBody.deleted == FieldDataSetStatus.deleted) & (FieldBody.language == FieldDataSetStatus.language) & (FieldBody.delta == FieldDataSetStatus.delta) ) bodyCount = ( FieldBody.select() .join(FieldDataSetStatus, on=condition1) .where(FieldDataSetStatus.field_dataset_status_value == "4") .count() ) print ("bodyCount: " + str(bodyCount)) # 取得總數 Node condition2 = Node.nid == FieldDataSetStatus.entity_id nodeCount = ( Node.select() .join(FieldDataSetStatus, on=condition2) .where(Node.type == "metadataset" | FieldDataSetStatus.field_dataset_status_value == "4") .count() ) print ("nodeCount: " + str(nodeCount)) world_list = [] num = 1000 # field_data_body i = 1 total_page = bodyCount / num + 1 # total_page = 1 while i < total_page + 1: print ("field_data_body Now Page: " + str(i)) page = getPage(i, num, FieldBody) for mesg in page:
from model.Node import Node __author__ = 'johnnytsai' page = Node.select().where(Node.type == "metadataset").paginate(1, 1000) for mesg in page: print mesg.title