Transaction modes support

[shiro]

IntelliJ has this really nice way of setting the transaction mode, committing on the DB if the mode is "auto" (like what you're doing in the extension) and wrapping it in a transaction if set to "manual", so it can be rolled back or committed by the developer using the buttons.

This is useful for testing if a query is working/testing on a virtually modified dataset without actually updating the DB.

Thanks for the awesome extension!

[cweijan]

Thanks for your feedback, but sorry I don't plan to provide support for transactions, this feature is useless for most people, once transactions are supported, I have to add a new button on the toolbar of the results page, which will cause the toolbar are very messy(Too many buttons now).

[shiro]

Understandable, thanks for the clarification. 👍

[DaniRey]

As a workaround users can manually start a transaction in a "Query".