queries

Documentation

Index

• type Asset
• type CreateAssetParams
• type CreateAssetRow
• type CreateModelParams
• type DBTX
• type GetAssetByIDRow
• type ListAssetsByModelRow
• type ListAssetsRow
• type Model
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateAsset(ctx context.Context, arg CreateAssetParams) (CreateAssetRow, error)
  • func (q *Queries) CreateModel(ctx context.Context, arg CreateModelParams) (Model, error)
  • func (q *Queries) CreateVendor(ctx context.Context, name string) (Vendor, error)
  • func (q *Queries) DeleteAssetByID(ctx context.Context, assetID int64) (int64, error)
  • func (q *Queries) DeleteModelByID(ctx context.Context, id int64) (int64, error)
  • func (q *Queries) DeleteVendorByID(ctx context.Context, id int64) (int64, error)
  • func (q *Queries) GetAssetByID(ctx context.Context, assetID int64) (GetAssetByIDRow, error)
  • func (q *Queries) GetModelByID(ctx context.Context, id int64) (Model, error)
  • func (q *Queries) GetVendorByID(ctx context.Context, id int64) (Vendor, error)
  • func (q *Queries) ListAssets(ctx context.Context) ([]ListAssetsRow, error)
  • func (q *Queries) ListAssetsByModel(ctx context.Context, modelID int64) ([]ListAssetsByModelRow, error)
  • func (q *Queries) ListModels(ctx context.Context) ([]Model, error)
  • func (q *Queries) ListModelsByVendorID(ctx context.Context, vendorID int64) ([]Model, error)
  • func (q *Queries) ListVendors(ctx context.Context) ([]Vendor, error)
  • func (q *Queries) UpdateAssetByID(ctx context.Context, arg UpdateAssetByIDParams) (UpdateAssetByIDRow, error)
  • func (q *Queries) UpdateModelByID(ctx context.Context, arg UpdateModelByIDParams) (Model, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type UpdateAssetByIDParams
• type UpdateAssetByIDRow
• type UpdateModelByIDParams
• type Vendor

Types

type Asset

type Asset struct {
	ID        int64
	ModelID   int64
	Serial    string
	Comments  string
	CreatedAt pgtype.Timestamptz
	UpdatedAt pgtype.Timestamptz
}

type CreateAssetParams

type CreateAssetParams struct {
	ModelID  int64
	Serial   string
	Comments string
}

type CreateAssetRow

type CreateAssetRow struct {
	Asset    Asset
	VendorID int64
}

type CreateModelParams

type CreateModelParams struct {
	Model    string
	VendorID int64
	Name     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 GetAssetByIDRow

type GetAssetByIDRow struct {
	Asset    Asset
	VendorID int64
}

type ListAssetsByModelRow

type ListAssetsByModelRow struct {
	Asset    Asset
	VendorID int64
}

type ListAssetsRow

type ListAssetsRow struct {
	Asset    Asset
	VendorID int64
}

type Model

type Model struct {
	ID        int64
	Model     string
	VendorID  int64
	Name      string
	CreatedAt pgtype.Timestamptz
	UpdatedAt pgtype.Timestamptz
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateAsset

func (q *Queries) CreateAsset(ctx context.Context, arg CreateAssetParams) (CreateAssetRow, error)

func (*Queries) CreateModel

func (q *Queries) CreateModel(ctx context.Context, arg CreateModelParams) (Model, error)

func (*Queries) CreateVendor

func (q *Queries) CreateVendor(ctx context.Context, name string) (Vendor, error)

func (*Queries) DeleteAssetByID

func (q *Queries) DeleteAssetByID(ctx context.Context, assetID int64) (int64, error)

func (*Queries) DeleteModelByID

func (q *Queries) DeleteModelByID(ctx context.Context, id int64) (int64, error)

func (*Queries) DeleteVendorByID

func (q *Queries) DeleteVendorByID(ctx context.Context, id int64) (int64, error)

func (*Queries) GetAssetByID

func (q *Queries) GetAssetByID(ctx context.Context, assetID int64) (GetAssetByIDRow, error)

func (*Queries) GetModelByID

func (q *Queries) GetModelByID(ctx context.Context, id int64) (Model, error)

func (*Queries) GetVendorByID

func (q *Queries) GetVendorByID(ctx context.Context, id int64) (Vendor, error)

func (*Queries) ListAssets

func (q *Queries) ListAssets(ctx context.Context) ([]ListAssetsRow, error)

func (*Queries) ListAssetsByModel

func (q *Queries) ListAssetsByModel(ctx context.Context, modelID int64) ([]ListAssetsByModelRow, error)

func (*Queries) ListModels

func (q *Queries) ListModels(ctx context.Context) ([]Model, error)

func (*Queries) ListModelsByVendorID

func (q *Queries) ListModelsByVendorID(ctx context.Context, vendorID int64) ([]Model, error)

func (*Queries) ListVendors

func (q *Queries) ListVendors(ctx context.Context) ([]Vendor, error)

func (*Queries) UpdateAssetByID

func (q *Queries) UpdateAssetByID(ctx context.Context, arg UpdateAssetByIDParams) (UpdateAssetByIDRow, error)

func (*Queries) UpdateModelByID

func (q *Queries) UpdateModelByID(ctx context.Context, arg UpdateModelByIDParams) (Model, error)

func (*Queries) WithTx

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

type UpdateAssetByIDParams

type UpdateAssetByIDParams struct {
	ModelID  int64
	Serial   string
	Comments string
	AssetID  int64
}

type UpdateAssetByIDRow

type UpdateAssetByIDRow struct {
	Asset    Asset
	VendorID int64
}

type UpdateModelByIDParams

type UpdateModelByIDParams struct {
	ID       int64
	Model    string
	Name     string
	VendorID int64
}

type Vendor

type Vendor struct {
	ID        int64
	Name      string
	CreatedAt pgtype.Timestamptz
	UpdatedAt pgtype.Timestamptz
}