adding workflow database scripts
Project: http://git-wip-us.apache.org/repos/asf/airavata/repo Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/c4517231 Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/c4517231 Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/c4517231 Branch: refs/heads/master Commit: c45172319fa3162bee57d20d028cbb431efd9d00 Parents: 494e0d7 Author: Chathuri Wimalasena <[email protected]> Authored: Mon Feb 1 14:09:05 2016 -0500 Committer: Chathuri Wimalasena <[email protected]> Committed: Mon Feb 1 14:09:05 2016 -0500 ---------------------------------------------------------------------- .../src/main/resources/workflow-derby.sql | 117 +++++++++++++++++++ .../src/main/resources/workflow-mysql.sql | 117 +++++++++++++++++++ 2 files changed, 234 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/airavata/blob/c4517231/modules/registry/registry-core/src/main/resources/workflow-derby.sql ---------------------------------------------------------------------- diff --git a/modules/registry/registry-core/src/main/resources/workflow-derby.sql b/modules/registry/registry-core/src/main/resources/workflow-derby.sql new file mode 100644 index 0000000..e798824 --- /dev/null +++ b/modules/registry/registry-core/src/main/resources/workflow-derby.sql @@ -0,0 +1,117 @@ +/* + * + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + * + */ + +CREATE TABLE WORKFLOW +( + TEMPLATE_ID VARCHAR (255) NOT NULL, + WORKFLOW_NAME VARCHAR (255) NOT NULL, + GRAPH CLOB, + IMAGE BLOB, + PRIMARY KEY (TEMPLATE_ID) +); + +CREATE TABLE WORKFLOW_INPUT +( + TEMPLATE_ID VARCHAR(255), + INPUT_KEY VARCHAR(255), + INPUT_VALUE VARCHAR(255), + DATA_TYPE VARCHAR(255), + METADATA VARCHAR(255), + APP_ARGUMENT VARCHAR(255), + STANDARD_INPUT SMALLINT, + USER_FRIENDLY_DESC VARCHAR(255), + INPUT_ORDER INTEGER, + IS_REQUIRED SMALLINT, + REQUIRED_TO_COMMANDLINE SMALLINT, + DATA_STAGED SMALLINT, + PRIMARY KEY(TEMPLATE_ID,INPUT_KEY), + FOREIGN KEY (TEMPLATE_ID) REFERENCES WORKFLOW(TEMPLATE_ID) ON DELETE CASCADE +); + +CREATE TABLE WORKFLOW_OUTPUT +( + TEMPLATE_ID VARCHAR(255), + OUTPUT_KEY VARCHAR(255), + OUTPUT_VALUE VARCHAR(255), + DATA_TYPE VARCHAR(255), + IS_REQUIRED SMALLINT, + REQUIRED_TO_COMMANDLINE SMALLINT, + DATA_MOVEMENT SMALLINT, + DATA_NAME_LOCATION VARCHAR(255), + SEARCH_QUERY VARCHAR(255), + APP_ARGUMENT VARCHAR(255), + OUTPUT_STREAMING SMALLINT, + PRIMARY KEY(TEMPLATE_ID,OUTPUT_KEY), + FOREIGN KEY (TEMPLATE_ID) REFERENCES WORKFLOW(TEMPLATE_ID) ON DELETE CASCADE +); + +CREATE TABLE COMPONENT_STATUS +( + STATUS_ID VARCHAR (255) NOT NULL, + STATE VARCHAR(255), + REASON VARCHAR(255), + PRIMARY KEY (STATUS_ID) +); + +CREATE TABLE WORKFLOW_STATUS +( + STATUS_ID VARCHAR (255) NOT NULL, + TEMPLATE_ID VARCHAR (255) NOT NULL, + STATE VARCHAR(255), + REASON VARCHAR(255), + PRIMARY KEY (STATUS_ID, COMPONENT_ID), + FOREIGN KEY (TEMPLATE_ID) REFERENCES WORKFLOW(TEMPLATE_ID) ON DELETE CASCADE +); + +CREATE TABLE EDGE +( + EDGE_ID VARCHAR (255) NOT NULL, + TEMPLATE_ID VARCHAR (255) NOT NULL, + NAME VARCHAR (255), + COMPONENT_STATUS_ID VARCHAR(255), + DESCRIPTION VARCHAR(500), + PRIMARY KEY (EDGE_ID, TEMPLATE_ID), + FOREIGN KEY (TEMPLATE_ID) REFERENCES WORKFLOW(TEMPLATE_ID) ON DELETE CASCADE +); + +CREATE TABLE PORT +( + PORT_ID VARCHAR (255) NOT NULL, + TEMPLATE_ID VARCHAR (255) NOT NULL, + NAME VARCHAR (255), + COMPONENT_STATUS_ID VARCHAR(255), + DESCRIPTION VARCHAR(500), + PRIMARY KEY (PORT_ID, TEMPLATE_ID), + FOREIGN KEY (TEMPLATE_ID) REFERENCES WORKFLOW(TEMPLATE_ID) ON DELETE CASCADE +); + +CREATE TABLE NODE +( + NODE_ID VARCHAR (255) NOT NULL, + TEMPLATE_ID VARCHAR (255) NOT NULL, + NAME VARCHAR (255), + APPLICATION_ID VARCHAR (255), + APPLICATION_NAME VARCHAR (255), + COMPONENT_STATUS_ID VARCHAR(255), + DESCRIPTION VARCHAR(500), + PRIMARY KEY (NODE_ID, TEMPLATE_ID), + FOREIGN KEY (TEMPLATE_ID) REFERENCES WORKFLOW(TEMPLATE_ID) ON DELETE CASCADE +); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/airavata/blob/c4517231/modules/registry/registry-core/src/main/resources/workflow-mysql.sql ---------------------------------------------------------------------- diff --git a/modules/registry/registry-core/src/main/resources/workflow-mysql.sql b/modules/registry/registry-core/src/main/resources/workflow-mysql.sql new file mode 100644 index 0000000..945a912 --- /dev/null +++ b/modules/registry/registry-core/src/main/resources/workflow-mysql.sql @@ -0,0 +1,117 @@ +/* + * + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + * + */ + +CREATE TABLE WORKFLOW +( + TEMPLATE_ID VARCHAR (255) NOT NULL, + WORKFLOW_NAME VARCHAR (255) NOT NULL, + GRAPH LONGTEXT, + IMAGE BLOB, + PRIMARY KEY (TEMPLATE_ID) +); + +CREATE TABLE WORKFLOW_INPUT +( + TEMPLATE_ID VARCHAR(255), + INPUT_KEY VARCHAR(255), + INPUT_VALUE VARCHAR(255), + DATA_TYPE VARCHAR(255), + METADATA VARCHAR(255), + APP_ARGUMENT VARCHAR(255), + STANDARD_INPUT SMALLINT, + USER_FRIENDLY_DESC VARCHAR(255), + INPUT_ORDER INTEGER, + IS_REQUIRED SMALLINT, + REQUIRED_TO_COMMANDLINE SMALLINT, + DATA_STAGED SMALLINT, + PRIMARY KEY(TEMPLATE_ID,INPUT_KEY), + FOREIGN KEY (TEMPLATE_ID) REFERENCES WORKFLOW(TEMPLATE_ID) ON DELETE CASCADE +); + +CREATE TABLE WORKFLOW_OUTPUT +( + TEMPLATE_ID VARCHAR(255), + OUTPUT_KEY VARCHAR(255), + OUTPUT_VALUE VARCHAR(255), + DATA_TYPE VARCHAR(255), + IS_REQUIRED SMALLINT, + REQUIRED_TO_COMMANDLINE SMALLINT, + DATA_MOVEMENT SMALLINT, + DATA_NAME_LOCATION VARCHAR(255), + SEARCH_QUERY VARCHAR(255), + APP_ARGUMENT VARCHAR(255), + OUTPUT_STREAMING SMALLINT, + PRIMARY KEY(TEMPLATE_ID,OUTPUT_KEY), + FOREIGN KEY (TEMPLATE_ID) REFERENCES WORKFLOW(TEMPLATE_ID) ON DELETE CASCADE +); + +CREATE TABLE COMPONENT_STATUS +( + STATUS_ID VARCHAR (255) NOT NULL, + STATE VARCHAR(255), + REASON VARCHAR(255), + PRIMARY KEY (STATUS_ID) +); + +CREATE TABLE WORKFLOW_STATUS +( + STATUS_ID VARCHAR (255) NOT NULL, + TEMPLATE_ID VARCHAR (255) NOT NULL, + STATE VARCHAR(255), + REASON VARCHAR(255), + PRIMARY KEY (STATUS_ID, COMPONENT_ID), + FOREIGN KEY (TEMPLATE_ID) REFERENCES WORKFLOW(TEMPLATE_ID) ON DELETE CASCADE +); + +CREATE TABLE EDGE +( + EDGE_ID VARCHAR (255) NOT NULL, + TEMPLATE_ID VARCHAR (255) NOT NULL, + NAME VARCHAR (255), + COMPONENT_STATUS_ID VARCHAR(255), + DESCRIPTION VARCHAR(500), + PRIMARY KEY (EDGE_ID, TEMPLATE_ID), + FOREIGN KEY (TEMPLATE_ID) REFERENCES WORKFLOW(TEMPLATE_ID) ON DELETE CASCADE +); + +CREATE TABLE PORT +( + PORT_ID VARCHAR (255) NOT NULL, + TEMPLATE_ID VARCHAR (255) NOT NULL, + NAME VARCHAR (255), + COMPONENT_STATUS_ID VARCHAR(255), + DESCRIPTION VARCHAR(500), + PRIMARY KEY (PORT_ID, TEMPLATE_ID), + FOREIGN KEY (TEMPLATE_ID) REFERENCES WORKFLOW(TEMPLATE_ID) ON DELETE CASCADE +); + +CREATE TABLE NODE +( + NODE_ID VARCHAR (255) NOT NULL, + TEMPLATE_ID VARCHAR (255) NOT NULL, + NAME VARCHAR (255), + APPLICATION_ID VARCHAR (255), + APPLICATION_NAME VARCHAR (255), + COMPONENT_STATUS_ID VARCHAR(255), + DESCRIPTION VARCHAR(500), + PRIMARY KEY (NODE_ID, TEMPLATE_ID), + FOREIGN KEY (TEMPLATE_ID) REFERENCES WORKFLOW(TEMPLATE_ID) ON DELETE CASCADE +); \ No newline at end of file
