Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Activerecord1.rb

By: drollwit on May 4th, 2012  |  syntax: Ruby  |  size: 1.12 KB  |  hits: 23  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
This paste has a previous version, view the difference. Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. ####  Create
  2. starwars = Movie.create!(:title => 'Star Wars',
  3.   :release_date => '25/4/1977', :rating => 'PG')
  4. # note that numerical dates follow European format: dd/mm/yyyy
  5. requiem =  Movie.create!(:title => 'Requiem for a Dream',
  6.   :release_date => 'Oct 27, 2000', :rating => 'R')
  7. #  Creation using separate 'save' method, used when updating existing records
  8. field = Movie.new(:title => 'Field of Dreams',
  9.   :release_date => '21-Apr-89', :rating => 'PG')
  10. field.save!
  11. field.title = 'New Field of Dreams'
  12. ####  Read
  13. pg_movies = Movie.where("rating = 'PG'")
  14. ancient_movies = Movie.where('release_date < :cutoff and rating = :rating',
  15.   :cutoff => 'Jan 1, 2000', :rating => 'PG')
  16. pg_movies_2 = Movie.find_by_rating('PG')
  17. Movie.find(3)  # exception if key not found; find_by_id returns nil instead
  18. ####  Update
  19. starwars.update_attributes(:description => 'The best space western EVER',
  20.   :release_date => '25/5/1977')
  21. requiem.rating = 'NC-17'
  22. requiem.save!
  23. ####  Delete
  24. requiem.destroy
  25. Movie.where('title = "Requiem for a Dream"')
  26. ####  Find returns an enumerable
  27. Movie.find_all_by_rating('PG').each do |mov|
  28.   mov.destroy
  29. end
create a new version of this paste RAW Paste Data