如何在将数据编入JSON之前将数据从SQLite数据库读入字典？

I am a beginner at python and using SQLite. So please be patient with me. I am not entirely sure how much information i should provide, so i have decided on putting up as much code as i think is related. Like the saying goes; better safe than sorry. I am a beginner at python and using SQLite. So