Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  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

stmts

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

+ var CreateWebPushSubTable = Statement[any]

+ var CreateWebPushSubscriptionForUser = Statement[any]

+ var DeleteWebPushSubscriptionByID = Statement[any]

+ var DeleteWebPushSubscriptionForToken = Statement[any]

+ var GetWebPushSubscriptionsForUser = Statement[models.Webpush]

v1.0.0

Dec 6, 2023

v0

v0.0.1

Dec 6, 2023

Changes in this version

+ var AddWebauthnCred = Statement[any]

+ var AssignRoleToUser = Statement[any]

+ var CheckAndDeleteRecoveryCode = Statement[any]

+ var Create2FABackupCodeTable = Statement[any]

+ var CreateAddress = Statement[any]

+ var CreateAddressTable = Statement[any]

+ var CreateEMail = Statement[any]

+ var CreateEMailTable = Statement[any]

+ var CreateFeature = Statement[any]

+ var CreateFeatureTable = Statement[any]

+ var CreatePhoneNumberTable = Statement[any]

+ var CreateRegistrationToken = Statement[any]

+ var CreateRegistrationTokenCleanupTrigger = Statement[any]

+ var CreateRegistrationTokenTable = Statement[any]

+ var CreateRejectedToken = Statement[any]

+ var CreateRole = Statement[any]

+ var CreateRoleAssignmentTable = Statement[any]

+ var CreateRoleTable = Statement[any]

+ var CreateTokenInvalidationTable = Statement[any]

+ var CreateUser = Statement[any]

+ var CreateUserFeatureTable = Statement[any]

+ var CreateUserPhoneNumber = Statement[any]

+ var CreateUserTable = Statement[any]

+ var CreateWebauthnCredsTable = Statement[any]

+ var DeleteAddress = Statement[any]

+ var DeleteEMailFromUser = Statement[any]

+ var DeleteExpiredTokens = Statement[any]

+ var DeleteRole = Statement[any]

+ var DeleteUser = Statement[any]

+ var DeleteUserPhoneNumber = Statement[any]

+ var DisableFeature = Statement[any]

+ var EnableFeature = Statement[any]

+ var EnrollUserTOTPSecret = Statement[any]

+ var ErrInvalidArgCount = errors.New("invalid number of arguments")

+ var ErrMissingArgument = errors.New("missing argument value")

+ var ErrNoResults = errors.New("no results")

+ var ErrNoRowsAffected = errors.New("no rows affected")

+ var GetAddressByID = Statement[models.Address]

+ var GetAllUsers = Statement[models.User]

+ var GetEmailByID = Statement[models.EMail]

+ var GetEmailsForUserByID = Statement[models.EMail]

+ var GetEnabledFeatures = Statement[any]

+ var GetPhoneNumberByID = Statement[models.PhoneNumber]

+ var GetPhoneNumbersByUserID = Statement[models.PhoneNumber]

+ var GetPrimaryEmailForUserByID = Statement[models.EMail]

+ var GetRegistrationToken = Statement[models.RegistrationToken]

+ var GetRoleByID = Statement[models.Role]

+ var GetRoleByName = Statement[models.Role]

+ var GetRoles = Statement[models.Role]

+ var GetRolesForUser = Statement[models.Role]

+ var GetUserAddressesByID = Statement[models.Address]

+ var GetUserByEMail = ...

+ var GetUserByID = Statement[models.User]

+ var GetUserByName = Statement[models.User]

+ var GetUserPrimaryPhoneNumber = Statement[models.PhoneNumber]

+ var GetUsersByRole = Statement[models.User]

+ var GetWebauthnCreds = Statement[models.Passkey]

+ var InsertRecoveryCodes = Statement[any]

+ var IsTokenRejected = Statement[models.RejectedToken]

+ var LoadUserRecoveryCodes = Statement[any]

+ var MarkEmailAsPrimary = Statement[any]

+ var MarkEmailAsVerified = Statement[any]

+ var MarkEmailVerified = Statement[any]

+ var MarkPhoneNumberAsPrimary = Statement[any]

+ var MarkPhoneNumberAsVerified = Statement[any]

+ var MarkPhoneNumberVerified = Statement[any]

+ var MarkRegistrationTokenUsed = Statement[models.RegistrationToken]

+ var RemoveAllRecoveryCodes = Statement[any]

+ var RemoveUserTOTPSecret = Statement[any]

+ var RemoveWebauthnCred = Statement[any]

+ var SetUserPassword = Statement[any]

+ var UnassignRoleFromUser = Statement[any]

+ var UpdateAddress = Statement[any]

+ var UpdateRole = Statement[any]

+ var UpdateUser = Statement[any]

+ type Statement struct

+ Args []string

+ Query string

+ Result R

+ func (stmt Statement[R]) Prepare(args any) (gorqlite.ParameterizedStatement, error)

+ func (stmt Statement[R]) Write(ctx context.Context, conn *gorqlite.Connection, args any) error