Thursday, January 19, 2006

I prefer Rake to NAnt (#3)

I prefer Ruby's multi-threading to NAnt's lack of.
The current application I'm working on has lots of data. With every build we drop, create, and reload the objects in the database. The drop and create sql must be executed first, but the loading scripts can be run in parallel. Ruby makes this easy with the Thread class in the Core API.
task "setup_db" do
tasker =

#execute in parallel
threads = []
threads << { tasker.execute_osql("dummy_data1.sql") }
threads << { tasker.execute_osql("dummy_data2.sql") }
threads << { tasker.execute_osql("dummy_data3.sql") }
threads << { tasker.execute_osql("dummy_data4.sql") }
threads << { tasker.execute_osql("dummy_data5.sql") }

#join threads
while ( t = threads.shift ) ; t.join ; end
*DbTasks is simple class that contains common information (login info). The DbTasks.execute_osql method is just a wrapper for executing osql as a system command with DbTasks' static information.

**As usual, there may be a better way in Ruby. And, there may be multi-threading options in NAnt that I'm not aware of.

1 comment:

  1. Anonymous2:31 PM

    You might want to check out the new multitask feature in Rake 0.7.0. It allows you to rewrite the above with:

    Tasker =

    task :drop_and_create do

    SubTasks = (1..5).collect { |i|
      task "load#{i}" => :drop_and_create do

    multitask :setup_db => SubTasks

    -- Jim Weirich


Note: Only a member of this blog may post a comment.