Why? Sounds like a *very* bad ERD! -Alex
-----Original Message----- From: Angel Kolev [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 12, 2007 4:15 PM To: Class user and developer list Subject: Re: [Dbix-class] all data at once Hi, i need genders in different tables. I forgot to notice, found solution for my problem: my $rs = $c->model('AppModelDB::Family')->search({family_id => undef},{join => ['female','male'], prefetch => ['female','male'] }); $rs->populate([{female=>{%females},%family,male=>{%males},}]); Hartmaier Alexander wrote: > > Hi! > > > > Why isn‘t the gender a simple attribute but instead two different tables? > > > > -Alex > > > > *From:* Angel Kolev [mailto:[EMAIL PROTECTED] > *Sent:* Saturday, December 08, 2007 4:37 PM > *To:* dbix-class@lists.scsys.co.uk > *Subject:* [Dbix-class] all data at once > > > > Hi, All. Im new in DBIx::Class and this is my first question here :) > I write catalyst app and use dbic for 3 tables (males,females,family) > with has_many and may_to_many. All works, but there are too many > requests to my database when i use this: > my $rs = $c->model('AppModelDB::ClientMale')->search(); > while (my $line = $rs->next) { > push @{$families},[ $line->client_family->first->id, > make_family( > $line->first_n, > $line->family_n, > $line->client_female->first->first_n, > $line->client_female->first->family_n > ) > ,$line->client_family->first->city > ,$line->client_family->first->zip_code > ,$line->client_family->first->municipality > ,$line->client_family->first->street > ,$line->client_family->first->public_place_type > ,$line->client_family->first->public_place_name > ]; > } > } > $c->stash->{families} = $families; > > I wrote "export DBIC_TRACE=1" for debug and saw alot of screens with > SELECT requests to MySQL. Plese help me to optimize the code. Every > single table has around 190 lines. > Thank you > > ------------------------------------------------------------------------ > > _______________________________________________ > 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] _______________________________________________ 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]
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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]
