Rails rake task to run arbitrary sql scripts in repo.

runsql.rake

namespace :dbrun do
  namespace :functions do
    app_root = Rails.application.config.root
    sql_functions_path = File.join(app_root, "db", "functions")
    sql_functions_glob_path = File.join(sql_functions_path, "*.sql")

    ActiveRecord::Base.configurations = YAML.load(File.read(File.join(app_root, 'config', 'database.yml')))
    ActiveRecord::Base.establish_connection (ENV['ENV'] || 'development').to_sym

    Dir.glob(sql_functions_glob_path) do |file|
      desc "Run #{file}."
      task File.basename(file, ".*").to_sym do
        path = File.join(sql_functions_path, File.basename(file))
        ActiveRecord::Base.connection.execute(File.read(path))
      end
    end
  end
end