sqlc

package

Go to main page

Versions in this module

v0

v0.5.0

Dec 19, 2022

Changes in this version

+ type MergeAliasesParams struct

+ Keep uuid.UUID

+ Merge uuid.UUID

+ type MergeOccurrencesParams struct

+ Keep uuid.UUID

+ Merge uuid.UUID

+ type MergeReviewsParams struct

+ Keep uuid.UUID

+ Merge uuid.UUID

+ type MergeSameDayOccurrencesParams struct

+ Keep uuid.UUID

+ Merge uuid.UUID

+ type MergeSideDishesParams struct

+ Keep uuid.UUID

+ Merge uuid.UUID

type Querier

+ DeleteDish func(ctx context.Context, id uuid.UUID) (*Dish, error)

+ MergeAliases func(ctx context.Context, arg *MergeAliasesParams) error

+ MergeOccurrences func(ctx context.Context, arg *MergeOccurrencesParams) error

+ MergeReviews func(ctx context.Context, arg *MergeReviewsParams) error

+ MergeSameDayOccurrences func(ctx context.Context, arg *MergeSameDayOccurrencesParams) error

+ MergeSideDishes func(ctx context.Context, arg *MergeSideDishesParams) error

type Queries

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

+ func (q *Queries) MergeAliases(ctx context.Context, arg *MergeAliasesParams) error

+ func (q *Queries) MergeOccurrences(ctx context.Context, arg *MergeOccurrencesParams) error

+ func (q *Queries) MergeReviews(ctx context.Context, arg *MergeReviewsParams) error

+ func (q *Queries) MergeSameDayOccurrences(ctx context.Context, arg *MergeSameDayOccurrencesParams) error

+ func (q *Queries) MergeSideDishes(ctx context.Context, arg *MergeSideDishesParams) error

v0.4.0

Oct 23, 2022

Changes in this version

type AddImageToReviewParams

+ ImageHash string

type AddMultipleImagesToReviewParams

+ ImageHash string

type Image

+ ImageHash string

type Querier

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

type Queries

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

v0.3.0

Jul 30, 2022

Changes in this version

+ type AddImageToReviewParams struct

+ ImageStoreID string

+ Review uuid.UUID

+ type AddMultipleImagesToReviewParams struct

+ ImageStoreID string

+ Review uuid.UUID

+ type AddMultipleOccurrenceSideDishesParams struct

+ Dish uuid.UUID

+ Occurrence uuid.UUID

+ type AddMultipleOccurrenceTagsParams struct

+ Occurrence uuid.UUID

+ Tag string

+ type AddOccurrenceSideDishParams struct

+ Dish uuid.UUID

+ Occurrence uuid.UUID

+ type AddOccurrenceTagParams struct

+ Occurrence uuid.UUID

+ Tag string

+ type CreateDishAliasParams struct

+ AliasName string

+ Dish uuid.UUID

+ NormalizedAliasName string

+ type CreateDishParams struct

+ NameDe string

+ NameEn sql.NullString

+ type CreateOccurrenceParams struct

+ Carbohydrates sql.NullInt32

+ Date time.Time

+ Dish uuid.UUID

+ Fat sql.NullInt32

+ Fiber sql.NullInt32

+ Kcal sql.NullInt32

+ Kj sql.NullInt32

+ Location uuid.UUID

+ PriceGuest sql.NullInt32

+ PriceStaff sql.NullInt32

+ PriceStudent sql.NullInt32

+ Protein sql.NullInt32

+ Salt sql.NullInt32

+ SaturatedFat sql.NullInt32

+ Status OccurrenceStatus

+ Sugar sql.NullInt32

+ type CreateReviewParams struct

+ DisplayName sql.NullString

+ Occurrence uuid.UUID

+ Stars int32

+ Text sql.NullString

+ type CreateTagParams struct

+ Description string

+ IsAllergy bool

+ Key string

+ Name string

+ Priority Priority

+ ShortName sql.NullString

+ type DBTX interface

