"""
Item 数据模型
"""
from tortoise.models import Model
from tortoise import fields
from datetime import datetime

class Item(Model):
    """物品模型"""
    
    id = fields.IntField(pk=True, description="主键ID")
    name = fields.CharField(max_length=100, description="名称")
    description = fields.TextField(null=True, description="描述")
    price = fields.DecimalField(max_digits=10, decimal_places=2, default=0.00, description="价格")
    is_active = fields.BooleanField(default=True, description="是否激活")
    
    # 关联用户（可选）
    owner = fields.ForeignKeyField(
        "models.User", 
        related_name="items",
        null=True,
        on_delete=fields.SET_NULL,
        description="所有者"
    )
    
    # 时间戳
    created_at = fields.DatetimeField(auto_now_add=True, description="创建时间")
    updated_at = fields.DatetimeField(auto_now=True, description="更新时间")
    
    def __str__(self):
        return f"Item(id={self.id}, name={self.name}, price={self.price})"
    
    class Meta:
        table = "items"
        table_description = "物品表"
        ordering = ["-created_at"]
        
    class PydanticMeta:
        # Pydantic 模型配置
        exclude = ["is_active"]