Starting to work on users in DB

diff --git a/TODO b/TODO
new file mode 100644 (file)
index 0000000..49522cc
--- /dev/null
+++ b/TODO
@@ -0,0 +1,4 @@
+- Store User and Channel objects
+- Add no-such-command error to Bot().parsemsg
+- Add level checking to Bot().parsemsg
+- Add PM-to-bot support

diff --git a/erebus.py b/erebus.py
index 421d3012becec4d0e6e4f809fc89691bd32c689f..6e1289e12786e7719a36df9500a6d25aba62e14a 100644 (file)
--- a/erebus.py
+++ b/erebus.py
@@ -16,19 +16,28 @@ class Erebus(object):
 
                def __init__(self, nick, auth=None):
                        self.nick = nick
-                       self.auth = auth
-
-                       if auth is not None:
-                               self.checklevel()
+                       self.auth = nick #TEMP
+                       self.checklevel()
 
                def authed(self, auth):
                        self.auth = auth
                        self.checklevel()
 
-               def checklevel(self): self.level = 9999 #TODO get level from db
+               def checklevel(self):
+                       if self.auth is None:
+                               self.level = -1
+                       else:
+                               c = main.db.cursor()
+                               c.execute("SELECT level FROM users WHERE auth = %s", (self.auth,))
+                               row = c.fetchone()
+                               if row is not None:
+                                       self.level = row['level']
+                               else:
+                                       self.level = 0
+                       return self.level
 
                def __str__(self): return self.nick
-               def __repr__(self): return "<User %r>" % (self.nick)
+               def __repr__(self): return "<User %r (%d)>" % (self.nick,self.level)
 
        class Channel(object):
                users = []