import sqlite3


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


def main():
    conn = sqlite3.connect(":memory:")
    cur = conn.cursor()
    # conn.row_factory = sqlite3.Row # is ok
    conn.row_factory = dict_factory # is fail
    cur.executescript("""    
        create table if not exists test(
            id integer primary key AUTOINCREMENT
        );
    """)
    cur.close()
    for line in conn.iterdump():
        print(line)


main()