1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
|
$ rails c
Loading development environment (Rails 3.2.2)
irb(main):001:0> p1 = Pin.create(:title => "Pokemon")
←[1m←[36m (0.0ms)←[0m ←[1mbegin transaction←[0m
←[1m←[35mSQL (37.0ms)←[0m INSERT INTO "pins" ("created_at", "title", "updated_at") VALUES (?, ?, ?) [["created_at", Fri, 27 Jul 2012 07:56:53 UTC +00:00], ["title", "Pokemon"], ["updated_at", Fri, 27 Jul 2012 0
7:56:53 UTC +00:00]]
←[1m←[36m (6.0ms)←[0m ←[1mcommit transaction←[0m
=> #<Pin id: 1, title: "Pokemon", created_at: "2012-07-27 07:56:53", updated_at: "2012-07-27 07:56:53">
irb(main):002:0> p2 = Pin.create(:title => "Yugiho")
←[1m←[35m (0.0ms)←[0m begin transaction
←[1m←[36mSQL (2.0ms)←[0m ←[1mINSERT INTO "pins" ("created_at", "title", "updated_at") VALUES (?, ?, ?)←[0m [["created_at", Fri, 27 Jul 2012 07:57:06 UTC +00:00], ["title", "Yugiho"], ["updated_at", Fri, 27 Jul
2012 07:57:06 UTC +00:00]]
←[1m←[35m (8.0ms)←[0m commit transaction
=> #<Pin id: 2, title: "Yugiho", created_at: "2012-07-27 07:57:06", updated_at: "2012-07-27 07:57:06">
irb(main):003:0> u = User.create()
←[1m←[36m (0.0ms)←[0m ←[1mbegin transaction←[0m
←[1m←[35mSQL (2.0ms)←[0m INSERT INTO "users" ("created_at", "updated_at") VALUES (?, ?) [["created_at", Fri, 27 Jul 2012 07:57:18 UTC +00:00], ["updated_at", Fri, 27 Jul 2012 07:57:18 UTC +00:00]]
←[1m←[36m (5.0ms)←[0m ←[1mcommit transaction←[0m
=> #<User id: 1, created_at: "2012-07-27 07:57:18", updated_at: "2012-07-27 07:57:18">
irb(main):004:0> u.user_has_pins.create(:pin_id => 1)
←[1m←[35m (0.0ms)←[0m begin transaction
←[1m←[36mSQL (1.0ms)←[0m ←[1mINSERT INTO "user_has_pins" ("created_at", "pin_id", "updated_at", "user_id") VALUES (?, ?, ?, ?)←[0m [["created_at", Fri, 27 Jul 2012 07:57:58 UTC +00:00], ["pin_id", 1], ["updated_at", Fri, 27 Jul 2012 07:57:58 UTC +00:00], ["user_id", 1]]
←[1m←[35m (4.0ms)←[0m commit transaction
=> #<UserHasPin id: 1, user_id: 1, pin_id: 1, created_at: "2012-07-27 07:57:58", updated_at: "2012-07-27 07:57:58">
irb(main):005:0> u.pins
←[1m←[36mPin Load (0.0ms)←[0m ←[1mSELECT "pins".* FROM "pins" INNER JOIN "user_has_pins" ON "pins"."id" = "user_has_pins"."pin_id" WHERE "user_has_pins"."user_id" = 1←[0m
=> [#<Pin id: 1, title: "Pokemon", created_at: "2012-07-27 07:56:53", updated_at: "2012-07-27 07:56:53">]
irb(main):006:0> p1.users
←[1m←[35mUser Load (1.0ms)←[0m SELECT "users".* FROM "users" INNER JOIN "user_has_pins" ON "users"."id" = "user_has_pins"."user_id" WHERE "user_has_pins"."pin_id" = 1
=> [#<User id: 1, created_at: "2012-07-27 07:57:18", updated_at: "2012-07-27 07:57:18">]
irb(main):007:0> p2.users
←[1m←[36mUser Load (1.0ms)←[0m ←[1mSELECT "users".* FROM "users" INNER JOIN "user_has_pins" ON "users"."id" = "user_has_pins"."user_id" WHERE "user_has_pins"."pin_id" = 2←[0m
=> [] |
Partager