Basic understanding of processing UI to backend scripts (bulk updating a postgres db from a table)
Hi guys,
I'm new to windmill, and I've created a simple app that lists data from a postgres table using a script associated with an aggrid.
I allow editing, and want to then update the rows that have been modified when a save button is clicked.
I have the button ... I'm just not sure how to best link it to a script (of some kind ... I mean easiest to loop over changed rows in code rather than some strange input to an sql script) and the appropriate methodology to implement such a thing.
Thanks for any quick pointers!
4 Replies
Take a look at the db studio first
It might do everything you want out of the box
It's a new app component
Yep, I think that is ... but is there a simple tutorial / explanation, of an appropriate way I should wire up a table list, a button, and then processing that data as a backend update statement (or code in python or whatever)?
Thanks for the suggestion, by the way 🙂
No tutorial I am afraid right now but once you understand well the basics of windmill's app it should be straightforward
Okay, would I be on a valid path to assume I would need to write a backend script, not query, that iterates over input that I would connect to the aggrid result?
Or would I write a frontend script inline for the aggrid that transforms the data and then calls a backend script that processes that data and saves to the db?