repo

package

Go to main page

Versions in this module

v1

v1.1.2

Dec 20, 2023

v1.1.1

Dec 20, 2023

v1.1.0

Dec 20, 2023

Changes in this version

type Repo

+ func (repo *Repo) CreateWebPushSubscriptionForUser(ctx context.Context, userID string, userAgent string, tokenID string, ...) (string, error)

+ func (repo *Repo) DeleteWebPushSubscriptionByID(ctx context.Context, id string) error

+ func (repo *Repo) DeleteWebPushSubscriptionForToken(ctx context.Context, tokenID string) error

+ func (repo *Repo) GetWebPushSubscriptionsForUser(ctx context.Context, userID string) ([]models.Webpush, error)

v1.0.0

Dec 6, 2023

v0

v0.14.4

Feb 27, 2025

v0.14.3

Feb 7, 2025

v0.14.2

Feb 7, 2025

v0.14.1

Feb 7, 2025

v0.14.0

Feb 7, 2025

Changes in this version

type GetUsersByRoleRow

+ Deleted bool

type User

+ Deleted bool

v0.13.0

Nov 9, 2024

v0.12.7

Nov 9, 2024

v0.12.6

Nov 9, 2024

v0.12.5

Nov 9, 2024

v0.12.4

Oct 28, 2024

v0.12.3

Oct 28, 2024

v0.12.2

Sep 15, 2024

v0.12.1

Sep 15, 2024

v0.12.0

Sep 15, 2024

v0.11.0

Apr 16, 2024

v0.10.0

Jan 20, 2024

v0.9.0

Jan 14, 2024

Changes in this version

+ var ErrTxNotSupported = errors.New("tx not supported")

+ func Migrate(ctx context.Context, db *sql.DB) (int, error)

+ func RunInTransaction[R any](ctx context.Context, q *Queries, fn func(tx *Queries) (R, error), ...) (R, error)

+ type AddRoleToTokenParams struct

+ RoleID string

+ TokenID string

+ type AddWebauthnCredParams struct

+ ClientDevice string

+ ClientName string

+ ClientOs string

+ Cred string

+ CredType string

+ ID string

+ UserID string

+ type AssignPermissionToRoleParams struct

+ Permission string

+ RoleID string

+ type AssignRoleToUserParams struct

+ RoleID string

+ UserID string

+ type CheckAndDeleteRecoveryCodeParams struct

+ Code string

+ UserID string

+ type CreateAPITokenParams struct

+ ExpiresAt sql.NullTime

+ ID string

+ Name string

+ Token string

+ UserID string

+ type CreateEMailParams struct

+ Address string

+ ID string

+ IsPrimary bool

+ UserID string

+ Verified bool

+ type CreateRegistrationTokenParams struct

+ AllowedUsage sql.NullInt64

+ CreatedAt time.Time

+ CreatedBy string

+ Expires sql.NullTime

+ InitialRoles string

+ Token string

+ type CreateRejectedTokenParams struct

+ ExpiresAt time.Time

+ IssuedAt time.Time

+ TokenID string

+ UserID string

+ type CreateRoleParams struct

+ DeleteProtected bool

+ Description string

+ ID string

+ Name string

+ type CreateSystemRoleParams struct

+ Description string

+ ID string

+ Name string

+ type CreateUserAddressParams struct

+ CityCode string

+ CityName string

+ Extra string

+ ID string

+ Street string

+ UserID string

+ type CreateUserParams struct

+ Avatar string

+ Birthday string

+ DisplayName string

+ Extra string

+ FirstName string

+ ID string

+ LastName string

+ Password string

+ Username string

+ type CreateUserPhoneNumberParams struct

+ ID string

+ IsPrimary bool

+ PhoneNumber string

+ UserID string

+ Verified bool

+ type CreateWebPushSubscriptionForUserParams struct

+ Auth string

+ Endpoint string

+ ID string

+ Key string

+ TokenID string

+ UserAgent string

+ UserID string

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

+ ID string

+ UserID string

+ type DeleteUserAddressParams struct

+ ID string

+ UserID string

+ type DeleteUserPhoneNumberParams struct

+ ID string

+ UserID string

+ type EnrollUserTOTPSecretParams struct

+ ID string

+ TotpSecret sql.NullString

+ type GetEmailByIDParams struct

+ ID string

+ UserID string

+ type GetPhoneNumberByIDParams struct

+ ID string

+ UserID string

+ type GetRegistrationTokenParams struct

+ Expires sql.NullTime

+ Token string

+ type GetUserAddressParams struct

+ ID string

+ UserID string

+ type GetUserByEMailRow struct

+ User User

