diff options
Diffstat (limited to 'mysql_utils.py')
-rw-r--r-- | mysql_utils.py | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql_utils.py b/mysql_utils.py index e59c3d9..1edfe35 100644 --- a/mysql_utils.py +++ b/mysql_utils.py @@ -13,11 +13,23 @@ class mysql_connect: if args is None: return self.curs.execute(query) else: + print query + print args return self.curs.execute(query, args) def fetchall(self): return self.curs.fetchall() + @property + def columns(self): + self.execute("SHOW COLUMNS FROM utils_players") + fetched = self.fetchall() + columns = [] + + for row in fetched: + columns.append(row[0]) + return columns + def __enter__(self): return self |