db

package
v0.110.1 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Nov 21, 2024 License: Apache-2.0 Imports: 3 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Advisory added in v0.85.0

type Advisory struct {
	Platform        string
	Organisation    string
	Repo            string
	PackageName     string
	Version         string
	CurrentVersion  sql.NullString
	PackageManager  string
	PackageFilePath string
	DepTypes        string
	Level           string
	AdvisoryType    string
	Description     string
	SupportedUntil  sql.NullString
	EolFrom         sql.NullString
}

type ComponentMetadatum added in v0.100.0

type ComponentMetadatum struct {
	ComponentName       string
	ParentComponentName sql.NullString
	Platform            sql.NullString
	Organisation        sql.NullString
	Repo                sql.NullString
	Path                sql.NullString
	Vendor              sql.NullString
	Product             sql.NullString
	ProductVersion      sql.NullString
	Owner               sql.NullString
	OwnerNotes          sql.NullString
	ComponentType       sql.NullString
	ComponentUsage      sql.NullString
	Description         sql.NullString
	AdditionalMetadata  sql.NullString
}

type CustomAdvisory added in v0.85.0

type CustomAdvisory struct {
	PackagePattern       string
	PackageManager       string
	Version              sql.NullString
	VersionMatchStrategy sql.NullString
	Level                string
	AdvisoryType         string
	Description          string
}

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 DependencyHealth added in v0.76.0

type DependencyHealth struct {
	PackageName                        string
	PackageType                        string
	ScorecardScore                     sql.NullFloat64
	ScorecardCodereview                sql.NullInt64
	ScorecardMaintained                sql.NullInt64
	ScorecardCiibestpractices          sql.NullInt64
	ScorecardLicense                   sql.NullInt64
	ScorecardDangerousworkflow         sql.NullInt64
	ScorecardPackaging                 sql.NullInt64
	ScorecardTokenpermissions          sql.NullInt64
	ScorecardSignedreleases            sql.NullInt64
	ScorecardBranchprotection          sql.NullInt64
	ScorecardBinaryartifacts           sql.NullInt64
	ScorecardFuzzing                   sql.NullInt64
	ScorecardSecuritypolicy            sql.NullInt64
	ScorecardSast                      sql.NullInt64
	ScorecardVulnerabilities           sql.NullInt64
	ScorecardPinneddependencies        sql.NullInt64
	EcosystemsRepoArchived             sql.NullBool
	EcosystemsRepoPushedAt             sql.NullString
	EcosystemsRepoUpdatedAt            sql.NullString
	EcosystemsRepoLastSyncedAt         sql.NullString
	EcosystemsLastSyncedAt             sql.NullString
	EcosystemsLatestReleasePublishedAt sql.NullString
	EcosystemsStatus                   sql.NullString
	EcosystemsFunding                  sql.NullString
}

type DepsdevCfe added in v0.57.0

type DepsdevCfe struct {
	PackageName string
	Version     string
	CveID       string
	UpdatedAt   string
}

type DepsdevDeprecated added in v0.99.0

type DepsdevDeprecated struct {
	PackageName  string
	Version      string
	PackageType  string
	IsDeprecated bool
	UpdatedAt    string
}

type DepsdevLicense added in v0.57.0

type DepsdevLicense struct {
	PackageName string
	Version     string
	License     string
	UpdatedAt   string
}

type ExternalLicense added in v0.59.0

type ExternalLicense struct {
	PackageName    string
	Version        string
	PackageManager string
	License        string
}

type InsertAdvisoryForPartialRenovatePackageParams added in v0.102.0

type InsertAdvisoryForPartialRenovatePackageParams struct {
	PackageName     string
	Version         string
	CurrentVersion  sql.NullString
	PackageManager  string
	PackageFilePath string
	DepTypes        string
	Level           string
	AdvisoryType    string
	Description     string
	SupportedUntil  sql.NullString
	EolFrom         sql.NullString
}

type InsertAdvisoryForPartialSBOMPackageParams added in v0.102.0

