Ruby on Rails 3: increment value using sql

Question

I'm doign a voting application and I need to update votes count for this I want to use update SQL, because in other cases voices may be lost (AR generates update statement with value, but what if previous request already incremented column value?).

Ho do I do that?

arnep · Accepted Answer · 2011-09-21 07:28:27Z

2

You can use increment_counter which does a direct update in the database without caring about the actual value of your Active Record contents:

Vote.increment_counter :vote_value, 5

answered Sep 21, 2011 at 7:28

arnep

6,3213 gold badges40 silver badges56 bronze badges

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

Comments

taro · Accepted Answer · 2011-09-21 07:24:31Z

0

Try something like:

Movie.update_counters id, :like_count => 1

answered Sep 21, 2011 at 7:24

taro

5,8502 gold badges33 silver badges34 bronze badges

Collectives™ on Stack Overflow

Ruby on Rails 3: increment value using sql

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