def findById(self, id): db = self.learnXdB.openDataBase() c = db.cursor() t = (id,) c.execute("Select * From Languages Where id = ?", t) language = None for row in c: language = Language( row[1], row[2], posOptions=row[3], id=row[0], total=row[4], learnt=row[5], known=row[6], mature=row[7] ) if language.posOptions: language.posOptions = pickle.loads(str(language.posOptions)) db.commit() c.close() return language
def list(self): db = self.learnXdB.openDataBase() c = db.cursor() c.execute("select * from Languages") languages = [] for row in c: language = Language( row[1], row[2], posOptions=row[3], id=row[0], total=row[4], learnt=row[5], known=row[6], mature=row[7] ) if language.posOptions: language.posOptions = pickle.loads(str(language.posOptions)) languages.append(language) c.close() return languages