lib/gitlab/database/partitioning/multi_database_partition_dropper.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

# frozen_string_literal: true

module Gitlab
  module Database
    module Partitioning
      class MultiDatabasePartitionDropper
        def drop_detached_partitions
          Gitlab::AppLogger.info(message: "Dropping detached postgres partitions")

          each_database_connection do |name, connection|
            Gitlab::Database::SharedModel.using_connection(connection) do
              Gitlab::AppLogger.debug(message: "Switched database connection", connection_name: name)

              DetachedPartitionDropper.new.perform
            end
          end

          Gitlab::AppLogger.info(message: "Finished dropping detached postgres partitions")
        end

        private

        def each_database_connection
          databases.each_pair do |name, connection_wrapper|
            yield name, connection_wrapper.scope.connection
          end
        end

        def databases
          Gitlab::Database.databases
        end
      end
    end
  end
end