def test_get_top_ten_most_listened_tracks():
rows = MusicTracks.get_top_ten_most_listened_tracks()
values = [
491235, 158793, 108682, 92059, 89844, 89302, 77324, 68234, 66866, 61303
]
assert len(rows) == 10
n = 0
for row in rows:
assert row[9] == values[0]
n = n + 1
def test_where_returns_correct_keys():
row = MusicTracks.where({'album_title': 'KONTRAST'})[0]
keys = [
'track_id', 'album_id', 'album_title', 'album_url', 'artist_id',
'artist_name', 'artist_url', 'track_date_created', 'track_duration',
'track_listens', 'track_title', 'track_url'
]
values = [
'56482', '10439', 'KONTRAST',
'http://freemusicarchive.org/music/KVZE/KONTRAST/', '12270', 'KVZE',
'http://freemusicarchive.org/music/KVZE/', '11/16/2011 03:54:59 PM',
'02:21', '1047', 'Scotch',
'http://freemusicarchive.org/music/KVZE/KONTRAST/08_kvze_-_scotch'
]
for i in range(0, len(keys)):
assert row[keys[i]] == values[i]
def test_find_by_album_id():
row = MusicTracks.find_by_id({'album_id': '21390'})
keys = [
'track_id', 'album_id', 'album_title', 'album_url', 'artist_id',
'artist_name', 'artist_url', 'track_date_created', 'track_duration',
'track_listens', 'track_title', 'track_url'
]
values = [
'142485', '21390', 'Sanctuary',
'http://freemusicarchive.org/music/Artem_Bemba/Sanctuary/', '20476',
'Artem Bemba', 'http://freemusicarchive.org/music/Artem_Bemba/',
'9/03/2016 04:14:26 AM', '13:24', '1900', 'Flour',
'http://freemusicarchive.org/music/Artem_Bemba/Sanctuary/Artem_Bemba_-_01_-_Flour'
]
for i in range(0, len(keys)):
assert row[keys[i]] == values[i]
def test_find_by_artist_id():
row = MusicTracks.find_by_id({'artist_id': '11070'})
keys = [
'track_id', 'album_id', 'album_title', 'album_url', 'artist_id',
'artist_name', 'artist_url', 'track_date_created', 'track_duration',
'track_listens', 'track_title', 'track_url'
]
values = [
'143654', '21538', 'Necktar Volume 2',
'http://freemusicarchive.org/music/Subversive_Intentions/Volume_2_1042/',
'11070', 'Subversive Intentions',
'http://freemusicarchive.org/music/Subversive_Intentions/',
'9/26/2016 05:36:34 AM', '10:28', '13', 'Permanentpress',
'http://freemusicarchive.org/music/Subversive_Intentions/Volume_2_1042/23_-_Permanentpress'
]
for i in range(0, len(keys)):
assert row[keys[i]] == values[i]
def test_find_by_track_id():
row = MusicTracks.find_by_id({'track_id': '143342'})
keys = [
'track_id', 'album_id', 'album_title', 'album_url', 'artist_id',
'artist_name', 'artist_url', 'track_date_created', 'track_duration',
'track_listens', 'track_title', 'track_url'
]
values = [
'143342', '21515', 'Timethod',
'http://freemusicarchive.org/music/Ars_Sonor__Total_ET/Timethod/',
'22800', 'Ars Sonor & Total E.T.',
'http://freemusicarchive.org/music/Ars_Sonor__Total_ET/',
'9/21/2016 05:23:45 AM', '01:40', '5168', 'Intro',
'http://freemusicarchive.org/music/Ars_Sonor__Total_ET/Timethod/01-Intro_1074'
]
for i in range(0, len(keys)):
assert row[keys[i]] == values[i]
def test_where_returns_no_tracks():
assert len(MusicTracks.where({'track_title': 'NotExistentTitle'})) == 0
def test_where_returns_tracks_by_title():
assert len(MusicTracks.where({'track_title': 'Introduction'})) == 2
def test_where_returns_tracks_per_album():
assert len(MusicTracks.where({'album_title': 'Kung Flu'})) == 5
def test_where_returns_tracks_by_listens():
assert len(MusicTracks.where({'track_listens': '842'})) == 4
def test_where_returns_tracks_by_artist_name():
assert len(MusicTracks.where({'artist_name': 'The Loving Knives'})) == 6