Guest User

Untitled

a guest
Oct 10th, 2018
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.35 KB | None | 0 0
  1. mediaboxuser@mediabox:/media/share/extraspace/RoR/git/test_guru$ rails c
  2. Running via Spring preloader in process 5782
  3. Loading development environment (Rails 5.2.1)
  4. 2.5.1 :001 > user = User.find(2)
  5. User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 2], ["LIMIT", 1]]
  6. => #<User id: 2, user_class: 0, username: "first_nurd", password: "strong_pass", email: "first_nurd@gmail.com", created_at: "2018-10-10 20:34:09", updated_at: "2018-10-10 20:34:09">
  7. 2.5.1 :002 > user.test_by_level(0)
  8. Test Load (1.9ms) SELECT "tests".* FROM "tests" JOIN passing_tests ON passing_tests.test_id = tests.id WHERE (level = 0 AND user_id = 2) LIMIT ? [["LIMIT", 11]]
  9. => #<ActiveRecord::Relation [#<Test id: 1, title: "Kievan Rus", level: 0, created_at: "2018-10-10 20:33:46", updated_at: "2018-10-10 20:33:46", category_id: 1>]>
  10. 2.5.1 :003 > user.test_by_level(1)
  11. Test Load (1.0ms) SELECT "tests".* FROM "tests" JOIN passing_tests ON passing_tests.test_id = tests.id WHERE (level = 1 AND user_id = 2) LIMIT ? [["LIMIT", 11]]
  12. => #<ActiveRecord::Relation [#<Test id: 2, title: "Middle Ages", level: 1, created_at: "2018-10-10 20:33:46", updated_at: "2018-10-10 20:33:46", category_id: 1>]>
  13. 2.5.1 :004 > user.test_by_level(2)
  14. Test Load (1.3ms) SELECT "tests".* FROM "tests" JOIN passing_tests ON passing_tests.test_id = tests.id WHERE (level = 2 AND user_id = 2) LIMIT ? [["LIMIT", 11]]
  15. => #<ActiveRecord::Relation [#<Test id: 3, title: "Oscar Award", level: 2, created_at: "2018-10-10 20:33:47", updated_at: "2018-10-10 20:33:47", category_id: 2>]>
  16. 2.5.1 :005 > user = User.find(3)
  17. User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 3], ["LIMIT", 1]]
  18. => #<User id: 3, user_class: 0, username: "second_nurd", password: "more_strong_pass", email: "second_nurd@gmail.com", created_at: "2018-10-10 20:34:09", updated_at: "2018-10-10 20:34:09">
  19. 2.5.1 :006 > user.test_by_level(0)
  20. Test Load (1.4ms) SELECT "tests".* FROM "tests" JOIN passing_tests ON passing_tests.test_id = tests.id WHERE (level = 0 AND user_id = 3) LIMIT ? [["LIMIT", 11]]
  21. => #<ActiveRecord::Relation [#<Test id: 5, title: "World Cup", level: 0, created_at: "2018-10-10 20:33:47", updated_at: "2018-10-10 20:33:47", category_id: 3>]>
  22. 2.5.1 :007 > user.test_by_level(1)
  23. Test Load (1.4ms) SELECT "tests".* FROM "tests" JOIN passing_tests ON passing_tests.test_id = tests.id WHERE (level = 1 AND user_id = 3) LIMIT ? [["LIMIT", 11]]
  24. => #<ActiveRecord::Relation []>
  25. 2.5.1 :008 > user.test_by_level(2)
  26. Test Load (1.5ms) SELECT "tests".* FROM "tests" JOIN passing_tests ON passing_tests.test_id = tests.id WHERE (level = 2 AND user_id = 3) LIMIT ? [["LIMIT", 11]]
  27. => #<ActiveRecord::Relation [#<Test id: 3, title: "Oscar Award", level: 2, created_at: "2018-10-10 20:33:47", updated_at: "2018-10-10 20:33:47", category_id: 2>, #<Test id: 4, title: "International Cinema", level: 2, created_at: "2018-10-10 20:33:47", updated_at: "2018-10-10 20:33:47", category_id: 2>]>
  28. 2.5.1 :009 > user = User.find(4)
  29. User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 4], ["LIMIT", 1]]
  30. => #<User id: 4, user_class: 0, username: "third_nurd", password: "most_strong_pass", email: "third_nurd@gmail.com", created_at: "2018-10-10 20:34:09", updated_at: "2018-10-10 20:34:09">
  31. 2.5.1 :010 > user.test_by_level(0)
  32. Test Load (1.3ms) SELECT "tests".* FROM "tests" JOIN passing_tests ON passing_tests.test_id = tests.id WHERE (level = 0 AND user_id = 4) LIMIT ? [["LIMIT", 11]]
  33. => #<ActiveRecord::Relation [#<Test id: 5, title: "World Cup", level: 0, created_at: "2018-10-10 20:33:47", updated_at: "2018-10-10 20:33:47", category_id: 3>, #<Test id: 1, title: "Kievan Rus", level: 0, created_at: "2018-10-10 20:33:46", updated_at: "2018-10-10 20:33:46", category_id: 1>]>
  34. 2.5.1 :011 > user.test_by_level(1)
  35. Test Load (1.3ms) SELECT "tests".* FROM "tests" JOIN passing_tests ON passing_tests.test_id = tests.id WHERE (level = 1 AND user_id = 4) LIMIT ? [["LIMIT", 11]]
  36. => #<ActiveRecord::Relation [#<Test id: 6, title: "Supporters", level: 1, created_at: "2018-10-10 20:33:47", updated_at: "2018-10-10 20:33:47", category_id: 3>]>
  37. 2.5.1 :012 > user.test_by_level(2)
  38. Test Load (1.1ms) SELECT "tests".* FROM "tests" JOIN passing_tests ON passing_tests.test_id = tests.id WHERE (level = 2 AND user_id = 4) LIMIT ? [["LIMIT", 11]]
  39. => #<ActiveRecord::Relation []>
  40. 2.5.1 :013 >
Add Comment
Please, Sign In to add comment