type InsertAdvisoryForPartialSBOMPackageParams struct {
	PackageName           string
	Version               string
	CurrentVersion        sql.NullString
	PackageManager        string
	PackageFilePath       string
	DepTypes              string
	Level                 string
	AdvisoryType          string
	Description           string
	SupportedUntil        sql.NullString
	EolFrom               sql.NullString
	VersioncurrentVersion sql.NullString
}

type InsertAdvisoryParams added in v0.102.0

type InsertAdvisoryParams struct {
	Platform        string
	Organisation    string
	Repo            string
	PackageName     string
	Version         string
	CurrentVersion  sql.NullString
	PackageManager  string
	PackageFilePath string
	DepTypes        string
	Level           string
	AdvisoryType    string
	Description     string
	SupportedUntil  sql.NullString
	EolFrom         sql.NullString
}

type Owner

type Owner struct {
	Platform     string
	Organisation string
	Repo         string
	Owner        string
	Notes        sql.NullString
	UpdatedAt    string
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) InsertAdvisory added in v0.102.0

func (q *Queries) InsertAdvisory(ctx context.Context, arg InsertAdvisoryParams) error

func (*Queries) InsertAdvisoryForPartialRenovatePackage added in v0.102.0

func (q *Queries) InsertAdvisoryForPartialRenovatePackage(ctx context.Context, arg InsertAdvisoryForPartialRenovatePackageParams) (int64, error)

func (*Queries) InsertAdvisoryForPartialSBOMPackage added in v0.102.0

func (q *Queries) InsertAdvisoryForPartialSBOMPackage(ctx context.Context, arg InsertAdvisoryForPartialSBOMPackageParams) (int64, error)

func (*Queries) RetrieveDistinctReposAndPackages

func (q *Queries) RetrieveDistinctReposAndPackages(ctx context.Context) ([]RetrieveDistinctReposAndPackagesRow, error)

func (*Queries) RetrieveDistinctReposAndPackagesWithDependencyHealth added in v0.102.0

func (q *Queries) RetrieveDistinctReposAndPackagesWithDependencyHealth(ctx context.Context) ([]RetrieveDistinctReposAndPackagesWithDependencyHealthRow, error)

func (*Queries) RetrieveDistinctReposAndPackagesWithLicenses added in v0.102.0

func (q *Queries) RetrieveDistinctReposAndPackagesWithLicenses(ctx context.Context) ([]RetrieveDistinctReposAndPackagesWithLicensesRow, error)

func (*Queries) RetrievePolicyViolations

func (q *Queries) RetrievePolicyViolations(ctx context.Context) ([]RetrievePolicyViolationsRow, error)

func (*Queries) RetrieveRepoKeysForPolicyViolationResult added in v0.102.0

func (*Queries) RetrieveRepositoryMetadata added in v0.67.0

func (q *Queries) RetrieveRepositoryMetadata(ctx context.Context) ([]RepositoryMetadatum, error)

func (*Queries) RetrieveRowsForPolicyEvaluation added in v0.102.0

This is not used via sqlc, but via manual query building NOTE this is generated manually via taking the maximal result of `EvaluationInputOpts#Query()`

func (*Queries) RetrieveRowsForPolicyEvaluation_Base added in v0.102.0

func (*Queries) RetrieveRowsForPolicyEvaluation_Base_RepoKey added in v0.102.0

func (*Queries) WithTx

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

type Renovate

type Renovate struct {
	Platform        string
	Organisation    string
	Repo            string
	PackageName     string
	Version         string
	CurrentVersion  sql.NullString
	Digest          sql.NullString
	PackageManager  string
	PackageFilePath string
	Datasource      string
	DepTypes        string
	PackageType     string
	PackageUrl      string
}

type RenovateUpdate

type RenovateUpdate struct {
	Platform        string
	Organisation    string
	Repo            string
	PackageName     string
	Version         string
	CurrentVersion  sql.NullString
	Digest          sql.NullString
	PackageManager  string
	PackageFilePath string
	Datasource      string
	NewVersion      string
	NewDigest       sql.NullString
	UpdateType      string
}

