db

package
v1.2.2 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Jun 6, 2026 License: Apache-2.0 Imports: 9 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Connect 

func Connect(ctx context.Context, databaseURL string, tracer pgx.QueryTracer) (*pgxpool.Pool, *sql.DB, error)

Connect creates a pgxpool connection and returns both a pgxpool (for health checks / lifecycle) and a *sql.DB wrapper (for sqlc Queries and goose).

tracer is an optional pgx.QueryTracer (pass nil to disable). When non-nil it fires for every query executed through the pool, including those issued by sqlc via the database/sql stdlib bridge.

Types

type Activity 

type Activity struct {
	ID               uuid.UUID     `json:"id"`
	MeasureID        uuid.NullUUID `json:"measure_id"`
	Title            string        `json:"title"`
	Description      string        `json:"description"`
	ActivityType     string        `json:"activity_type"`
	Recurrence       string        `json:"recurrence"`
	Status           string        `json:"status"`
	Owner            string        `json:"owner"`
	DueDate          sql.NullTime  `json:"due_date"`
	CompletedAt      sql.NullTime  `json:"completed_at"`
	CompletedBy      string        `json:"completed_by"`
	Notes            string        `json:"notes"`
	EvidenceUrl      string        `json:"evidence_url"`
	ParentActivityID uuid.NullUUID `json:"parent_activity_id"`
	CreatedAt        time.Time     `json:"created_at"`
	UpdatedAt        time.Time     `json:"updated_at"`
	AssigneeID       uuid.NullUUID `json:"assignee_id"`
	Priority         string        `json:"priority"`
	Kind             string        `json:"kind"`
	RefNum           sql.NullInt32 `json:"ref_num"`
}

type AddAssessmentParticipantParams 

type AddAssessmentParticipantParams struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	UserID       uuid.UUID `json:"user_id"`
}

type AddAssetToAssessmentParams 

type AddAssetToAssessmentParams struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	AssetID      uuid.UUID `json:"asset_id"`
}

type AddAvvikAttachmentParams 

type AddAvvikAttachmentParams struct {
	AvvikID    uuid.UUID     `json:"avvik_id"`
	Filename   string        `json:"filename"`
	StorageKey string        `json:"storage_key"`
	UploadedBy uuid.NullUUID `json:"uploaded_by"`
}

type AddAvvikEventParams 

type AddAvvikEventParams struct {
	AvvikID      uuid.UUID       `json:"avvik_id"`
	ActorID      uuid.NullUUID   `json:"actor_id"`
	ActorLabel   string          `json:"actor_label"`
	EventType    string          `json:"event_type"`
	Payload      json.RawMessage `json:"payload"`
	OccurredAt   time.Time       `json:"occurred_at"`
	ImportSource sql.NullString  `json:"import_source"`
}

type AddAvvikNotificationParams 

type AddAvvikNotificationParams struct {
	AvvikID  uuid.UUID     `json:"avvik_id"`
	Audience string        `json:"audience"`
	SentAt   time.Time     `json:"sent_at"`
	SentBy   uuid.NullUUID `json:"sent_by"`
	Notes    string        `json:"notes"`
}

type AddMeasureLinkParams 

type AddMeasureLinkParams struct {
	MeasureID uuid.UUID `json:"measure_id"`
	Url       string    `json:"url"`
	Label     string    `json:"label"`
}

type AddParticipantParams 

type AddParticipantParams struct {
	ResourceType string    `json:"resource_type"`
	ResourceID   uuid.UUID `json:"resource_id"`
	UserID       uuid.UUID `json:"user_id"`
	Role         string    `json:"role"`
}

type AppSetting 

type AppSetting struct {
	ID                int32 `json:"id"`
	ComplianceEnabled bool  `json:"compliance_enabled"`
	RiskEnabled       bool  `json:"risk_enabled"`
	ActivitiesEnabled bool  `json:"activities_enabled"`
	AssetsEnabled     bool  `json:"assets_enabled"`
	PlaygroundEnabled bool  `json:"playground_enabled"`
	AvvikEnabled      bool  `json:"avvik_enabled"`
}

type Asset 

type Asset struct {
	ID          uuid.UUID `json:"id"`
	Name        string    `json:"name"`
	Description string    `json:"description"`
	AssetType   string    `json:"asset_type"`
	Owner       string    `json:"owner"`
	Status      string    `json:"status"`
	Criticality string    `json:"criticality"`
	CreatedAt   time.Time `json:"created_at"`
	UpdatedAt   time.Time `json:"updated_at"`
}

type AuditLog 

type AuditLog struct {
	ID        uuid.UUID       `json:"id"`
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserID    uuid.NullUUID   `json:"user_id"`
	SourceIp  string          `json:"source_ip"`
	UserAgent string          `json:"user_agent"`
	RequestID string          `json:"request_id"`
	TraceID   string          `json:"trace_id"`
	Attrs     json.RawMessage `json:"attrs"`
}

type Avvik 

type Avvik struct {
	ID                        uuid.UUID      `json:"id"`
	Title                     string         `json:"title"`
	Description               string         `json:"description"`
	DiscoveredAt              time.Time      `json:"discovered_at"`
	ReportedAt                sql.NullTime   `json:"reported_at"`
	ReporterName              string         `json:"reporter_name"`
	ReporterEmail             string         `json:"reporter_email"`
	AssignedTo                uuid.NullUUID  `json:"assigned_to"`
	OrgUnitID                 uuid.NullUUID  `json:"org_unit_id"`
	RiskLevel                 string         `json:"risk_level"`
	Status                    string         `json:"status"`
	PersonalData              bool           `json:"personal_data"`
	Ksi                       bool           `json:"ksi"`
	KsiInformationOwner       string         `json:"ksi_information_owner"`
	MarketSensitive           bool           `json:"market_sensitive"`
	MarketAssessmentNote      string         `json:"market_assessment_note"`
	GdprDeadlineAt            sql.NullTime   `json:"gdpr_deadline_at"`
	RealisedRiskID            uuid.NullUUID  `json:"realised_risk_id"`
	RootCause                 string         `json:"root_cause"`
	LessonsLearned            string         `json:"lessons_learned"`
	LogQaDone                 bool           `json:"log_qa_done"`
	FollowupsDelegated        bool           `json:"followups_delegated"`
	ReporterInformed          bool           `json:"reporter_informed"`
	OrgInformed               bool           `json:"org_informed"`
	MgmtInformed              bool           `json:"mgmt_informed"`
	DecisionsAnchored         bool           `json:"decisions_anchored"`
	ImplementationDeadlineSet bool           `json:"implementation_deadline_set"`
	ClosureSummary            string         `json:"closure_summary"`
	ClosedAt                  sql.NullTime   `json:"closed_at"`
	ExternalReference         string         `json:"external_reference"`
	ImportSource              sql.NullString `json:"import_source"`
	ImportedAt                sql.NullTime   `json:"imported_at"`
	CreatedAt                 time.Time      `json:"created_at"`
	UpdatedAt                 time.Time      `json:"updated_at"`
}

type AvvikActivity 

type AvvikActivity struct {
	AvvikID    uuid.UUID `json:"avvik_id"`
	ActivityID uuid.UUID `json:"activity_id"`
	CreatedAt  time.Time `json:"created_at"`
}

type AvvikAttachment 

type AvvikAttachment struct {
	ID         uuid.UUID     `json:"id"`
	AvvikID    uuid.UUID     `json:"avvik_id"`
	Filename   string        `json:"filename"`
	StorageKey string        `json:"storage_key"`
	UploadedBy uuid.NullUUID `json:"uploaded_by"`
	UploadedAt time.Time     `json:"uploaded_at"`
}

type AvvikEvent 

type AvvikEvent struct {
	ID           uuid.UUID       `json:"id"`
	AvvikID      uuid.UUID       `json:"avvik_id"`
	ActorID      uuid.NullUUID   `json:"actor_id"`
	ActorLabel   string          `json:"actor_label"`
	EventType    string          `json:"event_type"`
	Payload      json.RawMessage `json:"payload"`
	OccurredAt   time.Time       `json:"occurred_at"`
	ImportSource sql.NullString  `json:"import_source"`
}

type AvvikMeasure 

type AvvikMeasure struct {
	AvvikID      uuid.UUID `json:"avvik_id"`
	MeasureID    uuid.UUID `json:"measure_id"`
	Relationship string    `json:"relationship"`
	CreatedAt    time.Time `json:"created_at"`
}

type AvvikNotification 

type AvvikNotification struct {
	ID       uuid.UUID     `json:"id"`
	AvvikID  uuid.UUID     `json:"avvik_id"`
	Audience string        `json:"audience"`
	SentAt   time.Time     `json:"sent_at"`
	SentBy   uuid.NullUUID `json:"sent_by"`
	Notes    string        `json:"notes"`
}

type ClaimPendingUserParams 

type ClaimPendingUserParams struct {
	Email      string `json:"email"`
	Provider   string `json:"provider"`
	ProviderID string `json:"provider_id"`
	Name       string `json:"name"`
}

type CompleteActivityParams 

type CompleteActivityParams struct {
	ID          uuid.UUID `json:"id"`
	CompletedBy string    `json:"completed_by"`
	Notes       string    `json:"notes"`
	EvidenceUrl string    `json:"evidence_url"`
}

type CountRisksForMatrixRow 

type CountRisksForMatrixRow struct {
	LikelihoodCurrent  sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent sql.NullInt32 `json:"consequence_current"`
	Count              int64         `json:"count"`
}

type CreateActivityParams 

type CreateActivityParams struct {
	MeasureID    uuid.NullUUID `json:"measure_id"`
	Title        string        `json:"title"`
	Description  string        `json:"description"`
	ActivityType string        `json:"activity_type"`
	Recurrence   string        `json:"recurrence"`
	Priority     string        `json:"priority"`
	Kind         string        `json:"kind"`
	Owner        string        `json:"owner"`
	AssigneeID   uuid.NullUUID `json:"assignee_id"`
	DueDate      sql.NullTime  `json:"due_date"`
}

type CreateAssetParams 

type CreateAssetParams struct {
	Name        string `json:"name"`
	Description string `json:"description"`
	AssetType   string `json:"asset_type"`
	Owner       string `json:"owner"`
	Status      string `json:"status"`
	Criticality string `json:"criticality"`
}

type CreateAvvikParams 

type CreateAvvikParams struct {
	Title                string         `json:"title"`
	Description          string         `json:"description"`
	DiscoveredAt         time.Time      `json:"discovered_at"`
	ReportedAt           sql.NullTime   `json:"reported_at"`
	ReporterName         string         `json:"reporter_name"`
	ReporterEmail        string         `json:"reporter_email"`
	AssignedTo           uuid.NullUUID  `json:"assigned_to"`
	OrgUnitID            uuid.NullUUID  `json:"org_unit_id"`
	RiskLevel            string         `json:"risk_level"`
	Status               string         `json:"status"`
	PersonalData         bool           `json:"personal_data"`
	Ksi                  bool           `json:"ksi"`
	KsiInformationOwner  string         `json:"ksi_information_owner"`
	MarketSensitive      bool           `json:"market_sensitive"`
	MarketAssessmentNote string         `json:"market_assessment_note"`
	GdprDeadlineAt       sql.NullTime   `json:"gdpr_deadline_at"`
	RealisedRiskID       uuid.NullUUID  `json:"realised_risk_id"`
	ImportSource         sql.NullString `json:"import_source"`
	ExternalReference    string         `json:"external_reference"`
	ImportedAt           sql.NullTime   `json:"imported_at"`
}

type CreateFrameworkParams 

type CreateFrameworkParams struct {
	Name          string `json:"name"`
	ShortName     string `json:"short_name"`
	Version       string `json:"version"`
	Description   string `json:"description"`
	FrameworkType string `json:"framework_type"`
}

