Class: ApplicationRecord

Inherits:
ActiveRecord::Base
  • Object
show all
Includes:
CrossDatabaseModification, DatabaseReflection, LegacyBulkInsert, ResetOnUnionError, SensitiveSerializableHash, Transactions
Defined in:
app/models/application_record.rb

Direct Known Subclasses

Abuse::Event, Abuse::TrustScore, AbuseReport, Achievements::Achievement, Achievements::UserAchievement, Ai::ServiceAccessToken, AlertManagement::Alert, AlertManagement::AlertAssignee, AlertManagement::HttpIntegration, AlertManagement::MetricImage, Alerting::ProjectAlertingSetting, Analytics::CycleAnalytics::Aggregation, Analytics::CycleAnalytics::IssueStageEvent, Analytics::CycleAnalytics::MergeRequestStageEvent, Analytics::CycleAnalytics::Stage, Analytics::CycleAnalytics::StageEventHash, Analytics::CycleAnalytics::ValueStream, Analytics::UsageTrends::Measurement, ApplicationSetting::Term, Approval, Atlassian::Identity, AuditEvent, AwardEmoji, Aws::Role, Badge, BatchedGitRefUpdates::Deletion, Board, BoardGroupRecentVisit, BoardProjectRecentVisit, BulkImport, BulkImports::BatchTracker, BulkImports::Configuration, BulkImports::Entity, BulkImports::Export, BulkImports::ExportBatch, BulkImports::ExportUpload, BulkImports::Failure, BulkImports::Tracker, ChatName, ChatTeam, Ci::ApplicationRecord, Ci::Catalog::Resource, Ci::Catalog::Resources::Component, Ci::Catalog::Resources::Version, Ci::NamespaceMirror, Clusters::Agent, Clusters::AgentToken, Clusters::Agents::ActivityEvent, Clusters::Agents::Authorizations::CiAccess::GroupAuthorization, Clusters::Agents::Authorizations::CiAccess::ProjectAuthorization, Clusters::Agents::Authorizations::UserAccess::GroupAuthorization, Clusters::Agents::Authorizations::UserAccess::ProjectAuthorization, Clusters::Cluster, Clusters::ClusterEnabledGrant, Clusters::Group, Clusters::Integrations::Prometheus, Clusters::KubernetesNamespace, Clusters::Platforms::Kubernetes, Clusters::Project, Clusters::Providers::Aws, Clusters::Providers::Gcp, CommitSignatures::GpgSignature, CommitSignatures::SshSignature, CommitSignatures::X509CommitSignature, ContainerExpirationPolicy, ContainerRegistry::DataRepairDetail, ContainerRepository, CustomEmoji, CustomerRelations::Contact, CustomerRelations::IssueContact, CustomerRelations::Organization, DependencyProxy::Blob, DependencyProxy::GroupSetting, DependencyProxy::ImageTtlGroupPolicy, DependencyProxy::Manifest, DeployKeysProject, DeployToken, Deployment, DeploymentCluster, DeploymentMergeRequest, DescriptionVersion, DesignManagement::Action, DesignManagement::Design, DesignManagement::Repository, DesignManagement::Version, DevOpsReport::Metric, DiffNotePosition, DraftNote, Environment, Epic, ErrorTracking::ClientKey, ErrorTracking::Error, ErrorTracking::ErrorEvent, ErrorTracking::ProjectErrorTrackingSetting, Event, ForkNetwork, ForkNetworkMember, Gitlab::BackgroundMigration::AddNamespacesEmailsEnabledColumnData::NamespaceSetting, Gitlab::BackgroundMigration::AddProjectsEmailsEnabledColumnData::ProjectSetting, Gitlab::BackgroundMigration::BackfillDefaultBranchProtectionNamespaceSetting::Namespace, Gitlab::BackgroundMigration::BackfillDefaultBranchProtectionNamespaceSetting::NamespaceSetting, Gitlab::BackgroundMigration::BackfillDraftStatusOnMergeRequestsWithCorrectedRegex::MergeRequest, Gitlab::BackgroundMigration::BackfillFindingIdInVulnerabilities::VulnerabilitiesFindings, Gitlab::BackgroundMigration::BackfillIntegrationsEnableSslVerification::Integration, Gitlab::BackgroundMigration::BackfillMissingCiCdSettings::ProjectCiCdSetting, Gitlab::BackgroundMigration::BackfillNoteDiscussionId::Note, Gitlab::BackgroundMigration::BackfillNugetNormalizedVersion::Package, Gitlab::BackgroundMigration::BackfillNugetNormalizedVersion::PackagesNugetMetadatum, Gitlab::BackgroundMigration::BackfillProjectFeaturePackageRegistryAccessLevel::ProjectFeature, Gitlab::BackgroundMigration::BackfillProjectStatisticsStorageSizeWithRecentSize::Namespace, Gitlab::BackgroundMigration::BackfillProjectStatisticsStorageSizeWithRecentSize::Project, Gitlab::BackgroundMigration::BackfillProjectStatisticsStorageSizeWithRecentSize::ProjectStatistics, Gitlab::BackgroundMigration::BackfillProjectStatisticsStorageSizeWithRecentSize::Route, Gitlab::BackgroundMigration::BackfillProjectStatisticsStorageSizeWithoutPipelineArtifactsSizeJob::Project, Gitlab::BackgroundMigration::BackfillProjectStatisticsStorageSizeWithoutPipelineArtifactsSizeJob::ProjectStatistics, Gitlab::BackgroundMigration::BackfillResourceLinkEvents::ResourceLinkEvent, Gitlab::BackgroundMigration::BackfillWorkItemTypeIdForIssues::MigrationIssue, Gitlab::BackgroundMigration::ConvertCreditCardValidationDataToHashes::CreditCardValidation, Gitlab::BackgroundMigration::DisableLegacyOpenSourceLicenceForRecentPublicProjects::ProjectSetting, Gitlab::BackgroundMigration::DisableLegacyOpenSourceLicenseForInactivePublicProjects::ProjectSetting, Gitlab::BackgroundMigration::DisableLegacyOpenSourceLicenseForNoIssuesNoRepoProjects::ProjectSetting, Gitlab::BackgroundMigration::DisableLegacyOpenSourceLicenseForOneMemberNoRepoProjects::ProjectSetting, Gitlab::BackgroundMigration::FixIncoherentPackagesSizeOnProjectStatistics::Package, Gitlab::BackgroundMigration::FixIncoherentPackagesSizeOnProjectStatistics::PackageFile, Gitlab::BackgroundMigration::FixIncoherentPackagesSizeOnProjectStatistics::ProjectStatistics, Gitlab::BackgroundMigration::FixVulnerabilityReadsHasIssues::VulnerabilityRead, Gitlab::BackgroundMigration::MarkDuplicateNpmPackagesForDestruction::Package, Gitlab::BackgroundMigration::MigrateEvidencesForVulnerabilityFindings::Evidence, Gitlab::BackgroundMigration::MigrateEvidencesForVulnerabilityFindings::Finding, Gitlab::BackgroundMigration::MigrateLinksForVulnerabilityFindings::Finding, Gitlab::BackgroundMigration::MigrateLinksForVulnerabilityFindings::Link, Gitlab::BackgroundMigration::MigrateRemediationsForVulnerabilityFindings::Finding, Gitlab::BackgroundMigration::MigrateRemediationsForVulnerabilityFindings::FindingRemediation, Gitlab::BackgroundMigration::PopulateVulnerabilityDismissalFields::Feedback, Gitlab::BackgroundMigration::PopulateVulnerabilityDismissalFields::Finding, Gitlab::BackgroundMigration::PopulateVulnerabilityDismissalFields::Vulnerability, Gitlab::BackgroundMigration::PurgeStaleSecurityScans::SecurityScan, Gitlab::BackgroundMigration::ResetStatusOnContainerRepositories::ContainerRepository, Gitlab::BackgroundMigration::ResetStatusOnContainerRepositories::Namespace, Gitlab::BackgroundMigration::ResetStatusOnContainerRepositories::Project, Gitlab::BackgroundMigration::ResetStatusOnContainerRepositories::Route, Gitlab::BackgroundMigration::ResetTooManyTagsSkippedRegistryImports::ContainerRepository, Gitlab::BackgroundMigration::Route, Gitlab::BackgroundMigration::SetLegacyOpenSourceLicenseAvailableForNonPublicProjects::ProjectSetting, Gitlab::BackgroundMigration::TruncateOverlongVulnerabilityHtmlTitles::Vulnerability, Gitlab::BackgroundMigration::UpdateDelayedProjectRemovalToNullForUserNamespaces::NamespaceSetting, Gitlab::Database::PgUser, Gitlab::DatabaseImporters::Security::TrainingProviders::Importer::Security::TrainingProvider, GpgKey, GpgKeySubkey, GrafanaIntegration, Group::CrmSettings, GroupCustomAttribute, GroupDeployKeysGroup, GroupDeployToken, GroupGroupLink, GroupImportState, Groups::FeatureSetting, ImportExportUpload, ImportFailure, IncidentManagement::IssuableEscalationStatus, IncidentManagement::ProjectIncidentManagementSetting, IncidentManagement::TimelineEvent, IncidentManagement::TimelineEventTag, IncidentManagement::TimelineEventTagLink, Integration, Integrations::IssueTrackerData, Integrations::JiraTrackerData, Integrations::SlackWorkspace::ApiScope, Integrations::SlackWorkspace::IntegrationApiScope, Integrations::ZentaoTrackerData, InternalId, IssuableSeverity, Issue, Issue::Email, Issue::Metrics, IssueAssignee, IssueEmailParticipant, IssueLink, Issues::CsvImport, Issues::SearchData, JiraConnectInstallation, JiraConnectSubscription, JiraImportState, Key, Label, LabelLink, LabelPriority, LfsFileLock, LfsObject, LfsObjectsProject, List, ListUserPreference, MainClusterwide::ApplicationRecord, Member, MemberTask, MergeRequest, MergeRequest::CleanupSchedule, MergeRequest::DiffCommitUser, MergeRequest::Metrics, MergeRequestAssignee, MergeRequestContextCommit, MergeRequestContextCommitDiffFile, MergeRequestDiff, MergeRequestDiffCommit, MergeRequestDiffFile, MergeRequestReviewer, MergeRequestsClosingIssues, Milestone, MilestoneRelease, Ml::Candidate, Ml::CandidateMetadata, Ml::CandidateMetric, Ml::CandidateParam, Ml::Experiment, Ml::ExperimentMetadata, Ml::Model, Ml::ModelVersion, Namespace, Namespace::AdminNote, Namespace::AggregationSchedule, Namespace::Detail, Namespace::PackageSetting, Namespace::RootStorageStatistics, NamespaceCiCdSetting, NamespaceSetting, NamespaceStatistics, Namespaces::LdapSetting, Namespaces::SyncEvent, Note, NoteDiffFile, Notes::NoteMetadata, NotificationSetting, Onboarding::Progress, Operations::FeatureFlag, Operations::FeatureFlags::Scope, Operations::FeatureFlags::Strategy, Operations::FeatureFlags::StrategyUserList, Operations::FeatureFlags::UserList, Operations::FeatureFlagsClient, Organizations::Organization, Organizations::OrganizationSetting, Organizations::OrganizationUser, PackageMetadata::ApplicationRecord, Packages::BuildInfo, Packages::Cleanup::Policy, Packages::Composer::CacheFile, Packages::Composer::Metadatum, Packages::Conan::FileMetadatum, Packages::Conan::Metadatum, Packages::Debian::FileMetadatum, Packages::Debian::GroupArchitecture, Packages::Debian::GroupComponent, Packages::Debian::GroupComponentFile, Packages::Debian::GroupDistribution, Packages::Debian::GroupDistributionKey, Packages::Debian::ProjectArchitecture, Packages::Debian::ProjectComponent, Packages::Debian::ProjectComponentFile, Packages::Debian::ProjectDistribution, Packages::Debian::ProjectDistributionKey, Packages::Debian::Publication, Packages::Dependency, Packages::DependencyLink, Packages::Helm::FileMetadatum, Packages::Maven::Metadatum, Packages::Npm::MetadataCache, Packages::Npm::Metadatum, Packages::Nuget::DependencyLinkMetadatum, Packages::Nuget::Metadatum, Packages::Nuget::Symbol, Packages::Package, Packages::PackageFile, Packages::PackageFileBuildInfo, Packages::Protection::Rule, Packages::Pypi::Metadatum, Packages::Rpm::Metadatum, Packages::Rpm::RepositoryFile, Packages::Rubygems::Metadatum, Packages::Tag, PagesDeployment, PagesDomain, PagesDomainAcmeOrder, PersonalAccessToken, PlanLimits, PoolRepository, ProductAnalyticsEvent, ProgrammingLanguage, Project, ProjectAuthorization, ProjectAutoDevops, ProjectCiCdSetting, ProjectCustomAttribute, ProjectDailyStatistic, ProjectDeployToken, ProjectExportJob, ProjectFeature, ProjectFeatureUsage, ProjectGroupLink, ProjectImportData, ProjectImportState, ProjectPagesMetadatum, ProjectRepository, ProjectSetting, ProjectStatistics, Projects::BuildArtifactsSizeRefresh, Projects::CiFeatureUsage, Projects::DataTransfer, Projects::ImportExport::RelationExport, Projects::ImportExport::RelationExportUpload, Projects::ProjectTopic, Projects::RepositoryStorageMove, Projects::SyncEvent, Projects::Topic, Projects::WikiRepository, PrometheusAlert, PrometheusAlertEvent, PrometheusMetric, ProtectedBranch, ProtectedBranch::MergeAccessLevel, ProtectedBranch::PushAccessLevel, ProtectedTag, ProtectedTag::CreateAccessLevel, PushEventPayload, RawUsageData, Release, Releases::Evidence, Releases::Link, RemoteMirror, RepositoryLanguage, ResourceEvent, ResourceEvents::AbuseReportEvent, ResourceEvents::IssueAssignmentEvent, ResourceEvents::MergeRequestAssignmentEvent, Review, SentNotification, SentryIssue, ServiceDesk::CustomEmailCredential, ServiceDesk::CustomEmailVerification, ServiceDeskSetting, Shard, SlackIntegration, Snippet, SnippetRepository, SnippetStatistics, Snippets::RepositoryStorageMove, SpamLog, Subscription, Suggestion, SystemNoteMetadata, TermAgreement, Terraform::State, Terraform::StateVersion, TimeTracking::TimelogCategory, Timelog, Todo, TokenWithIv, TrendingProject, Upload, UserAgentDetail, UserCanonicalEmail, UserCustomAttribute, UserHighestRole, UserInteractedProject, UserMention, Users::BannedUser, Users::CreditCardValidation, Users::GhostUserMigration, Users::GroupCallout, Users::GroupVisit, Users::InProductMarketingEmail, Users::NamespaceCommitEmail, Users::PhoneNumberValidation, Users::ProjectCallout, Users::ProjectVisit, Users::SavedReply, Users::UserFollowUser, UsersStarProject, UsersStatistics, VsCode::VsCodeSetting, Vulnerabilities::Remediation, Vulnerability, WebHook, WebHookLog, WebauthnRegistration, WikiPage::Meta, WikiPage::Slug, WorkItems::HierarchyRestriction, WorkItems::ParentLink, WorkItems::RelatedWorkItemLink, WorkItems::Type, WorkItems::WidgetDefinition, X509Certificate, X509Issuer, ZoomMeeting

