Curranj/Words_To_SQL
136
1import os2from openai import OpenAI3import gradio as gr4 5client = OpenAI(api_key=os.environ["Secret"])6 7def gpt3(texts):8 response = client.chat.completions.create(9 model="gpt-4",10 messages=[{"role": "user", "content": texts}],11 temperature=0,12 max_tokens=750,13 top_p=1,14 frequency_penalty=0.0,15 presence_penalty=0.0,16 stop=[";", "*/", "</code>"]17 )18 return response.choices[0].message.content19 20def greet(prompt):21 txt = f'''/*Prompt: {prompt}*/ \nSQL code:'''22 sql = gpt3(txt)23 return sql24 25e = gr.Interface(26 fn=greet, 27 inputs=["text"], 28 outputs="text",29 title="Natural Language to SQL Converter",30 description="Convert your natural language queries into SQL code."31)32e.launch()