On Fri, Feb 11, 2011 at 20:20, Trevor Leffler <tleff...@uw.edu> wrote: > Hello, > > I am investigating whether DBIC has support for switching between logical > databases (ala 'use db1; ...; use db2; ...;'). I've a situation where there > exist many cloned databases (same DDL), one per customer. The current model > is that all customers share the same front-end, and it switches between DBs > as needed. I would like to avoid the following: multiple open connections > per app process, multiple MyDB::Schema objects, server hups upon customer > adds/drops, etc. > > The very reasonable suggestion to combine all of the client databases into > one is being considered, so please let's not get side-tracked by that line > of thought, thanks. :) > > So... how might I have my Schema issue a 'use $db' prior to any queries? Or > perhaps are there other solutions to how one could have multiple DB clones > while avoiding the code and connection scaling issues?
Have you considered $schema->storage->dbh_do("use $db") ? Rob _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk