def exists(username):
"""
Checks if the user exists.
:param username: Name of the user
:return: Boolean value, True if the user exists.
"""
db = Database(DB_PATH)
num = db.query("SELECT COUNT(*) as count FROM %s WHERE username=?;" % TABLE_USERS, (username, ))[0][0]
db.close()
return num > 0
def get_password(username):
"""
Returns the password for a given username.
:param username: Name of the user
:return: The password
"""
db = Database(DB_PATH)
password = db.query("SELECT password FROM %s WHERE username=?;" % TABLE_USERS, (username, ))[0][0]
db.close()
return password
def get_queues(username):
"""
Query the queues for a given username.
:param username: Name of the user
:return: A list of queues
"""
db = Database(DB_PATH)
queues = []
try:
query = db.query("SELECT NAME FROM %s WHERE username=?;" % TABLE_QUEUES, (username, ))
for item in query:
queues.append(item[0])
except Exception:
pass
db.close()
return queues
