[Dbix-class] data access trough mysql stored procedures

Eisenberger Tamás tamas at eisenberger.hu
Sat Nov 21 17:54:26 GMT 2009


Hy!

I have a web application that I protected with an authentication system
entirely written in mysql, so mysql's stored procedures does the
authentication, the session id generation and the privilege checking...

I have four sp for every table, to handle select insert update and
delete actions... And every sp that requires user rights will get a
session id as first parameter and checks if the user can do the action
or not.

This way the mysql user that used by the site can be completely
unprivileged!

Recently I decided to rewrite the application in an object oriented way
to get an easier maintainable solution, and I found catalyst and
dbix::class should be really useful! I was reading around them for days,
and I now have a concept how my application should be ported around
these tools, the only problem is my authentication mechanism what I
don't want to abandon!

So the question is that: Can I tell dbix::class somehow to use my stored
procedures for it's select, insert, update and delete actions?

---
I've got an answer to the above message on the catalyst list that I should =
follow this doc page: http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class=
/Manual/Cookbook.pod#Using_database_functions_or_stored_procedures

But it seems that it only shows how I can call a single tored procedure.

Thanks for helping me!

P.S.: Sorry because my baaad English!

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 4813 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20091121/17=
ba5ab0/smime.bin


More information about the DBIx-Class mailing list