[PYTHON] [MEMO] Read File, Converting, Insert to DB

from contextlib import closing
import sqlite3

dbname = 'moji.db'
def method():
    with open('text.txt', 'r') as f1, open('sss.txt', 'r') as f2, closing(sqlite3.connect(dbname)) as conn:
        c = conn.cursor()
        create_table = 'create table moji(unicode int, sjis int, jis int, width int, height int, contents text)'
        c.execute(create_table)
        sql = 'insert into moji values(?,?,?,?,?,?)'
        while True:
            f1line = f1.readline()
            f2line = f2.readline()
            a = f1line.split(',')
            b = f2line.split(',')
            a0 = a[0]
            a1 = a[1]
            a2 = a[2]
            
            b0 = b[0]
            b1 = b[1]
            b2 = b[2]
            
            width = 16
            height = 16
            contents = f1line[-160:]
            jis = int(b1,16)
            unicode = int(b2,16)
            sjis = int(b0,16)
            moji = (unicode, sjis, jis, width, height, contents)
            c.execute(sql, moji)
            conn.commit()
            if(jis != int(a1, 16)):
                print(jis)
                break