from sqlalchemy import Column, String, Text, DateTime from app.core.database import Base from datetime import datetime class HttpSession(Base): __tablename__ = "http_session" __ddl__ = """ CREATE TABLE IF NOT EXISTS `http_session` ( `session_id` VARCHAR(128) NOT NULL, `local_storage` MEDIUMTEXT NULL, `session_storage` MEDIUMTEXT NULL, `cookies` MEDIUMTEXT NULL, `user_agent` VARCHAR(512) NULL, `proxy` VARCHAR(256) NULL, `page` MEDIUMTEXT NULL, `create_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`session_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='自动化执行浏览器会话状态表'; """ session_id = Column(String(128), primary_key=True) local_storage = Column(Text) session_storage = Column(Text) cookies = Column(Text) user_agent = Column(String(512)) proxy = Column(String(256)) page = Column(Text) create_at = Column(DateTime, nullable=False, default=datetime.utcnow)