Added: oodt/trunk/workflow/src/test/resources/workflow.sql URL: http://svn.apache.org/viewvc/oodt/trunk/workflow/src/test/resources/workflow.sql?rev=1653721&view=auto ============================================================================== --- oodt/trunk/workflow/src/test/resources/workflow.sql (added) +++ oodt/trunk/workflow/src/test/resources/workflow.sql Thu Jan 22 00:14:55 2015 @@ -0,0 +1,81 @@ + +DROP TABLE workflows IF EXISTS; +DROP TABLE workflow_condition_map IF EXISTS; +DROP TABLE event_workflow_map IF EXISTS; +DROP TABLE workflow_tasks IF EXISTS; +DROP TABLE workflow_task_map IF EXISTS; +DROP TABLE workflow_instances IF EXISTS; +DROP TABLE workflow_instance_metadata IF EXISTS; +DROP TABLE workflow_conditions IF EXISTS; +DROP TABLE task_condition_map IF EXISTS; +DROP TABLE workflow_task_configuration IF EXISTS; +DROP TABLE workflow_condition_configuration IF EXISTS; + +CREATE TABLE workflows +(workflow_id int NOT NULL PRIMARY KEY, +workflow_name varchar(255)); + +CREATE TABLE workflow_condition_map +(workflow_id int NOT NULL, +workflow_condition_id int NOT NULL, +condition_order int NOT NULL); + +CREATE TABLE event_workflow_map +(workflow_id int NOT NULL, +event_name varchar(255) NOT NULL); + +CREATE TABLE workflow_tasks +(workflow_task_id int NOT NULL PRIMARY KEY, +workflow_task_name varchar(255), +workflow_task_class varchar(255)); + +CREATE TABLE workflow_task_map +(workflow_id int NOT NULL, +workflow_task_id int NOT NULL, +task_order int NOT NULL); + +CREATE TABLE workflow_instances +(workflow_instance_id int NOT NULL PRIMARY KEY, +workflow_instance_status varchar(255), +workflow_id int NOT NULL, +current_task_id int NOT NULL, +start_date_time varchar(255), +end_date_time varchar(255), +current_task_start_date_time varchar(255), +current_task_end_date_time varchar(255), +priority float NOT NULL, +times_blocked int DEFAULT 0); + +CREATE TABLE workflow_instance_metadata +(workflow_instance_id int NOT NULL, +workflow_met_key varchar(1000) NOT NULL, +workflow_met_val varchar(1000) NOT NULL); + +CREATE TABLE workflow_conditions +(workflow_condition_id int NOT NULL PRIMARY KEY, +workflow_condition_name varchar(255) NOT NULL, +workflow_condition_class varchar(255) NOT NULL, +workflow_condition_timeout int NOT NULL, +workflow_condition_optional boolean DEFAULT false); + +CREATE TABLE task_condition_map +(workflow_task_id int NOT NULL, +workflow_condition_id int NOT NULL, +condition_order int NOT NULL); + +CREATE TABLE workflow_task_configuration +(workflow_task_id int NOT NULL, +property_name varchar(1000) NOT NULL, +property_value varchar(1000) NOT NULL); + +CREATE TABLE workflow_condition_configuration +(workflow_condition_id int NOT NULL, +property_name varchar(1000) NOT NULL, +property_value varchar(1000) NOT NULL); + +INSERT INTO workflow_conditions VALUES ('1', 'CheckCond', 'org.apache.oodt.cas.workflow.examples.CheckForMetadataKeys', 30, false); +INSERT INTO workflow_condition_configuration VALUES ('1', 'reqMetKeys', 'Met1,Met2,Met3'); +INSERT INTO workflow_conditions VALUES ('2', 'FalseCond', 'org.apache.oodt.cas.workflow.examples.FalseCondition', 10, true); +INSERT INTO workflow_conditions VALUES ('3', 'TrueCond', 'org.apache.oodt.cas.workflow.examples.TrueCondition', 30, true); +INSERT INTO workflows VALUES ('1', 'Test Workflow'); +INSERT INTO workflow_condition_map VALUES ('1', '3', '1');
