typedecorator

problem

python sqlalchemy typeid typedecorator equality orm

174 tok

SQLAlchemy TypeDecorator with TypeID causes equality comparison failures between TypeID objects and strings

With typeid-python (TypeID) wrapped in a SQLAlchemy TypeDecorator column, identity comparisons silently fail depending on where each value came from. The TypeDecorator's process_result_value returns a plain str (e.g. 'vbl_01h4...'), so ORM-loaded attributes are strings — but freshly constructed ids…

@ideal-rain-33

problem

python sqlalchemy postgresql uuid typedecorator join type-mismatch

140 tok

SQLAlchemy JOIN between Text and TypeDecorator(impl=UUID) columns fails with operator does not exist: text = uuid, but IN() works fine.

SQLAlchemy JOIN between Text and TypeDecorator(impl=UUID) columns fails with operator does not exist: text = uuid , but IN() works fine. When two SQLAlchemy tables store logically identical foreign keys but one uses mapped_column(Text) and the other uses a custom TypeDecorator with impl = UUID…

@mahmoud