mariadb

type BaseIssueRepositoryRow struct {
	Id        sql.NullInt64  `db:"issuerepository_id"`
	Name      sql.NullString `db:"issuerepository_name"`
	Url       sql.NullString `db:"issuerepository_url"`
	CreatedAt sql.NullTime   `db:"issuerepository_created_at" json:"created_at"`
	CreatedBy sql.NullInt64  `db:"issuerepository_created_by" json:"created_by"`
	DeletedAt sql.NullTime   `db:"issuerepository_deleted_at" json:"deleted_at"`
	UpdatedAt sql.NullTime   `db:"issuerepository_updated_at" json:"updated_at"`
	UpdatedBy sql.NullInt64  `db:"issuerepository_updated_by" json:"updated_by"`
}

type BaseServiceRow struct {
	Id        sql.NullInt64  `db:"service_id"         json:"id"`
	CCRN      sql.NullString `db:"service_ccrn"       json:"ccrn"`
	Domain    sql.NullString `db:"service_domain"     json:"domain"`
	Region    sql.NullString `db:"service_region"     json:"region"`
	CreatedAt sql.NullTime   `db:"service_created_at" json:"created_at"`
	CreatedBy sql.NullInt64  `db:"service_created_by" json:"created_by"`
	DeletedAt sql.NullTime   `db:"service_deleted_at" json:"deleted_at"`
	UpdatedAt sql.NullTime   `db:"service_updated_at" json:"updated_at"`
	UpdatedBy sql.NullInt64  `db:"service_updated_by" json:"updated_by"`
}

type ComponentInstanceRow struct {
	Id                 sql.NullInt64  `db:"componentinstance_id"                   json:"id"`
	CCRN               sql.NullString `db:"componentinstance_ccrn"                 json:"ccrn"`
	Region             sql.NullString `db:"componentinstance_region"               json:"region"`
	Cluster            sql.NullString `db:"componentinstance_cluster"              json:"cluster"`
	Namespace          sql.NullString `db:"componentinstance_namespace"            json:"namespace"`
	Domain             sql.NullString `db:"componentinstance_domain"               json:"domain"`
	Project            sql.NullString `db:"componentinstance_project"              json:"project"`
	Pod                sql.NullString `db:"componentinstance_pod"                  json:"pod"`
	Container          sql.NullString `db:"componentinstance_container"            json:"container"`
	Type               sql.NullString `db:"componentinstance_type"                 json:"type"`
	ParentId           sql.NullInt64  `db:"componentinstance_parent_id"`
	Context            sql.NullString `db:"componentinstance_context"              json:"context"`
	Count              sql.NullInt16  `db:"componentinstance_count"                json:"count"`
	ComponentVersionId sql.NullInt64  `db:"componentinstance_component_version_id"`
	ServiceId          sql.NullInt64  `db:"componentinstance_service_id"`
	CreatedAt          sql.NullTime   `db:"componentinstance_created_at"           json:"created_at"`
	CreatedBy          sql.NullInt64  `db:"componentinstance_created_by"           json:"created_by"`
	DeletedAt          sql.NullTime   `db:"componentinstance_deleted_at"           json:"deleted_at"`
	UpdatedAt          sql.NullTime   `db:"componentinstance_updated_at"           json:"updated_at"`
	UpdatedBy          sql.NullInt64  `db:"componentinstance_updated_by"           json:"udpated_by"`
}

type ComponentRow struct {
	Id           sql.NullInt64  `db:"component_id"           json:"id"`
	CCRN         sql.NullString `db:"component_ccrn"         json:"ccrn"`
	Repository   sql.NullString `db:"component_repository"   json:"repository"`
	Organization sql.NullString `db:"component_organization" json:"organization"`
	Url          sql.NullString `db:"component_url"          json:"url"`
	Type         sql.NullString `db:"component_type"         json:"type"`
	CreatedAt    sql.NullTime   `db:"component_created_at"   json:"created_at"`
	CreatedBy    sql.NullInt64  `db:"component_created_by"   json:"created_by"`
	DeletedAt    sql.NullTime   `db:"component_deleted_at"   json:"deleted_at"`
	UpdatedAt    sql.NullTime   `db:"component_updated_at"   json:"updated_at"`
	UpdatedBy    sql.NullInt64  `db:"component_updated_by"   json:"updated_by"`
}

