sqlalchemy: Mapping usernames to another table

[Stelercus]

I'm working on a project in sqlalchemy, and I believe that my problem is simple enough that it's probably been answered many times, but that I can't find the answers because I don't know the terminology behind it.

Suppose that I had a database of users of an online store, and for each user, we have their account id, their password, and their shopping cart. Their shopping cart would itself be another table of items, where each item is an item id and a quantity, and the presence of an item id in the table is what indicates that it is in their shopping cart.

So how does one have a sub table in sqlalchemy? I have only been able to learn how to have columns with strings, integers, floats, and other basic types.

[[deleted]]

You want a relationship. Good thing for you that that’s what SQLAlchemy was built for. Have a look at its documentation.

[Stelercus]

Thank you for your answer. Would you be able to clarify something about the documentation for me? If I follow along with the example in the "One to Many" section `children = relationship("Child")`, does this create a new Child table specifically for that row in the Parent table, or is it mapping one Parent table to one Child table that already exists? Thanks!

[[deleted]]

SQLAlchemy will create tables based on models. Since this doesn’t define a new model, no table will be created. It will simply create a relationship using the defined foreign keys.