Radio Bantik:
Days in the Life of an Alpha Geek

I needed to update an attribute on a bunch of records today. In the model, there’s a before save condition that generates a permalink based on the record’s name. So in script/console, I populated an array with Location.all, iterated over the array, and called save(false) on each. The operation was taking a while, so I hopped over to CocoaMySQL to monitor the progress of the operation.

While I waited, I wrote a little SQL query to calculate the progress of the operation:

select (select count(*) from locations where url is null) as unprocessed, (select count(*) from locations where url is not null) as processed, (((select processed / (unprocessed + processed)) * 100)) as "% complete";

Sample output:

Nothing terribly complex, but cool and generally useful.

This entry was posted on Monday, December 22nd, 2008 at 6:57 pm and is filed under Ruby on Rails. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.