Skip to content

Instantly share code, notes, and snippets.

@tongueroo
Created November 27, 2008 01:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tongueroo/29662 to your computer and use it in GitHub Desktop.
Save tongueroo/29662 to your computer and use it in GitHub Desktop.
irb(main):001:0> p = Page.get(2)
~ SELECT "id", "name", "permalink", "created_at", "updated_at" FROM "pages" WHERE ("id" = 2) ORDER BY "id" LIMIT 1
=> #<Page id=2 name="new name2" permalink="tung" body=<not loaded> created_at=#<DateTime: 23565855547/9600,-1/3,2299161> updated_at=#<DateTime: 26511813857/10800,-1/3,2299161>>
irb(main):002:0> p.update_attributes('name' => 'new name3', 'body' => 'new body3')
~ SELECT "body", "id", "name", "permalink", "created_at", "updated_at" FROM "pages" WHERE ("id" = 2) ORDER BY "id"
~ SELECT "id" FROM "pages" WHERE ("name" = 'new name2') ORDER BY "id" LIMIT 1
~ SELECT "id" FROM "pages" WHERE ("permalink" = 'tung') ORDER BY "id" LIMIT 1
=> true
irb(main):003:0> p.reload
~ SELECT "body", "id", "name", "permalink", "created_at", "updated_at" FROM "pages" WHERE ("id" IN (2)) ORDER BY "id"
=> #<Page id=2 name="new name2" permalink="tung" body="new body3" created_at=#<DateTime: 23565855547/9600,-1/3,2299161> updated_at=#<DateTime: 26511813857/10800,-1/3,2299161>>
irb(main):004:0> p.name
=> "new name2"
irb(main):005:0> p.body
=> "new body3"
irb(main):006:0> p = Page.get(2)
~ SELECT "id", "name", "permalink", "created_at", "updated_at" FROM "pages" WHERE ("id" = 2) ORDER BY "id" LIMIT 1
=> #<Page id=2 name="new name2" permalink="tung" body=<not loaded> created_at=#<DateTime: 23565855547/9600,-1/3,2299161> updated_at=#<DateTime: 26511813857/10800,-1/3,2299161>>
irb(main):007:0> p.update_attributes(:name => 'new name4', :body => 'new body4')
~ SELECT "body", "id", "name", "permalink", "created_at", "updated_at" FROM "pages" WHERE ("id" = 2) ORDER BY "id"
~ SELECT "id" FROM "pages" WHERE ("name" = 'new name4') ORDER BY "id" LIMIT 1
~ SELECT "id" FROM "pages" WHERE ("permalink" = 'tung') ORDER BY "id" LIMIT 1
~ UPDATE "pages" SET "body" = 'new body4', "name" = 'new name4', "updated_at" = '2008-11-26T17:56:46-08:00' WHERE ("id" = 2)
=> true
irb(main):008:0> p.reload
~ SELECT "body", "id", "name", "permalink", "created_at", "updated_at" FROM "pages" WHERE ("id" IN (2)) ORDER BY "id"
=> #<Page id=2 name="new name4" permalink="tung" body="new body4" created_at=#<DateTime: 23565855547/9600,-1/3,2299161> updated_at=#<DateTime: 106047255503/43200,-1/3,2299161>>
irb(main):009:0> p.name
=> "new name4"
irb(main):010:0> p.body
=> "new body4"
irb(main):011:0>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment