code.pfad.fr/buchungssystem/database ↑

database package

import "code.pfad.fr/buchungssystem/database"

Index

func MissingMigrations

❖ 
func MissingMigrations(db *sql.DB, dialect string) (func() error, error)

type AuthInsertParams

❖ 
type AuthInsertParams struct {
	ID    string
	Email string
	Name  string
}

type AuthSaveParams

❖ 
type AuthSaveParams struct {
	Email string
	ID    string
}

type BookableDay

❖ 
type BookableDay struct {
	Date              string
	HouseID           string
	PriceID           string
	RestrictionReason string
}

type BookableDayIndexParams

❖ 
type BookableDayIndexParams struct {
	HouseID string
	Start   string
	EndDate string
}

type BookableDayIndexUnlimitedParams

❖ 
type BookableDayIndexUnlimitedParams struct {
	HouseID string
	Start   string
}

type Booking

❖ 
type Booking struct {
	ID               int32
	HouseID          string
	StartAt          time.Time
	EndAt            time.Time
	PeopleOver       json.RawMessage
	Contact          string
	Email            string
	Phone            string
	Comment          string
	Invoice          json.RawMessage
	CreatedAt        time.Time
	AdminConfirmedAt sql.NullTime
	UserConfirmedAt  sql.NullTime
	CancelledAt      sql.NullTime
	HashedToken      string
	Landline         string
}

type BookingAdminChargesIndexRow

❖ 
type BookingAdminChargesIndexRow struct {
	ID   string
	Name string
}

type BookingAdminConfirmParams

❖ 
type BookingAdminConfirmParams struct {
	HashedToken string
	ID          int32
}

type BookingChargesIndexParams

❖ 
type BookingChargesIndexParams struct {
	HouseID string
	Start   string
	EndDate string
}

type BookingCommentUpdateParams

❖ 
type BookingCommentUpdateParams struct {
	Comment string
	ID      int32
}

type BookingCountForEmailParams

❖ 
type BookingCountForEmailParams struct {
	Email   string
	ID      int32
	HouseID string
}

type BookingCreateParams

❖ 
type BookingCreateParams struct {
	HouseID    string
	StartAt    time.Time
	EndAt      time.Time
	PeopleOver json.RawMessage
	Contact    string
	Email      string
	Phone      string
	Landline   string
	Comment    string
	Invoice    json.RawMessage
}

type BookingEndingAfterParams

❖ 
type BookingEndingAfterParams struct {
	HouseID string
	EndAt   time.Time
}

type BookingExpiredParams

❖ 
type BookingExpiredParams struct {
	AdminConfirmedAt sql.NullTime
	StartAt          time.Time
	HouseID          string
}

type BookingExtraCharge

❖ 
type BookingExtraCharge struct {
	BookingID int32
	ChargeID  string
	Percent   int32
}

type BookingExtraChargesCreateParams

❖ 
type BookingExtraChargesCreateParams struct {
	BookingID int32
	ChargeID  string
	Percent   int32
}

type BookingExtraChargesDeleteParams

❖ 
type BookingExtraChargesDeleteParams struct {
	BookingID int32
	ChargeID  string
}

type BookingExtraChargesUpdateParams

❖ 
type BookingExtraChargesUpdateParams struct {
	Percent   int32
	BookingID int32
	ChargeID  string
}

type BookingIndexParams

❖ 
type BookingIndexParams struct {
	HouseID               string
	StartAt               time.Time
	EndAt                 time.Time
	Search                string
	IncludeUnconfirmed    bool
	IncludeAdminConfirmed bool
	IncludeUserConfirmed  bool
	IncludeCancelled      bool
	PriceID               string
	AdminCharges          string
	AdminChargesCount     int32
	Limit                 int32
	Offset                int32
}

type BookingIndexRow

❖ 
type BookingIndexRow struct {
	ID               int32
	HouseID          string
	StartAt          time.Time
	EndAt            time.Time
	PeopleOver       json.RawMessage
	Contact          string
	Email            string
	Phone            string
	Comment          string
	Invoice          json.RawMessage
	CreatedAt        time.Time
	AdminConfirmedAt sql.NullTime
	UserConfirmedAt  sql.NullTime
	CancelledAt      sql.NullTime
	HashedToken      string
	Landline         string
	TotalCount       int64
}

