aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20120912170035_add_info_requests_count_to_public_bodies.rb17
1 files changed, 17 insertions, 0 deletions
diff --git a/db/migrate/20120912170035_add_info_requests_count_to_public_bodies.rb b/db/migrate/20120912170035_add_info_requests_count_to_public_bodies.rb
new file mode 100644
index 000000000..d77dbaa64
--- /dev/null
+++ b/db/migrate/20120912170035_add_info_requests_count_to_public_bodies.rb
@@ -0,0 +1,17 @@
+class AddInfoRequestsCountToPublicBodies < ActiveRecord::Migration
+ def self.up
+ add_column :public_bodies, :info_requests_count, :integer, :null => false, :default => 0
+
+ PublicBody.reset_column_information
+
+ PublicBody.find_each do |public_body|
+ public_body.update_attribute :info_requests_count, public_body.info_requests.length
+ end
+
+ end
+
+ def self.down
+ remove_column :public_bodies, :info_requests_count
+ end
+
+end