gmane.comp.lang.ruby.rails

Shngn | 16 May 01:10

ANNOUNCE: act_as_soft_deletable - new rails plugin for soft deleting / disabling ActiveRecord models


Acts_as_soft_deletable is a rails plugin that provides the ability to
soft delete or disable models.

When models are destroyed, they will be archived so that they can
later be restored easily. Its similar to acts_as_paranoid but uses a
different approach that should make it a little more foolproof.

See the README at the following url for a better description.

github url: http://github.com/ajh/acts_as_soft_deletable/tree/master

Feedback is always appreciated.

Thanks,

Andy Hartford
Substantial
hartforda@...

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

headers

Danimal | 16 May 22:13

Re: ANNOUNCE: act_as_soft_deletable - new rails plugin for soft deleting / disabling ActiveRecord models


Andy,

This looks awesome! Thanks for putting it together. I really like the
idea of keeping deleted items in separate tables so all the rest of
the AR stuff works as expected. Nice!

One thing I thought of while reading your README:

If you define your "Deleted" tables in a migration, why not build it
so that any future migrations would automatically adjust the deleted
tables? This may be more code on your end as you'd probably have to
either monkeypatch or just hook into the migration process, but it
couldn't be too hard. Pseudocode wise it would probably look like:

in "self.up", if a modification to table X occurs, check if there is
an X::Deleted table. If so, make the same modifications to X::Deleted

The beauty of doing this would be that you define your "deletable"
tables at the beginning, then just forget about 'em... So future
migrations are just normal migrations.

Just a thought, anyway. I'll be adding your plugin to some projects
I'm working on... and ditching my "acts_as_paranoid"-like hacks.

Thanks!

-Danimal

On May 15, 5:11 pm, Shngn <hartfo...@...> wrote:

(Continue reading)

headers

Danimal | 16 May 22:20

Re: ANNOUNCE: act_as_soft_deletable - new rails plugin for soft deleting / disabling ActiveRecord models


One other thought:

What if you extended this, either as a second plugin, or just
additional features, to add "acts_as_archivable"? Which is effectively
the same thing, but instead of thinking in terms of "delete" and
"undelete", it's "archived" or not.

And, I could see some cool hooks you could do. Like adding some cool
find mods. Off the top of my head:

Assuming I have a Post model with lots of posts, I might want to do
something like:

Post.find_and_archive(:all, :conditions => ["created_at < ?",
1.month.ago])

This would return an array of post objects that are older than 1
month, but it would also "move" them from the posts table to the
archived_posts table.

The other cool thing is that you could then make wicked simple rake
tasks to do archival maintenance.

Maybe even some hooks so that you could do "global" finds... i.e.
finds that would aggregate the X and archived_X tables.

Post.find_with_archive_by_author("John Do") # => would find all posts
from the "posts" table AND the "archived_posts" table

(Continue reading)

headers

Shngn | 19 May 02:23

Re: ANNOUNCE: act_as_soft_deletable - new rails plugin for soft deleting / disabling ActiveRecord models

On May 16, 1:13 pm, Danimal <fightonfightw...@...> wrote:
> If you define your "Deleted" tables in a migration, why not build it
> so that any future migrations would automatically adjust the deleted
> tables?

Yeah, that's a good idea. I did something similar with the
update_columns class method, but your way is definitely slicker. One
thing makes me a little uncomfortable though. If the migration drops a
column, and it automatically gets dropped from the archive table then
data is irretrievably lost. I can't decide if that's a bad thing, I'd
love to get your thoughts on that.

> What if you extended this, either as a second plugin, or just
> additional features, to add "acts_as_archivable"?Which is effectively
> the same thing, but instead of thinking in terms of "delete" and
> "undelete", it's "archived" or not.

I originally intended to make an acts_as_paranoid replacement that
worked with rails 2.0 and I got stuck in the 'deleted' paradigm. Now
that you point it out I agree 'archive' is a better metaphor. I'll
have to think about whether I want to go through the trouble to rename
everything :)

