{"id":18,"date":"2008-02-09T20:15:29","date_gmt":"2008-02-10T01:15:29","guid":{"rendered":"http:\/\/unixmonkey.net\/?p=18"},"modified":"2008-02-09T20:15:29","modified_gmt":"2008-02-10T01:15:29","slug":"getting-attachment_fu-to-play-nice-with-acts_as_versioned","status":"publish","type":"post","link":"https:\/\/unixmonkey.net\/?p=18","title":{"rendered":"Getting attachment_fu to play nice with acts_as_versioned"},"content":{"rendered":"

If you’ve ever wanted to keep track of revisions to document files or images in your Rails app, you are likely to want to use Acts_as_versioned, which is the authority on versioning database records, and Attachment_fu, which is the authority on uploading files with Rails.<\/p>\n

The problem is that they don’t know about each other and will step on each other’s toes without some changes. This article serves as a quick introduction to each, and shows how to make the two plugins get along like best friends.<\/p>\n

Acts_as_versioned<\/a> was written by Rails Core Team member Rick Olsen (who also wrote attachment_fu<\/a> and Restful_authentication<\/a> among others) that essentially makes a mirror table of the one you want to version, and keeps every version of the record you are updating.<\/p>\n

Say I have a document table with fields like this:<\/p>\n\n\n\n
id<\/td>\ntitle<\/td>\ndescription<\/td>\n<\/tr>\n
1<\/td>\nrep08<\/td>\n2008 report<\/td>\n<\/tr>\n<\/table>\n

Acts_as_versioned will add a column \u201cversion\u201d, and a separate table \u201cdocument_versions\u201d.<\/p>\n\n\n\n
id<\/td>\ntitle<\/td>\ndescription<\/td>\nversion<\/td>\n<\/tr>\n
1<\/td>\nrep08<\/td>\n2008 report<\/td>\n1<\/td>\n<\/tr>\n<\/table>\n

The document_versions table will look a bit like this<\/p>\n\n\n\n
id<\/td>\ndocument_id<\/td>\ntitle<\/td>\ndescription<\/td>\nversion<\/td>\n<\/tr>\n
1<\/td>\n1<\/td>\nrep08<\/td>\n2008 report<\/td>\n1<\/td>\n<\/tr>\n<\/table>\n

Setting up acts_as_versioned is pretty simple, I got most of my introduction to it from urbanhonking.com<\/a><\/p>\n

Now every time you update the original document, the changes are saved in your main documents table, and the version column is incremented by 1.<\/p>\n

After a few edits of the document, you\u2019ll see the versioning information in the Document_versions table add up.<\/p>\n\n\n\n\n\n
id<\/td>\ndocument_id<\/td>\ntitle<\/td>\ndescription<\/td>\nversion<\/td>\n<\/tr>\n
1<\/td>\n1<\/td>\nrep08<\/td>\n2008 report<\/td>\n1<\/td>\n<\/tr>\n
2<\/td>\n1<\/td>\nrep08<\/td>\n2008 report changed<\/td>\n2<\/td>\n<\/tr>\n
3<\/td>\n1<\/td>\nrep08 chgd<\/td>\n2008 report changed<\/td>\n3<\/td>\n<\/tr>\n<\/table>\n

Great! We can now use some of acts_as_versioned\u2019s built-in methods for determining if there are older versions, and be able to view or even revert to them.<\/p>\n

Now lets add the ability to upload a file to attach to a document record with attachment_fu.<\/p>\n

Attachment_fu is another plugin that makes uploading files and keeping track of them in the database relatively simple.<\/p>\n

A good intro to attachment_fu can be found on Mike Clark\u2019s blog<\/a><\/p>\n

Attachment_fu would require a few changes to our documents table:<\/p>\n\n\n\n
id<\/td>\ntitle<\/td>\ndescription<\/td>\nversion<\/td>\nfilename<\/td>\ncontent_type<\/td>\nsize<\/td>\n<\/tr>\n
1<\/td>\nrep08<\/td>\n2008 report<\/td>\n1<\/td>\nrep08.jpg<\/td>\nimage\/jpeg<\/td>\n2854<\/td>\n<\/tr>\n<\/table>\n

Don\u2019t forget to add the same fields to your documents_versions table, too.<\/p>\n

Once we\u2019ve added the right file fields to the new and edit forms, and image_tag or download link on the show view, we\u2019ve got working file uploads. Nice.<\/p>\n

Try to edit a record by attaching a new file, the new file is displayed and the record is preserved as an older version in the versioned table. But if you try to view the old version…wait a minute? Where did my version 1 file go!<\/p>\n

That\u2019s right, attachment_fu deletes the old file when you add a new one (as it should if you aren\u2019t versioning your data). Attachment_fu\u2019s rename_file method is the one responsible for deleting (or renaming) the old file when a new one is added, so lets monkeypatch that in our model to not do anything.<\/p>\n

def rename_file\nend<\/pre>\n
Now, it will only overwrite the file if the filename is the same. Lets store each version in its own folder to keep them from clobbering each other by monkey-patching the path files get written to in our model also:<\/p>\n
def attachment_path_id\n  \"\/#{id}\/v#{version}\/\"\nend\ndef partitioned_path(*args)\n  attachment_path_id + args.to_s\nend<\/pre>\n
This changes the public path from \/0000\/0001\/rep08.jpg to \/1\/v1\/rep08.jpg<\/p>\n
Now, if we want to display the image, we cannot use the \u2018public_filename\u2019 method, because it is only given to the Document model, and not the Document_Version model.<\/p>\n
That\u2019s okay, because with our new path arrangement, we can reliably predict where the old versions of the files will be kept.  You can show them with some code similar to this in your views:<\/p>\n
<% for version in @document.versions %>\n\n  Version <%= version.version %>\n  <%= image_tag(\"\/documents\/#{@document.id}\/v#{version.version\/\" + version.filename) %>\n  
\n\n<% end %><\/pre>\n
Now, when we delete a record, attachment_fu only knows about the current document, and will leave behind orphaned files and folders from the old versions.  Lets fix that by having it get rid of the document id folder.<\/p>\n
Rails reserves some special methods (callbacks) for performing actions before or after other major actions, lets tap into that by defining a method that will magically get called every time we delete a record.<\/p>\n
def after_destroy\n  FileUtils.rm_rf(RAILS_ROOT + \"\/public\/documents\/#{id}\/\")\nend<\/pre>\n
This translates into the shell command rm -rf and deletes our ID directory and everything inside it.<\/p>\n
Hooray!<\/p>\n
As a wrap up, lets look at our complete Document model:<\/p>\n
class Document < ActiveRecord::Base\n  acts_as_versioned\n  has_attachment :storage => :file_system\n\n  def rename_file\n  end\n\n  def attachment_path_id\n    \"\/#{id}\/v#{version}\/\"\n  end\n\n  def partitioned_path(*args)\n    attachment_path_id + args.to_s\n  end\n\n  def after_destroy\n    FileUtils.rm_rf(RAILS_ROOT + \"\/public\/documents\/#{id}\/\") if id\n  end\n\nend<\/pre>\n
I’ve whipped up a sample Rails app demonstrating the points and code in this article. It uses Rails 2.0.2 with the sqlite3 database.<\/p>\n
Download it here: Attachments_versioned (240kb .zip)<\/a><\/p>\n
I hope this saves some work for someone who wants to leverage these two excellent plugins by Rick Olsen (technoweenie<\/a>) on the same model without having them fight too much.<\/p>\n","protected":false},"excerpt":{"rendered":"
If you’ve ever wanted to keep track of revisions to document files or images in your Rails app, you are likely to want to use Acts_as_versioned, which is the authority on versioning database records, and Attachment_fu, which is the authority on uploading files with Rails. The problem is that they don’t know about each other […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,14,15],"tags":[21,22,44,45,46],"_links":{"self":[{"href":"https:\/\/unixmonkey.net\/index.php?rest_route=\/wp\/v2\/posts\/18"}],"collection":[{"href":"https:\/\/unixmonkey.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unixmonkey.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unixmonkey.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unixmonkey.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18"}],"version-history":[{"count":0,"href":"https:\/\/unixmonkey.net\/index.php?rest_route=\/wp\/v2\/posts\/18\/revisions"}],"wp:attachment":[{"href":"https:\/\/unixmonkey.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unixmonkey.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unixmonkey.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}