database

package
v0.0.0-...-2d47c91 Latest Latest
Warning

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

 Go to latest Published: May 24, 2022 License: AGPL-3.0 Imports: 8 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func MissingMigrations 

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

Types

type AddRememberTokenParams 

type AddRememberTokenParams struct {
	Token  string
	UserID string
}

type AuthInsertParams 

type AuthInsertParams struct {
	ID    string
	Email string
	Name  string
}

type AuthSaveParams 

type AuthSaveParams struct {
	Email string
	ID    string
}

type AuthbossStore 

type AuthbossStore struct {
	Queries *Queries
}

func (AuthbossStore) AddRememberToken 

func (s AuthbossStore) AddRememberToken(ctx context.Context, pid, token string) error

AddRememberToken to a user

func (AuthbossStore) DelRememberTokens 

func (s AuthbossStore) DelRememberTokens(ctx context.Context, pid string) error

DelRememberTokens removes all tokens for the given pid

func (AuthbossStore) FindOrCreateOAuth2User 

func (s AuthbossStore) FindOrCreateOAuth2User(ctx context.Context, result goauthboss.OAuth2Result) (authboss.User, error)

func (AuthbossStore) Load 

func (s AuthbossStore) Load(ctx context.Context, key string) (authboss.User, error)

Load the user

func (AuthbossStore) Save 

func (s AuthbossStore) Save(ctx context.Context, user authboss.User) error

Save the user

func (AuthbossStore) UseRememberToken 

func (s AuthbossStore) UseRememberToken(ctx context.Context, pid, token string) error

UseRememberToken finds the pid-token pair and deletes it. If the token could not be found return ErrTokenNotFound

type BookableDay 

type BookableDay struct {
	Date              string
	HouseID           string
	PriceID           string
	RestrictionReason 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
	CancellationReason string
}

type BookingBookableDayIndexParams 

type BookingBookableDayIndexParams struct {
	HouseID string
	Start   string
}

type BookingChargesIndexParams 

type BookingChargesIndexParams struct {
	HouseID string
	Start   string
	EndDate string
}

type BookingCreateParams 

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

type BookingEndingAfterParams 

type BookingEndingAfterParams struct {
	HouseID string
	EndAt   time.Time
}

type BookingOverlappingParams 

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

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
}

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 DashboardBookableDayIndexParams 

type DashboardBookableDayIndexParams struct {
	HouseID string
	Start   string
	EndDate string
}

type House 

type House struct {
	ID          string
	Name        string
	CreatedAt   time.Time
	MaxPerson   int32
	StartMinute int32
	EndMinute   int32
}

type HouseUser 

type HouseUser struct {
	UserID  string
	HouseID string
	Role    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) AddRememberToken 

func (q *Queries) AddRememberToken(ctx context.Context, arg AddRememberTokenParams) error

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) BookingBookableDayIndex 

func (q *Queries) BookingBookableDayIndex(ctx context.Context, arg BookingBookableDayIndexParams) ([]BookableDay, error)

func (*Queries) BookingChargesIndex 

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

func (*Queries) BookingCreate 

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

func (*Queries) BookingEndingAfter 

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

func (*Queries) BookingOverlapping 

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

func (*Queries) DashboardBookableDayIndex 

func (q *Queries) DashboardBookableDayIndex(ctx context.Context, arg DashboardBookableDayIndexParams) ([]BookableDay, error)

func (*Queries) DelRememberTokens 

func (q *Queries) DelRememberTokens(ctx context.Context, userID string) 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) 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) 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) 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) 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) UseRememberToken 

func (q *Queries) UseRememberToken(ctx context.Context, arg UseRememberTokenParams) (RememberToken, error)

func (*Queries) WithTx 

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

type RememberToken 

type RememberToken struct {
	Token     string
	UserID    string
	CreatedAt time.Time
}

type SettingBookableDayIndexParams 

type SettingBookableDayIndexParams struct {
	HouseID string
	Date    string
}

type SettingBookableDayUpdateParams 

type SettingBookableDayUpdateParams struct {
	PriceID           string
	RestrictionReason string
	HouseID           string
	Start             string
	EndDate           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 SettingHouseCreateParams 

type SettingHouseCreateParams struct {
	ID        string
	Name      string
	MaxPerson int32
}

type SettingHouseUpdateParams 

type SettingHouseUpdateParams struct {
	Name      string
	MaxPerson int32
	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 SettingPriceUpdateParams 

type SettingPriceUpdateParams struct {
	Name     string
	HiddenAt sql.NullTime
	ID       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
	Role        string
}

type UseRememberTokenParams 

type UseRememberTokenParams struct {
	UserID string
	Token  string
}

type User 

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

func (User) GetPID 

func (u User) GetPID() string

func (*User) PutPID 

func (u *User) PutPID(pid string)

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.