This project has moved and is read-only. For the latest updates, please go here.

Feature: Status Bar Displaying Currently Executing Script and Timers

Jan 30, 2014 at 4:06 PM
Hi,

I love this app and have a few feature ideas that would make it totally awesome. Would it be possible to add a bottom status bar that displays the current executing script, script executing time, and total executing time?

Thanks!
Jan 30, 2014 at 9:00 PM
Great (and easy to implement) suggestion! I've updated the app to show the progress as it runs through the scripts. Checkout v1.3.2 which I just posted. Thanks :)
Jan 30, 2014 at 9:55 PM
Thank you! That was quick! Looks good. Is there a way to add a live timer outside the log window, so we can see it's currently executing?

Additionally, the log output seems to be duplicated when all scripts completed. I like to copy/paste this, so when there are lots of scripts, it can get confusing. It would be nice if it wasn't repeated and contained the timings for each script


Current log:
Connection Info: Data Source=CONNSTRING;
=================================================================
All Script Summaries (in the order that the scripts were ran)
=================================================================

C:\Users\g1joe\Desktop\tst\1_delay.sql: Success
C:\Users\g1joe\Desktop\tst\2_delay - Copy.sql: Success
C:\Users\g1joe\Desktop\tst\2_delay.sql: Success
Processing 4 of 4 at 4:45:16 PM: 4_delay - Copy.sql...
Started running at 4:45:07 PM. Has been running for 9 seconds...Connection Info: Data Source=CONNSTRING;
=================================================================
All Script Summaries (in the order that the scripts were ran)
=================================================================

C:\Users\g1joe\Desktop\tst\1_delay.sql: Success
C:\Users\g1joe\Desktop\tst\2_delay - Copy.sql: Success
C:\Users\g1joe\Desktop\tst\2_delay.sql: Success
C:\Users\g1joe\Desktop\tst\4_delay - Copy.sql: Success

======================= Condensed Run Summary ========================
4 / 4 scripts ran successfully.
Time it took to run all sql scripts: 12 seconds.
Cleaner log:
Connection Info: Data Source=CONNSTRING;
=================================================================
All Script Summaries (in the order that the scripts were ran)
=================================================================
Started running at 4:52:45 PM. 
C:\Users\g1joe\Desktop\tst\1_delay.sql: Success
C:\Users\g1joe\Desktop\tst\2_delay - Copy.sql: Success
C:\Users\g1joe\Desktop\tst\2_delay.sql: Success
C:\Users\g1joe\Desktop\tst\4_delay - Copy.sql: Success
Fnished running at 4:52:57 PM. 

======================= Condensed Run Summary ========================
4 / 4 scripts ran successfully.
Time it took to run all sql scripts: 12 seconds.
Jan 30, 2014 at 10:01 PM
Bah, I believe it's a race condition duplicating the output, as everything showed normal for me :( Ok, I'll take another look and get it fixed up in the next day or two.
Jan 30, 2014 at 11:12 PM
Ok, turns out it was just a type causing the output to be duplicated and I never noticed in my testing :P

I've changed things up and implemented a status bar like you originally proposed; it feels a little cleaner. Give v1.3.3 a try and let me know if it's what you were looking for.
Marked as answer by deadlydog on 1/30/2014 at 3:12 PM
Feb 13, 2014 at 8:08 PM
Edited Feb 13, 2014 at 8:08 PM
Looks nice! I have some GUI suggestions for the status bar, the default text and colors, but it's not important and this does exactly what I need

Thank you!