diff options
| author | Francis Irving <francis@mysociety.org> | 2010-09-16 14:40:23 +0100 |
|---|---|---|
| committer | Francis Irving <francis@mysociety.org> | 2010-09-16 14:40:23 +0100 |
| commit | a0875d5ed9af831aec4f15377ae4ceb720724ae0 (patch) | |
| tree | e72b876d649a044767863aead43b6b10266dffb5 | |
| parent | e6d61b4f163f28c0d35cfe24979c18e5c3ed85de (diff) | |
Scripts to fill and clear caches updated.
| -rwxr-xr-x | script/clear-caches | 2 | ||||
| -rwxr-xr-x | script/fill-database-caches | 11 |
2 files changed, 12 insertions, 1 deletions
diff --git a/script/clear-caches b/script/clear-caches index 01ea95edc..63e9a979d 100755 --- a/script/clear-caches +++ b/script/clear-caches @@ -4,7 +4,7 @@ LOC=`dirname $0` -$LOC/runner "ActiveRecord::Base.connection.execute(\"update incoming_messages set cached_attachment_text_clipped = null, cached_main_body_text = null\")" +$LOC/runner "ActiveRecord::Base.connection.execute(\"update incoming_messages set cached_attachment_text_clipped = null, cached_main_body_text_unfolded = null, cached_main_body_text_folded = null\")" # Remove page cache (do it in two stages so live site gets cache cleared faster) rm -fr $LOC/../old-cache diff --git a/script/fill-database-caches b/script/fill-database-caches new file mode 100755 index 000000000..306b22ff2 --- /dev/null +++ b/script/fill-database-caches @@ -0,0 +1,11 @@ +#!/bin/bash + +# Fill in all the database caches of text from body/attachments. +# Will take a while to run! Can use after clear-caches to refresh the database +# level caches if you like. + +LOC=`dirname $0` + +$LOC/runner 'IncomingMessage.find_each() { |im| print im.id.to_s + " id: main body folded:" + im.get_main_body_text_folded.size.to_s + " attachment clipped:" + im.get_attachment_text_clipped.size.to_s + "\n" }' + + |