projectDB

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

type ProjectDB interface {
	ProjectReadOnlyDB
	///////////////////////////////////////////////////////////////////////////////
	Insert(project.Info) (projectID int, err error)

	UpdateBasicInfo(bi project.BasicInfo) (err error)
	UpdateCodeInfo(pc project.CodeInfo) (err error)
	UpdateStatusInfo(si project.StatusInfo) (err error)
	UpdateApplyInfo(ai project.ApplyInfo) (err error)
	UpdateAllocNum(ali project.AllocNum) (err error)
	UpdateAllocInfo(ali project.AllocInfo) (err error)

	// 同一数据库内归档
	InnerArchiveProject(historyTableName string, projectID int) (err error)
}

type ProjectPg struct {
	DBInfo
}

type ProjectReadOnlyDB interface {
	QueryByID(projectID int) (project.Info, error)
	QueryByOwner(userID int) ([]project.Info, error)
	QueryByDepartmentCode(dc string) ([]project.Info, error)
	QueryAllInfo() ([]project.Info, error)

	Close()
}