+ CopyFrom func(ctx context.Context, tableName pgx.Identifier, columnNames []string, ...) (int64, error)

+ 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 Dish struct

+ ID uuid.UUID

+ NameDe string

+ NameEn sql.NullString

+ type DishAlias struct

+ AliasName string

+ Dish uuid.UUID

+ NormalizedAliasName string

+ type GetDishReviewMetadataParams struct

+ Approved sql.NullBool

+ ID uuid.UUID

+ type GetDishReviewMetadataRow struct

+ AverageStars pgtype.Numeric

+ ReviewCount int64

+ type GetDishReviewsParams struct

+ Approved sql.NullBool

+ ID uuid.UUID

+ type GetFilteredOccurrencesParams struct

+ EndDate sql.NullTime

+ Location uuid.NullUUID

+ StartDate sql.NullTime

+ Status NullOccurrenceStatus

+ type GetOccurrenceReviewMetadataParams struct

+ Approved sql.NullBool

+ Occurrence uuid.UUID

+ type GetOccurrenceReviewMetadataRow struct

+ AverageStars pgtype.Numeric

+ ReviewCount int64

+ type GetOccurrenceReviewsParams struct

+ Approved sql.NullBool

+ ID uuid.UUID

+ type Image struct

+ ID uuid.UUID

+ ImageStoreID string

+ Review uuid.UUID

+ type Location struct

+ ExternalID int32

+ ID uuid.UUID

+ Name string

+ type NullOccurrenceStatus struct

+ OccurrenceStatus OccurrenceStatus

+ Valid bool

+ func (ns *NullOccurrenceStatus) Scan(value interface{}) error

+ func (ns NullOccurrenceStatus) Value() (driver.Value, error)

+ type NullPriority struct

+ Priority Priority

+ Valid bool

+ func (ns *NullPriority) Scan(value interface{}) error

+ func (ns NullPriority) Value() (driver.Value, error)

+ type Occurrence struct

+ Carbohydrates sql.NullInt32

+ Date time.Time

+ Dish uuid.UUID

+ Fat sql.NullInt32

+ Fiber sql.NullInt32

+ ID uuid.UUID

+ Kcal sql.NullInt32

+ Kj sql.NullInt32

+ Location uuid.UUID

+ PriceGuest sql.NullInt32

+ PriceStaff sql.NullInt32

+ PriceStudent sql.NullInt32

+ Protein sql.NullInt32

+ Salt sql.NullInt32

+ SaturatedFat sql.NullInt32

+ Status OccurrenceStatus

+ Sugar sql.NullInt32

+ type OccurrenceSideDish struct

+ Dish uuid.UUID

+ Occurrence uuid.UUID

+ type OccurrenceStatus string

+ const OccurrenceStatusAPPROVED

+ const OccurrenceStatusAWAITINGAPPROVAL

+ const OccurrenceStatusCONFIRMED

+ const OccurrenceStatusPENDINGDELETION

+ const OccurrenceStatusUPDATED

+ func (e *OccurrenceStatus) Scan(src interface{}) error

+ type OccurrenceTag struct

+ Occurrence uuid.UUID

+ Tag string

+ type Priority string

+ const PriorityHIDE

+ const PriorityHIGH

+ const PriorityLOW

+ const PriorityMEDIUM

+ func (e *Priority) Scan(src interface{}) error

+ type Querier interface

+ AddImageToReview func(ctx context.Context, arg *AddImageToReviewParams) (*Image, error)

+ AddMultipleImagesToReview func(ctx context.Context, arg []*AddMultipleImagesToReviewParams) (int64, error)

+ AddMultipleOccurrenceSideDishes func(ctx context.Context, arg []*AddMultipleOccurrenceSideDishesParams) (int64, error)

+ AddMultipleOccurrenceTags func(ctx context.Context, arg []*AddMultipleOccurrenceTagsParams) (int64, error)

+ AddOccurrenceSideDish func(ctx context.Context, arg *AddOccurrenceSideDishParams) (*OccurrenceSideDish, error)

