• last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Reduce divergencies between oracle and postgres codebase... this file was for some reason deleted in 2001, but sql in it is portable

Use more API

Note that now we assume email and user_id will be from parties that actually belong to the system

Remove (again) this almost 20 years old program

Use more api

Make clearer what is going on here (a lot, apparently)

Remove unused query and put last remaining inline to avoid xql file. Reduce joining

Don't pass fine tcl variables through the database for random reasons, improve code legibility, reduce divergency between oracle and postgres codebase, exploit multi-user permission checking on postgres

Beautify code, remove unneded variables and queries

Reduce joining

    • -6
    • +8
    /openacs-4/packages/chat/www/room-oracle.xql
Don't cache invalid user ids, as they might become valid shortly after (e.g. during registration)

flag current request as being performed via aa_testing

Fix missing close bracket

use form_name in url

Remove unneded xql

Use more API when retrieving user info and portrait, streamline queries, put all sql inline

Reduce divergency between oracle and postgres codebase

    • -0
    • +31
    /openacs-4/packages/acs-templating/tcl/widget-procs.xql
Use API when retrieving user info

Remove unnecessary xql

Reduce divergencies between oracle and postgres codebase

Don't pass fine tcl variables through the query, avoid unnecessary quoting (bulk-mail api would pass variable to the stored procedure using ':' notation)

    • -9
    • +4
    /openacs-4/packages/dotlrn/www/spam.tcl
    • -7
    • +2
    /openacs-4/packages/dotlrn/www/spam.xql
Reduce divergencies between oracle and postgres codebase

Use more API when retrieving user info

Replace leftover Naviserver-only cache idioms with retro compatible ones

    • -5
    • +5
    /openacs-4/packages/chat/tcl/chat-procs.tcl
Put this last query also in the code as the others, so no xql is required

Use more API, reduce divergency between postgres and oracle code

Use more API

Use more API

Prefer API over handcrafted queries

Create chat room cache in a way to provide compatibility with AOLserver

make timeout and cache size configurable.

    • -1
    • +20
    /openacs-4/packages/chat/tcl/chat-init.tcl
    • -7
    • +1
    /openacs-4/packages/chat/tcl/chat-procs.tcl