1 files changed, 23 insertions, 0 deletions
diff --git a/db/migrate/099_move_raw_email_to_filesystem.rb b/db/migrate/099_move_raw_email_to_filesystem.rb
new file mode 100644
index 000000000..991ef55d7
--- /dev/null
+++ b/db/migrate/099_move_raw_email_to_filesystem.rb
@@ -0,0 +1,23 @@
+class MoveRawEmailToFilesystem < ActiveRecord::Migration
+    def self.up
+        batch_size = 10
+        0.step(RawEmail.count, batch_size) do |i|
+            RawEmail.find(:all, :limit => batch_size, :offset => i, :order => :id).each do |raw_email|
+                if !File.exists?(raw_email.filepath)
+                    STDERR.puts "converting raw_email " + raw_email.id.to_s
+                    raw_email.data = raw_email.dbdata
+                    raw_email.dbdata = nil
+                    raw_email.save!
+                end
+            end
+        end
+    end
+
+    def self.down
+        #raise "safer not to have reverse migration scripts, and we never use them"
+    end
+end
+
+
+
+