proxy_pool.py 2.2 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. from sqlalchemy import Column, Integer, String, DateTime
  2. from sqlalchemy.sql import func
  3. from datetime import datetime
  4. from app.core.database import Base
  5. class ProxyPool(Base):
  6. __tablename__ = "proxy_pool"
  7. __ddl__ = """
  8. CREATE TABLE IF NOT EXISTS `proxy_pool` (
  9. `id` INT NOT NULL AUTO_INCREMENT,
  10. `pool_name` VARCHAR(32) NOT NULL COMMENT '所属代理池',
  11. `proto` VARCHAR(10) NOT NULL DEFAULT 'http' COMMENT '代理协议',
  12. `ip` VARCHAR(39) NOT NULL COMMENT '代理IP',
  13. `port` INT NOT NULL COMMENT '端口',
  14. `username` VARCHAR(64) NULL DEFAULT NULL COMMENT '代理用户名',
  15. `password` VARCHAR(64) NULL DEFAULT NULL COMMENT '代理密码',
  16. `next_use_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '下次允许使用的时间',
  17. `status` VARCHAR(16) NOT NULL DEFAULT 'active' COMMENT 'active=可用, disable=禁用',
  18. `time_zone` VARCHAR(100) NULL COMMENT '时区',
  19. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  20. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  21. PRIMARY KEY (`id`),
  22. KEY `idx_proxy_pool_pool_name` (`pool_name`),
  23. KEY `idx_proxy_pool_status` (`status`)
  24. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='网络代理资源池表';
  25. """
  26. id = Column(Integer, primary_key=True, index=True, autoincrement=True)
  27. pool_name = Column(String(32), nullable=False, comment="所属代理池")
  28. proto = Column(String(10), nullable=False, default="http", comment="代理协议")
  29. ip = Column(String(39), nullable=False, comment="代理IP")
  30. port = Column(Integer, nullable=False, comment="端口")
  31. username = Column(String(64), default=None, comment="代理用户名")
  32. password = Column(String(64), default=None, comment="代理密码")
  33. next_use_time = Column(DateTime, nullable=False, default=func.now(), comment="下次允许使用的时间")
  34. status = Column(String(16), nullable=False, default="active", comment="active=可用, disable=禁用")
  35. time_zone = Column(String(100), nullable=True, comment="时区")
  36. created_at = Column(DateTime, default=datetime.utcnow)
  37. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)