[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