from app.db.session import SessionLocal
from app.models.user import User
from app.models.product import Product, Category
from app.models.item import Item
from app.models.order import CartItem, Order, OrderItem
from app.models.email_verification import EmailVerification

db = SessionLocal()
try:
    cart_items = db.query(CartItem).all()
    print(f"Cart Items Count: {len(cart_items)}")
    for item in cart_items:
        print(f"User ID: {item.user_id}, Product ID: {item.product_id}, Qty: {item.quantity}")
except Exception as e:
    print(f"Error: {e}")
finally:
    db.close()