| 123456789101112131415161718192021222324252627282930313233343536373839 |
- from sqlalchemy import Column, Integer, String, DateTime
- from sqlalchemy.sql import func
- from datetime import datetime
- from app.core.database import Base
- class ProxyPool(Base):
- __tablename__ = "proxy_pool"
- __ddl__ = """
- CREATE TABLE IF NOT EXISTS `proxy_pool` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `pool_name` VARCHAR(32) NOT NULL COMMENT '所属代理池',
- `proto` VARCHAR(10) NOT NULL DEFAULT 'http' COMMENT '代理协议',
- `ip` VARCHAR(39) NOT NULL COMMENT '代理IP',
- `port` INT NOT NULL COMMENT '端口',
- `username` VARCHAR(64) NULL DEFAULT NULL COMMENT '代理用户名',
- `password` VARCHAR(64) NULL DEFAULT NULL COMMENT '代理密码',
- `next_use_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '下次允许使用的时间',
- `status` VARCHAR(16) NOT NULL DEFAULT 'active' COMMENT 'active=可用, disable=禁用',
- `time_zone` VARCHAR(100) NULL COMMENT '时区',
- `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`),
- KEY `idx_proxy_pool_pool_name` (`pool_name`),
- KEY `idx_proxy_pool_status` (`status`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='网络代理资源池表';
- """
- id = Column(Integer, primary_key=True, index=True, autoincrement=True)
- pool_name = Column(String(32), nullable=False, comment="所属代理池")
- proto = Column(String(10), nullable=False, default="http", comment="代理协议")
- ip = Column(String(39), nullable=False, comment="代理IP")
- port = Column(Integer, nullable=False, comment="端口")
- username = Column(String(64), default=None, comment="代理用户名")
- password = Column(String(64), default=None, comment="代理密码")
- next_use_time = Column(DateTime, nullable=False, default=func.now(), comment="下次允许使用的时间")
- status = Column(String(16), nullable=False, default="active", comment="active=可用, disable=禁用")
- time_zone = Column(String(100), nullable=True, comment="时区")
- created_at = Column(DateTime, default=datetime.utcnow)
- updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
|