session.py 1.2 KB

123456789101112131415161718192021222324252627282930
  1. from sqlalchemy import Column, String, DateTime
  2. from datetime import datetime
  3. from app.core.database import Base
  4. class VasSession(Base):
  5. __tablename__ = "vas_session"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `vas_session` (
  8. `id` VARCHAR(128) NOT NULL,
  9. `user_id` VARCHAR(128) NOT NULL,
  10. `user_agent` VARCHAR(255) NOT NULL,
  11. `ip` VARCHAR(128) NOT NULL,
  12. `expire_at` DATETIME NOT NULL,
  13. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  14. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  15. PRIMARY KEY (`id`),
  16. KEY `idx_vas_session_user_id` (`user_id`),
  17. KEY `idx_vas_session_expire_at` (`expire_at`)
  18. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户会话Token表';
  19. """
  20. id = Column(String(128), primary_key=True) # token
  21. user_id = Column(String(128), nullable=False)
  22. user_agent = Column(String(255), nullable=False)
  23. ip = Column(String(128), nullable=False)
  24. expire_at = Column(DateTime, nullable=False)
  25. created_at = Column(DateTime, default=datetime.utcnow)
  26. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)