tempfile_put_method.rb

require 'tempfile'  

file_contents = <<-EOB
---
production:
  database:  example
  usernname: test
  password:  #{password}
  host:      localhost
EOB

task :put_database_config, :roles => [:db], :only => {:primary => true} do
  password = Capistrano::CLI.ui.ask "Give me a database password: "
  TempFile.new do |tf|
    tf.puts file_contents
    put(tf, "#{release_path}/config/database.yml")
  end
end