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