+ Verified bool

+ type GetUserForAPITokenRow struct

+ User User

+ UserApiToken UserApiToken

+ type GetUsersByRoleRow struct

+ Avatar string

+ Birthday string

+ DisplayName string

+ Extra string

+ FirstName string

+ ID string

+ LastName string

+ Password string

+ RoleID string

+ TotpSecret sql.NullString

+ UserID string

+ Username string

+ type InsertRecoveryCodesParams struct

+ Code string

+ UserID string

+ type MarkEmailAsPrimaryParams struct

+ ID string

+ UserID string

+ type MarkEmailAsVerifiedParams struct

+ ID string

+ UserID string

+ type MarkEmailVerifiedParams struct

+ ID string

+ UserID string

+ Verified bool

+ type MarkPhoneNumberAsPrimaryParams struct

+ ID string

+ UserID string

+ type MarkPhoneNumberAsVerifiedParams struct

+ ID string

+ UserID string

+ type MarkPhoneNumberVerifiedParams struct

+ ID string

+ UserID string

+ Verified bool

+ type MarkRegistrationTokenUsedParams struct

+ Expires sql.NullTime

+ Token string

+ type MfaBackupCode struct

+ Code string

+ UserID string

+ type Queries struct

+ func (q *Queries) AddRoleToToken(ctx context.Context, arg AddRoleToTokenParams) error

+ func (q *Queries) AddWebauthnCred(ctx context.Context, arg AddWebauthnCredParams) error

+ func (q *Queries) AssignPermissionToRole(ctx context.Context, arg AssignPermissionToRoleParams) error

+ func (q *Queries) AssignRoleToUser(ctx context.Context, arg AssignRoleToUserParams) error

+ func (q *Queries) CheckAndDeleteRecoveryCode(ctx context.Context, arg CheckAndDeleteRecoveryCodeParams) (int64, error)

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

+ func (q *Queries) CreateAPIToken(ctx context.Context, arg CreateAPITokenParams) error

+ func (q *Queries) CreateEMail(ctx context.Context, arg CreateEMailParams) (UserEmail, error)

+ func (q *Queries) CreateRegistrationToken(ctx context.Context, arg CreateRegistrationTokenParams) error

+ func (q *Queries) CreateRejectedToken(ctx context.Context, arg CreateRejectedTokenParams) error

+ func (q *Queries) CreateRole(ctx context.Context, arg CreateRoleParams) (Role, error)

+ func (q *Queries) CreateSystemRole(ctx context.Context, arg CreateSystemRoleParams) (Role, error)

+ func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)

+ func (q *Queries) CreateUserAddress(ctx context.Context, arg CreateUserAddressParams) (UserAddress, error)

+ func (q *Queries) CreateUserPhoneNumber(ctx context.Context, arg CreateUserPhoneNumberParams) (UserPhoneNumber, error)

+ func (q *Queries) CreateWebPushSubscriptionForUser(ctx context.Context, arg CreateWebPushSubscriptionForUserParams) error

+ func (q *Queries) DeleteAllRolePermissions(ctx context.Context, roleID string) error

+ func (q *Queries) DeleteEMailFromUser(ctx context.Context, arg DeleteEMailFromUserParams) (int64, error)

+ func (q *Queries) DeleteExpiredTokens(ctx context.Context, expiresAt time.Time) (int64, error)

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

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

+ func (q *Queries) DeleteUserAddress(ctx context.Context, arg DeleteUserAddressParams) (int64, error)

+ func (q *Queries) DeleteUserPhoneNumber(ctx context.Context, arg DeleteUserPhoneNumberParams) (int64, error)

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

+ func (q *Queries) DeleteWebPushSubscriptionForToken(ctx context.Context, tokenID string) (int64, error)

+ func (q *Queries) EnrollUserTOTPSecret(ctx context.Context, arg EnrollUserTOTPSecretParams) error

+ func (q *Queries) GetAPITokensForUser(ctx context.Context, userID string) ([]UserApiToken, error)

+ func (q *Queries) GetAllUsers(ctx context.Context) ([]User, error)

+ func (q *Queries) GetEmailByID(ctx context.Context, arg GetEmailByIDParams) (UserEmail, error)

+ func (q *Queries) GetEmailsForUserByID(ctx context.Context, userID string) ([]UserEmail, error)

+ func (q *Queries) GetPhoneNumberByID(ctx context.Context, arg GetPhoneNumberByIDParams) (UserPhoneNumber, error)

+ func (q *Queries) GetPhoneNumbersByUserID(ctx context.Context, userID string) ([]UserPhoneNumber, error)