type CreateMeasureParams 

type CreateMeasureParams struct {
	Name        string        `json:"name"`
	Description string        `json:"description"`
	Category    string        `json:"category"`
	Owner       string        `json:"owner"`
	AssigneeID  uuid.NullUUID `json:"assignee_id"`
	Status      string        `json:"status"`
}

type CreateOrganizationParams 

type CreateOrganizationParams struct {
	Name     string         `json:"name"`
	ParentID uuid.NullUUID  `json:"parent_id"`
	Key      sql.NullString `json:"key"`
}

type CreateRequirementParams 

type CreateRequirementParams struct {
	FrameworkID uuid.UUID `json:"framework_id"`
	Ref         string    `json:"ref"`
	Title       string    `json:"title"`
	Description string    `json:"description"`
	SortOrder   int32     `json:"sort_order"`
}

type CreateRiskAssessmentParams 

type CreateRiskAssessmentParams struct {
	Name                    string        `json:"name"`
	Scope                   string        `json:"scope"`
	AnalysisObject          string        `json:"analysis_object"`
	SecurityObjectives      string        `json:"security_objectives"`
	BusinessObjectives      string        `json:"business_objectives"`
	Type                    string        `json:"type"`
	RiskOwnerID             uuid.NullUUID `json:"risk_owner_id"`
	OrgID                   uuid.NullUUID `json:"org_id"`
	CreatedBy               uuid.NullUUID `json:"created_by"`
	ThreatAssessmentEnabled bool          `json:"threat_assessment_enabled"`
}

type CreateRiskParams 

type CreateRiskParams struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	Name         string    `json:"name"`
	Description  string    `json:"description"`
}

type CreateRiskReassessmentEventParams 

type CreateRiskReassessmentEventParams struct {
	RiskID        uuid.UUID     `json:"risk_id"`
	MeasureID     uuid.UUID     `json:"measure_id"`
	TriggerStatus string        `json:"trigger_status"`
	TriggeredBy   uuid.NullUUID `json:"triggered_by"`
	Note          string        `json:"note"`
}

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 DeclineAssessmentParams 

type DeclineAssessmentParams struct {
	ID             uuid.UUID `json:"id"`
	AcceptanceNote string    `json:"acceptance_note"`
}

type DeleteMeasureLinkParams 

type DeleteMeasureLinkParams struct {
	ID        uuid.UUID `json:"id"`
	MeasureID uuid.UUID `json:"measure_id"`
}

type FilterActivitiesParams 

type FilterActivitiesParams struct {
	Status     interface{} `json:"status"`
	Kind       interface{} `json:"kind"`
	Owner      interface{} `json:"owner"`
	Mine       bool        `json:"mine"`
	AssigneeID uuid.UUID   `json:"assignee_id"`
	PageOffset int32       `json:"page_offset"`
	PageSize   int32       `json:"page_size"`
}

type FilterActivitiesRow 

type FilterActivitiesRow struct {
	ID               uuid.UUID     `json:"id"`
	MeasureID        uuid.NullUUID `json:"measure_id"`
	Title            string        `json:"title"`
	Description      string        `json:"description"`
	ActivityType     string        `json:"activity_type"`
	Recurrence       string        `json:"recurrence"`
	Status           string        `json:"status"`
	Priority         string        `json:"priority"`
	Kind             string        `json:"kind"`
	Owner            string        `json:"owner"`
	AssigneeID       uuid.NullUUID `json:"assignee_id"`
	DueDate          sql.NullTime  `json:"due_date"`
	CompletedAt      sql.NullTime  `json:"completed_at"`
	CompletedBy      string        `json:"completed_by"`
	Notes            string        `json:"notes"`
	EvidenceUrl      string        `json:"evidence_url"`
	ParentActivityID uuid.NullUUID `json:"parent_activity_id"`
	CreatedAt        time.Time     `json:"created_at"`
	UpdatedAt        time.Time     `json:"updated_at"`
	RefNum           sql.NullInt32 `json:"ref_num"`
	MeasureName      string        `json:"measure_name"`
}

type FilterMeasuresParams 

type FilterMeasuresParams struct {
	Status     interface{} `json:"status"`
	Owner      interface{} `json:"owner"`
	Mine       bool        `json:"mine"`
	AssigneeID uuid.UUID   `json:"assignee_id"`
	PageOffset int32       `json:"page_offset"`
	PageSize   int32       `json:"page_size"`
}

type Framework 

type Framework struct {
	ID                uuid.UUID `json:"id"`
	Name              string    `json:"name"`
	ShortName         string    `json:"short_name"`
	Version           string    `json:"version"`
	Description       string    `json:"description"`
	CreatedAt         time.Time `json:"created_at"`
	UpdatedAt         time.Time `json:"updated_at"`
	FrameworkType     string    `json:"framework_type"`
	NotRelevant       bool      `json:"not_relevant"`
	NotRelevantReason string    `json:"not_relevant_reason"`
}

type GetActivityRow 

type GetActivityRow struct {
	ID               uuid.UUID     `json:"id"`
	MeasureID        uuid.NullUUID `json:"measure_id"`
	Title            string        `json:"title"`
	Description      string        `json:"description"`
	ActivityType     string        `json:"activity_type"`
	Recurrence       string        `json:"recurrence"`
	Status           string        `json:"status"`
	Priority         string        `json:"priority"`
	Kind             string        `json:"kind"`
	Owner            string        `json:"owner"`
	AssigneeID       uuid.NullUUID `json:"assignee_id"`
	DueDate          sql.NullTime  `json:"due_date"`
	CompletedAt      sql.NullTime  `json:"completed_at"`
	CompletedBy      string        `json:"completed_by"`
	Notes            string        `json:"notes"`
	EvidenceUrl      string        `json:"evidence_url"`
	ParentActivityID uuid.NullUUID `json:"parent_activity_id"`
	CreatedAt        time.Time     `json:"created_at"`
	UpdatedAt        time.Time     `json:"updated_at"`
	RefNum           sql.NullInt32 `json:"ref_num"`
	MeasureName      string        `json:"measure_name"`
}

type GetDashboardStatsRow 

type GetDashboardStatsRow struct {
	FrameworksCount            int64 `json:"frameworks_count"`
	RequirementsCount          int64 `json:"requirements_count"`
	MeasuresCount              int64 `json:"measures_count"`
	ImplementedCount           int64 `json:"implemented_count"`
	CoveredRequirementsCount   int64 `json:"covered_requirements_count"`
	OverdueActivitiesCount     int64 `json:"overdue_activities_count"`
	ActivitiesDueThisWeekCount int64 `json:"activities_due_this_week_count"`
}

type GetRiskStatsRow 

type GetRiskStatsRow struct {
	Total       int64 `json:"total"`
	RedCount    int64 `json:"red_count"`
	YellowCount int64 `json:"yellow_count"`
	GreenCount  int64 `json:"green_count"`
}

type InsertAuditLogParams 

type InsertAuditLogParams struct {
	Event     string          `json:"event"`
	UserID    uuid.NullUUID   `json:"user_id"`
	SourceIp  string          `json:"source_ip"`
	UserAgent string          `json:"user_agent"`
	RequestID string          `json:"request_id"`
	TraceID   string          `json:"trace_id"`
	Attrs     json.RawMessage `json:"attrs"`
}

type IsParticipantParams 

type IsParticipantParams struct {
	ResourceType string    `json:"resource_type"`
	ResourceID   uuid.UUID `json:"resource_id"`
	UserID       uuid.UUID `json:"user_id"`
}

type IsRiskAssessmentAccessibleParams 

type IsRiskAssessmentAccessibleParams struct {
	ID      uuid.UUID `json:"id"`
	Column2 uuid.UUID `json:"column_2"`
}

type IsRiskAssessmentParticipantParams 

type IsRiskAssessmentParticipantParams struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	UserID       uuid.UUID `json:"user_id"`
}

type LinkAvvikActivityParams 

type LinkAvvikActivityParams struct {
	AvvikID    uuid.UUID `json:"avvik_id"`
	ActivityID uuid.UUID `json:"activity_id"`
}

type LinkAvvikMeasureParams 

type LinkAvvikMeasureParams struct {
	AvvikID      uuid.UUID `json:"avvik_id"`
	MeasureID    uuid.UUID `json:"measure_id"`
	Relationship string    `json:"relationship"`
}

type LinkMeasureToRequirementParams 

type LinkMeasureToRequirementParams struct {
	MeasureID     uuid.UUID `json:"measure_id"`
	RequirementID uuid.UUID `json:"requirement_id"`
	Note          string    `json:"note"`
}

type LinkRiskToActivityParams 

type LinkRiskToActivityParams struct {
	RiskID     uuid.UUID `json:"risk_id"`
	ActivityID uuid.UUID `json:"activity_id"`
}

type LinkRiskToAssetParams 

type LinkRiskToAssetParams struct {
	RiskID  uuid.UUID `json:"risk_id"`
	AssetID uuid.UUID `json:"asset_id"`
}

type LinkRiskToMeasureParams 

type LinkRiskToMeasureParams struct {
	RiskID    uuid.UUID `json:"risk_id"`
	MeasureID uuid.UUID `json:"measure_id"`
	Note      string    `json:"note"`
}

type ListActiveSessionsByUserRow 

type ListActiveSessionsByUserRow struct {
	UserID       uuid.UUID `json:"user_id"`
	Name         string    `json:"name"`
	Email        string    `json:"email"`
	Role         string    `json:"role"`
	SessionCount int64     `json:"session_count"`
	ExpiresAt    time.Time `json:"expires_at"`
}

type ListActivitiesForMeasureRow 

type ListActivitiesForMeasureRow struct {
	ID           uuid.UUID    `json:"id"`
	Title        string       `json:"title"`
	Status       string       `json:"status"`
	Priority     string       `json:"priority"`
	Kind         string       `json:"kind"`
	DueDate      sql.NullTime `json:"due_date"`
	ActivityType string       `json:"activity_type"`
	Recurrence   string       `json:"recurrence"`
}

type ListActivitiesForUserRow 

type ListActivitiesForUserRow struct {
	ID          uuid.UUID    `json:"id"`
	Title       string       `json:"title"`
	Status      string       `json:"status"`
	Priority    string       `json:"priority"`
	Kind        string       `json:"kind"`
	DueDate     sql.NullTime `json:"due_date"`
	UpdatedAt   time.Time    `json:"updated_at"`
	MeasureName string       `json:"measure_name"`
}

type ListActivitiesRow 

type ListActivitiesRow struct {
	ID               uuid.UUID     `json:"id"`
	MeasureID        uuid.NullUUID `json:"measure_id"`
	Title            string        `json:"title"`
	Description      string        `json:"description"`
	ActivityType     string        `json:"activity_type"`
	Recurrence       string        `json:"recurrence"`
	Status           string        `json:"status"`
	Priority         string        `json:"priority"`
	Kind             string        `json:"kind"`
	Owner            string        `json:"owner"`
	AssigneeID       uuid.NullUUID `json:"assignee_id"`
	DueDate          sql.NullTime  `json:"due_date"`
	CompletedAt      sql.NullTime  `json:"completed_at"`
	CompletedBy      string        `json:"completed_by"`
	Notes            string        `json:"notes"`
	EvidenceUrl      string        `json:"evidence_url"`
	ParentActivityID uuid.NullUUID `json:"parent_activity_id"`
	CreatedAt        time.Time     `json:"created_at"`
	UpdatedAt        time.Time     `json:"updated_at"`
	RefNum           sql.NullInt32 `json:"ref_num"`
	MeasureName      string        `json:"measure_name"`
}

type ListAllRequirementsRow 

