Discard
Soft deletes for ActiveRecord done right.
What does this do?
A simple ActiveRecord mixin to add conventions for flagging records as discarded.
Why should I use this?
I've worked with and have helped maintain paranoia for a while. I'm convinced it does the wrong thing for most cases.
Paranoia and acts_as_paranoid both attempt to emulate deletes by setting a column and adding a default scope on the model. This requires some ActiveRecord hackery, and leads to some surprising and awkward behaviour.
- A default scope is added to hide soft-deleted records, which necessitates
adding
.with_deleted
to associations or anywhere soft-deleted records should be found. :disappointed:- Adding
belongs_to :child, -> { with_deleted }
helps, but doesn't work for joins and eager-loading.
- Adding
delete
is overridden (really_delete
will actually delete the record) :unamused:destroy
is overridden (really_destroy
will actually delete the record) :pensive:dependent: :destroy
associations are deleted when performing soft-destroys :scream:- requiring any dependent records to also be
acts_as_paranoid
to avoid losing data. :grimacing:
- requiring any dependent records to also be
There are some use cases where these behaviours make sense: if you really did want to almost delete the record. More often developers are just looking to hide some records, or mark them as inactive.
Discard takes a different approach. It doesn't override any ActiveRecord methods and instead simply provides convenience methods and scopes for discarding (hiding), restoring, and querying records.
Installation
Add this line to your application's Gemfile:
gem 'discard'
And then execute:
$ bundle
Usage
Declare a record as discardable
Declare the record as being discardable
class Post < ActiveRecord::Base
include Discard::Model
end
class AddDiscardToPosts < ActiveRecord::Migration[5.0]
def up
add_column :posts, :discarded_at, :datetime
end
end
Discard a record
Post.all # => [#<Post id: 1, ...>]
Post.kept # => [#<Post id: 1, ...>]
Post.discarded # => []
@post = Post.first # => #<Post id: 1, ...>
@post.discard!
@post.discarded? # => true
@post.discarded_at # => 2017-04-18 18:49:49 -0700
Post.all # => [#<Post id: 1, ...>]
Post.kept # => []
Post.discarded # => [#<Post id: 1, ...>]
From a controller
Controller actions need a small modification to discard records instead of deleting them. Just replace destroy
with discard
.
def destroy
@post.discard
redirect_to users_url, notice: "Post removed"
end
Working with associations
Under paranoia, soft deleting a record will destroy any dependent: :destroy
associations. Probably not what you want! This leads to all dependent records
also needing to be acts_as_paranoid
, which makes restoring awkward: paranoia
handles this by restoring any records which have their deleted_at set to a
similar timestamp. Also, it doesn't always make sense to mark these records as
deleted, it depends on the application.
A better approach is to simply mark the one record as discarded, and use SQL joins to restrict finding these if that's desired.
For example, in a blog comment system, with Post
s and Comment
s, you might
want to discard the records independently. A user's comment history could
include comments on deleted posts.
Post.kept # SELECT * FROM posts WHERE discarded_at IS NULL
Comment.kept # SELECT * FROM comments WHERE discarded_at IS NULL
Or you could decide that comments are dependent on their posts not being
discarded. Just override the kept
scope on the Comment model.
class Comment < ActiveRecord::Base
has_many :posts
include Discard::Model
scope :kept, -> { undiscarded.joins(:posts).merge(Post.kept) }
end
Comment.kept
# SELECT * FROM comments
# INNER JOIN posts ON comments.post_id = posts.id
# WHERE
# comments.discarded_at IS NULL AND
# posts.discarded_at IS NULL
SQL databases are very good at this, and performance should not be an issue.
In both of these cases restoring either of these records will do right thing!
Default scope
It's usually undesirable to add a default scope. It will take more effort to work around and will cause more headaches. If you know you need a default scope, it's easy to add yourself ❤.
class Post < ActiveRecord::Base
include Discard::Model
default_scope -> { kept }
end
Post.all # Only kept posts
Post.with_discarded # All Posts
Post.with_discarded.discarded # Only discarded posts
Custom column
If you're migrating from paranoia, you might want to continue using the same column.
class Post < ActiveRecord::Base
include Discard::Model
self.discard_column = :deleted_at
end
Non-features
- Restoring records (this will probably be added)
- Discarding dependent records (this will likely be added)
- Callbacks (this will probably be added)
- Special handling of AR counter cache columns - The counter cache counts the total number of records, both kept and discarded.
Development
After checking out the repo, run bin/setup
to install dependencies. Then, run rake test
to run the tests. You can also run bin/console
for an interactive prompt that will allow you to experiment.
Contributing
Bug reports and pull requests are welcome on GitHub at https://github.com/jhawthorn/discard.
License
The gem is available as open source under the terms of the MIT License.
Acknowledgments
- Ben Morgan who has done a great job maintaining paranoia
- Ryan Bigg, the original author of paranoia (and many things), as a simpler replacement of acts_as_paranoid
- All paranoia users and contributors