From cfe31f992a12c95570891b8cca8747589c6c6228 Mon Sep 17 00:00:00 2001 From: Nick Thomas Date: Mon, 1 Jul 2019 12:23:25 +0100 Subject: Squash old migrations Use the `squasher` gem to squash migrations older than the start of 2018 --- db/migrate/20150425164647_remove_duplicate_tags.rb | 18 ------------------ 1 file changed, 18 deletions(-) delete mode 100644 db/migrate/20150425164647_remove_duplicate_tags.rb (limited to 'db/migrate/20150425164647_remove_duplicate_tags.rb') diff --git a/db/migrate/20150425164647_remove_duplicate_tags.rb b/db/migrate/20150425164647_remove_duplicate_tags.rb deleted file mode 100644 index 5165eb65695..00000000000 --- a/db/migrate/20150425164647_remove_duplicate_tags.rb +++ /dev/null @@ -1,18 +0,0 @@ -# rubocop:disable all -class RemoveDuplicateTags < ActiveRecord::Migration[4.2] - def up - select_all("SELECT name, COUNT(id) as cnt FROM tags GROUP BY name HAVING COUNT(id) > 1").each do |tag| - tag_name = quote_string(tag["name"]) - duplicate_ids = select_all("SELECT id FROM tags WHERE name = '#{tag_name}'").map{|tag| tag["id"]} - origin_tag_id = duplicate_ids.first - duplicate_ids.delete origin_tag_id - - execute("UPDATE taggings SET tag_id = #{origin_tag_id} WHERE tag_id IN(#{duplicate_ids.join(",")})") - execute("DELETE FROM tags WHERE id IN(#{duplicate_ids.join(",")})") - end - end - - def down - - end -end -- cgit v1.2.1