type ListAllRequirementsRow struct {
	ID                 uuid.UUID `json:"id"`
	FrameworkID        uuid.UUID `json:"framework_id"`
	Ref                string    `json:"ref"`
	Title              string    `json:"title"`
	Description        string    `json:"description"`
	SortOrder          int32     `json:"sort_order"`
	CreatedAt          time.Time `json:"created_at"`
	UpdatedAt          time.Time `json:"updated_at"`
	FrameworkName      string    `json:"framework_name"`
	FrameworkShortName string    `json:"framework_short_name"`
}

type ListAllRisksForUserRow 

type ListAllRisksForUserRow struct {
	ID                   uuid.UUID     `json:"id"`
	AssessmentID         uuid.UUID     `json:"assessment_id"`
	Name                 string        `json:"name"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodTarget     sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget    sql.NullInt32 `json:"consequence_target"`
	RiskDecision         string        `json:"risk_decision"`
	Status               string        `json:"status"`
	CreatedAt            time.Time     `json:"created_at"`
	UpdatedAt            time.Time     `json:"updated_at"`
	Description          string        `json:"description"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
	OwnerID              uuid.NullUUID `json:"owner_id"`
	DecisionNotes        string        `json:"decision_notes"`
	RefNum               sql.NullInt32 `json:"ref_num"`
	ReviewNeeded         bool          `json:"review_needed"`
	ReviewDue            sql.NullTime  `json:"review_due"`
	AssessedAt           sql.NullTime  `json:"assessed_at"`
	AssessedBy           uuid.NullUUID `json:"assessed_by"`
	AssessmentRationale  string        `json:"assessment_rationale"`
	AssessmentName       string        `json:"assessment_name"`
	AssessmentRefNum     sql.NullInt32 `json:"assessment_ref_num"`
}

type ListAllRisksRow 

type ListAllRisksRow struct {
	ID                   uuid.UUID     `json:"id"`
	AssessmentID         uuid.UUID     `json:"assessment_id"`
	Name                 string        `json:"name"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodTarget     sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget    sql.NullInt32 `json:"consequence_target"`
	RiskDecision         string        `json:"risk_decision"`
	Status               string        `json:"status"`
	CreatedAt            time.Time     `json:"created_at"`
	UpdatedAt            time.Time     `json:"updated_at"`
	Description          string        `json:"description"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
	OwnerID              uuid.NullUUID `json:"owner_id"`
	DecisionNotes        string        `json:"decision_notes"`
	RefNum               sql.NullInt32 `json:"ref_num"`
	ReviewNeeded         bool          `json:"review_needed"`
	ReviewDue            sql.NullTime  `json:"review_due"`
	AssessedAt           sql.NullTime  `json:"assessed_at"`
	AssessedBy           uuid.NullUUID `json:"assessed_by"`
	AssessmentRationale  string        `json:"assessment_rationale"`
	AssessmentName       string        `json:"assessment_name"`
	AssessmentRefNum     sql.NullInt32 `json:"assessment_ref_num"`
}

type ListAssetsParams 

type ListAssetsParams struct {
	Q          interface{} `json:"q"`
	Status     interface{} `json:"status"`
	PageOffset int32       `json:"page_offset"`
	PageSize   int32       `json:"page_size"`
}

type ListAuditLogAdminRow 

type ListAuditLogAdminRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForActivityRow 

type ListAuditLogForActivityRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForAssessmentRow 

type ListAuditLogForAssessmentRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForAssetRow 

type ListAuditLogForAssetRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForFrameworkRow 

type ListAuditLogForFrameworkRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForMeasureRow 

type ListAuditLogForMeasureRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForRequirementRow 

type ListAuditLogForRequirementRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAuditLogForRiskRow 

type ListAuditLogForRiskRow struct {
	EventTime time.Time       `json:"event_time"`
	Event     string          `json:"event"`
	UserName  string          `json:"user_name"`
	Attrs     json.RawMessage `json:"attrs"`
}

type ListAvvikParams 

type ListAvvikParams struct {
	Status          sql.NullString `json:"status"`
	RiskLevel       sql.NullString `json:"risk_level"`
	PersonalData    sql.NullBool   `json:"personal_data"`
	Ksi             sql.NullBool   `json:"ksi"`
	MarketSensitive sql.NullBool   `json:"market_sensitive"`
	OrgUnitID       uuid.NullUUID  `json:"org_unit_id"`
	Mine            bool           `json:"mine"`
	AssigneeID      uuid.UUID      `json:"assignee_id"`
	PageOffset      int32          `json:"page_offset"`
	PageSize        int32          `json:"page_size"`
}

type ListMeasureFrameworkLinksRow 

type ListMeasureFrameworkLinksRow struct {
	MeasureID          uuid.UUID `json:"measure_id"`
	FrameworkShortName string    `json:"framework_short_name"`
}

type ListMeasuresForRequirementRow 

type ListMeasuresForRequirementRow struct {
	ID       uuid.UUID `json:"id"`
	Name     string    `json:"name"`
	Category string    `json:"category"`
	Status   string    `json:"status"`
	Owner    string    `json:"owner"`
}

type ListOwnedActivitiesRow 

type ListOwnedActivitiesRow struct {
	ID          uuid.UUID `json:"id"`
	Title       string    `json:"title"`
	Status      string    `json:"status"`
	Priority    string    `json:"priority"`
	Kind        string    `json:"kind"`
	DueDate     string    `json:"due_date"`
	UpdatedAt   string    `json:"updated_at"`
	MeasureName string    `json:"measure_name"`
}

type ListOwnedMeasuresRow 

type ListOwnedMeasuresRow struct {
	ID        uuid.UUID `json:"id"`
	Name      string    `json:"name"`
	Status    string    `json:"status"`
	UpdatedAt string    `json:"updated_at"`
}

type ListOwnedRisksRow 

type ListOwnedRisksRow struct {
	ID                 uuid.UUID `json:"id"`
	AssessmentID       uuid.UUID `json:"assessment_id"`
	Name               string    `json:"name"`
	LikelihoodCurrent  int32     `json:"likelihood_current"`
	ConsequenceCurrent int32     `json:"consequence_current"`
	UpdatedAt          string    `json:"updated_at"`
	AssessmentName     string    `json:"assessment_name"`
	AssessmentRefNum   int32     `json:"assessment_ref_num"`
}

type ListRecentActivitiesRow 

type ListRecentActivitiesRow struct {
	ID          uuid.UUID    `json:"id"`
	Title       string       `json:"title"`
	Status      string       `json:"status"`
	Owner       string       `json:"owner"`
	Priority    string       `json:"priority"`
	CompletedAt sql.NullTime `json:"completed_at"`
	DueDate     sql.NullTime `json:"due_date"`
	UpdatedAt   time.Time    `json:"updated_at"`
	MeasureName string       `json:"measure_name"`
}

type ListRequirementsForMeasureRow 

type ListRequirementsForMeasureRow struct {
	ID                 uuid.UUID `json:"id"`
	FrameworkID        uuid.UUID `json:"framework_id"`
	Ref                string    `json:"ref"`
	Title              string    `json:"title"`
	Description        string    `json:"description"`
	SortOrder          int32     `json:"sort_order"`
	CreatedAt          time.Time `json:"created_at"`
	UpdatedAt          time.Time `json:"updated_at"`
	FrameworkName      string    `json:"framework_name"`
	FrameworkShortName string    `json:"framework_short_name"`
}

type ListRiskReassessmentEventsParams 

type ListRiskReassessmentEventsParams struct {
	RiskID  uuid.UUID    `json:"risk_id"`
	SinceAt sql.NullTime `json:"since_at"`
}

type ListRiskReassessmentEventsRow 

type ListRiskReassessmentEventsRow struct {
	ID            uuid.UUID     `json:"id"`
	RiskID        uuid.UUID     `json:"risk_id"`
	MeasureID     uuid.UUID     `json:"measure_id"`
	TriggerStatus string        `json:"trigger_status"`
	TriggeredAt   time.Time     `json:"triggered_at"`
	TriggeredBy   uuid.NullUUID `json:"triggered_by"`
	Note          string        `json:"note"`
	MeasureName   string        `json:"measure_name"`
	MeasureRefNum sql.NullInt32 `json:"measure_ref_num"`
}

type ListRiskReviewQueueForUserRow 

type ListRiskReviewQueueForUserRow struct {
	ID                   uuid.UUID     `json:"id"`
	AssessmentID         uuid.UUID     `json:"assessment_id"`
	Name                 string        `json:"name"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodTarget     sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget    sql.NullInt32 `json:"consequence_target"`
	RiskDecision         string        `json:"risk_decision"`
	Status               string        `json:"status"`
	CreatedAt            time.Time     `json:"created_at"`
	UpdatedAt            time.Time     `json:"updated_at"`
	Description          string        `json:"description"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
	OwnerID              uuid.NullUUID `json:"owner_id"`
	DecisionNotes        string        `json:"decision_notes"`
	RefNum               sql.NullInt32 `json:"ref_num"`
	ReviewNeeded         bool          `json:"review_needed"`
	ReviewDue            sql.NullTime  `json:"review_due"`
	AssessedAt           sql.NullTime  `json:"assessed_at"`
	AssessedBy           uuid.NullUUID `json:"assessed_by"`
	AssessmentRationale  string        `json:"assessment_rationale"`
	AssessmentName       string        `json:"assessment_name"`
	AssessmentRefNum     sql.NullInt32 `json:"assessment_ref_num"`
}

type ListRiskReviewQueueRow 

type ListRiskReviewQueueRow struct {
	ID                   uuid.UUID     `json:"id"`
	AssessmentID         uuid.UUID     `json:"assessment_id"`
	Name                 string        `json:"name"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodTarget     sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget    sql.NullInt32 `json:"consequence_target"`
	RiskDecision         string        `json:"risk_decision"`
	Status               string        `json:"status"`
	CreatedAt            time.Time     `json:"created_at"`
	UpdatedAt            time.Time     `json:"updated_at"`
	Description          string        `json:"description"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
	OwnerID              uuid.NullUUID `json:"owner_id"`
	DecisionNotes        string        `json:"decision_notes"`
	RefNum               sql.NullInt32 `json:"ref_num"`
	ReviewNeeded         bool          `json:"review_needed"`
	ReviewDue            sql.NullTime  `json:"review_due"`
	AssessedAt           sql.NullTime  `json:"assessed_at"`
	AssessedBy           uuid.NullUUID `json:"assessed_by"`
	AssessmentRationale  string        `json:"assessment_rationale"`
	AssessmentName       string        `json:"assessment_name"`
	AssessmentRefNum     sql.NullInt32 `json:"assessment_ref_num"`
}

type ListTopRisksRow 

type ListTopRisksRow struct {
	ID                   uuid.UUID     `json:"id"`
	AssessmentID         uuid.UUID     `json:"assessment_id"`
	Name                 string        `json:"name"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodTarget     sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget    sql.NullInt32 `json:"consequence_target"`
	RiskDecision         string        `json:"risk_decision"`
	Status               string        `json:"status"`
	CreatedAt            time.Time     `json:"created_at"`
	UpdatedAt            time.Time     `json:"updated_at"`
	Description          string        `json:"description"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
	OwnerID              uuid.NullUUID `json:"owner_id"`
	DecisionNotes        string        `json:"decision_notes"`
	RefNum               sql.NullInt32 `json:"ref_num"`
	ReviewNeeded         bool          `json:"review_needed"`
	ReviewDue            sql.NullTime  `json:"review_due"`
	AssessedAt           sql.NullTime  `json:"assessed_at"`
	AssessedBy           uuid.NullUUID `json:"assessed_by"`
	AssessmentRationale  string        `json:"assessment_rationale"`
	AssessmentName       string        `json:"assessment_name"`
}

type Measure 

