Evan Weaver on 24 Jan 2008 08:49:17 -0800


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PhillyOnRails] ActiveRecord: updating a single attribute

  • From: "Evan Weaver" <evan@cloudbur.st>
  • To: talk@phillyonrails.org
  • Subject: Re: [PhillyOnRails] ActiveRecord: updating a single attribute
  • Date: Thu, 24 Jan 2008 11:48:00 -0500
  • Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; bh=0g5olKsW4NF3qpE4UUSAO8eOC+QXRAABdZlV6vq+CAw=; b=HHOEsiYRBuEpEDkesfsduNn/ROViZrOw2iEZmk2v5qPNYNqb6LDOY8sQ0AABPzSP62tsSj8QaJIxVufuBPlQhEOszd24+vSYwxrRccJil4MjpxVePINvCyuvSeuZk1uo+3hLmJoKesEH0thc7b/igOv1vmr0irX52zS18SNnW3s=
  • List-archive: <http://lists.phillyonrails.org/pipermail/talk>
  • Reply-to: talk@phillyonrails.org
  • Sender: talk-bounces@phillyonrails.org

You can't enforce validations if you don't resave every attribute every time.

Evan

On Jan 24, 2008 12:33 PM, Chris Cera <chris@cera.us> wrote:
> Hi everyone,
>
> Is there a way to update just one attribute of a record without
> causing all the attributes to be re-set?  When I use the
> update_attribute() or increment(), since they call save() it
> causes every attribute to get re-set.  I verified this in the
> mysql 'General Query Log'.  Example:
>     item.update_attribute(:normal_views, item.normal_views + 1)
>
> I feel that there must be a more elegant solution than this:
>     sql = 'UPDATE documents SET normal_views = normal_views + 1 WHERE id = ' + item.id.to_s
>     ActiveRecord::Base.connection.update(sql)
>
> Any suggestions are greatly appreciated.  Thank you, -Chris
>
> ref: http://api.rubyonrails.org/classes/ActiveRecord/Base.html
>
> --
> Christopher D. Cera
> CTO, Hovitate LLC
> http://vuzit.com
> P: 215.435.2289
> F: 267.295.7369
> _______________________________________________
> To unsubscribe or change your settings, visit:
> http://lists.phillyonrails.org/mailman/listinfo/talk
>



-- 
Evan Weaver
Cloudburst, LLC
_______________________________________________
To unsubscribe or change your settings, visit:
http://lists.phillyonrails.org/mailman/listinfo/talk