#!/usr/bin/python2.3
# -*- coding: utf-8 -*-
import MySQLdb
db = MySQLdb.connect(host="localhost", user="root", passwd="", db="hmm", use_unicode=True)

c = db.cursor()

lexicon = open('lexicon.txt').read().decode('utf-8').splitlines()

lexicon = [line.split() for line in lexicon]

insertion = u"""
    INSERT INTO hmm 
        (source_code, target_code, source_term, target_term ) 
    VALUES 
        (%s, %s, %s, %s);""".encode('utf-8')

#c.execute(insertion, ["en", "pt", "Brazil", "Brasil"])

c.executemany(insertion, lexicon) 

db.commit()

c.execute("""select * from hmm""")

for sc, tc, st, tt in c:
    print sc, tc, st, tt