def addUser(username, pwhash, groupid):
salted_hash = doSalt(pwhash)
cur = dbservices.getCursor()
sql = "INSERT INTO `users` (`username`, `password`, `group_id`) VALUES(%s, %s, %s)"
cur.execute(sql, (username, salted_hash, groupid))
dbservices.closeCursor(cur)
logging.info("User %s added to group %i", username, groupid)
def editUser(orig_username, username, pwhash, groupid):
sql = "UPDATE `users` SET `username` = %s, `password` = %s, `group_id` = %s WHERE `username` = %s"
cur = dbservices.getCursor()
rows_affected = cur.execute(sql, (username, doSalt(pwhash), groupid, orig_username))
dbservices.closeCursor(cur)
if rows_affected:
logging.info("User %s edited: Group %s", username, groupid)
return True
logging.info("User %s editing failed", username)
return False
def deleteUser(username):
sql = "DELETE FROM `users` WHERE username = %s"
cur = dbservices.getCursor()
rows_affected = cur.execute(sql, username)
dbservices.closeCursor(cur)
if rows_affected:
logging.info("User %s deleted.", username)
return True
logging.info("User %s deletion failed.", username)
return False
def checkIfUsernameExists(username):
cur = dbservices.getCursor()
sql = "SELECT COUNT(*) FROM `users` WHERE `username` = %s"
cur.execute(sql, username)
numEntries = cur.fetchone()[0]
dbservices.closeCursor(cur)
if numEntries:
return True
return False
def loginUser(username, pwhash):
salted_hash = doSalt(pwhash)
sql = "SELECT COUNT(*) FROM `users` WHERE username = %s AND password = %s"
cur = dbservices.getCursor()
cur.execute(sql, (username, salted_hash))
numrows = cur.fetchone()[0]
dbservices.closeCursor(cur)
if numrows:
logging.info("User %s successfully logged in", username)
return True
logging.info("User %s login attempt failed", username)
return False