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