def get_blog(blog_id): d = DBHelper() result = d.find_one("SELECT title, content, create_time from blog where id=%s", blog_id) if result: title, content, create_time = result b = Blog(blog_id, title, content, create_time) return b
def check_user_name(user_name): if not user_name: return False, False x = DBHelper() result = x.find_one("SELECT is_admin FROM user WHERE user_name=%s", user_name) if result: is_user = True is_admin = result else: is_user = False is_admin = False return is_user, is_admin
def check_user(user_name, password): if not (user_name and password): return False x = DBHelper() result = x.find_one("SELECT password FROM user WHERE user_name=%s", user_name) return result and result[0] == md5(password).hexdigest()