namespace :db do
  namespace :test do
    task :prepare do |t|
      ActiveRecord::Migration.execute <<EOS
    CREATE VIEW patch_view AS SELECT patches.*, programs.name AS program_name, pv.id AS patch_version_id, pv.for_upstream_version, pv.comment FROM patch_versions pv JOIN (patches JOIN programs ON patches.program_id = programs.id) ON pv.patch_id = patches.id WHERE pv.id = (SELECT id FROM patch_versions WHERE patch_id = pv.patch_id ORDER BY pv.created_at DESC LIMIT 1);
EOS
    end
  end
end