pgstore

package
v1.4.9 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Oct 28, 2025 License: Apache-2.0 Imports: 4 Imported by: 0

Documentation

Overview

Package pgstore contains query helpers generated from db/queries/* using sqlc.

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type ChangeTagCategoryParams 

type ChangeTagCategoryParams struct {
	ID         uuid.UUID
	CategoryID uuid.UUID
}

type Collection 

type Collection struct {
	ID        uuid.UUID
	UserID    uuid.UUID
	Name      string
	CreatedAt time.Time
}

type Consumption 

type Consumption struct {
	Ts    time.Time
	TeaID uuid.UUID
}

type InsertCollectionParams 

type InsertCollectionParams struct {
	ID     uuid.UUID
	UserID uuid.UUID
	Name   string
}

type InsertConsumptionParams 

type InsertConsumptionParams struct {
	UserID uuid.UUID
	Ts     time.Time
	TeaID  uuid.UUID
}

type InsertTagCategoryParams 

type InsertTagCategoryParams struct {
	ID   uuid.UUID
	Name string
}

type InsertTagParams 

type InsertTagParams struct {
	ID         uuid.UUID
	Name       string
	Color      string
	CategoryID uuid.UUID
}

type InsertTeaParams 

type InsertTeaParams struct {
	ID          uuid.UUID
	Name        string
	Type        string
	Description sql.NullString
}

type ListCollectionRecordsRow 

type ListCollectionRecordsRow struct {
	QRID           uuid.UUID
	TeaID          uuid.UUID
	Name           string
	Type           string
	Description    sql.NullString
	BoilingTemp    int32
	ExpirationDate time.Time
}

type ListConsumptionsSinceParams 

type ListConsumptionsSinceParams struct {
	UserID uuid.UUID
	Since  time.Time
}

type Notification 

type Notification struct {
	ID        uuid.UUID
	UserID    uuid.UUID
	Type      int16
	CreatedAt time.Time
}

type QRRecord 

type QRRecord struct {
	ID             uuid.UUID
	TeaID          uuid.UUID
	BoilingTemp    int32
	ExpirationDate time.Time
	CreatedAt      time.Time
}

type Queries 

type Queries struct {
	// contains filtered or unexported fields
}

func New 

func New(db *sql.DB) *Queries

func (*Queries) AddTagToTea 

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

func (*Queries) ChangeTagCategory 

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

func (*Queries) DB 

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

func (*Queries) DeleteCollection 

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

func (*Queries) DeleteCollectionItem 

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

func (*Queries) DeleteConsumptionsBefore 

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

func (*Queries) DeleteTag 

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

func (*Queries) DeleteTagCategory 

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

func (*Queries) DeleteTagFromTea 

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

func (*Queries) DeleteTagsByCategory 

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

func (*Queries) DeleteTea 

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

func (*Queries) GetCollection 

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

func (*Queries) GetQR 

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

func (*Queries) GetTag 

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

func (*Queries) GetTagCategory 

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

func (*Queries) GetTea 

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

func (*Queries) InsertCollection 

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

func (*Queries) InsertCollectionItem 

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

func (*Queries) InsertCollectionItems added in v1.4.7 

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

func (*Queries) InsertConsumption 

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

func (*Queries) InsertDevice 

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

func (*Queries) InsertTag 

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

func (*Queries) InsertTagCategory 

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

func (*Queries) InsertTea 

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

func (*Queries) ListCollectionRecords 

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

func (*Queries) ListCollections 

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

func (*Queries) ListConsumptionsSince 

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

func (*Queries) ListDeviceTokens 

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

func (*Queries) ListNotifications 

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

func (*Queries) ListTagCategories 

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

func (*Queries) ListTags 

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

func (*Queries) ListTagsByCategory 

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

func (*Queries) ListTagsByCategoryFilter 

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

func (*Queries) ListTagsByName 

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

func (*Queries) ListTagsByNameCategory 

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

func (*Queries) ListTagsByTea 

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

func (*Queries) ListTeas 

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

func (*Queries) ListUsers 

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

func (*Queries) SearchTagCategories 

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

func (*Queries) SearchTeasByPrefix 

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

func (*Queries) UpdateDeviceToken 

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

func (*Queries) UpdateTag 

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

func (*Queries) UpdateTagCategory 

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

func (*Queries) UpdateTea 

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

func (*Queries) UpsertQR 

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

func (*Queries) UpsertUser 

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

type Tag 

type Tag struct {
	ID         uuid.UUID
	Name       string
	Color      string
	CategoryID uuid.UUID
}

type TagCategory 

type TagCategory struct {
	ID   uuid.UUID
	Name string
}

type Tea 

type Tea struct {
	ID          uuid.UUID
	Name        string
	Type        string
	Description sql.NullString
	CreatedAt   time.Time
}

type UpdateTagCategoryParams 

type UpdateTagCategoryParams struct {
	ID   uuid.UUID
	Name string
}

type UpdateTagParams 

type UpdateTagParams struct {
	ID    uuid.UUID
	Name  string
	Color string
}

type UpdateTeaParams 

type UpdateTeaParams struct {
	ID          uuid.UUID
	Name        string
	Type        string
	Description sql.NullString
}

type UpsertUserParams 

type UpsertUserParams struct {
	ID      uuid.UUID
	AppleID string
}

type User 

type User struct {
	ID        uuid.UUID
	AppleID   string
	CreatedAt time.Time
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.