• last updated 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Remove divergency between oracle and postgres codebase, rewrite proc to avoid duplication and give it a proper and correct documentation

Quoting commit that replaced db_list_of_lists with db_list, de facto hiding every additional column from results:

-------

Author: Peter Marklund <peter_marklund@fastmail.fm>

Date: Mon Nov 24 14:50:34 2003 +0000

changing the get_attachments procs to use db_list instead of db_list_of_lists and the PG query to only return the id

-------

Fix typo

Whitespace cleanup

Whitespace changes

    • -121
    • +118
    /openacs-4/packages/theme-selva/tcl/selva-procs.tcl
Prefer 'acs_user::get_element ...' to 'person::name ...', in cases when 'person' is a user, as it doesn't rely on util_memoize_cache.

don't drop constraints, but fix it.

    • -2
    • +2
    /openacs-4/packages/news/www/item-create-3.tcl
    • -2
    • +2
    /openacs-4/packages/news/www/preview.tcl
Similar to www/index page:

- remove divergency between oracle and postgres code

- improve localization

- add author column to UI as was probably meant to be (author was selected, but not used)

- use multirow builtin count instead of manually generated one

Remove divergency between oracle and postgres codebase

Reduce divergency between oracle and postgres codebase plus some small optimization

Port downstream fix from Thomas Renner

    • -2
    • +2
    /openacs-4/packages/news/www/preview.tcl
fix for issue #3348

Remove leftover xql and prefer acs_user::get api, as doesn't rely on util_memoize cache

Reduce divergency between oracle and postgres codebase

Reduce divergency between oracle and postgres codebase

Remove divergency between oracle and postgres codebase

Remove unnecessary join, as users are always persons and unnecessary stored procedure in order_by as we compute this in the column already

Remove divergency between oracle and postgres, bring all sql inline

Reduce divergency between oracle and postgres codebase

    • -13
    • +0
    /openacs-4/packages/chat/www/user-unban-oracle.xql
    • -3
    • +2
    /openacs-4/packages/chat/www/user-unban.tcl
Moderator is really a generic party and not always a user

Reduce divergency between oracle and postgres codebase

Disambiguate table reference in subquery

Further replace stored procedure with already-available table column

Replace unnecessary stored procedures and casts

Avoid unnecessary stored procedures and casts

Remove leftover xql files

fix example in documentation and small code cleanup

Avoid unnecesary existence checks

Whitespace changes

Avoid unnecesary existence checks

Whitespace changes