application-group-procs-oracle.xql

  • last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Reduce divergency between oracle and postgres codebase and bring portable sql inline

    • -39
    • +0
    ./application-group-procs-oracle.xql
  1. … 3 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

    • -46
    • +1
    ./application-group-procs-oracle.xql
  1. … 7834 more files in changeset.
- align with postgres

.xql overhaul:

- removed misleading sql-statements from db_* calls, which were

ignored due .xql files

- removed bug where same query name was used in a single proc

with different intended sql queries, but the same was picked

up from the .xql file due to the name

- removed multiple entries of same query name from .xql files

(e.g. the entry "package_create_attribute_list.select_type_info" was

7 (!!!) times in a single .xql file)

- removed redundant queries for unsupported versions of the dbms

- added missing xql entries for db-backends, where other db-specific

queries exists (e.g. added an entry to -oracle.xql, where an entry

existed in -postgres.xql)

    • -40
    • +0
    ./application-group-procs-oracle.xql
  1. … 70 more files in changeset.
track application group package change.

  1. … 1 more file in changeset.
fixing bug in query application_group::delete.delete - removing extra comma

merge all the changes on the oacs-5-1 and dotlrn-2-0 branches up to tag jcd-merge-20040420

  1. … 647 more files in changeset.
Fixed bug #1526

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

  1. … 275 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -32
    • +8
    ./application-group-procs-oracle.xql
  1. … 107 more files in changeset.
You can once again mount/dismount subsites and delete of subsite works in

the simple case (i.e. when you've deleted everything you've added to it

via the site map or group/user/relseg admin UI)

    • -19
    • +13
    ./application-group-procs-oracle.xql
  1. … 12 more files in changeset.
1. Peter's APM changes broke subsite mounting because the old post

instantiate routine wasn't really called until after the site node for

the subsite was mounted. No problem - I changed it to be an after-mount

callback instead (which was the idea all along)

2. Earlier changes made by me broke the adding of users by an admin, because

the main subsite no longer has a group defined by default separate from

registered users. The registered users group *is* the main subsite

membership group. Had to add a special check for this case.

3. Removed the naughty composition rel added by application_group::new. This

caused subsites to have undesirable side-effects (add admin to subsite and

the user magically became an admin of the supersite, if you defined an

admin_rel and adminstrator relational segment in each)

    • -19
    • +1
    ./application-group-procs-oracle.xql
  1. … 9 more files in changeset.
Merged with the 4.5 branch (oacs-4-5 tag "don-merge-1")

    • -10
    • +10
    ./application-group-procs-oracle.xql
  1. … 58 more files in changeset.

Most of this fixes up the creation of application groups for subsites.

Subsites - for PG at least - still have some serious problems that need

fixing.

    • -10
    • +10
    ./application-group-procs-oracle.xql
  1. … 12 more files in changeset.
A small contribution to port it

    • -0
    • +146
    ./application-group-procs-oracle.xql
  1. … 33 more files in changeset.