def test_track_report_snippet(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
db_return = self.collection.track_report_snippet(4, 133)
self.assertEqual(len(db_return), 3) # a snippet is always 3 tracks
# track 3
self.assertEqual(db_return[0]["track_pos"], 3)
self.assertEqual(db_return[0]["discogs_title"], "Material Love")
self.assertEqual(db_return[0]["d_track_no"], "B1")
self.assertEqual(db_return[0]["trans_rating"], "")
self.assertEqual(db_return[0]["key"], None)
self.assertEqual(db_return[0]["bpm"], 140)
self.assertEqual(db_return[0]["a_key"], None)
self.assertEqual(db_return[0]["a_bpm"], None)
# track 4
self.assertEqual(db_return[1]["track_pos"], 4)
self.assertEqual(db_return[1]["discogs_title"], "The Crane")
self.assertEqual(db_return[1]["d_track_no"], "AA")
self.assertEqual(db_return[1]["trans_rating"], "")
self.assertEqual(db_return[1]["key"], "Am")
self.assertEqual(db_return[1]["bpm"], 120)
self.assertEqual(db_return[1]["a_key"], None)
self.assertEqual(db_return[1]["a_bpm"], None)
# track 5
self.assertEqual(db_return[2]["track_pos"], 5)
print("{} - {} - END".format(self.clname, name))
def test_stats_releases_d_collection_flag(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
db_return = self.collection.stats_releases_d_collection_flag()
self.assertEqual(db_return, 4)
print("{} - {} - END".format(self.clname, name))
def test_stats_tracks_key_brainz(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
db_return = self.collection.stats_tracks_key_brainz()
self.assertEqual(db_return, 1) # should be 1 track with ab_key
print("{} - {} - END".format(self.clname, name))
def test_stats_tracks_bpm_manual(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
db_return = self.collection.stats_tracks_bpm_manual()
self.assertEqual(db_return, 5) # should be 5 tracks with manual bpm
print("{} - {} - END".format(self.clname, name))
def test_search_release_offline_number_error(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
db_return = self.collection.search_release_offline('999999')
self.assertIsNone(db_return)
print("{} - {} - END".format(self.clname, name))
def test_stats_releases_total(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
db_return = self.collection.stats_releases_total()
# self.debug_db(db_return)
self.assertEqual(db_return, 4) # should be 4 releases in coll.
print("{} - {} - END".format(self.clname, name))
def test_search_release_offline_text_error(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
db_return = self.collection.search_release_offline('XXX') # artist or title
self.assertIsNone(db_return) # returns None if nothing found
# self.assertEqual(db_return, []) # FIXME should this better be empty list?
print("{} - {} - END".format(self.clname, name))
def test_stats_mixtracks_unique(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
db_return = self.collection.stats_mixtracks_unique()
# self.debug_db(db_return)
self.assertEqual(db_return, 7) # 7 unique tracks
print("{} - {} - END".format(self.clname, name))
def test_stats_track_ext_orphaned(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
db_return = self.collection.stats_track_ext_orphaned()
# self.debug_db(db_return)
self.assertEqual(db_return, 0)
print("{} - {} - END".format(self.clname, name))
def test_search_release_track_offline_nothing(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
dbr = self.collection.search_release_track_offline(
artist='', release='', track='')
# self.debug_db(dbr)
self.assertIsNotNone(dbr)
self.assertEqual(len(dbr), 0) # should be a list with 0 Rows
print("{} - {} - END".format(self.clname, name))
def test_stats_match_method_release(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
db_return = self.collection.stats_match_method_release()
# self.debug_db(db_return)
self.assertEqual(len(db_return), 3) # should be a list with 4 Rows
self.assertEqual(db_return[0]['m_match_method'], None)
self.assertEqual(db_return[1]['m_match_method'], 'CatNo (exact)')
self.assertEqual(db_return[2]['m_match_method'], "Discogs URL")
print("{} - {} - END".format(self.clname, name))
def test_search_release_offline_number(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
db_return = self.collection.search_release_offline('123456')
self.assertIsNotNone(db_return)
self.assertEqual(len(db_return), 10) # should be 10 columns
self.assertEqual(db_return['discogs_id'], 123456)
self.assertEqual(db_return['d_artist'], 'Märtini Brös.')
self.assertEqual(db_return['discogs_title'], 'Material Love')
print("{} - {} - END".format(self.clname, name))
def test_d_get_first_catno(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
label_item = Mock() # Mock a label object.
label_item.data = {'catno': 'ZEN 70'}
mock_d_labels = [label_item] # Mock list of label objects.
catno = self.collection.d_get_first_catno( # And finally test.
mock_d_labels
)
self.assertEqual(catno, 'ZEN 70')
print("{} - {} - END".format(self.clname, name))
def test_search_release_track_offline_artist(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
dbr = self.collection.search_release_track_offline(
artist='Märtini', release='', track='')
# self.debug_db(dbr)
self.assertIsNotNone(dbr)
self.assertEqual(len(dbr), 3) # should be a list with 3 Rows
self.assertEqual(dbr[2]['discogs_id'], 123456)
self.assertEqual(dbr[0]['d_artist'], 'Märtini Brös.')
self.assertEqual(dbr[1]['discogs_title'], 'Material Love')
print("{} - {} - END".format(self.clname, name))
def test_search_release_offline_text_multiple(self):
print("\nTestMix.search_release_offline_text_multiple: BEGIN")
self.collection = Collection(False, self.db_path)
db_return = self.collection.search_release_offline('Amon') # artist or title
self.assertIsNotNone(db_return)
self.assertEqual(len(db_return), 2) # should be a list with 2 Rows
self.assertEqual(db_return[0]['discogs_id'], 69092)
self.assertEqual(db_return[0]['d_artist'], 'Amon Tobin')
self.assertEqual(db_return[0]['discogs_title'], 'Out From Out Where')
self.assertEqual(db_return[1]['discogs_id'], 919698)
self.assertEqual(db_return[1]['d_artist'], 'Amon Tobin')
self.assertEqual(db_return[1]['discogs_title'], 'Foley Room')
print("TestMix.search_release_offline_text_multiple: DONE\n")
def test_search_release_track_offline_release(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
dbr = self.collection.search_release_track_offline(
artist='', release='material', track='')
# self.debug_db(dbr)
self.assertIsNotNone(dbr)
self.assertEqual(len(dbr), 3) # it's one release but finds all track entries!
self.assertEqual(dbr[0]['d_artist'], 'Märtini Brös.')
self.assertEqual(dbr[1]['d_track_name'], 'Material Love')
self.assertEqual(dbr[2]['discogs_title'], 'Material Love')
print("{} - {} - END".format(self.clname, name))
def test_search_release_track_offline_artist_release_track(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
dbr = self.collection.search_release_track_offline(
artist='Märtini', release='material', track='cab')
# self.debug_db(dbr)
self.assertIsNotNone(dbr)
self.assertEqual(len(dbr), 1) # one track
self.assertEqual(dbr[0]['d_artist'], 'Märtini Brös.')
self.assertEqual(dbr[0]['d_track_name'], 'Material Love (Cab Drivers Remix)')
self.assertEqual(dbr[0]['discogs_title'], 'Material Love')
print("{} - {} - END".format(self.clname, name))
def test_get_tracks_by_key(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
db_return = self.collection.get_tracks_by_key("Am")
self.assertIsNotNone(db_return)
self.assertEqual(len(db_return), 2) # should be a list with 2 Rows
self.assertEqual(db_return[0]['d_artist'], 'Source Direct')
self.assertEqual(db_return[0]['d_track_no'], 'AA')
self.assertEqual(db_return[0]['chosen_bpm'], 120)
self.assertEqual(db_return[1]['d_artist'], 'Märtini Brös.')
self.assertEqual(db_return[1]['d_track_no'], 'A1')
self.assertEqual(db_return[1]['chosen_bpm'], 125)
print("{} - {} - END".format(self.clname, name))
def test_track_report_occurences(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
self.collection = Collection(False, self.db_path)
db_return = self.collection.track_report_occurences(123456, 'B2')
self.assertEqual(len(db_return), 11) # track was used 11 times
# check some occurences
self.assertEqual(db_return[0]["mix_id"], 125) # first occurence
self.assertEqual(db_return[0]["track_pos"], 2) # used at pos 2
self.assertEqual(
db_return[0]["name"],
'test 125 last_tr, tr_of_one_mix, one_mix')
self.assertEqual(db_return[7]["mix_id"], 132) # 8th occurence
self.assertEqual(db_return[7]["track_pos"], 2) # used at pos 2
self.assertEqual(db_return[10]["mix_id"], 135) # 11th occurence
self.assertEqual(db_return[10]["track_pos"], 2) # used at pos 2
print("{} - {} - END".format(self.clname, name))
def test_get_all_db_releases(self):
name = inspect.currentframe().f_code.co_name
print("\n{} - {} - BEGIN".format(self.clname, name))
# instantiate the Collection model class
self.collection = Collection(False, self.db_path)
db_return = self.collection.get_all_db_releases()
# self.debug_db(db_return)
self.assertIsNotNone(db_return)
self.assertEqual(len(db_return), 4)
self.assertEqual(db_return[2]['discogs_id'], 123456)
self.assertEqual(db_return[2]['discogs_title'], 'Material Love')
# self.assertEqual(db_return[2]['import_timestamp'], '2020-01-25 22:33:35')
self.assertEqual(db_return[2]['d_artist'], 'Märtini Brös.')
# self.assertEqual(db_return[2]['in_d_collection'], 1)
self.assertEqual(db_return[3]['discogs_id'], 8620643)
self.assertEqual(db_return[3]['discogs_title'], 'The Crane')
# self.assertEqual(db_return[3]['import_timestamp'], '2020-01-30 10:06:26')
self.assertEqual(db_return[3]['d_artist'], 'Source Direct')
# self.assertEqual(db_return[3]['in_d_collection'], 1)
print("{} - {} - END".format(self.clname, name))
