tool.py 1.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. import json
  2. from enum import Enum
  3. from sqlalchemy.dialects.postgresql import UUID
  4. from extensions.ext_database import db
  5. class ToolProviderName(Enum):
  6. SERPAPI = 'serpapi'
  7. @staticmethod
  8. def value_of(value):
  9. for member in ToolProviderName:
  10. if member.value == value:
  11. return member
  12. raise ValueError(f"No matching enum found for value '{value}'")
  13. class ToolProvider(db.Model):
  14. __tablename__ = 'tool_providers'
  15. __table_args__ = (
  16. db.PrimaryKeyConstraint('id', name='tool_provider_pkey'),
  17. db.UniqueConstraint('tenant_id', 'tool_name', name='unique_tool_provider_tool_name')
  18. )
  19. id = db.Column(UUID, server_default=db.text('uuid_generate_v4()'))
  20. tenant_id = db.Column(UUID, nullable=False)
  21. tool_name = db.Column(db.String(40), nullable=False)
  22. encrypted_credentials = db.Column(db.Text, nullable=True)
  23. is_enabled = db.Column(db.Boolean, nullable=False, server_default=db.text('false'))
  24. created_at = db.Column(db.DateTime, nullable=False, server_default=db.text('CURRENT_TIMESTAMP(0)'))
  25. updated_at = db.Column(db.DateTime, nullable=False, server_default=db.text('CURRENT_TIMESTAMP(0)'))
  26. @property
  27. def credentials_is_set(self):
  28. """
  29. Returns True if the encrypted_config is not None, indicating that the token is set.
  30. """
  31. return self.encrypted_credentials is not None
  32. @property
  33. def credentials(self):
  34. """
  35. Returns the decrypted config.
  36. """
  37. return json.loads(self.encrypted_credentials) if self.encrypted_credentials is not None else None