+ func (q *Queries) GetPrimaryEmailForUserByID(ctx context.Context, userID string) (UserEmail, error)

+ func (q *Queries) GetRegistrationToken(ctx context.Context, arg GetRegistrationTokenParams) (RegistrationToken, error)

+ func (q *Queries) GetRoleByID(ctx context.Context, id string) (Role, error)

+ func (q *Queries) GetRoleByName(ctx context.Context, name string) (Role, error)

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

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

+ func (q *Queries) GetRolesForToken(ctx context.Context, id string) ([]Role, error)

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

+ func (q *Queries) GetRolesWithPermission(ctx context.Context, permission string) ([]RolePermission, error)

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

+ func (q *Queries) GetUserAddress(ctx context.Context, arg GetUserAddressParams) (UserAddress, error)

+ func (q *Queries) GetUserAddresses(ctx context.Context, userID string) ([]UserAddress, error)

+ func (q *Queries) GetUserByEMail(ctx context.Context, address string) (GetUserByEMailRow, error)

+ func (q *Queries) GetUserByID(ctx context.Context, id string) (User, error)

+ func (q *Queries) GetUserByName(ctx context.Context, username string) (User, error)

+ func (q *Queries) GetUserForAPIToken(ctx context.Context, token string) (GetUserForAPITokenRow, error)

+ func (q *Queries) GetUserPrimaryPhoneNumber(ctx context.Context, userID string) (UserPhoneNumber, error)

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

+ func (q *Queries) GetWebPushSubscriptionsForUser(ctx context.Context, userID string) ([]WebpushSubscription, error)

+ func (q *Queries) GetWebauthnCreds(ctx context.Context, userID string) ([]WebauthnCred, error)

+ func (q *Queries) InsertRecoveryCodes(ctx context.Context, arg InsertRecoveryCodesParams) error

+ func (q *Queries) IsTokenRejected(ctx context.Context, tokenID string) (bool, error)

+ func (q *Queries) LoadUserRecoveryCodes(ctx context.Context, userID string) ([]MfaBackupCode, error)

+ func (q *Queries) MarkEmailAsPrimary(ctx context.Context, arg MarkEmailAsPrimaryParams) (int64, error)

+ func (q *Queries) MarkEmailAsVerified(ctx context.Context, arg MarkEmailAsVerifiedParams) (int64, error)

+ func (q *Queries) MarkEmailVerified(ctx context.Context, arg MarkEmailVerifiedParams) (int64, error)

+ func (q *Queries) MarkPhoneNumberAsPrimary(ctx context.Context, arg MarkPhoneNumberAsPrimaryParams) (int64, error)

+ func (q *Queries) MarkPhoneNumberAsVerified(ctx context.Context, arg MarkPhoneNumberAsVerifiedParams) (int64, error)

+ func (q *Queries) MarkPhoneNumberVerified(ctx context.Context, arg MarkPhoneNumberVerifiedParams) (int64, error)

+ func (q *Queries) MarkRegistrationTokenUsed(ctx context.Context, arg MarkRegistrationTokenUsedParams) (RegistrationToken, error)

+ func (q *Queries) RemoveAllRecoveryCodes(ctx context.Context, userID string) error

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

+ func (q *Queries) RemoveWebauthnCred(ctx context.Context, arg RemoveWebauthnCredParams) (int64, error)

+ func (q *Queries) RevokeUserAPIToken(ctx context.Context, arg RevokeUserAPITokenParams) (int64, error)

+ func (q *Queries) SetUserExtraData(ctx context.Context, arg SetUserExtraDataParams) (int64, error)

+ func (q *Queries) SetUserPassword(ctx context.Context, arg SetUserPasswordParams) (int64, error)

+ func (q *Queries) Tx(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error)

+ func (q *Queries) UnassignPermissionFromRole(ctx context.Context, arg UnassignPermissionFromRoleParams) (int64, error)

+ func (q *Queries) UnassignRoleFromUser(ctx context.Context, arg UnassignRoleFromUserParams) (int64, error)

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

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

+ func (q *Queries) UpdateUserAddress(ctx context.Context, arg UpdateUserAddressParams) (UserAddress, error)

+ func (q *Queries) UserHasTOTPEnrolled(ctx context.Context, id string) (bool, error)

+ func (q *Queries) ValidateRegistrationToken(ctx context.Context, token string) (bool, error)

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

+ type RegistrationToken struct

+ AllowedUsage sql.NullInt64

+ CreatedAt time.Time

+ CreatedBy string

+ Expires sql.NullTime

+ InitialRoles string

+ Token string

+ type RemoveWebauthnCredParams struct

+ ID string

+ UserID string

+ type RevokeUserAPITokenParams struct

