filter_by(...).update(...) is not working in inheritance

[Shiny380]

filter_by(...).update(...) is not working in inheritance
I think I might know the problem with this.
https://hackersandslackers.com/database-queries-sqlalchemy-orm/#:~:text=Unlike%20filter()%20%2C%20filter_by(),match%20the%20arguments%20we%20pass
Unlike filter(), filter_by() accepts keyword arguments (note the difference in syntax here: filter() checks a conditional against a column object whereas filter_by() finds columns which match the arguments we pass). filter_by() can only search for exact values and serves as a kind of shorthand for simple filtering queries.

[Shiny380]

After a little bit of study:

• filter didn't work but filter_by did work for the RTU/TCP polling get all points
• the below code snippet shows that filter might have worked if I used PointModel.enable instead of ModbusPointModel.enable but didn't test.

session.query(Engineer).\
    filter(Engineer.id == Employee.id).\
    filter(Employee.name == 'dilbert').\
    delete()

https://docs.sqlalchemy.org/en/13/orm/query.html?highlight=synchronize_session#sqlalchemy.orm.query.Query.delete.params.synchronize_session