def delete_queue(username, queue):
"""
Delete a queue for a given user.
:param username: Name of the user
:param queue: Name of the queue to delete
"""
db = Database(DB_PATH)
db.update('DELETE FROM %s WHERE username=? and name=?' % TABLE_QUEUES, (username, queue))
def append_queue(username, queue):
"""
Add a queue for the given username.
:param username: Name of the user
:param queue: Name of queue to add
"""
db = Database(DB_PATH)
db.update('INSERT OR REPLACE INTO %s VALUES(?, ?);' % TABLE_QUEUES, (username, queue))
db.close()
def append_user(username, password):
"""
Adds a user to the database and creates their user folder.
:param username: Name of the user
:param password: Password for the account, should be hashed.
"""
db = Database(DB_PATH)
db.update('INSERT INTO %s VALUES(?, ?);' % TABLE_USERS, (username, password))
db.close()
os.mkdir(USER_PATH + username)
