Nope :) That will manage our clients.
2007/12/12, Benjamin Hitz <[EMAIL PROTECTED]>: > > > I am going to take a WFG, and say "Dating Site". > > Ben > > > 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:* [email protected] > >> *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/dbix- > >> [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/dbix- > > [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/dbix- > > [EMAIL PROTECTED] > > -- > Ben Hitz > Senior Scientific Programmer ** Saccharomyces Genome Database ** GO > Consortium > Stanford University ** [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] >
_______________________________________________ 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]
