def update_location_actions():
from re import escape
location = Location()
db = Database()
t = BingTranslate()
cmd = "SELECT * FROM location"
location_res = db.query_db(cmd)
for item in location_res:
location_id, location_name, location_chinese = item
for action in location.get_action_for_venue(location_chinese):
cmd = u"SELECT * FROM action WHERE chinese_name = '%s'" % (action)
action_res = db.query_db(cmd)
if len(action_res) > 0:
action_id = action_res[0][0]
is_bad = action_res[0][3]
else:
action_en = t.translate(action, "zh-CHT", "en")
cmd = (
u"INSERT INTO action (chinese_name, english_name) \
VALUES ('%s', '%s')"
% (escape(action), escape(action_en))
)
db.query_db(cmd)
cmd = u"SELECT * FROM action WHERE chinese_name = '%s'" % (action)
action_res = db.query_db(cmd)
action_id = action_res[0][0]
is_bad = action_res[0][3]
if is_bad != 1:
cmd = (
"INSERT INTO location_action (location_id, action_id) \
VALUES (%s, %s)"
% (location_id, action_id)
)
db.query_db(cmd)
def update_concept_english():
db = Database()
t = BingTranslate()
cmd = "SELECT * FROM concept"
concept_res = db.query_db(cmd)
for concept in concept_res[90835:]:
concept_id = concept[0]
concept_name = concept[1]
english = t.translate(concept_name, "zh-CHT", "en").lower()
print english.encode("utf-8")
cmd = 'UPDATE concept SET english = "%s" WHERE id = %s' % (english, concept_id)
db.query_db(cmd)
