You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by ch...@apache.org on 2013/05/24 18:49:15 UTC
svn commit: r1486114 - in /airavata/trunk/tools: pom.xml
registry-tool/src/main/resources/db-scripts/0.8/migrate_derby.sql
registry-tool/src/main/resources/db-scripts/0.8/migrate_mysql.sql
Author: chathuri
Date: Fri May 24 16:49:15 2013
New Revision: 1486114
URL: http://svn.apache.org/r1486114
Log:
updating registry migrate tool with Gfac_Job_Data changes
Modified:
airavata/trunk/tools/pom.xml
airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_derby.sql
airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_mysql.sql
Modified: airavata/trunk/tools/pom.xml
URL: http://svn.apache.org/viewvc/airavata/trunk/tools/pom.xml?rev=1486114&r1=1486113&r2=1486114&view=diff
==============================================================================
--- airavata/trunk/tools/pom.xml (original)
+++ airavata/trunk/tools/pom.xml Fri May 24 16:49:15 2013
@@ -35,8 +35,8 @@
</modules>
</profile>
</profiles>
- <properties>
- <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
- <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
- </properties>
+ <!--<properties>-->
+ <!--<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>-->
+ <!--<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>-->
+ <!--</properties>-->
</project>
Modified: airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_derby.sql
URL: http://svn.apache.org/viewvc/airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_derby.sql?rev=1486114&r1=1486113&r2=1486114&view=diff
==============================================================================
--- airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_derby.sql (original)
+++ airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_derby.sql Fri May 24 16:49:15 2013
@@ -38,4 +38,27 @@ CREATE TABLE Execution_Error
PRIMARY KEY(error_id),
FOREIGN KEY (workflow_instanceID) REFERENCES Workflow_Data(workflow_instanceID) ON DELETE CASCADE,
FOREIGN KEY (experiment_ID) REFERENCES Experiment_Data(experiment_ID) ON DELETE CASCADE
-);
\ No newline at end of file
+);
+
+create table GFac_Job_Data
+(
+ experiment_ID varchar(255),
+ workflow_instanceID varchar(255),
+ node_id varchar(255),
+ application_descriptor_ID varchar(255),
+ host_descriptor_ID varchar(255),
+ service_descriptor_ID varchar(255),
+ job_data CLOB,
+ local_Job_ID varchar(255),
+ submitted_time TIMESTAMP DEFAULT '0000-00-00 00:00:00',
+ completed_time TIMESTAMP DEFAULT '0000-00-00 00:00:00',
+ status INT,
+ metadata CLOB,
+ PRIMARY KEY(local_Job_ID),
+ FOREIGN KEY (experiment_ID) REFERENCES Experiment_Data(experiment_ID),
+ FOREIGN KEY (workflow_instanceID) REFERENCES Workflow_Data(workflow_instanceID)
+);
+
+INSERT INTO GFac_Job_Data(experiment_ID, workflow_instanceID, node_id, application_descriptor_ID, host_descriptor_ID, service_descriptor_ID,
+job_data, local_Job_ID, submitted_time, completed_time, status, metadata) SELECT null, workflow_instanceID, node_id, null, invoked_host,
+null, null, local_Job_ID, null, null, null, null FROM Gram_Data;
\ No newline at end of file
Modified: airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_mysql.sql
URL: http://svn.apache.org/viewvc/airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_mysql.sql?rev=1486114&r1=1486113&r2=1486114&view=diff
==============================================================================
--- airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_mysql.sql (original)
+++ airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_mysql.sql Fri May 24 16:49:15 2013
@@ -38,4 +38,27 @@ CREATE TABLE Execution_Error
PRIMARY KEY(error_id),
FOREIGN KEY (workflow_instanceID) REFERENCES Workflow_Data(workflow_instanceID) ON DELETE CASCADE,
FOREIGN KEY (experiment_ID) REFERENCES Experiment_Data(experiment_ID) ON DELETE CASCADE
-);
\ No newline at end of file
+);
+
+create table GFac_Job_Data
+(
+ experiment_ID varchar(255),
+ workflow_instanceID varchar(255),
+ node_id varchar(255),
+ application_descriptor_ID varchar(255),
+ host_descriptor_ID varchar(255),
+ service_descriptor_ID varchar(255),
+ job_data LONGTEXT,
+ local_Job_ID varchar(255),
+ submitted_time TIMESTAMP DEFAULT '0000-00-00 00:00:00',
+ completed_time TIMESTAMP DEFAULT '0000-00-00 00:00:00',
+ status INT,
+ metadata LONGTEXT,
+ PRIMARY KEY(local_Job_ID),
+ FOREIGN KEY (experiment_ID) REFERENCES Experiment_Data(experiment_ID),
+ FOREIGN KEY (workflow_instanceID) REFERENCES Workflow_Data(workflow_instanceID)
+);
+
+INSERT INTO GFac_Job_Data(experiment_ID, workflow_instanceID, node_id, application_descriptor_ID, host_descriptor_ID, service_descriptor_ID,
+job_data, local_Job_ID, submitted_time, completed_time, status, metadata) SELECT null, workflow_instanceID, node_id, null, invoked_host,
+null, null, local_Job_ID, null, null, null, null FROM Gram_Data;
\ No newline at end of file