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
