<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">I often build a map and use this also for an exist()-check (not for bigdata)</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">my %email_for =</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"> map { $@_ }</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"> $rs</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"> ->search(</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"> undef,</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"> {</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"> select => qw[ user_id email ],</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"> },</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"> )</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"> ->cursor</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"> ->all</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"> ;</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">only important is to use exact 2 fields in the select.</div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature">
<span style="font-family:arial,sans-serif"><br><br>Mit freundlichem Gruß<br>Felix Ostmann<br></span><br></div></div>
<br><div class="gmail_quote">2015-02-13 12:13 GMT+01:00 Ekki Plicht (DF4OR) <span dir="ltr"><<a href="mailto:ekki@plicht.de" target="_blank">ekki@plicht.de</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Ooookay... that's a lot of very helpful answers. Many thanks for all<br>
the suggestions, I guess I will go with the helper or with count().<br>
<br>
Thanks,<br>
Ekki<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
2015-02-13 11:32 GMT+01:00 Will Crawford <<a href="mailto:billcrawford1970@gmail.com">billcrawford1970@gmail.com</a>>:<br>
> On 11 February 2015 at 21:58, Ekki Plicht (DF4OR) <<a href="mailto:ekki@plicht.de">ekki@plicht.de</a>> wrote:<br>
>> Hi,<br>
>> I need to check a list of values if they exist in a database. The<br>
>> value is a unique key of that table. A stupid 'find' works of course,<br>
>> but returns the whole row data, where I only need a simple binary<br>
>> yes/no information if a row was found or not.<br>
><br>
> Presuming you mean that you need to get a list of them all, there's a<br>
> few answers, depending on your needs. A couple of the answers already<br>
> given are pretty useful and I'll be filing the "exists" rs method away<br>
> for future use.<br>
><br>
> Something like<br>
><br>
> my %found = map +( $_ => 1 ),<br>
> $rs->search_rs( { key => { -in => [ ... ] } } )->get_column('key')->all;<br>
><br>
> might do the trick (not tested for typos).<br>
><br>
> _______________________________________________<br>
> List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a><br>
> IRC: <a href="http://irc.perl.org#dbix-class" target="_blank">irc.perl.org#dbix-class</a><br>
> SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/" target="_blank">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a><br>
> Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk" target="_blank">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a><br>
<br>
_______________________________________________<br>
List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a><br>
IRC: <a href="http://irc.perl.org#dbix-class" target="_blank">irc.perl.org#dbix-class</a><br>
SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/" target="_blank">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a><br>
Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk" target="_blank">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a><br>
</div></div></blockquote></div><br></div></div>