projectmodel

Documentation

Index

• type CreateProjectParams
• type DBTX
• type Project
• type Querier
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateProject(ctx context.Context, arg CreateProjectParams) (sql.Result, error)
  • func (q *Queries) DeleteProject(ctx context.Context, id int64) error
  • func (q *Queries) GetProject(ctx context.Context, id int64) (*Project, error)
  • func (q *Queries) ListCalcProjects(ctx context.Context) ([]*Project, error)
  • func (q *Queries) ListProjectCalcsByManager(ctx context.Context, managerID int64) ([]*Project, error)
  • func (q *Queries) ListProjects(ctx context.Context) ([]*Project, error)
  • func (q *Queries) ListProjectsByManager(ctx context.Context, managerID int64) ([]*Project, error)
  • func (q *Queries) UpdateProject(ctx context.Context, arg UpdateProjectParams) (sql.Result, error)
  • func (q *Queries) UpdateProjectStatus(ctx context.Context, arg UpdateProjectStatusParams) (sql.Result, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type UpdateProjectParams
• type UpdateProjectStatusParams

Types

type CreateProjectParams

type CreateProjectParams struct {
	Name      string `json:"name"`
	Client    string `json:"client"`
	Period    string `json:"period"`
	ManagerID int64  `json:"manager_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 Project

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

type Querier

type Querier interface {
	CreateProject(ctx context.Context, arg CreateProjectParams) (sql.Result, error)
	DeleteProject(ctx context.Context, id int64) error
	GetProject(ctx context.Context, id int64) (*Project, error)
	ListCalcProjects(ctx context.Context) ([]*Project, error)
	ListProjectCalcsByManager(ctx context.Context, managerID int64) ([]*Project, error)
	ListProjects(ctx context.Context) ([]*Project, error)
	ListProjectsByManager(ctx context.Context, managerID int64) ([]*Project, error)
	UpdateProject(ctx context.Context, arg UpdateProjectParams) (sql.Result, error)
	UpdateProjectStatus(ctx context.Context, arg UpdateProjectStatusParams) (sql.Result, error)
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateProject

func (q *Queries) CreateProject(ctx context.Context, arg CreateProjectParams) (sql.Result, error)

func (*Queries) DeleteProject

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

func (*Queries) GetProject

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

func (*Queries) ListCalcProjects

func (q *Queries) ListCalcProjects(ctx context.Context) ([]*Project, error)

func (*Queries) ListProjectCalcsByManager

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

func (*Queries) ListProjects

func (q *Queries) ListProjects(ctx context.Context) ([]*Project, error)

func (*Queries) ListProjectsByManager

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

func (*Queries) UpdateProject

func (q *Queries) UpdateProject(ctx context.Context, arg UpdateProjectParams) (sql.Result, error)

func (*Queries) UpdateProjectStatus

func (q *Queries) UpdateProjectStatus(ctx context.Context, arg UpdateProjectStatusParams) (sql.Result, error)

func (*Queries) WithTx

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

type UpdateProjectParams

type UpdateProjectParams struct {
	Name      string `json:"name"`
	Client    string `json:"client"`
	Period    string `json:"period"`
	ManagerID int64  `json:"manager_id"`
	Markdown  string `json:"markdown"`
	ID        int64  `json:"id"`
}

type UpdateProjectStatusParams

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