--- On Mon, 5/12/08, James Kiser <[EMAIL PROTECTED]> wrote: > From: James Kiser <[EMAIL PROTECTED]> > Subject: [Dbix-class] arbitrary table names - best practice? > To: [email protected] > Date: Monday, May 12, 2008, 8:51 PM > I have a database that contains a few thousand tables that > all share > the same structure. They are all named as > [db].[table][unique > number]. The unique number is basically the primary key to > another > table which is used to define the 'relationship'. > > Obviously, I don't want to create a class for each > table and would > ideally like to have one class that will dynamically use > the > appropriate table based on the primary key (unique number) > that I > have. The right answer is to redesign the schema and there > are plans > to do this. However, I need a solution I can work with > until those > changes take place. > > I have a working solution based off of > DBIx::Class::Schema::Loader > using the constraint option. Is using > DBIx::Class::Schema::Loader the > *best way* to handle this situation? Has anyone else had > to implement > something similar? Are there any other alternatives? > > Thanks in advance, > James >
I'm not sure if there is a better way to do this, but I'd sure like to see an article/blog/something about you using Perl and DBIC to deal with a DB with a few thousand tables. I wonder if Rails/ActiveRecord could even come close to starting up under such conditions :) Good Luck, John > _______________________________________________ > 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/[EMAIL PROTECTED] ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ _______________________________________________ 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/[EMAIL PROTECTED]
