• last updated 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
fixed up package display to work with postgresql

files no lnger applicable

added new query files used for moving scheduling from oracle to aolserver

Built two query snippets using "db_map". They weren't db specific so we

now have a generic index.xql file...

cleanup

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.