def get_by_id(id_: int, cook=True):
value = DBUtils.get_by_single("music", "id", id_)
# 转换成music对象
if cook and value is not None:
m = Converter.local_data_local_music(value)
return m
return value
def get_by_music_id(music_id: str, cook=True):
value = DBUtils.get_by_single("music", "music_id", music_id)
# 转换成music对象
if cook and value is not None:
m = Converter.local_data_local_music(value)
return m
return value
def get_by_name(name, cook=True):
value = DBUtils.get_by_single("music", "name", name)
# 转换成music对象
if cook and value is not None:
m = Converter.local_data_local_music(value)
return m
return value
def get_all(cook=True):
cursor = DBUtils.get_cursor()
cursor.execute("select * from music")
values = cursor.fetchall()
cursor.close()
# 转换成music对象
if cook:
musics = []
for v in values:
m = Converter.local_data_local_music(v)
musics.append(m)
return musics
return values
def test1():
file = u"F:\CloudMusic\李宗盛\李宗盛 - 山丘 (Live).mp3"
mp_ = MP3(file)
url = "https://api.itooi.cn/music/netease/song?key=579621905&id=1356132066"
get = requests.get(url)
json_result = json.loads(get.content.decode())
music = Converter.itooi_music(json_result)
music.get_uri()
time.sleep(15)
pygame.mixer.music.pause()
time.sleep(3)
pygame.mixer.music.unpause()
print("test 1 over")
def slot_net_search_success(self, music_list: list):
for i, v in enumerate(music_list):
Ui_MainWindow.__gen_list_item(self.net_list_widget, i,
Converter.itooi_music(v))
self.stackedWidget_3.setCurrentIndex(0)
self.label_2.movie().stop()