OpenACS / openacs-4 / packages / workflow

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 16
Last Commit: 05 Apr
Commits this week: 0
Total Lines of Code (LoC): 4,067
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 18 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 29 Jun 2004
12:18 pm

olah

I forgot to commit the upgrade script for Oracle

Options
    • -0
    • +107
    ./oracle/upgrade/upgrade-2.0.0b3-2.0.0b4.sql
12:11 pm

olah

Made some changes to allow wf case objects to be plain objects (items worked without problems), see: http://openacs.org/forums/message-view?message_id=192465 ... I have not been able to test the upgrade script for Oracle.

Options
    • -3
    • +16
    ./oracle/workflow-procedural-create.sql
    • -3
    • +16
    ./postgresql/workflow-procedural-create.sql
    • -0
    • +100
    ./postgresql/upgrade/upgrade-2.0.0b3-2.0.0b4.sql
  4. … 2 more files in changeset.
Thursday 29 Apr 2004
10:20 pm

jeffd

upgrade-1.2d1-1.2b2.sql should have been named upgrade-1.2d2-1.2b2.sql as it overlapped with the upgrade-1.2d1-1.2d2.sql script an so was not executed when upgrading from core 5.0.4

Options
    • -148
    • +0
    ./oracle/upgrade/upgrade-1.2d1-1.2b2.sql
    • -0
    • +148
    ./oracle/upgrade/upgrade-1.2d2-1.2b2.sql
    • -130
    • +0
    ./postgresql/upgrade/upgrade-1.2d1-1.2b2.sql
    • -0
    • +130
    ./postgresql/upgrade/upgrade-1.2d2-1.2b2.sql
Sunday 07 Mar 2004
12:08 pm

maltes

Added missing drop statements

Options
    • -0
    • +6
    ./postgresql/workflow-tables-drop.sql
Thursday 05 Feb 2004
11:35 am

peterm

the workflow_user_deputy_map view was broken in oracle. Caught thanks to the extensive automated tests written by Lars

Options
    • -6
    • +7
    ./oracle/workflow-tables-create.sql
    • -2
    • +4
    ./oracle/upgrade/upgrade-1.2-2.0d1.sql
Friday 30 Jan 2004
10:46 am

peterm

porting the table-create sql script and the 1.2-2.0d1 upgrade script from PG to Oracle

Options
    • -114
    • +169
    ./oracle/workflow-tables-create.sql
    • -79
    • +230
    ./oracle/upgrade/upgrade-1.2-2.0d1.sql
    • -4
    • +4
    ./postgresql/workflow-tables-create.sql
    • -6
    • +6
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  5. … 1 more file in changeset.
Thursday 29 Jan 2004
1:47 pm

peterm

the trigger type constraint in the upgrade script was old. Caught this problem thanks to the automated tests that Lars have written.

Options
    • -2
    • +2
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
12:10 pm

peterm

need to drop old workflow_deputies column with cascade

Options
    • -3
    • +3
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
Wednesday 28 Jan 2004
10:39 am

peterm

changing proc workflow::case::fsm::get to allow parent_enabled_action_id to be null. Removing two obsolete TODOs

Options
    • -4
    • +1
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  2. … 1 more file in changeset.
Monday 26 Jan 2004
1:33 pm

lars

- Short_names are workflow-wide

- pretty-names are unique per parent_action_id

Options
    • -2
    • +2
    ./postgresql/workflow-tables-create.sql
    • -1
    • +14
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  3. … 4 more files in changeset.
Friday 23 Jan 2004
12:02 pm

lars

Added support for workflows with hierarchy, parallel actions, and dynamic number of parallel actions. Phew.

Options
    • -5
    • +3
    ./postgresql/workflow-procedural-create.sql
    • -199
    • +212
    ./postgresql/workflow-tables-create.sql
    • -176
    • +221
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  4. … 15 more files in changeset.
Monday 12 Jan 2004
11:56 am

lars

Added unique constraint on workflow_fsm_action_en_in_st table

Options
    • -2
    • +3
    ./postgresql/workflow-tables-create.sql
    • -1
    • +5
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
Friday 09 Jan 2004
4:47 pm

lars

Recursive workflows

Options
    • -3
    • +5
    ./postgresql/workflow-procedural-create.sql
    • -17
    • +33
    ./postgresql/workflow-tables-create.sql
    • -1
    • +114
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  4. … 10 more files in changeset.
Thursday 08 Jan 2004
5:00 pm

lars

Definition-level support for recursive workflows

Options
    • -24
    • +15
    ./oracle/workflow-tables-create.sql
    • -24
    • +15
    ./oracle/upgrade/upgrade-1.2-2.0d1.sql
    • -24
    • +13
    ./postgresql/workflow-tables-create.sql
    • -0
    • +1
    ./postgresql/workflow-tables-drop.sql
    • -24
    • +15
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  6. … 2 more files in changeset.
2:23 pm

lars

- Fixed on delete cascade -> on delete set null for workflow_fsm_actions

- Added definition level tables for recursive workflows

Options
    • -0
    • +40
    ./oracle/workflow-tables-create.sql
    • -1
    • +57
    ./oracle/upgrade/upgrade-1.2-2.0d1.sql
    • -1
    • +40
    ./postgresql/workflow-tables-create.sql
    • -1
    • +50
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
Monday 05 Jan 2004
4:42 pm

