query

Documentation

Index

• type CreateItemParams
• type DBTX
• type DeleteItemParams
• type Item
• type Queries
  • func New(db DBTX) *Queries
  • func Prepare(ctx context.Context, db DBTX) (*Queries, error)
  • func (q *Queries) Close() error
  • func (q *Queries) CreateItem(ctx context.Context, arg CreateItemParams) (Item, error)
  • func (q *Queries) DeleteItem(ctx context.Context, arg DeleteItemParams) error
  • func (q *Queries) GetItem(ctx context.Context, name string) (Item, error)
  • func (q *Queries) ListItems(ctx context.Context) ([]Item, error)
  • func (q *Queries) UpdateItem(ctx context.Context, arg UpdateItemParams) (Item, error)
  • func (q *Queries) UpsertItem(ctx context.Context, arg UpsertItemParams) (Item, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type UpdateItemParams
• type UpsertItemParams

Types

type CreateItemParams

type CreateItemParams struct {
	Name        string         `db:"name"`
	DisplayName string         `db:"display_name"`
	CreateTime  time.Time      `db:"create_time"`
	UpdateTime  time.Time      `db:"update_time"`
	DeleteTime  sql.NullTime   `db:"delete_time"`
	Hash        sql.NullString `db:"hash"`
	Content     sql.NullString `db:"content"`
	Properties  interface{}    `db:"properties"`
	Metadata    interface{}    `db:"metadata"`
}

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 DeleteItemParams

type DeleteItemParams struct {
	DeleteTime sql.NullTime `db:"delete_time"`
	Name       string       `db:"name"`
}

type Item

type Item struct {
	Name        string         `db:"name"`
	DisplayName string         `db:"display_name"`
	CreateTime  time.Time      `db:"create_time"`
	UpdateTime  time.Time      `db:"update_time"`
	DeleteTime  sql.NullTime   `db:"delete_time"`
	Hash        sql.NullString `db:"hash"`
	Content     sql.NullString `db:"content"`
	Properties  interface{}    `db:"properties"`
	Metadata    interface{}    `db:"metadata"`
}

type Queries

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

func New

func New(db DBTX) *Queries

func Prepare

func Prepare(ctx context.Context, db DBTX) (*Queries, error)

func (*Queries) Close

func (q *Queries) Close() error

func (*Queries) CreateItem

func (q *Queries) CreateItem(ctx context.Context, arg CreateItemParams) (Item, error)

func (*Queries) DeleteItem

func (q *Queries) DeleteItem(ctx context.Context, arg DeleteItemParams) error

func (*Queries) GetItem

func (q *Queries) GetItem(ctx context.Context, name string) (Item, error)

func (*Queries) ListItems

func (q *Queries) ListItems(ctx context.Context) ([]Item, error)

func (*Queries) UpdateItem

func (q *Queries) UpdateItem(ctx context.Context, arg UpdateItemParams) (Item, error)

func (*Queries) UpsertItem

func (q *Queries) UpsertItem(ctx context.Context, arg UpsertItemParams) (Item, error)

func (*Queries) WithTx

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

type UpdateItemParams

type UpdateItemParams struct {
	Name        string         `db:"name"`
	DisplayName string         `db:"display_name"`
	UpdateTime  time.Time      `db:"update_time"`
	Hash        sql.NullString `db:"hash"`
	Content     sql.NullString `db:"content"`
	Properties  interface{}    `db:"properties"`
	Metadata    interface{}    `db:"metadata"`
	Name_2      string         `db:"name_2"`
}

type UpsertItemParams

type UpsertItemParams struct {
	Name        string         `db:"name"`
	DisplayName string         `db:"display_name"`
	CreateTime  time.Time      `db:"create_time"`
	UpdateTime  time.Time      `db:"update_time"`
	DeleteTime  sql.NullTime   `db:"delete_time"`
	Hash        sql.NullString `db:"hash"`
	Content     sql.NullString `db:"content"`
	Properties  interface{}    `db:"properties"`
	Metadata    interface{}    `db:"metadata"`
}