ubpostgres

package
v0.0.5 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Jul 9, 2025 License: MIT Imports: 2 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type AddPermissionToRoleParams

type AddPermissionToRoleParams struct {
	RoleID       int64
	PermissionID int64
}

type AddRoleParams

type AddRoleParams struct {
	RoleID int64
	Name   string
}

type AddRoleToUserParams

type AddRoleToUserParams struct {
	UserID int64
	RoleID int64
}

type AddUserParams

type AddUserParams struct {
	UserID      int64
	FirstName   string
	LastName    string
	DisplayName string
	Email       string
}

type DBTX

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type GetRolePermissionsRow

type GetRolePermissionsRow struct {
	PermissionID sql.NullInt64
	Name         sql.NullString
}

type GetUserPermissionsRow

type GetUserPermissionsRow struct {
	PermissionID sql.NullInt64
	Name         sql.NullString
}

type GetUserRolesRow

type GetUserRolesRow struct {
	RoleID sql.NullInt64
	Name   sql.NullString
}

type Permission

type Permission struct {
	PermissionID int64
	Name         string
}

type Queries

type Queries struct {
	// contains filtered or unexported fields
}

func New

func New(db DBTX) *Queries

func (*Queries) AddPermissionToRole

func (q *Queries) AddPermissionToRole(ctx context.Context, arg AddPermissionToRoleParams) error

func (*Queries) AddRole

func (q *Queries) AddRole(ctx context.Context, arg AddRoleParams) error

func (*Queries) AddRoleToUser

func (q *Queries) AddRoleToUser(ctx context.Context, arg AddRoleToUserParams) error

func (*Queries) AddUser

func (q *Queries) AddUser(ctx context.Context, arg AddUserParams) error

---------------------------------------------------------------------------

User and Role management

---------------------------------------------------------------------------

func (*Queries) CreatePermission

func (q *Queries) CreatePermission(ctx context.Context, name string) (int64, error)

func (*Queries) GetPermissions

func (q *Queries) GetPermissions(ctx context.Context) ([]Permission, error)

func (*Queries) GetRolePermissions

func (q *Queries) GetRolePermissions(ctx context.Context, roleID int64) ([]GetRolePermissionsRow, error)

func (*Queries) GetRoles

func (q *Queries) GetRoles(ctx context.Context) ([]Role, error)

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, userID int64) (User, error)

func (*Queries) GetUserByEmail

func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)

func (*Queries) GetUserPermissions

func (q *Queries) GetUserPermissions(ctx context.Context, userID int64) ([]GetUserPermissionsRow, error)

func (*Queries) GetUserRoles

func (q *Queries) GetUserRoles(ctx context.Context, userID int64) ([]GetUserRolesRow, error)

func (*Queries) RemoveAllRolesFromUser

func (q *Queries) RemoveAllRolesFromUser(ctx context.Context, userID int64) error

func (*Queries) RemovePermissionFromRole

func (q *Queries) RemovePermissionFromRole(ctx context.Context, arg RemovePermissionFromRoleParams) error

func (*Queries) UpdateRole

func (q *Queries) UpdateRole(ctx context.Context, arg UpdateRoleParams) error

func (*Queries) UpdateUser

func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) error

func (*Queries) WithTx

func (q *Queries) WithTx(tx *sql.Tx) *Queries

type RemovePermissionFromRoleParams

type RemovePermissionFromRoleParams struct {
	RoleID       int64
	PermissionID int64
}

type Role

type Role struct {
	RoleID int64
	Name   string
}

type RolePermission

type RolePermission struct {
	RoleID       int64
	PermissionID int64
}

type UpdateRoleParams

type UpdateRoleParams struct {
	Name   string
	RoleID int64
}

type UpdateUserParams

type UpdateUserParams struct {
	LastName    string
	FirstName   string
	DisplayName string
	Email       string
	UserID      int64
}

type User

type User struct {
	UserID      int64
	LastName    string
	FirstName   string
	DisplayName string
	Email       string
}

type UserRole

type UserRole struct {
	UserID int64
	RoleID int64
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL