080-python-backend

🐍 PYTHON/FASTAPI — TRADING TERMINAL BACKEND

CONFIGURACIÓN DEL PROYECTO PYTHON

Estructura de dependencias:

requirements.txt          ← Producción
requirements-dev.txt      ← Solo desarrollo

# requirements.txt
fastapi==0.111.0
uvicorn[standard]==0.29.0
sqlalchemy[asyncio]==2.0.29
asyncpg==0.29.0
alembic==1.13.1
pydantic==2.7.1
pydantic-settings==2.2.1
python-jose[cryptography]==3.3.0
passlib[bcrypt]==1.7.4
redis[asyncio]==5.0.4
httpx==0.27.0
structlog==24.1.0
python-binance==1.0.19
slowapi==0.1.9

# requirements-dev.txt
pytest==8.1.1
pytest-asyncio==0.23.6
pytest-cov==5.0.0
black==24.4.2
ruff==0.4.2
mypy==1.10.0

---

⚙️ CONFIGURACIÓN (Settings Pattern)

# core/config.py — PATRÓN OBLIGATORIO

from pydantic_settings import BaseSettings
from pydantic import validator
from typing import Optional

class Settings(BaseSettings):
    """
    Todas las configuraciones vienen de variables de entorno.
    Nunca valores hardcodeados aquí.
    """
    # Base de datos
    DATABASE_URL: str
    REDIS_URL: str = "redis://localhost:6379/0"

    # Seguridad
    SECRET_KEY: str
    JWT_ALGORITHM: str = "HS256"
    JWT_EXPIRE_MINUTES: int = 60

    # APIs de Trading
    BINANCE_API_KEY: Optional[str] = None
    BINANCE_API_SECRET: Optional[str] = None
    MT5_LOGIN: Optional[str] = None
    MT5_PASSWORD: Optional[str] = None
    MT5_SERVER: Optional[str] = None

    # App
    ENVIRONMENT: str = "development"
    DEBUG: bool = False
    ALLOWED_ORIGINS: str = "http://localhost:5173"

    @validator('SECRET_KEY')
    def secret_key_must_be_strong(cls, v):
        if len(v) < 32:
            raise ValueError('SECRET_KEY debe tener al menos 32 caracteres')
        return v

    class Config:
        env_file = ".env"
        case_sensitive = True

settings = Settings()  # Singleton — importar este objeto

---

🗄️ MODELOS DE BASE DE DATOS

# models/order.py — SQLAlchemy async

from sqlalchemy import Column, String, Numeric, Enum, DateTime, ForeignKey
from sqlalchemy.dialects.postgresql import UUID
from sqlalchemy.orm import relationship
from datetime import datetime
import uuid
import enum

from core.database import Base

class OrderStatus(str, enum.Enum):
    PENDING = "pending"
    OPEN = "open"
    FILLED = "filled"
    CANCELLED = "cancelled"
    REJECTED = "rejected"

class Order(Base):
    __tablename__ = "orders"

    id = Column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4)
    user_id = Column(UUID(as_uuid=True), ForeignKey("users.id"), nullable=False)

    symbol = Column(String(20), nullable=False, index=True)
    side = Column(String(4), nullable=False)          # BUY / SELL
    order_type = Column(String(20), nullable=False)   # MARKET / LIMIT
    status = Column(String(20), nullable=False, default=OrderStatus.PENDING)

    quantity = Column(Numeric(precision=20, scale=8), nullable=False)
    price = Column(Numeric(precision=20, scale=8), nullable=True)
    fill_price = Column(Numeric(precision=20, scale=8), nullable=True)

    created_at = Column(DateTime(timezone=True), default=datetime.utcnow)
    updated_at = Column(DateTime(timezone=True), default=datetime.utcnow, onupdate=datetime.utcnow)
    filled_at = Column(DateTime(timezone=True), nullable=True)

    exchange_order_id = Column(String(100), nullable=True, unique=True)

    # Relaciones
    user = relationship("User", back_populates="orders")

    def __repr__(self):
        return f"<Order {self.id}: {self.side} {self.quantity} {self.symbol} @ {self.price}>"