type RepositoryMetadatum added in v0.67.0

type RepositoryMetadatum struct {
	Platform           string
	Organisation       string
	Repo               string
	IsMonorepo         bool
	IsFork             bool
	RepositoryType     string
	RepositoryUsage    sql.NullString
	Visibility         string
	Description        sql.NullString
	AdditionalMetadata sql.NullString
}

type RetrieveDistinctReposAndPackagesRow

type RetrieveDistinctReposAndPackagesRow struct {
	Platform                           string
	Organisation                       string
	Repo                               string
	PackageName                        string
	Version                            string
	CurrentVersion                     sql.NullString
	PackageManager                     string
	DepTypes                           string
	PackageFilePath                    string
	Licenses                           string
	PackageName_2                      sql.NullString
	PackageType                        sql.NullString
	ScorecardScore                     sql.NullFloat64
	ScorecardCodereview                sql.NullInt64
	ScorecardMaintained                sql.NullInt64
	ScorecardCiibestpractices          sql.NullInt64
	ScorecardLicense                   sql.NullInt64
	ScorecardDangerousworkflow         sql.NullInt64
	ScorecardPackaging                 sql.NullInt64
	ScorecardTokenpermissions          sql.NullInt64
	ScorecardSignedreleases            sql.NullInt64
	ScorecardBranchprotection          sql.NullInt64
	ScorecardBinaryartifacts           sql.NullInt64
	ScorecardFuzzing                   sql.NullInt64
	ScorecardSecuritypolicy            sql.NullInt64
	ScorecardSast                      sql.NullInt64
	ScorecardVulnerabilities           sql.NullInt64
	ScorecardPinneddependencies        sql.NullInt64
	EcosystemsRepoArchived             sql.NullBool
	EcosystemsRepoPushedAt             sql.NullString
	EcosystemsRepoUpdatedAt            sql.NullString
	EcosystemsRepoLastSyncedAt         sql.NullString
	EcosystemsLastSyncedAt             sql.NullString
	EcosystemsLatestReleasePublishedAt sql.NullString
	EcosystemsStatus                   sql.NullString
	EcosystemsFunding                  sql.NullString
}

type RetrieveDistinctReposAndPackagesWithDependencyHealthRow added in v0.102.0

type RetrieveDistinctReposAndPackagesWithDependencyHealthRow struct {
	Platform                           string
	Organisation                       string
	Repo                               string
	PackageName                        string
	Version                            string
	CurrentVersion                     sql.NullString
	PackageManager                     string
	DepTypes                           string
	PackageFilePath                    string
	PackageName_2                      sql.NullString
	PackageType                        sql.NullString
	ScorecardScore                     sql.NullFloat64
	ScorecardCodereview                sql.NullInt64
	ScorecardMaintained                sql.NullInt64
	ScorecardCiibestpractices          sql.NullInt64
	ScorecardLicense                   sql.NullInt64
	ScorecardDangerousworkflow         sql.NullInt64
	ScorecardPackaging                 sql.NullInt64
	ScorecardTokenpermissions          sql.NullInt64
	ScorecardSignedreleases            sql.NullInt64
	ScorecardBranchprotection          sql.NullInt64
	ScorecardBinaryartifacts           sql.NullInt64
	ScorecardFuzzing                   sql.NullInt64
	ScorecardSecuritypolicy            sql.NullInt64
	ScorecardSast                      sql.NullInt64
	ScorecardVulnerabilities           sql.NullInt64
	ScorecardPinneddependencies        sql.NullInt64
	EcosystemsRepoArchived             sql.NullBool
	EcosystemsRepoPushedAt             sql.NullString
	EcosystemsRepoUpdatedAt            sql.NullString
	EcosystemsRepoLastSyncedAt         sql.NullString
	EcosystemsLastSyncedAt             sql.NullString
	EcosystemsLatestReleasePublishedAt sql.NullString
	EcosystemsStatus                   sql.NullString
	EcosystemsFunding                  sql.NullString
}

type RetrieveDistinctReposAndPackagesWithLicensesRow added in v0.102.0

