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)