search

vanna-ai / vanna

🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using RAG 🔄.
https://vanna.ai/docs/
MIT License
9.42k stars 691 forks source link

Fix string concatenation in initial_prompt #449

Closed peilongchencc closed 1 month ago

peilongchencc commented 1 month ago

old version:

dialect = "SQL"
initial_prompt = f"You are a {dialect} expert. "
"Please help to generate a SQL query to answer the question. Your response should ONLY be based on the given context and follow the response guidelines and format instructions. "
print(initial_prompt)

terminal ouput:

You are a SQL expert.

new version:

dialect = "SQL"
initial_prompt = f"You are a {dialect} expert. " + \
"Please help to generate a SQL query to answer the question. Your response should ONLY be based on the given context and follow the response guidelines and format instructions. "
print(initial_prompt)

terminal ouput:

You are a SQL expert. Please help to generate a SQL query to answer the question. Your response should ONLY be based on the given context and follow the response guidelines and format instructions.