louiecerv/sqlite3-interactive

1import streamlit as st2import sqlite33 4st.title("Task 5: Delete Data")5 6db_name = st.text_input("Enter database name:", "example.db")7delete_query = st.text_area("Enter SQL delete query (e.g., DELETE FROM students WHERE id=1):")8 9if st.button("Delete Data"):10    try:11        conn = sqlite3.connect(db_name)12        cursor = conn.cursor()13        cursor.execute(delete_query)14        conn.commit()15        rows_affected = cursor.rowcount16        if rows_affected == 0:17            st.warning("No data deleted. Please check your query.")18        else:19            st.success("Data deleted successfully!")20    except Exception as e:21        st.error(f"Error: {e}")22    finally:23        conn.close()24