• last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Split up basic user information (one.tcl) and the users contributions (one-contributions)

Without this change, one.tcl becomes unusable for large sites, where some

users have literally millions of objects (e.g. admins migrating some data).

We have seen the query running for several hours. Maybe, one should

limit also in the splitted case the number of presented contributions

file one-contributions.adp was initially added on branch oacs-5-10.

    • -0
    • +0
    ./users/one-contributions.adp
file one-contributions.tcl was initially added on branch oacs-5-10.

    • -0
    • +0
    ./users/one-contributions.tcl
Prefer 'namespace which' over 'info commands', as it is faster (on local tests, around 2x) and returns a single value. Many thanks to Nathan Coulter.

  1. … 57 more files in changeset.
use bind variables instead of tcl variable substition in xql fullqueries

  1. … 15 more files in changeset.
reduce debugging output

fix listing of batch run

- make links clickable

- modernize Tcl code

added last_contribution based on last created object

file ip-info.adp was initially added on branch oacs-5-10.

file ip-info.tcl was initially added on branch oacs-5-10.

remove stray "from" in last visit information

we have in table "users" no last IP, we could just fall back to a

last contribution field

Improve sql portability

  1. … 4 more files in changeset.
Improve portability, fetch idiom should be supported by "modern Oracle"

improve spelling

  1. … 3 more files in changeset.
mprove spelling: move closer to the linux documentation recommendations, standardize variable names

  1. … 11 more files in changeset.
improve acs-admin//apm/packages-install

- use usual user interaction for select/unselect all

- add proper handling of no upgrades

- improve HTML markup

- improve code orthogonality

  1. … 2 more files in changeset.
add multiple to page contract

improve variable names

use "ns_dbquotelist" to quote tcl list

use ns_dbquotelist to convert Tcl list to sql

  1. … 1 more file in changeset.
Replace 'ad_url' with 'ad_conn subsite_url'

when installation runs into an error, show the error message preformatted

  1. … 1 more file in changeset.
whitespace changes

  1. … 1 more file in changeset.
Prefer api to retrieve csp nonce, as it performs useful existance checks

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

    • -20
    • +0
    ./users/member-state-change-oracle.xql
    • -18
    • +0
    ./users/member-state-change-postgresql.xql
Rename string_truncate and string_truncate_middle to comply with OpenACS naming convention, create deprecated wrappers, replace occurrences

As string_truncate_middle was defined in xotcl-request-monitor, bring it to acs-tcl instead

  1. … 10 more files in changeset.
Rename ReturnHeaders proc to comply with OpenACS naming convention, create deprecated wrapper, replace occurrences

  1. … 10 more files in changeset.
  1. … 1 more file in changeset.
prefer all caps spelling for SQL

  1. … 2 more files in changeset.
Rename clock_to_ansi to lc_clock_to_ansi to comply with naming convention, replace occurrences, create deprecated wrapper

  1. … 5 more files in changeset.