def __init__(self):
self.user = DBOHHOUser()
self.user_and_device_relation = DBOHHOUserAndDeviceRelation()
self.password = Password()
self.token = Token()
self.user_extension = DBOHHOUserAccuracyExtension()
self.interest = DBOHHOInterest()
self.map = DBOHHOMapInformation()
self.device = DBOHHODevice()
self.record_user_and_match_condition = DBOHHORecordUserAndMatchCondition(
)
self.match_condition = DBOHHORecordMatchCondition()
self.im_user = DBOHHOIMUser()
self.im_user_relation = DBOHHOIMUserRelation()
self.user_configuration = DBOHHOUserConfiguration()
self.imei = IMEI()
self.user_and_device_imei = DBOHHOUserAndDeviceIMEI()
self.friend = Friend()
self.apply = DBOHHORecordMatchApply()
self.country_code = DBOHHOCountryCode()
self.user_and_cellphone_relation = DBOHHOUserAndCellphoneRelation()
self.user_favourite_book = DBOHHOUserFavouriteBook()
self.user_favourite_movie = DBOHHOUserFavouriteMovie()
self.user_favourite_sport = DBOHHOUserFavouriteSport()
self.user_favourite_music = DBOHHOUserFavouriteMusic()
self.user_icon = DBOHHOUserIcon()
self.user_description = DBOHHOUserDescription()
self.user_impression = DBOHHOUserImpression()
def post(self):
the_post = Post()
user_instance = DBOHHOUser()
condition_instance = DBOHHORecordMatchCondition()
relation_instance = UserAndMatchCondition()
username = the_post.get_username(self)
name = the_post.get_name(self)
match_condition_id = the_post.get_id(self)
user = user_instance.get_by_cellphone(username)
match_condition = condition_instance.get_by_id(match_condition_id)
if user and match_condition:
result = relation_instance.add(user.id, name, match_condition_id)
if result["code"] == 1:
return self.redirect(USER_AND_MATCH_CONDITION_LIST_URL)
return self.redirect(USER_AND_MATCH_CONDITION_ADD_URL)
def __init__(self):
self.user = DBOHHOUser()
self.user_and_device_relation = DBOHHOUserAndDeviceRelation()
self.password = Password()
self.token = Token()
self.user_extension = DBOHHOUserAccuracyExtension()
self.interest = DBOHHOInterest()
self.map = DBOHHOMapInformation()
self.device = DBOHHODevice()
self.record_user_and_match_condition = DBOHHORecordUserAndMatchCondition()
self.match_condition = DBOHHORecordMatchCondition()
self.im_user = DBOHHOIMUser()
self.im_user_relation = DBOHHOIMUserRelation()
self.user_configuration = DBOHHOUserConfiguration()
self.imei = IMEI()
self.user_and_device_imei = DBOHHOUserAndDeviceIMEI()
self.friend = Friend()
self.apply = DBOHHORecordMatchApply()
self.country_code = DBOHHOCountryCode()
self.user_and_cellphone_relation = DBOHHOUserAndCellphoneRelation()
class LogicAddUser(object):
def __init__(self):
self.user = DBOHHOUser()
self.user_and_device_relation = DBOHHOUserAndDeviceRelation()
self.password = Password()
self.token = Token()
self.user_extension = DBOHHOUserAccuracyExtension()
self.interest = DBOHHOInterest()
self.map = DBOHHOMapInformation()
self.device = DBOHHODevice()
self.record_user_and_match_condition = DBOHHORecordUserAndMatchCondition()
self.match_condition = DBOHHORecordMatchCondition()
self.im_user = DBOHHOIMUser()
self.im_user_relation = DBOHHOIMUserRelation()
self.user_configuration = DBOHHOUserConfiguration()
self.imei = IMEI()
self.user_and_device_imei = DBOHHOUserAndDeviceIMEI()
self.friend = Friend()
self.apply = DBOHHORecordMatchApply()
self.country_code = DBOHHOCountryCode()
self.user_and_cellphone_relation = DBOHHOUserAndCellphoneRelation()
# def gevent_add_user_test(self, cellphone):
def add_user(self, number=10):
gevent_list = [gevent.spawn(self.gevent_add_user_test, number) for i in range(2)]
gevent.joinall(gevent_list)
cellphone = 10000000000
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 add_user(self, number=10):
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 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_user1(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:
# 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 add_user_impression(self, user_id):
data = dict()
obj = OhhoRandom.get_user_impression()
data["user_id"] = user_id
data["another_user_id"] = obj.get("another_user_id", "")
data["content_id"] = obj.get("content_id", "")
data["apply_id"] = obj.get("apply_id", "")
data["type"] = obj.get("type", "")
self.user_impression.add(data)
def add_user_icon(self, user_id):
data = dict()
obj = OhhoRandom.get_user_icon()
data["user_id"] = user_id
data["icon"] = obj.get("icon", "")
data["is_head_sculpture"] = obj.get("is_head_sculpture", "")
data["thumbnail"] = obj.get("thumbnail", "")
self.user_icon.add(data)
def add_user_favourite_sport(self, user_id):
data = dict()
obj = OhhoRandom.get_favourite_sport()
data["user_id"] = user_id
data["sport_id"] = obj.get("sport_id", "")
data["name"] = obj.get("name", "")
data["description"] = obj.get("description", "")
data["index"] = obj.get("index", "")
self.user_favourite_sport.add(data)
def add_user_favourite_music(self, user_id):
data = dict()
obj = OhhoRandom.get_favourite_music()
data["user_id"] = user_id
data["music_id"] = obj.get("music_id", "")
data["name"] = obj.get("name", "")
data["description"] = obj.get("description", "")
data["album"] = obj.get("album", "")
data["publisher"] = obj.get("publisher", "")
data["singer"] = obj.get("singer", "")
data["icon"] = obj.get("icon", "")
data["url"] = obj.get("url", "")
self.user_favourite_music.add(data)
def add_user_favourite_movie(self, user_id):
data = dict()
obj = OhhoRandom.get_favourite_movie()
data["user_id"] = user_id
data["movie_id"] = obj.get("movie_id", "")
data["name"] = obj.get("name", "")
data["description"] = obj.get("description", "")
data["index"] = obj.get("index", "")
data["casts"] = obj.get("casts", "")
data["genres"] = obj.get("genres", "")
data["icon"] = obj.get("icon", "")
data["url"] = obj.get("url", "")
self.user_favourite_movie.add(data)
def add_user_favourite_book(self, user_id):
data = dict()
obj = OhhoRandom.get_favourite_book()
data["user_id"] = user_id
data["isbn"] = obj.get("isbn", "")
data["name"] = obj.get("name", "")
data["description"] = obj.get("description", "")
data["index"] = obj.get("index", "")
data["icon"] = obj.get("icon", "")
data["author"] = obj.get("author", "")
data["url"] = obj.get("url", "")
self.user_favourite_book.add(data)
def add_user_description(self, user_id):
data = dict()
data["user_id"] = user_id
data["type"] = OhhoRandom.get_type()
data["first"] = OhhoRandom.get_first()
data["second"] = OhhoRandom.get_second()
data["third"] = OhhoRandom.get_third()
self.user_description.add(data)
def add_user_and_device_relation(self, user_id):
data = dict()
data["user_id"] = user_id
data["device_id"] = OhhoRandom.get_device_id
self.user_and_device_relation.add(data)
def add_user_and_device_imei(self, user_id):
data = dict()
data["user_id"] = user_id
data["device_id"] = OhhoRandom.get_device_id
data["imei"] = OhhoRandom.get_imei()
self.user_and_device_imei.add(data)
def add_user_and_cellphone_relation(self, user_id):
data = dict()
data["user_id"] = user_id
data["cellphone_id"] = OhhoRandom.get_cellphone_id()
self.user_and_cellphone_relation.add(data)
def add_user_configuration(self, user_id):
data = dict()
data["user_id"] = user_id
data["is_match"] = 1
data["is_online"] = 1
self.user_configuration.add(data)
def add_user_match_condition(self, user_id):
data = dict()
data["user_id"] = user_id
data["match_condition_id"] = OhhoRandom.get_match_condition_id()
self.match_condition.add(data)
def add_user_extension(self, user_id):
data = dict()
data["user_id"] = user_id
data["sex"] = OhhoRandom.get_sex()
# data["identity_card"] = identity_card
# data["real_name"] = ""
data["nickname"] = "宝宝"
data["birthday"] = OhhoRandom.get_birthday()
# data["height"] = OhhoRandom.get_height()
# data["hometown"] = OhhoRandom.get_hometown()
# data["school"] = OhhoRandom.get_school()
# data["company"] = OhhoRandom.get_company()
# data["degree_id"] = OhhoRandom.get_degree_id()
# data["favourite_live_city"] = OhhoRandom.get_favourite_live_city()
# data["occupation_id"] = OhhoRandom.get_occupation_id()
# data["position_id"] = OhhoRandom.get_position_id()
self.user_extension.add(data)
def add_user_extension_dic(self, user_id):
data = dict()
data["user_id"] = user_id
data["sex"] = OhhoRandom.get_sex()
data["nickname"] = "宝宝"
data["birthday"] = OhhoRandom.get_birthday()
return data
def add_user_token_table_dic(self, user_id):
token = OHHORandom.get_nonce()
token_dict = dict()
token_dict["user_id"] = user_id
token_dict["token"] = token
# self.token.token.add(token_dict)
return token_dict
def add_user_token_table(self, user_id):
token = OHHORandom.get_nonce()
token_dict = dict()
token_dict["user_id"] = user_id
token_dict["token"] = token
self.token.token.add(token_dict)
def add_user_table(self, cellphone="00000000000"):
"""添加用户 参数 """
data = dict()
password = "******"
country_code_id = 159
username = OHHOUUID.get_uuid1_string()
self.password.set_password(password)
encryption_password = self.password.encryption()
data["username"] = username
data["password"] = encryption_password
data["cellphone"] = cellphone
data["country_code_id"] = country_code_id
# time1 = time.time()
self.user.add(data)
# print("user_id")
# print(self.user.model.id[0])
user = self.user.get_by_username(username)
# time2 = time.time()
# time3 = time2 - time1
# print("user insert")
# print(time3)
return user.id
def insert_table(self):
data = dict()
password = "******"
country_code_id = 159
username = OHHOUUID.get_uuid1_string()
self.password.set_password(password)
encryption_password = self.password.encryption()
data["username"] = username
data["password"] = encryption_password
data["cellphone"] = "13828838383"
data["country_code_id"] = country_code_id
time1 = time.time()
self.user.add(data)
time2 = time.time()
time3 = time2 - time1
print("user insert")
print(time3)
def __init__(self):
self.condition = DBOHHORecordMatchCondition()
class MatchCondition(object):
def __init__(self):
self.condition = DBOHHORecordMatchCondition()
def add(self, data):
hometown_list = list()
current_list = list()
data["hometown_list"] = hometown_list
data["current_list"] = current_list
condition = self.get(data)
if not condition:
success = self.condition.add(data)
if success:
OHHOLog.print_log(ADD_MATCH_CONDITION_SUCCESS)
condition = self.get(data)
else:
OHHOLog.print_log(ADD_MATCH_CONDITION_FAILED)
else:
OHHOLog.print_log(MATCH_CONDITION_EXIST)
return condition
def get(self, data_dict):
query = self.condition.get_query()
OHHOLog.print_log(query.count())
query = self.condition.filter_all(query, data_dict)
OHHOLog.print_log(query.count())
query = self.condition.order_by_id_asc(query)
return self.condition.first(query)
def get_by_id(self, match_condition_id):
return self.condition.get_by_id(match_condition_id)
def get_some(self, query, offset, limit):
return self.condition.get_some(query, offset, limit)
def update(self, instance, data):
return self.condition.update(instance, data)
def delete(self, instance):
return self.condition.delete(instance)
def find(self, sex, nickname):
query = self.condition.get_query()
if sex != "":
query = self.condition.filter_by_sex(query, sex)
if nickname != "":
query = self.condition.find_by_nickname(query, nickname)
return query
def get_name_by_id(self, id, db_mode):
if id is None:
return ""
else:
instance = db_mode()
the_object = instance.get_by_id(id)
return the_object.name if the_object else ""
def get_information(self, instance):
information = self.condition.get_information(instance)
information["drink"] = self.get_name_by_id(instance.drink_id, DBOHHODrink)
information["smoke"] = self.get_name_by_id(instance.smoke_id, DBOHHOSmoke)
information["profession"] = self.get_name_by_id(instance.profession_id, DBOHHOProfession)
information["industry"] = self.get_name_by_id(instance.industry_id, DBOHHOIndustry)
information["body_type"] = self.get_name_by_id(instance.body_type_id, DBOHHOBodyType)
information["work_domain"] = self.get_name_by_id(instance.work_domain_id, DBOHHOWorkDomain)
return information
def __init__(self):
self.relation = DBOHHORecordUserAndMatchCondition()
self.condition = DBOHHORecordMatchCondition()
self.user = DBOHHOUser()
class UserAndMatchCondition(object):
def __init__(self):
self.relation = DBOHHORecordUserAndMatchCondition()
self.condition = DBOHHORecordMatchCondition()
self.user = DBOHHOUser()
def get_nearest_match_relation_by_user(self, user_id):
query = self.relation.get_query()
query = self.relation.filter_by_user(query, user_id)
query = self.relation.order_by_id_desc(query)
return self.relation.first(query)
def add(self, user_id, name, match_condition_id):
"""
用户ID，名称唯一确定一条值，match_condition可以更改
:param data: name, user_id, match_condition_id
:return:
"""
if user_id:
relation = self.get_nearest_match_relation_by_user(user_id)
if relation:
result = Result.result_exist(USER_AND_MATCH_CONDITION_EXIST)
result["data"] = relation
else:
data = dict()
data["user_id"] = user_id
data["match_condition_id"] = match_condition_id
if name:
data["name"] = name
success = self.relation.add(data)
if success:
result = Result.result_success()
relation = self.get_nearest_match_relation_by_user(user_id)
result["data"] = relation
else:
result = Result.result_failed()
result["data"] = None
else:
result = Result.result_failed(PARAMETERS_ARE_INVALID)
result["data"] = None
return result
# if user_id and name:
# query = self.relation.get_query()
# query = self.relation.filter_by_user(query, user_id)
# query = self.relation.filter_by_name(query, name)
# query = self.relation.order_by_id_asc(query)
# relation = self.relation.first(query)
# if relation:
# OHHOLog.print_log(USER_AND_MATCH_CONDITION_EXIST)
# result = Result.result_exist(USER_AND_MATCH_CONDITION_EXIST)
# result["data"] = relation
# else:
# data = dict()
# data["user_id"] = user_id
# data["name"] = name
# data["match_condition_id"] = match_condition_id
# success = self.relation.add(data)
# if success:
# OHHOLog.print_log(ADD_USER_AND_MATCH_CONDITION_SUCCESS)
# result = Result.result_success()
# relation = self.get(user_id, name)
# result["data"] = relation
# else:
# OHHOLog.print_log(ADD_USER_AND_MATCH_CONDITION_FAILED)
# result = Result.result_failed()
# result["data"] = None
# else:
# OHHOLog.print_log(PARAMETERS_ARE_INVALID)
# result = Result.result(-2, PARAMETERS_ARE_INVALID)
# result["data"] = None
# return result
def get(self, user_id, name=None):
if user_id:
query = self.relation.get_query()
query = self.relation.filter_by_user(query, user_id)
if name:
query = self.relation.filter_by_name(query, name)
query = self.relation.order_by_id_desc(query)
query = self.relation.first(query)
return query
else:
OHHOLog.print_log(PARAMETERS_ARE_INVALID)
return None
def get_by_id(self, user_and_match_condition_id):
return self.relation.get_by_id(user_and_match_condition_id)
def update(self, relation, data):
return self.relation.update(relation, data)
def delete(self, instance):
return self.relation.delete(instance)
def find(self, username, name, match_condition_ids):
query = self.relation.get_query()
if username:
users = self.user.find_by_username(username)
user_id_list = list()
if not self.user.is_empty(users):
user_id_list = [user.id for user in users]
query = self.relation.find_by_user(query, user_id_list)
if name:
query = self.relation.find_by_name(query, name)
if match_condition_ids:
match_condition_id_list = match_condition_ids.split(",")
query = self.relation.find_by_match_condition(
query, match_condition_id_list)
return query
def get_some(self, query, offset, limit):
return self.relation.get_some(query, offset, limit)
def get_match_condition(self, match_condition_id):
return self.condition.get_by_id(match_condition_id)
class LogicAddUserNew(object):
def __init__(self):
self.user = DBOHHOUser()
self.user_and_device_relation = DBOHHOUserAndDeviceRelation()
self.password = Password()
self.token = Token()
self.user_extension = DBOHHOUserAccuracyExtension()
self.interest = DBOHHOInterest()
self.map = DBOHHOMapInformation()
self.device = DBOHHODevice()
self.record_user_and_match_condition = DBOHHORecordUserAndMatchCondition(
)
self.match_condition = DBOHHORecordMatchCondition()
self.im_user = DBOHHOIMUser()
self.im_user_relation = DBOHHOIMUserRelation()
self.user_configuration = DBOHHOUserConfiguration()
self.imei = IMEI()
self.user_and_device_imei = DBOHHOUserAndDeviceIMEI()
self.friend = Friend()
self.apply = DBOHHORecordMatchApply()
self.country_code = DBOHHOCountryCode()
self.user_and_cellphone_relation = DBOHHOUserAndCellphoneRelation()
self.user_favourite_book = DBOHHOUserFavouriteBook()
self.user_favourite_movie = DBOHHOUserFavouriteMovie()
self.user_favourite_sport = DBOHHOUserFavouriteSport()
self.user_favourite_music = DBOHHOUserFavouriteMusic()
self.user_icon = DBOHHOUserIcon()
self.user_description = DBOHHOUserDescription()
self.user_impression = DBOHHOUserImpression()
# self.cellphone = 10000000000
# self.identity_id = 9000000000
def add_user(self):
cellphone = 10000000000
identity_id = 9000000000
for i in range(10):
cellphone = cellphone + 1
identity_id = identity_id + 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)
self.add_user_configuration(user_id)
# self.add_user_and_cellphone_relation(user_id)
self.device.set_identity(identity_id)
while self.device.get_by_identity():
identity_id = identity_id + 1
device_id = self.add_device(identity_id)
self.add_user_and_device_imei(user_id, device_id)
self.add_user_and_device_relation(user_id, device_id)
match_condition_id = self.add_match_condition()
print("match_condition_id:")
print(match_condition_id)
self.add_user_match_condition(user_id, match_condition_id)
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 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 add_user_and_device_relation(self, user_id, device_id):
data = dict()
data["user_id"] = user_id
data["device_id"] = device_id
self.user_and_device_relation.add(data)
def add_user_and_device_imei(self, user_id, device_id):
data = dict()
data["user_id"] = user_id
data["device_id"] = device_id
data["imei"] = OhhoRandom.get_imei()
self.user_and_device_imei.add(data)
def add_user_and_cellphone_relation(self, user_id):
data = dict()
data["user_id"] = user_id
data["cellphone_id"] = OhhoRandom.get_cellphone_id()
self.user_and_cellphone_relation.add(data)
def add_user_configuration(self, user_id):
data = dict()
data["user_id"] = user_id
data["is_match"] = 1
data["is_online"] = 1
self.user_configuration.add(data)
def add_user_match_condition(self, user_id, match_condition_id):
data = dict()
data["user_id"] = user_id
data["match_condition_id"] = match_condition_id
self.record_user_and_match_condition.add(data)
def add_user_extension(self, user_id):
data = dict()
data["user_id"] = user_id
data["sex"] = OhhoRandom.get_sex()
data["birthday"] = OhhoRandom.get_birthday()
data["interest"] = OhhoRandom.get_user_interest()
self.user_extension.add(data)
def add_user_token_table(self, user_id):
token = OHHORandom.get_nonce()
token_dict = dict()
token_dict["user_id"] = user_id
token_dict["token"] = token
self.token.token.add(token_dict)
def add_user_table(self, cellphone="00000000000"):
"""添加用户 参数 """
data = dict()
password = "******"
country_code_id = 159
username = OHHOUUID.get_uuid1_string()
self.password.set_password(password)
encryption_password = self.password.encryption()
data["username"] = username
data["password"] = encryption_password
data["cellphone"] = cellphone
data["country_code_id"] = country_code_id
self.user.add(data)
user = self.user.get_by_username(username)
return user.id
class LogicAddUser(object):
def __init__(self):
self.user = DBOHHOUser()
self.user_and_device_relation = DBOHHOUserAndDeviceRelation()
self.password = Password()
self.token = Token()
self.user_extension = DBOHHOUserAccuracyExtension()
self.interest = DBOHHOInterest()
self.map = DBOHHOMapInformation()
self.device = DBOHHODevice()
self.record_user_and_match_condition = DBOHHORecordUserAndMatchCondition(
)
self.match_condition = DBOHHORecordMatchCondition()
self.im_user = DBOHHOIMUser()
self.im_user_relation = DBOHHOIMUserRelation()
self.user_configuration = DBOHHOUserConfiguration()
self.imei = IMEI()
self.user_and_device_imei = DBOHHOUserAndDeviceIMEI()
self.friend = Friend()
self.apply = DBOHHORecordMatchApply()
self.country_code = DBOHHOCountryCode()
self.user_and_cellphone_relation = DBOHHOUserAndCellphoneRelation()
self.user_favourite_book = DBOHHOUserFavouriteBook()
self.user_favourite_movie = DBOHHOUserFavouriteMovie()
self.user_favourite_sport = DBOHHOUserFavouriteSport()
self.user_favourite_music = DBOHHOUserFavouriteMusic()
self.user_icon = DBOHHOUserIcon()
self.user_description = DBOHHOUserDescription()
self.user_impression = DBOHHOUserImpression()
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)
# self.add_user_match_condition(user_id)
# self.add_user_configuration(user_id)
# self.add_user_and_cellphone_relation(user_id)
# self.add_user_and_device_imei(user_id)
# self.add_user_and_device_relation(user_id)
# self.add_user_description(user_id)
# self.add_user_favourite_book(user_id)
# self.add_user_favourite_movie(user_id)
# self.add_user_favourite_music(user_id)
# self.add_user_favourite_sport(user_id)
# self.add_user_icon(user_id)
# self.add_user_impression(user_id)
def add_user_impression(self, user_id):
data = dict()
obj = OhhoRandom.get_user_impression()
data["user_id"] = user_id
data["another_user_id"] = obj.get("another_user_id", "")
data["content_id"] = obj.get("content_id", "")
data["apply_id"] = obj.get("apply_id", "")
data["type"] = obj.get("type", "")
self.user_impression.add(data)
def add_user_icon(self, user_id):
data = dict()
obj = OhhoRandom.get_user_icon()
data["user_id"] = user_id
data["icon"] = obj.get("icon", "")
data["is_head_sculpture"] = obj.get("is_head_sculpture", "")
data["thumbnail"] = obj.get("thumbnail", "")
self.user_icon.add(data)
def add_user_favourite_sport(self, user_id):
data = dict()
obj = OhhoRandom.get_favourite_sport()
data["user_id"] = user_id
data["sport_id"] = obj.get("sport_id", "")
data["name"] = obj.get("name", "")
data["description"] = obj.get("description", "")
data["index"] = obj.get("index", "")
self.user_favourite_sport.add(data)
def add_user_favourite_music(self, user_id):
data = dict()
obj = OhhoRandom.get_favourite_music()
data["user_id"] = user_id
data["music_id"] = obj.get("music_id", "")
data["name"] = obj.get("name", "")
data["description"] = obj.get("description", "")
data["album"] = obj.get("album", "")
data["publisher"] = obj.get("publisher", "")
data["singer"] = obj.get("singer", "")
data["icon"] = obj.get("icon", "")
data["url"] = obj.get("url", "")
self.user_favourite_music.add(data)
def add_user_favourite_movie(self, user_id):
data = dict()
obj = OhhoRandom.get_favourite_movie()
data["user_id"] = user_id
data["movie_id"] = obj.get("movie_id", "")
data["name"] = obj.get("name", "")
data["description"] = obj.get("description", "")
data["index"] = obj.get("index", "")
data["casts"] = obj.get("casts", "")
data["genres"] = obj.get("genres", "")
data["icon"] = obj.get("icon", "")
data["url"] = obj.get("url", "")
self.user_favourite_movie.add(data)
def add_user_favourite_book(self, user_id):
data = dict()
obj = OhhoRandom.get_favourite_book()
data["user_id"] = user_id
data["isbn"] = obj.get("isbn", "")
data["name"] = obj.get("name", "")
data["description"] = obj.get("description", "")
data["index"] = obj.get("index", "")
data["icon"] = obj.get("icon", "")
data["author"] = obj.get("author", "")
data["url"] = obj.get("url", "")
self.user_favourite_book.add(data)
def add_user_description(self, user_id):
data = dict()
data["user_id"] = user_id
data["type"] = OhhoRandom.get_type()
data["first"] = OhhoRandom.get_first()
data["second"] = OhhoRandom.get_second()
data["third"] = OhhoRandom.get_third()
self.user_description.add(data)
def add_user_and_device_relation(self, user_id):
data = dict()
data["user_id"] = user_id
data["device_id"] = OhhoRandom.get_device_id
self.user_and_device_relation.add(data)
def add_user_and_device_imei(self, user_id):
data = dict()
data["user_id"] = user_id
data["device_id"] = OhhoRandom.get_device_id
data["imei"] = OhhoRandom.get_imei()
self.user_and_device_imei.add(data)
def add_user_and_cellphone_relation(self, user_id):
data = dict()
data["user_id"] = user_id
data["cellphone_id"] = OhhoRandom.get_cellphone_id()
self.user_and_cellphone_relation.add(data)
def add_user_configuration(self, user_id):
data = dict()
data["user_id"] = user_id
data["is_match"] = 1
data["is_online"] = 1
self.user_configuration.add(data)
def add_user_match_condition(self, user_id):
data = dict()
data["user_id"] = user_id
data["match_condition_id"] = OhhoRandom.get_match_condition_id()
self.match_condition.add(data)
def add_user_extension(self, user_id, identity_card):
data = dict()
data["user_id"] = user_id
data["sex"] = OhhoRandom.get_sex()
# data["identity_card"] = identity_card
# data["real_name"] = ""
data["nickname"] = "宝宝"
data["birthday"] = OhhoRandom.get_birthday()
# data["height"] = OhhoRandom.get_height()
# data["hometown"] = OhhoRandom.get_hometown()
# data["school"] = OhhoRandom.get_school()
# data["company"] = OhhoRandom.get_company()
# data["degree_id"] = OhhoRandom.get_degree_id()
# data["favourite_live_city"] = OhhoRandom.get_favourite_live_city()
# data["occupation_id"] = OhhoRandom.get_occupation_id()
# data["position_id"] = OhhoRandom.get_position_id()
self.user_extension.add(data)
def add_user_token_table(self, user_id):
token = OHHORandom.get_nonce()
token_dict = dict()
token_dict["user_id"] = user_id
token_dict["token"] = token
self.token.token.add(token_dict)
def add_user_table(self, cellphone="00000000000"):
"""添加用户 参数 """
data = dict()
password = "******"
country_code_id = 159
username = OHHOUUID.get_uuid1_string()
self.password.set_password(password)
encryption_password = self.password.encryption()
data["username"] = username
data["password"] = encryption_password
data["cellphone"] = cellphone
data["country_code_id"] = country_code_id
self.user.add(data)
user = self.user.get_by_username(username)
return user.id