[SP-pm] Catalyst DBIx -> lista alguns campos

[Renato Santos]

vc precisa definir os alias para os campos!

*NOTE:* You will almost always need a corresponding
"as"<http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#as>
attribute
when you use "select"<http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#select>,
to instruct DBIx::Class how to store the result of the column. Also note
that the "as"<http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#as>
attribute
has nothing to do with the SQL-side 'AS' identifier aliasing. You can
however alias a function, so you can use it in e.g. an ORDER BY clause.
This is done via the -as *select function attribute* supplied as shown in
the example above.


2012/8/20 Jose Nilton <jniltinho at gmail.com>

> Então eu posso fazer desse modo:
>
> $resultset->search ( undef,  {  select => [qw/ id login email active /] }
> )
>
> $rs = $schema->resultset('Employee')->search(undef, { select => ['name']});
>
>
>
>
> Em 20 de agosto de 2012 16:54, Renato Santos <renato.cron at gmail.com>escreveu:
>
> vc usa o $resultset->search ( undef,  {  select => [qw/ id login email
>> active /], as => [qw/o_aidi o_login o_email active/]  }
>>
>> lembrando que os prefetchs são tratados separadamente.
>>
>> Todos atributos estão em:
>>
>> http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#ATTRIBUTES
>>
>> vc tbm pode usar '+select' e '+as' pra adicionar mais campos na query.
>>
>>
>> 2012/8/20 Jose Nilton <jniltinho at gmail.com>
>>
>>> Boa tarde a todos,
>>>
>>> Gostaria de saber como eu faço para listar só alguns campos da tabela:
>>>
>>> Exemplo:
>>>
>>> Banco: agencia
>>> Tabelas: users
>>> Campos: id, login, email, password, adm, active, create.
>>>
>>> Não quero selecionar todos os campos, quero id, login, email, active.
>>>
>>> Obrigado
>>>
>>> --
>>> .................................................................
>>>   "Com Deus todas as coisas são possíveis"
>>>
>>> =begin disclaimer
>>>    Sao Paulo Perl Mongers: http://sao-paulo.pm.org/
>>>  SaoPaulo-pm mailing list: SaoPaulo-pm at pm.org
>>>  L<http://mail.pm.org/mailman/listinfo/saopaulo-pm>
>>> =end disclaimer
>>>
>>>
>>
>>
>> --
>> Saravá,
>> Renato CRON
>> http://www.renatocron.com/blog/
>> @renato_cron <http://twitter.com/#%21/renato_cron>
>>
>>
>> =begin disclaimer
>>    Sao Paulo Perl Mongers: http://sao-paulo.pm.org/
>>  SaoPaulo-pm mailing list: SaoPaulo-pm at pm.org
>>  L<http://mail.pm.org/mailman/listinfo/saopaulo-pm>
>> =end disclaimer
>>
>>
>
>
> --
> .................................................................
>   "Com Deus todas as coisas são possíveis"
>
> =begin disclaimer
>    Sao Paulo Perl Mongers: http://sao-paulo.pm.org/
>  SaoPaulo-pm mailing list: SaoPaulo-pm at pm.org
>  L<http://mail.pm.org/mailman/listinfo/saopaulo-pm>
> =end disclaimer
>
>


-- 
Saravá,
Renato CRON
http://www.renatocron.com/blog/
@renato_cron <http://twitter.com/#!/renato_cron>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/saopaulo-pm/attachments/20120820/5e38047a/attachment.html>