#!/usr/bin/env python3
"""
Check current character data in database
"""

import asyncio
from sqlalchemy import select
from src.database.connection import init_database, get_db_session
from src.database.models import Character

async def check_character_data():
    """Check current character data"""
    
    await init_database()
    
    async with get_db_session() as session:
        # Get all characters
        characters_query = select(Character)
        characters = await session.scalars(characters_query)
        
        for character in characters:
            print(f"\n{'='*50}")
            print(f"Character: {character.name}")
            print(f"{'='*50}")
            print(f"Personality: {character.personality[:100] if character.personality else 'None'}{'...' if character.personality and len(character.personality) > 100 else ''}")
            print(f"Interests: {character.interests}")
            print(f"Speaking Style: {character.speaking_style}")
            print(f"Background: {character.background}")
            print(f"Is Active: {character.is_active}")
            print(f"\nSystem Prompt:")
            print("-" * 30)
            print(character.system_prompt if character.system_prompt else "None")
            print("-" * 30)

if __name__ == "__main__":
    asyncio.run(check_character_data())