keyvault-api / src /models /product.py
hashir-qt's picture
Upload folder using huggingface_hub
e656014 verified
Raw History Blame Contribute Delete
2.86 kB
import uuid
from datetime import datetime, timezone
from enum import Enum
from typing import List, Optional
from sqlalchemy import Column, DateTime, JSON
from sqlmodel import Field, SQLModel
class ProductCategory(str, Enum):
"""Type/category of the digital product."""
GAME_KEY = "game_key"
GIFT_CARD = "gift_card"
SUBSCRIPTION = "subscription"
IN_GAME_CURRENCY = "in_game_currency"
class ProductStatus(str, Enum):
"""Visibility/availability status of a product listing."""
ACTIVE = "active"
INACTIVE = "inactive"
OUT_OF_STOCK = "out_of_stock"
class ProductListing(SQLModel, table=True):
"""A product listed for sale by a seller."""
__tablename__ = "product_listings"
id: str = Field(
default_factory=lambda: str(uuid.uuid4()),
primary_key=True,
)
seller_id: str = Field(foreign_key="seller_profiles.id", index=True)
title: str = Field(index=True)
description: str
price: float # USD sale price
original_price: Optional[float] = Field(default=None) # for strikethrough display
platform: str # Steam, PlayStation, Xbox, Nintendo, PC, Other
region: str = Field(default="Global") # Global, US, EU, ASIA, etc.
category: ProductCategory
image_url: Optional[str] = Field(default=None)
activation_steps: Optional[List[str]] = Field(
default=None,
sa_column=Column(JSON, nullable=True),
)
is_flash_deal: bool = Field(default=False)
status: ProductStatus = Field(default=ProductStatus.ACTIVE)
stock_count: int = Field(default=0)
total_sold: int = Field(default=0)
created_at: datetime = Field(
default_factory=lambda: datetime.now(timezone.utc),
sa_column=Column(DateTime(timezone=True), nullable=False),
)
updated_at: datetime = Field(
default_factory=lambda: datetime.now(timezone.utc),
sa_column=Column(DateTime(timezone=True), nullable=False),
)
class ProductKey(SQLModel, table=True):
"""An individual encrypted product/game key attached to a listing."""
__tablename__ = "product_keys"
id: str = Field(
default_factory=lambda: str(uuid.uuid4()),
primary_key=True,
)
product_id: str = Field(foreign_key="product_listings.id", index=True)
encrypted_key: str # Fernet-encrypted raw key
is_sold: bool = Field(default=False)
sold_at: Optional[datetime] = Field(
default=None,
sa_column=Column(DateTime(timezone=True), nullable=True),
)
order_item_id: Optional[str] = Field(default=None) # FK to order_items (Phase 4)
created_at: datetime = Field(
default_factory=lambda: datetime.now(timezone.utc),
sa_column=Column(DateTime(timezone=True), nullable=False),
)