• last updated 14 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
added oracle query

moved scheduling to aolserver

catchall

Initial Revision

    • -0
    • +130
    /openacs-4/packages/acs-mail/tcl/acs-mail-procs.xql
Fixed pl/sql and outer join

moved content repository job scheduling from oracle to aolsrver, that it is compatible with postgresql

Added calls to Dan's new "db_map" routine to make db-specific queries in

the apm index page work.

Initial Revision

    • -0
    • +203
    /openacs-4/packages/acs-mail/tcl/acs-mail-procs-oracle.xql
Initial Revision

fixed permissions problem for handling insertion of dup index values

fixed up a few queries that I missed on the initial porting pass

fixed dynmic query using new db_map command

added uplevel subst to db_map command

cleanup

cleaned up content repository data-model and converted oracle apm to use file storage in the content repository

added new db_map command for generating query snippets

ported complex search using new db_map command for generating query snippets

Just what it says ...

initial porting of queries

more porting to postgres

adding CR file storage area.

added support for storing content repository items in the file system

updated oracle version to use file storage in CR

1. Polished up the query files for the root www directory

2. Turned a bunch of bitmap indexes into b-tree indexes

3. the developer support .info file had been messed over by an early

version of my APM port to PG.

    • -0
    • +21
    /openacs-4/www/index-oracle.xql
    • -0
    • +14
    /openacs-4/www/index.xql
extracted queries

    • -0
    • +90
    /openacs-4/packages/download/tcl/download-procs-oracle.xql
    • -0
    • +115
    /openacs-4/packages/download/tcl/download-procs.xql
    • -0
    • +17
    /openacs-4/packages/download/www/all-metadata.xql
    • -0
    • +48
    /openacs-4/packages/download/www/archive-add-2-oracle.xql
    • -0
    • +22
    /openacs-4/packages/download/www/archive-add.xql
    • -0
    • +11
    /openacs-4/packages/download/www/archive-version-add-2.xql
    • -0
    • +22
    /openacs-4/packages/download/www/archive-version-add.xql
    • -0
    • +27
    /openacs-4/packages/download/www/download-verify-oracle.xql
    • -0
    • +26
    /openacs-4/packages/download/www/index-oracle.xql
    • -0
    • +26
    /openacs-4/packages/download/www/index-postgresql.xql
  1. … 32 more files in changeset.
updated info file and extracted queries

ported the datamodel

fixed bug in add-edit-oracle.xql

psql doesn't like -U without a username

Removed bogus "as" in from clause. Broke Oracle, didn't bother PG, made

them the same for consistency's sake.