from app.core.database import SessionLocal
from app.models.website import WebsiteContent

db = SessionLocal()
content_count = db.query(WebsiteContent).filter(WebsiteContent.website_id == 8).count()
print(f'Content records for website 8: {content_count}')

if content_count > 0:
    contents = db.query(WebsiteContent).filter(WebsiteContent.website_id == 8).all()
    for c in contents:
        print(f"\nURL: {c.page_url}")
        print(f"Length: {len(c.content)}")
        print(f"Preview: {c.content[:100]}...")
else:
    print('No content found for website 8')

db.close()