copy arc.thumbs

diff --git a/bin/copy-arc_thumbs.rb b/bin/copy-arc_thumbs.rb
new file mode 100644 (file)
index 0000000..1c2a914
--- /dev/null
+++ b/bin/copy-arc_thumbs.rb
@@ -0,0 +1,5 @@
+Record::Arc.all.each do |rec|
+  arc = Arc.find(rec.code)
+  arc.thumbs = rec.thumbs.map { |t| t.video_id }
+  arc.save
+end

diff --git a/db/groonga/migrate/20110707085913_add_thumbs_to_arc.rb b/db/groonga/migrate/20110707085913_add_thumbs_to_arc.rb
new file mode 100644 (file)
index 0000000..269a990
--- /dev/null
+++ b/db/groonga/migrate/20110707085913_add_thumbs_to_arc.rb
@@ -0,0 +1,13 @@
+class AddThumbsToArc < ActiveGroonga::Migration
+  def up
+    change_table(:arcs) do |table|
+      table.reference(:thumbs, "thumbs", :type => :vector)
+    end
+  end
+
+  def down
+    change_table(:arcs) do |table|
+      table.remove_column(:thumbs)
+    end
+  end
+end

diff --git a/db/groonga/schema.rb b/db/groonga/schema.rb
index de7c94e..6b31d52 100644 (file)
--- a/db/groonga/schema.rb
+++ b/db/groonga/schema.rb
@@ -1,4 +1,4 @@
-ActiveGroonga::Schema.define(:version => 20110707050534) do |schema|
+ActiveGroonga::Schema.define(:version => 20110707085913) do |schema|
   schema.instance_eval do
     create_table("arcs",
                  :type => :hash,
@@ -62,6 +62,7 @@ ActiveGroonga::Schema.define(:version => 20110707050534) do |schema|
 
     change_table("arcs") do |table|
       table.reference("site", "sites")
+      table.reference("thumbs", "thumbs")
     end
 
     change_table("pmds") do |table|