Rev 246 | Rev 259 | 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 -*- |
||
176 | muzer | 3 | # This file is part of Tsim Apiak. |
4 | # |
||
5 | # Tsim Apiak is free software: you can redistribute it and/or modify |
||
6 | # it under the terms of the GNU General Public Licence as published by |
||
7 | # the Free Software Foundation, either version 3 of the Licence, or |
||
8 | # (at your option) any later version. |
||
9 | # |
||
10 | # In addition to this, you must also comply with clause 4 of the |
||
11 | # Apache Licence, version 2.0, concerning attribution. Where there |
||
12 | # is a contradiction between the two licences, the GPL |
||
13 | # takes preference. |
||
14 | # |
||
186 | szabot | 15 | # Tsim Apiak is distributed in the hope that it will be useful, |
176 | muzer | 16 | # but WITHOUT ANY WARRANTY; without even the implied warranty of |
17 | # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
||
18 | # GNU General Public License for more details. |
||
19 | # |
||
20 | # You should have received a copy of the GNU General Public License |
||
21 | # along with Tsim Apiak. If not, see <http://www.gnu.org/licenses/>. |
||
46 | szabot | 22 | |
176 | muzer | 23 | |
46 | szabot | 24 | import tornado.database |
25 | |||
26 | def getnavilist(): |
||
27 | ret = [] |
||
28 | db = tornado.database.Connection("127.0.0.1", "navi", user="navi", password="navi") |
||
29 | for row in db.query(""" |
||
103 | szabot | 30 | SELECT * |
46 | szabot | 31 | FROM `metaWords` |
257 | muzer | 32 | WHERE partOfSpeech <> 'num.' |
103 | szabot | 33 | ORDER BY CHAR_LENGTH(navi) DESC"""): |
65 | szabot | 34 | if row["infixes"]: |
89 | szabot | 35 | ret.append({"id": row["id"], "navi": row["navi"], "infix": row["infixes"].lower(), "type": row["partOfSpeech"]}) |
65 | szabot | 36 | else: |
89 | szabot | 37 | ret.append({"id": row["id"], "navi": row["navi"], "infix": row["navi"].lower(), "type": row["partOfSpeech"]}) |
46 | szabot | 38 | db.close() |
39 | return ret |
||
40 | |||
246 | szabot | 41 | def translate(wid, language): |
235 | muzer | 42 | ret = None |
136 | muzer | 43 | db = tornado.database.Connection("127.0.0.1", "navi", user="navi", password="navi") |
44 | for row in db.query(""" |
||
45 | SELECT * |
||
46 | FROM `localizedWords` |
||
246 | szabot | 47 | WHERE id = %s AND languageCode = %s""", wid, language): |
136 | muzer | 48 | ret = row["localized"] |
139 | szabot | 49 | break |
235 | muzer | 50 | if ret == None: |
51 | return u"ERROR: WORD NOT LOCALISED" |
||
136 | muzer | 52 | db.close() |
176 | muzer | 53 | return ret |