So here, I worked on an SQL database implementing the following steps:
1- Export SQL to CSV
2- Clean CSV to TXT
3- Convert to 1-line Database TXT
4- Merge it with the Base Prompt
5- Send the Merge to ChatGPT API
here my base prompt as an example :
Act as a chatbot that assists the agents of EcoDeliver. Your role is to help EcoDeliver agents effectively utilize the application, provide guidance, answer project-related questions, and offer solutions to challenges specific to EcoDeliver. EcoDeliver is an innovative IoT-powered app for efficient commands delivery management, integrating real-time tracking, user-friendly interfaces, and environmentally friendly practices. You have access to the following database:
{}
Remember that every user who interacts with you is an agent seeking assistance with EcoDeliver-related tasks
here is the message:
then add the 1line_db (N°4 in the pic) to the base prompt between {}
and the user message after here is the message:
then send all that to OpenAi api
import openai
openai.api_base = "https://openrouter.ai/api/v1"
openai.api_key = 'get_ur_own_api_key'
user_msg_file_path = r'C:\path\to\the\file\merged.txt'
with open(user_msg_file_path, 'r') as user_msg_file:
user_msg = user_msg_file.read()
response = openai.ChatCompletion.create(
model="openai/gpt-3.5-turbo",
messages=[
{"role": "system", "content": ""},
{"role": "user", "content": user_msg},
],
headers={
"HTTP-Referer": 'http://localhost:3000',
"X-Title": 'Your App Name',
},
)
reply_content = response.choices[0].message['content']
response_file_path = r'C:\path\to\the\file\response.txt'
with open(response_file_path, 'w') as response_file:
response_file.write(reply_content)
print(reply_content)
ET VOILA
Pros and Cons:
Pros:
Diverse Responses: ChatGPT is a general AI, so you get responses that can't be queried using SQL. For example, you can ask about the distance traveled using just addresses.
Cons:
Costly: Exporting your entire database to ChatGPT for each message can get expensive.
Data Risk: There might be a risk when exporting data, so be cautious about the information you share.
Top comments (0)