type Measure struct {
	ID             uuid.UUID     `json:"id"`
	Name           string        `json:"name"`
	Description    string        `json:"description"`
	Category       string        `json:"category"`
	Owner          string        `json:"owner"`
	Status         string        `json:"status"`
	CreatedAt      time.Time     `json:"created_at"`
	UpdatedAt      time.Time     `json:"updated_at"`
	LastVerifiedAt sql.NullTime  `json:"last_verified_at"`
	AssigneeID     uuid.NullUUID `json:"assignee_id"`
	RefNum         sql.NullInt32 `json:"ref_num"`
}
type MeasureLink struct {
	ID        uuid.UUID `json:"id"`
	MeasureID uuid.UUID `json:"measure_id"`
	Url       string    `json:"url"`
	Label     string    `json:"label"`
	CreatedAt time.Time `json:"created_at"`
}

type MeasureRequirement 

type MeasureRequirement struct {
	MeasureID     uuid.UUID `json:"measure_id"`
	RequirementID uuid.UUID `json:"requirement_id"`
	Note          string    `json:"note"`
	CreatedAt     time.Time `json:"created_at"`
}

type Organization 

type Organization struct {
	ID        uuid.UUID      `json:"id"`
	Name      string         `json:"name"`
	ParentID  uuid.NullUUID  `json:"parent_id"`
	CreatedAt time.Time      `json:"created_at"`
	UpdatedAt time.Time      `json:"updated_at"`
	Key       sql.NullString `json:"key"`
}

type PreCreateUserParams 

type PreCreateUserParams struct {
	ProviderID string `json:"provider_id"`
	Name       string `json:"name"`
	Role       string `json:"role"`
}

type Querier 

type Querier interface {
	AcceptAssessment(ctx context.Context, id uuid.UUID) (RiskAssessment, error)
	AddAssessmentParticipant(ctx context.Context, arg AddAssessmentParticipantParams) error
	AddAssetToAssessment(ctx context.Context, arg AddAssetToAssessmentParams) error
	AddAvvikAttachment(ctx context.Context, arg AddAvvikAttachmentParams) (AvvikAttachment, error)
	AddAvvikEvent(ctx context.Context, arg AddAvvikEventParams) (AvvikEvent, error)
	AddAvvikNotification(ctx context.Context, arg AddAvvikNotificationParams) (AvvikNotification, error)
	AddMeasureLink(ctx context.Context, arg AddMeasureLinkParams) (MeasureLink, error)
	AddParticipant(ctx context.Context, arg AddParticipantParams) error
	ClaimPendingUser(ctx context.Context, arg ClaimPendingUserParams) (User, error)
	ClearAssessmentParticipants(ctx context.Context, assessmentID uuid.UUID) error
	ClearRiskAssets(ctx context.Context, riskID uuid.UUID) error
	CompleteActivity(ctx context.Context, arg CompleteActivityParams) (Activity, error)
	CountCoveredRequirementsByFramework(ctx context.Context, frameworkID uuid.UUID) (int64, error)
	CountRequirementsByFramework(ctx context.Context, frameworkID uuid.UUID) (int64, error)
	CountRisksForMatrix(ctx context.Context) ([]CountRisksForMatrixRow, error)
	CreateActivity(ctx context.Context, arg CreateActivityParams) (Activity, error)
	CreateAsset(ctx context.Context, arg CreateAssetParams) (Asset, error)
	CreateAvvik(ctx context.Context, arg CreateAvvikParams) (Avvik, error)
	CreateFramework(ctx context.Context, arg CreateFrameworkParams) (Framework, error)
	CreateMeasure(ctx context.Context, arg CreateMeasureParams) (Measure, error)
	CreateOrganization(ctx context.Context, arg CreateOrganizationParams) (Organization, error)
	CreateRequirement(ctx context.Context, arg CreateRequirementParams) (Requirement, error)
	CreateRisk(ctx context.Context, arg CreateRiskParams) (Risk, error)
	CreateRiskAssessment(ctx context.Context, arg CreateRiskAssessmentParams) (RiskAssessment, error)
	CreateRiskReassessmentEvent(ctx context.Context, arg CreateRiskReassessmentEventParams) error
	DeclineAssessment(ctx context.Context, arg DeclineAssessmentParams) (RiskAssessment, error)
	DeleteActivity(ctx context.Context, id uuid.UUID) error
	DeleteAsset(ctx context.Context, id uuid.UUID) error
	DeleteFramework(ctx context.Context, id uuid.UUID) error
	DeleteMeasure(ctx context.Context, id uuid.UUID) error
	DeleteMeasureLink(ctx context.Context, arg DeleteMeasureLinkParams) error
	DeleteOrganization(ctx context.Context, id uuid.UUID) error
	DeleteRequirement(ctx context.Context, id uuid.UUID) error
	DeleteRisk(ctx context.Context, id uuid.UUID) error
	DeleteRiskAssessment(ctx context.Context, id uuid.UUID) error
	DeleteSessionsByUserID(ctx context.Context, userID uuid.NullUUID) error
	DeleteUser(ctx context.Context, id uuid.UUID) error
	FilterActivities(ctx context.Context, arg FilterActivitiesParams) ([]FilterActivitiesRow, error)
	FilterMeasures(ctx context.Context, arg FilterMeasuresParams) ([]Measure, error)
	FlagRiskForReview(ctx context.Context, id uuid.UUID) error
	GetActivity(ctx context.Context, id uuid.UUID) (GetActivityRow, error)
	GetAppSettings(ctx context.Context) (AppSetting, error)
	GetAsset(ctx context.Context, id uuid.UUID) (Asset, error)
	GetAvvik(ctx context.Context, id uuid.UUID) (Avvik, error)
	GetDashboardStats(ctx context.Context) (GetDashboardStatsRow, error)
	GetFramework(ctx context.Context, id uuid.UUID) (Framework, error)
	GetMeasure(ctx context.Context, id uuid.UUID) (Measure, error)
	GetOrganization(ctx context.Context, id uuid.UUID) (Organization, error)
	GetRequirement(ctx context.Context, id uuid.UUID) (Requirement, error)
	GetRisk(ctx context.Context, id uuid.UUID) (Risk, error)
	GetRiskAssessment(ctx context.Context, id uuid.UUID) (RiskAssessment, error)
	GetRiskGlobalSettings(ctx context.Context) (RiskGlobalSetting, error)
	GetRiskStats(ctx context.Context) (GetRiskStatsRow, error)
	GetUserByEmail(ctx context.Context, email string) (User, error)
	GetUserByID(ctx context.Context, id uuid.UUID) (User, error)
	InsertAuditLog(ctx context.Context, arg InsertAuditLogParams) error
	IsParticipant(ctx context.Context, arg IsParticipantParams) (bool, error)
	IsRiskAssessmentAccessible(ctx context.Context, arg IsRiskAssessmentAccessibleParams) (bool, error)
	IsRiskAssessmentParticipant(ctx context.Context, arg IsRiskAssessmentParticipantParams) (bool, error)
	LinkAvvikActivity(ctx context.Context, arg LinkAvvikActivityParams) error
	LinkAvvikMeasure(ctx context.Context, arg LinkAvvikMeasureParams) error
	LinkMeasureToRequirement(ctx context.Context, arg LinkMeasureToRequirementParams) error
	LinkRiskToActivity(ctx context.Context, arg LinkRiskToActivityParams) error
	LinkRiskToAsset(ctx context.Context, arg LinkRiskToAssetParams) error
	LinkRiskToMeasure(ctx context.Context, arg LinkRiskToMeasureParams) error
	ListActiveSessionsByUser(ctx context.Context) ([]ListActiveSessionsByUserRow, error)
	ListActivities(ctx context.Context) ([]ListActivitiesRow, error)
	ListActivitiesForMeasure(ctx context.Context, measureID uuid.NullUUID) ([]ListActivitiesForMeasureRow, error)
	ListActivitiesForRisk(ctx context.Context, riskID uuid.UUID) ([]Activity, error)
	ListActivitiesForUser(ctx context.Context, assigneeID uuid.NullUUID) ([]ListActivitiesForUserRow, error)
	ListAllRequirements(ctx context.Context) ([]ListAllRequirementsRow, error)
	ListAllRisks(ctx context.Context) ([]ListAllRisksRow, error)
	ListAllRisksForUser(ctx context.Context, dollar_1 uuid.UUID) ([]ListAllRisksForUserRow, error)
	ListAssets(ctx context.Context, arg ListAssetsParams) ([]Asset, error)
	ListAssetsForAssessment(ctx context.Context, assessmentID uuid.UUID) ([]Asset, error)
	ListAssetsForRisk(ctx context.Context, riskID uuid.UUID) ([]Asset, error)
	ListAuditLogAdmin(ctx context.Context) ([]ListAuditLogAdminRow, error)
	ListAuditLogForActivity(ctx context.Context, dollar_1 string) ([]ListAuditLogForActivityRow, error)
	ListAuditLogForAssessment(ctx context.Context, dollar_1 string) ([]ListAuditLogForAssessmentRow, error)
	ListAuditLogForAsset(ctx context.Context, dollar_1 string) ([]ListAuditLogForAssetRow, error)
	ListAuditLogForFramework(ctx context.Context, dollar_1 string) ([]ListAuditLogForFrameworkRow, error)
	ListAuditLogForMeasure(ctx context.Context, dollar_1 string) ([]ListAuditLogForMeasureRow, error)
	ListAuditLogForRequirement(ctx context.Context, dollar_1 string) ([]ListAuditLogForRequirementRow, error)
	ListAuditLogForRisk(ctx context.Context, dollar_1 string) ([]ListAuditLogForRiskRow, error)
	ListAvvik(ctx context.Context, arg ListAvvikParams) ([]Avvik, error)
	ListAvvikActivities(ctx context.Context, avvikID uuid.UUID) ([]Activity, error)
	ListAvvikAttachments(ctx context.Context, avvikID uuid.UUID) ([]AvvikAttachment, error)
	ListAvvikEvents(ctx context.Context, avvikID uuid.UUID) ([]AvvikEvent, error)
	ListAvvikMeasures(ctx context.Context, avvikID uuid.UUID) ([]Measure, error)
	ListAvvikNotifications(ctx context.Context, avvikID uuid.UUID) ([]AvvikNotification, error)
	ListDevStubUsers(ctx context.Context) ([]User, error)
	ListFrameworks(ctx context.Context) ([]Framework, error)
	// Returns one row per (measure, framework) pair — used to build the framework
	// badge list shown next to each measure in the list view.
	ListMeasureFrameworkLinks(ctx context.Context) ([]ListMeasureFrameworkLinksRow, error)
	ListMeasureLinks(ctx context.Context, measureID uuid.UUID) ([]MeasureLink, error)
	ListMeasureRiskLinkIDs(ctx context.Context) ([]uuid.UUID, error)
	ListMeasures(ctx context.Context) ([]Measure, error)
	ListMeasuresForRequirement(ctx context.Context, requirementID uuid.UUID) ([]ListMeasuresForRequirementRow, error)
	ListMeasuresForRisk(ctx context.Context, riskID uuid.UUID) ([]Measure, error)
	ListMeasuresForUser(ctx context.Context, assigneeID uuid.NullUUID) ([]Measure, error)
	ListOrganizations(ctx context.Context) ([]Organization, error)
	ListOwnedActivities(ctx context.Context, assigneeID uuid.NullUUID) ([]ListOwnedActivitiesRow, error)
	ListOwnedMeasures(ctx context.Context, assigneeID uuid.NullUUID) ([]ListOwnedMeasuresRow, error)
	ListOwnedRisks(ctx context.Context, ownerID uuid.NullUUID) ([]ListOwnedRisksRow, error)
	ListParticipantsForAssessment(ctx context.Context, assessmentID uuid.UUID) ([]User, error)
	ListRecentActivities(ctx context.Context) ([]ListRecentActivitiesRow, error)
	ListRequirementsByFramework(ctx context.Context, frameworkID uuid.UUID) ([]Requirement, error)
	ListRequirementsForMeasure(ctx context.Context, measureID uuid.UUID) ([]ListRequirementsForMeasureRow, error)
	ListRiskAssessments(ctx context.Context) ([]RiskAssessment, error)
	ListRiskAssessmentsForUser(ctx context.Context, riskOwnerID uuid.NullUUID) ([]RiskAssessment, error)
	ListRiskReassessmentEvents(ctx context.Context, arg ListRiskReassessmentEventsParams) ([]ListRiskReassessmentEventsRow, error)
	ListRiskReviewQueue(ctx context.Context) ([]ListRiskReviewQueueRow, error)
	ListRiskReviewQueueForUser(ctx context.Context, dollar_1 uuid.UUID) ([]ListRiskReviewQueueForUserRow, error)
	ListRiskScaleLabels(ctx context.Context) ([]RiskScaleLabel, error)
	ListRisksForActivity(ctx context.Context, activityID uuid.UUID) ([]Risk, error)
	ListRisksForAssessment(ctx context.Context, assessmentID uuid.UUID) ([]Risk, error)
	ListRisksForMeasure(ctx context.Context, measureID uuid.UUID) ([]Risk, error)
	ListTopRisks(ctx context.Context) ([]ListTopRisksRow, error)
	ListUsers(ctx context.Context) ([]User, error)
	MarkActivityInProgress(ctx context.Context, id uuid.UUID) (Activity, error)
	MarkOverdueActivities(ctx context.Context) error
	PreCreateUser(ctx context.Context, arg PreCreateUserParams) (User, error)
	ReassessRiskCurrentScores(ctx context.Context, arg ReassessRiskCurrentScoresParams) (Risk, error)
	RemoveAssessmentParticipant(ctx context.Context, arg RemoveAssessmentParticipantParams) error
	RemoveAssetFromAssessment(ctx context.Context, arg RemoveAssetFromAssessmentParams) error
	ReopenActivity(ctx context.Context, id uuid.UUID) (Activity, error)
	SearchActivities(ctx context.Context, title string) ([]Activity, error)
	SearchAssetsForRisk(ctx context.Context, arg SearchAssetsForRiskParams) ([]Asset, error)
	SearchAssetsToLink(ctx context.Context, arg SearchAssetsToLinkParams) ([]Asset, error)
	SearchMeasures(ctx context.Context, name string) ([]Measure, error)
	SetUserOrg(ctx context.Context, arg SetUserOrgParams) (User, error)
	SetUserRole(ctx context.Context, arg SetUserRoleParams) (User, error)
	ToggleRiskAssessmentPublic(ctx context.Context, id uuid.UUID) (RiskAssessment, error)
	UnlinkAvvikActivity(ctx context.Context, arg UnlinkAvvikActivityParams) error
	UnlinkAvvikMeasure(ctx context.Context, arg UnlinkAvvikMeasureParams) error
	UnlinkMeasureFromRequirement(ctx context.Context, arg UnlinkMeasureFromRequirementParams) error
	UnlinkRiskFromActivity(ctx context.Context, arg UnlinkRiskFromActivityParams) error
	UnlinkRiskFromAsset(ctx context.Context, arg UnlinkRiskFromAssetParams) error
	UnlinkRiskFromMeasure(ctx context.Context, arg UnlinkRiskFromMeasureParams) error
	UpdateActivity(ctx context.Context, arg UpdateActivityParams) (Activity, error)
	UpdateAppSettings(ctx context.Context, arg UpdateAppSettingsParams) error
	UpdateAsset(ctx context.Context, arg UpdateAssetParams) (Asset, error)
	UpdateAvvikClosureFlags(ctx context.Context, arg UpdateAvvikClosureFlagsParams) (Avvik, error)
	UpdateAvvikStatus(ctx context.Context, arg UpdateAvvikStatusParams) (Avvik, error)
	UpdateAvvikTriage(ctx context.Context, arg UpdateAvvikTriageParams) (Avvik, error)
	UpdateFramework(ctx context.Context, arg UpdateFrameworkParams) (Framework, error)
	UpdateMeasure(ctx context.Context, arg UpdateMeasureParams) (Measure, error)
	UpdateMeasureLastVerified(ctx context.Context, id uuid.UUID) error
	UpdateRequirement(ctx context.Context, arg UpdateRequirementParams) (Requirement, error)
	UpdateRiskAssessmentReviewed(ctx context.Context, id uuid.UUID) error
	UpdateRiskAssessmentStep(ctx context.Context, arg UpdateRiskAssessmentStepParams) error
	UpdateRiskAssessmentStep1(ctx context.Context, arg UpdateRiskAssessmentStep1Params) (RiskAssessment, error)
	UpdateRiskAssessmentThreatStep(ctx context.Context, arg UpdateRiskAssessmentThreatStepParams) (RiskAssessment, error)
	UpdateRiskCurrentScores(ctx context.Context, arg UpdateRiskCurrentScoresParams) (Risk, error)
	UpdateRiskDecision(ctx context.Context, arg UpdateRiskDecisionParams) error
	UpdateRiskGlobalSettings(ctx context.Context, arg UpdateRiskGlobalSettingsParams) error
	UpdateRiskIdentification(ctx context.Context, arg UpdateRiskIdentificationParams) (Risk, error)
	UpdateRiskTargetScore(ctx context.Context, arg UpdateRiskTargetScoreParams) error
	UpsertDevStubUser(ctx context.Context, arg UpsertDevStubUserParams) (User, error)
	UpsertRiskScaleLabel(ctx context.Context, arg UpsertRiskScaleLabelParams) error
	UpsertUser(ctx context.Context, arg UpsertUserParams) (User, error)
}

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) AcceptAssessment 

