db

Documentation

Index

• Variables
• type ComponentMetadatum
• type DBTX
• type InsertPackageParams
• type Owner
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) InsertPackage(ctx context.Context, arg InsertPackageParams) error
  • func (q *Queries) QueryGolangCILint(ctx context.Context) ([]QueryGolangCILintRow, error)
  • func (q *Queries) QueryMostPopularDockerImages(ctx context.Context) ([]QueryMostPopularDockerImagesRow, error)
  • func (q *Queries) QueryMostPopularPackageManagers(ctx context.Context) ([]QueryMostPopularPackageManagersRow, error)
  • func (q *Queries) RetrieveDistinctPackages(ctx context.Context) ([]RetrieveDistinctPackagesRow, error)
  • func (q *Queries) RetrieveDistinctPackagesWithoutSensitivePackages(ctx context.Context) ([]RetrieveDistinctPackagesWithoutSensitivePackagesRow, error)
  • func (q *Queries) RetrieveReposAndPackagesForMissingData(ctx context.Context) ([]RetrieveReposAndPackagesForMissingDataRow, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type QueryGolangCILintRow
• type QueryMostPopularDockerImagesRow
• type QueryMostPopularPackageManagersRow
• type RetrieveDistinctPackagesRow
• type RetrieveDistinctPackagesWithoutSensitivePackagesRow
• type RetrieveReposAndPackagesForMissingDataRow
• type Sbom
• type SensitivePackage

Variables

var CreateTablesQuery string

Types

type ComponentMetadatum

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 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 InsertPackageParams

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

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) InsertPackage

func (q *Queries) InsertPackage(ctx context.Context, arg InsertPackageParams) error

func (*Queries) QueryGolangCILint

func (q *Queries) QueryGolangCILint(ctx context.Context) ([]QueryGolangCILintRow, error)

TODO: revisit in https://gitlab.com/tanna.dev/dependency-management-data/-/issues/596 and make this a `left join`

func (*Queries) QueryMostPopularDockerImages

func (q *Queries) QueryMostPopularDockerImages(ctx context.Context) ([]QueryMostPopularDockerImagesRow, error)

func (*Queries) QueryMostPopularPackageManagers

func (q *Queries) QueryMostPopularPackageManagers(ctx context.Context) ([]QueryMostPopularPackageManagersRow, error)

func (*Queries) RetrieveDistinctPackages

func (q *Queries) RetrieveDistinctPackages(ctx context.Context) ([]RetrieveDistinctPackagesRow, error)

func (*Queries) RetrieveDistinctPackagesWithoutSensitivePackages

func (q *Queries) RetrieveDistinctPackagesWithoutSensitivePackages(ctx context.Context) ([]RetrieveDistinctPackagesWithoutSensitivePackagesRow, error)

func (*Queries) RetrieveReposAndPackagesForMissingData

func (q *Queries) RetrieveReposAndPackagesForMissingData(ctx context.Context) ([]RetrieveReposAndPackagesForMissingDataRow, error)

func (*Queries) WithTx

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

type QueryGolangCILintRow

type QueryGolangCILintRow struct {
	Platform     sql.NullString
	Organisation sql.NullString
	Repo         sql.NullString
	Owner        sql.NullString
}

type QueryMostPopularDockerImagesRow

type QueryMostPopularDockerImagesRow struct {
	PackageName string
	Count       int64
}

type QueryMostPopularPackageManagersRow

type QueryMostPopularPackageManagersRow struct {
	PackageType string
	Count       int64
}

type RetrieveDistinctPackagesRow

type RetrieveDistinctPackagesRow struct {
	PackageName    string
	Version        sql.NullString
	CurrentVersion sql.NullString
	PackageType    string
}

type RetrieveDistinctPackagesWithoutSensitivePackagesRow

type RetrieveDistinctPackagesWithoutSensitivePackagesRow struct {
	PackageName    string
	Version        sql.NullString
	CurrentVersion sql.NullString
	PackageType    string
}

type RetrieveReposAndPackagesForMissingDataRow

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

type Sbom

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

type SensitivePackage

type SensitivePackage struct {
	PackagePattern string
	PackageManager sql.NullString
	MatchStrategy  string
}