Newbie questions - create table and file browser?

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

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!

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Adam T. 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 G.
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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEUEARECAAYFAkgFc0MACgkQbtAgaoJTgL8jhwCXfaSz6TwCYDPFdRnPETDsIsdm
0gCgp7nDTTEmnYqruYQM9uSkKeR9rH4=
=QGaI
-----END PGP SIGNATURE-----

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs