def get_book_by_page_id(page_id):
page = m.Page.query.get(page_id)
path = m.Path.query.get(page.path_id)
book = m.Book.query.get(path.book_id)
data, err = m.BookSchema().dump(book)
if not err:
return data
def get_books_by_user(user_id):
books = m.Book.query.filter(m.Book.is_deleted.is_(False)).filter(
m.Book.editors.any(id=user_id)).all()
data, err = m.BookSchema().dump(books, many=True)
print(data)
if not err:
return data
def get_book_by_path_id(path_id):
path = m.Path.query.get(path_id)
print(path.book_id, end=" book id \n")
book = m.Book.query.get(path.book_id)
data, err = m.BookSchema().dump(book)
if not err:
print(err)
return data
def create_book(book_raw, user_id):
book_schema = m.BookSchema()
book_data, _err = book_schema.load(book_raw)
book = m.Book()
book.title = book_data['title']
book.description = book_data['description']
book.cover = book_data['cover']
book.editors.append(m.User.query.get(user_id))
if _err:
return None
else:
m.db.session.add(book)
m.db.session.commit()
# book_dump = book_schema.dump(book)
return book
def get_public_books():
books = m.Book.query.filter(
m.Book.is_deleted.is_(False)).filter(m.Book.status == 'public').all()
data = m.BookSchema().dump(books, many=True)
return data
def get_book_by_id(book_id):
book = m.Book.query.get(book_id)
data, err = m.BookSchema().dump(book)
if not err:
print(err)
return data