def load_stories(self): db = sqlite3.connect('model/news.db') c = db.cursor() c.execute("SELECT id,title,date,category,story FROM news") news_table = c.fetchall() for story in news_table: c.execute("SELECT id,source,url,headline,story FROM sources WHERE id=?", [story[0]]) story_sources = c.fetchall() sources = [] for source in story_sources: sources.append(Source(source[1],source[2],source[3],source[4])) s = Story() s.id = story[0] s.title = story[1] s.date = story[2] s.category = story[3] s.story = story[4] s.sources = sources self.stories.append(s) c.close()