diff options
Diffstat (limited to 'database.py')
| -rw-r--r-- | database.py | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/database.py b/database.py index 9927627..5f14801 100644 --- a/database.py +++ b/database.py @@ -17,6 +17,11 @@ class DatabaseConnection(object): self.conn.commit() return c.lastrowid + def get_groups(self): + with closing(self.conn.cursor(MySQLdb.cursors.DictCursor)) as c: + c.execute("select * from `groups`") + return c.fetchall() + def get_connection(user, passwd, db): conn = MySQLdb.connect(user=user, passwd=passwd, db=db) return DatabaseConnection(conn) |