RFE: Rerun the current tab's SQL Query each N second after... #80
Description
Hello,
may I ask You to consider following RFE? RFE: Rerun the current tab's SQL Query each N seconds: a) after the start of the last run (if not still running) or b) after the end of the last run.
The idea of this RFE is to enable monitoring metrics returned by the SQL command in SQuirreL SQL. The ResultSet windows can be opened in separate windows, so there can be multiple windows tiled on the separate monitor.
The GUI idea is that next to the current icon Rerun will be input box for non negative integer value, which will allow insert number of seconds for Rerun following by click on Rerun icon. If there is 0, no automatic Rerun will be performed. If there is already Rerun in action, once the user change value back to 0 or close ResultSet window, no next Rerun will run, but in case non closing window, one next Rerun will be performed, because it is already scheduled for Rerun. If the user wants next Rerun, he has to change 0 no another number and click Rerun as during first usage.
If someone would think about persistence of default value of Rerun in seconds in Global Preferences, this case would have to solve the first activation of Rerun, otherwise after the first run of each and any command, this command would be always Reruned, which is, of course unwanted. Or, there could be default value, but Rerun has to be activated by the first click on it.
My idea is to be as simple as possible to implement it. So no sophisticated cron, scheduler... just in case of non 0 value fire start current Rerun with wait(N seconds) after (start if not running or end) of the last run at the beginning. The only thing, which I do not know, is how to handle situation, if the command is still running and Rerun should already start. This looks like not to implement "a) after the start of the last run (if not still running)" at all and implement only "b) after the end of the last run". This will also solve problem, how to distinguish between after the start and after the end in GUI. So finally, I vote for just only "after the end of the last run".
Thank You in advance, Stepan