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()