• last updated 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Reduce number of queries, improve documentation

Queries could be made even less e.g. by locking and querying the tuples in one statement. However, it would be trickyer to make the code portable.

  1. … 1 more file in changeset.
replace low-level cr_fs_path by higher level interface content::revision::get_cr_file_path

  1. … 8 more files in changeset.
Replace limit (pg only) with fetch idiom, which should be portable on "modern" Oracle

  1. … 1 more file in changeset.
change "fetch first 1 row only" to "limit 1" to generic xql file, since Oracle started to support fetch first only with version 12c

Reduce divergence between oracle and postgres codebase, fix postgres only idiom in xql file

  1. … 2 more files in changeset.
Upgrade scripts and fix datamodel consistency

  1. … 6 more files in changeset.
Remove unused queries. Remove from generic xql queries that are different for each db and already in the appropriate xql

Replace send procs with a refactored version of complex_send, allowing cc, bcc and attachments

  1. … 6 more files in changeset.
Some more cleanup, put bounce restore in acs-subsite

  1. … 6 more files in changeset.
Cleaning up. Removed the code for prefix handling as it does not work. Changed Oracle scripts and make them look nicer.

  1. … 14 more files in changeset.
Fixed bouncing and record bounces when SMTP server does not like the email address

  1. … 3 more files in changeset.
move to using smtp for complex_send. Support for single_mail flag. Support for bcc and cc emails

  1. … 1 more file in changeset.
Added rollout support. Couple of minor changes

  1. … 3 more files in changeset.
Mails are send to parties, not to users. Therefore the logging and bouncing should belong to parties, not to users.

  1. … 5 more files in changeset.
Oops, yesterday's commit was partially bogus, tested these queries at

Heidelberg this time ...

Replaced two slow queries using cc_users with their faster equivalent using

parties and users. Makes a huge difference on Oracle when there are many,

many users (49,000 in this case). And yes, I checked, the original queries

used indexes galore, Oracle was doing as well as can be expected.

adding catalog files, procedures and making changes to remove the contacts dependency on lib email.tcl files

  1. … 5 more files in changeset.
Importing on behalf of Nima. Enhancement for the support of incoming email

  1. … 4 more files in changeset.
merge all the changes on the oacs-5-1 and dotlrn-2-0 branches up to tag jcd-merge-20040420

  1. … 647 more files in changeset.
maltes change broke sending mail because he reversed the result of bouncing_user_p and bouncing_email_p (mostly because the query was misnamed can_send_p and should have been bouncing_p since that was the sense of the return

  1. … 1 more file in changeset.
The case seems to be wrong. Changed. Hopefully it will not break things somewhere else.

More changes due to continuous user_id and user_name problems. Looking forward to more testing by others.

  1. … 1 more file in changeset.
New Version of Acs-Mail-Lite with support for bounce management

    • -0
    • +119
    ./acs-mail-lite-procs.xql
  1. … 7 more files in changeset.