--- John Siracusa <[EMAIL PROTECTED]> wrote:
> On 3/16/07 3:34 PM, Fred Cox wrote:
> > Ideally, I would like to have RDB know to ATTACH
> the second database and treat
> > the two files as one.
> >
> > From what I can tell of the SQLite database, in
> the case where the table names
> > are unique, the only complication is that all the
> sqlite_master tables would
> > need to be queried by RDBO::Loader (I'm guessing
> without yet having looked at
> > the code).
> >
> >
>
http://www.mail-archive.com/[email protected]/msg18562.html
> >
> > Is this already supported, or would it be easy to
> make RDB and RDBO::Loader do
> > the right things?
>
> It's no supported AFAIK (this is the first I've
> heard of it). I don't know
> how easy or hard it would be to do. What do you
> envision the interface to
> this functionality looking like?
>
Perhaps something like this in the Rose::DB subclass:
# Register your lone data source using the default
type and domain
__PACKAGE__->register_db
( 'driver' => 'sqlite',
'database' => [ 'main.sqlite',
'secondary.sqlite',
'tertiary.sqlite' ] );
I presume the Loader would need to know from the
Rose::DB object that it needs to query multiple
sqlite_master tables.
Thanks for considering this,
Fred
> -John
____________________________________________________________________________________
Now that's room service! Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rose-db-object
