plugin.py 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172
  1. from datetime import datetime
  2. from sqlalchemy import Column, Integer, String, Text, SmallInteger, DateTime, UniqueConstraint, Index
  3. from app.core.database import Base
  4. class Plugin(Base):
  5. __tablename__ = "plugins"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `plugins` (
  8. `id` INT NOT NULL AUTO_INCREMENT,
  9. `name` VARCHAR(64) NOT NULL COMMENT '插件唯一英文标识',
  10. `display_name` VARCHAR(128) NOT NULL DEFAULT '',
  11. `filename` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '插件二进制脚本文件',
  12. `class_name` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '插件入口类名',
  13. `protocol` VARCHAR(64) NOT NULL DEFAULT 'IPlugin' COMMENT '插件协议标识',
  14. `latest_version` VARCHAR(32) NOT NULL DEFAULT '1.0.0',
  15. `description` VARCHAR(512) NOT NULL DEFAULT '',
  16. `status` SMALLINT NOT NULL DEFAULT 1 COMMENT '1:启用, 0:停用',
  17. `developer_id` VARCHAR(128) NULL COMMENT '插件开发管理者ID (享有20%技术分成)',
  18. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  19. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  20. PRIMARY KEY (`id`),
  21. UNIQUE KEY `uk_plugin_name` (`name`),
  22. INDEX `idx_plugins_developer_id` (`developer_id`),
  23. INDEX `idx_plugins_status` (`status`)
  24. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='核心履约插件表';
  25. """
  26. id = Column(Integer, primary_key=True, autoincrement=True)
  27. name = Column(String(64), unique=True, nullable=False, index=True)
  28. display_name = Column(String(128), nullable=False, default="")
  29. filename = Column(String(128), nullable=False, default="")
  30. class_name = Column(String(128), nullable=False, default="")
  31. protocol = Column(String(64), nullable=False, default="IPlugin")
  32. latest_version = Column(String(32), nullable=False, default="1.0.0")
  33. description = Column(String(512), nullable=False, default="")
  34. status = Column(SmallInteger, nullable=False, default=1, index=True)
  35. developer_id = Column(String(128), nullable=True, index=True, comment="插件开发管理者ID")
  36. created_at = Column(DateTime, default=datetime.utcnow, nullable=False)
  37. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False)
  38. class PluginVersion(Base):
  39. __tablename__ = "plugin_versions"
  40. __ddl__ = """
  41. CREATE TABLE IF NOT EXISTS `plugin_versions` (
  42. `id` INT NOT NULL AUTO_INCREMENT,
  43. `plugin_id` INT NOT NULL DEFAULT 0,
  44. `plugin_name` VARCHAR(64) NOT NULL,
  45. `version` VARCHAR(32) NOT NULL,
  46. `download_url` VARCHAR(512) NOT NULL,
  47. `sha256` VARCHAR(64) NOT NULL DEFAULT '',
  48. `changelog` TEXT NULL,
  49. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  50. PRIMARY KEY (`id`),
  51. UNIQUE KEY `uk_plugin_version` (`plugin_id`, `version`),
  52. INDEX `idx_pv_plugin_name` (`plugin_name`)
  53. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='插件版本历史表';
  54. """
  55. id = Column(Integer, primary_key=True, autoincrement=True)
  56. plugin_id = Column(Integer, nullable=False, default=0, index=True)
  57. plugin_name = Column(String(64), nullable=False, index=True)
  58. version = Column(String(32), nullable=False)
  59. download_url = Column(String(512), nullable=False)
  60. sha256 = Column(String(64), nullable=False, default="")
  61. changelog = Column(Text, nullable=True)
  62. created_at = Column(DateTime, default=datetime.utcnow, nullable=False)
  63. __table_args__ = (
  64. UniqueConstraint("plugin_id", "version", name="uk_plugin_version"),
  65. )