db

Documentation

Index

• Variables
• type Advisory
• type AwsElasticacheDatastore
• type AwsElasticacheDatastoreEngine
• type AwsLambdaFunction
• type AwsLambdaFunctionRuntime
• type AwsRdsDatabase
• type AwsRdsDatabasesEngine
• type DBTX
• type DependabotEndoflife
• type DepsdevCfe
• type DepsdevLicense
• type EndoflifedateProduct
• type Owner
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) AnonymiseAdvisoriesPackagePatternByOrg(ctx context.Context, packagePattern string) error
  • func (q *Queries) RetrieveAWSAdvisories(ctx context.Context) ([]RetrieveAWSAdvisoriesRow, error)
  • func (q *Queries) RetrievePackageAdvisories(ctx context.Context) ([]RetrievePackageAdvisoriesRow, error)
  • func (q *Queries) RetrievePackageAdvisoriesLike(ctx context.Context, arg RetrievePackageAdvisoriesLikeParams) ([]RetrievePackageAdvisoriesLikeRow, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type Renovate
• type RenovateEndoflife
• type RenovateUpdate
• type RetrieveAWSAdvisoriesRow
• type RetrievePackageAdvisoriesLikeParams
  • func NewRetrievePackageAdvisoriesLikeParams(platform, org, repo, owner string) RetrievePackageAdvisoriesLikeParams
  • func (p RetrievePackageAdvisoriesLikeParams) IsWildcard() bool
• type RetrievePackageAdvisoriesLikeRow
• type RetrievePackageAdvisoriesRow
• type Sbom
• type SbomsEndoflife

Variables

var CreateTablesQuery string

Types

type Advisory

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

type AwsElasticacheDatastore

type AwsElasticacheDatastore struct {
	AccountID     string
	Region        string
	Arn           string
	Name          string
	Engine        string
	EngineVersion string
	Tags          string
}

type AwsElasticacheDatastoreEngine

type AwsElasticacheDatastoreEngine struct {
	Engine        string
	EngineVersion string
	Deprecation   string
}

type AwsLambdaFunction

type AwsLambdaFunction struct {
	AccountID    string
	Region       string
	Arn          string
	Name         string
	Runtime      string
	LastModified sql.NullString
	Tags         string
}

type AwsLambdaFunctionRuntime

type AwsLambdaFunctionRuntime struct {
	Runtime     string
	Deprecation sql.NullString
	EndOfLife   sql.NullString
}

type AwsRdsDatabase

type AwsRdsDatabase struct {
	AccountID     string
	Region        string
	Arn           string
	Name          string
	Engine        string
	EngineVersion string
	Tags          string
}

type AwsRdsDatabasesEngine

type AwsRdsDatabasesEngine struct {
	Engine        string
	EngineVersion string
	Deprecation   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 DependabotEndoflife

type DependabotEndoflife struct {
	PackageName    string
	Version        string
	PackageManager string
	ProductName    string
	Cycle          string
}

type DepsdevCfe

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

type DepsdevLicense

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

type EndoflifedateProduct

type EndoflifedateProduct struct {
	ProductName    string
	Cycle          string
	SupportedUntil sql.NullString
	EolFrom        sql.NullString
	InsertedAt     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) AnonymiseAdvisoriesPackagePatternByOrg

func (q *Queries) AnonymiseAdvisoriesPackagePatternByOrg(ctx context.Context, packagePattern string) error

func (*Queries) RetrieveAWSAdvisories

func (q *Queries) RetrieveAWSAdvisories(ctx context.Context) ([]RetrieveAWSAdvisoriesRow, error)

func (*Queries) RetrievePackageAdvisories

func (q *Queries) RetrievePackageAdvisories(ctx context.Context) ([]RetrievePackageAdvisoriesRow, error)

func (*Queries) RetrievePackageAdvisoriesLike

func (q *Queries) RetrievePackageAdvisoriesLike(ctx context.Context, arg RetrievePackageAdvisoriesLikeParams) ([]RetrievePackageAdvisoriesLikeRow, error)

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
	PackageManager  string
	PackageFilePath string
	Datasource      string
	DepTypes        string
}

type RenovateEndoflife

type RenovateEndoflife struct {
	PackageName    string
	Version        string
	CurrentVersion sql.NullString
	PackageManager string
	Datasource     string
	ProductName    string
	Cycle          string
}

type RenovateUpdate

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

type RetrieveAWSAdvisoriesRow

type RetrieveAWSAdvisoriesRow struct {
	Arn          string
	Name         string
	Runtime      sql.NullString
	AdvisoryType interface{}
	Description  interface{}
}

type RetrievePackageAdvisoriesLikeParams

type RetrievePackageAdvisoriesLikeParams struct {
	Platform string
	Org      string
	Repo     string
	Owner    interface{}
}

func NewRetrievePackageAdvisoriesLikeParams

func NewRetrievePackageAdvisoriesLikeParams(platform, org, repo, owner string) RetrievePackageAdvisoriesLikeParams

NewRetrievePackageAdvisoriesLikeParams constructs a RetrievePackageAdvisoriesLikeParams with the correct defaults, and replaces wildcard characters (`*`) with the appropriate SQL

func (RetrievePackageAdvisoriesLikeParams) IsWildcard

func (p RetrievePackageAdvisoriesLikeParams) IsWildcard() bool

type RetrievePackageAdvisoriesLikeRow

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

type RetrievePackageAdvisoriesRow

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

type Sbom

type Sbom struct {
	Platform       string
	Organisation   string
	Repo           string
	PackageName    string
	Version        sql.NullString
	CurrentVersion sql.NullString
	PackageType    string
}

type SbomsEndoflife

type SbomsEndoflife struct {
	PackageName    string
	Version        sql.NullString
	CurrentVersion sql.NullString
	PackageType    string
	ProductName    string
	Cycle          string
}