[chef] resource in a ruby_block?

[Jeremy Winters < >]

I'm looking to do something like this...


ruby_block "do something doing convergence" do
        block do
                check_value=result_from_database_at_convergence_run_time
        
                if check_value==0 then
                        execute "run my sql script" do
                                cwd "path_to_script"
                                user "root"
                                command "./execute_sql_file.rb"
                        end
                end
        end
        only_if do primary_idempotent_condition==true end
end

is this possible?  am I missing something?

Jeremy Winters
212-202-0449 x1023