> Post.find_with_archive_by_author("John Do") # => would find all posts
> from the "posts" table AND the "archived_posts" table

This is a cool idea too! Its not obvious to me how I'd implement this.
My first thought is method_missing so I could handle methods that
start like 'find_with_archive...'. But I would need a way to decline

(Continue reading)

headers

Danimal | 19 May 04:05

Re: ANNOUNCE: act_as_soft_deletable - new rails plugin for soft deleting / disabling ActiveRecord models


Andy,

Some thoughts to keep this conversation going...

1) Migrations:

A couple of thoughts. First, you could just figure that if someone is
using your plugin and has set the "Archived" tables in their initial
migrations, then they are aware of what deleting columns would mean.
So you could go that route.

Another thought would be to offer some sort of warning... i.e. running
a migration that removes columns would give a warning... which could
be overridden by a flag or even some environment setting.

Another option, although very complex, would be to monkeypatch AR so
that deleting columns doesn't actually delete them but "hides" them.
But the more I think about that, the less I like it.

Ultimately, I'd just go with the first option. If you think about it,
the value here is storing record data beyond the "delete" point (I
like "archive" better). So if the "structure" of the data is changed,
that change should be allowed (in this case, removing columns as part
of a migration). It's the rows of data, if you will, that you want to
maintain. I think if the programmer knows enough to use your plugin
and define the extra tables, then they should be aware and willing to
accept that removing columns means removing them from the
"Deleted" (or "Archived") tables.

(Continue reading)

headers

Shngn | 19 May 19:26

Re: ANNOUNCE: act_as_soft_deletable - new rails plugin for soft deleting / disabling ActiveRecord models

On May 18, 7:05 pm, Danimal <fightonfightw...@...> wrote:
> 1) Migrations:
> Another thought would be to offer some sort of warning... i.e. running
> a migration that removes columns would give a warning... which could
> be overridden by a flag or even some environment setting.

I like the warning approach that can be disabled. With that in place,
I don't mind automatically syncing tables rather than the manual
#update_columns call. I'll try to get these changes implemented soon.

> You might even do some plugin research and find some
> others that do some custom Find calls and use that as a starting
> point.

Thats a good idea. I'll look around for that. Maybe someone reading
this thread can suggest something?

> 4) File-based Archival
>
> I could even imagine adding some hook whereby the archival takes
> records from the DB and dumps them to some flat-file, or XML, or CSV
> or some such format. This may not be necessary... but I can imagine
> some possible use. I.e. where you "archive" (to the archive tables)
> posts older than 3 months, but you "flat-file-archive" posts older
> than 1 year. Just an idea, though... maybe it's not that useful.

It would also be possible to write a rake task to dump the archival
tables with mysqldump or the equivalent.

(Continue reading)

headers

Danimal | 19 May 20:13

Re: ANNOUNCE: act_as_soft_deletable - new rails plugin for soft deleting / disabling ActiveRecord models


Andy,

This is good stuff. Keep at it!

I probably won't be able to fiddle with it for a week or so, but it's
definitely a plugin that will be useful in at least one of my projects
(as I mentioned before).

Thanks again for doing this and offering it to the world.

-Danimal
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

headers

Shngn | 30 May 00:48

Re: ANNOUNCE: act_as_soft_deletable - new rails plugin for soft deleting / disabling ActiveRecord models


Danimal, I added some of the features you suggested.

I added a find method like ActiveRecord#find that will return deleted
records as well, it's called find_with_deleted. I also added support
for dynamic finders like find_all_with_deleted_by_name_and_date(name,
date).

I added a warning to the update_column migration method that warns
when columns are deleted. The warning can be disabled. I'm still
looking into automatically syncing the tables when the live table
changes.

Andy
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

headers

Dan Sharp | 30 May 02:21

Re: ANNOUNCE: act_as_soft_deletable - new rails plugin for soft deleting / disabling ActiveRecord models


Andy, this is awesome! Thanks for the hard work.

-Danimal

