File size: 1,248 Bytes
a919f65
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
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()