[Tickets #6150] Permission sql driver

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=6150
-----------------------------------------------------------------------
 Ticket             | 6150
 Created By         | Duck <duck at obala.net>
 Summary            | Permission sql driver
 Queue              | Horde Framework Packages
 Version            | HEAD
 Type               | Enhancement
 State              | New
 Priority           | 1. Low
 Milestone          | 
 Patch              | 
 Owners             | 
+New Attachment     | perms.tgz
-----------------------------------------------------------------------


Duck <duck at obala.net> (2008-01-25 11:34) wrote:

Another attempt minimize my DB load is moving permissions outside DT.
Permission actually uses only id, name, parents and data colum for
serialize its attributes. So with this driver you get a very small and fast
table loading only the data needed when needed. And even loads and connect
the db objeject only when need, as the comon calls are only hasPermission
and exists and if you use cache you will never build anoter DB conenction
to check a premission.

You also need the apply the perms.diff to the permissions UI as one
datatree call is harcoded. As the permission driver, but this you must
change it by your own.

Files:
- perms.sql, horde_perms table structure
- migrate.php: moves your current permissons to a flat table
- perms.diff current UI fix
- sql.php driver to out in Horde/Perms/sql.php
- test.php, runs all driver methods for result coparations