provider.py 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217
  1. from enum import Enum
  2. from sqlalchemy import func
  3. from models.base import Base
  4. from .engine import db
  5. from .types import StringUUID
  6. class ProviderType(Enum):
  7. CUSTOM = "custom"
  8. SYSTEM = "system"
  9. @staticmethod
  10. def value_of(value):
  11. for member in ProviderType:
  12. if member.value == value:
  13. return member
  14. raise ValueError(f"No matching enum found for value '{value}'")
  15. class ProviderQuotaType(Enum):
  16. PAID = "paid"
  17. """hosted paid quota"""
  18. FREE = "free"
  19. """third-party free quota"""
  20. TRIAL = "trial"
  21. """hosted trial quota"""
  22. @staticmethod
  23. def value_of(value):
  24. for member in ProviderQuotaType:
  25. if member.value == value:
  26. return member
  27. raise ValueError(f"No matching enum found for value '{value}'")
  28. class Provider(Base):
  29. """
  30. Provider model representing the API providers and their configurations.
  31. """
  32. __tablename__ = "providers"
  33. __table_args__ = (
  34. db.PrimaryKeyConstraint("id", name="provider_pkey"),
  35. db.Index("provider_tenant_id_provider_idx", "tenant_id", "provider_name"),
  36. db.UniqueConstraint(
  37. "tenant_id", "provider_name", "provider_type", "quota_type", name="unique_provider_name_type_quota"
  38. ),
  39. )
  40. id = db.Column(StringUUID, server_default=db.text("uuid_generate_v4()"))
  41. tenant_id = db.Column(StringUUID, nullable=False)
  42. provider_name = db.Column(db.String(255), nullable=False)
  43. provider_type = db.Column(db.String(40), nullable=False, server_default=db.text("'custom'::character varying"))
  44. encrypted_config = db.Column(db.Text, nullable=True)
  45. is_valid = db.Column(db.Boolean, nullable=False, server_default=db.text("false"))
  46. last_used = db.Column(db.DateTime, nullable=True)
  47. quota_type = db.Column(db.String(40), nullable=True, server_default=db.text("''::character varying"))
  48. quota_limit = db.Column(db.BigInteger, nullable=True)
  49. quota_used = db.Column(db.BigInteger, default=0)
  50. created_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
  51. updated_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
  52. def __repr__(self):
  53. return (
  54. f"<Provider(id={self.id}, tenant_id={self.tenant_id}, provider_name='{self.provider_name}',"
  55. f" provider_type='{self.provider_type}')>"
  56. )
  57. @property
  58. def token_is_set(self):
  59. """
  60. Returns True if the encrypted_config is not None, indicating that the token is set.
  61. """
  62. return self.encrypted_config is not None
  63. @property
  64. def is_enabled(self):
  65. """
  66. Returns True if the provider is enabled.
  67. """
  68. if self.provider_type == ProviderType.SYSTEM.value:
  69. return self.is_valid
  70. else:
  71. return self.is_valid and self.token_is_set
  72. class ProviderModel(Base):
  73. """
  74. Provider model representing the API provider_models and their configurations.
  75. """
  76. __tablename__ = "provider_models"
  77. __table_args__ = (
  78. db.PrimaryKeyConstraint("id", name="provider_model_pkey"),
  79. db.Index("provider_model_tenant_id_provider_idx", "tenant_id", "provider_name"),
  80. db.UniqueConstraint(
  81. "tenant_id", "provider_name", "model_name", "model_type", name="unique_provider_model_name"
  82. ),
  83. )
  84. id = db.Column(StringUUID, server_default=db.text("uuid_generate_v4()"))
  85. tenant_id = db.Column(StringUUID, nullable=False)
  86. provider_name = db.Column(db.String(255), nullable=False)
  87. model_name = db.Column(db.String(255), nullable=False)
  88. model_type = db.Column(db.String(40), nullable=False)
  89. encrypted_config = db.Column(db.Text, nullable=True)
  90. is_valid = db.Column(db.Boolean, nullable=False, server_default=db.text("false"))
  91. created_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
  92. updated_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
  93. class TenantDefaultModel(Base):
  94. __tablename__ = "tenant_default_models"
  95. __table_args__ = (
  96. db.PrimaryKeyConstraint("id", name="tenant_default_model_pkey"),
  97. db.Index("tenant_default_model_tenant_id_provider_type_idx", "tenant_id", "provider_name", "model_type"),
  98. )
  99. id = db.Column(StringUUID, server_default=db.text("uuid_generate_v4()"))
  100. tenant_id = db.Column(StringUUID, nullable=False)
  101. provider_name = db.Column(db.String(255), nullable=False)
  102. model_name = db.Column(db.String(255), nullable=False)
  103. model_type = db.Column(db.String(40), nullable=False)
  104. created_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
  105. updated_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
  106. class TenantPreferredModelProvider(Base):
  107. __tablename__ = "tenant_preferred_model_providers"
  108. __table_args__ = (
  109. db.PrimaryKeyConstraint("id", name="tenant_preferred_model_provider_pkey"),
  110. db.Index("tenant_preferred_model_provider_tenant_provider_idx", "tenant_id", "provider_name"),
  111. )
  112. id = db.Column(StringUUID, server_default=db.text("uuid_generate_v4()"))
  113. tenant_id = db.Column(StringUUID, nullable=False)
  114. provider_name = db.Column(db.String(255), nullable=False)
  115. preferred_provider_type = db.Column(db.String(40), nullable=False)
  116. created_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
  117. updated_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
  118. class ProviderOrder(Base):
  119. __tablename__ = "provider_orders"
  120. __table_args__ = (
  121. db.PrimaryKeyConstraint("id", name="provider_order_pkey"),
  122. db.Index("provider_order_tenant_provider_idx", "tenant_id", "provider_name"),
  123. )
  124. id = db.Column(StringUUID, server_default=db.text("uuid_generate_v4()"))
  125. tenant_id = db.Column(StringUUID, nullable=False)
  126. provider_name = db.Column(db.String(255), nullable=False)
  127. account_id = db.Column(StringUUID, nullable=False)
  128. payment_product_id = db.Column(db.String(191), nullable=False)
  129. payment_id = db.Column(db.String(191))
  130. transaction_id = db.Column(db.String(191))
  131. quantity = db.Column(db.Integer, nullable=False, server_default=db.text("1"))
  132. currency = db.Column(db.String(40))
  133. total_amount = db.Column(db.Integer)
  134. payment_status = db.Column(db.String(40), nullable=False, server_default=db.text("'wait_pay'::character varying"))
  135. paid_at = db.Column(db.DateTime)
  136. pay_failed_at = db.Column(db.DateTime)
  137. refunded_at = db.Column(db.DateTime)
  138. created_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
  139. updated_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
  140. class ProviderModelSetting(Base):
  141. """
  142. Provider model settings for record the model enabled status and load balancing status.
  143. """
  144. __tablename__ = "provider_model_settings"
  145. __table_args__ = (
  146. db.PrimaryKeyConstraint("id", name="provider_model_setting_pkey"),
  147. db.Index("provider_model_setting_tenant_provider_model_idx", "tenant_id", "provider_name", "model_type"),
  148. )
  149. id = db.Column(StringUUID, server_default=db.text("uuid_generate_v4()"))
  150. tenant_id = db.Column(StringUUID, nullable=False)
  151. provider_name = db.Column(db.String(255), nullable=False)
  152. model_name = db.Column(db.String(255), nullable=False)
  153. model_type = db.Column(db.String(40), nullable=False)
  154. enabled = db.Column(db.Boolean, nullable=False, server_default=db.text("true"))
  155. load_balancing_enabled = db.Column(db.Boolean, nullable=False, server_default=db.text("false"))
  156. created_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
  157. updated_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
  158. class LoadBalancingModelConfig(Base):
  159. """
  160. Configurations for load balancing models.
  161. """
  162. __tablename__ = "load_balancing_model_configs"
  163. __table_args__ = (
  164. db.PrimaryKeyConstraint("id", name="load_balancing_model_config_pkey"),
  165. db.Index("load_balancing_model_config_tenant_provider_model_idx", "tenant_id", "provider_name", "model_type"),
  166. )
  167. id = db.Column(StringUUID, server_default=db.text("uuid_generate_v4()"))
  168. tenant_id = db.Column(StringUUID, nullable=False)
  169. provider_name = db.Column(db.String(255), nullable=False)
  170. model_name = db.Column(db.String(255), nullable=False)
  171. model_type = db.Column(db.String(40), nullable=False)
  172. name = db.Column(db.String(255), nullable=False)
  173. encrypted_config = db.Column(db.Text, nullable=True)
  174. enabled = db.Column(db.Boolean, nullable=False, server_default=db.text("true"))
  175. created_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())
  176. updated_at = db.Column(db.DateTime, nullable=False, server_default=func.current_timestamp())