from flask_sqlalchemy import SQLAlchemy
from models import db, LastPlay, Users, Books  # Импортируем необходимые модели
from datetime import datetime

class BooksModel:
    def __init__(self, app):
        self.db = db
        self.db.init_app(app)  # Инициализируем db с приложением
        
        with app.app_context():
            self.db.create_all()
            
        self.session = self.db.session

    def getAllBooks(self):
        try:
            books = self.session.query(Books).all()  # Используем Books из импорта
            return books
        except Exception as e:
            print(f"Error fetching books: {e}")
            return None