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

pgstore

package

Go to main page

Versions in this module

v1

v1.4.13

Feb 8, 2026

v1.4.12

Nov 1, 2025

v1.4.11

Nov 1, 2025

v1.4.10

Nov 1, 2025

v1.4.9

Oct 28, 2025

v1.4.8

Oct 23, 2025

v1.4.7

Oct 23, 2025

Changes in this version

type Queries

+ func (q *Queries) InsertCollectionItems(ctx context.Context, collectionID uuid.UUID, qrIDs []uuid.UUID) error

v1.4.6

Oct 19, 2025

Changes in this version

+ type ChangeTagCategoryParams struct

+ CategoryID uuid.UUID

+ ID uuid.UUID

+ type Collection struct

+ CreatedAt time.Time

+ ID uuid.UUID

+ Name string

+ UserID uuid.UUID

+ type Consumption struct

+ TeaID uuid.UUID

+ Ts time.Time

+ type InsertCollectionParams struct

+ ID uuid.UUID

+ Name string

+ UserID uuid.UUID

+ type InsertConsumptionParams struct

+ TeaID uuid.UUID

+ Ts time.Time

+ UserID uuid.UUID

+ type InsertTagCategoryParams struct

+ ID uuid.UUID

+ Name string

+ type InsertTagParams struct

+ CategoryID uuid.UUID

+ Color string

+ ID uuid.UUID

+ Name string

+ type InsertTeaParams struct

+ Description sql.NullString

+ ID uuid.UUID

+ Name string

+ Type string

+ type ListCollectionRecordsRow struct

+ BoilingTemp int32

+ Description sql.NullString

+ ExpirationDate time.Time

+ Name string

+ QRID uuid.UUID

+ TeaID uuid.UUID

+ Type string

+ type ListConsumptionsSinceParams struct

+ Since time.Time

+ UserID uuid.UUID

+ type Notification struct

+ CreatedAt time.Time

+ ID uuid.UUID

+ Type int16

+ UserID uuid.UUID

+ type QRRecord struct

+ BoilingTemp int32

+ CreatedAt time.Time

+ ExpirationDate time.Time

+ ID uuid.UUID

+ TeaID uuid.UUID

+ type Queries struct

+ func New(db *sql.DB) *Queries

+ func (q *Queries) AddTagToTea(ctx context.Context, teaID uuid.UUID, tagID uuid.UUID) error

+ func (q *Queries) ChangeTagCategory(ctx context.Context, arg ChangeTagCategoryParams) (Tag, error)

+ func (q *Queries) DB() *sql.DB

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

+ func (q *Queries) DeleteCollectionItem(ctx context.Context, collectionID uuid.UUID, qrID uuid.UUID) error

+ func (q *Queries) DeleteConsumptionsBefore(ctx context.Context, userID uuid.UUID, cutoff time.Time) error

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

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

+ func (q *Queries) DeleteTagFromTea(ctx context.Context, teaID uuid.UUID, tagID uuid.UUID) error

+ func (q *Queries) DeleteTagsByCategory(ctx context.Context, categoryID uuid.UUID) error

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

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

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

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

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

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

+ func (q *Queries) InsertCollection(ctx context.Context, arg InsertCollectionParams) (Collection, error)

+ func (q *Queries) InsertCollectionItem(ctx context.Context, collectionID uuid.UUID, qrID uuid.UUID) error

+ func (q *Queries) InsertConsumption(ctx context.Context, arg InsertConsumptionParams) error

+ func (q *Queries) InsertDevice(ctx context.Context, id uuid.UUID, userID uuid.UUID, token string) error

+ func (q *Queries) InsertTag(ctx context.Context, arg InsertTagParams) (Tag, error)

+ func (q *Queries) InsertTagCategory(ctx context.Context, arg InsertTagCategoryParams) (TagCategory, error)

+ func (q *Queries) InsertTea(ctx context.Context, arg InsertTeaParams) (Tea, error)

+ func (q *Queries) ListCollectionRecords(ctx context.Context, collectionID uuid.UUID) ([]ListCollectionRecordsRow, error)

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

+ func (q *Queries) ListConsumptionsSince(ctx context.Context, arg ListConsumptionsSinceParams) ([]Consumption, error)

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

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

+ func (q *Queries) ListTagCategories(ctx context.Context) ([]TagCategory, error)

+ func (q *Queries) ListTags(ctx context.Context) ([]Tag, error)

+ func (q *Queries) ListTagsByCategory(ctx context.Context, categoryID uuid.UUID) ([]Tag, error)

+ func (q *Queries) ListTagsByCategoryFilter(ctx context.Context, categoryID uuid.UUID) ([]Tag, error)

+ func (q *Queries) ListTagsByName(ctx context.Context, prefix string) ([]Tag, error)

+ func (q *Queries) ListTagsByNameCategory(ctx context.Context, prefix string, categoryID uuid.UUID) ([]Tag, error)

+ func (q *Queries) ListTagsByTea(ctx context.Context, teaID uuid.UUID) ([]Tag, error)

+ func (q *Queries) ListTeas(ctx context.Context) ([]Tea, error)

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

+ func (q *Queries) SearchTagCategories(ctx context.Context, prefix string) ([]TagCategory, error)

+ func (q *Queries) SearchTeasByPrefix(ctx context.Context, name string, limit int32) ([]Tea, error)

+ func (q *Queries) UpdateDeviceToken(ctx context.Context, id uuid.UUID, token string) (int64, error)

+ func (q *Queries) UpdateTag(ctx context.Context, arg UpdateTagParams) (Tag, error)

+ func (q *Queries) UpdateTagCategory(ctx context.Context, arg UpdateTagCategoryParams) (TagCategory, error)

+ func (q *Queries) UpdateTea(ctx context.Context, arg UpdateTeaParams) (Tea, error)

+ func (q *Queries) UpsertQR(ctx context.Context, arg QRRecord) error

+ func (q *Queries) UpsertUser(ctx context.Context, arg UpsertUserParams) (User, error)

+ type Tag struct

+ CategoryID uuid.UUID

+ Color string

+ ID uuid.UUID

+ Name string

+ type TagCategory struct

+ ID uuid.UUID

+ Name string

+ type Tea struct

+ CreatedAt time.Time

+ Description sql.NullString

+ ID uuid.UUID

+ Name string

+ Type string

+ type UpdateTagCategoryParams struct

+ ID uuid.UUID

+ Name string

+ type UpdateTagParams struct

+ Color string

+ ID uuid.UUID

+ Name string

+ type UpdateTeaParams struct

+ Description sql.NullString

+ ID uuid.UUID

+ Name string

+ Type string

+ type UpsertUserParams struct

+ AppleID string

+ ID uuid.UUID

+ type User struct

+ AppleID string

+ CreatedAt time.Time

+ ID uuid.UUID