• last updated 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
fix typo

db_handle reform

Use "ns_db currenthandles" (when available) to implement "db_with_handle"

instead of the old approach based on the global db_state variables.

The enws approach has the advantantge that it is

- more robust (deletion and creation of the per-request variables,

no coherency problem),

- simpler, and

- faster (less overhead per db_with_handle call, simple queries up to 20% faster)

time {db_string . {select object_id from acs_objects limit 1}} 1000

old: 200-230 microseconds per iteration

new: 160-180 microseconds per iteration

    • -113
    • +334
    /openacs-4/packages/acs-tcl/tcl/00-database-procs.tcl
Replace single quotes wuith double quotes in javascript expressions involving acs_ListBulkActionClick

this is really needed only for the URL part, but was done on the name as well for consistency. The reason

is even a properly encoded URL could still contain single quotes, therefore breaking the expression,

while double quotes are expected to be encoded in valid, urlencoded URLs. This relies on trusting the developer

to properly encode URLs, which should be expected. An alternative could involve active escaping of

javascript special characters by e.g. ad_js_escape.

[PostgreSQL 11] Change 'with (iscachable)' to IMMUTABLE for PG11

[PostgreSQL 11] Change 'with (iscachable)' to IMMUTABLE for PG11

backport from oacs-5-9, which might avoid problems with oacs 5-8 when used with recent versions of nsf

fix typo

perform javascript escaping with more regular semantics

Introduce new ad_js_escape with the purpose of sanitizing tcl strings used inside javascript code from escape sequences and from quotes in particular and provide some test cases

TODO: consider its usage into templates when e.g. we are putting a URL into javascript functions such as acs_ListBulkActionClick. URLs might in fact contain single and double quotes.

Provide some basic way to create subgroups via the UI

Actually store the group name in the UI by intercepting the right form var

Fix test test by considering that group pretty name is automatically localized

Don't quote some function defaults that are meant to be evaluated literally

New automated test doing the roundrtrip of group-type related API

Note that this is currently failing due to a bug in package_instantiate_object, which triggered the creation of this test.

Move logics to delete a group type into the API

Fix quoting of group type

Remove unneeded variable

Add (trivial) ad_include_contract

Avoid unnecessary computations

add index for bulk mail sweeper. was already #10 on sequential reads on learn

Reduce divergency between oracle and postgres codebase and bring portable sql inline

Reuse return url over subsites, remove dummy sql

Use best practice list idiom

Avoid useless check

Proc "util_get_subset_missing": make sure to return the found elements.

Added test case for this proc.

allow passing of pretty_names that contain content including less and greater sign

fix overquoting in notification-widget

    • -1
    • +1
    /openacs-4/packages/forums/www/message-view.adp
    • -1
    • +1
    /openacs-4/packages/calendar/www/view.adp
    • -1
    • +1
    /openacs-4/packages/faq/www/one-faq.adp
Localize file-size limits in the UI

Introduce a client-side check for the maximum file size, inform user of current limit and improve file-size related localization

Prettify code