def get_All_Books(self, Testament_Id): self.Testament_Id = Testament_Id sql_query=("SELECT * FROM BOOK WHERE id in(SELECT BOOK FROM CONTENT WHERE TESTAMENT='%s' and id in(SELECT CONTENTID FROM FILE))")\ %self.Testament_Id cursor.execute(sql_query) books = cursor.fetchall() book = [] for items in books: hydrate_book = Module.Book() hydrate_book.hydrate(items) book.append(hydrate_book) return book