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)