• last updated 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
fixed cursors that were not being closed in the core

    • -1
    • +3
    ./sql/oracle/workflow-case-package.sql
  1. … 1 more file in changeset.
removed requirement on acs-notifications

    • -2
    • +1
    ./sql/oracle/workflow-case-package.sql
    • -2
    • +1
    ./sql/postgresql/workflow-case-package.sql
  1. … 5 more files in changeset.
converted notification calls to acs_mail_nt calls

    • -12
    • +3
    ./sql/oracle/workflow-case-package.sql
    • -11
    • +9
    ./sql/postgresql/workflow-case-package.sql
  1. … 7 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.

    • -2
    • +4
    ./sql/postgresql/workflow-case-package.sql
  1. … 10 more files in changeset.
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

  1. … 1 more file in changeset.
fixed outer join query

    • -5
    • +5
    ./www/admin/static-assignments-postgresql.xql
more workflow fixup

    • -0
    • +31
    ./www/admin/arc-edit-oracle.xql
    • -0
    • +17
    ./www/admin/arc-edit-postgresql.xql
more workflow cleanup

    • -27
    • +43
    ./sql/postgresql/workflow-case-package.sql
    • -10
    • +30
    ./sql/postgresql/workflow-package.sql
    • -0
    • +87
    ./tcl/workflow-procs-postgresql.xql
    • -0
    • +7
    ./www/admin/workflow-add-2-postgresql.xql
    • -0
    • +20
    ./www/admin/wizard/create-oracle.xql
  1. … 4 more files in changeset.
more debugging of workflow

    • -3
    • +5
    ./sql/postgresql/workflow-case-package.sql
  1. … 2 more files in changeset.
fixed up wf after initial testing

    • -6
    • +8
    ./sql/postgresql/sample-article-create.sql
    • -3
    • +3
    ./sql/postgresql/wf-callback-package.sql
    • -7
    • +12
    ./sql/postgresql/workflow-case-package.sql
    • -0
    • +2
    ./www/assignee-remove-2-postgresql.xql
    • -0
    • +35
    ./www/admin/cases-oracle.xql
    • -0
    • +35
    ./www/admin/cases-postgresql.xql
    • -0
    • +17
    ./www/admin/static-assignments-oracle.xql
    • -0
    • +53
    ./www/admin/static-assignments-postgresql.xql
  1. … 3 more files in changeset.
initial testing and debug work

    • -2
    • +13
    ./tcl/workflow-procs-postgresql.xql
added query files for main workflow page

    • -0
    • +42
    ./www/task-list-oracle.xql
    • -0
    • +41
    ./www/task-list-postgresql.xql
fixed permissions problem for handling insertion of dup index values

    • -5
    • +5
    ./www/admin/wizard/create-postgresql.xql
  1. … 1 more file in changeset.
fixed up a few queries that I missed on the initial porting pass

    • -30
    • +34
    ./tcl/workflow-procs-postgresql.xql

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. … 36 more files in changeset.
added more query files

    • -0
    • +46
    ./www/admin/wizard/create-oracle.xql
    • -0
    • +49
    ./www/admin/wizard/create-postgresql.xql
    • -0
    • +135
    ./www/admin/wizard/create.xql
tested lob support for content-repository. converted photo upload in acs-subsite to use lobs instead of files

  1. … 9 more files in changeset.
new query files

    • -0
    • +28
    ./www/admin/arc-add.xql
    • -0
    • +17
    ./www/admin/arc-delete.xql
    • -0
    • +20
    ./www/admin/arc-edit-2.xql
    • -0
    • +46
    ./www/admin/arc-edit.xql
    • -0
    • +24
    ./www/admin/attribute-add-2-oracle.xql
    • -0
    • +28
    ./www/admin/attribute-add-2-postgresql.xql
    • -0
    • +26
    ./www/admin/attribute-add.xql
    • -0
    • +19
    ./www/admin/attribute-delete-oracle.xql
    • -0
    • +17
    ./www/admin/attribute-delete-postgresql.xql
    • -0
    • +29
    ./www/admin/attribute-delete.xql
    • -0
    • +44
    ./www/admin/attributes.xql
    • -0
    • +25
    ./www/admin/case-debug-oracle.xql
    • -0
    • +25
    ./www/admin/case-debug-postgresql.xql
    • -0
    • +55
    ./www/admin/case-debug.xql
    • -0
    • +48
    ./www/admin/cases.xql
  1. … 62 more files in changeset.

New info files with truncated rather than PG timestamps.

  1. … 2 more files in changeset.

Removed more of the "default '' not null" kludge.

    • -42
    • +42
    ./sql/postgresql/wf-core-create.sql
    • -516
    • +0
    ./sql/test/workflow-case-package-test.sql
  1. … 17 more files in changeset.
updated package spec to include new .xql files

1. Fixed apm_load_queries. Again? Yes, again. I fixed it real good this

time.

2. Added .xql files for acs-admin. APM .xql files have mostly but not

completely been ported. It sort of works though, cool!

1. Fixed apm_load_queries. Again? Yes, again. I fixed it real good this

time.

2. Added .xql files for acs-admin. APM .xql files have mostly but not

completely been ported. It sort of works though, cool!

  1. … 60 more files in changeset.
query extraction and cleanup

    • -0
    • +50
    ./tcl/display-procs-oracle.xql
    • -0
    • +50
    ./tcl/display-procs-postgresql.xql
    • -0
    • +77
    ./tcl/graph-procs.xql
    • -0
    • +296
    ./tcl/workflow-procs-oracle.xql
    • -0
    • +281
    ./tcl/workflow-procs-postgresql.xql
    • -0
    • +246
    ./tcl/workflow-procs.xql
    • -0
    • +18
    ./www/assign-add-postgresql.xql
    • -0
    • +35
    ./www/assign-yourself-oracle.xql
    • -0
    • +31
    ./www/assign-yourself-postgresql.xql
    • -0
    • +65
    ./www/assign-yourself.xql
    • -0
    • +35
    ./www/assignee-add-2-oracle.xql
    • -0
    • +31
    ./www/assignee-add-2-postgresql.xql
    • -0
    • +53
    ./www/assignee-add-2.xql
    • -0
    • +18
    ./www/assignee-add-oracle.xql
    • -0
    • +18
    ./www/assignee-add-postgresql.xql
  1. … 13 more files in changeset.
added comments for default parameters

    • -21
    • +21
    ./sql/postgresql/workflow-case-package.sql
    • -18
    • +18
    ./sql/postgresql/workflow-package.sql
  1. … 9 more files in changeset.
added postgresql files to package info file and commented out notifications calls until notifications is ported

    • -4
    • +5
    ./sql/postgresql/workflow-case-package.sql
adding test directory to repository

    • -0
    • +587
    ./sql/postgresql/test/workflow-case-package-test.sql
cleanup of dir structure

    • -0
    • +346
    ./sql/postgresql/upgrade/upgrade-4.0-4.0.1.sql
    • -0
    • +190
    ./sql/postgresql/upgrade/upgrade-4.0.1-4.1b.sql
    • -346
    • +0
    ./sql/upgrade/upgrade-4.0-4.0.1.sql
    • -190
    • +0
    ./sql/upgrade/upgrade-4.0.1-4.1b.sql
cleanup of unused functions

    • -2
    • +2
    ./sql/postgresql/sample-article-create.sql
    • -2
    • +2
    ./sql/postgresql/wf-callback-package.sql