import streamlit as st from azure.cosmos import CosmosClient, PartitionKey, exceptions import os import pandas as pd import traceback # For detailed error stacks st.set_page_config(layout="wide") # Cosmos DB configuration ENDPOINT = "https://acae-afd.documents.azure.com:443/" SUBSCRIPTION_ID = "003fba60-5b3f-48f4-ab36-3ed11bc40816" DATABASE_NAME = os.environ.get("COSMOS_DATABASE_NAME") CONTAINER_NAME = os.environ.get("COSMOS_CONTAINER_NAME") Key = os.environ.get("Key") def insert_record(record): try: response = container.create_item(body=record) return True, response except exceptions.CosmosHttpResponseError as e: return False, f"HTTP error occurred: {str(e)}. Status code: {e.status_code}" except Exception as e: return False, f"An unexpected error occurred: {str(e)}" def call_stored_procedure(record): try: response = container.scripts.execute_stored_procedure( sproc="processPrompt", params=[record], partition_key=record['id'] ) return True, response except exceptions.CosmosHttpResponseError as e: error_message = f"HTTP error occurred: {str(e)}. Status code: {e.status_code}" return False, error_message except Exception as e: error_message = f"An unexpected error occurred: {str(e)}" return False, error_message def fetch_all_records(): try: query = "SELECT * FROM c" items = list(container.query_items(query=query, enable_cross_partition_query=True)) return pd.DataFrame(items) except exceptions.CosmosHttpResponseError as e: st.error(f"HTTP error occurred while fetching records: {str(e)}. Status code: {e.status_code}") return pd.DataFrame() except Exception as e: st.error(f"An unexpected error occurred while fetching records: {str(e)}") return pd.DataFrame() def update_record(updated_record): try: container.upsert_item(body=updated_record) # Upsert updates the item if it exists return True, f"Record with id {updated_record['id']} successfully updated." except exceptions.CosmosHttpResponseError as e: return False, f"HTTP error occurred: {str(e)}. Status code: {e.status_code}" except Exception as e: return False, f"An unexpected error occurred: {traceback.format_exc()}" def delete_record(name, id): try: container.delete_item(item=id, partition_key=id) return True, f"Successfully deleted record with name: {name} and id: {id}" except exceptions.CosmosResourceNotFoundError: return False, f"Record with id {id} not found. It may have been already deleted." except exceptions.CosmosHttpResponseError as e: return False, f"HTTP error occurred: {str(e)}. Status code: {e.status_code}" except Exception as e: return False, f"An unexpected error occurred: {traceback.format_exc()}" # Streamlit app st.title("🌟 Cosmos DB Record Management") # Initialize session state for selected records if 'selected_records' not in st.session_state: st.session_state.selected_records = [] # Login section if 'logged_in' not in st.session_state: st.session_state.logged_in = False if not st.session_state.logged_in: st.subheader("🔐 Login") input_key = Key # Use the predefined Key instead of asking for user input if st.button("🚀 Login"): if input_key: st.session_state.primary_key = input_key st.session_state.logged_in = True st.rerun() else: st.error("Invalid key. Please check your environment variables.") else: # Initialize Cosmos DB client try: client = CosmosClient(ENDPOINT, credential=st.session_state.primary_key) database = client.get_database_client(DATABASE_NAME) container = database.get_container_client(CONTAINER_NAME) except exceptions.CosmosHttpResponseError as e: st.error(f"Failed to connect to Cosmos DB. HTTP error: {str(e)}. Status code: {e.status_code}") st.stop() except Exception as e: st.error(f"An unexpected error occurred while connecting to Cosmos DB: {str(e)}") st.stop() # Fetch and display all records st.subheader("📊 All Records") df = fetch_all_records() if df.empty: st.write("No records found in the database.") else: st.write("Records:") for index, row in df.iterrows(): col1, col2, col3 = st.columns([5, 1, 1]) with col1: # Display all fields in the listing st.write(f"ID: {row['id']}, Name: {row['name']}, Document: {row['document']}, " f"Evaluation Text: {row['evaluationText']}, Evaluation Score: {row['evaluationScore']}") with col2: key = f"select_{row['id']}" if st.button(f"👉 Select", key=key): st.session_state.selected_record = row.to_dict() with col3: if st.button(f"🗑️ Delete", key=f"delete_{row['id']}"): success, message = delete_record(row['name'], row['id']) if success: st.success(message) st.rerun() # Refresh after deletion else: st.error(message) # Display selected record for editing if 'selected_record' in st.session_state and st.session_state.selected_record: selected_record = st.session_state.selected_record st.subheader(f"Editing Record - ID: {selected_record['id']}") # Editable fields prefilled with the selected record updated_name = st.text_input("Name", value=selected_record['name']) updated_document = st.text_area("Document", value=selected_record['document']) updated_evaluation_text = st.text_area("Evaluation Text", value=selected_record['evaluationText']) updated_evaluation_score = st.text_input("Evaluation Score", value=str(selected_record['evaluationScore'])) # Update button with emoji if st.button("💾 Save Changes"): updated_record = { "id": selected_record['id'], "name": updated_name, "document": updated_document, "evaluationText": updated_evaluation_text, "evaluationScore": updated_evaluation_score # Now treated as a string } success, message = update_record(updated_record) if success: st.success(message) st.session_state.selected_record = updated_record # Update the session state with new values else: st.error(message) # Input fields for new record st.subheader("📝 Enter New Record Details") new_id = st.text_input("ID") new_name = st.text_input("Name") new_document = st.text_area("Document") new_evaluation_text = st.text_area("Evaluation Text") new_evaluation_score = st.text_input("Evaluation Score") # Now treated as a string col1, col2 = st.columns(2) # Insert Record button with col1: if st.button("💾 Insert Record"): record = { "id": new_id, "name": new_name, "document": new_document, "evaluationText": new_evaluation_text, "evaluationScore": new_evaluation_score # Insert as a string } success, response = insert_record(record) if success: st.success("✅ Record inserted successfully!") st.json(response) else: st.error(f"❌ Failed to insert record: {response}") st.rerun() # Call Procedure button with col2: if st.button("🔧 Call Procedure"): record = { "id": new_id, "name": new_name, "document": new_document, "evaluationText": new_evaluation_text, "evaluationScore": new_evaluation_score } success, response = call_stored_procedure(record) if success: st.success("✅ Stored procedure executed successfully!") st.json(response) else: st.error(f"❌ Failed to execute stored procedure: {response}") # Logout button if st.button("🚪 Logout"): st.session_state.logged_in = False st.session_state.selected_records.clear() # Clear selected records on logout st.session_state.selected_record = None # Clear selected record st.rerun() # Display connection info st.sidebar.subheader("🔗 Connection Information") st.sidebar.text(f"Endpoint: {ENDPOINT}") st.sidebar.text(f"Subscription ID: {SUBSCRIPTION_ID}") st.sidebar.text(f"Database: {DATABASE_NAME}") st.sidebar.text(f"Container: {CONTAINER_NAME}")