Re: how to switch a view easily?

[prev] [thread] [next] [Date index for 2005/04/20]

How about moving deleted bookings to a separate deleted_bookings table?
you will make an extra query against the database if they want to see 
deleted bookings.


On Wed, 19 Apr 2005, Randal L. Schwartz wrote:

> 
> My $client has an app with "Booking" being a centrally important
> joining table (lots of has-many's on both sides).  One of the fields
> of Booking indicates whether the Booking has been deleted.  Now
> $client wants entire app to have two modes... "include deleted
> bookings" and "exclude deleted bookings".
> 
> Other than changing all my nice nifty working code to include huge
> amounts of new ->search_where's everywhere... is there some easy
> method I can use instead?
> 
> Certainly I can't be the first one to need this. :)
> 
> -- 
> Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
> <merlyn@xxxxxxxxxx.xxx> <URL:http://www.stonehenge.com/merlyn/>
> Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
> See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!
>