projectResDB

Documentation

Index

• type DBInfo
• type ProjectResDB
• type ProjectResPg
  • func NewProjectResPg(sqlxdb *sqlx.DB, tn string) ProjectResPg
  • func (prpg ProjectResPg) Close()
  • func (prpg ProjectResPg) Delete(projectID int) (err error)
  • func (prpg ProjectResPg) Insert(pr projectRes.ResInfo) (err error)
  • func (prpg ProjectResPg) QueryAll() (prs []projectRes.ResInfo, err error)
  • func (prpg ProjectResPg) QueryByID(projectID int) (pr projectRes.ResInfo, err error)
  • func (prpg ProjectResPg) Update(pr projectRes.ResInfo) (err error)

Types

type DBInfo

type DBInfo struct {
	TheDB     *sqlx.DB
	TableName string
}

type ProjectResDB

type ProjectResDB interface {
	QueryByID(projectID int) (pr projectRes.ResInfo, err error)
	QueryAll() ([]projectRes.ResInfo, error)
	Insert(pr projectRes.ResInfo) (err error)
	Update(pr projectRes.ResInfo) (err error)
	Delete(projectID int) (err error)
	Close()
}

type ProjectResPg

type ProjectResPg struct {
	DBInfo
}

func NewProjectResPg

func NewProjectResPg(sqlxdb *sqlx.DB, tn string) ProjectResPg

func (ProjectResPg) Close

func (prpg ProjectResPg) Close()

func (ProjectResPg) Delete

func (prpg ProjectResPg) Delete(projectID int) (err error)

func (ProjectResPg) Insert

func (prpg ProjectResPg) Insert(pr projectRes.ResInfo) (err error)

func (ProjectResPg) QueryAll

func (prpg ProjectResPg) QueryAll() (prs []projectRes.ResInfo, err error)

func (ProjectResPg) QueryByID

func (prpg ProjectResPg) QueryByID(projectID int) (pr projectRes.ResInfo, err error)

func (ProjectResPg) Update

func (prpg ProjectResPg) Update(pr projectRes.ResInfo) (err error)