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

Initial port

stores content as "file" in content repository. Comments working

moved acs-object-util from site-wide search to kernel

moved files from site-wide search. It makes more sense to have them in the kernel.

    • -0
    • +133
    /openacs-4/packages/acs-kernel/sql/oracle/acs-object-util.sql
Fixed error in bookmarks__new; context_id was not being set in acs_objects for all bookmarks -- added dead links checking

Finished form-procs.tcl

    • -10
    • +62
    /openacs-4/packages/cms/tcl/form-procs-oracle.xql
    • -56
    • +44
    /openacs-4/packages/cms/tcl/form-procs.tcl
    • -0
    • +39
    /openacs-4/packages/cms/tcl/form-procs.xql

1. Added a check that PG was initdb's with the collation order for

characters that we expect.

2. Jon added a "sql/common" directory for the insert statements which

load data for acs-references, so I added a new datamodel type "common"

to the APM.

3. Created a new db API routine that returns true if a given db_type is

compatible with the current RDBMS.

4. Added a workaround for a PL/pgSQL "execute" bug in acs-workflow (other

cases had been fixed previously by others but this one was missed)

5. Diddled a couple of .info files using the APM.

93% done with porting form-procs.tcl. Stopped at add_basic_revision. Will finish this today (sunday).

    • -0
    • +110
    /openacs-4/packages/cms/tcl/form-procs-oracle.xql
    • -73
    • +59
    /openacs-4/packages/cms/tcl/form-procs.tcl
    • -6
    • +19
    /openacs-4/packages/cms/tcl/form-procs.xql

The query extractor had never been run on this, oops, and there were a

couple of rownum references and package calls ... works now even if you

enable user switching.

Initial version of bboard-portlets, grabbed from aD's repository.

Initial revision