Spaces:
Sleeping
Sleeping
File size: 1,564 Bytes
e656014 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 | """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
|