type BookingOverlappingParams

❖ 
type BookingOverlappingParams struct {
	HouseID string
	StartAt time.Time
	EndAt   time.Time
}

type BookingPricesIndexParams

❖ 
type BookingPricesIndexParams struct {
	HouseID string
	Start   string
	EndDate string
}

type BookingStatusCountParams

❖ 
type BookingStatusCountParams struct {
	HouseID string
	EndAt   time.Time
}

type BookingStatusCountRow

❖ 
type BookingStatusCountRow struct {
	Status interface{}
	Count  int64
}

type BookingUpcomingParams

❖ 
type BookingUpcomingParams struct {
	HouseID string
	EndAt   time.Time
}

type BookingUpdateContactParams

❖ 
type BookingUpdateContactParams struct {
	Contact  string
	Email    string
	Phone    string
	Landline string
	Invoice  json.RawMessage
	ID       int32
}

type BookingUpdateDatesParams

❖ 
type BookingUpdateDatesParams struct {
	StartAt time.Time
	EndAt   time.Time
	ID      int32
}

type BookingUpdatePeopleAgesParams

❖ 
type BookingUpdatePeopleAgesParams struct {
	PeopleOver json.RawMessage
	ID         int32
}

type Charge

❖ 
type Charge struct {
	ID                     string
	Name                   string
	Description            string
	HouseID                string
	PriceID                string
	Unit                   string
	Amount                 int32
	MinPersonCharged       int32
	ChargedOverPersonCount int32
	ExemptedUnderAge       int32
	Optionality            string
	CreatedAt              time.Time
	DeletedAt              sql.NullTime
}

func (Charge) ChargedPeople

❖ 
func (c Charge) ChargedPeople(totalPeople int, ages map[int32]int) int

type DBTX

❖ 
type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type Email

❖ 
type Email struct {
	ID            string
	BookingID     int32
	HeaderFrom    string
	HeaderTo      string
	HeaderSubject string
	TextPlain     string
	CreatedAt     time.Time
	SentAt        sql.NullTime
	FatalError    string
}

type EmailCreateParams

❖ 
type EmailCreateParams struct {
	ID            string
	BookingID     int32
	HeaderFrom    string
	HeaderTo      string
	HeaderSubject string
	TextPlain     string
	FatalError    string
}

type EmailUpdateParams

❖ 
type EmailUpdateParams struct {
	SentAt     sql.NullTime
	FatalError string
	ID         string
}

type ExtraRequest

❖ 
type ExtraRequest struct {
	ID          int32
	Weight      int32
	HouseID     string
	Description string
	Pricing     string
}

type House

❖ 
type House struct {
	ID                      string
	Name                    string
	CreatedAt               time.Time
	MaxPerson               int32
	StartMinute             int32
	EndMinute               int32
	ReplyTo                 string
	DaysForUserConfirmation int32
	MonthsForPublicBooking  int32
	PublicBookingType       string
}

type HouseUser

❖ 
type HouseUser struct {
	UserID  string
	HouseID string
	Role    string
}

type LogEvent

❖ 
type LogEvent struct {
	ID        int32
	BookingID int32
	UserID    sql.NullString
	Message   string
	CreatedAt time.Time
}

type LogEventCreateParams

❖ 
type LogEventCreateParams struct {
	BookingID int32
	UserID    sql.NullString
	Message   string
}

type LogEventIndexRow

❖ 
type LogEventIndexRow struct {
	CreatedAt time.Time
	Message   string
	Name      string
}

type Price

❖ 
type Price struct {
	ID        string
	Name      string
	CreatedAt time.Time
	HiddenAt  sql.NullTime
}

type Queries

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

func New

❖ 
func New(db DBTX) *Queries

func (*Queries) AuthInsert

❖ 
func (q *Queries) AuthInsert(ctx context.Context, arg AuthInsertParams) error

func (*Queries) AuthLoad

❖ 
func (q *Queries) AuthLoad(ctx context.Context, id string) (User, error)

func (*Queries) AuthSave

