00-database-procs-postgresql.tcl

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

1. Fixed a bug in the oracle version of acs-mail-nt-create.sql

2. Fixed a bug in the oracle version of the APM - a standard SQL92

left join was being executed rather than the nasty Oracle-specific

notation.

3. Futzed with the APM a bit - you can now only set "watch" commands on

those .xql files which are used by the current installation, you can

only install packages supported by the current installation's RDBMS.

  1. … 8 more files in changeset.

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.

  1. … 10 more files in changeset.
fixed uplevel name collision

adde switches to prevent error on clobs and blobs

fixed logging to be more configurable within the QD and default to not so verbose.

    • -10
    • +10
    ./00-database-procs-postgresql.tcl
  1. … 2 more files in changeset.
more debugging of workflow

  1. … 3 more files in changeset.
psql doesn't like -U without a username

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.

    • -11
    • +63
    ./00-database-procs-postgresql.tcl
  1. … 36 more files in changeset.
tested and fixed the template query db api

  1. … 26 more files in changeset.
added blobs switch to db_dml, so that update statements can be ported to write the content column directly

more cleanup of CR and blob support

    • -16
    • +82
    ./00-database-procs-postgresql.tcl
  1. … 3 more files in changeset.
converted apm to store package tarballs in the content repository

  1. … 7 more files in changeset.
added comment about db_dml -blob_files change

tested lob support for content-repository. converted photo upload in acs-subsite to use lobs instead of files

  1. … 9 more files in changeset.
finished porting portrait upload to work with CR

    • -16
    • +36
    ./00-database-procs-postgresql.tcl
  1. … 4 more files in changeset.
work on protrait upload

  1. … 5 more files in changeset.
more query extraction work

    • -10
    • +80
    ./00-database-procs-postgresql.tcl
  1. … 6 more files in changeset.
added tcl variable support to db api

  1. … 3 more files in changeset.
updated API of DB QD

  1. … 4 more files in changeset.

Call to psql to load datamodels needs to be done in the directory that

the datamodel lives in, as includes in psql are resolved relative to

the current working directoy. I missed this earlier - sqlplus resolves

includes relative to the loading .sql file itself.

Moved the bootstrap and installer stuff into their own mini-package, which

let me clean up the loading of acs-tcl a bit and isolate all the bits of

APM-knowledge required in the pre-acs-tcl bootstrapping process into a single

apm file. In general, bootstrap.tcl is cleaner and easier to read.

    • -0
    • +494
    ./00-database-procs-postgresql.tcl
  1. … 37 more files in changeset.