workflow-procs-oracle.xql

  • last updated 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Reduce divergencies between oracle and postgres codebase

  1. … 5 more files in changeset.
oracle query trigger_type/outerjoin fix

oracle outerjoin fix

rolling back

  1. … 31 more files in changeset.
fixing outerjoin for oracle

porting queries in the 2.0 version of workflow from postgres to oracle. Moving common query workflow::case::fsm::get_state_info_not_cached.select_state_info into shared xql file.

  1. … 5 more files in changeset.
Added support for workflows with hierarchy, parallel actions, and dynamic number of parallel actions. Phew.

  1. … 17 more files in changeset.
New ::edit API that handles insert/update/delete for cascaded types (action -> fsm_action -> something else)

  1. … 10 more files in changeset.
changed workflow::get_not_cached to use left outer join so as to not choke when initial action is missing

  1. … 2 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

  1. … 275 more files in changeset.
Merged over workflow from HEAD

  1. … 45 more files in changeset.
First release of workflow

  1. … 37 more files in changeset.
further development of the workflow Tcl API. Added caching of the Tcl API on the workflow level. Port of datamodel to Oracle, some work remaining there. The package is not yet ready for initial release but will be in about 1-2 weeks.

    • -0
    • +26
    ./workflow-procs-oracle.xql
  1. … 29 more files in changeset.