Refresh Token — core.identidad.trx_refresh_tokens¶
Tokenización de sesiones: almacén de refresh tokens con rotación y revocación.
from datetime import datetime, date
from typing import Optional
import uuid
from sqlalchemy import (
BigInteger,
Boolean,
CheckConstraint,
Date,
DateTime,
ForeignKey,
Identity,
Index,
Integer,
SmallInteger,
String,
Text,
UniqueConstraint,
text,
)
from sqlalchemy.dialects import postgresql
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column
class Base(DeclarativeBase):
pass
class TrxRefreshToken(Base):
__tablename__ = 'trx_refresh_tokens'
__table_args__ = (
UniqueConstraint('token_hash', name='uq_trx_refresh_tokens_token_hash'),
{"schema": 'core.identidad'},
)
id: Mapped[uuid.UUID] = mapped_column(
UUID(as_uuid=True),
primary_key=True,
server_default=text("gen_random_uuid()"),
)
empresa_id: Mapped[int] = mapped_column(
BigInteger,
nullable=False,
comment='Empresa de la sesión',
)
token_hash: Mapped[str] = mapped_column(
String(64),
nullable=False,
comment='Hash SHA-256 del token',
)
usuario_id: Mapped[uuid.UUID] = mapped_column(
UUID(as_uuid=True),
nullable=False,
ForeignKey("mae_usuarios.id"),
comment='Usuario propietario del token',
)
expiracion: Mapped[datetime] = mapped_column(
DateTime(timezone=True),
nullable=False,
comment='Fecha de expiración',
)
revocado: Mapped[bool | None] = mapped_column(
Boolean,
server_default=text("false"),
comment='Token revocado',
)
revocado_en: Mapped[datetime | None] = mapped_column(
DateTime(timezone=True),
comment='Fecha de revocación',
)
user_agent: Mapped[str | None] = mapped_column(
String(300),
comment='User-Agent del cliente',
)
ip: Mapped[str | None] = mapped_column(
String(45),
comment='IP origen (IPv4/IPv6)',
)
# Auditoría General
created_at: Mapped[datetime] = mapped_column(
DateTime(timezone=True),
nullable=False,
server_default=text("now()"),
comment='Fecha de creación',
)
is_activo: Mapped[bool] = mapped_column(
Boolean,
nullable=False,
server_default=text("true"),
comment='Estado lógico del registro',
)
updated_at: Mapped[datetime] = mapped_column(
DateTime(timezone=True),
nullable=False,
server_default=text("now()"),
comment='Fecha de última actualización',
)
deleted_at: Mapped[Optional[datetime]] = mapped_column(
DateTime(timezone=True),
comment='Fecha de eliminación lógica',
)
created_by: Mapped[Optional[uuid.UUID]] = mapped_column(
UUID(as_uuid=True),
comment='Usuario creador',
)
updated_by: Mapped[Optional[uuid.UUID]] = mapped_column(
UUID(as_uuid=True),
comment='Usuario modificador',
)