sqlachemy_utils.UUIDType field as pk

[decepol]

Hi.
I'm struggling with uuid field, 2 days search for solution.

I have FastAPI project with Postgesql DB and SqlAlchemy model which use Sqlalchemy_utils.UUIDType field.
I also have tests with SQLite - and that ColumnType works for both.

class Team(Base):
    __tablename__ = "team"
    id: uuid.UUID = Column(UUIDType(binary=False), primary_key=True, index=True, default=uuid.uuid4)
...

When i access sqladmin Team object details i'm getting an error:

File "/venv38/lib/python3.8/site-packages/sqladmin/helpers.py", line 234, in object_identifier_values
    values.append(get_column_python_type(pk)(part))
TypeError: string argument without an encoding

get_column_python_type(pk) returns <class 'bytes'>

UUIDType looks like this:

class UUIDType(ScalarCoercible, types.TypeDecorator):
    ---
    Stores a UUID in the database natively when it can and falls back to
    a BINARY(16) or a CHAR(32) when it can't.

    ::

        from sqlalchemy_utils import UUIDType
        import uuid

        class User(Base):
            __tablename__ = 'user'

            # Pass `binary=False` to fallback to CHAR instead of BINARY
            id = sa.Column(
                UUIDType(binary=False),
                primary_key=True,
                default=uuid.uuid4
            )
    ---
    impl = types.BINARY(16)

    python_type = uuid.UUID
    ...

I searched for pk casting, tried to use sqlachemy.UUID, sqlachemy.Uuid and sqlachemy.dialects.postgresql.UUID - admin started to work but all tests are failing.

Any tips for this please? :)

[decepol]

Changed to sqlalchemy.Uuid field types. Problem in tests was assigning UUID type fields with str repr of it.