i am using the st_aggrid component with connection with database what i want is to allow the user user to edit a column value using st_aggrid than after edit is done its commit on the database how can i do this ?? because until now when user edit a value the database value doesn’t change.
df = pd.read_sql_query("select * from app_db where user ='jasmin'",con) gd=GridOptionsBuilder.from_dataframe(df) gd.configure_column("status",editable = True) gridoptions = gd.build() grid_table = AgGrid(df, gridOptions = gridoptions, update_mode = GridUpdateMode.SELECTION_CHANGED, height = 500, them = "fresh" )
from here how to commit the update on the database??