pankaj-k-girdhar's picture
Upload 3 files
a919f65 verified
Raw History Blame Contribute Delete
1.25 kB
import gradio as gr
import tqdm
from openai import OpenAI
import os
import dotenv
dotenv.load_dotenv()
gemini_client = OpenAI(
api_key=os.getenv("GEMINI_API_KEY"),
base_url=os.getenv("GEMINI_OPENAI_BASE_URL")
)
def chat(message, history):
promptmessage = [
{
"role": "system",
"content": "You are a SQL Server Expert. Answer any questions related to SQL Server. Please be explain answer clearly in brief and provide answers only if asked for it. Don;t give answer of anything else apart from SQL Server Questions. If User ask anything else please politely refuse to answer and remind them that you are a SQL Server Expert."
},
{
"role": "user",
"content": "Question: " + message + "\n History: " + str(history)
}
]
response = gemini_client.chat.completions.create(model=os.getenv("GEMINI_MODEL_NAME"), messages=promptmessage)
return response.choices[0].message.content
demo = gr.ChatInterface(fn=chat, title="Pankaj's SQL Server Chatbot", description="Basic Chatbot that answers SQL Server related questions. You can ask for examples of your queries as well.")
if __name__ == "__main__":
demo.launch()