pgstore

package
v1.4.13 Latest Latest
Warning

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

Go to latest
Published: Feb 8, 2026 License: Apache-2.0 Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type AddTagToTeaParams

type AddTagToTeaParams struct {
	TeaID uuid.UUID `json:"tea_id"`
	TagID uuid.UUID `json:"tag_id"`
}

type ChangeTagCategoryParams

type ChangeTagCategoryParams struct {
	ID         uuid.UUID `json:"id"`
	CategoryID uuid.UUID `json:"category_id"`
}

type Collection

type Collection struct {
	ID        uuid.UUID `json:"id"`
	UserID    uuid.UUID `json:"user_id"`
	Name      string    `json:"name"`
	CreatedAt time.Time `json:"created_at"`
}

type CollectionQrItem

type CollectionQrItem struct {
	CollectionID uuid.UUID `json:"collection_id"`
	QrID         uuid.UUID `json:"qr_id"`
}

type Consumption

type Consumption struct {
	UserID uuid.UUID `json:"user_id"`
	Ts     time.Time `json:"ts"`
	TeaID  uuid.UUID `json:"tea_id"`
}

type DBTX

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type DeleteCollectionItemParams

type DeleteCollectionItemParams struct {
	CollectionID uuid.UUID `json:"collection_id"`
	QrID         uuid.UUID `json:"qr_id"`
}

type DeleteCollectionParams

type DeleteCollectionParams struct {
	ID     uuid.UUID `json:"id"`
	UserID uuid.UUID `json:"user_id"`
}

type DeleteConsumptionsBeforeParams

type DeleteConsumptionsBeforeParams struct {
	UserID uuid.UUID `json:"user_id"`
	Ts     time.Time `json:"ts"`
}

type DeleteTagFromTeaParams

type DeleteTagFromTeaParams struct {
	TeaID uuid.UUID `json:"tea_id"`
	TagID uuid.UUID `json:"tag_id"`
}

type Device

type Device struct {
	ID        uuid.UUID `json:"id"`
	UserID    uuid.UUID `json:"user_id"`
	Token     string    `json:"token"`
	CreatedAt time.Time `json:"created_at"`
}

type GetCollectionParams

type GetCollectionParams struct {
	ID     uuid.UUID `json:"id"`
	UserID uuid.UUID `json:"user_id"`
}

type InsertCollectionItemParams

type InsertCollectionItemParams struct {
	CollectionID uuid.UUID `json:"collection_id"`
	QrID         uuid.UUID `json:"qr_id"`
}

type InsertCollectionParams

type InsertCollectionParams struct {
	ID     uuid.UUID `json:"id"`
	UserID uuid.UUID `json:"user_id"`
	Name   string    `json:"name"`
}

type InsertConsumptionParams

type InsertConsumptionParams struct {
	UserID uuid.UUID `json:"user_id"`
	Ts     time.Time `json:"ts"`
	TeaID  uuid.UUID `json:"tea_id"`
}

type InsertDeviceParams

type InsertDeviceParams struct {
	ID     uuid.UUID `json:"id"`
	UserID uuid.UUID `json:"user_id"`
	Token  string    `json:"token"`
}

type InsertTagCategoryParams

type InsertTagCategoryParams struct {
	ID   uuid.UUID `json:"id"`
	Name string    `json:"name"`
}

type InsertTagParams

type InsertTagParams struct {
	ID         uuid.UUID `json:"id"`
	Name       string    `json:"name"`
	Color      string    `json:"color"`
	CategoryID uuid.UUID `json:"category_id"`
}

type InsertTeaParams

type InsertTeaParams struct {
	ID          uuid.UUID   `json:"id"`
	Name        string      `json:"name"`
	Type        string      `json:"type"`
	Description pgtype.Text `json:"description"`
}

type ListCollectionRecordsRow

type ListCollectionRecordsRow struct {
	QrID           uuid.UUID   `json:"qr_id"`
	TeaID          uuid.UUID   `json:"tea_id"`
	Name           string      `json:"name"`
	Type           string      `json:"type"`
	Description    pgtype.Text `json:"description"`
	BoilingTemp    int32       `json:"boiling_temp"`
	ExpirationDate time.Time   `json:"expiration_date"`
}

type ListConsumptionsSinceParams

type ListConsumptionsSinceParams struct {
	UserID uuid.UUID `json:"user_id"`
	Ts     time.Time `json:"ts"`
}

type ListConsumptionsSinceRow

type ListConsumptionsSinceRow struct {
	Ts    time.Time `json:"ts"`
	TeaID uuid.UUID `json:"tea_id"`
}

type ListTagsByNameCategoryParams

