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!

rubenf•1/14/24, 6:51 AM

Take a look at the db studio first

rubenf•1/14/24, 6:52 AM

It might do everything you want out of the box

rubenf•1/14/24, 6:52 AM

It's a new app component

Rob.Clayton•1/15/24, 12:23 AM

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)?

Rob.Clayton•1/15/24, 12:24 AM

Thanks for the suggestion, by the way

rubenf•1/15/24, 12:24 AM

No tutorial I am afraid right now but once you understand well the basics of windmill's app it should be straightforward

Rob.Clayton•1/15/24, 12:28 AM

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?