I wrote a blog post on the specifics of my method.
http://blog.afoolishmanifesto.com/archives/274. The only things that
are missing are a) configurability and b) a way to find deleted rows.
The first is just a matter of me reading the source code of more
Components, the second seems harder as I can't seem to pull it off
with the information that people on IRC are giving me. I'll email you
guys about the solution to that when I get it.
what if instead of
$_[0]->{deletion_date} = \"IS NULL";
You did
$_[0]->{deletion_date} ||= \"IS NULL";
thus not overriding merely specifying, so when you DO want to also see
deleted items,
->search({ deletion_date => \"deletion_date" });
David
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]