Hey Guys,
I am attempting to develop an application for managing my company's workflow doing visual effects for the TV/film industry.
I have a few ruby on rails questions.
1. How can I create a new table in a database without using a migration? (I want to create a new table for every job we do - to keep track of all the versions of the effects and works in progress we do)
2. Is there anyway to browse directories/files on a server using rails?
Any help is greatly appreciated!
Cheers
Adam
Adam Teale wrote:
1. How can I create a new table in a database without using a migration?
SQL. Exact details depend on the RDBMS you are going to use.
(I want to create a new table for every job we do - to keep track of all the versions of the effects and works in progress we do)
This is not a really well thought out idea. The amount of JOINs, UNIONs this invites is nasty, not to mention that it will be an administrative nightmare (glossing over the performance issues this might incur in production).
That's what has_many, has_one, belongs_to, belongs_to_many, etc.. are for, Rails' (or rather ActiveRecord's) relationship methods. Yes, you can do that with the many, many tables you'll have, too, but every single table will need a controller at least, maybe even a model. Not to mention you'll end up having to inherit from a base class for the models. Not very DRY, and not very YAGNI, either.
Have fun maintaining the n+x controllers and possibly models, though.
2. Is there anyway to browse directories/files on a server using rails?
There should be. Ruby (the language Rails is written in) should allow for that, one way or another.
- -- Phillip Gawlowski Twitter: twitter.com/cynicalryan
~ I say, if your knees aren't green by the end of the day, you ought to seriously re-examine your life. -- Calvin
Hi Phillip!
Thanks for replying so quickly.
It's good to know so early on that I have the wrong approach to the tables! I'l read up on ActiveReord
Cheers!