Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

dbpostgres

package

Go to main page

Versions in this module

v0

v0.0.5

Jul 9, 2025

v0.0.4

Jul 7, 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

v0.0.2

Jun 24, 2025