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