Rails generates incomplete schema


#1

Is it possible to get the generated schema.rb to include accurately
reflect your database’s schema?

For example, when using usesguid plugin, we change the primary key
from id, int(11), autoincrement to say, guid, varchar(22)

The schema file picks up the change of id to guid, but not the type.
So when the test DB is created from schema.rb, the guid column is int
(11) autoincrement. This causes havoc with unit tests and does not
accurately depict the production environment.

How do people deal with this? It’s driving me crazy.

Similarly, adding a new column as integer autoincrement that is not
the primary key is also not reflected in schema.rb and completely
breaks fixtures.

Any help would be appreciated,

Thanks,
=Blair.


#2

Apparently config.active_record.schema_format = :sql in environment.rb
was the trick I was looking for.

Not very obvious. Not obvious that your test DB schema will be
different than your dev/prod schema should you start putting weird
stuff in your migrations.

=Blair.