+ AddOccurrenceTag func(ctx context.Context, arg *AddOccurrenceTagParams) (*OccurrenceTag, error)

+ CreateDish func(ctx context.Context, arg *CreateDishParams) (*Dish, error)

+ CreateDishAlias func(ctx context.Context, arg *CreateDishAliasParams) (*DishAlias, error)

+ CreateOccurrence func(ctx context.Context, arg *CreateOccurrenceParams) (*Occurrence, error)

+ CreateReview func(ctx context.Context, arg *CreateReviewParams) (*Review, error)

+ CreateTag func(ctx context.Context, arg *CreateTagParams) (*Tag, error)

+ DeleteDishAlias func(ctx context.Context, aliasName string) (*DishAlias, error)

+ DeleteImage func(ctx context.Context, id uuid.UUID) (*Image, error)

+ DeleteOccurrence func(ctx context.Context, id uuid.UUID) (*Occurrence, error)

+ DeleteReview func(ctx context.Context, id uuid.UUID) (*Review, error)

+ GetAliasesForDish func(ctx context.Context, dish uuid.UUID) ([]string, error)

+ GetAllAliases func(ctx context.Context) ([]*DishAlias, error)

+ GetAllDishes func(ctx context.Context) ([]*Dish, error)

+ GetAllImages func(ctx context.Context) ([]*Image, error)

+ GetAllLocations func(ctx context.Context) ([]*Location, error)

+ GetAllOccurrences func(ctx context.Context) ([]*Occurrence, error)

+ GetAllReviews func(ctx context.Context) ([]*Review, error)

+ GetAllTags func(ctx context.Context) ([]*Tag, error)

+ GetDishByID func(ctx context.Context, id uuid.UUID) (*Dish, error)

+ GetDishReviewMetadata func(ctx context.Context, arg *GetDishReviewMetadataParams) (*GetDishReviewMetadataRow, error)

+ GetDishReviews func(ctx context.Context, arg *GetDishReviewsParams) ([]*Review, error)

+ GetFilteredOccurrences func(ctx context.Context, arg *GetFilteredOccurrencesParams) ([]*Occurrence, error)

+ GetImageByID func(ctx context.Context, id uuid.UUID) (*Image, error)

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

+ GetImagesByDish func(ctx context.Context, id uuid.UUID) ([]*Image, error)

+ GetImagesByOccurrence func(ctx context.Context, id uuid.UUID) ([]*Image, error)

+ GetImagesByReview func(ctx context.Context, id uuid.UUID) ([]*Image, error)

+ GetImagesForOccurrence func(ctx context.Context, id uuid.UUID) ([]*Image, error)

+ GetLocationByID func(ctx context.Context, id uuid.UUID) (*Location, error)

+ GetOccurrenceByID func(ctx context.Context, id uuid.UUID) (*Occurrence, error)

+ GetOccurrenceReviewMetadata func(ctx context.Context, arg *GetOccurrenceReviewMetadataParams) (*GetOccurrenceReviewMetadataRow, error)

+ GetOccurrenceReviews func(ctx context.Context, arg *GetOccurrenceReviewsParams) ([]*Review, error)

+ GetOccurrencesAfterInclusiveDate func(ctx context.Context, date time.Time) ([]*Occurrence, error)

+ GetOccurrencesByDate func(ctx context.Context, date time.Time) ([]*Occurrence, error)

+ GetReviewByID func(ctx context.Context, id uuid.UUID) (*Review, error)

+ GetReviewByImage func(ctx context.Context, id uuid.UUID) (*Review, error)

+ GetSideDishesForOccurrence func(ctx context.Context, occurrence uuid.UUID) ([]*Dish, error)

+ GetTagByKey func(ctx context.Context, key string) (*Tag, error)

+ GetTagsForOccurrence func(ctx context.Context, occurrence uuid.UUID) ([]*Tag, error)

+ GetUserByEmail func(ctx context.Context, email string) (*User, error)

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

+ RemoveOccurrenceSideDish func(ctx context.Context, arg *RemoveOccurrenceSideDishParams) (*OccurrenceSideDish, error)

