| 20,26 → 20,12 |
|---|
| db.close() |
| return ret |
| |
| def getnavi(word): |
| ret = [] |
| db = tornado.database.Connection("127.0.0.1", "navi", user="navi", password="navi") |
| for row in db.query(""" |
| SELECT * |
| FROM `metaWords` |
| WHERE navi = ?""",word): |
| if row["infixes"]: |
| ret.append({"id": row["id"], "navi": row["navi"], "infix": row["infixes"].lower(), "type": row["partOfSpeech"]}) |
| else: |
| ret.append({"id": row["id"], "navi": row["navi"], "infix": row["navi"].lower(), "type": row["partOfSpeech"]}) |
| db.close() |
| return ret |
| |
| def translate(wid,language): |
| db = tornado.database.Connection("127.0.0.1", "navi", user="navi", password="navi") |
| for row in db.query(""" |
| SELECT * |
| FROM `localizedWords` |
| WHERE (id = ?) AND (languageCode = ?)""",int(wid),language): |
| WHERE (id = ?) AND (languageCode = ?)""",(wid,language)): |
| ret = row["localized"] |
| break |
| db.close() |