Display number of affected rows after an UPDATE or DELETE query

[anarute]

In database consoles, when doing operations the user normally has an indication of how many rows were affected by a query. This is particular important for destructive queries as UPDATE or DELETE, so the user can know how many records were impacted by the operation and detect manual errors.

In psql for instance:

Unless I'm missing something, I don't see this number anywhere. I think it could be displayed in the alert that appears after the operation is successful:

[anarute]

@tconbeer I'd be willing to work on this if you think it's a good idea.
I was taking a look on the execute_query, QueriesExecuted and fetch_data_or_reset_table and trying to understand how to send this info across, if you have any pointers it would be great 🙏

[tconbeer]

This will require a change to the adapter API, and then a change to adapters to implement the new API.

Right now adapters should return None after successfully executing DDL/DML (they return a HarlequinCursor after executing a query that returns tabular data).

An implementation of this feature would probably be a new Class in harlequin.adapter to contain the details of an executed DDL/DML query, like the name of the statement (e.g., DELETE) and the number of affected rows. Then the Harlequin App could present info from this new object if it is returned by adapters, instead of None (this will require a change to the QueriesExecuted message to store this info).

[anarute]

Great, thank you!