Foreign Keys

[jValdron]

I Googled and search through the Git project, and couldn't find any information on foreign keys/constraints.

Isn't there anyway to do foreign keys in node-orm? I know some languages doesn't support it, such as MongoDB, but it'd be nice to have 'em for SQL languages. That was one of the key point why I switched back to MySQL from MongoDB.

[dresende]

I just move DDL to module node-sql-ddl-sync. Perhaps you could help me with that in that module.

[miguelcobain]

Does node-orm currently support Foreign Keys during the sync operation?
I can see that there is some code here to add foreign keys in this project: https://github.com/dresende/node-sql-ddl-sync

But I don't see it being used anywhere. What's the state of this?

Thanks.

[dxg]

Nope. If you need foreign keys, I recommend adding them via the migrations plugin
Foreign key support was added to sql-ddl-sync so that it can be used by the migration plugin. It's not used anywhere else.

[miguelcobain]

OK, makes sense. Thanks.

However, it shouldn't be too hard to add this to the sync feature, right?
The column is already created. The only thing missing is really just the foreign key. I'll try to take a look.

Thanks again. :)

[dxg]

Yeah, it should be possible to add some FK constraints to hasOne relationships and reflect this in the sync.