Example #1
0
File: blog.py Project: xi4nyu/sae
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
Example #2
0
File: user.py Project: xi4nyu/sae
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
Example #3
0
File: blog.py Project: xi4nyu/sae
def publish_blog(title, content):
    d = DBHelper()
    return d.insert(TABLE_NAME, ("title", "content", "is_show"), ((title, content, True),))
Example #4
0
File: blog.py Project: xi4nyu/sae
def get_all_blogs():
    d = DBHelper()
    count, result = d.find("SELECT id, title, content, create_time from blog")
    blogs = [Blog(ID, title, content, create_time) for ID, title, content, create_time in result]
    return count, blogs
Example #5
0
File: user.py Project: xi4nyu/sae
def create_user(user_name, password, is_admin):
    db = DBHelper()
    value = (user_name, md5(password).hexdigest(), is_admin)
    return db.insert("user", ("user_name", "password", "is_admin"), (value,))
Example #6
0
File: user.py Project: xi4nyu/sae
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()
Example #7
0
File: todo.py Project: xi4nyu/sae
def add_todo(text):
    print "todo"
    db = DBHelper()
    db.insert("todo", ("text", "status"), ((text, 1),))
Example #8
0
File: todo.py Project: xi4nyu/sae
def get_todo_list():
    db = DBHelper()
    count, result = db.find("SELECT id, text, status FROM todo")
    return [dict(Id = Id, text = text, status = status) for Id, text, status in result]