type RetrieveDistinctReposAndPackagesWithLicensesRow struct {
	Platform        string
	Organisation    string
	Repo            string
	PackageName     string
	Version         string
	CurrentVersion  sql.NullString
	PackageManager  string
	DepTypes        string
	PackageFilePath string
	Licenses        string
}

type RetrievePolicyViolationsLikeParams

type RetrievePolicyViolationsLikeParams struct {
	Platform string
	Org      string
	Repo     string
	Owner    interface{}
	Level    string
}

func NewRetrievePolicyViolationsLikeParams

func NewRetrievePolicyViolationsLikeParams(platform string, org string, repo string, owner string, level string) RetrievePolicyViolationsLikeParams

type RetrievePolicyViolationsLikeRow

type RetrievePolicyViolationsLikeRow struct {
	Platform        string
	Organisation    string
	Repo            string
	PackageName     string
	Version         string
	CurrentVersion  sql.NullString
	PackageManager  string
	DepTypes        string
	PackageFilePath string
	Owner           sql.NullString
	Level           string
	AdvisoryType    string
	Description     string
}

type RetrievePolicyViolationsRow

type RetrievePolicyViolationsRow struct {
	Platform        string
	Organisation    string
	Repo            string
	PackageName     string
	Version         string
	CurrentVersion  sql.NullString
	PackageManager  string
	DepTypes        string
	PackageFilePath string
	Owner           sql.NullString
	Level           string
	Description     string
}

type RetrieveRepoKeysForPolicyViolationResultParams added in v0.102.0

type RetrieveRepoKeysForPolicyViolationResultParams struct {
	PackageName    string
	Version        string
	CurrentVersion sql.NullString
	PackageManager string
}

type RetrieveRepoKeysForPolicyViolationResultRow added in v0.102.0

type RetrieveRepoKeysForPolicyViolationResultRow struct {
	Platform     string
	Organisation string
	Repo         string
}

type RetrieveRowsForPolicyEvaluationParams added in v0.102.0

type RetrieveRowsForPolicyEvaluationParams struct {
	Limit  int64
	Offset int64
}

type RetrieveRowsForPolicyEvaluationRow added in v0.102.0

type RetrieveRowsForPolicyEvaluationRow struct {
	Platform                           string
	Organisation                       string
	Repo                               string
	PackageName                        string
	Version                            string
	CurrentVersion                     sql.NullString
	PackageManager                     string
	PackageFilePath                    string
	DepTypes                           string
	IsMonorepo                         sql.NullBool
	IsFork                             sql.NullBool
	RepositoryType                     sql.NullString
	RepositoryUsage                    sql.NullString
	Visibility                         sql.NullString
	Description                        sql.NullString
	AdditionalMetadata                 sql.NullString
	Licenses                           string
	ScorecardScore                     sql.NullFloat64
	ScorecardCodereview                sql.NullInt64
	ScorecardMaintained                sql.NullInt64
	ScorecardCiibestpractices          sql.NullInt64
	ScorecardLicense                   sql.NullInt64
	ScorecardDangerousworkflow         sql.NullInt64
	ScorecardPackaging                 sql.NullInt64
	ScorecardTokenpermissions          sql.NullInt64
	ScorecardSignedreleases            sql.NullInt64
	ScorecardBranchprotection          sql.NullInt64
	ScorecardBinaryartifacts           sql.NullInt64
	ScorecardFuzzing                   sql.NullInt64
	ScorecardSecuritypolicy            sql.NullInt64
	ScorecardSast                      sql.NullInt64
	ScorecardVulnerabilities           sql.NullInt64
	ScorecardPinneddependencies        sql.NullInt64
	EcosystemsRepoArchived             sql.NullBool
	EcosystemsRepoPushedAt             sql.NullString
	EcosystemsRepoUpdatedAt            sql.NullString
	EcosystemsRepoLastSyncedAt         sql.NullString
	EcosystemsLastSyncedAt             sql.NullString
	EcosystemsLatestReleasePublishedAt sql.NullString
	EcosystemsStatus                   sql.NullString
	EcosystemsFunding                  sql.NullString
}

