db

Documentation

Index

• Variables
• 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 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 {
	Platform       string
	Organisation   string
	Repo           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)

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     string
	Organisation string
	Repo         string
	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 {
	Platform       string
	Organisation   string
	Repo           string
	PackageName    string
	Version        sql.NullString
	CurrentVersion sql.NullString
	PackageType    string
}

type Sbom

type Sbom struct {
	Platform       string
	Organisation   string
	Repo           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
}