this could be in a method, like:

    def get_columns(self, name):
        columns = self.cursor.execute('show columns from {0}'.format(name))
        return columns.fetchall()