db

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 MetaGithubRepository struct {
	ID              uuid.UUID
	ScanID          uuid.UUID
	Owner           string
	RepoName        string
	CommitID        string
	Branch          sql.NullString
	IsDefaultBranch sql.NullBool
	BaseCommitID    sql.NullString
	PullRequestID   sql.NullInt32
	PageSeq         sql.NullInt32
}

type NullTargetClass struct {
	TargetClass TargetClass
	Valid       bool // Valid is true if TargetClass is not NULL
}

type Package struct {
	ID         string
	TargetType string
	Name       string
	Version    string
}

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

type Result struct {
	ID         uuid.UUID
	ScanID     uuid.UUID
	Target     string
	TargetType string
	Class      TargetClass
}

type ResultPackage struct {
	ID       uuid.UUID
	ResultID uuid.UUID
	PkgID    string
}

type ResultVulnerability struct {
	ID           uuid.UUID
	ResultID     uuid.UUID
	VulnID       string
	PkgID        string
	FixedVersion sql.NullString
	PrimaryUrl   sql.NullString
}

type SaveMetaGithubRepositoryParams struct {
	ID              uuid.UUID
	ScanID          uuid.UUID
	Owner           string
	RepoName        string
	Branch          sql.NullString
	IsDefaultBranch sql.NullBool
	CommitID        string
	BaseCommitID    sql.NullString
	PullRequestID   sql.NullInt32
}

type SavePackageParams struct {
	ID         string
	TargetType string
	Name       string
	Version    string
}

type SaveResultPackageParams struct {
	ID       uuid.UUID
	ResultID uuid.UUID
	PkgID    string
}

type SaveResultParams struct {
	ID         uuid.UUID
	ScanID     uuid.UUID
	Target     string
	TargetType string
	Class      TargetClass
}

type SaveResultVulnerabilityParams struct {
	ID           uuid.UUID
	ResultID     uuid.UUID
	VulnID       string
	PkgID        string
	FixedVersion sql.NullString
	PrimaryUrl   sql.NullString
}

type SaveScanParams struct {
	ID           uuid.UUID
	ArtifactName string
	ArtifactType string
}

type SaveVulnerabilityParams struct {
	ID             string
	Title          string
	Description    string
	Severity       string
	CweIds         []string
	Cvss           pqtype.NullRawMessage
	Reference      []string
	PublishedAt    sql.NullTime
	LastModifiedAt sql.NullTime
}

type Scan struct {
	ID           uuid.UUID
	CreatedAt    time.Time
	ArtifactName string
	ArtifactType string
	PageSeq      sql.NullInt32
}

type TargetClass string

type UpdateVulnerabilityParams struct {
	ID             string
	Title          string
	Description    string
	Severity       string
	CweIds         []string
	Cvss           pqtype.NullRawMessage
	Reference      []string
	PublishedAt    sql.NullTime
	LastModifiedAt sql.NullTime
}

type Vulnerability struct {
	ID             string
	Title          string
	Description    string
	Severity       string
	CweIds         []string
	Cvss           pqtype.NullRawMessage
	Reference      []string
	PublishedAt    sql.NullTime
	LastModifiedAt sql.NullTime
}