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 add_user_commit_all(self, number=10):
cellphone = 10000000000
# identity_card = 100000000000000000
user_query = self.user.get_query()
user_query = self.user.order_by_id_desc(user_query)
user_obj = Operation.first(user_query)
if user_obj:
if user_obj.cellphone:
cellphone = int(user_obj.cellphone)
i = 1
dic_list_token = list()
dic_list_extension = list()
while i <= number:
# OHHOLog.print_log(i)
print(i)
i += 1
cellphone += 1
data = dict()
while self.user.get_by_cellphone(str(cellphone)):
cellphone = cellphone + 1
user_id = self.add_user_table(str(cellphone))
token_dic = self.add_user_token_table_dic(user_id)
extension_dic = self.add_user_extension_dic(user_id)
dic_list_token.append(token_dic)
dic_list_extension.append(extension_dic)
self.token.token.bulk_add(dic_list_token)
self.user_extension.bulk_add(dic_list_extension)
print("for end")
print("end")
def add_device(self, identity_id):
data = dict()
data["identity_id"] = identity_id
self.device.add(data)
query = self.device.get_query()
query = self.device.order_by_id_desc(query)
obj = Operation.first(query)
return obj.id
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 add_match_condition(self):
data = dict()
data["sex"] = OhhoRandom.get_sex()
data["small_age"] = 0
data["big_age"] = 150
data["interest"] = OhhoRandom.get_user_match_interest()
self.match_condition.add(data)
query = self.match_condition.get_query()
query = self.match_condition.order_by_id_desc(query)
obj = Operation.first(query)
return obj.id
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 add_user(self):
cellphone = 10000000000
identity_card = 100000000000000000
user_query = self.user.get_query()
user_query = self.user.order_by_id_desc(user_query)
user_obj = Operation.first(user_query)
if user_obj:
cellphone = int(user_obj.cellphone)
for i in range(100):
cellphone += 1
# identity_card += 1
while self.user.get_by_cellphone(cellphone):
cellphone = cellphone + 1
user_id = self.add_user_table(str(cellphone))
self.add_user_token_table(user_id)
self.add_user_extension(user_id, identity_card)
def add_user(self, number=10):
cellphone = 10000000000
# identity_card = 100000000000000000
user_query = self.user.get_query()
user_query = self.user.order_by_id_desc(user_query)
user_obj = Operation.first(user_query)
if user_obj:
if user_obj.cellphone:
cellphone = int(user_obj.cellphone)
i = 0
while i <= number:
i += 1
cellphone += 1
while self.user.get_by_cellphone(str(cellphone)):
cellphone = cellphone + 1
user_id = self.add_user_table(str(cellphone))
self.add_user_token_table(user_id)
self.add_user_extension(user_id)
print("for end")
print("end")
def gevent_add_user_test(self, number):
global cellphone
# identity_card = 100000000000000000
user_query = self.user.get_query()
user_query = self.user.order_by_id_desc(user_query)
user_obj = Operation.first(user_query)
if user_obj:
if user_obj.cellphone:
cellphone = int(user_obj.cellphone)
i = 0
while i <= number:
# OHHOLog.print_log(i)
i += 1
cellphone += 1
while self.user.get_by_cellphone(str(cellphone)):
cellphone = cellphone + 1
user_id = self.add_user_table(str(cellphone))
self.add_user_token_table(user_id)
self.add_user_extension(user_id)
print("for end")
print("end")
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 first(self, query):
return Operation.first(query)
def get_by_id(self, the_id):
query = self.get_query()
query = Operation.filter(query, self.model.id, the_id)
return Operation.first(query)
def get_by_device(self, device_id):
query = self.get_query()
query = Operation.filter(query, self.model.device_id, device_id)
return Operation.first(query)
def get_by_apply_and_user(self, apply_id, user_id):
query = self.get_query()
query = self.get_by_apply_id(query, apply_id)
query = self.get_by_user_id(query, user_id)
query = self.order_by_id_desc(query)
return Operation.first(query)
def get_by_version(self, version):
query = self.get_query()
query = Operation.filter(query, self.model.version, version)
return Operation.first(query)
def get_nearest_by_interest(self, interest):
query = self.get_query()
query = Operation.filter(query, self.model.interest, interest)
query = self.order_by_id_desc(query)
return Operation.first(query)
def get_by_identity(self, identity_id):
query = self.get_query()
query = Operation.filter(query, self.model.identity_id, identity_id)
return Operation.first(query)
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_nearest_distance(self, distance):
query = self.get_query()
query = Operation.great_than_equal(query, self.model.distance, distance)
query = self.order_by_id_asc(query)
return Operation.first(query)
def get_by_apply_and_user(self, apply_id, user_id):
query = self.get_query()
query = Operation.filter(query, self.model.apply_id, apply_id)
query = Operation.filter(query, self.model.user_id, user_id)
query = self.order_by_id_desc(query)
return Operation.first(query)
def get_by_cellphone_and_user(self, cellphone_id, user_id):
query = self.get_query()
query = Operation.filter(query, self.model.cellphone_id, cellphone_id)
query = Operation.filter(query, self.model.user_id, user_id)
query = self.order_by_id_desc(query)
return Operation.first(query)