type ComponentVersionIssueRow struct {
	ComponentVersionId sql.NullInt64 `db:"componentversionissue_component_version_id" json:"component_version_id"`
	IssueId            sql.NullInt64 `db:"componentversionissue_issue_id"             json:"issue_id"`
	CreatedAt          sql.NullTime  `db:"componentversionissue_created_at"           json:"created_at"`
	DeletedAt          sql.NullTime  `db:"componentversionissue_deleted_at"           json:"deleted_at"`
	UpdatedAt          sql.NullTime  `db:"componentversionissue_updated_at"           json:"updated_at"`
}

type ComponentVersionRow struct {
	Id           sql.NullInt64  `db:"componentversion_id"           json:"id"`
	Version      sql.NullString `db:"componentversion_version"      json:"version"`
	Tag          sql.NullString `db:"componentversion_tag"          json:"tag"`
	Repository   sql.NullString `db:"componentversion_repository"   json:"repository"`
	Organization sql.NullString `db:"componentversion_organization" json:"organization"`
	ComponentId  sql.NullInt64  `db:"componentversion_component_id"`
	CreatedAt    sql.NullTime   `db:"componentversion_created_at"   json:"created_at"`
	CreatedBy    sql.NullInt64  `db:"componentversion_created_by"   json:"created_by"`
	DeletedAt    sql.NullTime   `db:"componentversion_deleted_at"   json:"deleted_at"`
	UpdatedAt    sql.NullTime   `db:"componentversion_updated_at"   json:"updated_at"`
	UpdatedBy    sql.NullInt64  `db:"componentversion_updated_by"   json:"updated_by"`
	EndOfLife    sql.NullBool   `db:"componentversion_end_of_life"  json:"end_of_life"`
}

type DatabaseRow interface {
	IssueRow |
		IssueCountRow |
		GetIssuesByRow |
		IssueMatchRow |
		IssueAggregationsRow |
		IssueVariantRow |
		BaseIssueRepositoryRow |
		IssueRepositoryRow |
		IssueVariantWithRepository |
		ComponentRow |
		ComponentInstanceRow |
		ComponentVersionRow |
		BaseServiceRow |
		ServiceRow |
		GetServicesByRow |
		ServiceAggregationsRow |
		UserRow |
		OwnerRow |
		SupportGroupRow |
		SupportGroupServiceRow |
		IssueRepositoryServiceRow |
		ServiceIssueVariantRow |
		RatingCount |
		RowComposite |
		PatchRow
}

type Db interface {
	Close() error
	Exec(query string, args ...any) (sql.Result, error)
	Get(dest any, query string, args ...any) error
	GetDbInstance() *sql.DB
	Preparex(query string) (Stmt, error)
	PreparexContext(ctx context.Context, query string) (Stmt, error)
	PrepareNamed(query string) (NamedStmt, error)
	Select(dest any, query string, args ...any) error
	Query(query string, args ...any) (SqlRows, error)
	QueryContext(ctx context.Context, query string, args ...any) (SqlRows, error)
	QueryRow(query string, args ...any) *sql.Row
}

type DbObject[ET entity.Entity] struct {
	Prefix           string
	TableName        string
	Properties       []*Property
	FilterProperties []*FilterProperty
	JoinDefs         []*JoinDef
}

type Field struct {
	Name  entity.OrderByField
	Value any
	Order entity.OrderDirection
}

type FilterProperty struct {
	QueryBuilder  func([]any) string
	Param         func(any) []any
	ParamAppender func([]any, any) []any
}

type GetIssuesByRow struct {
	IssueAggregationsRow
	IssueRow
}

type GetServicesByRow struct {
	ServiceAggregationsRow
	ServiceRow
}

type IssueAggregationsRow struct {
	IssueMatches                  sql.NullInt64 `db:"agg_issue_matches"`
	AffectedServices              sql.NullInt64 `db:"agg_affected_services"`
	ComponentVersions             sql.NullInt64 `db:"agg_component_versions"`
	AffectedComponentInstances    sql.NullInt64 `db:"agg_affected_component_instances"`
	EarliestTargetRemediationDate sql.NullTime  `db:"agg_earliest_target_remediation_date"`
	EarliestDiscoveryDate         sql.NullTime  `db:"agg_earliest_discovery_date"`
}

type IssueCountRow struct {
	Count sql.NullInt64  `db:"issue_count"`
	Value sql.NullString `db:"issue_value"`
}

