updating boolean attributes in postgresql from rails

Question

I have a simple statement like this:

@employee.update_attributes(:subscribed=>false)

but this is not updating the boolean column field subscribed. It throws a warning saying:

WARNING: Can't mass-assign these protected attributes: subscribed

François Beausoleil · Accepted Answer · 2010-08-03 15:05:31Z

3

I would suggest using #update_attribute, not #update_attributes. #update_attribute (singular) accepts two parameters: the attribute name and the value. This is intended for flipping booleans, or updating single values. The semantics of #update_attribute also mean that callbacks won't be fired.

From your code, it's a simple change:

@employee.update_attribute(:subscribed, false)

Now, for the real reason why your code is failing is because you have someplace where you're using #attr_accessible or #attr_protected in your Employee model. Using #attr_accessible helps prevent injection attacks by only allowing certain fields to be assignable from #attributes= (which is what #update_attributes ultimately calls). The warning originates from #attributes=.

answered Aug 3, 2010 at 15:05

François Beausoleil

16.6k11 gold badges71 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Patrick · Accepted Answer · 2010-08-03 04:26:43Z

1

needed attr_accessible :subscribed >_<

answered Aug 3, 2010 at 4:26

Patrick

4752 gold badges6 silver badges16 bronze badges

Collectives™ on Stack Overflow

updating boolean attributes in postgresql from rails

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related