No foreign key after auto_upgrade!

[datamapper]

No foreign key after auto_upgrade!

[solnic]

Which foreign key?

by Piotr Solnica (solnic)

[solnic]

loaner_id and loanee_id.

by Siegfried Levin

[solnic]

@siegfried: Did you use DataMapper.finalize after declaring the models, but before running DataMapper.auto_upgrade! ? It is responsible for inferring the foreign keys and setting them up so that the migration will add them.

by Dan Kubb (dkubb)

[solnic]

@dkubb: I do use DataMapper.finalize.

by Siegfried Levin

[nicosalvo]

I'm experiencing the same problem using datamapper 1.2.0, any help well be appreciated.

[ksimard]

i am using 1.0.2 and i am also having foreign key issues. except my issue is that i added a :required => false flag and it is not dropping the foreign key constraint

i use finalize and auto_upgrade!

[dkubb]

@ksimard auto-upgrading is only additive, this means it only adds new tables, columns, indexes (and foreign keys someday). It will never remove or rename things. In DM2 we may have it make changes that we can determine are "safe", but otherwise in DM1 auto-upgrading will never change something that already exists.