Make table row behave more like a dict

[mjmare]

The docs say " Row Objects behave like Python dictionaries.". Well, a bit yes, but it is missing some vital parts:

• it would be useful to have access methods like: keys(), values(), items()
• it would be useful to access row values with a .get(fieldname, default)

It would also be nice to be able to cast a row to a dict, but that seems to be difficult: What does SuspensionError mean?

Also using table.list_columns (as a workaround for .keys()) does not work on the client.

[owen.campbell]

Here’s what the suspension error is about and how you cast a row to a dict:

Creating a dict from a table record

Is there a convenient way to convert a record from a data table into a python dict? I have a form which takes various user input fields, binds those to self.item and passes the result to a server module to update the data table with some validation on the way. So far, so good. However, I’d like to initialise the form with the current record. I can extract the relevant record and hand crank it into the self.item dict by listing the fields, but it would be far nicer to do so directly.