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 저장완료!")
