acs-mail-lite-procs-oracle.xql

  • last updated 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Remove redundant query definitions

  1. … 1 more file in changeset.
merge with changes from https://github.com/tekbasse/acs-mail-lite/tree/master/tcl

in essence, these changes provide support for handling email with attachments based on nsIMAP.

see https://openacs.org/forums/message-view?message_id=5378972 for more background

  1. … 71 more files in changeset.
Reduce divergence between oracle and postgres codebase, fix postgres only idiom in xql file

  1. … 2 more files in changeset.
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

  1. … 2547 more files in changeset.
New feature: now one can send plain filesystem files as email attachments, instead than only those into file-storage

  1. … 8 more files in changeset.
TIP#127 Add object_id as optional parameter to acs_mail_lite::send

  1. … 3 more files in changeset.
Fix 3087 reordering the insert by putting the clob ones (cc, bcc, body and extraheaders) at the end to avoid crash on oracle 10g.

    • -10
    • +10
    ./acs-mail-lite-procs-oracle.xql
Merged from 5.4.2

  1. … 283 more files in changeset.
Add reply_to column necessary to sweeper proc in call acs_mail_lite::send_immediately

Upgrade scripts and fix datamodel consistency

  1. … 6 more files in changeset.
Replace send procs with a refactored version of complex_send, allowing cc, bcc and attachments

    • -25
    • +47
    ./acs-mail-lite-procs-oracle.xql
  1. … 6 more files in changeset.
Applied patch #841 fixes bug #3087

Some more cleanup, put bounce restore in acs-subsite

  1. … 6 more files in changeset.
Added oracle scripts, continued with the move from user_id to party_id

  1. … 11 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.
bad writte <fullquery> fixed

merging acs-mail-lite oacs-5-1 with head, since head works but the other doesnt

  1. … 3 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.
Fixed a typo in one of the queries

Oracle was throwing errors on the send_notification_to_bouncing_email query. It isn't smart enough to map the insert columns by name, so we have to enumerate them explicitly.

New Version of Acs-Mail-Lite with support for bounce management

  1. … 7 more files in changeset.
changed the api because it was using oracle reserved key words

  1. … 2 more files in changeset.
first version of this simple mail queue

    • -0
    • +38
    ./acs-mail-lite-procs-oracle.xql
  1. … 8 more files in changeset.