import cgi
import MySQLdb

db = MySQLdb.connect(host="localhost", user="root", passwd="", db="lex")
cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor)


def addtrans():
    query = """insert into lex ("source_code", target_code, source_term, target_term) values (en, pt, House, Casa)"""
    cursor.execute(query)

sample = "en" + "pt House Casa".split()

c.executemany(

)