+ ID string

+ UserID string

+ type Role struct

+ DeleteProtected bool

+ Description string

+ ID string

+ Name string

+ Origin string

+ type RoleAssignment struct

+ RoleID string

+ UserID string

+ type RolePermission struct

+ Permission string

+ RoleID string

+ type SetUserExtraDataParams struct

+ Extra string

+ ID string

+ type SetUserPasswordParams struct

+ ID string

+ Password string

+ type TokenInvalidation struct

+ ExpiresAt time.Time

+ IssuedAt time.Time

+ TokenID string

+ UserID string

+ type TransactionOptions func(opts *sql.TxOptions)

+ func Isolation(lvl sql.IsolationLevel) TransactionOptions

+ func ReadOnly() TransactionOptions

+ type Transactioner interface

+ BeginTx func(context.Context, *sql.TxOptions) (*sql.Tx, error)

+ type UnassignPermissionFromRoleParams struct

+ Permission string

+ RoleID string

+ type UnassignRoleFromUserParams struct

+ RoleID string

+ UserID string

+ type UpdateRoleParams struct

+ DeleteProtected bool

+ Description string

+ ID string

+ Name string

+ type UpdateUserAddressParams struct

+ CityCode string

+ CityName string

+ Extra string

+ ID string

+ Street string

+ UserID string

+ type UpdateUserParams struct

+ Avatar string

+ Birthday string

+ DisplayName string

+ Extra string

+ FirstName string

+ ID string

+ LastName string

+ Username string

+ type User struct

+ Avatar string

+ Birthday string

+ DisplayName string

+ Extra string

+ FirstName string

+ ID string

+ LastName string

+ Password string

+ TotpSecret sql.NullString

+ Username string

+ type UserAddress struct

+ CityCode string

+ CityName string

+ Extra string

+ ID string

+ Street string

+ UserID string

+ type UserApiToken struct

+ CreatedAt time.Time

+ ExpiresAt sql.NullTime

+ ID string

+ Name string

+ Token string

+ UserID string

+ type UserApiTokenRole struct

+ RoleID string

+ TokenID string

+ type UserEmail struct

+ Address string

+ ID string

+ IsPrimary bool

+ UserID string

+ Verified bool

+ type UserPhoneNumber struct

+ ID string

+ IsPrimary bool

+ PhoneNumber string

+ UserID string

+ Verified bool

+ type WebauthnCred struct

+ ClientDevice string

+ ClientName string

+ ClientOs string

+ Cred string

+ CredType string

+ ID string

+ UserID string

+ type WebpushSubscription struct

+ Auth string

+ Endpoint string

+ ID string

+ Key string

+ TokenID string

+ UserAgent string

+ UserID string

v0.0.1

Dec 6, 2023

Changes in this version

+ func NewWebAuthnUser(ctx context.Context, log *logrus.Entry, repo *Repo, usr models.User) webauthn.User

+ func QueryOne[T any](ctx context.Context, stmt stmts.Statement[T], conn *gorqlite.Connection, ...) (T, error)

+ func Query[T any](ctx context.Context, stmt stmts.Statement[T], conn *gorqlite.Connection, ...) ([]T, error)

+ type Repo struct

+ Conn *gorqlite.Connection

+ func New(endpoint string) (*Repo, error)

+ func (repo *Repo) AddUserAddress(ctx context.Context, address models.Address) (models.Address, error)

+ func (repo *Repo) AddUserPhoneNumber(ctx context.Context, model models.PhoneNumber) (models.PhoneNumber, error)

+ func (repo *Repo) AddWebauthnCred(ctx context.Context, userID string, cred webauthn.Credential, ...) error

+ func (repo *Repo) AssignRoleToUser(ctx context.Context, userID string, roleID string) error

+ func (repo *Repo) CheckAndDeleteRecoveryCode(ctx context.Context, userID string, code string) error

+ func (repo *Repo) CreateRegistrationToken(ctx context.Context, token models.RegistrationToken) error

+ func (repo *Repo) CreateRole(ctx context.Context, group models.Role) (models.Role, error)

+ func (repo *Repo) CreateUser(ctx context.Context, user models.User) (models.User, error)

+ func (repo *Repo) CreateUserEmail(ctx context.Context, mail models.EMail) (models.EMail, error)

+ func (repo *Repo) DeleteEMailFromUser(ctx context.Context, userID string, mailID string) error

+ func (repo *Repo) DeleteRejectedTokens(ctx context.Context, threshold time.Time) error

+ func (repo *Repo) DeleteRole(ctx context.Context, id string) error

+ func (repo *Repo) DeleteUser(ctx context.Context, id string) error

