db

package
v0.0.0-...-e7aebcb Latest Latest
Warning

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

Go to latest
Published: Dec 31, 2024 License: MIT Imports: 4 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type AddFilterParams

type AddFilterParams struct {
	UserHash   string
	FilterText string
	Category   pgtype.Text
	Weight     int32
}

type AddNoOrderDayParams

type AddNoOrderDayParams struct {
	UserHash    string
	ArrayAppend interface{}
}

type AddWeekdayOrderingExceptionParams

type AddWeekdayOrderingExceptionParams struct {
	UserHash    string
	ArrayAppend interface{}
}

type CreateUserParams

type CreateUserParams struct {
	UserHash string
	Sid      string
}

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 DeleteFilterParams

type DeleteFilterParams struct {
	UserHash   string
	FilterText string
	Category   pgtype.Text
}

type Filter

type Filter struct {
	ID         int32
	UserID     int32
	FilterText string
	Category   pgtype.Text
	CreatedAt  pgtype.Timestamp
	Weight     int32
}

type GetUserRow

type GetUserRow struct {
	ID                  int32
	UserHash            string
	Sid                 string
	OrderDaysExceptions []int32
	NoOrderDays         []string
	IsBetaTester        bool
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) AddFilter

func (q *Queries) AddFilter(ctx context.Context, arg AddFilterParams) error

func (*Queries) AddNoOrderDay

func (q *Queries) AddNoOrderDay(ctx context.Context, arg AddNoOrderDayParams) error

func (*Queries) AddWeekdayOrderingException

func (q *Queries) AddWeekdayOrderingException(ctx context.Context, arg AddWeekdayOrderingExceptionParams) error

func (*Queries) CreateUser

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)

func (*Queries) DeleteFilter

func (q *Queries) DeleteFilter(ctx context.Context, arg DeleteFilterParams) error

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, userHash string) (GetUserRow, error)

func (*Queries) ListFilters

func (q *Queries) ListFilters(ctx context.Context, userHash string) ([]Filter, error)

func (*Queries) ListNoOrderDays

func (q *Queries) ListNoOrderDays(ctx context.Context, userHash string) error

func (*Queries) ListWeekdayOrderingExceptions

func (q *Queries) ListWeekdayOrderingExceptions(ctx context.Context, userHash string) error

func (*Queries) RegisterBetatester

func (q *Queries) RegisterBetatester(ctx context.Context, userHash string) error

func (*Queries) RemoveNoOrderDay

func (q *Queries) RemoveNoOrderDay(ctx context.Context, arg RemoveNoOrderDayParams) error

func (*Queries) RemoveWeekdayOrderingException

func (q *Queries) RemoveWeekdayOrderingException(ctx context.Context, arg RemoveWeekdayOrderingExceptionParams) error

func (*Queries) UpdateFilterWeight

func (q *Queries) UpdateFilterWeight(ctx context.Context, arg UpdateFilterWeightParams) error

func (*Queries) UpdateUserSID

func (q *Queries) UpdateUserSID(ctx context.Context, arg UpdateUserSIDParams) error

func (*Queries) WithTx

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

type RemoveNoOrderDayParams

type RemoveNoOrderDayParams struct {
	UserHash    string
	ArrayRemove interface{}
}

type RemoveWeekdayOrderingExceptionParams

type RemoveWeekdayOrderingExceptionParams struct {
	UserHash    string
	ArrayRemove interface{}
}

type UpdateFilterWeightParams

type UpdateFilterWeightParams struct {
	UserHash   string
	Weight     int32
	FilterText string
	Category   pgtype.Text
}

type UpdateUserSIDParams

type UpdateUserSIDParams struct {
	UserHash string
	Sid      string
}

type User

type User struct {
	ID                  int32
	UserHash            string
	Sid                 string
	IsBetaTester        bool
	OrderDaysExceptions []int32
	NoOrderDays         []string
}

Jump to

Keyboard shortcuts

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