def add_user(cls, username, password):
query_db("INSERT INTO users(username, password) VALUES (?, ?)",
[username, hash_password(password)])
def get_user_by_name_and_password(cls, username, password):
return query_db('SELECT * FROM users WHERE username=? AND password=?',
[username, hash_password(password)])
def get_user_by_name(cls, username):
return query_db('SELECT * FROM users WHERE username=?', [username])
def add_image(cls, image_path):
if not cls.get_image_by_path(image_path):
query_db("INSERT INTO images(path) VALUES (?)", [image_path])
def get_image_by_path(cls, image_path):
return query_db('SELECT * FROM images WHERE path = ?', [image_path])
def get_all_image(cls):
return query_db('SELECT * FROM images')