Versions in this module Expand all Collapse all v0 v0.0.5 Jul 9, 2025 Changes in this version + type AddPermissionToRoleParams struct + PermissionID int64 + RoleID int64 + type AddRoleParams struct + Name string + RoleID int64 + type AddRoleToUserParams struct + RoleID int64 + UserID int64 + type AddUserParams struct + DisplayName string + Email string + FirstName string + LastName string + UserID int64 + type DBTX interface + ExecContext func(context.Context, string, ...interface{}) (sql.Result, error) + PrepareContext func(context.Context, string) (*sql.Stmt, error) + QueryContext func(context.Context, string, ...interface{}) (*sql.Rows, error) + QueryRowContext func(context.Context, string, ...interface{}) *sql.Row + type GetRolePermissionsRow struct + Name sql.NullString + PermissionID sql.NullInt64 + type GetUserPermissionsRow struct + Name sql.NullString + PermissionID sql.NullInt64 + type GetUserRolesRow struct + Name sql.NullString + RoleID sql.NullInt64 + type Permission struct + Name string + PermissionID int64 + type Queries struct + func New(db DBTX) *Queries + func (q *Queries) AddPermissionToRole(ctx context.Context, arg AddPermissionToRoleParams) error + func (q *Queries) AddRole(ctx context.Context, arg AddRoleParams) error + func (q *Queries) AddRoleToUser(ctx context.Context, arg AddRoleToUserParams) error + func (q *Queries) AddUser(ctx context.Context, arg AddUserParams) error + func (q *Queries) CreatePermission(ctx context.Context, name string) (int64, error) + func (q *Queries) GetPermissions(ctx context.Context) ([]Permission, error) + func (q *Queries) GetRolePermissions(ctx context.Context, roleID int64) ([]GetRolePermissionsRow, error) + func (q *Queries) GetRoles(ctx context.Context) ([]Role, error) + func (q *Queries) GetUser(ctx context.Context, userID int64) (User, error) + func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error) + func (q *Queries) GetUserPermissions(ctx context.Context, userID int64) ([]GetUserPermissionsRow, error) + func (q *Queries) GetUserRoles(ctx context.Context, userID int64) ([]GetUserRolesRow, error) + func (q *Queries) RemoveAllRolesFromUser(ctx context.Context, userID int64) error + func (q *Queries) RemovePermissionFromRole(ctx context.Context, arg RemovePermissionFromRoleParams) error + func (q *Queries) UpdateRole(ctx context.Context, arg UpdateRoleParams) error + func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) error + func (q *Queries) WithTx(tx *sql.Tx) *Queries + type RemovePermissionFromRoleParams struct + PermissionID int64 + RoleID int64 + type Role struct + Name string + RoleID int64 + type RolePermission struct + PermissionID int64 + RoleID int64 + type UpdateRoleParams struct + Name string + RoleID int64 + type UpdateUserParams struct + DisplayName string + Email string + FirstName string + LastName string + UserID int64 + type User struct + DisplayName string + Email string + FirstName string + LastName string + UserID int64 + type UserRole struct + RoleID int64 + UserID int64