def add_song(self, song, playlist_name):
conn.execute("INSERT INTO song VALUES('" + song.name + "','" +
song.release_date + "','" + song.lyrics + "','" +
song.length + "','" + song.path + "','" + song.album +
"')")
conn.commit()
def get_song(self, name):
song = Song()
result = conn.execute("SELECT * FROM song " + "WHERE name = '" + name +
"'")
for row in result:
song.name = row[0]
song.release_date = row[1]
song.lyrics = row[2]
song.length = row[3]
song.path = row[4]
song.album = row[5]
print("name", name)
result1 = conn.execute("SELECT band_name " + "FROM song_band " +
"WHERE song_name = '" + name + "'" +
"AND featured = '0'")
result2 = conn.execute("SELECT band_name " + "FROM song_band " +
"WHERE song_name = '" + name + "'" +
"AND featured = '1'")
for band, featured_band in zip(result1, result2):
print("SS", band[0])
song.bands.append(band[0])
song.featured_bands.append(featured_band[0])
result = conn.execute("SELECT band_name " + "FROM song_band " +
"WHERE song_name = '" + name + "'" +
"AND featured = 'true'")
for row in result:
song.featured_bands.append(row[0])
return song
def add_song_band(self, song):
for band_name in song.bands:
conn.execute("INSERT INTO song_band VALUES('" + song.name + "','" +
band_name + "'," + '0' + ")")
for band_name in song.featured_bands:
conn.execute("INSERT INTO song_band VALUES('" + song.name + "','" +
band_name + "'," + '1' + ")")
conn.commit()
def get_playlist(self, name):
playlist = Playlist()
result = conn.execute("SELECT * FROM playlist " + "WHERE name = '" +
name + "'")
for row in result:
playlist.name = row[0]
playlist.description = row[1]
result = conn.execute("SELECT song_name "
"FROM playlist_song " +
"WHERE playlist_name = '" + playlist.name + "'")
for row in result:
playlist.songs.append(song_model.get_song(row[0]))
return playlist
def get_playlists(self):
result = conn.execute("SELECT * FROM playlist")
playlists = []
for row in result:
playlist = Playlist()
playlist.name = row[0]
playlist.description = row[1]
playlists.append(playlist)
for playlist in playlists:
result = conn.execute("SELECT song_name " + "FROM playlist_song " +
"WHERE playlist_name = '" + playlist.name +
"'")
for row in result:
playlist.songs.append(row[0])
return playlists
def getPlaylistSongs(self, playlist_name):
result = conn.execute("SELECT song_name "
"FROM playlist_song " +
"WHERE playlist_name = '" + playlist_name + "'")
songs = []
for row in result:
songs.append(song_model.get_song(row[0]))
return songs
def get_album(self, name):
result = conn.execute("SELECT * FROM album " + "WHERE name = '" +
name + "'")
album = Album()
for row in result:
album.name = row[0]
result = conn.execute("SELECT name FROM song " +
"WHERE album_name = '" + album.name + "'")
songs = []
for song_name in result:
songs.append(song_model.get_song(song_name[0]))
album.songs = songs
album.number_of_songs = len(album.songs)
return album
def get_songs(self, band_name):
result = conn.execute("SELECT song_name FROM song_band " +
"WHERE band_name = '" + band_name + "'")
songs = []
for row in result:
songs.append(song_model.get_song(row[0]))
return songs
def get_albums(self):
result = conn.execute("SELECT * FROM album")
albums = []
for row in result:
album = self.get_album(row[0])
albums.append(album)
return albums
def get_artists(self):
result = conn.execute("SELECT * FROM artist")
artists = []
for row in result:
artist = Artist()
artist.name = row[0]
artist.date_of_birth = row[1]
artist.band = row[2]
artists.append(artist)
return artists
def add_playlist_songs(self, song_name, playlist_name):
conn.execute("INSERT INTO playlist_song VALUES('" + playlist_name +
"','" + song_name + "')")
conn.commit()
def remove_playlist_song(self, playlist_name, song_name):
conn.execute("DELETE FROM playlist_song " + "WHERE playlist_name = '" +
playlist_name + "' " + "AND song_name = '" + song_name +
"'")
conn.commit()
def add_playlist(self, name, description):
conn.execute("INSERT INTO playlist VALUES('" + name + "','" +
description + "')")
conn.commit()
def add_album(self, name):
conn.execute("INSERT INTO album VALUES('" + name + "')")
conn.execute()
def add_artist(self, artist):
conn.execute("INSERT INTO artist " + "VALUES('" + artist.name +
"', '" + artist.date_of_birth + "', '" + artist.band +
"')")
conn.commit()
def remove_playlist(self, name):
conn.execute("DELETE FROM playlist_song " + "WHERE playlist_name = '" +
name + "'")
conn.execute("DELETE FROM playlist " + "WHERE name = '" + name + "'")
conn.commit()
def add_band(self, band_name):
conn.execute("INSERT INTO band VALUES('" + band_name + "')")
conn.commit()