❖ 
func (q *Queries) AuthSave(ctx context.Context, arg AuthSaveParams) error

func (*Queries) BookableDayIndex

❖ 
func (q *Queries) BookableDayIndex(ctx context.Context, arg BookableDayIndexParams) ([]BookableDay, error)

func (*Queries) BookableDayIndexUnlimited

❖ 
func (q *Queries) BookableDayIndexUnlimited(ctx context.Context, arg BookableDayIndexUnlimitedParams) ([]BookableDay, error)

func (*Queries) BookingAdminChargesIndex

❖ 
func (q *Queries) BookingAdminChargesIndex(ctx context.Context, houseID string) ([]BookingAdminChargesIndexRow, error)

func (*Queries) BookingAdminConfirm

❖ 
func (q *Queries) BookingAdminConfirm(ctx context.Context, arg BookingAdminConfirmParams) error

func (*Queries) BookingAnonymizeCancelled

❖ 
func (q *Queries) BookingAnonymizeCancelled(ctx context.Context, cancelledAt sql.NullTime) ([]Booking, error)

func (*Queries) BookingAnonymizeOld

❖ 
func (q *Queries) BookingAnonymizeOld(ctx context.Context, endAt time.Time) ([]Booking, error)

func (*Queries) BookingChargesIndex

❖ 
func (q *Queries) BookingChargesIndex(ctx context.Context, arg BookingChargesIndexParams) ([]Charge, error)

func (*Queries) BookingCommentUpdate

❖ 
func (q *Queries) BookingCommentUpdate(ctx context.Context, arg BookingCommentUpdateParams) error

func (*Queries) BookingCountForEmail

❖ 
func (q *Queries) BookingCountForEmail(ctx context.Context, arg BookingCountForEmailParams) (int64, error)

func (*Queries) BookingCreate

❖ 
func (q *Queries) BookingCreate(ctx context.Context, arg BookingCreateParams) (Booking, error)

func (*Queries) BookingDelete

❖ 
func (q *Queries) BookingDelete(ctx context.Context, id int32) error

func (*Queries) BookingEndingAfter

❖ 
func (q *Queries) BookingEndingAfter(ctx context.Context, arg BookingEndingAfterParams) ([]Booking, error)

func (*Queries) BookingExpired

❖ 
func (q *Queries) BookingExpired(ctx context.Context, arg BookingExpiredParams) ([]Booking, error)

func (*Queries) BookingExtraChargesCreate

❖ 
func (q *Queries) BookingExtraChargesCreate(ctx context.Context, arg BookingExtraChargesCreateParams) error

func (*Queries) BookingExtraChargesDelete

❖ 
func (q *Queries) BookingExtraChargesDelete(ctx context.Context, arg BookingExtraChargesDeleteParams) error

func (*Queries) BookingExtraChargesIndex

❖ 
func (q *Queries) BookingExtraChargesIndex(ctx context.Context, bookingID int32) ([]BookingExtraCharge, error)

func (*Queries) BookingExtraChargesUpdate

❖ 
func (q *Queries) BookingExtraChargesUpdate(ctx context.Context, arg BookingExtraChargesUpdateParams) error

func (*Queries) BookingFind

❖ 
func (q *Queries) BookingFind(ctx context.Context, id int32) (Booking, error)

func (*Queries) BookingIndex

❖ 
func (q *Queries) BookingIndex(ctx context.Context, arg BookingIndexParams) ([]BookingIndexRow, error)

func (*Queries) BookingOverlapping

❖ 
func (q *Queries) BookingOverlapping(ctx context.Context, arg BookingOverlappingParams) ([]Booking, error)

func (*Queries) BookingPricesIndex

❖ 
func (q *Queries) BookingPricesIndex(ctx context.Context, arg BookingPricesIndexParams) ([]Price, error)

func (*Queries) BookingStatusCount

❖ 
func (q *Queries) BookingStatusCount(ctx context.Context, arg BookingStatusCountParams) ([]BookingStatusCountRow, error)

func (*Queries) BookingUpcoming

❖ 
func (q *Queries) BookingUpcoming(ctx context.Context, arg BookingUpcomingParams) ([]Booking, error)

