import sys
import codecs
sys.stdout = codecs.getwriter('utf-8')(sys.stdout)
from sqlite3 import dbapi2 as sqlite
import re

#lex = sqlite.connect('/home/pat/lang/de/lexicon.db')
lex = sqlite.connect('/home/pat/lex/lex/lexicon.db')
lex = lex.cursor()

code = sys.argv[1]
c = lex.execute('select distinct sourceterm, targetterm from lexicon where sourcecode = ? or targetcode = ? order by distinct', (code,code)) 

words = []

def good(term):
    return \
        ':' not in term \
        and \
        not re.match('.*[0-9].*', term) 

for code1, term1, code2, term2 in c:
    if code1 == code:
        term = term1
    elif code2 == code:
        term = term2
    if good(term):
        #words.append(term)
        print term