• last updated 22 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

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.

fixed up some oracle stuff that I broke when porting to oracle

fixed comment for distribution_tarball attribute that was removed

fixed query dispatcher to handle case of package proc calling another package proce without qualifying the package name

1. Added a new attribute to the .info file which tells the bootstrap

installer whether or not a package is part of the acs-core. Only

acs-core packages are now installed during the initial bootstrap install

of the system.

2. Fixed a dupe query name problem in a couple of queryfiles. The problem

is not with the dispatcher but with the extractor, and for the moment it

is just easier to kludge the resulting queryfile than fix the extractor.

  1. … 22 more files in changeset.
Start of postgresql port

ported queries for serving tarballs

    • -0
    • +32
    /openacs-4/packages/acs-admin/www/apm/packages/index-oracle.xql