func (*Queries) BookingUpdateContact

❖ 
func (q *Queries) BookingUpdateContact(ctx context.Context, arg BookingUpdateContactParams) error

func (*Queries) BookingUpdateDates

❖ 
func (q *Queries) BookingUpdateDates(ctx context.Context, arg BookingUpdateDatesParams) error

func (*Queries) BookingUpdatePeopleAges

❖ 
func (q *Queries) BookingUpdatePeopleAges(ctx context.Context, arg BookingUpdatePeopleAgesParams) error

func (*Queries) BookingUserConfirm

❖ 
func (q *Queries) BookingUserConfirm(ctx context.Context, id int32) error

func (*Queries) EmailAnonymize

❖ 
func (q *Queries) EmailAnonymize(ctx context.Context, bookingID int32) error

func (*Queries) EmailCreate

❖ 
func (q *Queries) EmailCreate(ctx context.Context, arg EmailCreateParams) (Email, error)

func (*Queries) EmailForBooking

❖ 
func (q *Queries) EmailForBooking(ctx context.Context, bookingID int32) ([]Email, error)

func (*Queries) EmailPending

❖ 
func (q *Queries) EmailPending(ctx context.Context, createdAt time.Time) ([]Email, error)

func (*Queries) EmailUpdate

❖ 
func (q *Queries) EmailUpdate(ctx context.Context, arg EmailUpdateParams) error

func (*Queries) ExtraRequestsIndex

❖ 
func (q *Queries) ExtraRequestsIndex(ctx context.Context, houseID string) ([]ExtraRequest, error)

func (*Queries) LogEventAnonymize

❖ 
func (q *Queries) LogEventAnonymize(ctx context.Context, bookingID int32) error

func (*Queries) LogEventCreate

❖ 
func (q *Queries) LogEventCreate(ctx context.Context, arg LogEventCreateParams) error

func (*Queries) LogEventIndex

❖ 
func (q *Queries) LogEventIndex(ctx context.Context, bookingID int32) ([]LogEventIndexRow, error)

func (*Queries) SettingBookableDayCreate

❖ 
func (q *Queries) SettingBookableDayCreate(ctx context.Context, arg SettingBookableDayUpdateParams) error

func (*Queries) SettingBookableDayIndex

❖ 
func (q *Queries) SettingBookableDayIndex(ctx context.Context, arg SettingBookableDayIndexParams) ([]BookableDay, error)

BOOKABLE DAYS

func (*Queries) SettingBookableDayUpdate

❖ 
func (q *Queries) SettingBookableDayUpdate(ctx context.Context, arg SettingBookableDayUpdateParams) error

SettingBookableDayCreate see settings.go

func (*Queries) SettingBookableHouseIndex

❖ 
func (q *Queries) SettingBookableHouseIndex(ctx context.Context, userID string) ([]SettingBookableHouseIndexRow, error)

func (*Queries) SettingChargeCreate

❖ 
func (q *Queries) SettingChargeCreate(ctx context.Context, arg SettingChargeCreateParams) error

func (*Queries) SettingChargeDelete

❖ 
func (q *Queries) SettingChargeDelete(ctx context.Context, id string) error

func (*Queries) SettingChargeIndexPerHousePrice

❖ 
func (q *Queries) SettingChargeIndexPerHousePrice(ctx context.Context, arg SettingChargeIndexPerHousePriceParams) ([]Charge, error)

func (*Queries) SettingChargeIndexPerPrice

❖ 
func (q *Queries) SettingChargeIndexPerPrice(ctx context.Context, priceID string) ([]Charge, error)

CHARGE

func (*Queries) SettingChargeUpdate

❖ 
func (q *Queries) SettingChargeUpdate(ctx context.Context, arg SettingChargeUpdateParams) error

func (*Queries) SettingExtraRequestCreate

❖ 
func (q *Queries) SettingExtraRequestCreate(ctx context.Context, arg SettingExtraRequestCreateParams) error

func (*Queries) SettingExtraRequestDelete

❖ 
func (q *Queries) SettingExtraRequestDelete(ctx context.Context, id int32) error

