mariadb

type ActivityHasIssueRow struct {
	ActivityId sql.NullInt64 `db:"activityhasissue_activity_id" json:"activity_id"`
	IssueId    sql.NullInt64 `db:"activityhasissue_issue_id" json:"issue_id"`
	CreatedAt  sql.NullTime  `db:"activityhasissue_created_at" json:"created_at"`
	DeletedAt  sql.NullTime  `db:"activityhasissue_deleted_at" json:"deleted_at,omitempty"`
	UpdatedAt  sql.NullTime  `db:"activityhasissue_updated_at" json:"updated_at"`
}

type ActivityHasServiceRow struct {
	ActivityId sql.NullInt64 `db:"activityhasservice_activity_id" json:"activity_id"`
	ServiceId  sql.NullInt64 `db:"activityhasservice_service_id" json:"service_id"`
	CreatedAt  sql.NullTime  `db:"activityhasservice_created_at" json:"created_at"`
	DeletedAt  sql.NullTime  `db:"activityhasservice_deleted_at" json:"deleted_at,omitempty"`
	UpdatedAt  sql.NullTime  `db:"activityhasservice_updated_at" json:"updated_at"`
}

type ActivityRow struct {
	Id        sql.NullInt64  `db:"activity_id" json:"id"`
	Status    sql.NullString `db:"activity_status" json:"status"`
	CreatedAt sql.NullTime   `db:"activity_created_at" json:"created_at"`
	CreatedBy sql.NullInt64  `db:"activity_created_by" json:"created_by"`
	DeletedAt sql.NullTime   `db:"activity_deleted_at" json:"deleted_at,omitempty"`
	UpdatedAt sql.NullTime   `db:"activity_updated_at" json:"updated_at"`
	UpdatedBy sql.NullInt64  `db:"activity_updated_by" json:"updated_by"`
}

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,omitempty"`
	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,omitempty"`
	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,omitempty"`
	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"`
	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,omitempty"`
	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,omitempty"`
	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,omitempty"`
	UpdatedAt    sql.NullTime   `db:"componentversion_updated_at" json:"updated_at"`
	UpdatedBy    sql.NullInt64  `db:"componentversion_updated_by" json:"updated_by"`
}

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

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

type EvidenceRow struct {
	Id          sql.NullInt64  `db:"evidence_id" json:"id"`
	Description sql.NullString `db:"evidence_description" json:"description"`
	Type        sql.NullString `db:"evidence_type" json:"type"`
	Vector      sql.NullString `db:"evidence_vector" json:"vector"`
	Rating      sql.NullString `db:"evidence_rating" json:"rating"`
	RAAEnd      sql.NullTime   `db:"evidence_raa_end" json:"raa_end"`
	User        *UserRow       `json:"user,omitempty"`
	UserId      sql.NullInt64  `db:"evidence_author_id"`
	Activity    *ActivityRow   `json:"activity,omitempty"`
	ActivityId  sql.NullInt64  `db:"evidence_activity_id"`
	CreatedAt   sql.NullTime   `db:"evidence_created_at" json:"created_at"`
	CreatedBy   sql.NullInt64  `db:"evidence_created_by" json:"created_by"`
	DeletedAt   sql.NullTime   `db:"evidence_deleted_at" json:"deleted_at,omitempty"`
	UpdatedAt   sql.NullTime   `db:"evidence_updated_at" json:"updated_at"`
	UpdatedBy   sql.NullInt64  `db:"evidence_updated_by" json:"updated_by"`
}

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

type GetIssuesByRow struct {
	IssueAggregationsRow
	IssueRow
}

type GetServicesByRow struct {
	ServiceAggregationsRow
	ServiceRow
}

type IssueAggregationsRow struct {
	Activities                    sql.NullInt64 `db:"agg_activities"`
	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 IssueMatchChangeRow struct {
	Id           sql.NullInt64  `db:"issuematchchange_id" json:"id"`
	IssueMatchId sql.NullInt64  `db:"issuematchchange_issue_match_id" json:"issue_match_id"`
	ActivityId   sql.NullInt64  `db:"issuematchchange_activity_id" json:"activity_id"`
	Action       sql.NullString `db:"issuematchchange_action" json:"action"`
	CreatedAt    sql.NullTime   `db:"issuematchchange_created_at" json:"created_at"`
	CreatedBy    sql.NullInt64  `db:"issuematchchange_created_by" json:"created_by"`
	DeletedAt    sql.NullTime   `db:"issuematchchange_deleted_at" json:"deleted_at,omitempty"`
	UpdatedAt    sql.NullTime   `db:"issuematchchange_updated_at" json:"updated_at"`
	UpdatedBy    sql.NullInt64  `db:"issuematchchange_updated_by" json:"updated_by"`
}

type IssueMatchEvidenceRow struct {
	EvidenceId   sql.NullInt64 `db:"issuematchevidence_evidence_id" json:"evidence_id"`
	IssueMatchId sql.NullInt64 `db:"issuematchevidence_issue_match_id" json:"issue_match_id"`
	CreatedAt    sql.NullTime  `db:"issuematchevidence_created_at" json:"created_at"`
	DeletedAt    sql.NullTime  `db:"issuematchevidence_deleted_at" json:"deleted_at,omitempty"`
	UpdatedAt    sql.NullTime  `db:"issuematchevidence_updated_at" json:"updated_at"`
}

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,omitempty"`
	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,omitempty"`
	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,omitempty"`
	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,omitempty"`
	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 NamedStmt interface {
	Close() error
	Exec(arg interface{}) (sql.Result, error)
}

type NewCursor func(cursors *cursors) error

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,omitempty"`
	UpdatedAt sql.NullTime  `db:"owner_updated_at" json:"updated_at"`
}

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 RowComposite struct {
	*IssueRow
	*IssueCountRow
	*GetIssuesByRow
	*IssueMatchRow
	*IssueAggregationsRow
	*IssueVariantRow
	*BaseIssueRepositoryRow
	*IssueRepositoryRow
	*IssueVariantWithRepository
	*ComponentRow
	*ComponentInstanceRow
	*ComponentVersionRow
	*BaseServiceRow
	*ServiceRow
	*GetServicesByRow
	*ServiceAggregationsRow
	*ActivityRow
	*UserRow
	*EvidenceRow
	*OwnerRow
	*SupportGroupRow
	*SupportGroupServiceRow
	*ActivityHasIssueRow
	*ActivityHasServiceRow
	*IssueRepositoryServiceRow
	*IssueMatchChangeRow
	*ServiceIssueVariantRow
	*RatingCount
}

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"`
}

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 ...interface{}) (*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,omitempty"`
	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,omitempty"`
	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,omitempty"`
	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,omitempty"`
	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"`
}