• last updated 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Initial port

    • -0
    • +64
    /openacs-4/packages/file-storage/www/file-add-2-oracle.xql
    • -0
    • +17
    /openacs-4/packages/file-storage/www/file-add-2.xql
    • -0
    • +56
    /openacs-4/packages/file-storage/www/file-copy-2-oracle.xql
    • -0
    • +70
    /openacs-4/packages/file-storage/www/file-copy-2-postgresql.xql
    • -0
    • +17
    /openacs-4/packages/file-storage/www/file-copy.xql
    • -0
    • +38
    /openacs-4/packages/file-storage/www/file-delete-oracle.xql
    • -0
    • +36
    /openacs-4/packages/file-storage/www/file-delete-postgresql.xql
    • -0
    • +13
    /openacs-4/packages/file-storage/www/file-delete.xql
    • -0
    • +32
    /openacs-4/packages/file-storage/www/file-edit-2-oracle.xql
    • -0
    • +30
    /openacs-4/packages/file-storage/www/file-edit-2-postgresql.xql
    • -0
    • +17
    /openacs-4/packages/file-storage/www/file-edit-postgresql.xql
    • -0
    • +20
    /openacs-4/packages/file-storage/www/file-move-2-oracle.xql
    • -0
    • +18
    /openacs-4/packages/file-storage/www/file-move-2-postgresql.xql
    • -0
    • +36
    /openacs-4/packages/file-storage/www/file-move-2.xql
    • -0
    • +17
    /openacs-4/packages/file-storage/www/file-move-oracle.xql
  1. … 3 more files in changeset.
Includes all .xql files

Fix broken threading due to incorrect query name.

Syncing with server after move; adding fixes to CONNECT BY replacements. Presently, some are broken once multiple users are added to site

Fixed posting error due to incorrect partialquery name.

Added patch form Luke Pond that updates bboard_garbage_collect_postgresql

so that general_comments are prevented from being garbage collected.

Fixes the broken forum page. Wrap else clause of the "messages_select"

query in to_char so that the datatypes of both claues match.

adp page used dollar sign instead of at signs..

    • -1
    • +1
    /openacs-4/packages/faq/www/one-faq.adp
Fixed naming of queries in .xql files. Along the way I also fixed other things that I have overseen.

    • -41
    • +34
    /openacs-4/packages/cms/tcl/form-procs-oracle.xql
    • -5
    • +5
    /openacs-4/packages/cms/tcl/form-procs.tcl
    • -23
    • +31
    /openacs-4/packages/cms/tcl/form-procs.xql
    • -3
    • +3
    /openacs-4/packages/cms/tcl/module-procs.tcl
    • -3
    • +3
    /openacs-4/packages/cms/tcl/module-procs.xql
    • -123
    • +0
    /openacs-4/packages/cms/tcl/perm-procs-oracle.xql
    • -1
    • +1
    /openacs-4/packages/cms/tcl/user-procs.xql
made register_content one transaction

fixed to use new acs-mail notifications

cleanup of old oracle code

made date format prettier

fixed to use new acs_mail notifications

fixed an APM install bug.

first stab at a document that describes changes I've made, usage instructions and other miscellaneous notes.

    • -0
    • +482
    /openacs-4/packages/acs-mail/www/doc/openacs-mail.html
created index page to link to other docs

    • -0
    • +25
    /openacs-4/packages/acs-mail/www/doc/index.html
fixed queries to use CR

added acs_mail_base64_encode - a tcl proc that uuencodes

fixed acs_mail_set_content to use CR

same for acs_mail_set_content_file

added acs_mail_uuencode_file to uuencode a file

changed acs_mail_encode_content a lot to properly read data from the CR and encode it as needed

changed recursive db_foreach to a db_list_of_lists followed by a foreach to prevent running out of handles

added a check of MIME type to decide whether to add 'Content-Transfer_Encoding: base 64'

commented out the code that puts To: and From: address into Headers to prevent duplicate To: and From: addresses in the email

changed acs_mail_content_new to be private. doesn't make sense to call it without a message_body

changed to use content repository, rather than acs-content

fixed 'FIXME LOB'

changed to use content repository, rather than acs-content

added 'on delete cascade'

changed content_object_id to content_item_id

added declaration for v_header_message_id

changed acs_mail_body__body_p to return boolean

fixed acs_mail_link__new

simple drop script

moved acs-notifications into acs-mail-nt-create

dropped support for max_retries param to __post_request since it was specific to acs-notifications, not acs-mail

raise exceptions if any of the other notification functions besides post_request or cancel_request are called

added overloaded fxn for post_request that takes the most common params

source acs_mail_nt_drop.sql

changed order of table drop

added inline func to drop all objects in acs-mail

fixed names of acs_objects to be specific to acs-mail (as opposed to acs-messaging)

changed object_id to gc_object_id in __create_type so that drop_type works!

changed content_object_id (fk acs_content) to content_item_id (referring to CR)

added 'on delete cascade' to acs_mail_links

added command to source acs_mail_nt_create.sql

added on delete cascade

replaced content_object_id with content_item_id

changed add_content from procedure to a function. we can then get the sequence number back into tcl, so we can edit data for that object

simple drop script

ported acs-mail-nt-create from PG to oracle