# To load with python interpreter

import msgpack
import ui

import sqlite3

with open('result_all.pack', 'rb') as f:
    r = f.read()

d = p = msgpack.unpackb(r, raw=False)
del r

with sqlite3.connect("result_all.sql") as con:
    cur = con.cursor()
    cur.execute('''CREATE TABLE IF NOT EXISTS entry (
        word TEXT,
        cat_gram TEXT,
        API TEXT,
        infos TEXT,
        genre TEXT,
        accord TEXT,
        defs BLOG,
        ID INTEGER PRIMARY KEY)''')
    con.commit()

    for w, listW in d.items():
        for word in listW:
            data = (w, word['cat-gram'], word['API'], "\t".join(word['infos']),
                    word['genre'], word['accord'],
                    msgpack.packb(word['def']))
            cur.execute('''INSERT INTO entry (word, cat_gram, API, infos,
            genre, accord, defs) VALUES (?, ?, ?, ?,  ?, ?,  ?)''', data)
    con.commit()


def give_def(w):
    ui.show_terminal(d[w])