func (*Queries) SettingExtraRequestUpdate

❖ 
func (q *Queries) SettingExtraRequestUpdate(ctx context.Context, arg SettingExtraRequestUpdateParams) error

func (*Queries) SettingHouseCreate

❖ 
func (q *Queries) SettingHouseCreate(ctx context.Context, arg SettingHouseCreateParams) error

HOUSE

func (*Queries) SettingHouseFind

❖ 
func (q *Queries) SettingHouseFind(ctx context.Context, id string) (House, error)

func (*Queries) SettingHouseIndex

❖ 
func (q *Queries) SettingHouseIndex(ctx context.Context) ([]House, error)

func (*Queries) SettingHouseUpdate

❖ 
func (q *Queries) SettingHouseUpdate(ctx context.Context, arg SettingHouseUpdateParams) error

func (*Queries) SettingHouseUserIndex

❖ 
func (q *Queries) SettingHouseUserIndex(ctx context.Context) ([]HouseUser, error)

HOUSE-USER

func (*Queries) SettingHouseUserInsertRole

❖ 
func (q *Queries) SettingHouseUserInsertRole(ctx context.Context, arg SettingHouseUserInsertRoleParams) error

func (*Queries) SettingHouseUserRole

❖ 
func (q *Queries) SettingHouseUserRole(ctx context.Context, arg SettingHouseUserRoleParams) (string, error)

func (*Queries) SettingHouseUserUpdateRole

❖ 
func (q *Queries) SettingHouseUserUpdateRole(ctx context.Context, arg SettingHouseUserUpdateRoleParams) error

func (*Queries) SettingPriceCreate

❖ 
func (q *Queries) SettingPriceCreate(ctx context.Context, arg SettingPriceCreateParams) error

PRICE

func (*Queries) SettingPriceFind

❖ 
func (q *Queries) SettingPriceFind(ctx context.Context, id string) (Price, error)

func (*Queries) SettingPriceHasBooking

❖ 
func (q *Queries) SettingPriceHasBooking(ctx context.Context, arg SettingPriceHasBookingParams) (bool, error)

func (*Queries) SettingPriceIndex

❖ 
func (q *Queries) SettingPriceIndex(ctx context.Context) ([]Price, error)

func (*Queries) SettingPriceIndexActive

❖ 
func (q *Queries) SettingPriceIndexActive(ctx context.Context) ([]Price, error)

func (*Queries) SettingPriceUpdate

❖ 
func (q *Queries) SettingPriceUpdate(ctx context.Context, arg SettingPriceUpdateParams) error

func (*Queries) SettingRestDayIndex

❖ 
func (q *Queries) SettingRestDayIndex(ctx context.Context, arg SettingRestDayIndexParams) ([]BookableDay, error)

func (*Queries) SettingRestDayUpdate

❖ 
func (q *Queries) SettingRestDayUpdate(ctx context.Context, arg SettingRestDayUpdateParams) error

func (*Queries) SettingUserFind

❖ 
func (q *Queries) SettingUserFind(ctx context.Context, id string) (User, error)

func (*Queries) SettingUserHouseRoles

❖ 
func (q *Queries) SettingUserHouseRoles(ctx context.Context, userID string) ([]SettingUserHouseRolesRow, error)

func (*Queries) SettingUserIndex

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

USER

func (*Queries) SettingUserUpdate

❖ 
func (q *Queries) SettingUserUpdate(ctx context.Context, arg SettingUserUpdateParams) error

func (*Queries) SettingViewableHouseIndex

❖ 
func (q *Queries) SettingViewableHouseIndex(ctx context.Context, userID string) ([]SettingViewableHouseIndexRow, error)

func (*Queries) WithTx

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

type SettingBookableDayIndexParams

❖ 
type SettingBookableDayIndexParams struct {
	HouseID string
	Date    string
}

type SettingBookableDayUpdateParams

❖ 
type SettingBookableDayUpdateParams struct {
	PriceID string
	HouseID string
	Start   string
	EndDate string
}

type SettingBookableHouseIndexRow

