def retrieveAlbums(self):
sql = "SELECT * from album"
cur.execute(sql)
self.myAlbums = []
for row in cur:
a = Album()
a.album_id = row[0]
a.title = row[1]
a.band_name = row[2]
a.band_id = row[3]
self.myAlbums.append(a)
def retrieveBandAlbums(self):
albums = []
sql = "SELECT * from album where band_id = '" + str(self.band_id) + "'"
cur.execute(sql)
for row in cur:
a = Album()
a.album_id = row[0]
a.title = row[1]
a.band_name = row[2]
a.band_id = row[3]
albums.append(a)
return albums
