CoolFace
Apppublic

Curranj/Words_To_SQL

sourceHugging Faceupdated 2y agoView on Hugging Face
136likes
app.py32 linesDownload Raw Back to root
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()