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

    • -28
    • +0
    ./acs-authentication/tcl/sync-procs-oracle.xql
    • -28
    • +0
    ./acs-authentication/tcl/sync-procs-postgresql.xql
    • -0
    • +26
    ./acs-authentication/tcl/sync-procs.xql
Reduce divergence between postgres and oracle codebase

    • -37
    • +0
    ./acs-admin/www/users/complex-search-oracle.xql
    • -9
    • +3
    ./acs-admin/www/users/complex-search.tcl
    • -5
    • +28
    ./acs-admin/www/users/complex-search.xql
Ehm... reintroduce dual for oracle compliance

Use dual for oracle compliance

Add dual for oracle compliance

Reduce divergency between oracle and postgres codebase

    • -27
    • +0
    ./news/www/admin/process-2-oracle.xql
    • -27
    • +0
    ./news/www/admin/process-2-postgresql.xql
    • -0
    • +17
    ./news/www/admin/process-2.xql
Reduce divergency between oracle and postgres codebase

    • -28
    • +0
    ./news/www/admin/revision-add-oracle.xql
    • -29
    • +0
    ./news/www/admin/revision-add-postgresql.xql
Use tcl to do date calculations instead of db, reduce postgres/oracle divergencies

    • -7
    • +0
    ./news/www/admin/approve-postgresql.xql
Reduce divergence between oracle and postgres codebase, optimize queries

Do date calculations in tcl rather than in db, reduce oracle and postgres divergency

    • -14
    • +0
    ./news/www/item-create-postgresql.xql
Reduce divergence between oracle and postgres code

    • -0
    • +10
    ./news/lib/latest-news.xql
Reduce oracle/postgres divergence

    • -22
    • +0
    ./rss-support/tcl/rss-generation-service-procs-oracle.xql
    • -23
    • +0
    ./rss-support/tcl/rss-generation-service-procs-postgresql.xql
    • -2
    • +21
    ./rss-support/tcl/rss-generation-service-procs.xql
Uniform sql codebase

    • -19
    • +0
    ./notifications/tcl/sweep-procs-oracle.xql
    • -13
    • +0
    ./notifications/tcl/sweep-procs-postgresql.xql
    • -0
    • +14
    ./notifications/tcl/sweep-procs.xql
Use cached api instead of query to retrieve node id from community and community_type

Remove unused query from xql (no usage was found upstream and on Learn@WU)

Get rid of dual idiom

Oracle doesn't support limit :-|

Streamline and optimize idiom

Declare explicitly the only column we need in a way that DBMS can create a better query plan

Tolerate the same request variable specified multiple times

We use export_vars as arbiter to decide how this will be treated.

Also remove some postgres/oracle divergence

    • -21
    • +16
    ./calendar/www/view-list-display.tcl
Replace db date conversion with tcl one, remove unneded statements (sort_by is already defined in page contract, ad_return_template is implicit)

    • -7
    • +3
    ./calendar-portlet/www/calendar-list-portlet.tcl
Fix typo

Port downstream only usage of reading info api

Also fix such api so that root message is retrieved for every given source message

    • -5
    • +16
    ./forums/sql/oracle/forums-reading-info-package-create.sql
    • -0
    • +163
    ./forums/sql/oracle/upgrade/upgrade-1.3.1d3-1.3.1d4.sql
Converge downstream reading_info feature with upstream

Port downstream only idiom to update reading_info table

Make more use of api when retrieving forum and message information

Optimize message existance query

Fix sql update to populate new forum_id column in existing data

Maintenance of forum reading count feature

- removal of forums_reading_info_user (1Mio rows on Learn@WU).

This materialized view had to be constantly synced with

forums_reading_info table. Reimplemented as view.

- simplify logics in stored procedure due to new datamodel

- fix inconsistencies between oracle and postgres function definition

- re-enabled parameter to decide whether use these stats or not in

administration

TODO: consider further reform of this feature as stats grow very

large on busy sites for probably little value added

    • -3
    • +3
    ./forums/sql/oracle/forums-reading-info-drop.sql
    • -143
    • +5
    ./forums/sql/oracle/forums-reading-info-package-create.sql
    • -0
    • +186
    ./forums/sql/oracle/upgrade/upgrade-1.3.1d2-1.3.1d3.sql
Remove deprecated idioms and unneded queries

    • -8
    • +0
    ./forums/lib/message/post-postgresql.xql
Persist sanitized timestamp into data object before saving (Many thanks to Markus Moser)

Implement post anonymously through explicit forum attribute in table

Now moderators can explicitly decide whether a forum will enable posting anonymously or not.

Forum must be in a policy different from closed and the anonymous flag must be set accordingly for this to happen.

Also:

- normalize api in a way it can accomodate all current attributes. In particular,

now edit api will now leave every unspecified attribute unchanged, instead of

setting it to some default.

- fix some usability issues when managing forum parameters (e.g. values not

retrieved in form when editing existing forum)

- introduce missing Oracle upgrade script for the whole forum reform

- fix oracle creation script

    • -0
    • +27
    ./forums/sql/oracle/upgrade/upgrade-1.3.1d1-1.3.1d2.sql
    • -9
    • +14
    ./forums/tcl/forums-security-procs.tcl
Update docs: remove broken links and remove/update obsolete section

    • -3
    • +22
    ./acs-core-docs/www/acs-package-dev.html
    • -2
    • +2
    ./acs-core-docs/www/analog-install.adp
    • -4
    • +9
    ./acs-core-docs/www/analog-install.html
    • -9
    • +30
    ./acs-core-docs/www/analog-setup.html
    • -30
    • +27
    ./acs-core-docs/www/aolserver.adp
    • -48
    • +156
    ./acs-core-docs/www/aolserver.html
    • -46
    • +37
    ./acs-core-docs/www/aolserver4.adp
    • -37
    • +141
    ./acs-core-docs/www/aolserver4.html
    • -87
    • +428
    ./acs-core-docs/www/apm-design.html
    • -4
    • +2
    ./acs-core-docs/www/apm-requirements.adp
  1. … 285 more files in changeset.