#!/usr/bin/env python
# -*- coding: utf-8 -*-
import MySQLdb
import sys
import codecs
from BeautifulSoup import UnicodeDammit
#sys.stdout = codecs.getwriter('utf-8')(sys.stdout)
#sys.stdin = codecs.getreader('utf-8')(sys.stdin)

db = MySQLdb.connect(host="localhost", user="root", passwd="", db="lex", )

c = db.cursor()

if __name__ == "__main__":

    query = sys.argv[1]
    source_code, target_code, source_term =  query.split('/')
    
    sql = """select * from lex where 
            source_code = %s 
            and target_code = %s 
            and source_term like %s"""

    source_term = source_term.replace('*','%%')

    c.execute(sql, (source_code, target_code, source_term))

    for sc, st, tc, tt in c:
        row = "%s\n%s\n\n" % (st,tt)
        urow = UnicodeDammit(row).unicode
        sys.stdout.write(row)