jobmodel

Documentation

Index

• type CreateJobParams
• type DBTX
• type Job
• type Querier
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateJob(ctx context.Context, arg CreateJobParams) (sql.Result, error)
  • func (q *Queries) DeleteJob(ctx context.Context, id int64) error
  • func (q *Queries) GetJob(ctx context.Context, id int64) (*Job, error)
  • func (q *Queries) ListCalcJobs(ctx context.Context) ([]*Job, error)
  • func (q *Queries) ListJobs(ctx context.Context) ([]*Job, error)
  • func (q *Queries) ListJobsByManager(ctx context.Context, managerID int64) ([]*Job, error)
  • func (q *Queries) ListJobsCalcsByManager(ctx context.Context, managerID int64) ([]*Job, error)
  • func (q *Queries) UpdateJob(ctx context.Context, arg UpdateJobParams) (sql.Result, error)
  • func (q *Queries) UpdateJobStatus(ctx context.Context, arg UpdateJobStatusParams) (sql.Result, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type UpdateJobParams
• type UpdateJobStatusParams

Types

type CreateJobParams

type CreateJobParams struct {
	Name      string `json:"name"`
	Period    string `json:"period"`
	ManagerID int64  `json:"manager_id"`
	ProjectID int64  `json:"project_id"`
	Markdown  string `json:"markdown"`
}

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 Job

type Job struct {
	ID        int64     `json:"id"`
	Name      string    `json:"name"`
	Period    string    `json:"period"`
	Status    int32     `json:"status"`
	ManagerID int64     `json:"manager_id"`
	ProjectID int64     `json:"project_id"`
	Markdown  string    `json:"markdown"`
	ShowCalc  int32     `json:"show_calc"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type Querier

type Querier interface {
	CreateJob(ctx context.Context, arg CreateJobParams) (sql.Result, error)
	DeleteJob(ctx context.Context, id int64) error
	GetJob(ctx context.Context, id int64) (*Job, error)
	ListCalcJobs(ctx context.Context) ([]*Job, error)
	ListJobs(ctx context.Context) ([]*Job, error)
	ListJobsByManager(ctx context.Context, managerID int64) ([]*Job, error)
	ListJobsCalcsByManager(ctx context.Context, managerID int64) ([]*Job, error)
	UpdateJob(ctx context.Context, arg UpdateJobParams) (sql.Result, error)
	UpdateJobStatus(ctx context.Context, arg UpdateJobStatusParams) (sql.Result, error)
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateJob

func (q *Queries) CreateJob(ctx context.Context, arg CreateJobParams) (sql.Result, error)

func (*Queries) DeleteJob

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

func (*Queries) GetJob

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

func (*Queries) ListCalcJobs

func (q *Queries) ListCalcJobs(ctx context.Context) ([]*Job, error)

func (*Queries) ListJobs

func (q *Queries) ListJobs(ctx context.Context) ([]*Job, error)

func (*Queries) ListJobsByManager

func (q *Queries) ListJobsByManager(ctx context.Context, managerID int64) ([]*Job, error)

func (*Queries) ListJobsCalcsByManager

func (q *Queries) ListJobsCalcsByManager(ctx context.Context, managerID int64) ([]*Job, error)

func (*Queries) UpdateJob

func (q *Queries) UpdateJob(ctx context.Context, arg UpdateJobParams) (sql.Result, error)

func (*Queries) UpdateJobStatus

func (q *Queries) UpdateJobStatus(ctx context.Context, arg UpdateJobStatusParams) (sql.Result, error)

func (*Queries) WithTx

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

type UpdateJobParams

type UpdateJobParams struct {
	Name      string `json:"name"`
	Period    string `json:"period"`
	ManagerID int64  `json:"manager_id"`
	ProjectID int64  `json:"project_id"`
	Status    int32  `json:"status"`
	ShowCalc  int32  `json:"show_calc"`
	Markdown  string `json:"markdown"`
	ID        int64  `json:"id"`
}

type UpdateJobStatusParams

type UpdateJobStatusParams struct {
	Status int32 `json:"status"`
	ID     int64 `json:"id"`
}