[Dbix-class] all data at once

[Benjamin Hitz]

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:ankolev at gmail.com]
> 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:ankolev at gmail.com]
>> *Sent:* Saturday, December 08, 2007 4:37 PM
>> *To:* dbix-class at 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/dbix- 
>> class at lists.rawmode.org
>
>
> _______________________________________________
> 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 at lists.rawmode.org
>
> _______________________________________________
> 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 at lists.rawmode.org

--
Ben Hitz
Senior Scientific Programmer ** Saccharomyces Genome Database ** GO  
Consortium
Stanford University ** hitz at genome.stanford.edu