Constant Summary collapse

MAX_PLUCK =

We should avoid using pluck docs.gitlab.com/ee/development/sql.html#plucking-ids but, if we are going to use it, let’s try and limit the number of records

1_000

Constants included from ResetOnUnionError

ResetOnUnionError::MAX_RESET_PERIOD

Class Method Summary collapse

Instance Method Summary collapse

Methods included from SensitiveSerializableHash

#serializable_hash

Class Method Details

.cached_column_listObject



114
115
116
# File 'app/models/application_record.rb', line 114

def self.cached_column_list
  column_names.map { |column_name| arel_table[column_name] }
end

.declarative_enum(enum_mod) ⇒ Object



110
111
112
# File 'app/models/application_record.rb', line 110

def self.declarative_enum(enum_mod)
  enum(enum_mod.key => enum_mod.values)
end

.default_select_columnsObject



118
119
120
121
122
123
124
# File 'app/models/application_record.rb', line 118

def self.default_select_columns
  if ignored_columns.any?
    cached_column_list
  else
    arel_table[Arel.star]
  end
end

.id_in(ids) ⇒ Object



23
24
25
# File 'app/models/application_record.rb', line 23

def self.id_in(ids)
  where(id: ids)
end

.id_not_in(ids) ⇒ Object



35
36
37
# File 'app/models/application_record.rb', line 35