+ RemoveOccurrenceTag func(ctx context.Context, arg *RemoveOccurrenceTagParams) (*OccurrenceTag, error)

+ SetReviewApproval func(ctx context.Context, arg *SetReviewApprovalParams) (*Review, error)

+ UpdateDish func(ctx context.Context, arg *UpdateDishParams) (*Dish, error)

+ UpdateDishAlias func(ctx context.Context, arg *UpdateDishAliasParams) (*DishAlias, error)

+ UpdateOccurrence func(ctx context.Context, arg *UpdateOccurrenceParams) (*Occurrence, error)

+ UpdateReview func(ctx context.Context, arg *UpdateReviewParams) (*Review, error)

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) AddImageToReview(ctx context.Context, arg *AddImageToReviewParams) (*Image, error)

+ func (q *Queries) AddMultipleImagesToReview(ctx context.Context, arg []*AddMultipleImagesToReviewParams) (int64, error)

+ func (q *Queries) AddMultipleOccurrenceSideDishes(ctx context.Context, arg []*AddMultipleOccurrenceSideDishesParams) (int64, error)

+ func (q *Queries) AddMultipleOccurrenceTags(ctx context.Context, arg []*AddMultipleOccurrenceTagsParams) (int64, error)

+ func (q *Queries) AddOccurrenceSideDish(ctx context.Context, arg *AddOccurrenceSideDishParams) (*OccurrenceSideDish, error)

+ func (q *Queries) AddOccurrenceTag(ctx context.Context, arg *AddOccurrenceTagParams) (*OccurrenceTag, error)

+ func (q *Queries) CreateDish(ctx context.Context, arg *CreateDishParams) (*Dish, error)

+ func (q *Queries) CreateDishAlias(ctx context.Context, arg *CreateDishAliasParams) (*DishAlias, error)

+ func (q *Queries) CreateOccurrence(ctx context.Context, arg *CreateOccurrenceParams) (*Occurrence, error)

+ func (q *Queries) CreateReview(ctx context.Context, arg *CreateReviewParams) (*Review, error)

+ func (q *Queries) CreateTag(ctx context.Context, arg *CreateTagParams) (*Tag, error)

+ func (q *Queries) DeleteDishAlias(ctx context.Context, aliasName string) (*DishAlias, error)

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

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

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

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

+ func (q *Queries) GetAllAliases(ctx context.Context) ([]*DishAlias, error)

+ func (q *Queries) GetAllDishes(ctx context.Context) ([]*Dish, error)

+ func (q *Queries) GetAllImages(ctx context.Context) ([]*Image, error)

+ func (q *Queries) GetAllLocations(ctx context.Context) ([]*Location, error)

+ func (q *Queries) GetAllOccurrences(ctx context.Context) ([]*Occurrence, error)

+ func (q *Queries) GetAllReviews(ctx context.Context) ([]*Review, error)

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

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

+ func (q *Queries) GetDishReviewMetadata(ctx context.Context, arg *GetDishReviewMetadataParams) (*GetDishReviewMetadataRow, error)

+ func (q *Queries) GetDishReviews(ctx context.Context, arg *GetDishReviewsParams) ([]*Review, error)

+ func (q *Queries) GetFilteredOccurrences(ctx context.Context, arg *GetFilteredOccurrencesParams) ([]*Occurrence, error)

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

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

+ func (q *Queries) GetImagesByDish(ctx context.Context, id uuid.UUID) ([]*Image, error)

+ func (q *Queries) GetImagesByOccurrence(ctx context.Context, id uuid.UUID) ([]*Image, error)

+ func (q *Queries) GetImagesByReview(ctx context.Context, id uuid.UUID) ([]*Image, error)

+ func (q *Queries) GetImagesForOccurrence(ctx context.Context, id uuid.UUID) ([]*Image, error)

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

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

+ func (q *Queries) GetOccurrenceReviewMetadata(ctx context.Context, arg *GetOccurrenceReviewMetadataParams) (*GetOccurrenceReviewMetadataRow, error)

