• last updated 15 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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

first stab at a drop script

    • -0
    • +74
    /openacs-4/packages/acs-mail/sql/oracle/acs-mail-drop.sql
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

removed dependence on acs-content

added dependence to acs-content-repository

add sql drop script

add notification create and drop script

Initial port

    • -0
    • +43
    /openacs-4/packages/file-storage/tcl/file-storage-procs.xql
Initial port

    • -0
    • +47
    /openacs-4/packages/file-storage/www/folder-create-2-oracle.xql
    • -0
    • +15
    /openacs-4/packages/file-storage/www/folder-create-2.xql
    • -0
    • +17
    /openacs-4/packages/file-storage/www/folder-delete-oracle.xql
    • -0
    • +28
    /openacs-4/packages/file-storage/www/folder-delete.xql
Moved package_id calculation to tcl

inital port

    • -0
    • +44
    /openacs-4/packages/file-storage/www/index-oracle.xql
    • -0
    • +41
    /openacs-4/packages/file-storage/www/index-postgresql.xql
Inital port