DPamneja's picture
Final
9d09bcd
Raw History Blame Contribute Delete
1.03 kB
# Importing the dependencies
import streamlit as st
import sqlite3
from src.Text_to_SQL.utils import get_gemini_response,read_sql_query
from src.Text_to_SQL.prompt import prompt
from src.Text_to_SQL.logger import logging
# Creating the Page
st.set_page_config(page_title="Text to SQL Retrieval")
st.header("Gemini App to Retrieve SQL Data")
question = st.text_input("Input : ",key="input")
submit = st.button("Ask the question!")
# Running the query
if submit:
logging.info("----------------------------START------------------------------")
logging.info("Response Requested")
response = get_gemini_response(question,prompt)
logging.info("Response Generated")
print(response)
response = read_sql_query(response,"./data/Student_Data.db")
logging.info("Response converted as SQL")
st.subheader("The response is : ")
for row in response:
print(row)
st.header(row)
logging.info("----------------------------END------------------------------")