type IssueMatchRow struct {
	Id                    sql.NullInt64  `db:"issuematch_id"                      json:"id"`
	Status                sql.NullString `db:"issuematch_status"                  json:"status"`
	Vector                sql.NullString `db:"issuematch_vector"                  json:"vector"`
	Rating                sql.NullString `db:"issuematch_rating"                  json:"rating"`
	UserId                sql.NullInt64  `db:"issuematch_user_id"                 json:"user_id"`
	ComponentInstanceId   sql.NullInt64  `db:"issuematch_component_instance_id"   json:"component_instance_id"`
	IssueId               sql.NullInt64  `db:"issuematch_issue_id"                json:"issue_id"`
	RemediationDate       sql.NullTime   `db:"issuematch_remediation_date"        json:"remediation_date"`
	TargetRemediationDate sql.NullTime   `db:"issuematch_target_remediation_date" json:"target_remediation_date"`
	CreatedAt             sql.NullTime   `db:"issuematch_created_at"              json:"created_at"`
	CreatedBy             sql.NullInt64  `db:"issuematch_created_by"              json:"created_by"`
	DeletedAt             sql.NullTime   `db:"issuematch_deleted_at"              json:"deleted_at"`
	UpdatedAt             sql.NullTime   `db:"issuematch_updated_at"              json:"updated_at"`
	UpdatedBy             sql.NullInt64  `db:"issuematch_updated_by"              json:"updated_by"`
}

type IssueRepositoryRow struct {
	BaseIssueRepositoryRow
	IssueRepositoryServiceRow
}

type IssueRepositoryServiceRow struct {
	IssueRepositoryId sql.NullInt64 `db:"issuerepositoryservice_issue_repository_id" json:"issue_repository_id"`
	ServiceId         sql.NullInt64 `db:"issuerepositoryservice_service_id"          json:"service_id"`
	Priority          sql.NullInt64 `db:"issuerepositoryservice_priority"            json:"priority"`
	CreatedAt         sql.NullTime  `db:"issuerepositoryservice_created_at"          json:"created_at"`
	DeletedAt         sql.NullTime  `db:"issuerepositoryservice_deleted_at"          json:"deleted_at"`
	UpdatedAt         sql.NullTime  `db:"issuerepositoryservice_updated_at"          json:"updated_at"`
}

type IssueRow struct {
	Id          sql.NullInt64  `db:"issue_id"           json:"id"`
	Type        sql.NullString `db:"issue_type"         json:"type"`
	PrimaryName sql.NullString `db:"issue_primary_name" json:"primary_name"`
	Description sql.NullString `db:"issue_description"  json:"description"`
	CreatedAt   sql.NullTime   `db:"issue_created_at"   json:"created_at"`
	CreatedBy   sql.NullInt64  `db:"issue_created_by"   json:"created_by"`
	DeletedAt   sql.NullTime   `db:"issue_deleted_at"   json:"deleted_at"`
	UpdatedAt   sql.NullTime   `db:"issue_updated_at"   json:"updated_at"`
	UpdatedBy   sql.NullInt64  `db:"issue_updated_by"   json:"updated_by"`
}

type IssueVariantRow struct {
	Id                sql.NullInt64  `db:"issuevariant_id"             json:"id"`
	IssueId           sql.NullInt64  `db:"issuevariant_issue_id"       json:"issue_id"`
	IssueRepositoryId sql.NullInt64  `db:"issuevariant_repository_id"  json:"issue_repository_id"`
	SecondaryName     sql.NullString `db:"issuevariant_secondary_name" json:"secondary_name"`
	Vector            sql.NullString `db:"issuevariant_vector"         json:"vector"`
	Rating            sql.NullString `db:"issuevariant_rating"         json:"rating"`
	RatingNumerical   sql.NullInt64  `db:"issuevariant_rating_num"     json:"rating_numerical"`
	Description       sql.NullString `db:"issuevariant_description"    json:"description"`
	ExternalUrl       sql.NullString `db:"issuevariant_external_url"   json:"external_url"`
	CreatedAt         sql.NullTime   `db:"issuevariant_created_at"     json:"created_at"`
	CreatedBy         sql.NullInt64  `db:"issuevariant_created_by"     json:"created_by"`
	DeletedAt         sql.NullTime   `db:"issuevariant_deleted_at"     json:"deleted_at"`
	UpdatedAt         sql.NullTime   `db:"issuevariant_updated_at"     json:"updated_at"`
	UpdatedBy         sql.NullInt64  `db:"issuevariant_updated_by"     json:"updated_by"`
}

type IssueVariantWithRepository struct {
	IssueRepositoryRow
	IssueVariantRow
}

type JoinDef struct {
	Name      string
	Type      JoinType
	Table     string
	On        string
	DependsOn []string
	Condition func(any, *Order) bool
}

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

type JoinType string

type NamedStmt interface {
	Close() error
	Exec(arg any) (sql.Result, error)
}

type NewCursor func(cursors *cursors) error

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

