def query_client_item_list_by_parent(cls,
parent_id,
ref_id,
offset=0,
limit=500):
return ClientDataItem.select().where(
ClientDataItem.parent == parent_id,
ClientDataItem.ref_id == ref_id).offset(offset).limit(limit)
def query_root_files_by_user_id(cls, ref_id):
return ClientDataItem.select().where(
ClientDataItem.ref_id == ref_id,
ClientDataItem.source_fs_id == TOP_DIR_FILE_NAME).first()
def get_top_dir_item_by_pan_id(cls,
pan_id,
top_dir_name=PAN_ROOT_DIR['name']):
return ClientDataItem.select().where(
ClientDataItem.source_fs_id == top_dir_name,
ClientDataItem.panacc == pan_id).first()
def get_root_item_by_pan_id(cls, pan_id):
return ClientDataItem.select().where(
ClientDataItem.source_fs_id == TOP_DIR_FILE_NAME,
ClientDataItem.panacc == pan_id).first()
def get_data_item_by_id(cls, pk_id, ref_id):
return ClientDataItem.select().where(
ClientDataItem.id == pk_id,
ClientDataItem.ref_id == ref_id).first()
def get_data_item_by_source_fs_id(cls, source_fs_id, ref_id):
return ClientDataItem.select().where(
ClientDataItem.source_fs_id == source_fs_id,
ClientDataItem.ref_id == ref_id).first()
def check_data_item_exists_by_ref_id_id(cls, ref_id, item_id):
return ClientDataItem.select().where(
ClientDataItem.id == item_id,
ClientDataItem.ref_id == ref_id).exists()