• last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
tested and fixed the template query db api

  1. … 12 more files in changeset.
fixed some errors in tree queries pointed out by Vinod Kurup

Make db_qd_get_fullname cope with a malnourished call stack

Add query dispatcher call to db_list and db_list_of_lists

added ad_proc to template query procs

Updated .info

Start of postgresql port

  1. … 11 more files in changeset.
updated with streamlined permission_p

Fixed conflict in this file, the order should now be:

- source the -procs files

- load up queries

- source the -init files

this is because the -init files sometimes have queries they need dispatched.

added QD stuff to Oracle piece. Not tested yet.

A small contribution to port it

    • -0
    • +38
    /openacs-4/packages/acs-subsite/tcl/attribute-procs-oracle.xql
    • -0
    • +129
    /openacs-4/packages/acs-subsite/tcl/attribute-procs.xql
    • -0
    • +42
    /openacs-4/packages/acs-subsite/tcl/group-procs-oracle.xql
    • -0
    • +44
    /openacs-4/packages/acs-subsite/tcl/group-procs-postgresql.xql
    • -0
    • +35
    /openacs-4/packages/acs-subsite/tcl/group-procs.xql
    • -0
    • +25
    /openacs-4/packages/acs-subsite/tcl/group-type-procs.xql
    • -0
    • +72
    /openacs-4/packages/acs-subsite/tcl/package-procs-oracle.xql
  1. … 19 more files in changeset.
Correcting a mistake

Now it's close to work