How to add one integer to a feature in a rails data set using the rails console

Question

I have a database full of some information, but I need to go into the rails console and add one integer to a specific data set in my local database.

I have a column named times_used, within that column I need to add one more integer into it.

I've tried,

p.update_attribute(:times_used, add: 1)
p.update_attribute(:times_used, add: :1)
p.update_attribute(:times_used, add: [:1])
p.update_attribute(:times_used, + 1)
p.update_attribute(:times_used) + 1

I'm wondering, what I am trying to do, is possible? Do I need to loop through these? Much thanks to anybody for taking a quick look at this.

Mike Desjardins · Accepted Answer · 2015-12-01 20:24:54Z

2

You can do something like this:

MyModel.where(id: 1).update_all('times_used = times_used + 1')

answered Dec 1, 2015 at 20:24

Mike Desjardins

4604 silver badges10 bronze badges

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

1 Comment

kdweber89 Over a year ago

Thank you very much, I like how your approach allows you to make changes to everything, and also individual elements as well.

fltiago · Accepted Answer · 2015-12-01 20:29:15Z

1

You can use the increment! method, take a look: http://apidock.com/rails/ActiveRecord/Base/increment!

//would be something like
p.increment!(:times_used)

answered Dec 1, 2015 at 20:29

fltiago

1787 bronze badges

Collectives™ on Stack Overflow

How to add one integer to a feature in a rails data set using the rails console

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related