community-core-procs-postgresql.xql

  • last updated 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Whitespace cleanup

    • -10
    • +10
    ./community-core-procs-postgresql.xql
  1. … 3 more files in changeset.
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
    • +40
    ./community-core-procs-postgresql.xql
  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.

    • -0
    • +16
    ./community-core-procs-postgresql.xql
  1. … 16 more files in changeset.
Reduce divergency between oracle and postgres codebase

    • -73
    • +0
    ./community-core-procs-postgresql.xql
  1. … 2 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

    • -12
    • +0
    ./community-core-procs-postgresql.xql
  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

    • -12
    • +0
    ./community-core-procs-postgresql.xql
  1. … 22 more files in changeset.
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

    • -25
    • +0
    ./community-core-procs-postgresql.xql
  1. … 2547 more files in changeset.
- get rid of deprecated calls to acs_sc_call during regression test

    • -25
    • +0
    ./community-core-procs-postgresql.xql
  1. … 6 more files in changeset.
Reverted per request.

  1. … 1 more file in changeset.
Exchanged cc_users for the faster acs_users_all query.

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

    • -2
    • +10
    ./community-core-procs-postgresql.xql
  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.
Fixed password expiration and approval expiration

    • -0
    • +65
    ./community-core-procs-postgresql.xql
  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.

    • -0
    • +12
    ./community-core-procs-postgresql.xql
  1. … 816 more files in changeset.
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

    • -20
    • +21
    ./community-core-procs-postgresql.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)

    • -0
    • +12
    ./community-core-procs-postgresql.xql
  1. … 4 more files in changeset.
added simple new/delete/update/get api for person objects

  1. … 3 more files in changeset.
adding helper procs for membership_rel package; making use of them in acs_user package

    • -30
    • +0
    ./community-core-procs-postgresql.xql
  1. … 5 more files in changeset.
cleaned up and fixed some bugs

    • -0
    • +29
    ./community-core-procs-postgresql.xql
  1. … 3 more files in changeset.
query extractor output for acs-tcl

    • -21
    • +25
    ./community-core-procs-postgresql.xql
  1. … 41 more files in changeset.

applied patches from Steve Woodcock that port a few more queries, fix a few data model PL/SQL quirks, and generally allow us to get further into a working OpenACS!

  1. … 6 more files in changeset.
new version of QD with better handling of absolute/relative paths

  1. … 10 more files in changeset.
ported a few more queries

    • -0
    • +27
    ./community-core-procs-postgresql.xql
  1. … 5 more files in changeset.