Subversion Repositories navi

Rev

Rev 138 | Rev 143 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
46 szabot 1
#!/usr/bin/python
2
# -*- coding: utf-8 -*-
3
 
4
import tornado.database
5
import re
6
 
7
def getnavilist():
8
    ret = []
9
    current = u""
10
    db = tornado.database.Connection("127.0.0.1", "navi", user="navi", password="navi")
11
    for row in db.query("""
103 szabot 12
    SELECT *
46 szabot 13
    FROM `metaWords`
103 szabot 14
    WHERE partOfSpeech <> 'num.' AND partOfSpeech <> "prefix"
15
    ORDER BY CHAR_LENGTH(navi) DESC"""):
65 szabot 16
        if row["infixes"]:
89 szabot 17
            ret.append({"id": row["id"], "navi": row["navi"], "infix": row["infixes"].lower(), "type": row["partOfSpeech"]})
65 szabot 18
        else:
89 szabot 19
            ret.append({"id": row["id"], "navi": row["navi"], "infix": row["navi"].lower(), "type": row["partOfSpeech"]})
46 szabot 20
    db.close()
21
    return ret
22
 
23
def getnavi(word):
24
    ret = []
25
    db = tornado.database.Connection("127.0.0.1", "navi", user="navi", password="navi")
26
    for row in db.query("""
27
    SELECT *
28
    FROM `metaWords`
29
    WHERE navi = ?""",word):
65 szabot 30
        if row["infixes"]:
89 szabot 31
            ret.append({"id": row["id"], "navi": row["navi"], "infix": row["infixes"].lower(), "type": row["partOfSpeech"]})
65 szabot 32
        else:
89 szabot 33
            ret.append({"id": row["id"], "navi": row["navi"], "infix": row["navi"].lower(), "type": row["partOfSpeech"]})
46 szabot 34
    db.close()
136 muzer 35
    return ret
36
 
137 muzer 37
def translate(id,language):
136 muzer 38
    db = tornado.database.Connection("127.0.0.1", "navi", user="navi", password="navi")
39
    for row in db.query("""
40
    SELECT *
41
    FROM `localizedWords`
139 szabot 42
    WHERE id = ? AND languageCode = ?""",id,language):
136 muzer 43
        ret = row["localized"]
139 szabot 44
        break
136 muzer 45
    db.close()
46
    return ret