def get_by_key(self):
if self.key:
query = self.get_query()
query = Operation.filter(query, self.model.key, self.key)
return Operation.first(query)
else:
return None
def get_by_state(self, query, state, has_state=False):
if has_state:
return Operation.filter(query, self.model.state, state)
else:
if state:
return query
else:
return None
def exist_valid_cellphone(self, cellphone):
query = self.get_query()
query = self.get_valid(query)
query = Operation.filter(query, self.model.cellphone, cellphone)
if self.is_empty(query):
return False
else:
return True
def get_by_imei(self, imei):
try:
query = self.get_query()
query = Operation.filter(query, self.model.imei, imei)
return Operation.first(query), None
except Exception as ex:
OHHOLog.print_log(ex)
return True, ex
def get_user_impression(self, user_id, type):
query = self.get_query_new()
query = Operation.filter(query, self.model.another_user_id,
user_id).group_by(self.model.content_id)
query = self.get_by_type(query, type)
query = query.order_by(desc("count_content"),
desc(self.model.changed_at)).limit(5)
query = self.get_all(query)
return query
def get_by_identity(self):
# query = self.get_query()
# OHHOLog.print_log(self.identity_id)
if self.identity_id:
# OHHOLog.print_log(self.identity_id)
query = self.get_query()
# OHHOLog.print_log(self.get_count(query))
query = Operation.filter(query, self.model.identity_id, self.identity_id)
# OHHOLog.print_log(self.get_count(query))
return Operation.first(query)
else:
# OHHOLog.print_log(self.identity_id)
return None
def filter_by_user(self, query, user_id):
return Operation.filter(query, self.model.user_id, user_id)
def get_by_device(self, device_id):
query = self.get_query()
query = self.get_valid(query)
query = Operation.filter(query, self.model.device_id, device_id)
query = self.order_by_id_desc(query)
return Operation.first(query)
def get_by_is_lost(self, query, is_lost):
return Operation.filter(query, self.model.is_lost, is_lost)
def find_by_device(self, query, device_id_list):
return Operation.filter(query, self.model.device_id, device_id_list)
def get_by_country_code(self, query, country_code_id):
return Operation.filter(query, self.model.country_code_id, country_code_id)
def get_by_user(self, user_id):
query = self.get_query()
query = Operation.filter(query, self.model.user_id, user_id)
query = self.order_by_id_asc(query)
query = self.get_all(query)
return query
def get_by_user(self, user_id):
query = DBOHHOMatchCondition.get_query()
return Operation.filter(query, self.model.user_id, user_id)
def get_by_name(self, query, name):
return Operation.filter(query, self.model.name, name)
def get_by_user(self, user_id):
query = self.get_query()
query = Operation.filter(query, self.model.user_id, user_id)
return Operation.first(query)
def get_by_cellphone_from_query(self, query, cellphone):
return Operation.filter(query, self.model.cellphone, cellphone)
def get_by_cellphone(self, cellphone):
query = self.get_query()
query = self.get_valid(query)
query = Operation.filter(query, self.model.cellphone, cellphone)
query = self.order_by_id_asc(query)
return self.first(query)
def get_user_head_sculpture(self, user_id):
query = self.get_query()
query = Operation.filter(query, self.model.user_id, user_id)
query = Operation.filter(query, self.model.is_head_sculpture, 1)
return self.first(query)
def get_by_password(self, query, password):
return Operation.filter(query, self.model.password, password)
def filter_by_apply(self, query, apply_id):
return Operation.filter(query, self.model.apply_id, apply_id)
def get_by_country_code_and_cellphone(self, country_code_id, cellphone):
query = self.get_query()
query = self.get_by_country_code(query, country_code_id)
query = Operation.filter(query, self.model.cellphone, cellphone)
query = self.order_by_id_asc(query)
return self.first(query)
def get_apply_id_list_by_user(self, query, user_id):
query = Operation.filter(query, self.model.user_id, user_id)
apply_id_list = [meeting.apply_id for meeting in query]
return apply_id_list
def get_by_type(self, query, type):
return Operation.filter(query, self.model.type, type)
def get_by_address(self, address):
query = self.get_query()
return Operation.filter(query, self.model.address, address)
def get_not_lost(self, query):
return Operation.filter(query, self.model.is_lost, False)
def get_by_page(self, query, page_id):
if query and page_id:
return Operation.filter(query, self.model.page_id, page_id)
else:
return None
def filter_by_apply(self, apply_id):
query = self.get_query()
return Operation.filter(query, self.model.apply_id, apply_id)
def get_by_timestamp(self, timestamp):
query = self.get_query()
query = Operation.filter(query, self.model.timestamp, timestamp)
query = self.order_by_id_asc(query)
return self.first(query)
def get_by_apply(self, apply_id):
query = self.get_query()
query = Operation.filter(query, self.model.apply_id, apply_id)
query = self.order_by_id_desc(query)
return self.first(query)
def get_by_username(self, username):
query = self.get_query()
query = Operation.filter(query, self.model.username, username)
return self.first(query)
