[Dbix-class] custom result source calling a stored procedure
melutovich at gmail.com
Tue Jun 10 11:18:29 GMT 2014
For a customer result source, I know we can do something such as:
$new_source->name( \<<SQL );
( SELECT u.* FROM user u
INNER JOIN user_friends f ON u.id = f.user_id
WHERE f.friend_user_id = ?
SELECT u.* FROM user u
INNER JOIN user_friends f ON u.id = f.friend_user_id
WHERE f.user_id = ? )
is there any restrictions on the SQL; is it possible to have the SQL just
be a call to a stored procedure?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the DBIx-Class