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)
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 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
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