Problems with writing a query

[YaBatman]

Hello there! I have three models: User, Role, Permission, which are all connected via many-to-many communication. Could you please tell me how I can get all the permissions for a specific user?

class Permission(edgy.Model):
    id: int = edgy.BigIntegerField(primary_key=True, autoincrement=True)
    app_name: str = edgy.CharField(max_length=100)
    code_name: str = edgy.CharField(max_length=100)

    class Meta:
        tablename = "permissions"
        registry = settings.registry



class Role(edgy.Model):
    id: int = edgy.BigIntegerField(primary_key=True, autoincrement=True)
    name: str = edgy.CharField(max_length=150, unique=True)
    description: str = edgy.TextField(null=True)
    permissions: list["Permission"] = edgy.ManyToMany(to="Permission", related_name="roles")

    class Meta:
        tablename = "roles"
        registry = settings.registry


class User(edgy.Model):
    id: int = edgy.BigIntegerField(primary_key=True, autoincrement=True)
    first_name: str = edgy.CharField(max_length=150)
    last_name: str = edgy.CharField(max_length=150)
    middle_name = edgy.CharField(max_length=150, null=True)
    email = edgy.EmailField(max_length=150, unique=True, index=True)
    password: str = edgy.CharField(max_length=87, null=True)
    gender: GenderChoices = edgy.ChoiceField(choices=GenderChoices)
    date_of_birth: date = edgy.DateField()
    is_action: bool = edgy.BooleanField(default=True)
    is_superuser: bool = edgy.BooleanField(default=False)
    roles: list["Role"] = edgy.ManyToMany(to="Role", related_name="users")
    created_at: datetime = edgy.DateTimeField(auto_now_add=True, default_timezone=ZoneInfo("UTC"))
    updated_at: datetime = edgy.DateTimeField(auto_now=True)


    class Meta:
        tablename = "users"
        registry = settings.registry

[devkral]

First:
I would recommend you to use the edgy contrib permission module:

https://edgy.dymmond.com/permissions/intro/

You will save a lot of time. If you still want to do it yourself have a look in

https://github.com/dymmond/edgy/blob/main/edgy/contrib/permissions/managers.py

This is the implementation.