Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/wizard/create-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/wizard/create-oracle.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/wizard/create-oracle.xql 3 May 2001 04:03:03 -0000 1.1
@@ -0,0 +1,46 @@
+
+
+
+ oracle8.1.6
+
+
+
+
+ declare
+ v_workflow_key varchar(40);
+ begin
+ v_workflow_key := workflow.create_workflow(
+ workflow_key => '[db_quote $workflow_key]',
+ pretty_name => '[db_quote $workflow_name]',
+ pretty_plural => '[db_quote $workflow_name]',
+ description => '[db_quote $workflow_description]',
+ table_name => '[db_quote $workflow_cases_table]'
+ );
+ end;
+
+
+
+
+
+
+
+
+ declare
+ v_attribute_id acs_attributes.attribute_id%TYPE;
+ begin
+ v_attribute_id := workflow.create_attribute(
+ workflow_key => '[db_quote $workflow_key]',
+ attribute_name => '[db_quote $task($transition_key,loop_attribute_name)]',
+ datatype => 'boolean',
+ pretty_name => '[db_quote "$task($transition_key,loop_question)"]',
+ default_value => '[ad_decode $task($transition_key,loop_answer) "t" "f" "t"]'
+ );
+
+ insert into wf_transition_attribute_map (workflow_key, transition_key, attribute_id, sort_order)
+ values ('[db_quote $workflow_key]', '[db_quote $transition_key]', v_attribute_id, 1);
+ end;
+
+
+
+
+
Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/wizard/create-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/wizard/create-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/wizard/create-postgresql.xql 3 May 2001 04:03:03 -0000 1.1
@@ -0,0 +1,49 @@
+
+
+
+ postgresql7.1
+
+
+
+
+ select workflow__create_workflow(
+ '[db_quote $workflow_key]',
+ '[db_quote $workflow_name]',
+ '[db_quote $workflow_name]',
+ '[db_quote $workflow_description]',
+ '[db_quote $workflow_cases_table]',
+ 'case_id'
+ );
+
+
+
+
+
+
+
+
+ insert into wf_transition_attribute_map
+ select '[db_quote $workflow_key]' as workflow_key,
+ '[db_quote $transition_key]' as transition_key,
+ workflow__create_attribute(
+ workflow_key => '[db_quote $workflow_key]',
+ attribute_name => '[db_quote $task($transition_key,loop_attribute_name)]',
+ datatype => 'boolean',
+ pretty_name => '[db_quote "$task($transition_key,loop_question)"]',
+ null,
+ null,
+ null,
+ default_value => '[ad_decode $task($transition_key,loop_answer) "t" "f" "t"]',
+ 1,
+ 1,
+ null,
+ 'generic',
+ 'none'
+ ) as attribute_id,
+ 1 as sortorder
+
+
+
+
+
+
Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/wizard/create.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/wizard/create.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/wizard/create.xql 3 May 2001 04:03:03 -0000 1.1
@@ -0,0 +1,135 @@
+
+
+
+
+
+ select pretty_name from acs_object_types
+
+
+
+
+
+
+ select object_type from acs_object_types
+
+
+
+
+
+
+ select constraint_name from user_constraints
+
+
+
+
+
+
+
+create table $workflow_cases_table (
+ case_id integer primary key
+ constraint $workflow_cases_constraint
+ references wf_cases on delete cascade
+)
+
+
+
+
+
+
+
+ insert into wf_places (place_key, workflow_key, place_name, sort_order)
+ values ('[db_quote $task($transition_key,input_place_key)]', '[db_quote $workflow_key]',
+ '[db_quote "Ready to $task($transition_key,task_name)"]', [expr $counter+1])
+
+
+
+
+
+
+
+ insert into wf_places (place_key, workflow_key, place_name, sort_order)
+ values ('end', '[db_quote $workflow_key]', 'Process finished', [expr $num_tasks+1])
+
+
+
+
+
+
+
+ insert into wf_transitions (transition_key, transition_name, workflow_key, sort_order, trigger_type)
+ values ('[db_quote $transition_key]', '[db_quote $task($transition_key,task_name)]',
+ '[db_quote $workflow_key]', [expr $counter+1], 'user')
+
+
+
+
+
+
+
+ insert into wf_arcs (workflow_key, transition_key, place_key, direction)
+ values ('[db_quote $workflow_key]', '[db_quote $transition_key]',
+ '[db_quote $task($transition_key,input_place_key)]', 'in')
+
+
+
+
+
+
+
+ insert into wf_arcs (workflow_key, transition_key, place_key, direction)
+ values ('[db_quote $workflow_key]', '[db_quote $transition_key]',
+ '[db_quote $task($transition_key,output_place_key)]', 'out')
+
+
+
+
+
+
+
+ insert into wf_arcs (workflow_key, transition_key, place_key, direction, guard_callback, guard_description)
+ values ('[db_quote $workflow_key]', '[db_quote $transition_key]',
+ '[db_quote $false_place]', 'out', '
+
+ db_dml insert_true_output_arc
+
+
+
+
+
+
+
+ insert into wf_arcs (workflow_key, transition_key, place_key, direction,
+ guard_callback, guard_custom_arg, guard_description)
+ values ('[db_quote $workflow_key]', '[db_quote $transition_key]', '[db_quote $true_place]', 'out',
+ 'wf_callback.guard_attribute_true', '[db_quote $task($transition_key,loop_attribute_name)]',
+ '[db_quote $task($transition_key,loop_question)]')
+
+
+
+
+
+
+
+ insert into wf_transition_assignment_map (workflow_key, transition_key, assign_transition_key)
+ values ('[db_quote $workflow_key]', '[db_quote $assigning_transition_key]', '[db_quote $transition_key]')
+
+
+
+
+
+
+
+ insert into wf_context_transition_info (context_key, workflow_key, transition_key, estimated_minutes)
+ values ('default', '[db_quote $workflow_key]', '[db_quote $transition_key]', $task_time)
+
+
+
+
+
+
+ drop table $workflow_cases_table
+
+
+
+
+