Ruby on Rails: Insert into database from the terminal

Question

I'm trying to insert some options into the database using the terminal since there's no real admin for these options as they'll never change. I'm trying to use the following command

o = MeasurementOption.new(:name => 'Lbs', measurement_type_id => '3')

and I get the following error

syntax error near unexpected token `('

I'm looking at examples, and it seems like I have the syntax correct.

cordsen · Accepted Answer · 2011-06-29 20:29:01Z

3

I think you are missing a colon

o = MeasurementOption.new(:name => 'Lbs', :measurement_type_id => '3')
                                          ^

answered Jun 29, 2011 at 20:29

cordsen

1,69112 silver badges10 bronze badges

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

1 Comment

Michael Durrant Over a year ago

You may also want to consider putting this in your db/seeds.rb file. That way it'll automatically be created wherever you created the app. I didn't know about this useful option when I was first learning rails. You just put the statements you want (including save) in that file and then they become part of the db:drop db:create db:migrate db:seeds process.

ardavis · Accepted Answer · 2011-06-29 23:41:16Z

1

The new standard way of doing this would be to lose the =>. It would be best to get into the Rails Way of doing it this way:

o = MeasurementOption.new(name: 'Lbs', measurement_type_id: '3')

Also, if you are adding some static values that will never change, it would hurt to create these in your seeds file.

Go to db/seeds.rb and add

o = MeasurementOption.create!(name: 'Lbs', measurement_type_id: 3)

Then you can also use o' later in the seeds file if you needed, like:

duplicate_option = o

Then whenever you wish to seed your database, you would simply call rake db:seed. This way you won't have to create that static MeasurementOption each time you need to reset your database.

answered Jun 29, 2011 at 23:41

ardavis

9,92513 gold badges63 silver badges113 bronze badges

Collectives™ on Stack Overflow

Ruby on Rails: Insert into database from the terminal

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