account.py 1.6 KB

1234567891011121314151617181920212223242526272829303132333435
  1. from sqlalchemy import Column, Integer, String, Text, Float, JSON, TIMESTAMP, Enum, DateTime
  2. from sqlalchemy.sql import func
  3. from datetime import datetime
  4. from app.core.database import Base
  5. class Account(Base):
  6. __tablename__ = "account"
  7. __ddl__ = """
  8. CREATE TABLE IF NOT EXISTS `account` (
  9. `id` INT NOT NULL AUTO_INCREMENT,
  10. `pool_name` VARCHAR(50) NOT NULL,
  11. `username` VARCHAR(100) NOT NULL,
  12. `password` VARCHAR(255) NULL,
  13. `extra_data` JSON NULL,
  14. `next_use_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '下次允许使用的时间',
  15. `status` ENUM('active','disable') NOT NULL DEFAULT 'active',
  16. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  17. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  18. PRIMARY KEY (`id`),
  19. KEY `idx_account_pool_name` (`pool_name`),
  20. KEY `idx_account_status` (`status`)
  21. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='账号池表';
  22. """
  23. id = Column(Integer, primary_key=True, index=True)
  24. pool_name = Column(String(50), nullable=False, index=True)
  25. username = Column(String(100), nullable=False)
  26. password = Column(String(255), nullable=True)
  27. extra_data = Column(JSON, nullable=True)
  28. next_use_time = Column(DateTime, nullable=False, default=func.now(), comment="下次允许使用的时间")
  29. status = Column(Enum('active','disable'), default="active", index=True)
  30. created_at = Column(DateTime, default=datetime.utcnow)
  31. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)