db

Documentation

Index

• Variables
• type DBTX
• type InsertPackageParams
• type InsertPackageUpdateParams
• type Owner
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) InsertPackage(ctx context.Context, arg InsertPackageParams) error
  • func (q *Queries) InsertPackageUpdate(ctx context.Context, arg InsertPackageUpdateParams) error
  • func (q *Queries) QueryDistinctProjects(ctx context.Context, arg QueryDistinctProjectsParams) ([]QueryDistinctProjectsRow, error)
  • func (q *Queries) QueryGolangCILintDirect(ctx context.Context) ([]QueryGolangCILintDirectRow, error)
  • func (q *Queries) QueryGolangCILintIndirect(ctx context.Context) ([]QueryGolangCILintIndirectRow, error)
  • func (q *Queries) QueryMostPopularDockerImages(ctx context.Context) ([]QueryMostPopularDockerImagesRow, error)
  • func (q *Queries) QueryMostPopularPackageManagers(ctx context.Context) ([]QueryMostPopularPackageManagersRow, error)
  • func (q *Queries) RetrieveAll(ctx context.Context) ([]Renovate, 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) ([]Renovate, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type QueryDistinctProjectsParams
• type QueryDistinctProjectsRow
• type QueryGolangCILintDirectRow
• type QueryGolangCILintIndirectRow
• type QueryMostPopularDockerImagesRow
• type QueryMostPopularPackageManagersRow
• type Renovate
• type RenovateUpdate
• type RetrieveDistinctPackagesRow
• type RetrieveDistinctPackagesWithoutSensitivePackagesRow
• 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         string
	CurrentVersion  sql.NullString
	PackageManager  string
	PackageFilePath string
	Datasource      string
	DepTypes        string
}

type InsertPackageUpdateParams

type InsertPackageUpdateParams 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 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) InsertPackageUpdate

func (q *Queries) InsertPackageUpdate(ctx context.Context, arg InsertPackageUpdateParams) error

func (*Queries) QueryDistinctProjects

func (q *Queries) QueryDistinctProjects(ctx context.Context, arg QueryDistinctProjectsParams) ([]QueryDistinctProjectsRow, error)

func (*Queries) QueryGolangCILintDirect

func (q *Queries) QueryGolangCILintDirect(ctx context.Context) ([]QueryGolangCILintDirectRow, error)

preferably with a `json_each` but due to https://github.com/sqlc-dev/sqlc/issues/1830 we need to handle it like this

func (*Queries) QueryGolangCILintIndirect

func (q *Queries) QueryGolangCILintIndirect(ctx context.Context) ([]QueryGolangCILintIndirectRow, error)

preferably with a `json_each` but due to https://github.com/sqlc-dev/sqlc/issues/1830 we need to handle it like this

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

func (q *Queries) RetrieveAll(ctx context.Context) ([]Renovate, 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) ([]Renovate, error)

func (*Queries) WithTx

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

type QueryDistinctProjectsParams

type QueryDistinctProjectsParams struct {
	Platform     string
	Organisation string
	Repo         string
}

type QueryDistinctProjectsRow

type QueryDistinctProjectsRow struct {
	Platform     string
	Organisation string
	Repo         string
}

type QueryGolangCILintDirectRow

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

type QueryGolangCILintIndirectRow

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

type QueryMostPopularDockerImagesRow

type QueryMostPopularDockerImagesRow struct {
	PackageName string
	Count       int64
}

type QueryMostPopularPackageManagersRow

type QueryMostPopularPackageManagersRow struct {
	PackageManager string
	Count          int64
}

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

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

type RetrieveDistinctPackagesWithoutSensitivePackagesRow

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

type SensitivePackage

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