Re: how to switch a view easily?

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

>>>>> "Mark" == Mark Addison <mark.addison@xxx.xx.xx> writes:

Mark> What database is this running on? Specifically does it have views?
Mark> If so could you create views for the 2 sets and then use a quick
Mark> sub-class that just changes the table (view) it uses. Then all your
Mark> nifty code is shared by both and the mode can be set by the class you
Mark> use.

Yeah, thought of that, but then I run into a problem with updates,
since views are read-only.  I do things like this:

        for my $booking ($other->bookings) { # don't wanna see cancelled here
          $booking->some_column($new_value); # boom, go bye bye!
        }

The solution I'm going to try in a few moments is to create a view of
just livebooking, then override transform_sql to
s/\bbooking\b/livebooking/g, but only when /^select/i, which should
ignore updates and inserts.  That way I don't have to worry about
some handwritten SQL that looks like

SELECT ... FROM booking b, address a ...

because my previous plan was to replace that "booking" with

  (select * from booking where cancelled_date is null) as booking

and then you got that "b" out there which is not going to work well. :)

        -- 
        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!