| 12345678910111213141516171819202122232425262728 |
- 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)
|