& (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
