'active': 'True' or a 'active': True (bool) needs a review

[ReimarBauer]

On an old database setup I have seen an error on unarchive of operations. This could also been introduced by 02999a0#diff-a79f98f21772ef2875786e134f047c59410460de657ceda7b4829521ec2a87b8

sqlalchemy.exc.StatementError: (builtins.TypeError) Not a boolean value: 'True'
[SQL: UPDATE operations SET active=? WHERE operations.id = ?]
[parameters: [{'active': 'True', 'operations_id': 9}]]
INFO: disconnected

This needs a test

[anj20]

Hi @ReimarBauer
Can we explicitly check if the string is "True" (case-sensitive or case-insensitive) and then convert it to a boolean, instead of directly converting the value to a boolean? Jst like this

if isinstance(active, bool): self.active = active else: self.active = str(active).strip().lower() == 'true'