database

Documentation

Index

• Constants
• func InTransaction[R any](ctx context.Context, db *Database, ...) (R, error)
• type Database
  • func (db *Database) InTransaction(ctx context.Context, fn func(ctx context.Context, tx Executor) error) error
• type Executor
• type GetAssetQuery
• type ListAssetsQuery
• type ListCategoriesQuery
• type ListCustomAttrsQuery
• type ListFilesQuery
• type ListLocationsQuery
• type ListManufacturersQuery
• type ListModelsQuery
• type ListPositionCodesQuery
• type ListSuppliersQuery
• type ListTagsQuery
• type ListUsersQuery

Constants

const OrderASC = "ASC"

const OrderDESC = "DESC"

Functions

func InTransaction

func InTransaction[R any](ctx context.Context, db *Database, fn func(ctx context.Context, tx Executor) (R, error)) (R, error)

Types

type Database

type Database struct {
	bob.DB
	EnableDebugLogging bool
}

func (*Database) InTransaction

func (db *Database) InTransaction(ctx context.Context, fn func(ctx context.Context, tx Executor) error) error

type Executor

type Executor interface {
	scan.Queryer
	ExecContext(context.Context, string, ...any) (sql.Result, error)
}

type GetAssetQuery

type GetAssetQuery struct {
	ID               int64
	Tag              string
	IncludePurchases bool
	IncludeParts     bool
	IncludeFiles     bool
	IncludeParent    bool
	IncludeChildren  bool
}

type ListAssetsQuery

type ListAssetsQuery struct {
	SearchRaw    string
	SearchFields map[string]string

	IDs []int64

	Page     int
	PageSize int

	OrderBy  string
	OrderDir string

	AssetType string

	IncludePurchases bool
	IncludeParts     bool
	IncludeFiles     bool
	IncludeParent    bool
	IncludeChildren  bool
}

type ListCategoriesQuery

type ListCategoriesQuery struct {
	Search   string
	Page     int
	PageSize int
}

type ListCustomAttrsQuery

type ListCustomAttrsQuery struct {
	Search   string
	Page     int
	PageSize int
}

type ListFilesQuery

type ListFilesQuery struct {
	AssetID  int64
	Page     int
	PageSize int
	Hashes   [][]byte
}

type ListLocationsQuery

type ListLocationsQuery struct {
	Search   string
	Page     int
	PageSize int
}

type ListManufacturersQuery

type ListManufacturersQuery struct {
	Search   string
	Page     int
	PageSize int
}

type ListModelsQuery

type ListModelsQuery struct {
	Search   string
	Page     int
	PageSize int
}

type ListPositionCodesQuery

type ListPositionCodesQuery struct {
	Search   string
	Page     int
	PageSize int
}

type ListSuppliersQuery

type ListSuppliersQuery struct {
	Search   string
	Page     int
	PageSize int
}

type ListTagsQuery

type ListTagsQuery struct {
	Search   string
	InUse    *bool
	Page     int
	PageSize int
	OrderBy  string
	OrderDir string
}

type ListUsersQuery

type ListUsersQuery struct {
	Search   string
	Page     int
	PageSize int
	OrderBy  string
	OrderDir string
}