[Dbix-class] how to execute stored procedures in DBIx::Class
Michele Beltrame
mb at italpro.net
Tue Dec 26 09:29:35 GMT 2006
Hello Wan!
> In MySQL 5.0.x, I have created a procedure named boardslist, like this
Do you really need a stored procedure for this task? If not, you can
create a MySQL view and then wrap in it a schema class, so that you'll
be then able to do this with DBIx::Class:
$c->model('DB::Boardslist')->search({userId => 1});
or, without creating the view at all, provide a custom search method for
the Boards schema class.
Michele.
--
Michele Beltrame
http://www.varlogarthas.net/
ICQ# 76660101
Informativa privacy: http://www.italpro.net/em.html
More information about the Dbix-class
mailing list