Re: prefixing table names?

[prev] [thread] [next] [Date index for 2004/10/15]

Quoting bowen@xxxxxx.xxx:

> I may well be mistaken, but offhand I don't see any easy way to add a prefix
> to a group of table names for a Class::DBI application (i.e. siesta_*). This
> is a pretty basic requirement for multiple apps to co-exist in a single
> database. I know that of course one can use multiple db's, _if_ you have
> access to multiples, but it's often much easier just to use one. Makes joins
> easier too.
>
> Is table name prefixing hiding somewhere? Perhaps someone else is already
> working on this?
>


When i submitted my LIMIT patch to C::DBI::MySQL i tried to bring up a related
issue.  Basically, the main problem i see with C::DBI is that all of the sql
generation is in a big function inside C::DBI.  This means that subclassers
need to reimplement the whole thing just to add something at the beginning or
the end of the query.

If we could break up the generation into smaller functions with some sort of map
that defines function A calls function B calls function C, etc, then we could
make DB specific subclasses much much easier and take more advantage of what
each DB has to offer.

Tony, this becomes a question for you, then.  What do you think it would take to
componentize the SQL generation?  Are you (is anyone) interested in this at all?

This may make it easier to do what bowen wants, as well.

-jason gessner
    jason@xxxxxxxx.xxx

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.