Guest User

Untitled

a guest
May 22nd, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. Bookrack.rb
  2. has_many :faculties
  3.  
  4. Faculty.rb
  5. belongs_to :bookrack
  6. has_many :books
  7.  
  8. Book.rb
  9. belongs_to :faculty
  10. has_many :barcodes
  11.  
  12. Barcode.rb
  13. belongs_to :book
  14.  
  15. has_many :faculties
  16. has_many :books, through: :faculties
  17. has_many :barcodes, through: :books
  18.  
  19. Bookrack.find(1).barcodes.count
  20.  
  21. b = Bookrack.first.faculties.first.books.first.barcodes.count
  22.  
  23. # app/models/bookrack.rb
  24. has_many :faculties
  25.  
  26. # app/models/faculty.rb
  27. belongs_to :bookrack
  28. has_many :books
  29.  
  30. # app/models/book.rb
  31. belongs_to :faculty
  32. has_many :barcodes
  33.  
  34. # app/models/barcode.rb
  35. belongs_to :book
  36.  
  37. Bookrack.joins(faculties: [books: :barcodes]).count
  38. # => SELECT COUNT(*) FROM "bookracks"
  39. # INNER JOIN "faculties" ON "faculties"."bookrack_id" = "bookracks"."id"
  40. # INNER JOIN "books" ON "books"."faculty_id" = "faculties"."id"
  41. # INNER JOIN "barcodes" ON "barcodes"."book_id" = "books"."id"
  42. # => 1
Add Comment
Please, Sign In to add comment