• last updated 15 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Use semicolon as argument name / default value separator, instead of

colon (makes it easier to use in pl/pgsql)

Fixed type (ad_doc to ad_proc, my fingers got confused by the old proc_doc).

More Porting Tcl pages

initial port to postgresql

    • -0
    • +4
    ./packages/acs-interface/sql/postgresql/acs-interface-drop.sql
Initial port

    • -0
    • +141
    ./packages/file-storage/sql/postgresql/file-storage-create.sql
    • -0
    • +38
    ./packages/file-storage/sql/postgresql/file-storage-drop.sql
stores content as "file" in content repository. Comments working

moved acs-object-util from site-wide search to kernel

moved files from site-wide search. It makes more sense to have them in the kernel.

    • -0
    • +133
    ./packages/acs-kernel/sql/oracle/acs-object-util.sql
Fixed error in bookmarks__new; context_id was not being set in acs_objects for all bookmarks -- added dead links checking

    • -0
    • +27
    ./packages/bookmarks/www/bookmarks-user-list-oracle.xql
    • -0
    • +37
    ./packages/bookmarks/www/bookmarks-user-list-postgresql.xql
    • -0
    • +42
    ./packages/bookmarks/www/delete-dead-links-oracle.xql
    • -0
    • +55
    ./packages/bookmarks/www/delete-dead-links-postgresql.xql
Finished form-procs.tcl

    • -10
    • +62
    ./packages/cms/tcl/form-procs-oracle.xql
    • -1
    • +86
    ./packages/cms/tcl/form-procs-postgresql.xql
    • -56
    • +44
    ./packages/cms/tcl/form-procs.tcl

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.

    • -2
    • +2
    ./packages/acs-tcl/tcl/apm-install-procs.tcl
    • -4
    • +4
    ./packages/acs-tcl/tcl/apm-xml-procs.tcl
    • -22
    • +22
    ./packages/bookmarks/bookmarks.info
93% done with porting form-procs.tcl. Stopped at add_basic_revision. Will finish this today (sunday).

    • -0
    • +110
    ./packages/cms/tcl/form-procs-oracle.xql
    • -1
    • +70
    ./packages/cms/tcl/form-procs-postgresql.xql
    • -73
    • +59
    ./packages/cms/tcl/form-procs.tcl

The query extractor had never been run on this, oops, and there were a

couple of rownum references and package calls ... works now even if you

enable user switching.

Initial version of bboard-portlets, grabbed from aD's repository.

Initial revision

    • -0
    • +21
    ./contrib/obsolete-packages/bboard-portlets/www/summarize.adp
    • -0
    • +34
    ./contrib/obsolete-packages/bboard-portlets/www/summarize.tcl
files that were originally in site-wide search - ported by Neophytos Demetriou. Files were moved to the kernel, because it made sesse to do so

    • -0
    • +98
    ./packages/acs-kernel/sql/postgresql/acs-object-util.sql
Fixed seq/sequence in static-pages-create.sql

XQL files missing from previous commit

    • -0
    • +18
    ./packages/static-pages/www/admin/index-oracle.xql
    • -0
    • +19
    ./packages/static-pages/www/admin/index-postgresql.xql
Fix APM to allow for LSB-compliant Paths. It didn't allow "www" in the

path of packages.

more fixup

More fiddling.

Fixing commit emails.

Adding commit email support

    • -0
    • +166
    ./packages/CVSROOT.dotlrn/log.pl
Datamodel loads in postgresql. Beginning work on Tcl

added missing declare

added .xql files for www/admin/orders directory

    • -50
    • +63
    ./packages/ecommerce/ecommerce.info

fixed search query

    • -0
    • +74
    ./packages/ecommerce/www/admin/orders/search-oracle.xql
    • -0
    • +74
    ./packages/ecommerce/www/admin/orders/search-postgresql.xql
    • -49
    • +48
    ./packages/ecommerce/www/admin/orders/search.tcl

fixed money_select query

used db_map for dynamic queries with date calcs

    • -0
    • +26
    ./packages/ecommerce/www/admin/orders/refunds-oracle.xql
    • -0
    • +26
    ./packages/ecommerce/www/admin/orders/refunds-postgresql.xql

used db_map for dynamic sql queries with date calcs