Using t.references does not update schema.rb about foreigner HOT 6 CLOSED

Looks like this will require updating SchemaDumper, and adding a means to get foreign keys out of the db in the MySql connection adapter. I'd mark this as a feature request, but there doesn't appear to be a way to do so.

from foreigner.

I'd like to get this working. Reading foreign keys out of a MySql database is a bit tricky, but it seems like it can be done.

from foreigner.

You can get the basics with:
select
k.referenced_table_name as 'parent',
k.table_name as 'child' ,
k.column_name as 'column',
k.constraint_name as 'constraint_name'
from information_schema.key_column_usage k
where k.referenced_column_name is not null
and k.table_schema = '[database_name]';

However, how do you get the 'ON DELETE' information?

from foreigner.

I discovered that in MySql 5.1, the ON DELETE information will be contained in the information_schema. In the meantime, it looks like the only solution is to run "show create table [table_name]" and parse out the foreign keys.

from foreigner.

I added support for this. I feel like it's a bit hairy, but it should work for most standard installations of MySql.

from foreigner.

Closing

from foreigner.