On Thu, May 29, 2008 at 4:48 PM, Shngn <hartforda@...> wrote:
>
> Danimal, I added some of the features you suggested.
>
> I added a find method like ActiveRecord#find that will return deleted
> records as well, it's called find_with_deleted. I also added support
> for dynamic finders like find_all_with_deleted_by_name_and_date(name,
> date).
>
> I added a warning to the update_column migration method that warns
> when columns are deleted. The warning can be disabled. I'm still
> looking into automatically syncing the tables when the live table
> changes.
>
> Andy
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

(Continue reading)

headers

Walter McGinnis | 31 May 02:12

Re: ANNOUNCE: act_as_soft_deletable - new rails plugin for soft deleting / disabling ActiveRecord models

Andy,

So you are sticking with the acts_as_soft_deleteable name for the plugin? I've got a piece of work coming up that will be using it and I just want to be sure I get synced up with the correct code.

Cheers,

Walter

http://kete.net.nz/

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

headers

Shngn | 2 Jun 19:42

Re: ANNOUNCE: act_as_soft_deletable - new rails plugin for soft deleting / disabling ActiveRecord models


Walter,
Yeah, I'm going to keep the name. I was considering acts_as_archivable
but that's already taken by another plugin which does something
completely different ;)

I'd love to hear any ideas or feedback you have once you start using
it!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

headers

Walter McGinnis | 2 Jun 23:44

Re: ANNOUNCE: act_as_soft_deletable - new rails plugin for soft deleting / disabling ActiveRecord models

Great. Good to know. I plan to use it on a join model, actually. A related links type thing. Will let you know.

Cheers,

Walter

On Tue, Jun 3, 2008 at 5:42 AM, Shngn <hartforda-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:

Walter,
Yeah, I'm going to keep the name. I was considering acts_as_archivable
but that's already taken by another plugin which does something
completely different ;)

I'd love to hear any ideas or feedback you have once you start using
it!

headers

Clever Neologism | 3 Jun 16:58

Re: ANNOUNCE: act_as_soft_deletable - new rails plugin for soft deleting / disabling ActiveRecord models

Sounds neat!

On the archival angle, something I have been wishing for for a while
now is an archival plugin/system that does the following:

1) Tiered time-based (or, really, on any column, I just can't think
for a use for anything other than created/updated_at columns)
backups.  For example,  move everything over 6 months old to another
table, move everything over a year old to a secondary database.
2) Multiple data stores (multiple DBs, file stores, ???) for
flexibility.
3) The ability to daemonize and run it external to the running web
framework itself (like a cron job) so its transparent to the users of
the system), and the ability to do on-demand archiving in-framework
4) Adds in archival find methods to AR objects marked as archivable,
adds in individual archive/unarchive commands, etc.
5) Updating records in the archives should move them back to the main
table automagically (this could be configurable)

I have programmed multiple order processing systems, and every time I
have yearned for such a thing.  Unfortunately, I am really not good
enough with the guts of RoR to pull this off :(.

On Jun 2, 5:44 pm, "Walter McGinnis" <walter.mcgin...@...>
wrote:
> Great.  Good to know.  I plan to use it on a join model, actually.  A
> related links type thing.  Will let you know.
> Cheers,
> Walter
>
> On Tue, Jun 3, 2008 at 5:42 AM, Shngn <hartfo...@...> wrote:
>
> > Walter,
> > Yeah, I'm going to keep the name. I was considering acts_as_archivable
> > but that's already taken by another plugin which does something
> > completely different ;)
>
> > I'd love to hear any ideas or feedback you have once you start using
> > it!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

headers

Ar Chron | 3 Jun 18:33

Re: ANNOUNCE: act_as_soft_deletable - new rails plugin for s


Shngn wrote:
> I'd love to hear any ideas or feedback you have once you start using
> it!

I'll try to start using it this week...  I'd been tinkering with the 
idea of a soft delete via a 'visible' flag or something, but didn't 
really like that idea.

Your work looks like just the ticket!
--

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---