func (q *Queries) AcceptAssessment(ctx context.Context, id uuid.UUID) (RiskAssessment, error)

func (*Queries) AddAssessmentParticipant 

func (q *Queries) AddAssessmentParticipant(ctx context.Context, arg AddAssessmentParticipantParams) error

func (*Queries) AddAssetToAssessment 

func (q *Queries) AddAssetToAssessment(ctx context.Context, arg AddAssetToAssessmentParams) error

func (*Queries) AddAvvikAttachment 

func (q *Queries) AddAvvikAttachment(ctx context.Context, arg AddAvvikAttachmentParams) (AvvikAttachment, error)

func (*Queries) AddAvvikEvent 

func (q *Queries) AddAvvikEvent(ctx context.Context, arg AddAvvikEventParams) (AvvikEvent, error)

func (*Queries) AddAvvikNotification 

func (q *Queries) AddAvvikNotification(ctx context.Context, arg AddAvvikNotificationParams) (AvvikNotification, error)
func (q *Queries) AddMeasureLink(ctx context.Context, arg AddMeasureLinkParams) (MeasureLink, error)

func (*Queries) AddParticipant 

func (q *Queries) AddParticipant(ctx context.Context, arg AddParticipantParams) error

func (*Queries) ClaimPendingUser 

func (q *Queries) ClaimPendingUser(ctx context.Context, arg ClaimPendingUserParams) (User, error)

func (*Queries) ClearAssessmentParticipants 

func (q *Queries) ClearAssessmentParticipants(ctx context.Context, assessmentID uuid.UUID) error

func (*Queries) ClearRiskAssets 

func (q *Queries) ClearRiskAssets(ctx context.Context, riskID uuid.UUID) error

func (*Queries) CompleteActivity 

func (q *Queries) CompleteActivity(ctx context.Context, arg CompleteActivityParams) (Activity, error)

func (*Queries) CountCoveredRequirementsByFramework 

func (q *Queries) CountCoveredRequirementsByFramework(ctx context.Context, frameworkID uuid.UUID) (int64, error)

func (*Queries) CountRequirementsByFramework 

func (q *Queries) CountRequirementsByFramework(ctx context.Context, frameworkID uuid.UUID) (int64, error)

func (*Queries) CountRisksForMatrix 

func (q *Queries) CountRisksForMatrix(ctx context.Context) ([]CountRisksForMatrixRow, error)

func (*Queries) CreateActivity 

func (q *Queries) CreateActivity(ctx context.Context, arg CreateActivityParams) (Activity, error)

func (*Queries) CreateAsset 

func (q *Queries) CreateAsset(ctx context.Context, arg CreateAssetParams) (Asset, error)

func (*Queries) CreateAvvik 

func (q *Queries) CreateAvvik(ctx context.Context, arg CreateAvvikParams) (Avvik, error)

func (*Queries) CreateFramework 

func (q *Queries) CreateFramework(ctx context.Context, arg CreateFrameworkParams) (Framework, error)

func (*Queries) CreateMeasure 

func (q *Queries) CreateMeasure(ctx context.Context, arg CreateMeasureParams) (Measure, error)

func (*Queries) CreateOrganization 

func (q *Queries) CreateOrganization(ctx context.Context, arg CreateOrganizationParams) (Organization, error)

func (*Queries) CreateRequirement 

func (q *Queries) CreateRequirement(ctx context.Context, arg CreateRequirementParams) (Requirement, error)

func (*Queries) CreateRisk 

func (q *Queries) CreateRisk(ctx context.Context, arg CreateRiskParams) (Risk, error)

func (*Queries) CreateRiskAssessment 

func (q *Queries) CreateRiskAssessment(ctx context.Context, arg CreateRiskAssessmentParams) (RiskAssessment, error)

func (*Queries) CreateRiskReassessmentEvent 

func (q *Queries) CreateRiskReassessmentEvent(ctx context.Context, arg CreateRiskReassessmentEventParams) error

func (*Queries) DeclineAssessment 

func (q *Queries) DeclineAssessment(ctx context.Context, arg DeclineAssessmentParams) (RiskAssessment, error)

func (*Queries) DeleteActivity 

