<div dir="ltr">The best way to execute your stored proc is to get the database handle and call stored proc, for more details see here<br><br><a href="https://metacpan.org/pod/DBIx%3a%3aClass%3a%3aStorage%3a%3aDBI#dbh_do">https://metacpan.org/pod/DBIx%3a%3aClass%3a%3aStorage%3a%3aDBI#dbh_do</a><br>
</div><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><div><br></div>Best Regards, <br>Sheeju Alex<br>
<div style="display:inline"></div></div></div>
<br><br><div class="gmail_quote">On Tue, Jun 10, 2014 at 10:13 PM, Mitchell Elutovich <span dir="ltr"><<a href="mailto:melutovich@gmail.com" target="_blank">melutovich@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Will misunderstood my question instead of the SELECT ... <div><br></div><div>can I do something like?<div><br></div><div><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13.333333969116211px">$new_source->name( \<<SQL );</span><br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13.333333969116211px">
call mystoredproc(?);<br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13.333333969116211px"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13.333333969116211px">SQL</span><br></div>
<div><br></div></div><div><br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Jun 10, 2014 at 7:59 AM, Will Crawford <span dir="ltr"><<a href="mailto:billcrawford1970@gmail.com" target="_blank">billcrawford1970@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">$users->search (<br>
[<br>
{ 'user_friends.user_id' => $id },<br>
{ 'user_friends.friend_user_id' => $id }<br>
], {<br>
join => 'user_friends'<br>
}<br>
)->all<br>
<div><div><br>
<br>
<br>
On 10 June 2014 12:18, Mitchell Elutovich <<a href="mailto:melutovich@gmail.com" target="_blank">melutovich@gmail.com</a>> wrote:<br>
> For a customer result source, I know we can do something such as:<br>
><br>
> $new_source->name( \<<SQL );<br>
> ( SELECT u.* FROM user u<br>
> INNER JOIN user_friends f ON <a href="http://u.id" target="_blank">u.id</a> = f.user_id<br>
> WHERE f.friend_user_id = ?<br>
> UNION<br>
> SELECT u.* FROM user u<br>
> INNER JOIN user_friends f ON <a href="http://u.id" target="_blank">u.id</a> = f.friend_user_id<br>
> WHERE f.user_id = ? )<br>
> SQL<br>
><br>
> is there any restrictions on the SQL; is it possible to have the SQL just be<br>
> a call to a stored procedure?<br>
><br>
</div></div>> _______________________________________________<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:<br>
> <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>
</blockquote></div><br></div>
</div></div><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></blockquote></div><br></div>