dbpostgres

package

Go to main page

Versions in this module

v0

v0.0.25

Sep 13, 2025

v0.0.24

Sep 11, 2025

v0.0.23

Sep 11, 2025

v0.0.22

Sep 10, 2025

v0.0.21

Sep 10, 2025

Changes in this version

type UserAddApiKeyParams

+ OrganizationID int64

type UserApiKey

+ OrganizationID int64

type UserGetApiKeyRow

+ OrganizationID int64

type UserListApiKeysRow

+ OrganizationID int64

v0.0.18

Sep 5, 2025

Changes in this version

type AddUserParams

+ Verified bool

+ type GetRolesForUserRow struct

+ ID int64

+ Name string

+ SystemName string

type GetUserByEmailRow

+ Verified bool

type GetUserRow

+ Verified bool

+ type GetUsersInRoleRow struct

+ DisplayName string

+ Email string

+ FirstName string

+ ID int64

+ LastName string

+ Verified bool

type Queries

+ func (q *Queries) GetRolesForUser(ctx context.Context, userID int64) ([]GetRolesForUserRow, error)

+ func (q *Queries) GetUsersInRole(ctx context.Context, roleID int64) ([]GetUsersInRoleRow, error)

+ func (q *Queries) UserAddApiKey(ctx context.Context, arg UserAddApiKeyParams) error

+ func (q *Queries) UserDeleteApiKey(ctx context.Context, arg UserDeleteApiKeyParams) error

+ func (q *Queries) UserGetApiKey(ctx context.Context, apiKeyHash string) (UserGetApiKeyRow, error)

+ func (q *Queries) UserListApiKeys(ctx context.Context, userID int64) ([]UserListApiKeysRow, error)

+ func (q *Queries) UserSearch(ctx context.Context, arg UserSearchParams) ([]UserSearchRow, error)

type UpdateUserParams

+ Verified bool

type User

+ Verified bool

+ type UserAddApiKeyParams struct

+ CreatedAt time.Time

+ ExpiresAt time.Time

+ ID string

+ Name string

+ SecretHash string

+ UserID int64

+ type UserApiKey struct

+ CreatedAt time.Time

+ ExpiresAt time.Time

+ ID string

+ Name string

+ SecretHash string

+ UserID int64

+ type UserDeleteApiKeyParams struct

+ ID string

+ UserID int64

+ type UserGetApiKeyRow struct

+ CreatedAt time.Time

+ ExpiresAt time.Time

+ ID string

+ Name string

+ SecretHash string

+ UserID int64

+ type UserListApiKeysRow struct

+ CreatedAt time.Time

+ ExpiresAt time.Time

+ ID string

+ Name string

+ UserID int64

+ type UserSearchParams struct

+ Count int32

+ Query string

+ Start int32

+ type UserSearchRow struct

+ DisplayName string

+ Email string

+ FirstName string

+ ID int64

+ LastName string

+ Verified bool

v0.0.16

Aug 29, 2025

Changes in this version

type AddUserParams

+ CreatedAt sql.NullTime

+ UpdatedAt sql.NullTime

+ type GetAllUserOrganizationRolesRow struct

+ ID int64

+ Name string

+ OrganizationID int64

+ OrganizationName string

+ OrganizationSystemName string

+ SystemName string

+ type GetUserByEmailRow struct

+ DisplayName string

+ Email string

+ FirstName string

+ ID int64

+ LastName string

+ type GetUserRow struct

+ DisplayName string

+ Email string

+ FirstName string

+ ID int64

+ LastName string

+ type ListRolesWithUserCountsRow struct

+ ID int64

+ Name string

+ SystemName string

+ UserCount int64

type Queries

+ func (q *Queries) GetAllUserOrganizationRoles(ctx context.Context, userID int64) ([]GetAllUserOrganizationRolesRow, error)

+ func (q *Queries) ListRolesWithUserCounts(ctx context.Context, organizationID int64) ([]ListRolesWithUserCountsRow, error)

+ func (q *Queries) OrganizationsCount(ctx context.Context) (int64, error)

+ func (q *Queries) UpdateUserLoginStats(ctx context.Context, arg UpdateUserLoginStatsParams) error

+ func (q *Queries) UsersCount(ctx context.Context) (int64, error)

+ type UpdateUserLoginStatsParams struct

+ ID int64

+ LastLogin sql.NullTime

+ LoginCount int32

type UpdateUserParams

+ UpdatedAt sql.NullTime

type User

