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

corrected typo on parameter alias new_root_folder__package_id

Fix typo in arg name.

scanned in new .xql files for the cms package

    • -4
    • +328
    /openacs-4/packages/cms/cms.info

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

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

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

Fixed a few spelling mistakes

Ported a bunch more of acs-subsite

Fixed a few small, acs-subsite related bugs

  1. … 27 more files in changeset.
Fixed a query. Thanks goes to Dan for the help.

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

query not ended properly

FInished porting. Now to debug :-)

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

    • -7
    • +7
    /openacs-4/packages/cms/tcl/item-procs.tcl
    • -35
    • +6
    /openacs-4/packages/cms/tcl/module-procs.tcl
    • -12
    • +2
    /openacs-4/packages/cms/tcl/pagination-procs.tcl
    • -51
    • +5
    /openacs-4/packages/cms/tcl/perm-procs.tcl
    • -48
    • +48
    /openacs-4/packages/cms/tcl/rel-procs.tcl
    • -7
    • +6
    /openacs-4/packages/cms/tcl/user-procs.tcl
    • -4
    • +4
    /openacs-4/packages/cms/tcl/widget-procs.tcl
    • -21
    • +17
    /openacs-4/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
    /openacs-4/packages/cms/tcl/item-procs.tcl
    • -62
    • +57
    /openacs-4/packages/cms/tcl/module-procs.tcl
    • -42
    • +49
    /openacs-4/packages/cms/tcl/perm-procs.tcl
    • -97
    • +98
    /openacs-4/packages/cms/tcl/publish-procs.tcl
Postgresql ported - still needs modifications to work with static-pages. Oracle not tested and probably broken

Port group-type maintenance (no attributes yet)

Use semicolon as argument name / default value separator, instead of

colon (makes it easier to use in pl/pgsql)

Fixed type (ad_doc to ad_proc, my fingers got confused by the old proc_doc).

More Porting Tcl pages

initial port to postgresql