Re: prefixing table names?

[prev] [thread] [next] [Date index for 2004/11/02]

From: Bowen Dwelle
Subject: Re: prefixing table names?
Date: 16:36 on 02 Nov 2004

perhaps slightly better...

in Email::Store::DBI

sub set_sql {
         my ($class, $name, $sql, $db, @others) = @_;
         my $prefix = __PACKAGE__->TABLE_PREFIX();
         $sql =~ s/(FROM) /$+ $prefix/sg;      # fragile!
         $class->SUPER::set_sql($name, $sql, $db, @others);
}

Bowen Dwelle wrote:
> This only leftover crud is in Email::Store::Entity:
> 
> ##############
> # BOWEN - HACK
> my $sql = q{
>     SELECT     DISTINCT entity id
>     FROM TABLE_PREFIX_addressing
>     WHERE name = ?    AND address = ?};
> my $prefix = Email::Store::DBI->TABLE_PREFIX();
> $sql =~ s/TABLE_PREFIX_/$prefix/sg;
> Email::Store::Entity->set_sql(distinct_entity => $sql);
> ##############
> 
> any clues?

(message missing)

prefixing table names?
bowen 15:20 on 15 Oct 2004

Re: prefixing table names?
jason 15:36 on 15 Oct 2004

Re: prefixing table names?
Tony Bowden 18:45 on 15 Oct 2004

SQL Generation ( was Re: prefixing table names?)
jason scott gessner 00:08 on 19 Oct 2004

Re: SQL Generation ( was Re: prefixing table names?)
Tony Bowden 07:48 on 19 Oct 2004

Re: SQL Generation ( was Re: prefixing table names?)
Jay Strauss 13:58 on 19 Oct 2004

Re: SQL Generation ( was Re: prefixing table names?)
Todd Holbrook 15:10 on 19 Oct 2004

Re: SQL Generation ( was Re: prefixing table names?)
merlyn (Randal L. Schwartz) 09:46 on 19 Oct 2004

Re: SQL Generation ( was Re: prefixing table names?)
merlyn (Randal L. Schwartz) 10:00 on 19 Oct 2004

Re: prefixing table names?
Tony Bowden 15:36 on 15 Oct 2004

Re: prefixing table names?
Bowen Dwelle 22:05 on 15 Oct 2004

Re: prefixing table names?
Bradley K. Embree 22:16 on 15 Oct 2004

Re: prefixing table names?
Bowen Dwelle 22:48 on 15 Oct 2004

Re: prefixing table names?
Bowen Dwelle 23:20 on 15 Oct 2004

Re: prefixing table names?
Perrin Harkins 16:44 on 15 Oct 2004

Re: SQL Generation ( was Re: prefixing table names?)
Tony Bowden 15:26 on 19 Oct 2004

FromCGI and Untaint question
Peter Speltz 17:23 on 19 Oct 2004

Re: prefixing table names?
Bowen Dwelle 01:31 on 02 Nov 2004

Re: prefixing table names?
Bowen Dwelle 16:36 on 02 Nov 2004