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

db

package

Go to main page

Versions in this module

v1

v1.0.0

Nov 16, 2025

v0

v0.0.7

Mar 1, 2026

v0.0.6

Feb 28, 2026

v0.0.5

Feb 23, 2026

Changes in this version

type CreateUserParams

+ Role string

+ type GetAdminUserByIDRow struct

+ Avatar *string

+ CreatedAt time.Time

+ Deleted bool

+ FilesScanned *int32

+ ID uuid.UUID

+ LastLoginAt interface{}

+ LastScannedAt pgtype.Timestamptz

+ Login string

+ Name string

+ Rating *int32

+ Role string

+ Status *string

+ TotalWeight *float64

+ UpdatedAt time.Time

+ type GetAdminUsersParams struct

+ Limit int32

+ Offset int32

+ type GetAdminUsersRow struct

+ Avatar *string

+ CreatedAt time.Time

+ Deleted bool

+ FilesScanned *int32

+ ID uuid.UUID

+ LastLoginAt interface{}

+ LastScannedAt pgtype.Timestamptz

+ Login string

+ Name string

+ Rating *int32

+ Role string

+ Status *string

+ TotalWeight *float64

+ UpdatedAt time.Time

type Querier

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

+ GetAdminUserByID func(ctx context.Context, id uuid.UUID) (GetAdminUserByIDRow, error)

+ GetAdminUsers func(ctx context.Context, arg GetAdminUsersParams) ([]GetAdminUsersRow, error)

type Queries

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

+ func (q *Queries) GetAdminUserByID(ctx context.Context, id uuid.UUID) (GetAdminUserByIDRow, error)

+ func (q *Queries) GetAdminUsers(ctx context.Context, arg GetAdminUsersParams) ([]GetAdminUsersRow, error)

type User

+ Role string

v0.0.4

Nov 23, 2025

v0.0.3

Nov 23, 2025

v0.0.2

Nov 16, 2025

v0.0.1

Nov 16, 2025

Changes in this version

+ type CompletePredictionParams struct

+ Error *string

+ ID uuid.UUID

+ Result []byte

+ Status string

+ type CreateLoginHistoryParams struct

+ FailureReason *string

+ IpAddress *netip.Addr

+ Location *string

+ Success bool

+ UserAgent *string

+ UserID uuid.UUID

+ type CreateNewPredictionParams struct

+ Status string

+ TrashScan string

+ UserID uuid.UUID

+ type CreateRefreshTokenParams struct

+ ExpiresAt time.Time

+ TokenHash string

+ UserID uuid.UUID

+ type CreateUserParams struct

+ HashedPassword string

+ Login string

+ Name string

+ type DBTX interface

+ Exec func(context.Context, string, ...interface{}) (pgconn.CommandTag, error)

+ Query func(context.Context, string, ...interface{}) (pgx.Rows, error)

+ QueryRow func(context.Context, string, ...interface{}) pgx.Row

+ type GetLoginHistoryByUserParams struct

+ Limit int32

+ Offset int32

+ UserID uuid.UUID

+ type GetPredictionsByUserIDParams struct

+ Limit int32

+ Offset int32

+ UserID uuid.UUID

+ type LoginHistory struct

+ CreatedAt time.Time

+ FailureReason *string

+ ID uuid.UUID

+ IpAddress *netip.Addr

+ Location *string

+ Success bool

+ UserAgent *string

+ UserID uuid.UUID

+ type Prediction struct

+ CreatedAt time.Time

+ Error *string

+ ID uuid.UUID

+ Result []byte

+ Status string

+ TrashScan string

+ UpdatedAt time.Time

+ UserID uuid.UUID

+ type Querier interface

+ CompletePrediction func(ctx context.Context, arg CompletePredictionParams) error

+ CreateLoginHistory func(ctx context.Context, arg CreateLoginHistoryParams) (uuid.UUID, error)

+ CreateNewPrediction func(ctx context.Context, arg CreateNewPredictionParams) (Prediction, error)

+ CreateRefreshToken func(ctx context.Context, arg CreateRefreshTokenParams) (uuid.UUID, error)

+ CreateUser func(ctx context.Context, arg CreateUserParams) (uuid.UUID, error)

+ DeleteUser func(ctx context.Context, id uuid.UUID) error

+ GetActiveTokensByUser func(ctx context.Context, userID uuid.UUID) ([]RefreshToken, error)

+ GetLoginHistoryByUser func(ctx context.Context, arg GetLoginHistoryByUserParams) ([]LoginHistory, error)

+ GetPrediction func(ctx context.Context, id uuid.UUID) (Prediction, error)

+ GetPredictionsByUserID func(ctx context.Context, arg GetPredictionsByUserIDParams) ([]Prediction, error)

+ GetRefreshTokenByHash func(ctx context.Context, tokenHash string) (RefreshToken, error)

+ GetStatsByUserID func(ctx context.Context, userID uuid.UUID) (Stat, error)

+ GetUserByID func(ctx context.Context, id uuid.UUID) (User, error)

+ GetUserByLogin func(ctx context.Context, login string) (User, error)

+ RevokeAllUserTokens func(ctx context.Context, userID uuid.UUID) error

+ RevokeRefreshToken func(ctx context.Context, tokenHash string) error

+ UpdateStats func(ctx context.Context, arg UpdateStatsParams) error

+ UpdateUser func(ctx context.Context, arg UpdateUserParams) error

+ UpdateUserAvatar func(ctx context.Context, arg UpdateUserAvatarParams) error

+ UpdateUserPassword func(ctx context.Context, arg UpdateUserPasswordParams) error

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) CompletePrediction(ctx context.Context, arg CompletePredictionParams) error

+ func (q *Queries) CreateLoginHistory(ctx context.Context, arg CreateLoginHistoryParams) (uuid.UUID, error)

+ func (q *Queries) CreateNewPrediction(ctx context.Context, arg CreateNewPredictionParams) (Prediction, error)

+ func (q *Queries) CreateRefreshToken(ctx context.Context, arg CreateRefreshTokenParams) (uuid.UUID, error)

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

+ func (q *Queries) DeleteUser(ctx context.Context, id uuid.UUID) error

+ func (q *Queries) GetActiveTokensByUser(ctx context.Context, userID uuid.UUID) ([]RefreshToken, error)

+ func (q *Queries) GetLoginHistoryByUser(ctx context.Context, arg GetLoginHistoryByUserParams) ([]LoginHistory, error)

+ func (q *Queries) GetPrediction(ctx context.Context, id uuid.UUID) (Prediction, error)

+ func (q *Queries) GetPredictionsByUserID(ctx context.Context, arg GetPredictionsByUserIDParams) ([]Prediction, error)

+ func (q *Queries) GetRefreshTokenByHash(ctx context.Context, tokenHash string) (RefreshToken, error)

+ func (q *Queries) GetStatsByUserID(ctx context.Context, userID uuid.UUID) (Stat, error)

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

+ func (q *Queries) GetUserByLogin(ctx context.Context, login string) (User, error)

+ func (q *Queries) RevokeAllUserTokens(ctx context.Context, userID uuid.UUID) error

+ func (q *Queries) RevokeRefreshToken(ctx context.Context, tokenHash string) error

+ func (q *Queries) UpdateStats(ctx context.Context, arg UpdateStatsParams) error

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

+ func (q *Queries) UpdateUserAvatar(ctx context.Context, arg UpdateUserAvatarParams) error

+ func (q *Queries) UpdateUserPassword(ctx context.Context, arg UpdateUserPasswordParams) error

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

+ type RefreshToken struct

+ CreatedAt time.Time

+ ExpiresAt time.Time

+ ID uuid.UUID

+ Revoked bool

+ RevokedAt pgtype.Timestamptz

+ TokenHash string

+ UpdatedAt time.Time

+ UserID uuid.UUID

+ type Stat struct

+ Achievements []byte

+ CreatedAt time.Time

+ FilesScanned int32

+ ID uuid.UUID

+ LastScannedAt pgtype.Timestamptz

+ Rating int32

+ Status string

+ TotalWeight float64

+ TrashByTypes []byte

+ UpdatedAt time.Time

+ UserID uuid.UUID

+ type UpdateStatsParams struct

+ Achievements []byte

+ FilesScanned int32

+ ID uuid.UUID

+ LastScannedAt pgtype.Timestamptz

+ Rating int32

+ Status string

+ TotalWeight float64

+ TrashByTypes []byte

+ type UpdateUserAvatarParams struct

+ Avatar *string

+ ID uuid.UUID

+ type UpdateUserParams struct

+ ID uuid.UUID

+ Name string

+ type UpdateUserPasswordParams struct

+ HashedPassword string

+ ID uuid.UUID

+ type User struct

+ Avatar *string

+ CreatedAt time.Time

+ Deleted bool

+ HashedPassword string

+ ID uuid.UUID

+ Login string

+ Name string

+ UpdatedAt time.Time