type ListTagsByNameCategoryParams struct {
	Lower      string    `json:"lower"`
	CategoryID uuid.UUID `json:"category_id"`
}

type Notification

type Notification struct {
	ID        uuid.UUID `json:"id"`
	UserID    uuid.UUID `json:"user_id"`
	Type      int16     `json:"type"`
	CreatedAt time.Time `json:"created_at"`
}

type QrRecord

type QrRecord struct {
	ID             uuid.UUID `json:"id"`
	TeaID          uuid.UUID `json:"tea_id"`
	BoilingTemp    int32     `json:"boiling_temp"`
	ExpirationDate time.Time `json:"expiration_date"`
	CreatedAt      time.Time `json:"created_at"`
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) AddTagToTea

func (q *Queries) AddTagToTea(ctx context.Context, arg AddTagToTeaParams) error

func (*Queries) ChangeTagCategory

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

func (*Queries) DeleteCollection

func (q *Queries) DeleteCollection(ctx context.Context, arg DeleteCollectionParams) error

func (*Queries) DeleteCollectionItem

func (q *Queries) DeleteCollectionItem(ctx context.Context, arg DeleteCollectionItemParams) error

func (*Queries) DeleteConsumptionsBefore

func (q *Queries) DeleteConsumptionsBefore(ctx context.Context, arg DeleteConsumptionsBeforeParams) 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, arg DeleteTagFromTeaParams) 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, arg GetCollectionParams) (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, arg InsertCollectionItemParams) error

func (*Queries) InsertConsumption

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

func (*Queries) InsertDevice

func (q *Queries) InsertDevice(ctx context.Context, arg InsertDeviceParams) 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) ([]ListConsumptionsSinceRow, 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, lower string) ([]Tag, error)

func (*Queries) ListTagsByNameCategory

func (q *Queries) ListTagsByNameCategory(ctx context.Context, arg ListTagsByNameCategoryParams) ([]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, lower string) ([]TagCategory, error)

func (*Queries) SearchTeasByPrefix

func (q *Queries) SearchTeasByPrefix(ctx context.Context, arg SearchTeasByPrefixParams) ([]Tea, error)

func (*Queries) UpdateDeviceToken

func (q *Queries) UpdateDeviceToken(ctx context.Context, arg UpdateDeviceTokenParams) 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 UpsertQRParams) error

func (*Queries) UpsertUser

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

func (*Queries) WithTx

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

type SearchTeasByPrefixParams

type SearchTeasByPrefixParams struct {
	Lower string `json:"lower"`
	Limit int32  `json:"limit"`
}

type Tag

type Tag struct {
	ID         uuid.UUID `json:"id"`
	Name       string    `json:"name"`
	Color      string    `json:"color"`
	CategoryID uuid.UUID `json:"category_id"`
}

type TagCategory

type TagCategory struct {
	ID   uuid.UUID `json:"id"`
	Name string    `json:"name"`
}

type Tea

type Tea struct {
	ID          uuid.UUID   `json:"id"`
	Name        string      `json:"name"`
	Type        string      `json:"type"`
	Description pgtype.Text `json:"description"`
	CreatedAt   time.Time   `json:"created_at"`
}

type TeaTag

type TeaTag struct {
	TeaID uuid.UUID `json:"tea_id"`
	TagID uuid.UUID `json:"tag_id"`
}

type UpdateDeviceTokenParams

type UpdateDeviceTokenParams struct {
	ID    uuid.UUID `json:"id"`
	Token string    `json:"token"`
}

type UpdateTagCategoryParams

type UpdateTagCategoryParams struct {
	ID   uuid.UUID `json:"id"`
	Name string    `json:"name"`
}

type UpdateTagParams

type UpdateTagParams struct {
	ID    uuid.UUID `json:"id"`
	Name  string    `json:"name"`
	Color string    `json:"color"`
}

type UpdateTeaParams

type UpdateTeaParams struct {
	ID          uuid.UUID   `json:"id"`
	Name        string      `json:"name"`
	Type        string      `json:"type"`
	Description pgtype.Text `json:"description"`
}

type UpsertQRParams

type UpsertQRParams struct {
	ID             uuid.UUID `json:"id"`
	TeaID          uuid.UUID `json:"tea_id"`
	BoilingTemp    int32     `json:"boiling_temp"`
	ExpirationDate time.Time `json:"expiration_date"`
}

type UpsertUserParams

type UpsertUserParams struct {
	ID      uuid.UUID `json:"id"`
	AppleID string    `json:"apple_id"`
}

type User

type User struct {
	ID        uuid.UUID `json:"id"`
	AppleID   string    `json:"apple_id"`
	CreatedAt time.Time `json:"created_at"`
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL