ROUTE.PY
This is an example delete clause:
db.session.query(AssetClass).filter(AssetClass.asset_class_id==asset_class_id).delete(synchronize_session='fetch')
MODEL.PY
This is the database change for the foreign key. You add it to each model.
Ticker Class:
asset_class_id = db.Column(db.Integer, db.ForeignKey('asset_class.asset_class_id'), nullable=False)
Asset Class
tickers = db.relationship('Ticker', backref='tickers', lazy=True)
Database Create
In your database table for ticker, you will make a foreign key relationship.
The foreign key name can be whatever. You select the asset_class table as the referenced table. Then you select reference the asset_class_id in both tables. Make sure you select On Update Cascade, and On Delete Cascade.