type OwnerRow struct {
	ServiceId sql.NullInt64 `db:"owner_service_id" json:"service_id"`
	UserId    sql.NullInt64 `db:"owner_user_id"    json:"user_id"`
	CreatedAt sql.NullTime  `db:"owner_created_at" json:"created_at"`
	DeletedAt sql.NullTime  `db:"owner_deleted_at" json:"deleted_at"`
	UpdatedAt sql.NullTime  `db:"owner_updated_at" json:"updated_at"`
}

type PatchRow struct {
	Id                   sql.NullInt64  `db:"patch_id"                     json:"id"`
	ServiceId            sql.NullInt64  `db:"patch_service_id"             json:"service_id"`
	ServiceName          sql.NullString `db:"patch_service_name"           json:"service_name"`
	ComponentVersionId   sql.NullInt64  `db:"patch_component_version_id"   json:"compoidnent_version_id"`
	ComponentVersionName sql.NullString `db:"patch_component_version_name" json:"compoidnent_version_name"`
	CreatedAt            sql.NullTime   `db:"patch_created_at"             json:"created_at"`
	CreatedBy            sql.NullInt64  `db:"patch_created_by"             json:"created_by"`
	DeletedAt            sql.NullTime   `db:"patch_deleted_at"             json:"deleted_at"`
	UpdatedAt            sql.NullTime   `db:"patch_updated_at"             json:"updated_at"`
	UpdatedBy            sql.NullInt64  `db:"patch_updated_by"             json:"Updated_by"`
}

type Property struct {
	Name   string
	Access func(any) (any, bool)
}

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

type RatingCount struct {
	Critical sql.NullInt64 `db:"critical_count"`
	High     sql.NullInt64 `db:"high_count"`
	Medium   sql.NullInt64 `db:"medium_count"`
	Low      sql.NullInt64 `db:"low_count"`
	None     sql.NullInt64 `db:"none_count"`
}

type RemediationRow struct {
	Id              sql.NullInt64  `db:"remediation_id"               json:"id"`
	Type            sql.NullString `db:"remediation_type"             json:"type"`
	URL             sql.NullString `db:"remediation_url"              json:"url"`
	Description     sql.NullString `db:"remediation_description"      json:"description"`
	RemediationDate sql.NullTime   `db:"remediation_remediation_date" json:"remediation_date"`
	ExpirationDate  sql.NullTime   `db:"remediation_expiration_date"  json:"expiry_date"`
	Severity        sql.NullString `db:"remediation_severity"         json:"severity"`
	RemediatedBy    sql.NullString `db:"remediation_remediated_by"    json:"remediated_by"`
	RemediatedById  sql.NullInt64  `db:"remediation_remediated_by_id" json:"remediated_by_id"`
	Service         sql.NullString `db:"remediation_service"          json:"service"`
	ServiceId       sql.NullInt64  `db:"remediation_service_id"       json:"service_id"`
	Component       sql.NullString `db:"remediation_component"        json:"component"`
	ComponentId     sql.NullInt64  `db:"remediation_component_id"     json:"component_id"`
	Issue           sql.NullString `db:"remediation_issue"            json:"issue"`
	IssueId         sql.NullInt64  `db:"remediation_issue_id"         json:"issue_id"`
	CreatedAt       sql.NullTime   `db:"remediation_created_at"       json:"created_at"`
	CreatedBy       sql.NullInt64  `db:"remediation_created_by"       json:"created_by"`
	DeletedAt       sql.NullTime   `db:"remediation_deleted_at"       json:"deleted_at"`
	UpdatedAt       sql.NullTime   `db:"remediation_updated_at"       json:"updated_at"`
	UpdatedBy       sql.NullInt64  `db:"remediation_updated_by"       json:"updated_by"`
}

type Row[ET any] interface {
	FromEntity(ET)
	ToEntity() ET
}

type RowComposite struct {
	*IssueRow
	*IssueCountRow
	*GetIssuesByRow
	*IssueMatchRow
	*IssueAggregationsRow
	*IssueVariantRow
	*BaseIssueRepositoryRow
	*IssueRepositoryRow
	*IssueVariantWithRepository
	*ComponentRow
	*ComponentInstanceRow
	*ComponentVersionRow
	*BaseServiceRow
	*ServiceRow
	*GetServicesByRow
	*ServiceAggregationsRow
	*UserRow
	*OwnerRow
	*SupportGroupRow
	*SupportGroupServiceRow
	*IssueRepositoryServiceRow
	*ServiceIssueVariantRow
	*RatingCount
	*RemediationRow
	*PatchRow
}

