def retrieveBands(self): sql = "SELECT * from band" cur.execute(sql) self.myBands = [] for row in cur: b = Band() b.band_id = row[0] b.name = row[1] self.myBands.append(b)