Ruby: Inserting records to existing rails database using non-rails script

Question

I have a rails app that only allows users to search and view the contents of its (MySQL) database. To add records to the database, I'd like to run a ruby script automatically twice a day which generates the contents of the database and then updates the db. Is this possible, or does my script have to be a part of the rails web app?

Do you need to go through the app's models to do some INSERTs into MySQL or can you connect directly to the database? — mu is too short
– mu is too short, Commented Jun 8, 2018 at 19:33

Daryll Santos · Accepted Answer · 2018-06-08 18:14:03Z

2

Just to lead you in the right direction - you can use a Rake task for this. These are usually put in the lib/tasks directory.

It's a good idea to separate non-web related things such as seeding or updating a database. If this is a scheduled job, you can use whenever to hook the rake task to cron.

answered Jun 8, 2018 at 18:14

Daryll Santos

2,0613 gold badges23 silver badges42 bronze badges

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

Comments

Dan Sweeney · Accepted Answer · 2018-06-09 01:06:49Z

0

Solved this using rails runner command

answered Jun 9, 2018 at 1:06

Dan Sweeney

631 silver badge5 bronze badges

Collectives™ on Stack Overflow

Ruby: Inserting records to existing rails database using non-rails script

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