airavata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chath...@apache.org
Subject 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
Date Fri, 24 May 2013 16:49:15 GMT
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



Mime
View raw message