lars

Do not default to text/plain for description_mime_type

Options
    • -2
    • +2
    ./postgresql/workflow-tables-create.sql
Tuesday 16 Dec 2003
7:18 pm

lars

New ::edit API that handles insert/update/delete for cascaded types (action -> fsm_action -> something else)

Options
    • -0
    • +4
    ./postgresql/workflow-tables-create.sql
    • -1
    • +6
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  3. … 9 more files in changeset.
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -11
    • +3
    ./oracle/workflow-procedural-create.sql
    • -1
    • +1
    ./oracle/workflow-tables-create.sql
    • -0
    • +148
    ./oracle/upgrade/upgrade-1.2d1-1.2b2.sql
    • -10
    • +0
    ./postgresql/workflow-procedural-create.sql
    • -0
    • +130
    ./postgresql/upgrade/upgrade-1.2d1-1.2b2.sql
  6. … 594 more files in changeset.
Wednesday 10 Dec 2003
5:05 pm

lars

Comment about a missing unique constraint

Options
    • -0
    • +1
    ./postgresql/workflow-tables-create.sql
Tuesday 09 Dec 2003
5:33 pm

janines

fixing typo in comment that was causing an Oracle error

Options
    • -1
    • +1
    ./oracle/workflow-tables-create.sql
Monday 01 Dec 2003
10:53 am

lars

- Added role::edit, role::get_options

- Adding unique constraints on short_name and pretty_name to roles, actions, fsm_states

Options
    • -3
    • +16
    ./oracle/workflow-tables-create.sql
    • -1
    • +12
    ./oracle/upgrade/upgrade-1.2-2.0d1.sql
    • -3
    • +15
    ./postgresql/workflow-tables-create.sql
    • -1
    • +12
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  5. … 5 more files in changeset.
Tuesday 18 Nov 2003
6:57 pm

lars

Added timed actions

Options
    • -1
    • +41
    ./oracle/workflow-tables-create.sql
    • -0
    • +48
    ./oracle/upgrade/upgrade-1.2-2.0d1.sql
    • -1
    • +38
    ./postgresql/workflow-tables-create.sql
    • -0
    • +42
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  5. … 15 more files in changeset.
6:54 pm

lars

file upgrade-1.2d1-1.2b2.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-1.2d1-1.2b2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.2d1-1.2b2.sql
6:54 pm

lars

Fixed bug #361 again (parent_id of log entry cr_items point to case's object), this time providing an upgrade script, changing the parent_id of existing log entries, and fixing the case deletion proc to delete cases properly given the parent_id.

Options
    • -11
    • +3
    ./oracle/workflow-procedural-create.sql
    • -0
    • +148
    ./oracle/upgrade/upgrade-1.2d1-1.2b2.sql
    • -10
    • +0
    ./postgresql/workflow-procedural-create.sql
    • -0
    • +130
    ./postgresql/upgrade/upgrade-1.2d1-1.2b2.sql
  5. … 1 more file in changeset.
Thursday 13 Nov 2003
3:22 pm

joela

added description and description_mime_types to workflows

Options
    • -0
    • +2
    ./oracle/workflow-tables-create.sql
    • -0
    • +13
    ./oracle/upgrade/upgrade-1.2d1.1.2d2.sql
    • -0
    • +2
    ./postgresql/workflow-tables-create.sql
    • -0
    • +17
    ./postgresql/upgrade/upgrade-1.2d1-1.2d2.sql
Thursday 30 Oct 2003
12:14 pm

joela

added two new fields to workflow_actions

Options
    • -0
    • +2
    ./oracle/workflow-tables-create.sql
    • -0
    • +13
    ./oracle/upgrade/upgrade-1.1d1-1.2d1.sql
    • -0
    • +2
    ./postgresql/workflow-tables-create.sql
    • -0
    • +17
    ./postgresql/upgrade/upgrade-1.1d1-1.2d1.sql
Friday 03 Oct 2003
3:26 pm

peterm

bug 361: making cr_items.parent_id of case log entries be the object_id of the object governed by the case, just like for the acs_object.context_id of the case

Options
    • -1
    • +1
    ./oracle/workflow-procedural-create.sql
    • -1
    • +1
    ./postgresql/workflow-procedural-create.sql
12:12 pm

jeffd

drop workflow_case_assigned_actions view

Options
    • -1
    • +1
    ./postgresql/workflow-tables-create.sql
    • -0
    • +1
    ./postgresql/workflow-tables-drop.sql
Tuesday 30 Sep 2003
2:10 pm

mohanp

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)

Options
    • -1
    • +1
    ./oracle/workflow-data-drop.sql
    • -9
    • +9
    ./oracle/workflow-procedural-create.sql
    • -1
    • +1
    ./oracle/workflow-tables-drop.sql
  4. … 273 more files in changeset.
Sunday 28 Sep 2003
3:24 am

lars

Added view workflow_case_assigned_actions

Options
    • -1
    • +22
    ./oracle/workflow-tables-create.sql
    • -0
    • +27
    ./oracle/upgrade/upgrade-1.0d5-1.1d1.sql
    • -0
    • +21
    ./postgresql/workflow-tables-create.sql
    • -0
    • +26
    ./postgresql/upgrade/upgrade-1.0d5-1.1d1.sql
  5. … 1 more file in changeset.