raito.plugins.roles.providers.sql.postgresql module

class raito.plugins.roles.providers.sql.postgresql.PostgreSQLRoleProvider(storage, session_factory=None)[source]

Bases: SQLAlchemyRoleProvider

PostgreSQL-based role provider.

Required packages sqlalchemy[asyncio], asyncpg package installed (pip install raito[postgresql])

Parameters:

  • storage (SQLAlchemyStorage)

  • session_factory (async_sessionmaker[AsyncSession] | None)

async set_role(bot_id, user_id, role_slug)[source]

Set the role for a specific user.

Parameters:

  • bot_id (int) – The Telegram bot ID

  • user_id (int) – The Telegram user ID

  • role_slug (str) – The role slug to assign

Return type:

None

async remove_role(bot_id, user_id)[source]

Remove the role for a specific user.

Parameters:

  • bot_id (int) – The Telegram bot ID

  • user_id (int) – The Telegram user ID

Return type:

None