python - Calling another table by using id flask

Question

Im new on flask and im wondering if its possible to call an item through item code like for example

items_name 

item_code    item_name
______________________
BOLT-001     BOLT 20mm
BOLT-002     BOLT 12mm

and out table like

items
item code   item qty
______________________
BOLT-001    20

how to print something like

BOLT 20mm x 20pcs

in laravel it would be like

->join('items_name','items.item_code','items_name.item_code')

but how to do it in flask?

question from:https://stackoverflow.com/questions/65841660/calling-another-table-by-using-id-flask

Answer 1

i've finally found the answer it appears that i have to add

on items_name model:

any = db.relationship('items', backref='item_name', lazy=True)

and on items model :

item_code= db.Column(db.String,db.ForeignKey('item_name.name')