20160616102642_remove_duplicated_keys.rb 584 Bytes
Newer Older
1
class RemoveDuplicatedKeys < ActiveRecord::Migration[4.2]
2 3 4 5
  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's avatar
Stan Hu committed
6
        DELETE FROM #{quote_table_name(:keys)}
7 8 9 10
        WHERE fingerprint = #{fingerprint}
        AND id != (
          SELECT id FROM (
            SELECT max(id) AS id
Stan Hu's avatar
Stan Hu committed
11
            FROM #{quote_table_name(:keys)}
12 13 14 15 16 17 18
            WHERE fingerprint = #{fingerprint}
          ) max_ids
        )
      })
    end
  end
end