❖ 
type SettingBookableHouseIndexRow struct {
	ID                      string
	Name                    string
	CreatedAt               time.Time
	MaxPerson               int32
	StartMinute             int32
	EndMinute               int32
	ReplyTo                 string
	DaysForUserConfirmation int32
	MonthsForPublicBooking  int32
	PublicBookingType       string
	Role                    string
}

type SettingChargeCreateParams

❖ 
type SettingChargeCreateParams struct {
	ID                     string
	HouseID                string
	PriceID                string
	Name                   string
	Description            string
	Unit                   string
	Amount                 int32
	MinPersonCharged       int32
	ChargedOverPersonCount int32
	ExemptedUnderAge       int32
	Optionality            string
}

type SettingChargeIndexPerHousePriceParams

❖ 
type SettingChargeIndexPerHousePriceParams struct {
	PriceID string
	HouseID string
}

type SettingChargeUpdateParams

❖ 
type SettingChargeUpdateParams struct {
	Name                   string
	Description            string
	Unit                   string
	Amount                 int32
	MinPersonCharged       int32
	ChargedOverPersonCount int32
	ExemptedUnderAge       int32
	Optionality            string
	ID                     string
}

type SettingExtraRequestCreateParams

❖ 
type SettingExtraRequestCreateParams struct {
	HouseID     string
	Description string
	Pricing     string
	Weight      int32
}

type SettingExtraRequestUpdateParams

❖ 
type SettingExtraRequestUpdateParams struct {
	Description string
	Pricing     string
	Weight      int32
	ID          int32
}

type SettingHouseCreateParams

❖ 
type SettingHouseCreateParams struct {
	ID        string
	Name      string
	MaxPerson int32
	ReplyTo   string
}

type SettingHouseUpdateParams

❖ 
type SettingHouseUpdateParams struct {
	Name              string
	MaxPerson         int32
	ReplyTo           string
	StartMinute       int32
	EndMinute         int32
	PublicBookingType string
	ID                string
}

type SettingHouseUserInsertRoleParams

❖ 
type SettingHouseUserInsertRoleParams struct {
	HouseID string
	UserID  string
	Role    string
}

type SettingHouseUserRoleParams

❖ 
type SettingHouseUserRoleParams struct {
	HouseID string
	UserID  string
}

type SettingHouseUserUpdateRoleParams

❖ 
type SettingHouseUserUpdateRoleParams struct {
	Role    string
	HouseID string
	UserID  string
}

type SettingPriceCreateParams

❖ 
type SettingPriceCreateParams struct {
	ID   string
	Name string
}

type SettingPriceHasBookingParams

❖ 
type SettingPriceHasBookingParams struct {
	HouseID string
	PriceID string
}

type SettingPriceUpdateParams

❖ 
type SettingPriceUpdateParams struct {
	Name     string
	HiddenAt sql.NullTime
	ID       string
}

type SettingRestDayIndexParams

❖ 
type SettingRestDayIndexParams struct {
	HouseID string
	Date    string
}

type SettingRestDayUpdateParams

❖ 
type SettingRestDayUpdateParams struct {
	RestrictionReason string
	HouseID           string
	Start             string
	EndDate           string
}

type SettingUserHouseRolesRow

❖ 
type SettingUserHouseRolesRow struct {
	HouseID string
	Role    sql.NullString
}

type SettingUserUpdateParams

❖ 
type SettingUserUpdateParams struct {
	AuthorizedAt sql.NullTime
	Role         string
	ID           string
}

type SettingViewableHouseIndexRow

❖ 
type SettingViewableHouseIndexRow struct {
	ID                      string
	Name                    string
	CreatedAt               time.Time
	MaxPerson               int32
	StartMinute             int32
	EndMinute               int32
	ReplyTo                 string
	DaysForUserConfirmation int32
	MonthsForPublicBooking  int32
	PublicBookingType       string
	Role                    string
}

type User

❖ 
type User struct {
	ID           string
	Email        string
	Name         string
	CreatedAt    time.Time
	AuthorizedAt sql.NullTime
	Role         string
}

Source Files

bookings.go db.go migration.go models.go settings.go zql.authboss.go zql.bookings.go zql.emails.go zql.logevents.go zql.setting.go

code.pfad.fr/buchungssystem/database
main