From 64974b9a18ef08f5a9f65a17af5cb06c1db4295c Mon Sep 17 00:00:00 2001
From: RaNaN <Mast3rRaNaN@hotmail.de>
Date: Thu, 10 Mar 2011 13:19:36 +0100
Subject: webif user managment

---
 module/database/UserDatabase.py | 30 ++++++++++++++++++++++--------
 1 file changed, 22 insertions(+), 8 deletions(-)

(limited to 'module/database/UserDatabase.py')

diff --git a/module/database/UserDatabase.py b/module/database/UserDatabase.py
index d2809fcea..6e04fa249 100644
--- a/module/database/UserDatabase.py
+++ b/module/database/UserDatabase.py
@@ -36,7 +36,7 @@ class ROLE:
 
 def has_permission(current, perms):
     # bytewise or perms before if needed
-    return current == (current & perms)
+    return perms == (current & perms)
 
 class UserMethods():
     @style.queue
@@ -69,18 +69,32 @@ class UserMethods():
             c.execute('INSERT INTO users (name, password) VALUES (?, ?)', (user, password))
 
 
-    @style.queue
-    def setPermission(db, userid, perms):
-        db.c.execute("UPDATE users SET permission=? WHERE id=?", (perms, userid))
-    
+    @style.async
+    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):
-        c = db.c
-        c.execute('SELECT name FROM users')
+        db.c.execute('SELECT name FROM users')
         users = []
-        for row in c.fetchall():
+        for row in db.c:
             users.append(row[0])
         return users
+
+    @style.queue
+    def getAllUserData(db):
+        db.c.execute("SELECT name, permission, role FROM users")
+        user = {}
+        for r in db.c:
+            user[r[0]] = {"permission" : r[1], "role" : r[2]}
+            
+        return user
+
     
     @style.queue
     def removeUser(db, user):
-- 
cgit v1.2.3