func (q *Queries) DeleteActivity(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteAsset 

func (q *Queries) DeleteAsset(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteFramework 

func (q *Queries) DeleteFramework(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteMeasure 

func (q *Queries) DeleteMeasure(ctx context.Context, id uuid.UUID) error
func (q *Queries) DeleteMeasureLink(ctx context.Context, arg DeleteMeasureLinkParams) error

func (*Queries) DeleteOrganization 

func (q *Queries) DeleteOrganization(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteRequirement 

func (q *Queries) DeleteRequirement(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteRisk 

func (q *Queries) DeleteRisk(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteRiskAssessment 

func (q *Queries) DeleteRiskAssessment(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteSessionsByUserID 

func (q *Queries) DeleteSessionsByUserID(ctx context.Context, userID uuid.NullUUID) error

func (*Queries) DeleteUser 

func (q *Queries) DeleteUser(ctx context.Context, id uuid.UUID) error

func (*Queries) FilterActivities 

func (q *Queries) FilterActivities(ctx context.Context, arg FilterActivitiesParams) ([]FilterActivitiesRow, error)

func (*Queries) FilterMeasures 

func (q *Queries) FilterMeasures(ctx context.Context, arg FilterMeasuresParams) ([]Measure, error)

func (*Queries) FlagRiskForReview 

func (q *Queries) FlagRiskForReview(ctx context.Context, id uuid.UUID) error

func (*Queries) GetActivity 

func (q *Queries) GetActivity(ctx context.Context, id uuid.UUID) (GetActivityRow, error)

func (*Queries) GetAppSettings 

func (q *Queries) GetAppSettings(ctx context.Context) (AppSetting, error)

func (*Queries) GetAsset 

func (q *Queries) GetAsset(ctx context.Context, id uuid.UUID) (Asset, error)

func (*Queries) GetAvvik 

func (q *Queries) GetAvvik(ctx context.Context, id uuid.UUID) (Avvik, error)

func (*Queries) GetDashboardStats 

func (q *Queries) GetDashboardStats(ctx context.Context) (GetDashboardStatsRow, error)

func (*Queries) GetFramework 

func (q *Queries) GetFramework(ctx context.Context, id uuid.UUID) (Framework, error)

func (*Queries) GetMeasure 

func (q *Queries) GetMeasure(ctx context.Context, id uuid.UUID) (Measure, error)

func (*Queries) GetOrganization 

func (q *Queries) GetOrganization(ctx context.Context, id uuid.UUID) (Organization, error)

func (*Queries) GetRequirement 

func (q *Queries) GetRequirement(ctx context.Context, id uuid.UUID) (Requirement, error)

func (*Queries) GetRisk 

func (q *Queries) GetRisk(ctx context.Context, id uuid.UUID) (Risk, error)

func (*Queries) GetRiskAssessment 

func (q *Queries) GetRiskAssessment(ctx context.Context, id uuid.UUID) (RiskAssessment, error)

func (*Queries) GetRiskGlobalSettings 

func (q *Queries) GetRiskGlobalSettings(ctx context.Context) (RiskGlobalSetting, error)

func (*Queries) GetRiskStats 

func (q *Queries) GetRiskStats(ctx context.Context) (GetRiskStatsRow, error)

func (*Queries) GetUserByEmail 

func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)

func (*Queries) GetUserByID 

func (q *Queries) GetUserByID(ctx context.Context, id uuid.UUID) (User, error)

func (*Queries) InsertAuditLog 

func (q *Queries) InsertAuditLog(ctx context.Context, arg InsertAuditLogParams) error

func (*Queries) IsParticipant 

func (q *Queries) IsParticipant(ctx context.Context, arg IsParticipantParams) (bool, error)

func (*Queries) IsRiskAssessmentAccessible 

func (q *Queries) IsRiskAssessmentAccessible(ctx context.Context, arg IsRiskAssessmentAccessibleParams) (bool, error)

func (*Queries) IsRiskAssessmentParticipant 

func (q *Queries) IsRiskAssessmentParticipant(ctx context.Context, arg IsRiskAssessmentParticipantParams) (bool, error)

func (*Queries) LinkAvvikActivity 

func (q *Queries) LinkAvvikActivity(ctx context.Context, arg LinkAvvikActivityParams) error

func (*Queries) LinkAvvikMeasure 

func (q *Queries) LinkAvvikMeasure(ctx context.Context, arg LinkAvvikMeasureParams) error

func (*Queries) LinkMeasureToRequirement 

func (q *Queries) LinkMeasureToRequirement(ctx context.Context, arg LinkMeasureToRequirementParams) error

func (*Queries) LinkRiskToActivity 

func (q *Queries) LinkRiskToActivity(ctx context.Context, arg LinkRiskToActivityParams) error

func (*Queries) LinkRiskToAsset 

func (q *Queries) LinkRiskToAsset(ctx context.Context, arg LinkRiskToAssetParams) error

func (*Queries) LinkRiskToMeasure 

func (q *Queries) LinkRiskToMeasure(ctx context.Context, arg LinkRiskToMeasureParams) error

func (*Queries) ListActiveSessionsByUser 

func (q *Queries) ListActiveSessionsByUser(ctx context.Context) ([]ListActiveSessionsByUserRow, error)

func (*Queries) ListActivities 

func (q *Queries) ListActivities(ctx context.Context) ([]ListActivitiesRow, error)

func (*Queries) ListActivitiesForMeasure 

func (q *Queries) ListActivitiesForMeasure(ctx context.Context, measureID uuid.NullUUID) ([]ListActivitiesForMeasureRow, error)

func (*Queries) ListActivitiesForRisk 

func (q *Queries) ListActivitiesForRisk(ctx context.Context, riskID uuid.UUID) ([]Activity, error)

func (*Queries) ListActivitiesForUser 

func (q *Queries) ListActivitiesForUser(ctx context.Context, assigneeID uuid.NullUUID) ([]ListActivitiesForUserRow, error)

func (*Queries) ListAllRequirements 

func (q *Queries) ListAllRequirements(ctx context.Context) ([]ListAllRequirementsRow, error)

func (*Queries) ListAllRisks 

func (q *Queries) ListAllRisks(ctx context.Context) ([]ListAllRisksRow, error)

func (*Queries) ListAllRisksForUser 

func (q *Queries) ListAllRisksForUser(ctx context.Context, dollar_1 uuid.UUID) ([]ListAllRisksForUserRow, error)

func (*Queries) ListAssets 

func (q *Queries) ListAssets(ctx context.Context, arg ListAssetsParams) ([]Asset, error)

func (*Queries) ListAssetsForAssessment 

func (q *Queries) ListAssetsForAssessment(ctx context.Context, assessmentID uuid.UUID) ([]Asset, error)

func (*Queries) ListAssetsForRisk 

func (q *Queries) ListAssetsForRisk(ctx context.Context, riskID uuid.UUID) ([]Asset, error)

func (*Queries) ListAuditLogAdmin 

func (q *Queries) ListAuditLogAdmin(ctx context.Context) ([]ListAuditLogAdminRow, error)

func (*Queries) ListAuditLogForActivity 

func (q *Queries) ListAuditLogForActivity(ctx context.Context, dollar_1 string) ([]ListAuditLogForActivityRow, error)

func (*Queries) ListAuditLogForAssessment 

func (q *Queries) ListAuditLogForAssessment(ctx context.Context, dollar_1 string) ([]ListAuditLogForAssessmentRow, error)

func (*Queries) ListAuditLogForAsset 

func (q *Queries) ListAuditLogForAsset(ctx context.Context, dollar_1 string) ([]ListAuditLogForAssetRow, error)

func (*Queries) ListAuditLogForFramework 

func (q *Queries) ListAuditLogForFramework(ctx context.Context, dollar_1 string) ([]ListAuditLogForFrameworkRow, error)

func (*Queries) ListAuditLogForMeasure 

func (q *Queries) ListAuditLogForMeasure(ctx context.Context, dollar_1 string) ([]ListAuditLogForMeasureRow, error)

func (*Queries) ListAuditLogForRequirement 

func (q *Queries) ListAuditLogForRequirement(ctx context.Context, dollar_1 string) ([]ListAuditLogForRequirementRow, error)

func (*Queries) ListAuditLogForRisk 

func (q *Queries) ListAuditLogForRisk(ctx context.Context, dollar_1 string) ([]ListAuditLogForRiskRow, error)

func (*Queries) ListAvvik 

func (q *Queries) ListAvvik(ctx context.Context, arg ListAvvikParams) ([]Avvik, error)

func (*Queries) ListAvvikActivities 

func (q *Queries) ListAvvikActivities(ctx context.Context, avvikID uuid.UUID) ([]Activity, error)

func (*Queries) ListAvvikAttachments 

func (q *Queries) ListAvvikAttachments(ctx context.Context, avvikID uuid.UUID) ([]AvvikAttachment, error)

func (*Queries) ListAvvikEvents 

func (q *Queries) ListAvvikEvents(ctx context.Context, avvikID uuid.UUID) ([]AvvikEvent, error)

func (*Queries) ListAvvikMeasures 

func (q *Queries) ListAvvikMeasures(ctx context.Context, avvikID uuid.UUID) ([]Measure, error)

func (*Queries) ListAvvikNotifications 

func (q *Queries) ListAvvikNotifications(ctx context.Context, avvikID uuid.UUID) ([]AvvikNotification, error)

func (*Queries) ListDevStubUsers 

func (q *Queries) ListDevStubUsers(ctx context.Context) ([]User, error)

func (*Queries) ListFrameworks 

func (q *Queries) ListFrameworks(ctx context.Context) ([]Framework, error)
func (q *Queries) ListMeasureFrameworkLinks(ctx context.Context) ([]ListMeasureFrameworkLinksRow, error)

Returns one row per (measure, framework) pair — used to build the framework badge list shown next to each measure in the list view. 

func (q *Queries) ListMeasureLinks(ctx context.Context, measureID uuid.UUID) ([]MeasureLink, error)

func (*Queries) ListMeasureRiskLinkIDs 

func (q *Queries) ListMeasureRiskLinkIDs(ctx context.Context) ([]uuid.UUID, error)

func (*Queries) ListMeasures 

func (q *Queries) ListMeasures(ctx context.Context) ([]Measure, error)

func (*Queries) ListMeasuresForRequirement 

func (q *Queries) ListMeasuresForRequirement(ctx context.Context, requirementID uuid.UUID) ([]ListMeasuresForRequirementRow, error)

func (*Queries) ListMeasuresForRisk 

func (q *Queries) ListMeasuresForRisk(ctx context.Context, riskID uuid.UUID) ([]Measure, error)

func (*Queries) ListMeasuresForUser 

func (q *Queries) ListMeasuresForUser(ctx context.Context, assigneeID uuid.NullUUID) ([]Measure, error)

func (*Queries) ListOrganizations 

func (q *Queries) ListOrganizations(ctx context.Context) ([]Organization, error)

func (*Queries) ListOwnedActivities 

func (q *Queries) ListOwnedActivities(ctx context.Context, assigneeID uuid.NullUUID) ([]ListOwnedActivitiesRow, error)

func (*Queries) ListOwnedMeasures 

func (q *Queries) ListOwnedMeasures(ctx context.Context, assigneeID uuid.NullUUID) ([]ListOwnedMeasuresRow, error)

func (*Queries) ListOwnedRisks 

func (q *Queries) ListOwnedRisks(ctx context.Context, ownerID uuid.NullUUID) ([]ListOwnedRisksRow, error)

func (*Queries) ListParticipantsForAssessment 

func (q *Queries) ListParticipantsForAssessment(ctx context.Context, assessmentID uuid.UUID) ([]User, error)

func (*Queries) ListRecentActivities 

func (q *Queries) ListRecentActivities(ctx context.Context) ([]ListRecentActivitiesRow, error)

func (*Queries) ListRequirementsByFramework 

func (q *Queries) ListRequirementsByFramework(ctx context.Context, frameworkID uuid.UUID) ([]Requirement, error)

func (*Queries) ListRequirementsForMeasure 

func (q *Queries) ListRequirementsForMeasure(ctx context.Context, measureID uuid.UUID) ([]ListRequirementsForMeasureRow, error)

func (*Queries) ListRiskAssessments 

func (q *Queries) ListRiskAssessments(ctx context.Context) ([]RiskAssessment, error)

func (*Queries) ListRiskAssessmentsForUser 

func (q *Queries) ListRiskAssessmentsForUser(ctx context.Context, riskOwnerID uuid.NullUUID) ([]RiskAssessment, error)

func (*Queries) ListRiskReassessmentEvents 

func (q *Queries) ListRiskReassessmentEvents(ctx context.Context, arg ListRiskReassessmentEventsParams) ([]ListRiskReassessmentEventsRow, error)

func (*Queries) ListRiskReviewQueue 

func (q *Queries) ListRiskReviewQueue(ctx context.Context) ([]ListRiskReviewQueueRow, error)

func (*Queries) ListRiskReviewQueueForUser 

func (q *Queries) ListRiskReviewQueueForUser(ctx context.Context, dollar_1 uuid.UUID) ([]ListRiskReviewQueueForUserRow, error)

func (*Queries) ListRiskScaleLabels 

func (q *Queries) ListRiskScaleLabels(ctx context.Context) ([]RiskScaleLabel, error)

func (*Queries) ListRisksForActivity 

func (q *Queries) ListRisksForActivity(ctx context.Context, activityID uuid.UUID) ([]Risk, error)

func (*Queries) ListRisksForAssessment 

func (q *Queries) ListRisksForAssessment(ctx context.Context, assessmentID uuid.UUID) ([]Risk, error)

func (*Queries) ListRisksForMeasure 

func (q *Queries) ListRisksForMeasure(ctx context.Context, measureID uuid.UUID) ([]Risk, error)

func (*Queries) ListTopRisks 

func (q *Queries) ListTopRisks(ctx context.Context) ([]ListTopRisksRow, error)

func (*Queries) ListUsers 

func (q *Queries) ListUsers(ctx context.Context) ([]User, error)

func (*Queries) MarkActivityInProgress 

func (q *Queries) MarkActivityInProgress(ctx context.Context, id uuid.UUID) (Activity, error)

func (*Queries) MarkOverdueActivities 

func (q *Queries) MarkOverdueActivities(ctx context.Context) error

func (*Queries) PreCreateUser 

func (q *Queries) PreCreateUser(ctx context.Context, arg PreCreateUserParams) (User, error)

func (*Queries) ReassessRiskCurrentScores 

func (q *Queries) ReassessRiskCurrentScores(ctx context.Context, arg ReassessRiskCurrentScoresParams) (Risk, error)

func (*Queries) RemoveAssessmentParticipant 

func (q *Queries) RemoveAssessmentParticipant(ctx context.Context, arg RemoveAssessmentParticipantParams) error

func (*Queries) RemoveAssetFromAssessment 

func (q *Queries) RemoveAssetFromAssessment(ctx context.Context, arg RemoveAssetFromAssessmentParams) error

func (*Queries) ReopenActivity 

func (q *Queries) ReopenActivity(ctx context.Context, id uuid.UUID) (Activity, error)

func (*Queries) SearchActivities 

func (q *Queries) SearchActivities(ctx context.Context, title string) ([]Activity, error)

func (*Queries) SearchAssetsForRisk 

func (q *Queries) SearchAssetsForRisk(ctx context.Context, arg SearchAssetsForRiskParams) ([]Asset, error)
func (q *Queries) SearchAssetsToLink(ctx context.Context, arg SearchAssetsToLinkParams) ([]Asset, error)

func (*Queries) SearchMeasures 

func (q *Queries) SearchMeasures(ctx context.Context, name string) ([]Measure, error)

func (*Queries) SetUserOrg 

func (q *Queries) SetUserOrg(ctx context.Context, arg SetUserOrgParams) (User, error)

func (*Queries) SetUserRole 

func (q *Queries) SetUserRole(ctx context.Context, arg SetUserRoleParams) (User, error)

func (*Queries) ToggleRiskAssessmentPublic 

func (q *Queries) ToggleRiskAssessmentPublic(ctx context.Context, id uuid.UUID) (RiskAssessment, error)

func (*Queries) UnlinkAvvikActivity 

func (q *Queries) UnlinkAvvikActivity(ctx context.Context, arg UnlinkAvvikActivityParams) error

func (*Queries) UnlinkAvvikMeasure 

func (q *Queries) UnlinkAvvikMeasure(ctx context.Context, arg UnlinkAvvikMeasureParams) error

func (*Queries) UnlinkMeasureFromRequirement 

func (q *Queries) UnlinkMeasureFromRequirement(ctx context.Context, arg UnlinkMeasureFromRequirementParams) error

func (*Queries) UnlinkRiskFromActivity 

func (q *Queries) UnlinkRiskFromActivity(ctx context.Context, arg UnlinkRiskFromActivityParams) error

func (*Queries) UnlinkRiskFromAsset 

func (q *Queries) UnlinkRiskFromAsset(ctx context.Context, arg UnlinkRiskFromAssetParams) error

func (*Queries) UnlinkRiskFromMeasure 

func (q *Queries) UnlinkRiskFromMeasure(ctx context.Context, arg UnlinkRiskFromMeasureParams) error

func (*Queries) UpdateActivity 

func (q *Queries) UpdateActivity(ctx context.Context, arg UpdateActivityParams) (Activity, error)

func (*Queries) UpdateAppSettings 

func (q *Queries) UpdateAppSettings(ctx context.Context, arg UpdateAppSettingsParams) error

func (*Queries) UpdateAsset 

func (q *Queries) UpdateAsset(ctx context.Context, arg UpdateAssetParams) (Asset, error)

func (*Queries) UpdateAvvikClosureFlags 

func (q *Queries) UpdateAvvikClosureFlags(ctx context.Context, arg UpdateAvvikClosureFlagsParams) (Avvik, error)

func (*Queries) UpdateAvvikStatus 

func (q *Queries) UpdateAvvikStatus(ctx context.Context, arg UpdateAvvikStatusParams) (Avvik, error)

func (*Queries) UpdateAvvikTriage 

func (q *Queries) UpdateAvvikTriage(ctx context.Context, arg UpdateAvvikTriageParams) (Avvik, error)

func (*Queries) UpdateFramework 

func (q *Queries) UpdateFramework(ctx context.Context, arg UpdateFrameworkParams) (Framework, error)

func (*Queries) UpdateMeasure 

func (q *Queries) UpdateMeasure(ctx context.Context, arg UpdateMeasureParams) (Measure, error)

func (*Queries) UpdateMeasureLastVerified 

func (q *Queries) UpdateMeasureLastVerified(ctx context.Context, id uuid.UUID) error

func (*Queries) UpdateRequirement 

func (q *Queries) UpdateRequirement(ctx context.Context, arg UpdateRequirementParams) (Requirement, error)

func (*Queries) UpdateRiskAssessmentReviewed 

func (q *Queries) UpdateRiskAssessmentReviewed(ctx context.Context, id uuid.UUID) error

func (*Queries) UpdateRiskAssessmentStep 

func (q *Queries) UpdateRiskAssessmentStep(ctx context.Context, arg UpdateRiskAssessmentStepParams) error

func (*Queries) UpdateRiskAssessmentStep1 

func (q *Queries) UpdateRiskAssessmentStep1(ctx context.Context, arg UpdateRiskAssessmentStep1Params) (RiskAssessment, error)

func (*Queries) UpdateRiskAssessmentThreatStep added in v1.0.2 

func (q *Queries) UpdateRiskAssessmentThreatStep(ctx context.Context, arg UpdateRiskAssessmentThreatStepParams) (RiskAssessment, error)

func (*Queries) UpdateRiskCurrentScores 

func (q *Queries) UpdateRiskCurrentScores(ctx context.Context, arg UpdateRiskCurrentScoresParams) (Risk, error)

func (*Queries) UpdateRiskDecision 

func (q *Queries) UpdateRiskDecision(ctx context.Context, arg UpdateRiskDecisionParams) error

func (*Queries) UpdateRiskGlobalSettings 

func (q *Queries) UpdateRiskGlobalSettings(ctx context.Context, arg UpdateRiskGlobalSettingsParams) error

func (*Queries) UpdateRiskIdentification 

func (q *Queries) UpdateRiskIdentification(ctx context.Context, arg UpdateRiskIdentificationParams) (Risk, error)

func (*Queries) UpdateRiskTargetScore 

func (q *Queries) UpdateRiskTargetScore(ctx context.Context, arg UpdateRiskTargetScoreParams) error

func (*Queries) UpsertDevStubUser 

func (q *Queries) UpsertDevStubUser(ctx context.Context, arg UpsertDevStubUserParams) (User, error)

func (*Queries) UpsertRiskScaleLabel 

func (q *Queries) UpsertRiskScaleLabel(ctx context.Context, arg UpsertRiskScaleLabelParams) error

func (*Queries) UpsertUser 

func (q *Queries) UpsertUser(ctx context.Context, arg UpsertUserParams) (User, error)

func (*Queries) WithTx 

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

type ReassessRiskCurrentScoresParams 

type ReassessRiskCurrentScoresParams struct {
	ID                  uuid.UUID     `json:"id"`
	LikelihoodCurrent   sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent  sql.NullInt32 `json:"consequence_current"`
	AssessmentRationale string        `json:"assessment_rationale"`
	AssessedBy          uuid.NullUUID `json:"assessed_by"`
}

type RemoveAssessmentParticipantParams 

type RemoveAssessmentParticipantParams struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	UserID       uuid.UUID `json:"user_id"`
}

type RemoveAssetFromAssessmentParams 

type RemoveAssetFromAssessmentParams struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	AssetID      uuid.UUID `json:"asset_id"`
}

type Requirement 

type Requirement struct {
	ID                uuid.UUID `json:"id"`
	FrameworkID       uuid.UUID `json:"framework_id"`
	Ref               string    `json:"ref"`
	Title             string    `json:"title"`
	Description       string    `json:"description"`
	SortOrder         int32     `json:"sort_order"`
	CreatedAt         time.Time `json:"created_at"`
	UpdatedAt         time.Time `json:"updated_at"`
	NotRelevant       bool      `json:"not_relevant"`
	NotRelevantReason string    `json:"not_relevant_reason"`
}

type ResourceParticipant 

type ResourceParticipant struct {
	ID           uuid.UUID `json:"id"`
	ResourceType string    `json:"resource_type"`
	ResourceID   uuid.UUID `json:"resource_id"`
	UserID       uuid.UUID `json:"user_id"`
	Role         string    `json:"role"`
	CreatedAt    time.Time `json:"created_at"`
}

type Risk 

type Risk struct {
	ID                   uuid.UUID     `json:"id"`
	AssessmentID         uuid.UUID     `json:"assessment_id"`
	Name                 string        `json:"name"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodTarget     sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget    sql.NullInt32 `json:"consequence_target"`
	RiskDecision         string        `json:"risk_decision"`
	Status               string        `json:"status"`
	CreatedAt            time.Time     `json:"created_at"`
	UpdatedAt            time.Time     `json:"updated_at"`
	Description          string        `json:"description"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
	OwnerID              uuid.NullUUID `json:"owner_id"`
	DecisionNotes        string        `json:"decision_notes"`
	RefNum               sql.NullInt32 `json:"ref_num"`
	ReviewNeeded         bool          `json:"review_needed"`
	ReviewDue            sql.NullTime  `json:"review_due"`
	AssessedAt           sql.NullTime  `json:"assessed_at"`
	AssessedBy           uuid.NullUUID `json:"assessed_by"`
	AssessmentRationale  string        `json:"assessment_rationale"`
}
type RiskActivityLink struct {
	RiskID     uuid.UUID `json:"risk_id"`
	ActivityID uuid.UUID `json:"activity_id"`
	Note       string    `json:"note"`
}

type RiskAssessment 

type RiskAssessment struct {
	ID                      uuid.UUID     `json:"id"`
	Name                    string        `json:"name"`
	Scope                   string        `json:"scope"`
	AnalysisObject          string        `json:"analysis_object"`
	SecurityObjectives      string        `json:"security_objectives"`
	BusinessObjectives      string        `json:"business_objectives"`
	Type                    string        `json:"type"`
	Status                  string        `json:"status"`
	CurrentStep             int32         `json:"current_step"`
	LastReviewedAt          sql.NullTime  `json:"last_reviewed_at"`
	CreatedBy               uuid.NullUUID `json:"created_by"`
	CreatedAt               time.Time     `json:"created_at"`
	UpdatedAt               time.Time     `json:"updated_at"`
	RiskOwnerID             uuid.NullUUID `json:"risk_owner_id"`
	OrgID                   uuid.NullUUID `json:"org_id"`
	RefNum                  sql.NullInt32 `json:"ref_num"`
	AcceptanceNote          string        `json:"acceptance_note"`
	IsPublic                bool          `json:"is_public"`
	ThreatAssessmentEnabled bool          `json:"threat_assessment_enabled"`
	ThreatAppDescription    string        `json:"threat_app_description"`
	ThreatInformationFlow   string        `json:"threat_information_flow"`
}

type RiskAssessmentAsset 

type RiskAssessmentAsset struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	AssetID      uuid.UUID `json:"asset_id"`
	CreatedAt    time.Time `json:"created_at"`
}

type RiskAssessmentParticipant 

type RiskAssessmentParticipant struct {
	AssessmentID uuid.UUID `json:"assessment_id"`
	UserID       uuid.UUID `json:"user_id"`
}
type RiskAssetLink struct {
	RiskID    uuid.UUID `json:"risk_id"`
	AssetID   uuid.UUID `json:"asset_id"`
	CreatedAt time.Time `json:"created_at"`
}

type RiskGlobalSetting 

type RiskGlobalSetting struct {
	ID                 int32  `json:"id"`
	AcceptanceCriteria string `json:"acceptance_criteria"`
	LowMax             int32  `json:"low_max"`
	HighMin            int32  `json:"high_min"`
}
type RiskMeasureLink struct {
	RiskID    uuid.UUID `json:"risk_id"`
	MeasureID uuid.UUID `json:"measure_id"`
	Note      string    `json:"note"`
}

type RiskReassessmentEvent 

type RiskReassessmentEvent struct {
	ID            uuid.UUID     `json:"id"`
	RiskID        uuid.UUID     `json:"risk_id"`
	MeasureID     uuid.UUID     `json:"measure_id"`
	TriggerStatus string        `json:"trigger_status"`
	TriggeredAt   time.Time     `json:"triggered_at"`
	TriggeredBy   uuid.NullUUID `json:"triggered_by"`
	Note          string        `json:"note"`
}

type RiskScaleLabel 

type RiskScaleLabel struct {
	Scale       string `json:"scale"`
	Level       int32  `json:"level"`
	Label       string `json:"label"`
	Description string `json:"description"`
}

type SearchAssetsForRiskParams 

type SearchAssetsForRiskParams struct {
	Q          interface{} `json:"q"`
	RiskID     uuid.UUID   `json:"risk_id"`
	LimitCount int32       `json:"limit_count"`
}

type SearchAssetsToLinkParams 

type SearchAssetsToLinkParams struct {
	Q            interface{} `json:"q"`
	AssessmentID uuid.UUID   `json:"assessment_id"`
	LimitCount   int32       `json:"limit_count"`
}

type Session 

type Session struct {
	Token  string        `json:"token"`
	Data   []byte        `json:"data"`
	Expiry time.Time     `json:"expiry"`
	UserID uuid.NullUUID `json:"user_id"`
}

type SetUserOrgParams 

type SetUserOrgParams struct {
	ID    uuid.UUID     `json:"id"`
	OrgID uuid.NullUUID `json:"org_id"`
}

type SetUserRoleParams 

type SetUserRoleParams struct {
	ID   uuid.UUID `json:"id"`
	Role string    `json:"role"`
}

type UnlinkAvvikActivityParams 

type UnlinkAvvikActivityParams struct {
	AvvikID    uuid.UUID `json:"avvik_id"`
	ActivityID uuid.UUID `json:"activity_id"`
}

type UnlinkAvvikMeasureParams 

type UnlinkAvvikMeasureParams struct {
	AvvikID   uuid.UUID `json:"avvik_id"`
	MeasureID uuid.UUID `json:"measure_id"`
}

type UnlinkMeasureFromRequirementParams 

type UnlinkMeasureFromRequirementParams struct {
	MeasureID     uuid.UUID `json:"measure_id"`
	RequirementID uuid.UUID `json:"requirement_id"`
}

type UnlinkRiskFromActivityParams 

type UnlinkRiskFromActivityParams struct {
	RiskID     uuid.UUID `json:"risk_id"`
	ActivityID uuid.UUID `json:"activity_id"`
}

type UnlinkRiskFromAssetParams 

type UnlinkRiskFromAssetParams struct {
	RiskID  uuid.UUID `json:"risk_id"`
	AssetID uuid.UUID `json:"asset_id"`
}

type UnlinkRiskFromMeasureParams 

type UnlinkRiskFromMeasureParams struct {
	RiskID    uuid.UUID `json:"risk_id"`
	MeasureID uuid.UUID `json:"measure_id"`
}

type UpdateActivityParams 

type UpdateActivityParams struct {
	ID           uuid.UUID     `json:"id"`
	Title        string        `json:"title"`
	Description  string        `json:"description"`
	ActivityType string        `json:"activity_type"`
	Recurrence   string        `json:"recurrence"`
	Priority     string        `json:"priority"`
	Kind         string        `json:"kind"`
	Owner        string        `json:"owner"`
	AssigneeID   uuid.NullUUID `json:"assignee_id"`
	DueDate      sql.NullTime  `json:"due_date"`
}

type UpdateAppSettingsParams 

type UpdateAppSettingsParams struct {
	ComplianceEnabled bool `json:"compliance_enabled"`
	RiskEnabled       bool `json:"risk_enabled"`
	ActivitiesEnabled bool `json:"activities_enabled"`
	AssetsEnabled     bool `json:"assets_enabled"`
	PlaygroundEnabled bool `json:"playground_enabled"`
	AvvikEnabled      bool `json:"avvik_enabled"`
}

type UpdateAssetParams 

type UpdateAssetParams struct {
	ID          uuid.UUID `json:"id"`
	Name        string    `json:"name"`
	Description string    `json:"description"`
	AssetType   string    `json:"asset_type"`
	Owner       string    `json:"owner"`
	Status      string    `json:"status"`
	Criticality string    `json:"criticality"`
}

type UpdateAvvikClosureFlagsParams 

type UpdateAvvikClosureFlagsParams struct {
	ID                        uuid.UUID `json:"id"`
	LogQaDone                 bool      `json:"log_qa_done"`
	FollowupsDelegated        bool      `json:"followups_delegated"`
	ReporterInformed          bool      `json:"reporter_informed"`
	OrgInformed               bool      `json:"org_informed"`
	MgmtInformed              bool      `json:"mgmt_informed"`
	DecisionsAnchored         bool      `json:"decisions_anchored"`
	ImplementationDeadlineSet bool      `json:"implementation_deadline_set"`
}

type UpdateAvvikStatusParams 

type UpdateAvvikStatusParams struct {
	ID             uuid.UUID    `json:"id"`
	Status         string       `json:"status"`
	ClosedAt       sql.NullTime `json:"closed_at"`
	ClosureSummary string       `json:"closure_summary"`
	RootCause      string       `json:"root_cause"`
	LessonsLearned string       `json:"lessons_learned"`
}

type UpdateAvvikTriageParams 

type UpdateAvvikTriageParams struct {
	ID                   uuid.UUID     `json:"id"`
	RiskLevel            string        `json:"risk_level"`
	PersonalData         bool          `json:"personal_data"`
	Ksi                  bool          `json:"ksi"`
	KsiInformationOwner  string        `json:"ksi_information_owner"`
	MarketSensitive      bool          `json:"market_sensitive"`
	MarketAssessmentNote string        `json:"market_assessment_note"`
	GdprDeadlineAt       sql.NullTime  `json:"gdpr_deadline_at"`
	OrgUnitID            uuid.NullUUID `json:"org_unit_id"`
}

type UpdateFrameworkParams 

type UpdateFrameworkParams struct {
	ID                uuid.UUID `json:"id"`
	Name              string    `json:"name"`
	ShortName         string    `json:"short_name"`
	Version           string    `json:"version"`
	Description       string    `json:"description"`
	FrameworkType     string    `json:"framework_type"`
	NotRelevant       bool      `json:"not_relevant"`
	NotRelevantReason string    `json:"not_relevant_reason"`
}

type UpdateMeasureParams 

type UpdateMeasureParams struct {
	ID          uuid.UUID     `json:"id"`
	Name        string        `json:"name"`
	Description string        `json:"description"`
	Category    string        `json:"category"`
	Owner       string        `json:"owner"`
	AssigneeID  uuid.NullUUID `json:"assignee_id"`
	Status      string        `json:"status"`
}

type UpdateRequirementParams 

type UpdateRequirementParams struct {
	ID                uuid.UUID `json:"id"`
	Ref               string    `json:"ref"`
	Title             string    `json:"title"`
	Description       string    `json:"description"`
	SortOrder         int32     `json:"sort_order"`
	NotRelevant       bool      `json:"not_relevant"`
	NotRelevantReason string    `json:"not_relevant_reason"`
}

type UpdateRiskAssessmentStep1Params 

type UpdateRiskAssessmentStep1Params struct {
	ID                      uuid.UUID     `json:"id"`
	Name                    string        `json:"name"`
	Scope                   string        `json:"scope"`
	AnalysisObject          string        `json:"analysis_object"`
	SecurityObjectives      string        `json:"security_objectives"`
	BusinessObjectives      string        `json:"business_objectives"`
	Type                    string        `json:"type"`
	RiskOwnerID             uuid.NullUUID `json:"risk_owner_id"`
	OrgID                   uuid.NullUUID `json:"org_id"`
	ThreatAssessmentEnabled bool          `json:"threat_assessment_enabled"`
}

type UpdateRiskAssessmentStepParams 

type UpdateRiskAssessmentStepParams struct {
	ID          uuid.UUID `json:"id"`
	CurrentStep int32     `json:"current_step"`
	Status      string    `json:"status"`
}

type UpdateRiskAssessmentThreatStepParams added in v1.0.2 

type UpdateRiskAssessmentThreatStepParams struct {
	ID                    uuid.UUID `json:"id"`
	ThreatAppDescription  string    `json:"threat_app_description"`
	ThreatInformationFlow string    `json:"threat_information_flow"`
}

type UpdateRiskCurrentScoresParams 

type UpdateRiskCurrentScoresParams struct {
	ID                   uuid.UUID     `json:"id"`
	LikelihoodCurrent    sql.NullInt32 `json:"likelihood_current"`
	ConsequenceCurrent   sql.NullInt32 `json:"consequence_current"`
	LikelihoodReasoning  string        `json:"likelihood_reasoning"`
	ConsequenceReasoning string        `json:"consequence_reasoning"`
}

type UpdateRiskDecisionParams 

type UpdateRiskDecisionParams struct {
	ID            uuid.UUID `json:"id"`
	RiskDecision  string    `json:"risk_decision"`
	DecisionNotes string    `json:"decision_notes"`
}

type UpdateRiskGlobalSettingsParams 

type UpdateRiskGlobalSettingsParams struct {
	AcceptanceCriteria string `json:"acceptance_criteria"`
	LowMax             int32  `json:"low_max"`
	HighMin            int32  `json:"high_min"`
}

type UpdateRiskIdentificationParams 

type UpdateRiskIdentificationParams struct {
	ID          uuid.UUID `json:"id"`
	Name        string    `json:"name"`
	Description string    `json:"description"`
}

type UpdateRiskTargetScoreParams 

type UpdateRiskTargetScoreParams struct {
	ID                uuid.UUID     `json:"id"`
	LikelihoodTarget  sql.NullInt32 `json:"likelihood_target"`
	ConsequenceTarget sql.NullInt32 `json:"consequence_target"`
}

type UpsertDevStubUserParams 

type UpsertDevStubUserParams struct {
	ProviderID string `json:"provider_id"`
	Email      string `json:"email"`
	Name       string `json:"name"`
	Role       string `json:"role"`
}

type UpsertRiskScaleLabelParams 

type UpsertRiskScaleLabelParams struct {
	Scale       string `json:"scale"`
	Level       int32  `json:"level"`
	Label       string `json:"label"`
	Description string `json:"description"`
}

type UpsertUserParams 

type UpsertUserParams struct {
	Provider   string `json:"provider"`
	ProviderID string `json:"provider_id"`
	Email      string `json:"email"`
	Name       string `json:"name"`
}

type User 

type User struct {
	ID         uuid.UUID     `json:"id"`
	Provider   string        `json:"provider"`
	ProviderID string        `json:"provider_id"`
	Email      string        `json:"email"`
	Name       string        `json:"name"`
	Role       string        `json:"role"`
	CreatedAt  time.Time     `json:"created_at"`
	UpdatedAt  time.Time     `json:"updated_at"`
	OrgID      uuid.NullUUID `json:"org_id"`
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.