def saveToDB(down_from):
db=getDB()
c=db.cursor()
filename = download.getFileName(down_from)
content = getContent("lyrics/"+filename)
if content is None:
print filename+" not exist!"
else:
content = converFromGB2312ToUTF8(content)
if content.lower().find('</html>') != -1:
content = None
os.remove("lyrics/"+filename)
down_from = converFromGB2312ToUTF8(down_from)
try:
sql = ""
if content is None:
sql = "INSERT INTO `lyrics_error`(`down_from`) values ('"+db.escape_string(down_from)+"')"
else:
sql = "INSERT INTO `lyrics`(`lyric`, `down_from`) values ('"+db.escape_string(content)+"', '"+db.escape_string(down_from)+"')"
#print sql
c.execute(sql)
db.commit()
except:
pass
def extractMetaData(down_from, lyric):
filename = download.getFileName(down_from)
filename = filename[0:filename.rfind('.')]
singer = filename[(filename.rfind('-')+1):len(filename)]
title = filename[0:filename.rfind('-')]
album = extractAlbum(down_from, lyric)
return title, singer, album
