community-core-procs.xql

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

Unify person update api, exploit cache better and remove unneded queries

  1. … 1 more file 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. … 4 more files in changeset.
Draft reform of the caching for party descendant types (persons, users, groups)

- new proc party::get to centralize caching of the various information for a party descendant scattered through tables

- allow to retrieve only a single value from the dict in new and existing api

- rename of user_info_cache with party_info_cache

- replacement into previously existing api

Behavior for the new proc now will be to not fail, just return an empty dict or an empty value when no party is found

TODO: after review of the change, replacement of all now deprecated calls in code around

  1. … 2 more files in changeset.
Reduce code duplication when retrieving person info

TODO centralize caching

  1. … 1 more file in changeset.
Reuse acs_user::get_by_username to retrieve user_id in order to reduce query duplication and cache entries for acs_user::get, simplify idiom

  1. … 1 more file 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.
remove not referened xql queries and files

move queries to deprecated-procs.xql

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

  1. … 2 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.
- get rid of deprecated calls to acs_sc_call during regression test

  1. … 6 more files in changeset.
Fixed a bug in my new simplifed bio code, uncovered by automated testing

(how timely given my earlier e-mail today!)

Missed a detail when moving bio back to person.

  1. … 4 more files in changeset.
Moved "bio" back to "person", but with type-specific storage. People can

fight over where such things belong on another day, for now keeping it in

"person" has the advantage that the Tcl API is 100% unchanged so moving it

to type-specific storage won't break .LRN.

  1. … 8 more files in changeset.
Moved "bio" from person/generic storage to user/type-specific storage as TIP'd

(PG only, Oracle to follow soon).

  1. … 6 more files in changeset.
Added procedure to provide the portrait_id of a user

  1. … 1 more file in changeset.
Cached the user_id from username procedure as this will not change that easily / often

  1. … 1 more file in changeset.
Performance increase by a factor of 200

  1. … 1 more file in changeset.
Added procedure to check if a user is actually registered. We should probably change auth::require_login to check if the user is registered instead of just checking for the existance of the cookie

  1. … 2 more files in changeset.
Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

  1. … 721 more files in changeset.
Added party::name and enhanced person::name

  1. … 3 more files in changeset.
reverting. not because I think I have to but because I'm just sick of discussing this minor change for ages

  1. … 3 more files in changeset.
Allow usage of an email with multiple party_ids. Should not break existing sites (as they would have broken if you have an e-mail twice in the system

  1. … 1 more file in changeset.
commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

  1. … 2275 more files in changeset.
performance improvements, using now acs_users_all

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.
Remerge Timo's changes for tip 42,43, cf tip 53

  1. … 97 more files in changeset.
rollback of Timo's name, package_id commit; see TIP 53

  1. … 96 more files in changeset.
TIP#42,43: adding package_id and title to acs_objects table

  1. … 96 more files in changeset.