本文實例講述了python自動翻譯實作方法。分享給大家供大家參考,具體如下:
以前學過python的基礎,一般也沒用過。後來有一個參數表需要中英文。想了一下,還是用python來做吧。呼叫的百度翻譯接口,經歷了亂碼、模組不全等問題。一般google,一邊做的。分享一下。
#encoding=utf-8 ## eagle_91@sina.com ## created 2014-07-22 import urllib import urllib2 import MySQLdb import json import gc import time url = 'http://openapi.baidu.com/public/2.0/bmt/translate' _sleepTime = 0.5 _limit = 1000 ## 链接mysql conn = MySQLdb.connect(host='localhost',user='root',passwd='',charset='utf8') curs = conn.cursor() conn.select_db('test') ## 搜索要操作的表 count=curs.execute("""SELECT * FROM sb_parameters WHERE ISNULL(en_name) ORDER BY id ASC""") ## print curs.fetchall() ## print count results = curs.fetchmany(_limit) for r in results: gc.collect() chin = unicode(r[3]).encode('utf-8') ## print chin values = {'client_id':'PWrGllvVAIFcD0sYqaipwkAV','q':chin,'from':'zh','to':'en'} data = urllib.urlencode(values) req = urllib2.Request(url, data) response = urllib2.urlopen(req) the_page = response.read() returnData = json.loads(the_page) ## print returnData if returnData.has_key("error_code"): continue; inputData = returnData["trans_result"][0]["dst"] try: sql = "UPDATE `sb_parameters` SET `en_name`='%s' WHERE `id` = %d" % (MySQLdb.escape_string(unicode(inputData).encode('utf-8')),r[0]) print sql curs.execute(sql) conn.commit() time.sleep(_sleepTime) except EOFError: sql = "UPDATE `sb_parameters` SET `en_name`='%s' WHERE `id` = %d" % ('',r[0]) print sql curs.execute(sql) conn.commit() continue conn.commit() ## 关闭链接 curs.close() ## 关闭数据库 conn.close()
更多python自動翻譯實作相關文章請關注PHP中文網!
#