provider.py 8.9 KB

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