SQLAlchemy generator does not handle unidirectional associations

[gwendal-jouneaux]

Describe the bug

The SQLAlchemy generator transform unidirectional associations to bidirectional associations

To Reproduce

1. Create any model with a unidirectional association
2. Generate SQLAlchemy code
3. The generated code transformed the unidirectional relation to a bidirectional one

Expected behavior

No back population nor inverse relation created for this association

Screenshots

[jcabot]

Well, in "pure" SQL, navigability is not a factor and foreign keys are added to the class where it makes sense based on the cardinality. Should this be really different in SQLAlchemy?

[ivan-alfonso]

We could update the generator to remove the relationship (last line in the code above) when the navigability is False. This would keep the Foreign Key in the Pet table, ensuring it’s still associated with a Person, but Pet wouldn’t be able to directly access Person. This is possible in SQLAlchemy