community-core-procs-oracle.xql

  • last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
query was moved to acs-authentication/tcl/authentication-procs-oracle.xql

Fix syntax to exec person.del()

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

  1. … 598 more files in changeset.
Use lower(username) rather than upper(username), create case folded

indexes on postgres for username, email, screen_name, move some of

the queries in community-core-procs to .xql file.

rename the updgrade files...doh!

  1. … 8 more files in changeset.
acs_user::delete -permanent doesn't work change to fix for bug 983 patch 322 Vinod Kurup

  1. … 2 more files in changeset.
Added additional attributes to acs_user::get for /acs-admin/users/one.tcl

  1. … 1 more file in changeset.
- Ignore case in usernames

- Fixing missing flush cache statements

  1. … 3 more files in changeset.
caching the acs_user::get proc

  1. … 3 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 password expiration and approval expiration

  1. … 8 more files in changeset.
Added screen_name to ad_user_new, and deprecated it

  1. … 2 more files in changeset.
Honor authority_id when creating new users

  1. … 2 more files in changeset.
Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

    • -11
    • +21
    ./community-core-procs-oracle.xql
  1. … 816 more files in changeset.
Oracle bugfix: the invocation of plsql function add_user hadn't been updated to the new signature

  1. … 1 more file in changeset.
Oracle bug fix: add_user plsql function no longer takes password_question and password_answer arguments

added the acs_user::get_by_username proc and the permanent switch to acs_user::delete that serves as a wrapper around the acs_user.delete plsql proc. Unfortunately that proc doesn't seem to work reliably

  1. … 2 more files in changeset.
Fixed ad_user_new to use new acs.add_user with authority_id and username, but no password question/answer

    • -13
    • +15
    ./community-core-procs-oracle.xql
  1. … 2 more files in changeset.
moving generally useful user_search query from bug tracker into the core so that it can be reused with db_map for example in a form builder search widget (reference it with dbqd.acs-tcl.tcl.community-core-procs.user_search)

  1. … 4 more files in changeset.
added simple new/delete/update/get api for person objects

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

    • -0
    • +28
    ./community-core-procs-oracle.xql
  1. … 41 more files in changeset.