get_chars_and_lemmas.py

import sqlite3


def dict_factory(cursor, row):
    d = {}
    for idx, col in enumerate(cursor.description):
        d[col[0]] = row[idx]
    return d


db = sqlite3.connect("databases/japanese.db")
db.row_factory = dict_factory


def get_char_info(char, db):
    cur = db.cursor()
    query = "SELECT * FROM kanji INNER JOIN kanji_meanings ON kanji.kanji=kanji_meanings.kanji WHERE kanji.kanji=?"
    cur.execute(query, [char])
    result = cur.fetchone()
    query = "SELECT * FROM lemmas WHERE lemma LIKE ? ORDER BY frequency DESC"
    cur.execute(query, ['%{}%'.format(x) for x in [char]])
    result['lemmas'] = list(cur)
    cur.close()
    return result

_ = get_char_info("田", db)
print(_)

db.close()