Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mediaboxuser@mediabox:/media/share/extraspace/RoR/git/test_guru$ rails c
- Running via Spring preloader in process 5782
- Loading development environment (Rails 5.2.1)
- 2.5.1 :001 > user = User.find(2)
- User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 2], ["LIMIT", 1]]
- => #<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">
- 2.5.1 :002 > user.test_by_level(0)
- 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]]
- => #<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>]>
- 2.5.1 :003 > user.test_by_level(1)
- 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]]
- => #<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>]>
- 2.5.1 :004 > user.test_by_level(2)
- 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]]
- => #<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>]>
- 2.5.1 :005 > user = User.find(3)
- User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 3], ["LIMIT", 1]]
- => #<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">
- 2.5.1 :006 > user.test_by_level(0)
- 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]]
- => #<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>]>
- 2.5.1 :007 > user.test_by_level(1)
- 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]]
- => #<ActiveRecord::Relation []>
- 2.5.1 :008 > user.test_by_level(2)
- 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]]
- => #<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>]>
- 2.5.1 :009 > user = User.find(4)
- User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 4], ["LIMIT", 1]]
- => #<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">
- 2.5.1 :010 > user.test_by_level(0)
- 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]]
- => #<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>]>
- 2.5.1 :011 > user.test_by_level(1)
- 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]]
- => #<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>]>
- 2.5.1 :012 > user.test_by_level(2)
- 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]]
- => #<ActiveRecord::Relation []>
- 2.5.1 :013 >
Add Comment
Please, Sign In to add comment