Create a new Rails app with an existing mysql Database

Question

I have an existing mysql database set up, and would like to set up a new rails up simply so my client can view and edit the records in the db. How can I set up a scaffold linked to my existing db. The db name is "Products" and has just one table called "pins".

Pins tables:

+----------------+---------------+------+-----+---------+----------------+
| Field          | Type          | Null | Key | Default | Extra          |
+----------------+---------------+------+-----+---------+----------------+
| id             | int(11)       | NO   | PRI | NULL    | auto_increment |
| type           | text          | YES  |     | NULL    |                |
| title          | text          | YES  |     | NULL    |                |
| description    | text          | YES  |     | NULL    |                |
| price          | text          | YES  |     | NULL    |                |
| img_src        | text          | YES  |     | NULL    |                |
| source         | text          | YES  |     | NULL    |                |
| sr_id          | text          | YES  |     | NULL    |                |
| category       | varchar(1000) | YES  |     | NULL    |                |
| pinner         | text          | YES  |     | NULL    |                |
| pinner_id      | text          | YES  |     | NULL    |                |
| board_cat      | text          | YES  |     | NULL    |                |
| board_name     | text          | YES  |     | NULL    |                |
| board_url      | text          | YES  |     | NULL    |                |
| like_count     | bigint(20)    | YES  |     | NULL    |                |
| repins_count   | bigint(20)    | YES  |     | NULL    |                |
| comments_count | bigint(20)    | YES  |     | NULL    |                |
| pinned_count   | bigint(20)    | YES  |     | NULL    |                |
| actions_count  | bigint(20)    | YES  |     | NULL    |                |
| error_404      | bigint(20)    | YES  |     | NULL    |                |
| pin_at         | text          | YES  |     | NULL    |                |
| social_rank    | bigint(20)    | YES  |     | NULL    |                |
| created_at     | text          | NO   |     | NULL    |                |
| updated_at     | text          | NO   |     | NULL    |                |
| isgiftable     | int(11)       | YES  |     | NULL    |                |
| sr_id_int      | bigint(20)    | YES  |     | NULL    |                |
+----------------+---------------+------+-----+---------+----------------+

What does the output of describe pins; in the mysql console look like? — Brian
– Brian, Commented Jun 13, 2012 at 23:55
If you are looking for a low hassle quickie solution, you may want to try either github.com/sferik/rails_admin or activeadmin.info . But, not sure how that type column is going to behave. — Brian
– Brian, Commented Jun 14, 2012 at 0:10

x1a4 · Accepted Answer · 2012-06-13 23:22:24Z

1

You can set the database name in config/database.yml. You'll want to have a Pin model which will map to the correct table automatically. The fields in the database will map to attributes in the model automatically, though you may need to write some glue if the names of the fields are wonky.

It's hard to give more advice than this without more info.

answered Jun 13, 2012 at 23:22

x1a4

19.5k5 gold badges42 silver badges40 bronze badges

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

6 Comments

Yogzzz Over a year ago

Is there anything that I need to explicitly state in my model? After configuring the database in my yml file, do I just run a migration? or should I do a schema dump and a seed load then a migration? Thanks!

x1a4 Over a year ago

If your database and table already have data in them, you don't need to migrate or seed. Migrations are for changing the database schema (adding/removing columns or tables, adding indexes, etc.) and seeding is for adding in initial data that your app might expect to already exist.

Brian Over a year ago

I get the impression Yogi is looking to scaffold the whole thing (e.g. controllers, views etc).

Yogzzz Over a year ago

Yeah, I was hoping to scaffold the whole thing...however the gems you suggested look really interesting.

Brian Over a year ago

I hope it works out for you. They can be a bit testy which is why I prefer not to use them, but if quick & dirty is your goal - march forward!

|

Max Scheiber · Accepted Answer · 2012-06-14 01:03:08Z

1

All you have to do is open up config/database.yml and adjust the development / production database information to the one you're already using. Assuming that your models and migrations point to tables with identical names, you shouldn't have to change anything else in your program.

answered Jun 14, 2012 at 1:03

Max Scheiber

1731 silver badge9 bronze badges

Comments

Taryn · Accepted Answer · 2013-05-27 16:54:42Z

1

Did you try to use the database.yml of your project on the newer one that you're creating? Doing that and keeping the same class names in the newer project may work.

edited May 27, 2013 at 16:54

Taryn

249k57 gold badges374 silver badges409 bronze badges

answered Jun 13, 2012 at 23:25

David

3881 silver badge14 bronze badges

Collectives™ on Stack Overflow

Create a new Rails app with an existing mysql Database

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related