diff options
Diffstat (limited to 'db/post_migrate/20181219130552_update_project_import_visibility_level.rb')
-rw-r--r-- | db/post_migrate/20181219130552_update_project_import_visibility_level.rb | 60 |
1 files changed, 0 insertions, 60 deletions
diff --git a/db/post_migrate/20181219130552_update_project_import_visibility_level.rb b/db/post_migrate/20181219130552_update_project_import_visibility_level.rb deleted file mode 100644 index bfa452578a3..00000000000 --- a/db/post_migrate/20181219130552_update_project_import_visibility_level.rb +++ /dev/null @@ -1,60 +0,0 @@ -# frozen_string_literal: true - -class UpdateProjectImportVisibilityLevel < ActiveRecord::Migration[5.0] - include Gitlab::Database::MigrationHelpers - - DOWNTIME = false - - BATCH_SIZE = 100 - - PRIVATE = 0 - INTERNAL = 10 - - disable_ddl_transaction! - - class Namespace < ActiveRecord::Base - self.table_name = 'namespaces' - end - - class Project < ActiveRecord::Base - include EachBatch - - belongs_to :namespace - - IMPORT_TYPE = 'gitlab_project' - - scope :with_group_visibility, ->(visibility) do - joins(:namespace) - .where(namespaces: { type: 'Group', visibility_level: visibility }) - .where(import_type: IMPORT_TYPE) - .where('projects.visibility_level > namespaces.visibility_level') - end - - self.table_name = 'projects' - end - - def up - # Update project's visibility to be the same as the group - # if it is more restrictive than `PUBLIC`. - update_projects_visibility(PRIVATE) - update_projects_visibility(INTERNAL) - end - - def down - # no-op: unrecoverable data migration - end - - private - - def update_projects_visibility(visibility) - say_with_time("Updating project visibility to #{visibility} on #{Project::IMPORT_TYPE} imports.") do - Project.with_group_visibility(visibility).select(:id).each_batch(of: BATCH_SIZE) do |batch, _index| - batch_sql = batch.select(:id).to_sql - - say("Updating #{batch.size} items.", true) - - execute("UPDATE projects SET visibility_level = '#{visibility}' WHERE id IN (#{batch_sql})") - end - end - end -end |