def query_all(limit=50): ''' Return some of the records. Not all. :param limit: :return: ''' return TabMember.select().limit(limit)
def check_user_by_name(user_id, u_pass): tt = TabMember.select().where(TabMember.user_name == user_id).count() if tt == 0: return -1 a = TabMember.get(user_name=user_id) if a.user_pass == tools.md5(u_pass): return 1 return 0
def query_by_time(recent=90): ''' Return some of the records. Not all. ''' time_that = int(time.time()) - recent * 24 * 3600 return TabMember.select().where( TabMember.time_create > time_that).order_by( TabMember.time_create.desc())
def check_user(user_id, u_pass): ''' Checking the password by user's ID. ''' user_count = TabMember.select().where(TabMember.uid == user_id).count() if user_count == 0: return -1 the_user = TabMember.get(uid=user_id) if the_user.user_pass == tools.md5(u_pass): return 1 return 0
def check_user_by_name(user_name, u_pass): ''' Checking the password by user's name. ''' tt = TabMember.select().where(TabMember.user_name == user_name).count() if tt == 0: return -1 a = TabMember.get(user_name=user_name) if a.user_pass == tools.md5(u_pass): return 1 return 0
def check_user_by_name(user_name, u_pass): ''' Checking the password by user's name. ''' the_query = TabMember.select().where(TabMember.user_name == user_name) if the_query.count() == 0: return -1 the_user = the_query.get() if the_user.user_pass == tools.md5(u_pass): return 1 return 0
def query_nologin(): ''' Query the users who do not login recently (90 days). and not send email (120 days). time_model: num * month * hours * minite * second time_login: 3 * 30 * 24 * 60 * 60 time_email: 4 * 30 * 24 * 60 * 60 ''' time_now = tools.timestamp() return TabMember.select().where(( (time_now - TabMember.time_login) > 7776000) & ( (time_now - TabMember.time_email) > 10368000))
def check_user(user_id, u_pass): ''' Checking the password by user's ID. :param user_id: :param u_pass: :return: ''' tt = TabMember.select().where(TabMember.uid == user_id).count() if tt == 0: return -1 a = TabMember.get(uid=user_id) if a.user_pass == tools.md5(u_pass): return 1 return 0
def get_by_keyword(par2): return TabMember.select().where(TabMember.user_name.contains(par2))
def count_of_certain(): recs = TabMember.select() return recs.count()
def total_number(): ''' Return the number of certian slug. ''' return TabMember.select().count()
def count_of_certain(): ''' ''' # adding ``None`` to hide ``No value for argument 'database' in method call`` return TabMember.select().count(None)
def query_pager_by_time(current_page_num=1): ''' Query pager ''' return TabMember.select().where(TabMember.time_create).paginate( current_page_num, CMS_CFG['list_num'])
def total_number(): ''' Return the number of certian slug. ''' # adding ``None`` to hide ``No value for argument 'database' in method call`` return TabMember.select().count(None)
def get_by_Email(par2): ''' Get Member by keyword ''' return TabMember.select().where(TabMember.user_email.contains(par2))
def query_nologin(): time_now = tools.timestamp() # num * month * hours * minite * second return TabMember.select().where(( (time_now - TabMember.time_login) > 3 * 30 * 24 * 60 * 60) & ( (time_now - TabMember.time_email) > 4 * 30 * 24 * 60 * 60))
def query_pager_by_slug(current_page_num=1): ''' Query pager ''' return TabMember.select().paginate(current_page_num, CMS_CFG['list_num'])