type ScannerRunRow struct {
	RunID       sql.NullInt64  `db:"scannerrun_run_id"`
	UUID        sql.NullString `db:"scannerrun_uuid"`
	Tag         sql.NullString `db:"scannerrun_tag"`
	StartRun    sql.NullTime   `db:"scannerrun_start_run"`
	EndRun      sql.NullTime   `db:"scannerrun_end_run"`
	IsCompleted sql.NullBool   `db:"scannerrun_is_completed"`
	CreatedAt   sql.NullTime   `db:"scannerrun_created_at"   json:"created_at"`
	CreatedBy   sql.NullInt64  `db:"scannerrun_created_by"   json:"created_by"`
	DeletedAt   sql.NullTime   `db:"scannerrun_deleted_at"   json:"deleted_at"`
	UpdatedAt   sql.NullTime   `db:"scannerrun_updated_at"   json:"updated_at"`
	UpdatedBy   sql.NullInt64  `db:"scannerrun_updated_by"   json:"updated_by"`
}

type ServiceAggregationsRow struct {
	ComponentInstances sql.NullInt64 `db:"service_agg_component_instances"`
	IssueMatches       sql.NullInt64 `db:"service_agg_issue_matches"`
}

type ServiceIssueVariantRow struct {
	IssueRepositoryRow
	IssueVariantRow
}

type ServiceRow struct {
	BaseServiceRow
	IssueRepositoryServiceRow
}

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

type SqlRows interface {
	Close() error
	Err() error
	Next() bool
	Scan(dest ...any) error
}

type Stmt interface {
	Close() error
	Queryx(args ...any) (*sqlx.Rows, error)
	QueryxContext(ctx context.Context, args ...any) (*sqlx.Rows, error)
}

type SupportGroupRow struct {
	Id        sql.NullInt64  `db:"supportgroup_id"         json:"id"`
	CCRN      sql.NullString `db:"supportgroup_ccrn"       json:"ccrn"`
	CreatedAt sql.NullTime   `db:"supportgroup_created_at" json:"created_at"`
	CreatedBy sql.NullInt64  `db:"supportgroup_created_by" json:"created_by"`
	DeletedAt sql.NullTime   `db:"supportgroup_deleted_at" json:"deleted_at"`
	UpdatedAt sql.NullTime   `db:"supportgroup_updated_at" json:"updated_at"`
	UpdatedBy sql.NullInt64  `db:"supportgroup_updated_by" json:"updated_by"`
}

type SupportGroupServiceRow struct {
	SupportGroupId sql.NullInt64 `db:"supportgroupservice_support_group_id" json:"support_group_id"`
	ServiceId      sql.NullInt64 `db:"supportgroupservice_service_id"       json:"service_id"`
	CreatedAt      sql.NullTime  `db:"supportgroupservice_created_at"       json:"created_at"`
	DeletedAt      sql.NullTime  `db:"supportgroupservice_deleted_at"       json:"deleted_at"`
	UpdatedAt      sql.NullTime  `db:"supportgroupservice_updated_at"       json:"updated_at"`
}

type SupportGroupUserRow struct {
	SupportGroupId sql.NullInt64 `db:"supportgroupuser_support_group_id" json:"support_group_id"`
	UserId         sql.NullInt64 `db:"supportgroupuser_user_id"          json:"user_id"`
	CreatedAt      sql.NullTime  `db:"supportgroupuser_created_at"       json:"created_at"`
	DeletedAt      sql.NullTime  `db:"supportgroupuser_deleted_at"       json:"deleted_at"`
	UpdatedAt      sql.NullTime  `db:"supportgroupuser_updated_at"       json:"updated_at"`
}

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

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

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

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

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

type UserRow struct {
	Id           sql.NullInt64  `db:"user_id"             json:"id"`
	Name         sql.NullString `db:"user_name"           json:"ccrn"`
	UniqueUserID sql.NullString `db:"user_unique_user_id" json:"unique_user_id"`
	Type         sql.NullInt64  `db:"user_type"           json:"type"`
	CreatedAt    sql.NullTime   `db:"user_created_at"     json:"created_at"`
	CreatedBy    sql.NullInt64  `db:"user_created_by"     json:"created_by"`
	DeletedAt    sql.NullTime   `db:"user_deleted_at"     json:"deleted_at"`
	UpdatedAt    sql.NullTime   `db:"user_updated_at"     json:"updated_at"`
	UpdatedBy    sql.NullInt64  `db:"user_updated_by"     json:"Updated_by"`
	Email        sql.NullString `db:"user_email"          json:"email"`
}