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