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

files that were originally in site-wide search - ported by Neophytos Demetriou. Files were moved to the kernel, because it made sesse to do so

Fixed seq/sequence in static-pages-create.sql

XQL files missing from previous commit

    • -0
    • +18
    /openacs-4/packages/static-pages/www/admin/index-oracle.xql
    • -0
    • +19
    /openacs-4/packages/static-pages/www/admin/index-postgresql.xql
Fix APM to allow for LSB-compliant Paths. It didn't allow "www" in the

path of packages.

more fixup

More fiddling.

Fixing commit emails.