Sweep: Include bot_ConversationalRetrievalChain code into script

[sweep-ai[bot]]

PR Feedback (click)

• [ ] 👍 Sweep Did Well
• [ ] 👎 Sweep Needs Improvement

  Description

  This pull request introduces the bot_ConversationalRetrievalChain.py script, which integrates various components for conversational retrieval using a bot. The script establishes a connection to a PostgreSQL database, retrieves conversation history, formats it, and uses a language model and vector store for generating responses.

Summary

• Added bot_ConversationalRetrievalChain.py to enable conversational retrieval capabilities.
• Utilizes psycopg2 for PostgreSQL database connection to fetch conversation history.
• Implements conversation history formatting to differentiate between human and AI messages.
• Leverages FAISS and Chroma from langchain_community.vectorstores for efficient vector storage and retrieval.
• Integrates ChatOpenAI from langchain.llm as the language model for generating responses.
• Supports loading and saving of vector stores locally for persistence.
• Includes command-line argument parsing for dynamic conversation ID and message input handling.
• Demonstrates a complete workflow from database query to response generation in a conversational context.

Fixes #4.

---

🎉 Latest improvements to Sweep:

• New dashboard launched for real-time tracking of Sweep issues, covering all stages from search to coding.
• Integration of OpenAI's latest Assistant API for more efficient and reliable code planning and editing, improving speed by 3x.
• Use the GitHub issues extension for creating Sweep issues directly from your editor.

---

💡 To get Sweep to edit this pull request, you can:

• Comment below, and Sweep can edit the entire PR
• Comment on a file, Sweep will only modify the commented file
• Edit the original issue to get Sweep to recreate the PR from scratch

This is an automated message generated by Sweep AI.

[sweep-ai[bot]]

Rollback Files For Sweep

• [ ] Rollback changes to libs/langchain/langchain/chains/conversational_retrieval/bot_ConversationalRetrievalChain.py

This is an automated message generated by Sweep AI.