6.0.0-beta1
7/9/25

[#6150] Permission sql driver
Summary Permission sql driver
Queue Horde Framework Packages
Queue Version HEAD
Type Enhancement
State Resolved
Priority 1. Low
Owners chuck (at) horde (dot) org
Requester duck (at) obala (dot) net
Created 01/25/2008 (6375 days ago)
Due
Updated 04/10/2008 (6299 days ago)
Assigned 04/10/2008 (6299 days ago)
Resolved 04/10/2008 (6299 days ago)
Milestone
Patch Yes

History
04/10/2008 05:21:47 AM Chuck Hagenbuch Comment #10
State ⇒ Resolved
Reply to this comment
Just needed to run horde-merge.php on this commit:

http://lists.horde.org/archives/cvs/Week-of-Mon-20080407/077159.html
04/10/2008 04:51:15 AM Ben Klang Comment #9
State ⇒ Assigned
Reply to this comment
It looks like the SQL schema to create tables was omitted from the 
3.1_to_3.2 upgrade script.  The schema also does not appear in the 
scripts/sql directory.  This is in a FRAMEWORK_3 checkout from tonight.
04/08/2008 04:59:13 PM Chuck Hagenbuch Comment #8 Reply to this comment
Fixed, thanks
04/08/2008 08:21:52 AM Duck Comment #7 Reply to this comment
Committed, with a bunch of work on Perms and Share to get datatree
dependencies/references out and make this work without them. Thanks!
There is still a reference to DataTree::encodeName in the 
horde/admin/perms/add_child.php.
04/08/2008 06:26:25 AM Chuck Hagenbuch Comment #6
Assigned to Chuck Hagenbuch
State ⇒ Resolved
Reply to this comment
Committed, with a bunch of work on Perms and Share to get datatree 
dependencies/references out and make this work without them. Thanks!
04/07/2008 12:43:52 AM Chuck Hagenbuch Comment #5 Reply to this comment
Added the SQL scripts and upgrade instructions.
04/04/2008 06:03:53 PM Chuck Hagenbuch Comment #4 Reply to this comment
I've committed the UI.php and datatree.php changes as they make sense 
even without the rest of this (though I'm working on the full patch 
too). Thanks again.
02/25/2008 06:53:50 PM Chuck Hagenbuch State ⇒ Accepted
 
02/25/2008 01:05:00 AM Jan Schneider Patch ⇒ Yes
 
02/25/2008 01:04:50 AM Jan Schneider Deleted Original Message
 
01/27/2008 11:11:28 AM Duck Comment #3
New Attachment: sql[1].php Download
Reply to this comment
Cache key fix.

Works on all my installations.
01/26/2008 11:23:08 AM Duck Comment #2
New Attachment: sql.php
Reply to this comment
Fix adding permissions to the top level.



Finished.
01/25/2008 04:34:13 PM Duck Comment #1
Priority ⇒ 1. Low
State ⇒ New
New Attachment: perms.tgz Download
Queue ⇒ Horde Framework Packages
Summary ⇒ Permission sql driver
Type ⇒ Enhancement
Reply to this comment
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

Saved Queries