Hello,
I am trying to update a column of selected row from dash datatable. I have managed to select value of selected row and update the specific column but how can I update that column into dash datatable and also update it into a database.
I am using flask sqlalchemy with postgres. Here
dff_sel_row.to_sql("prodlist", con=db.engine, if_exists='replace', index=False)
instead of if_exist=‘replace’ or ‘append’ I want to update that specific selected row column. Any help please!? My code:
@app.callback(
Output('tbl_rows', 'children'),
[Input('our-table', 'data'),
Input('our-table', 'selected_rows'),
Input('my_input', 'value')
]
)
def update_column_value(data, select_row, val):
print("Im here")
dff = pd.DataFrame(data)
# sel_row = [dff.loc[select_row]]
sel_row = [data[i] for i in select_row]
print("selected row is: ", sel_row)
dff_sel_row = pd.DataFrame(sel_row)
dff_sel_row.loc[:, 'Version'] = val
print(dff_sel_row)
dff_sel_row.to_sql("prodlist", con=db.engine, if_exists='replace', index=False)