I have the following tables: Workstation and Parameters.
I want to associate the Workstation with the Parameters, using a WorkstationParameter table that also contains the value of the parameter, using SQLAlchemy.
Is there any way that when getting a workstation from the database, all the parameters come with it? Currently I have {"name": "workstation", "id": 1}. I added the association using WorkstationParameter but I don't know if it is correct because I was expecting to get {"parameters": [], "name": "workstation", "id": 1}
I tried to replicate this: https://docs.sqlalchemy.org/en/20/orm/basic_relationships.html#association-object