class DbhelperController < ApplicationController
  def init
    puts "Hello World! This is a workaround!"
    CreateMovies.new.down
    CreateMovies.new.up
    AddMoreMovies.new.up
    puts "Movies have been added"
  end
end

class CreateMovies < ActiveRecord::Migration
  def up
    create_table :movies do |t|
      t.string :title
      t.string :rating
      t.text :description
      t.datetime :release_date
      # Add fields that let Rails automatically keep track
      # of when movies are added or modified:
      t.timestamps
    end
  end

  def down
    drop_table :movies
  end
end

class AddMoreMovies < ActiveRecord::Migration
  MORE_MOVIES = [
    {:title => 'Aladdin', :rating => 'G', :release_date => '25-Nov-1992'},
    {:title => 'The Terminator', :rating => 'R', :release_date => '26-Oct-1984'},
    {:title => 'When Harry Met Sally', :rating => 'R', :release_date => '21-Jul-1989'},
    {:title => 'The Help', :rating => 'PG-13', :release_date => '10-Aug-2011'},
    {:title => 'Chocolat', :rating => 'PG-13', :release_date => '5-Jan-2001'},
    {:title => 'Amelie', :rating => 'R', :release_date => '25-Apr-2001'},
    {:title => '2001: A Space Odyssey', :rating => 'G', :release_date => '6-Apr-1968'},
    {:title => 'The Incredibles', :rating => 'PG', :release_date => '5-Nov-2004'},
    {:title => 'Raiders of the Lost Ark', :rating => 'PG', :release_date => '12-Jun-1981'},
    {:title => 'Chicken Run', :rating => 'G', :release_date => '21-Jun-2000'},
  ]
  def up
    MORE_MOVIES.each do |movie|
      Movie.create!(movie)
    end
  end

  def down
    MORE_MOVIES.each do |movie|
      Movie.find_by_title_and_rating(movie[:title], movie[:rating]).destroy
    end
  end
end