BigW Consortium Gitlab

20160616102642_remove_duplicated_keys.rb 601 Bytes
Newer Older
1 2 3 4 5 6
# rubocop:disable all
class RemoveDuplicatedKeys < ActiveRecord::Migration
  def up
    select_all("SELECT fingerprint FROM #{quote_table_name(:keys)} GROUP BY fingerprint HAVING COUNT(*) > 1").each do |row|
      fingerprint = connection.quote(row['fingerprint'])
      execute(%Q{
Stan Hu committed
7
        DELETE FROM #{quote_table_name(:keys)}
8 9 10 11
        WHERE fingerprint = #{fingerprint}
        AND id != (
          SELECT id FROM (
            SELECT max(id) AS id
12
            FROM #{quote_table_name(:keys)}
13 14 15 16 17 18 19
            WHERE fingerprint = #{fingerprint}
          ) max_ids
        )
      })
    end
  end
end