+ func (repo *Repo) DeleteUserAddress(ctx context.Context, userID, addressID string) error

+ func (repo *Repo) DeleteUserPhoneNumber(ctx context.Context, userID string, phoneNumberID string) error

+ func (repo *Repo) GetAddressesByID(ctx context.Context, userID, id string) (models.Address, error)

+ func (repo *Repo) GetPasskeys(ctx context.Context, userID string) ([]models.Passkey, error)

+ func (repo *Repo) GetRoleByID(ctx context.Context, id string) (models.Role, error)

+ func (repo *Repo) GetRoleByName(ctx context.Context, name string) (models.Role, error)

+ func (repo *Repo) GetRoles(ctx context.Context) ([]models.Role, error)

+ func (repo *Repo) GetUserAddresses(ctx context.Context, userID string) ([]models.Address, error)

+ func (repo *Repo) GetUserByEMail(ctx context.Context, name string) (models.User, bool, error)

+ func (repo *Repo) GetUserByID(ctx context.Context, id string) (models.User, error)

+ func (repo *Repo) GetUserByName(ctx context.Context, name string) (models.User, error)

+ func (repo *Repo) GetUserEmailByID(ctx context.Context, userID, id string) (models.EMail, error)

+ func (repo *Repo) GetUserEmails(ctx context.Context, userID string) ([]models.EMail, error)

+ func (repo *Repo) GetUserPhoneNumberByID(ctx context.Context, id, userID string) (models.PhoneNumber, error)

+ func (repo *Repo) GetUserPhoneNumbers(ctx context.Context, userID string) ([]models.PhoneNumber, error)

+ func (repo *Repo) GetUserPrimaryMail(ctx context.Context, userID string) (models.EMail, error)

+ func (repo *Repo) GetUserPrimaryPhoneNumber(ctx context.Context, userID string) (models.PhoneNumber, error)

+ func (repo *Repo) GetUserRoles(ctx context.Context, userID string) ([]models.Role, error)

+ func (repo *Repo) GetUsers(ctx context.Context) ([]models.User, error)

+ func (repo *Repo) GetUsersByRole(ctx context.Context, roleID string) ([]models.User, error)

+ func (repo *Repo) GetWebauthnCreds(ctx context.Context, userID string) ([]webauthn.Credential, error)

+ func (repo *Repo) IsTokenRejected(ctx context.Context, tokenID string) (bool, error)

+ func (repo *Repo) MarkEmailAsPrimary(ctx context.Context, userID string, mailID string) error

+ func (repo *Repo) MarkEmailAsVerified(ctx context.Context, userID string, mailID string) error

+ func (repo *Repo) MarkPhoneNumberAsPrimary(ctx context.Context, userID string, phoneNumberID string) error

+ func (repo *Repo) MarkPhoneNumberAsVerified(ctx context.Context, userID string, phoneNumberID string) error

+ func (repo *Repo) MarkRegistrationTokenUsed(ctx context.Context, token string) error

+ func (repo *Repo) MarkTokenRejected(ctx context.Context, token models.RejectedToken) error

+ func (repo *Repo) Migrate(ctx context.Context) error

+ func (repo *Repo) RemoveUserTotpSecret(ctx context.Context, userID string) error

+ func (repo *Repo) RemoveWebauthnCred(ctx context.Context, userID, id string) error

+ func (repo *Repo) ReplaceUserRecoveryCodes(ctx context.Context, userID string, codes []string) error

+ func (repo *Repo) SetUserPassword(ctx context.Context, userID string, password string) error

+ func (repo *Repo) SetUserTotpSecret(ctx context.Context, userID string, totpSecret string) error

+ func (repo *Repo) UnassignRoleFromUser(ctx context.Context, userID string, roleID string) error

+ func (repo *Repo) UpdateRole(ctx context.Context, role models.Role) error

+ func (repo *Repo) UpdateUser(ctx context.Context, user models.User) error

+ func (repo *Repo) UpdateUserAddress(ctx context.Context, address models.Address) error

+ func (repo *Repo) UserHasRecoveryCodes(ctx context.Context, userID string) (bool, error)

+ func (repo *Repo) ValidateRegistrationToken(ctx context.Context, token string) (models.RegistrationToken, error)

+ type WebauthnUser struct

+ func (usr *WebauthnUser) WebAuthnCredentials() []webauthn.Credential

+ func (usr *WebauthnUser) WebAuthnDisplayName() string

+ func (usr *WebauthnUser) WebAuthnID() []byte

+ func (usr *WebauthnUser) WebAuthnIcon() string

+ func (usr *WebauthnUser) WebAuthnName() string

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