Add AATO, create migration file.

rohitpaulk · rohitpaulk · commit 163e0d193efb · 2015-01-01T02:51:20.000+05:30
diff --git a/Gemfile b/Gemfile
@@ -138,6 +138,9 @@ gem 'bson_ext'
 #Tagging
 gem 'rocket_tag'
 gem 'squeel', '1.0.1'
+
+gem 'acts-as-taggable-on', '~> 3.4'
+
 gem 'strong_parameters'
 gem 'postgres_ext'
 # ElasticSearch client
diff --git a/Gemfile.lock b/Gemfile.lock
@@ -81,6 +81,8 @@ GEM
     activesupport (3.2.21)
       i18n (~> 0.6, >= 0.6.4)
       multi_json (~> 1.0)
+    acts-as-taggable-on (3.4.2)
+      activerecord (>= 3.2, < 5)
     acts_as_commentable (2.0.1)
     acts_as_follower (0.1.1)
     addressable (2.3.6)
@@ -763,6 +765,7 @@ PLATFORMS
   ruby
 
 DEPENDENCIES
+  acts-as-taggable-on (~> 3.4)
   acts_as_commentable (= 2.0.1)
   acts_as_follower (= 0.1.1)
   airbrake
diff --git a/db/migrate/20141231203425_replace_rocket_tag_with_aato.rb b/db/migrate/20141231203425_replace_rocket_tag_with_aato.rb
@@ -0,0 +1,27 @@
+class ReplaceRocketTagWithAato < ActiveRecord::Migration
+  def up
+  	# This was created by rocket_tag but not used anywhere.
+  	drop_table :alias_tags
+
+  	# This is something that AATO has that rocket_tag doesn't.
+  	add_column :tags, :taggings_count, :integer, default: 0
+
+  	# Populate the taggings_count properly
+    ActsAsTaggableOn::Tag.reset_column_information
+    ActsAsTaggableOn::Tag.find_each do |tag|
+      ActsAsTaggableOn::Tag.reset_counters(tag.id, :taggings)
+    end
+
+    add_index 'tags', ['name'], name: 'index_tags_on_name', unique: true
+
+    remove_index 'taggings', name: "index_taggings_on_tag_id"
+    remove_index 'taggings', name: "index_taggings_on_taggable_id_and_taggable_type_and_context"
+    add_index 'taggings',
+      ['tag_id', 'taggable_id', 'taggable_type', 'context', 'tagger_id', 'tagger_type'],
+      unique: true, name: 'taggings_idx'
+  end
+
+  def down
+  	raise ActiveRecord::IrreversibleMigration
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
@@ -11,19 +11,11 @@
 #
 # It's strongly recommended to check this file into your version control system.
 
-ActiveRecord::Schema.define(:version => 20141221211825) do
+ActiveRecord::Schema.define(:version => 20141231203425) do
 
   add_extension "citext"
   add_extension "hstore"
 
-  create_table "alias_tags", :id => false, :force => true do |t|
-    t.integer "tag_id"
-    t.integer "alias_id"
-  end
-
-  add_index "alias_tags", ["alias_id"], :name => "index_alias_tags_on_alias_id"
-  add_index "alias_tags", ["tag_id"], :name => "index_alias_tags_on_tag_id"
-
   create_table "api_accesses", :force => true do |t|
     t.string   "api_key"
     t.text     "awards"
@@ -352,13 +344,15 @@
     t.datetime "created_at"
   end
 
-  add_index "taggings", ["tag_id"], :name => "index_taggings_on_tag_id"
-  add_index "taggings", ["taggable_id", "taggable_type", "context"], :name => "index_taggings_on_taggable_id_and_taggable_type_and_context"
+  add_index "taggings", ["tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type"], :name => "taggings_idx", :unique => true
 
   create_table "tags", :force => true do |t|
-    t.string "name"
+    t.string  "name"
+    t.integer "taggings_count", :default => 0
   end
 
+  add_index "tags", ["name"], :name => "index_tags_on_name", :unique => true
+
   create_table "teams", :force => true do |t|
     t.datetime "created_at",                                                                     :null => false
     t.datetime "updated_at",                                                                     :null => false
