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.
code:
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??