community-core-procs-oracle.xql

  • last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Parties api had procs defined in both acs-subsite and acs-tcl and sometimes duplicated

- move all party:: api into acs-tcl/tcl/community-core-procs

- remove duplicated definitions

- move leftover deprecated proc to deprecated-procs.tcl

  1. … 4 more files in changeset.
Portrait management reform and correction

Moved logics to create a portrait in a proc in order to reuse it in other places

such as picture retrieval services (e.g. Bach picture retrieval at WU). Turns out

we were not doing our homeworks here: when the portrait is created into CR, a

cr_child_rel is created. When the portrait was erased though, this was not cleaned

up propely, leaving dangling acs_objects with no reference in cr_child_rels table.

On busy sites, this can grow in the ten thousands order of magnitude. Changes include

also fix for this behavior and tuples cleanup.

  1. … 16 more files in changeset.
Reduce divergency between oracle and postgres codebase

  1. … 2 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-tcl (part 3)

- remove obsolete queries

ad_acs_admin_id.acs_admin_id_get

ad_db_select_widget.currency_info

ad_maybe_redirect_for_registration.sql_test_1

ad_maybe_redirect_for_registration.sql_test_2

ad_permission_p.n_privs

ad_user_class_query.sql_post_select_for_user_class

apm_file_add.apm_file_add

apm_file_remove.apm_file_remove

apm_package_install.version_exists_p

site_node::get_url_from_object_id.select_url_from_object_id

user_search

- remove obsolete files

tcl/00-database-procs-postgresql-postgresql.xql

tcl/00-database-procs-postgresql.tcl

tcl/defs-procs-oracle.xql

tcl/defs-procs-postgresql.xql

tcl/deprecated-utilities-procs.xql

tcl/request-processor-init.xql

tcl/request-processor-procs-oracle.xql

tcl/request-processor-procs-postgresql.xql

tcl/widgets-procs.xql

  1. … 22 more files in changeset.
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

  1. … 2547 more files in changeset.
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.