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

    • -0
    • +17
    ./packages/acs-mail/sql/postgresql/acs-mail-nt-drop.sql
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

    • -0
    • +258
    ./packages/acs-mail/sql/postgresql/acs-mail-nt-create.sql
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

    • -0
    • +12
    ./packages/acs-mail/sql/oracle/acs-mail-nt-drop.sql
ported acs-mail-nt-create from PG to oracle

    • -0
    • +265
    ./packages/acs-mail/sql/oracle/acs-mail-nt-create.sql
first stab at a drop script

    • -0
    • +74
    ./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
    ./packages/file-storage/tcl/file-storage-procs.xql
Initial port

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

inital port

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

    • -0
    • +100
    ./packages/file-storage/tcl/file-storage-procs-oracle.xql
    • -0
    • +107
    ./packages/file-storage/tcl/file-storage-procs-postgresql.xql
corrected typo on parameter alias new_root_folder__package_id

Fix typo in arg name.

scanned in new .xql files for the cms package

Oops - Vinod caught the fact that only the standard SQL92 version of the

query "apm_all_files" existed in a query file ...

    • -0
    • +17
    ./packages/acs-admin/www/apm/version-files-oracle.xql
fixed up typos

    • -1
    • +1
    ./packages/cms/tcl/form-procs-postgresql.xql
    • -2
    • +2
    ./packages/cms/tcl/module-procs-postgresql.xql
    • -1
    • +1
    ./packages/cms/tcl/pagination-procs-postgresql.xql

Fixed a few spelling mistakes

Ported a bunch more of acs-subsite

Fixed a few small, acs-subsite related bugs

    • -31
    • +32
    ./packages/acs-subsite/tcl/attribute-procs.tcl
    • -9
    • +9
    ./packages/acs-subsite/tcl/attribute-procs.xql
    • -2
    • +6
    ./packages/acs-subsite/tcl/package-procs.tcl
    • -2
    • +2
    ./packages/acs-subsite/tcl/rel-types-procs.tcl
  1. … 27 more files in changeset.
Fixed a query. Thanks goes to Dan for the help.

    • -2
    • +2
    ./packages/cms/tcl/form-procs-postgresql.xql

Got rid of an umlat that apparently cause ns_xml fits at least for some.

query not ended properly

    • -1
    • +1
    ./packages/cms/tcl/form-procs-oracle.xql
FInished porting. Now to debug :-)

    • -0
    • +11
    ./packages/cms/tcl/content-method-procs.xql
    • -0
    • +76
    ./packages/cms/tcl/item-procs-oracle.xql
    • -0
    • +76
    ./packages/cms/tcl/item-procs-postgresql.xql
    • -0
    • +104
    ./packages/cms/tcl/item-procs.xql
    • -0
    • +207
    ./packages/cms/tcl/module-procs-oracle.xql
    • -0
    • +210
    ./packages/cms/tcl/module-procs-postgresql.xql
    • -0
    • +41
    ./packages/cms/tcl/module-procs.xql
    • -0
    • +21
    ./packages/cms/tcl/pagination-procs-oracle.xql
    • -0
    • +21
    ./packages/cms/tcl/pagination-procs-postgresql.xql
    • -0
    • +16
    ./packages/cms/tcl/pagination-procs.xql
    • -0
    • +220
    ./packages/cms/tcl/perm-procs-oracle.xql
    • -0
    • +212
    ./packages/cms/tcl/perm-procs-postgresql.xql
    • -0
    • +13
    ./packages/cms/tcl/perm-procs.xql
    • -0
    • +58
    ./packages/cms/tcl/publish-procs-oracle.xql
    • -0
    • +58
    ./packages/cms/tcl/publish-procs-postgresql.xql
  1. … 9 more files in changeset.
Finished porting queries. Now to debug ;-)

    • -3
    • +3
    ./packages/cms/tcl/form-procs-oracle.xql
    • -4
    • +6
    ./packages/cms/tcl/form-procs-postgresql.xql
    • -35
    • +6
    ./packages/cms/tcl/module-procs.tcl
    • -12
    • +2
    ./packages/cms/tcl/pagination-procs.tcl
    • -48
    • +48
    ./packages/cms/tcl/rel-procs.tcl
    • -21
    • +17
    ./packages/cms/tcl/workflow-procs.tcl
Committing just for safety and historic purposes. Still have to run the query extractor on files

after form-procs.tcl (I make too many typos when generating the .xql by hand) and need to fix the

db_map's (which I appropriately flagged so I can remember).

    • -35
    • +35
    ./packages/cms/tcl/item-procs.tcl
    • -62
    • +57
    ./packages/cms/tcl/module-procs.tcl
    • -7
    • +7
    ./packages/cms/tcl/pagination-procs.tcl
    • -42
    • +49
    ./packages/cms/tcl/perm-procs.tcl
    • -97
    • +98
    ./packages/cms/tcl/publish-procs.tcl
Postgresql ported - still needs modifications to work with static-pages. Oracle not tested and probably broken

    • -3
    • +12
    ./packages/static-pages/static-pages.info