• last updated 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
fixed up a few queries that I missed on the initial porting pass

    • -30
    • +34
    ./acs-workflow/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. … 34 more files in changeset.
Start of postgresql port

    • -0
    • +239
    ./wap/sql/oracle/wap-create.sql
    • -0
    • +17
    ./wap/sql/oracle/wap-drop.sql
    • -0
    • +229
    ./wap/sql/postgresql/wap-create.sql
    • -0
    • +13
    ./wap/sql/postgresql/wap-drop.sql
Start of postgresql port

    • -0
    • +23
    ./postcard/sql/postgresql/postcard-create.sql
    • -0
    • +5
    ./postcard/sql/postgresql/postcard-drop.sql
    • -0
    • +17
    ./postcard/www/add-picture-2-oracle.xql
    • -0
    • +16
    ./postcard/www/add-picture-2-postgresql.xql
    • -0
    • +15
    ./postcard/www/dump-cards.xql
    • -0
    • +17
    ./postcard/www/postcard-picture-oracle.xql
    • -0
    • +17
    ./postcard/www/postcard-picture-postgresql.xql
    • -0
    • +14
    ./postcard/www/postcard-picture.xql
    • -0
    • +23
    ./postcard/www/send-card.xql
    • -0
    • +17
    ./postcard/www/show-card-oracle.xql
    • -0
    • +17
    ./postcard/www/show-card-postgresql.xql
    • -0
    • +15
    ./postcard/www/show-card.xql
  1. … 13 more files in changeset.
use of drop_package to drop all functions created

Start postgres port

    • -1
    • +1
    ./wf-ticket-tracker/wf-ticket-tracker.info
Start postgres port

    • -0
    • +6
    ./wf-ticket-tracker/wf-ticket-tracker.info
    • -0
    • +11
    ./wf-ticket-tracker/www/panel-ticket.xql
    • -0
    • +25
    ./wf-ticket-tracker/www/ticket-new-2-oracle.xql
    • -0
    • +22
    ./wf-ticket-tracker/www/ticket-new-2-postgresql.xql
Add default creation_date handling when passing null or 0 as value for that

Start postgres port

    • -0
    • +149
    ./wf-ticket-tracker/sql/postgresql/ticket-workflow-create.sql
    • -0
    • +103
    ./wf-ticket-tracker/sql/postgresql/wf-ticket-tracker-create.sql
    • -0
    • +9
    ./wf-ticket-tracker/sql/postgresql/wf-ticket-tracker-drop.sql
added more query files

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

    • -11
    • +87
    ./acs-workflow/acs-workflow.info
  1. … 9 more files in changeset.
new query files

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

NB. string-package.sql has not been done, it uses user-defined types

as function parameters, and is only used in acs-notifications (once)

which is being rewritten anyway.

    • -0
    • +3
    ./acs-util/sql/postgresql/acs-util-create.sql
    • -0
    • +1
    ./acs-util/sql/postgresql/acs-util-drop.sql
    • -0
    • +71
    ./acs-util/sql/postgresql/acs-util-package.sql
    • -0
    • +116
    ./acs-util/sql/postgresql/string-package.sql
    • -0
    • +36
    ./acs-util/sql/postgresql/test/acs-util-test.sql

New info files with truncated rather than PG timestamps.

  1. … 2 more files in changeset.

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

    • -0
    • +120
    ./acs-content/sql/oracle/upgrade/upgrade-4.1-4.1.1.sql
    • -516
    • +0
    ./acs-workflow/sql/test/workflow-case-package-test.sql
  1. … 15 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!

    • -2
    • +2
    ./acs-workflow/tcl/workflow-procs-postgresql.xql
  1. … 60 more files in changeset.
query extraction and cleanup

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

Forgot to define binary files before importing, so .gifs were messed up.

    • -0
    • +0
    ./bboard/sql/oracle/bboard-packages.sql
    • -0
    • +0
    ./bboard/sql/oracle/upgrade-4.0-4.0.1.sql
    • -0
    • +0
    ./bboard/sql/oracle/upgrade-4.0.2b3-4.0.2b4.sql
    • -0
    • +0
    ./bboard/sql/oracle/upgrade-4.0.2b5-4.0.2b6.sql
    • -0
    • +0
    ./bboard/sql/oracle/upgrade-4.0b-4.0.sql
  1. … 2465 more files in changeset.
Initial revision

    • -0
    • +116
    ./bboard/ChangeLog
    • -0
    • +116
    ./bboard/bboard.info
    • -0
    • +453
    ./bboard/sql/oracle/bboard-create.sql
    • -0
    • +144
    ./bboard/sql/oracle/bboard-drop.sql
    • -0
    • +571
    ./bboard/sql/oracle/bboard-packages.sql
    • -0
    • +34
    ./bboard/sql/oracle/bboard-views.sql
    • -0
    • +11
    ./bboard/sql/oracle/index_sync.sql
    • -0
    • +139
    ./bboard/sql/oracle/upgrade-4.0-4.0.1.sql
    • -0
    • +163
    ./bboard/sql/oracle/upgrade-4.0.1-4.0.2.sql
    • -0
    • +55
    ./bboard/sql/oracle/upgrade-4.0.2b3-4.0.2b4.sql
    • -0
    • +11
    ./bboard/sql/oracle/upgrade-4.0.2b5-4.0.2b6.sql
    • -0
    • +152
    ./bboard/sql/oracle/upgrade-4.0b-4.0.sql
    • -0
    • +11
    ./bboard/tcl/bboard-init.tcl
    • -0
    • +1010
    ./bboard/tcl/bboard-procs.tcl
    • -0
    • +16
    ./bboard/www/attachment-delete.tcl
  1. … 2465 more files in changeset.
added comments for default parameters

  1. … 9 more files in changeset.
added postgresql files to package info file and commented out notifications calls until notifications is ported

adding test directory to repository

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

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

cleanup of usused functions

fixed up some incompatiblities

finished porting test script

work on test script

1. Ran APM on acs-tcl.info

2. Fixed two typos by Dan in the acs-workflow datamodel.

  1. … 1 more file in changeset.