def setPermission(db, user, perms):
db.c.execute("UPDATE users SET permission=? WHERE name=?", (perms, user))
@style.async
def setRole(db, user, role):
db.c.execute("UPDATE users SET role=? WHERE name=?", (role, user))
@style.queue
def listUsers(db):
db.c.execute('SELECT name FROM users')
users = []
for row in db.c:
users.append(row[0])
return users
@style.queue
def getAllUserData(db):
db.c.execute("SELECT name, permission, role, template, email FROM users")
user = {}
for r in db.c:
user[r[0]] = {"permission": r[1], "role": r[2], "template": r[3], "email": r[4]}
return user
@style.queue
def removeUser(db, user):
db.c.execute('DELETE FROM users WHERE name=?', (user,))
DatabaseBackend.registerSub(UserMethods)
@style.queue
def listUsers(db):
db.c.execute('SELECT name FROM users')
users = []
for row in db.c:
users.append(row[0])
return users
@style.queue
def getAllUserData(db):
db.c.execute(
"SELECT name, permission, role, template, email FROM users")
user = {}
for r in db.c:
user[r[0]] = {
"permission": r[1],
"role": r[2],
"template": r[3],
"email": r[4]
}
return user
@style.queue
def removeUser(db, user):
db.c.execute('DELETE FROM users WHERE name=?', (user, ))
DatabaseBackend.registerSub(UserMethods)
