Welcome to mirror list, hosted at ThFree Co, Russian Federation.

gitlab.com/gitlab-org/gitlab-foss.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'db/post_migrate/20200811130433_create_missing_vulnerabilities_issue_links.rb')
-rw-r--r--db/post_migrate/20200811130433_create_missing_vulnerabilities_issue_links.rb48
1 files changed, 0 insertions, 48 deletions
diff --git a/db/post_migrate/20200811130433_create_missing_vulnerabilities_issue_links.rb b/db/post_migrate/20200811130433_create_missing_vulnerabilities_issue_links.rb
deleted file mode 100644
index 031d9ea49e2..00000000000
--- a/db/post_migrate/20200811130433_create_missing_vulnerabilities_issue_links.rb
+++ /dev/null
@@ -1,48 +0,0 @@
-# frozen_string_literal: true
-
-class CreateMissingVulnerabilitiesIssueLinks < ActiveRecord::Migration[6.0]
- class VulnerabilitiesFeedback < ActiveRecord::Base
- include EachBatch
- self.table_name = 'vulnerability_feedback'
- end
-
- class VulnerabilitiesIssueLink < ActiveRecord::Base
- self.table_name = 'vulnerability_issue_links'
- LINK_TYPE_CREATED = 2
- end
-
- include Gitlab::Database::MigrationHelpers
-
- DOWNTIME = false
-
- disable_ddl_transaction!
-
- def up
- VulnerabilitiesFeedback.where.not(issue_id: nil).each_batch do |relation|
- timestamp = Time.now
- issue_links = relation
- .joins("JOIN vulnerability_occurrences vo ON vo.project_id = vulnerability_feedback.project_id AND vo.report_type = vulnerability_feedback.category AND encode(vo.project_fingerprint, 'hex') = vulnerability_feedback.project_fingerprint")
- .where.not('vo.vulnerability_id' => nil)
- .pluck(:vulnerability_id, :issue_id)
- .map do |v_id, i_id|
- {
- vulnerability_id: v_id,
- issue_id: i_id,
- link_type: VulnerabilitiesIssueLink::LINK_TYPE_CREATED,
- created_at: timestamp,
- updated_at: timestamp
- }
- end
-
- next if issue_links.empty?
-
- VulnerabilitiesIssueLink.insert_all(
- issue_links,
- returning: false
- )
- end
- end
-
- def down
- end
-end