File size: 1,029 Bytes
9d09bcd
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
# 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------------------------------")