def test_can_create_artist(db):
"""Test can create Artist."""
artist = Artist(name='Michael Jackson')
db.session.add(artist)
db.session.commit()
assert artist in db.session
def test_can_read_artist(db):
"""Test can read Artist."""
artist = Artist(name='Michael Jackson')
db.session.add(artist)
db.session.commit()
artist_query = Artist.query.filter_by(name='Michael Jackson').first()
assert 'Michael Jackson' == artist_query.name
def test_can_create_album(db):
"""Test can create Artist."""
artist = Artist(name='Michael Jackson')
album = Album(title='Off the Wall', album_artists=[artist])
db.session.add(album)
db.session.commit()
assert album in db.session
def test_can_read_album(db):
"""Test can read Album."""
artist = Artist(name='Michael Jackson')
album = Album(title='Off the Wall', album_artists=[artist])
db.session.add(album)
db.session.commit()
album_query = Album.query.filter_by(title='Off the Wall').first()
assert 'Michael Jackson' == album_query.album_artists[0].name
def test_can_delete_artist(db):
"""Test can delete Artist."""
artist = Artist(name='Michael Jackson')
db.session.add(artist)
db.session.commit()
artist = Artist.query.filter_by(name='Michael Jackson').first()
db.session.delete(artist)
db.session.commit()
artist = Artist.query.filter_by(name='Michael Jackson').first()
assert artist is None
def test_date_changed_after_update(db):
"""Test that the `last_updated` field is updated on save."""
artist = Artist(name='Michael Jackson')
db.session.add(artist)
db.session.commit()
created = artist.last_updated
sleep(1)
artist.name = "Phil Collins"
db.session.commit()
updated = artist.last_updated
assert created != updated
def test_can_update_artist(db):
"""Test can update Artist."""
artist = Artist(name='Michael Jackson')
db.session.add(artist)
db.session.commit()
artist = Artist.query.filter_by(name='Michael Jackson').first()
artist.name = "Phil Collins"
db.session.add(artist)
db.session.commit()
artist = Artist.query.filter_by(name='Phil Collins').first()
assert 'Phil Collins' == artist.name
artist = Artist.query.filter_by(name='Michael Jackson').first()
assert artist is None
def test_can_create_album_song(db):
album = Album(
title="The Rise And Fall Of Ziggy Stardust And The Spiders From Mars")
artist = Artist(name="David Bowie")
album.album_artists.append(artist)
song = Song(title="Ziggy Stardust", path="/ziggy_stardust.mp3")
song.artists.append(artist)
album_song = AlbumSong()
album_song.song = song
album_song.album = album
album_song.track_no = 9
db.session.add(album)
db.session.add(artist)
db.session.add(song)
db.session.add(album_song)
db.session.commit()
album_song = AlbumSong.query.first()
print(album_song.album.__dict__)
assert album_song.song.title == "Ziggy Stardust"
assert album_song.album.title == "The Rise And Fall Of Ziggy Stardust And The Spiders From " +\
"Mars"
assert album_song.track_no == 9
def test_artist_serialise(db):
"""Test Artist serialise method."""
artist = Artist(name='Michael Jackson')
assert isinstance(artist.serialise(), dict)
def test_album_serialise(db):
artist = Artist(name='Michael Jackson')
album = Album(title='Off the Wall', album_artists=[artist])
assert isinstance(album.serialise(), dict)
assert isinstance(album.serialise()['album_artists'], list)
