keyvault-api / src /models /order.py
hashir-qt's picture
Upload folder using huggingface_hub
e656014 verified
Raw History Blame Contribute Delete
1.56 kB
"""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