Spaces:
Sleeping
Sleeping
Download app.py from zinthaw/text-to-SQL-GeminiAI: direct link, hf CLI and curl.
- Browser
- Download file 1.81 kB
-
https://huggingface.co/spaces/zinthaw/text-to-SQL-GeminiAI/resolve/main/app.py
- Command line
-
hf download hf://spaces/zinthaw/text-to-SQL-GeminiAI/app.py
-
curl -L -o app.py https://huggingface.co/spaces/zinthaw/text-to-SQL-GeminiAI/resolve/main/app.py
1.81 kB
| from dotenv import load_dotenv | |
| load_dotenv() ## load all the environment variables | |
| import streamlit as st | |
| import os | |
| import sqlite3 | |
| import google.generativeai as genai | |
| ## config Genai key | |
| genai.configure(api_key=os.getenv("google_api_key")) | |
| ## Function to load Google Gemini Model and provide queries as respone | |
| def get_gemini_responses(question,prompt): | |
| model=genai.GenerativeModel('gemini-pro') | |
| response=model.generate_content([prompt[0],question]) | |
| return response.text | |
| ## Function to retrieve query from database | |
| def read_sql_query(sql,db): | |
| conn=sqlite3.connect(db) | |
| cur=conn.cursor() | |
| cur.execute(sql) | |
| rows=cur.fetchall() | |
| conn.commit() | |
| conn.close() | |
| for row in rows: | |
| print(row) | |
| return rows | |
| ## Define prompt | |
| prompt=[""" | |
| You are an expert in converting English questions to SQL query! | |
| The SQL database has the name PLAYER and has the following columns - | |
| Name, Position, Age, Club, Height, Foot, Caps, Goals, MarketValue, Country | |
| For example, | |
| Example 1 - How many entries of records are present?, | |
| the SQL command will be something like this SELECT COUNT(*) FROM PLAYER ; | |
| Example 2 - How many player in Germany?, | |
| the SQL command will be something like this SELECT COUNT(*) FROM PLAYER WHERE Country='Germany' ; | |
| also the sql code should not have ''' in the beginning or end and sql word in output | |
| """ | |
| ] | |
| ## Streamlit App | |
| st.set_page_config(page_title="I Can Retrieve Any SQL query") | |
| st.header("Gemini App to Retrieve SQL Data") | |
| question=st.text_input("Input: ",key="input") | |
| submit=st.button("Ask the question") | |
| ## if submit is clicked | |
| if submit: | |
| response=get_gemini_responses(question,prompt) | |
| response=read_sql_query(response,"player.db") | |
| st.subheader("The Response is") | |
| for row in response: | |
| print(row) | |
| st.header(row) |