http_session.py 1.0 KB

12345678910111213141516171819202122232425262728
  1. from sqlalchemy import Column, String, Text, DateTime
  2. from app.core.database import Base
  3. from datetime import datetime
  4. class HttpSession(Base):
  5. __tablename__ = "http_session"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `http_session` (
  8. `session_id` VARCHAR(128) NOT NULL,
  9. `local_storage` MEDIUMTEXT NULL,
  10. `session_storage` MEDIUMTEXT NULL,
  11. `cookies` MEDIUMTEXT NULL,
  12. `user_agent` VARCHAR(512) NULL,
  13. `proxy` VARCHAR(256) NULL,
  14. `page` MEDIUMTEXT NULL,
  15. `create_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  16. PRIMARY KEY (`session_id`)
  17. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='自动化执行浏览器会话状态表';
  18. """
  19. session_id = Column(String(128), primary_key=True)
  20. local_storage = Column(Text)
  21. session_storage = Column(Text)
  22. cookies = Column(Text)
  23. user_agent = Column(String(512))
  24. proxy = Column(String(256))
  25. page = Column(Text)
  26. create_at = Column(DateTime, nullable=False, default=datetime.utcnow)