def Mysql_song(self): for i in self.songsnum: for s_id in self.singers_dic[i]: print("Song테이블 저장중....") self.Song_table.append([i, self.top100_dic[i]['songname'], s_id, self.album_dic[i]]) print("Song테이블 저장 완료") save(self.sql_truncate_s, self.sql_insert_s, self.Song_table)
def Mysql_songrank(self): for i in self.songsnum: print("SongRank테이블 저장중....") self.Songrank_table.append( [i, self.top100_dic[i]['likecnt'], self.top100_dic[i]['rank']]) save(self.sql_truncate_sr, self.sql_insert_sr, self.Song_table) print("SongRank테이블 저장완료!!")
def Mysql_artists(self): for id in self.artists_dic_t: for head in self.artists_dic_t[id]: for artist_id in self.artists_dic_t[id][head].values(): self.artist_info_lst.append( [str(id), str(artist_id), str(head)]) save(self.sql_truncate, self.sql_insert, self.artists_dic_t)
def Mysql_albuminfo(self): for i in self.album_info_dic.keys(): self.album_lst.append( [str(i), str(self.album_info_dic[i]['albumtitle']), str(self.album_info_dic[i]['albumtype']), str(self.album_info_dic[i]['likecnt']), self.album_info_dic[i]['발매사'], self.album_info_dic[i]['기획사'], str(self.album_info_dic[i]['발매일']), str(self.album_info_dic[i]['사람수']), self.album_info_dic[i]['장르'], str(self.album_info_dic[i]['평점']) ]) print("앨범테이블 저장중") save(self.sql_truncate, self.sql_insert, self.album_lst) print("앨범저장완료")
def Mysql_albuminfo(self): for i in self.album_id: self.album_lst.append([ str(i), str(self.album_info_dic[i]['albumtitle']), str(self.album_info_dic[i]['albumtype']), str(self.album_info_dic[i]['likecnt']), self.album_info_dic[i]['발매사'], self.album_info_dic[i]['기획사'], str(self.album_info_dic[i]['발매일']), str(self.album_info_dic[i]['사람수']), self.album_info_dic[i]['장르'], str(self.album_info_dic[i]['평점']) ]) save(self.sql_truncate, self.sql_insert, self.album_lst)
def Mysql_meltop(self): print("TOP100 저장중...") save(self.sql_truncate_m, self.sql_insert_m, self.MelTop100_table ) print("TOP100 저장완료!")