| 8,8 → 8,9 |
|---|
| import tornado.database |
| |
| import os |
| import re |
| |
| from navi.parsenum import parse |
| from tsimapiak.parsenum import parse |
| |
| class Index(tornado.web.RequestHandler): |
| def get(self): |
| 33,12 → 34,36 |
|---|
| def get(self): |
| os.system("/usr/bin/restartnavi") |
| |
| def clear(s): |
| s = s.replace(ur"ɛ",ur"e").replace(ur".",ur"").replace(ur"ɾ",ur"r") \ |
| .replace(ur"ɪ",ur"ì").replace(ur"ˈ",ur"").replace(ur"'",ur"x") \ |
| .replace(ur"ŋ",ur"ng").replace(ur"j",ur"y").replace(ur"ʔ",ur"'") \ |
| .replace(ur"æ",ur"ä").replace(ur"ˌ",ur"").replace(ur"\t{ts}",ur"ts") \ |
| .replace(ur"ṛ",ur"rr").replace(ur"ḷ",ur"ll").replace(ur"k̚",ur"k ") \ |
| .replace(ur"p̚",ur"p ").replace(ur"t̚",ur"t ").replace(ur"'̚",ur"' ") \ |
| .replace(u"\\",ur"").replace(ur"(",ur"").replace(ur")",ur"") \ |
| .replace(ur"[",ur"").replace(ur"]",ur"").replace(ur" "," ") \ |
| .replace(ur"$cdot$",ur"[^ ]*").strip() |
| s = re.sub(ur" or.*","",s) |
| s = re.sub(ur"z(.*)engk(.*)e",ur"z\1enk\2e",s) |
| s = re.sub(ur"t(.*)ì(m|n)\ ",ur"t\1ìng ",s) |
| return s |
| |
| class TestDB(tornado.web.RequestHandler): |
| def get(self): |
| text = "" |
| text = u"" |
| current = u"" |
| db = tornado.database.Connection("127.0.0.1", "navi", user="navi", password="navi") |
| for thing in db.query("SELECT * FROM test"): |
| text = "<br />".join((text, str(thing.id) + " - " + thing.asd)) |
| for thing in db.query(""" |
| SELECT *, CHAR_LENGTH(navi) AS NL |
| FROM `metaWords` |
| ORDER BY NL DESC"""): |
| if thing["partOfSpeech"] in (u"v.", u"vin.", u"vtr."): |
| current = clear(unicode(thing["ipa"])) |
| else: |
| current = unicode(thing["navi"]) |
| current = u" ".join([ur"[^ ]*"+x+ur"[^ ]*" for x in re.split(ur" (?=[^\]])",current)]) |
| text += current + u"<br />" |
| self.write(text) |
| |
| application = tornado.web.Application([ |