[Catalyst] data access trough mysql stored procedures
tamas at eisenberger.hu
Sat Nov 21 01:18:05 GMT 2009
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
This way the mysql user that used by the site can be completely
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?
Thanks for helping me!
P.S.: Sorry because my baaad English!
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 4813 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.scsys.co.uk/pipermail/catalyst/attachments/20091121/14f2=
More information about the Catalyst