• last updated 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
- Add SQL schema acs_permission to allow to call sql-functions for

Oracle and PostgreSQL in exactly the same way

- Move postgres permission function to the new neamespace and provide

stubs for backward compatibility

- New function permission::get_parties_with_permission

to support a restricted form of reverse lookup for permssions

in order to reduce the dependencies on

acs_object_party_privilege_map for PostgreSQL

- make upgrade scripts more robust (support repeated loading)

- bump verison number of acs-tcl to 5.9.1d9

- bump version number of acs-kernel to 5.9.1d11

  1. … 12 more files in changeset.
- replace obsolete all_object_party_privilege_map by acs_object_party_privilege_map

merge of 4.6.3b1 to HEAD

  1. … 107 more files in changeset.
Moved over my new permissions stuff plus improved file storage stuff (mostly

speed improvements in PG-land)

  1. … 17 more files in changeset.
1. Got rid of the "create or replace function" decls used for triggers, due

to the brand-new PG 7.3 "opaque" vs. "trigger" issue.

2. Added a new "fs::get_folder_object_ids" for use when you just need the

object ids rather than a bunch of (slow) permissions information,

(slow) counts of items in folders and subfolders, last modified info,

etc. dotLRN was calling "fs::get_folder_contents" when cloning folders

despite making use of only the object_id and that proc used to be unimaginably

slow. It's faster now due to the new permissions code but it's still slow

enough to warrant avoiding it when possible.

3. Fixed typo in my last commit.

  1. … 4 more files in changeset.
1. Fixed a couple of typos in file storage

2. New fast permissions stuff (PG only thus far)

2. While poking around CMS code looking for things that needed recreating

due to the permissions upgrade, changed over to "create or replace function"

  1. … 23 more files in changeset.

First round of speedups for verious permissions issues. Key finding is that

the all_object_party_privilege_map is speedy in PostgreSQL and apparently in

Oracle, as well (having re-read some of the optimization threads).

  1. … 23 more files in changeset.
query extractor output for acs-tcl

    • -0
    • +30
    ./acs-kernel-procs.xql
  1. … 41 more files in changeset.