示例#1
0
def removeUser():
    user_id = bottle.request.forms.get('id')

    if HomerHelper.idCheck('Users', user_id):  #validate the device ID
        user_name = HomerHelper.getUserName(user_id)
        try:
            db.query("DELETE FROM Users WHERE id = %s", user_id)
            #con.commit()
            HomerHelper.insert_history(user_name, user_id, "user removed")

            return("OK")

        except MySQLdb.IntegrityError:
            bottle.abort(400, "Doh! Unable to remove device. ")
    else:
        err_msg = "Doh! That request was no bueno. %s is not a valid ID or it is not enrolled in HOMEr" % user_id
        bottle.abort(400, err_msg)
示例#2
0
def setLocation():
    user_id = bottle.request.params.get('id')
    user_location = bottle.request.params.get('location')

    if HomerHelper.userIdCheck(user_id):
        user_name = HomerHelper.getUserName(user_id)

        try:
            sql_update = "UPDATE `Users` SET `Location`= %s  WHERE ID = %s"
            db.query(sql_update, (user_location, user_id))
            history_event = "set user location to: " + user_location
            HomerHelper.insert_history(user_name, user_id, history_event)
            return "OK"

        except MySQLdb.IntegrityError:
            bottle.abort(400, "Doh! User doesn't exist")
    else:
        bottle.abort(400, "Doh! User ID was not found")