diff options
Diffstat (limited to 'script')
| -rw-r--r-- | script/cache-incoming-emails | 9 | ||||
| -rwxr-xr-x | script/clear-caches | 2 | ||||
| -rwxr-xr-x | script/fill-database-caches | 11 |
3 files changed, 10 insertions, 12 deletions
diff --git a/script/cache-incoming-emails b/script/cache-incoming-emails new file mode 100644 index 000000000..a84a713d6 --- /dev/null +++ b/script/cache-incoming-emails @@ -0,0 +1,9 @@ +#!/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 "info request " + im.info_request.id.to_s + ", incoming message " + im.id.to_s + ": " + im.extract_attachments!.count.to_s + " attachments extracted to " + im.foi_attachments[0].directory + "; main body folded: " + im.get_main_body_text_folded.size.to_s + " attachment clipped:" + im.get_attachment_text_clipped.size.to_s + "\n" }' diff --git a/script/clear-caches b/script/clear-caches index e9438f92d..2d91774ef 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_unfolded = null, cached_main_body_text_folded = 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, sent_at = null, subject = null, safe_mail_from = null, mail_from_domain = null, valid_to_reply_to = 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 deleted file mode 100755 index e6b525144..000000000 --- a/script/fill-database-caches +++ /dev/null @@ -1,11 +0,0 @@ -#!/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" }' - - |