feat: working agent management

[Shreyas-Microsoft]

Purpose

This pull request introduces significant updates to the application's agent management and logging mechanisms, as well as improvements to SQL query handling and error management. The changes primarily focus on adding support for a new SQL agent, enhancing logging for debugging purposes, and improving cleanup processes during application shutdown and agent deletion.

Agent Management Enhancements:

• src/App/app.py: Added initialization and cleanup logic for a new SQL agent during application startup and shutdown. Improved error handling and logging during the shutdown process to ensure agents are properly cleaned up.
• src/App/backend/agents/agent_factory.py: Introduced a new _sql_agent attribute in AgentFactory and implemented methods to initialize and delete the SQL agent. Added detailed logging and error handling during agent deletion for wealth advisor, search, and SQL agents. [1] [2]

Logging Improvements:

• src/App/backend/agents/agent_factory.py: Enhanced logging to provide detailed information about agent initialization and deletion processes, including warnings for invalid or missing agent clients.
• src/App/backend/plugins/chat_with_data_plugin.py: Added logging for SQL query generation, execution, and result processing, as well as thread cleanup after query execution. [1] [2] [3]

SQL Query Handling:

• src/App/backend/plugins/chat_with_data_plugin.py: Improved SQL query generation and cleanup logic, ensuring queries are properly formatted and executed. Added logging to track query results and provide previews of the output.

Application Context Updates:

• src/App/backend/plugins/chat_with_data_plugin.py: Updated logic to use the singleton search agent from the application context when available, falling back to AgentFactory if necessary.

Codebase Maintenance:

• src/App/backend/agents/agent_factory.py: Added logging import to enable detailed logging throughout the agent factory module.
• src/App/backend/plugins/chat_with_data_plugin.py: Added current_app import to access application context for agent management.

Does this introduce a breaking change?

• Yes
• No

Golden Path Validation

• I have tested the primary workflows (the "golden path") to ensure they function correctly without errors.

Deployment Validation

• I have validated the deployment process successfully and all services are running as expected with this change.

What to Check

Verify that the following are valid

• ...

Other Information

[github-actions]

🎉 This PR is included in version 1.8.0 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