def get_album_information(self, album_id):
cursor = self.con.cursor()
query = '''SELECT albumTitle, bandName FROM Album WHERE albumID = ?'''
cursor.execute(query, (album_id, ))
self.con.commit()
album_info = cursor.fetchall()
album = Album(*album_info[0])
query = '''SELECT songURL, songName, songLength
FROM Song
WHERE albumID = ?'''
cursor.execute(query, (album_id))
self.con.commit()
songs_list = cursor.fetchall()
for item in songs_list:
song = Song(url=item[0], name=item[1], length=item[2])
album.add_song(song)
return album
