"""Order and OrderItem SQLModel table definitions.""" import uuid from datetime import datetime, timezone from enum import Enum from sqlalchemy import Column, DateTime from sqlmodel import Field, SQLModel class OrderStatus(str, Enum): """Lifecycle status of an order.""" PENDING = "pending" COMPLETED = "completed" REFUNDED = "refunded" class Order(SQLModel, table=True): """A completed purchase transaction by a buyer.""" __tablename__ = "orders" id: str = Field( default_factory=lambda: "ORD-" + uuid.uuid4().hex[:8].upper(), primary_key=True, ) buyer_id: str = Field(foreign_key="users.id", index=True) total_price: float platform_fee: float = Field(default=0.49) payment_method: str status: OrderStatus = Field(default=OrderStatus.COMPLETED) created_at: datetime = Field( default_factory=lambda: datetime.now(timezone.utc), sa_column=Column(DateTime(timezone=True), nullable=False), ) class OrderItem(SQLModel, table=True): """A single line item within an order (one key per item).""" __tablename__ = "order_items" id: str = Field( default_factory=lambda: str(uuid.uuid4()), primary_key=True, ) order_id: str = Field(foreign_key="orders.id", index=True) product_id: str = Field(foreign_key="product_listings.id") product_key_id: str = Field(foreign_key="product_keys.id") price_at_purchase: float title_at_purchase: str platform_at_purchase: str