sqlalchemy2-stubs
sqlalchemy2-stubs copied to clipboard
Type error when attempting to use a Literal[True] with sa.and_()
Relevant block of code:
sa.and_(
tb.c.VERSION == version,
tb.c.ISIN.in_(isins) if isins is not None else True,
tb.c.ISIN != None, # pylint: disable=singleton-comparison
b.c.DATE.in_(dates))
)
Error I get from pyright is:
error: Argument of type "ColumnElement[Boolean] | Literal[True]" cannot be assigned to parameter "clauses" of type "_CLE@BooleanClauseList" in function "and_"
Type "ColumnElement[Boolean] | Literal[True]" cannot be assigned to type "ColumnElement[Boolean]"
"Literal[True]" is incompatible with "ColumnElement[Boolean]" (reportGeneralTypeIssues)
Thanks for reporting,
You can use tb.c.ISIN.is_not(None) as an alternative.