member-state-change-oracle.xql

  • last updated 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Reduce divergency between oracle and postgres codebase

  1. … 2 more files in changeset.
Exploit cached api to simplify and remove queries. Note that user attributes this page manipulates won't come from the cache to avoid nasty side effects. Reduce divergency between oracle and postgres codebase

  1. … 3 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7834 more files in changeset.
.xql-file reform of acs-admin

- remove sql statements from the code, where these are provided via .xql

- prefer empty sql statements over various forms of *SQL*

- remove obsolete Oracle queries

member_approve

member_ban

member_reject

member_deleted

member_unapprove

user_info

- remove obsolete .xql files (containing only unused query names)

www/users/modify-admin-privileges-oracle.xql

www/users/modify-admin-privileges-postgresql.xql

www/users/user-add-2.xql

  1. … 13 more files in changeset.
more PG 9.0 compatibility. Avoiding the usage of OIDs in postgresql.

  1. … 5 more files in changeset.
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.
fixed broken query

    • -29
    • +33
    ./member-state-change-oracle.xql
applied patches 145,146,148, ignore patch 147. Patches by Gilbert Wonf. Fixes problems with email verification

  1. … 2 more files in changeset.

More porting changes ...

  1. … 13 more files in changeset.

Fixed extractor and re-ran it, causing some file shuffling.

  1. … 11 more files in changeset.

1. Fixed apm_load_queries. Again? Yes, again. I fixed it real good this

time.

2. Added .xql files for acs-admin. APM .xql files have mostly but not

completely been ported. It sort of works though, cool!

1. Fixed apm_load_queries. Again? Yes, again. I fixed it real good this

time.

2. Added .xql files for acs-admin. APM .xql files have mostly but not

completely been ported. It sort of works though, cool!

    • -0
    • +15
    ./member-state-change-oracle.xql
  1. … 60 more files in changeset.