• last updated 14 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
ported queries

    • -0
    • +15
    ./ticket-tracker-lite/tcl/ticket-tracker-lite-procs-oracle.xql
    • -0
    • +15
    ./ticket-tracker-lite/tcl/ticket-tracker-lite-procs-postgresql.xql
    • -1
    • +1
    ./ticket-tracker-lite/tcl/ticket-tracker-lite-procs.tcl
    • -0
    • +18
    ./ticket-tracker-lite/www/assignment-ae-oracle.xql
    • -0
    • +18
    ./ticket-tracker-lite/www/assignment-ae-postgresql.xql
    • -2
    • +2
    ./ticket-tracker-lite/www/assignment-ae.tcl
    • -0
    • +13
    ./ticket-tracker-lite/www/assignment-ae.xql
    • -0
    • +19
    ./ticket-tracker-lite/www/comment-ae-2-oracle.xql
    • -0
    • +19
    ./ticket-tracker-lite/www/comment-ae-2-postgresql.xql
    • -5
    • +5
    ./ticket-tracker-lite/www/comment-ae-2.tcl
    • -0
    • +59
    ./ticket-tracker-lite/www/comment-ae-2.xql
    • -2
    • +2
    ./ticket-tracker-lite/www/comment-ae.tcl
    • -0
    • +32
    ./ticket-tracker-lite/www/comment-ae.xql
    • -1
    • +1
    ./ticket-tracker-lite/www/comments.tcl
    • -0
    • +22
    ./ticket-tracker-lite/www/comments.xql
  1. … 48 more files in changeset.
ported datamodel to pg

    • -0
    • +182
    ./ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql
    • -0
    • +38
    ./ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-drop.sql
    • -0
    • +100
    ./ticket-tracker-lite/sql/postgresql/views-and-plsql.sql
cleanup

    • -2
    • +2
    ./acs-workflow/www/admin/attribute-add-2.tcl
    • -2
    • +2
    ./acs-workflow/www/admin/attribute-delete.tcl
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

    • -2
    • +6
    ./acs-workflow/tcl/workflow-procs-oracle.xql
  1. … 1 more file in changeset.
fixed outer join query

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

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

    • -0
    • +80
    ./acs-workflow/tcl/workflow-procs-oracle.xql
    • -0
    • +87
    ./acs-workflow/tcl/workflow-procs-postgresql.xql
    • -43
    • +8
    ./acs-workflow/tcl/workflow-procs.tcl
    • -3
    • +3
    ./acs-workflow/www/admin/workflow-copy.tcl
    • -3
    • +3
    ./acs-workflow/www/admin/workflow-copy.xql
    • -3
    • +3
    ./acs-workflow/www/admin/workflow-delete.tcl
  1. … 4 more files in changeset.
more debugging of workflow

  1. … 2 more files in changeset.
fixed up wf after initial testing

    • -1
    • +17
    ./acs-workflow/tcl/display-procs-oracle.xql
    • -0
    • +16
    ./acs-workflow/tcl/display-procs-postgresql.xql
    • -4
    • +2
    ./acs-workflow/tcl/workflow-procs-postgresql.xql
    • -1
    • +1
    ./acs-workflow/www/assignee-add-postgresql.xql
    • -0
    • +2
    ./acs-workflow/www/assignee-remove-2-postgresql.xql
    • -0
    • +35
    ./acs-workflow/www/admin/cases-oracle.xql
    • -0
    • +35
    ./acs-workflow/www/admin/cases-postgresql.xql
    • -0
    • +17
    ./acs-workflow/www/admin/static-assignments-oracle.xql
    • -0
    • +53
    ./acs-workflow/www/admin/static-assignments-postgresql.xql
  1. … 3 more files in changeset.
initial testing and debug work

    • -2
    • +11
    ./acs-workflow/tcl/workflow-procs-oracle.xql
    • -2
    • +13
    ./acs-workflow/tcl/workflow-procs-postgresql.xql
    • -18
    • +6
    ./acs-workflow/tcl/workflow-procs.tcl
added query files for main workflow page

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

  1. … 1 more file in changeset.
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.