• last updated 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
more cleanup

Fixed more syntax errors

more porting work

Changing file names.

modified acs_object scripts and fixed syntax error. This will now load

took out Oracle package dependency

started porting work

created postgresql sql directory

    • -0
    • +298
    /openacs-4/packages/cms/sql/postgresql/cms-content-methods.sql
    • -0
    • +243
    /openacs-4/packages/cms/sql/postgresql/cms-create.sql
    • -0
    • +4
    /openacs-4/packages/cms/sql/postgresql/cms-drop.sql
    • -0
    • +115
    /openacs-4/packages/cms/sql/postgresql/cms-fix.sql
    • -0
    • +415
    /openacs-4/packages/cms/sql/postgresql/cms-forms.sql
    • -0
    • +60
    /openacs-4/packages/cms/sql/postgresql/cms-update.sql
    • -0
    • +295
    /openacs-4/packages/cms/sql/postgresql/cms-widgets.sql
    • -0
    • +131
    /openacs-4/packages/cms/sql/postgresql/rel-test.sql
cleanup

removed cancel and resume links from cases that are finished - use of these links throws an error

fixed oracle db api so that db_exec_plsql command would still work after the passed in sql query is converted to an empty string

fixed outer join query

fixed some bugs discovered by Vinod Kurup

added file_size to pg datamodel, pg queries. Moved calc (size = bytes/1024) from tcl to sql

Added db_map for oracle-specific partial queries.

Fixed problem caused by dimensional being used twice (renamed to

dimensional_html)

Fixed problem that had set archive_type_id to 'All' (not an integer)

aD used the var 'dimensional' in a query and then reassigned it, so when

the query dispatcher tries to acces 'dimensional', it accesses the wrong

one. renamed the second use to dimensional_html

added partial queries

Added partial queries

more workflow fixup

more workflow cleanup

  1. … 4 more files in changeset.
updated date types to timestamp, eliminated nvl

Port queries/query extractor output

    • -100
    • +10
    /openacs-4/packages/acs-subsite/tcl/package-procs.xql
  1. … 166 more files in changeset.
initial version

more debugging of workflow

fixed up wf after initial testing

  1. … 3 more files in changeset.
fixed more queries

fixed sequences. Updated functions. Improved drop script

changed to consistent sequence names

initial testing and debug work

added query files for main workflow page