def self.id_not_in(ids)
  where.not(id: ids)
end

.iid_in(iids) ⇒ Object



31
32
33
# File 'app/models/application_record.rb', line 31

def self.iid_in(iids)
  where(iid: iids)
end

.pluck_primary_keyObject



39
40
41
# File 'app/models/application_record.rb', line 39

def self.pluck_primary_key
  where(nil).pluck(primary_key)
end

.primary_key_in(values) ⇒ Object



27
28
29
# File 'app/models/application_record.rb', line 27

def self.primary_key_in(values)
  where(primary_key => values)
end

.safe_ensure_unique(retries: 0) ⇒ Object



43
44
45
46
47
48
49
50
51
52
53
54
# File 'app/models/application_record.rb', line 43

def self.safe_ensure_unique(retries: 0)
  transaction(requires_new: true) do # rubocop:disable Performance/ActiveRecordSubtransactions
    yield
  end
rescue ActiveRecord::RecordNotUnique
  if retries > 0
    retries -= 1
    retry
  end

  false
end

.safe_find_or_create_by(*args, &block) ⇒ Object



78
79
80
81
82
83
84
85
86
87
88
89
90
# File 'app/models/application_record.rb', line 78

def self.safe_find_or_create_by(*args, &block)
  record = find_by(*args)
  return record if record.present?

  # We need to use `all.create` to make this implementation follow `find_or_create_by` which delegates this in
  # https://github.com/rails/rails/blob/v6.1.3.2/activerecord/lib/active_record/querying.rb#L22
  #
  # When calling this method on an association, just calling `self.create` would call `ActiveRecord::Persistence.create`
  # and that skips some code that adds the newly created record to the association.
  transaction(requires_new: true) { all.create(*args, &block) } # rubocop:disable Performance/ActiveRecordSubtransactions
