#coding=utf-8 import random import csv import MySQLdb import sys from mydb import Tiedb from mydb import Meta import re mydb = Tiedb() meta = Meta() # for row in mydb.get_random_rows(100, "%gmail.com"): # print row # sys.exit(0) #print mydb.get_song_info("青花瓷","周杰伦")[0],mydb.get_song_info("青花瓷","周杰伦")[1],mydb.get_song_info("青花瓷","周杰伦")[2] csvfile = file('meta_no_company_redirect.csv', 'rb') reader = csv.reader(csvfile) index=0 index_error=0 index_full=0 for lrow in list(reader): index=index+1 print '处理前:',lrow[0].decode('gbk'),lrow[1].decode('gbk'),'index:',index try: song=lrow[0].decode('gbk').encode('UTF-8') song=re.sub('\(.*?\)|\[.*?]|{.*?}|(.*?)','',song)#去括号 artist=lrow[1].decode('gbk').encode('UTF-8') artist=re.sub('\(.*?\)|\[.*?]|{.*?}|(.*?)','',artist)#去括号
#!-*- coding:utf8 -*- import os from mydb import Meta from mutagen.mp3 import MP3 import mutagen.id3 from mutagen.easyid3 import EasyID3 import sys reload(sys) sys.setdefaultencoding('utf-8') meta = Meta() index_match=0 path = 'D:\\Kuwo_2' for file in os.listdir(path): if file.find('-')>0: file_seg=file.split('-') artist=file_seg[0].decode('gbk').encode('utf-8') song=file_seg[1].split('.')[0].decode('gbk').encode('utf-8') try: match=meta.get_song_like(song,artist) if match: index_match+=1 # id3info = MP3(os.path.join(path,file), ID3=EasyID3) # for k, v in id3info.items(): # if k=='album': # album = ''.join(v) # meta.update_album_like(album,song,artist) # print album,index_match newname=match[0]+' - '+artist+'.mp3' os.rename(os.path.join(path,file),os.path.join(path+'\\match\\',newname)) print match[0],match[1],index_match
#coding=utf-8 import random import csv import MySQLdb import sys from mydb import Tiedb from mydb import Meta import re mydb = Tiedb() meta = Meta() # for row in mydb.get_random_rows(100, "%gmail.com"): # print row # sys.exit(0) #print mydb.get_song_info("青花瓷","周杰伦")[0],mydb.get_song_info("青花瓷","周杰伦")[1],mydb.get_song_info("青花瓷","周杰伦")[2] csvfile = file('meta_no_company_redirect.csv', 'rb') reader = csv.reader(csvfile) index = 0 index_error = 0 index_full = 0 for lrow in list(reader): index = index + 1 print '处理前:', lrow[0].decode('gbk'), lrow[1].decode('gbk'), 'index:', index try: song = lrow[0].decode('gbk').encode('UTF-8') song = re.sub('\(.*?\)|\[.*?]|{.*?}|(.*?)', '', song) #去括号 artist = lrow[1].decode('gbk').encode('UTF-8') artist = re.sub('\(.*?\)|\[.*?]|{.*?}|(.*?)', '', artist) #去括号 album = lrow[2].decode('gbk').encode('UTF-8')
#coding=utf-8 import random import csv import MySQLdb import sys from mydb import Tiedb from mydb import Meta import re import sys reload(sys) sys.setdefaultencoding('utf-8') mydb = Tiedb() meta = Meta() # for row in mydb.get_random_rows(100, "%gmail.com"): # print row # sys.exit(0) #print mydb.get_song_info("青花瓷","周杰伦")[0],mydb.get_song_info("青花瓷","周杰伦")[1],mydb.get_song_info("青花瓷","周杰伦")[2] csvfile = file('hanwen.csv', 'rb') reader = csv.reader(csvfile) index=0 index_error=0 index_full=0 for lrow in list(reader): index=index+1 print '处理前:',lrow[0].decode('gbk'),lrow[1].decode('gbk'),'index:',index try: song=lrow[0].decode('gbk').encode('UTF-8') song=re.sub('\(.*?\)|\[.*?]|{.*?}|(.*?)','',song)#去括号 song=song[0:len(song)/3]
import os import io from mydb import Meta from mutagen.mp3 import MP3 import mutagen.id3 from mutagen.easyid3 import EasyID3 import sys #sys.stdout = io.TextIOWrapper(sys.stdout.buffer,encoding='utf8')#改变标准输出的默认编码 reload(sys) sys.setdefaultencoding('utf-8') meta = Meta() index_match = 0 path = 'F:\\QQmusic\\320K\\waiting' #path='D:\\Kuwo_2_2' for file in os.listdir(path): if file.find('-') > 0: file_seg = file.split('-') song = file_seg[0].decode('gbk').encode('utf-8') artist = file_seg[1].decode('gbk').encode('utf-8') album = file_seg[2].split('.')[0].decode('gbk').encode('utf-8') try: mp3_path = song + '-' + artist + '.mp3' meta.insert_new(song, artist, album, mp3_path) #print album #meta.update_album_like(album,song,artist) #print index_match #newname=match[0]+' - '+match[1]+'.lrc' #os.rename(os.path.join(path,file),os.path.join(path+'\\match\\',newname)) #print match[0],match[1],index_match
#coding=utf-8 import PIL import random import csv import MySQLdb import sys from mydb import Tiedb from mydb import Meta import re import os from PIL import Image mydb = Tiedb() meta = Meta() path = '/home/pogo/meta_harvest/album/' # for row in mydb.get_random_rows(100, "%gmail.com"): # print row # sys.exit(0) #print mydb.get_song_info("青花瓷","周杰伦")[0],mydb.get_song_info("青花瓷","周杰伦")[1],mydb.get_song_info("青花瓷","周杰伦")[2] csvfile = file('meta_no_cover.csv', 'rb') reader = csv.reader(csvfile) index = 0 index_error = 0 index_full = 0 for lrow in list(reader): index = index + 1 #print '处理前:',lrow[0].decode('gbk'),lrow[1].decode('gbk'),'index:',index try: song = lrow[0].decode('gbk').encode('UTF-8') #song=re.sub('\(.*?\)|\[.*?]|{.*?}|(.*?)','',song)#去括号
#!-*- coding:utf8 -*- import os from mydb import Meta from mutagen.mp3 import MP3 import mutagen.id3 from mutagen.easyid3 import EasyID3 import sys reload(sys) sys.setdefaultencoding('utf-8') meta = Meta() index_match = 0 path = 'F:\\QQmusic\\320K' for file in os.listdir(path): if file.find('-') > 0: file_seg = file.split('-') song = file_seg[0].decode('gbk').encode('utf-8') artist = file_seg[1].split('.')[0].decode('gbk').encode('utf-8') try: index_match += 1 id3info = MP3(os.path.join(path, file), ID3=EasyID3) for k, v in id3info.items(): if k == 'album': album = '\n'.join(v) #meta.insert_new(song,artist,album) print album #meta.update_album_like(album,song,artist) #print album,index_match #newname=match[0]+' - '+match[1]+'.lrc' #os.rename(os.path.join(path,file),os.path.join(path+'\\match\\',newname)) #print match[0],match[1],index_match
import os import io from mydb import Meta from mutagen.mp3 import MP3 import mutagen.id3 from mutagen.easyid3 import EasyID3 import sys #sys.stdout = io.TextIOWrapper(sys.stdout.buffer,encoding='utf8')#改变标准输出的默认编码 reload(sys) sys.setdefaultencoding('utf-8') meta = Meta() index_match=0 path = 'F:\\QQmusic\\320K\\waiting' #path='D:\\Kuwo_2_2' for file in os.listdir(path): if file.find('-')>0: file_seg=file.split('-') song=file_seg[0].decode('gbk').encode('utf-8') artist=file_seg[1].decode('gbk').encode('utf-8') album=file_seg[2].split('.')[0].decode('gbk').encode('utf-8') try: mp3_path=song+'-'+artist+'.mp3' meta.insert_new(song,artist,album,mp3_path) #print album #meta.update_album_like(album,song,artist) #print index_match #newname=match[0]+' - '+match[1]+'.lrc' #os.rename(os.path.join(path,file),os.path.join(path+'\\match\\',newname))
#coding=utf-8 import PIL import random import csv import MySQLdb import sys from mydb import Tiedb from mydb import Meta import re import os from PIL import Image mydb = Tiedb() meta = Meta() path = '/home/pogo/meta_harvest/album/' # for row in mydb.get_random_rows(100, "%gmail.com"): # print row # sys.exit(0) #print mydb.get_song_info("青花瓷","周杰伦")[0],mydb.get_song_info("青花瓷","周杰伦")[1],mydb.get_song_info("青花瓷","周杰伦")[2] csvfile = file('meta_no_cover.csv', 'rb') reader = csv.reader(csvfile) index=0 index_error=0 index_full=0 for lrow in list(reader): index=index+1 #print '处理前:',lrow[0].decode('gbk'),lrow[1].decode('gbk'),'index:',index try:
#!-*- coding:utf8 -*- import os from mydb import Meta from mutagen.mp3 import MP3 import mutagen.id3 from mutagen.easyid3 import EasyID3 import sys reload(sys) sys.setdefaultencoding('utf-8') meta = Meta() index_match=0 path = 'F:\\QQmusic\\320K' for file in os.listdir(path): if file.find('-')>0: file_seg=file.split('-') song=file_seg[0].decode('gbk').encode('utf-8') artist=file_seg[1].split('.')[0].decode('gbk').encode('utf-8') try: match=meta.get_song_like(song,artist) if match: index_match+=1 id3info = MP3(os.path.join(path,file), ID3=EasyID3) for k, v in id3info.items(): if k=='album': album = ''.join(v) print album meta.update_album_like(album,song,artist) #print album,index_match #newname=match[0]+' - '+match[1]+'.lrc' #os.rename(os.path.join(path,file),os.path.join(path+'\\match\\',newname))
#coding=utf-8 import random import csv import MySQLdb import sys from mydb import Tiedb from mydb import Meta import re mydb = Tiedb() meta = Meta() # for row in mydb.get_random_rows(100, "%gmail.com"): # print row # sys.exit(0) #print mydb.get_song_info("青花瓷","周杰伦")[0],mydb.get_song_info("青花瓷","周杰伦")[1],mydb.get_song_info("青花瓷","周杰伦")[2] csvfile = file('meta_new_song.csv', 'rb') reader = csv.reader(csvfile) index=0 index_error=0 index_full=0 for lrow in list(reader): index=index+1 print '处理前:',lrow[0].decode('gbk'),index song_raw=lrow[0].decode('gbk').encode('UTF-8') song=re.sub('\(.*?\)|\[.*?]|{.*?}|(.*?)','',song_raw)#去括号 artist_raw=lrow[1].decode('gbk').encode('UTF-8') artist=re.sub('\(.*?\)|\[.*?]|{.*?}|(.*?)','',artist_raw)#去括号 try: #print '处理后:',song,artist #song_info=mydb.get_artist_xiami(song)
#coding=utf-8 import random import csv import MySQLdb import sys from mydb import Tiedb from mydb import Meta import re mydb = Tiedb() meta = Meta() # for row in mydb.get_random_rows(100, "%gmail.com"): # print row # sys.exit(0) #print mydb.get_song_info("青花瓷","周杰伦")[0],mydb.get_song_info("青花瓷","周杰伦")[1],mydb.get_song_info("青花瓷","周杰伦")[2] csvfile = file('meta_no_artist.csv', 'rb') reader = csv.reader(csvfile) index=0 index_error=0 index_full=0 for lrow in list(reader): index=index+1 print '处理前:',lrow[0].decode('gbk'),index song_raw=lrow[0].decode('gbk').encode('UTF-8') song=re.sub('\(.*?\)|\[.*?]|{.*?}|(.*?)','',song_raw)#去括号 try: print '处理后:',song song_info=mydb.get_artist_xiami(song) artist=song_info[0] print '处理后:',song,artist
#coding=utf-8 import random import csv import MySQLdb import sys from mydb import Tiedb from mydb import Meta import re mydb = Tiedb() meta = Meta() # for row in mydb.get_random_rows(100, "%gmail.com"): # print row # sys.exit(0) #print mydb.get_song_info("青花瓷","周杰伦")[0],mydb.get_song_info("青花瓷","周杰伦")[1],mydb.get_song_info("青花瓷","周杰伦")[2] csvfile = file('meta_no_artist.csv', 'rb') reader = csv.reader(csvfile) index = 0 index_error = 0 index_full = 0 for lrow in list(reader): index = index + 1 print '处理前:', lrow[0].decode('gbk'), index song_raw = lrow[0].decode('gbk').encode('UTF-8') song = re.sub('\(.*?\)|\[.*?]|{.*?}|(.*?)', '', song_raw) #去括号 try: print '处理后:', song song_info = mydb.get_artist_xiami(song) artist = song_info[0] print '处理后:', song, artist meta.update_artist_info(song, artist)
#!-*- coding:utf8 -*- import os from mydb import Meta from mutagen.mp3 import MP3 import mutagen.id3 from mutagen.easyid3 import EasyID3 import sys reload(sys) sys.setdefaultencoding('utf-8') meta = Meta() index_match = 0 path = 'F:\\QQmusic\\320K' for file in os.listdir(path): if file.find('-') > 0: file_seg = file.split('-') song = file_seg[0].decode('gbk').encode('utf-8') artist = file_seg[1].split('.')[0].decode('gbk').encode('utf-8') try: match = meta.get_song_like(song, artist) if match: index_match += 1 id3info = MP3(os.path.join(path, file), ID3=EasyID3) for k, v in id3info.items(): if k == 'album': album = ''.join(v) print album meta.update_album_like(album, song, artist) #print album,index_match #newname=match[0]+' - '+match[1]+'.lrc' #os.rename(os.path.join(path,file),os.path.join(path+'\\match\\',newname))
#coding=utf-8 import random import csv import MySQLdb import sys from mydb import Tiedb from mydb import Meta import re mydb = Tiedb() meta = Meta() # for row in mydb.get_random_rows(100, "%gmail.com"): # print row # sys.exit(0) #print mydb.get_song_info("青花瓷","周杰伦")[0],mydb.get_song_info("青花瓷","周杰伦")[1],mydb.get_song_info("青花瓷","周杰伦")[2] csvfile = file('meta_new_song.csv', 'rb') reader = csv.reader(csvfile) index = 0 index_error = 0 index_full = 0 for lrow in list(reader): index = index + 1 print '处理前:', lrow[0].decode('gbk'), index song_raw = lrow[0].decode('gbk').encode('UTF-8') song = re.sub('\(.*?\)|\[.*?]|{.*?}|(.*?)', '', song_raw) #去括号 artist_raw = lrow[1].decode('gbk').encode('UTF-8') artist = re.sub('\(.*?\)|\[.*?]|{.*?}|(.*?)', '', artist_raw) #去括号 try: #print '处理后:',song,artist #song_info=mydb.get_artist_xiami(song) #artist=song_info[0]
#coding=utf-8 import random import csv import MySQLdb import sys from mydb import Tiedb from mydb import Meta import re import sys reload(sys) sys.setdefaultencoding('utf-8') mydb = Tiedb() meta = Meta() # for row in mydb.get_random_rows(100, "%gmail.com"): # print row # sys.exit(0) #print mydb.get_song_info("青花瓷","周杰伦")[0],mydb.get_song_info("青花瓷","周杰伦")[1],mydb.get_song_info("青花瓷","周杰伦")[2] csvfile = file('hanwen.csv', 'rb') reader = csv.reader(csvfile) index = 0 index_error = 0 index_full = 0 for lrow in list(reader): index = index + 1 print '处理前:', lrow[0].decode('gbk'), lrow[1].decode('gbk'), 'index:', index try: song = lrow[0].decode('gbk').encode('UTF-8') song = re.sub('\(.*?\)|\[.*?]|{.*?}|(.*?)', '', song) #去括号 song = song[0:len(song) / 3]