#!/usr/bin/env python3
"""Test image URL issue"""

import asyncio
from sqlalchemy import select
from app.core.database import AsyncSessionLocal
from app.models.products_master import ProductMaster

async def test_image_issue():
    async with AsyncSessionLocal() as db:
        # Find products with broken main_image_path
        stmt = select(ProductMaster).where(ProductMaster.main_image_path == '[').limit(3)
        result = await db.execute(stmt)
        products = result.scalars().all()
        
        print(f"找到 {len(products)} 个main_image_path为'['的产品\n")
        
        for product in products:
            print(f"产品ID: {product.id}")
            print(f"  品牌: {product.品牌}")
            print(f"  货号: {product.货号}")
            print(f"  main_image_path: '{product.main_image_path}'")
            print(f"  original_image_urls类型: {type(product.original_image_urls)}")
            print(f"  original_image_urls值: {product.original_image_urls}")
            
            # Check if original_image_urls is valid
            if product.original_image_urls:
                if isinstance(product.original_image_urls, list) and len(product.original_image_urls) > 0:
                    first_url = product.original_image_urls[0]
                    print(f"  第一个URL: {first_url}")
                    print(f"  应该设置main_image_path为: {first_url}")
                elif isinstance(product.original_image_urls, str):
                    print(f"  original_image_urls是字符串: {product.original_image_urls}")
            print()

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