+ CreatedAt sql.NullTime

+ LastLogin sql.NullTime

+ LoginCount int32

+ UpdatedAt sql.NullTime

v0.0.14

Aug 14, 2025

v0.0.11

Aug 3, 2025

v0.0.10

Jul 30, 2025

v0.0.9

Jul 25, 2025

v0.0.8

Jul 24, 2025

v0.0.7

Jul 24, 2025

Changes in this version

+ type AddOrganizationParams struct

+ ID int64

+ Name string

+ Status string

+ SystemName string

+ type AddPermissionToRoleParams struct

+ Permission string

+ RoleID int64

+ type AddRoleParams struct

+ ID int64

+ Name string

+ OrganizationID int64

+ SystemName string

+ type AddRoleToUserParams struct

+ RoleID int64

+ UserID int64

+ type AddUserParams struct

+ DisplayName string

+ Email string

+ FirstName string

+ ID int64

+ LastName string

+ type AddUserToRoleParams struct

+ RoleID int64

+ 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 GetOrganizationRolesRow struct

+ ID int64

+ Name string

+ SystemName string

+ type GetOrganizationsRow struct

+ ID int64

+ Name string

+ SystemName string

+ type GetUserOrganizationPermissionsParams struct

+ OrganizationID int64

+ UserID int64

+ type GetUserOrganizationRolesParams struct

+ OrganizationID int64

+ UserID int64

+ type GetUserOrganizationRolesRow struct

+ ID int64

+ Name string

+ SystemName string

+ type GetUserOrganizationsRow struct

+ ID sql.NullInt64

+ Name sql.NullString

+ SystemName sql.NullString

+ type ListUserOrganizationRolesRow struct

+ Organization string

+ OrganizationID int64

+ OrganizationSystemName string

+ RoleID int64

+ RoleName string

+ RoleSystemName string

+ type Organization struct

+ ID int64

+ Name string

+ Status string

+ SystemName string

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) AddOrganization(ctx context.Context, arg AddOrganizationParams) error

+ 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) AddUserToRole(ctx context.Context, arg AddUserToRoleParams) error

+ func (q *Queries) DeleteRole(ctx context.Context, id int64) error

+ func (q *Queries) GetOrganization(ctx context.Context, id int64) (Organization, error)

+ func (q *Queries) GetOrganizationBySystemName(ctx context.Context, systemName string) (Organization, error)

+ func (q *Queries) GetOrganizationRoles(ctx context.Context, organizationID int64) ([]GetOrganizationRolesRow, error)

+ func (q *Queries) GetOrganizations(ctx context.Context) ([]GetOrganizationsRow, error)

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

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

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

+ func (q *Queries) GetUserOrganizationPermissions(ctx context.Context, arg GetUserOrganizationPermissionsParams) ([]string, error)

+ func (q *Queries) GetUserOrganizationRoles(ctx context.Context, arg GetUserOrganizationRolesParams) ([]GetUserOrganizationRolesRow, error)

+ func (q *Queries) GetUserOrganizations(ctx context.Context, userID int64) ([]GetUserOrganizationsRow, error)

+ func (q *Queries) ListOrganizations(ctx context.Context) ([]Organization, error)

+ func (q *Queries) ListUserOrganizationRoles(ctx context.Context, userID int64) ([]ListUserOrganizationRolesRow, error)

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

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

+ func (q *Queries) RemoveUserFromRole(ctx context.Context, arg RemoveUserFromRoleParams) error

+ func (q *Queries) UpdateOrganization(ctx context.Context, arg UpdateOrganizationParams) 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

+ Permission string

+ RoleID int64

+ type RemoveUserFromRoleParams struct

+ RoleID int64

+ UserID int64

+ type ResourceType struct

+ ID int64

+ Name string

+ SystemName string

+ type Role struct

+ ID int64

+ Name string

+ OrganizationID int64

+ SystemName string

+ type RolePermission struct

+ Permission string

+ RoleID int64

+ type UpdateOrganizationParams struct

+ ID int64

+ Name string

+ Status string

+ SystemName string

+ type UpdateRoleParams struct

+ ID int64

+ Name string

+ SystemName string

+ type UpdateUserParams struct

+ DisplayName string

+ Email string

+ FirstName string

+ ID int64

+ LastName string

+ type User struct

+ DisplayName string

+ Email string

+ FirstName string

+ ID int64

+ LastName string

+ type UserRole struct

+ RoleID int64

+ UserID int64

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