provider.py 9.1 KB

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