What I’m trying to do:
Programmatically build query objects and execute them.
Specifically, I want to create a function like this:
@anvil.server.callable def assert_input_row_doesnt_exist_in_table(input_row, table_to_check_against): # input_row is kvp, key is string, which is column name, value is any value that can be in datatable # properties_that_matter is a list of string, which correspond to the column names in the table to check from input_row # table_to_check_against is the table to assert this statement against pass
What I’ve tried and what’s not working:
I’ve looked at this documentation, which is good for having hardcoded queries, but I couldn’t find anything about being able to dynamically build the query code itself.
Any ideas are appreciated