type RetrieveRowsForPolicyEvaluation_BaseParams added in v0.102.0

type RetrieveRowsForPolicyEvaluation_BaseParams struct {
	Offset int64
	Limit  int64
}

type RetrieveRowsForPolicyEvaluation_BaseRow added in v0.102.0

type RetrieveRowsForPolicyEvaluation_BaseRow struct {
	PackageName     string
	Version         string
	CurrentVersion  sql.NullString
	PackageManager  string
	PackageFilePath string
	DepTypes        string
}

type RetrieveRowsForPolicyEvaluation_Base_DependencyHealthParams added in v0.102.0

type RetrieveRowsForPolicyEvaluation_Base_DependencyHealthParams struct {
	Offset int64
	Limit  int64
}

type RetrieveRowsForPolicyEvaluation_Base_DependencyHealthRow added in v0.102.0

type RetrieveRowsForPolicyEvaluation_Base_DependencyHealthRow struct {
	PackageName                        string
	Version                            string
	CurrentVersion                     sql.NullString
	PackageManager                     string
	PackageFilePath                    string
	DepTypes                           string
	PackageName_2                      sql.NullString
	PackageType                        sql.NullString
	ScorecardScore                     sql.NullFloat64
	ScorecardCodereview                sql.NullInt64
	ScorecardMaintained                sql.NullInt64
	ScorecardCiibestpractices          sql.NullInt64
	ScorecardLicense                   sql.NullInt64
	ScorecardDangerousworkflow         sql.NullInt64
	ScorecardPackaging                 sql.NullInt64
	ScorecardTokenpermissions          sql.NullInt64
	ScorecardSignedreleases            sql.NullInt64
	ScorecardBranchprotection          sql.NullInt64
	ScorecardBinaryartifacts           sql.NullInt64
	ScorecardFuzzing                   sql.NullInt64
	ScorecardSecuritypolicy            sql.NullInt64
	ScorecardSast                      sql.NullInt64
	ScorecardVulnerabilities           sql.NullInt64
	ScorecardPinneddependencies        sql.NullInt64
	EcosystemsRepoArchived             sql.NullBool
	EcosystemsRepoPushedAt             sql.NullString
	EcosystemsRepoUpdatedAt            sql.NullString
	EcosystemsRepoLastSyncedAt         sql.NullString
	EcosystemsLastSyncedAt             sql.NullString
	EcosystemsLatestReleasePublishedAt sql.NullString
	EcosystemsStatus                   sql.NullString
	EcosystemsFunding                  sql.NullString
}

type RetrieveRowsForPolicyEvaluation_Base_LicensesParams added in v0.102.0

type RetrieveRowsForPolicyEvaluation_Base_LicensesParams struct {
	Offset int64
	Limit  int64
}

type RetrieveRowsForPolicyEvaluation_Base_LicensesRow added in v0.102.0

type RetrieveRowsForPolicyEvaluation_Base_LicensesRow struct {
	PackageName     string
	Version         string
	CurrentVersion  sql.NullString
	PackageManager  string
	PackageFilePath string
	DepTypes        string
	Licenses        string
}

type RetrieveRowsForPolicyEvaluation_Base_RepoKeyParams added in v0.102.0

type RetrieveRowsForPolicyEvaluation_Base_RepoKeyParams struct {
	Offset int64
	Limit  int64
}

type RetrieveRowsForPolicyEvaluation_Base_RepoKeyRow added in v0.102.0

type RetrieveRowsForPolicyEvaluation_Base_RepoKeyRow struct {
	Platform        string
	Organisation    string
	Repo            string
	PackageName     string
	Version         string
	CurrentVersion  sql.NullString
	PackageManager  string
	PackageFilePath string
	DepTypes        string
}

type Sbom

type Sbom struct {
	ComponentName  string
	PackageName    string
	Version        sql.NullString
	CurrentVersion sql.NullString
	PackageType    string
	PackageUrl     string
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL