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
- API
  
  Reference documentation for the pkg.go.dev API
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

sqlcsqlite

package

Go to main page

Versions in this module

v2

v2.1.2

Oct 3, 2026

v2.1.1

Sep 25, 2026

v2.1.0

Sep 25, 2026

v2.0.0

Sep 12, 2026

Changes in this version

+ type Account struct

+ AccessToken sql.NullString

+ CreatedAt string

+ ExpiresAt sql.NullString

+ ID string

+ PasswordHash sql.NullString

+ Provider string

+ ProviderAccountID sql.NullString

+ RefreshToken sql.NullString

+ UpdatedAt string

+ UserID string

+ type BanUserParams struct

+ BanExpiry sql.NullString

+ BanReason sql.NullString

+ ID string

+ UpdatedAt string

+ type CreateUserParams struct

+ Avatar sql.NullString

+ BanCounter int64

+ BanExpiry sql.NullString

+ BanReason sql.NullString

+ Banned int64

+ CreatedAt string

+ Disabled int64

+ Email sql.NullString

+ ID string

+ Name string

+ Role sql.NullString

+ UpdatedAt 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 DeleteUserParams struct

+ ID string

+ UpdatedAt string

+ type GetUserRawRow struct

+ CreatedAt string

+ Disabled int64

+ Email string

+ ID string

+ Role string

+ UpdatedAt string

+ type ListUsersParams struct

+ Limit int64

+ Offset int64

+ type ListUsersRawParams struct

+ Limit int64

+ Offset int64

+ type ListUsersRawRow struct

+ CreatedAt string

+ Disabled int64

+ Email string

+ ID string

+ Role string

+ UpdatedAt string

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) BanUser(ctx context.Context, arg BanUserParams) error

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

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

+ func (q *Queries) DeleteUser(ctx context.Context, arg DeleteUserParams) error

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

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

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

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

+ func (q *Queries) GetUserRaw(ctx context.Context, id string) (GetUserRawRow, error)

+ func (q *Queries) GetUsersByRole(ctx context.Context, role sql.NullString) ([]User, error)

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

+ func (q *Queries) ListUsersRaw(ctx context.Context, arg ListUsersRawParams) ([]ListUsersRawRow, error)

+ func (q *Queries) UnbanUser(ctx context.Context, arg UnbanUserParams) error

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

+ func (q *Queries) UpdateUserRole(ctx context.Context, arg UpdateUserRoleParams) error

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

+ type Session struct

+ CreatedAt string

+ ExpiresAt string

+ ID string

+ IpAddress sql.NullString

+ RefreshToken sql.NullString

+ Token string

+ UserAgent sql.NullString

+ UserID string

+ type UnbanUserParams struct

+ ID string

+ UpdatedAt string

+ type UpdateUserParams struct

+ Avatar sql.NullString

+ Disabled int64

+ Email sql.NullString

+ ID string

+ Name string

+ UpdatedAt string

+ type UpdateUserRoleParams struct

+ ID string

+ Role sql.NullString

+ UpdatedAt string

+ type User struct

+ Avatar sql.NullString

+ BanCounter int64

+ BanExpiry sql.NullString

+ BanReason sql.NullString

+ Banned int64

+ CreatedAt string

+ Disabled int64

+ Email sql.NullString

+ ID string

+ Name string

+ Role sql.NullString

+ UpdatedAt string

+ type Verification struct

+ CreatedAt string

+ ExpiresAt string

+ ID string

+ Identifier string

+ Token string

+ Type string

Other modules containing this package

github.com/theinventorylib/aegis