How do I annotate the columns in my model? The following seems to mostly work:
class MyModel(Base):
__tablename__: str = 'mytable'
id: str = db.Column(db.String(32), primary_key=True)
test: int = db.Column(db.Integer, index=True)
is_valid: bool = db.Column(db.Boolean, default=True)
Those type hints such as id: str
remove the errors but a warning still appears for each column saying:
Expression of type "Column[Text]" cannot be assigned to declared type "str"
"Column[Text]" is incompatible with "str" PylancereportGeneralTypeIssues
This is Pylance, I messed around with the mypy stuff recommended in this SO question but it didn't really help and also I imagine I shouldn't be mixing mypy with Pylance (which is pyright no?).
I've also tried for eg. id: db.Column[Text]
but that seemed to confuse the rest of my code elsewhere...