+ func (q *Queries) GetOccurrenceReviews(ctx context.Context, arg *GetOccurrenceReviewsParams) ([]*Review, error)

+ func (q *Queries) GetOccurrencesAfterInclusiveDate(ctx context.Context, date time.Time) ([]*Occurrence, error)

+ func (q *Queries) GetOccurrencesByDate(ctx context.Context, date time.Time) ([]*Occurrence, error)

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

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

+ func (q *Queries) GetSideDishesForOccurrence(ctx context.Context, occurrence uuid.UUID) ([]*Dish, error)

+ func (q *Queries) GetTagByKey(ctx context.Context, key string) (*Tag, error)

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

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

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

+ func (q *Queries) RemoveOccurrenceSideDish(ctx context.Context, arg *RemoveOccurrenceSideDishParams) (*OccurrenceSideDish, error)

+ func (q *Queries) RemoveOccurrenceTag(ctx context.Context, arg *RemoveOccurrenceTagParams) (*OccurrenceTag, error)

+ func (q *Queries) SetReviewApproval(ctx context.Context, arg *SetReviewApprovalParams) (*Review, error)

+ func (q *Queries) UpdateDish(ctx context.Context, arg *UpdateDishParams) (*Dish, error)

+ func (q *Queries) UpdateDishAlias(ctx context.Context, arg *UpdateDishAliasParams) (*DishAlias, error)

+ func (q *Queries) UpdateOccurrence(ctx context.Context, arg *UpdateOccurrenceParams) (*Occurrence, error)

+ func (q *Queries) UpdateReview(ctx context.Context, arg *UpdateReviewParams) (*Review, error)

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

+ type RemoveOccurrenceSideDishParams struct

+ Dish uuid.UUID

+ Occurrence uuid.UUID

+ type RemoveOccurrenceTagParams struct

+ Occurrence uuid.UUID

+ Tag string

+ type Review struct

+ AcceptedAt sql.NullTime

+ CreatedAt time.Time

+ DisplayName sql.NullString

+ ID uuid.UUID

+ Occurrence uuid.UUID

+ Stars int32

+ Text sql.NullString

+ UpdatedAt time.Time

+ type SetReviewApprovalParams struct

+ AcceptedAt sql.NullTime

+ ID uuid.UUID

+ type Tag struct

+ Description string

+ IsAllergy bool

+ Key string

+ Name string

+ Priority Priority

+ ShortName sql.NullString

+ type UpdateDishAliasParams struct

+ AliasName string

+ Dish uuid.NullUUID

+ NewAliasName sql.NullString

+ NormalizedAliasName sql.NullString

+ type UpdateDishParams struct

+ ID uuid.UUID

+ NameDe sql.NullString

+ NameEn sql.NullString

+ type UpdateOccurrenceParams struct

+ Carbohydrates sql.NullInt32

+ Date sql.NullTime

+ Dish uuid.NullUUID

+ Fat sql.NullInt32

+ Fiber sql.NullInt32

+ ID uuid.UUID

+ Kcal sql.NullInt32

+ Kj sql.NullInt32

+ PriceGuest sql.NullInt32

+ PriceStaff sql.NullInt32

+ PriceStudent sql.NullInt32

+ Protein sql.NullInt32

+ Salt sql.NullInt32

+ SaturatedFat sql.NullInt32

+ Status NullOccurrenceStatus

+ Sugar sql.NullInt32

+ type UpdateReviewParams struct

+ Approved sql.NullBool

+ DisplayName sql.NullString

+ ID uuid.UUID

+ Occurrence uuid.NullUUID

+ Stars sql.NullInt32

+ Text sql.NullString

+ type User struct

+ CreatedAt time.Time

+ Email string

+ ID uuid.UUID

+ PasswordHash string

+ UpdatedAt time.Time

v0.2.1

Jun 23, 2022

v0.2.0

Jun 23, 2022

v0.1.0

Jun 7, 2022

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