rescue ActiveRecord::RecordNotUnique
  find_by(*args)
end

.safe_find_or_create_by!(*args, &block) ⇒ Object



56
57
58
59
60
61
62
# File 'app/models/application_record.rb', line 56

def self.safe_find_or_create_by!(*args, &block)
  safe_find_or_create_by(*args, &block).tap do |record|
    raise ActiveRecord::RecordNotFound unless record.present?

    record.validate! unless record.persisted?
  end
end

.underscoreObject



98
99
100
# File 'app/models/application_record.rb', line 98

def self.underscore
  @underscore ||= to_s.underscore
end

.where_exists(query) ⇒ Object



102
103
104
# File 'app/models/application_record.rb', line 102

def self.where_exists(query)
  where('EXISTS (?)', query.select(1))
end

.where_not_exists(query) ⇒ Object



106
107
108
# File 'app/models/application_record.rb', line 106

def self.where_not_exists(query)
  where('NOT EXISTS (?)', query.select(1))
end

.with_fast_read_statement_timeout(timeout_ms = 4500) ⇒ Object

Start a new transaction with a shorter-than-usual statement timeout. This is currently one third of the default 15-second timeout with a 500ms buffer to allow callers gracefully handling the errors to still complete within the 5s target duration of a low urgency request.



68
69
70
71
72
73
74
75
76
# File 'app/models/application_record.rb', line 68

def self.with_fast_read_statement_timeout(timeout_ms = 4500)
  ::Gitlab::Database::LoadBalancing::Session.current.fallback_to_replicas_for_ambiguous_queries do
    transaction(requires_new: true) do # rubocop:disable Performance/ActiveRecordSubtransactions
      connection.exec_query("SET LOCAL statement_timeout = #{timeout_ms}")

      yield
    end
  end
end

.without_orderObject



19
20
21
# File 'app/models/application_record.rb', line 19

def self.without_order
  reorder(nil)
end

Instance Method Details

#create_or_load_association(association_name) ⇒ Object



92
93
94
95
96
# File 'app/models/application_record.rb', line 92

def create_or_load_association(association_name)
  association(association_name).create unless association(association_name).loaded?
rescue ActiveRecord::RecordNotUnique, PG::UniqueViolation
  association(association_name).reader
end

#readable_by?(user) ⇒ Boolean

Returns:

  • (Boolean)


126
127
128
# File 'app/models/application_record.rb', line 126

def readable_by?(user)
  Ability.allowed?(user, "read_#{to_ability_name}".to_sym, self)
end

#to_ability_nameObject



130
131
132
# File 'app/models/application_record.rb', line 130

def to_ability_name
  model_name.element
end