Python Meta示例，mydb.Meta Python示例

示例#1

0

显示文件

文件： no_company.py 项目： wblyy/Music_MetaGrabber

#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)#去括号

示例#2

0

显示文件

文件： sorting_kuwo.py 项目： qgzang/Music_MetaGrabber

#!-*- 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

示例#3

0

显示文件

文件： no_company.py 项目： qgzang/Music_MetaGrabber

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

示例#4

0

显示文件

文件： no_lyric.py 项目： wblyy/Music_MetaGrabber

#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]

示例#5

0

显示文件

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

示例#6

0

显示文件

#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)#去括号

示例#7

0

显示文件

#!-*- 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

示例#8

0

显示文件

文件： inserting_new.py 项目： wblyy/Music_MetaGrabber

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

示例#9

0

显示文件

文件： update_cover_by_conpany.py 项目： wblyy/Music_MetaGrabber

#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:

示例#10

0

显示文件

文件： ID3.py 项目： wblyy/Music_MetaGrabber

#!-*- 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))

示例#11

0

显示文件

文件： new_song.py 项目： wblyy/Music_MetaGrabber

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

示例#12

0

显示文件

文件： no_artist.py 项目： wblyy/Music_MetaGrabber

#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

示例#13

0

显示文件

文件： no_artist.py 项目： qgzang/Music_MetaGrabber

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

示例#14

0

显示文件

文件： ID3.py 项目： qgzang/Music_MetaGrabber

#!-*- 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))

示例#15

0

显示文件

#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]

示例#16

0

显示文件

文件： no_lyric.py 项目： qgzang/Music_MetaGrabber

#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]