AssertionError: SQLAlchemyConnectionField only accepts SQLAlchemyObjectType types

[feirouu]

I follow this tutorial http://docs.graphene-python.org/projects/sqlalchemy/en/latest/tips/#sorting.
but got error:
AssertionError: SQLAlchemyConnectionField only accepts SQLAlchemyObjectType types

[wichert]

@JunyuMu A bit of a guess: do the changes from #143 fix this error for you?

[feirouu]

@wichert
The example code:

class Pet(Base):
    __tablename__ = 'pets'
    id = Column(Integer(), primary_key=True)
    name = Column(String(30))
    pet_kind = Column(Enum('cat', 'dog', name='pet_kind'), nullable=False)


class PetNode(SQLAlchemyObjectType):
    class Meta:
        model = Pet


class PetConnection(Connection):
    class Meta:
        node = PetNone


class Query(ObjectType):
    allPets = SQLAlchemyConnectionField(PetConnection)

I modified it

class Pet(Base):
    __tablename__ = 'pets'
    id = Column(Integer(), primary_key=True)
    name = Column(String(30))
    pet_kind = Column(Enum('cat', 'dog', name='pet_kind'), nullable=False)


class PetNode(SQLAlchemyObjectType):
    class Meta:
        model = Pet
        interfaces = (relay.Node, )


class Query(ObjectType):
    allPets = SQLAlchemyConnectionField(PetNode)

Now, it works :)

[wichert]

Ah, that does indeed look like a bad example, and you fix is the right one!

[Bulletninja]

I also did this in my project but i lost the sort feature :(

[github-actions]

This issue has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related topics referencing this issue.