Changeset 4769

Timestamp:

11/11/10 10:46:12 (13 years ago)

Author:

cneumuel

Message:

#1260

• delete cascade for HiveExperiments and Jobs database
• automatic downloading of HiveExperiments-List in HiveExperimentManager

Location:

branches/HeuristicLab.Hive/sources/HeuristicLab.Hive

Files:

• HeuristicLab.Calendar/3.3/Properties/AssemblyInfo.cs (modified) (1 diff)
• HeuristicLab.Hive.ExperimentManager.Views/3.3/HiveExperimentManagerView.cs (modified) (3 diffs)
• HeuristicLab.Hive.ExperimentManager.Views/3.3/HiveExperimentView.Designer.cs (modified) (2 diffs)
• HeuristicLab.Hive.ExperimentManager.Views/3.3/HiveExperimentView.resx (modified) (1 diff)
• HeuristicLab.Hive.ExperimentManager/3.3/HeuristicLab.Hive.ExperimentManager-3.3.csproj (modified) (1 diff)
• HeuristicLab.Hive.ExperimentManager/3.3/HiveClient.cs (deleted)
• HeuristicLab.Hive.ExperimentManager/3.3/HiveExperimentManager.cs (added)
• HeuristicLab.Hive.Server.LINQDataAccess/3.3/Scripts/prepareHiveDatabase.sql (modified) (4 diffs)

branches/HeuristicLab.Hive/sources/HeuristicLab.Hive/HeuristicLab.Calendar/3.3/Properties/AssemblyInfo.cs

@@ -58 +58 @@
 // [assembly: AssemblyVersion("1.0.*")]
 [assembly: AssemblyVersion("3.3.0.0")]
-[assembly: AssemblyFileVersion("3.3.0.4755")]
+[assembly: AssemblyFileVersion("3.3.0.4760")]

branches/HeuristicLab.Hive/sources/HeuristicLab.Hive/HeuristicLab.Hive.ExperimentManager.Views/3.3/HiveExperimentManagerView.cs

@@ -53 +53 @@
       Content_HiveExperimentsChanged(this, EventArgs.Empty);
       Content_IsProgressingChanged(this, EventArgs.Empty);
+      if(Content != null) UpdateExperimentsAsync();
     }
 
@@ -78 +79 @@
 
     private void updateExperimentsButton_Click(object sender, EventArgs e) {
-      MethodInvoker invoker = new MethodInvoker(Content.UpdateExperimentList);
-      invoker.BeginInvoke((ar) => {
-        try {
-          invoker.EndInvoke(ar);
-        }
-        catch (Exception ex) {
-          ThreadPool.QueueUserWorkItem(delegate(object exception) { ErrorHandling.ShowErrorDialog(this, (Exception)exception); }, ex);
-        }
-      }, null);
+      if(Content != null) UpdateExperimentsAsync();
     }
 
@@ -116 +109 @@
       }
     }
+
+    private void UpdateExperimentsAsync() {
+      MethodInvoker invoker = new MethodInvoker(Content.UpdateExperimentList);
+      invoker.BeginInvoke((ar) => {
+        try {
+          invoker.EndInvoke(ar);
+        }
+        catch (Exception ex) {
+          ThreadPool.QueueUserWorkItem(delegate(object exception) { ErrorHandling.ShowErrorDialog(this, (Exception)exception); }, ex);
+        }
+      }, null);
+    }
   }
 }

branches/HeuristicLab.Hive/sources/HeuristicLab.Hive/HeuristicLab.Hive.ExperimentManager.Views/3.3/HiveExperimentView.Designer.cs

@@ -313 +313 @@
       this.disconnectButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
       this.disconnectButton.Enabled = false;
-      this.disconnectButton.Location = new System.Drawing.Point(131, 500);
+      this.disconnectButton.Location = new System.Drawing.Point(234, 500);
       this.disconnectButton.Name = "disconnectButton";
       this.disconnectButton.Size = new System.Drawing.Size(120, 24);
       this.disconnectButton.TabIndex = 15;
-      this.disconnectButton.Text = "Disconnect from Hive";
+      this.disconnectButton.Text = "Stop Result Polling";
       this.toolTip.SetToolTip(this.disconnectButton, "Disconnect from Hive (Jobs will be continue to be calculated)");
       this.disconnectButton.UseVisualStyleBackColor = true;
@@ -326 +326 @@
       this.reconnectButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
       this.reconnectButton.Enabled = false;
-      this.reconnectButton.Location = new System.Drawing.Point(257, 500);
+      this.reconnectButton.Location = new System.Drawing.Point(120, 500);
       this.reconnectButton.Name = "reconnectButton";
-      this.reconnectButton.Size = new System.Drawing.Size(77, 24);
+      this.reconnectButton.Size = new System.Drawing.Size(108, 24);
       this.reconnectButton.TabIndex = 16;
-      this.reconnectButton.Text = "Reconnect";
+      this.reconnectButton.Text = "Start Result Polling";
       this.toolTip.SetToolTip(this.reconnectButton, "Reconnect to Hive");
       this.reconnectButton.UseVisualStyleBackColor = true;

branches/HeuristicLab.Hive/sources/HeuristicLab.Hive/HeuristicLab.Hive.ExperimentManager.Views/3.3/HiveExperimentView.resx

@@ -204 +204 @@
         fNTws+7PbaOWo6fHXMf6Hwc/vj/OGn/2S8Yv7ycKnpCfVEyqTDZPmU2dmnafvvF05dOJZ+nPFmYKf5X+
         tfa5zvMffnP8rX82YnbiBf/Fp99LXsq/PPRq2aueuYC5R69TXy/MF72Rf3P4LeNt37vwd5MLWe+x7ys/
-        6H7o/ujz8cGn1E+f/gUDmPP8usTo0wAAAAlwSFlzAAAOvgAADr4B6kKxwAAAA2JJREFUOE9lk31MFHQY
+        6H7o/ujz8cGn1E+f/gUDmPP8usTo0wAAAAlwSFlzAAAOvQAADr0BR/uQrQAAA2JJREFUOE9lk31MFHQY
         x59JZIU62/QPF1gauDJXjkpyZLxVMEEubgpKU0NePKS6yp168qaJ4OIlMhUH6hRWChyuuuTaQjqFk8j0
         MEhlURdMRgp0XERccfjpx7G1Vn8822+/fb/fz/f54xFA/jtDf03S4fyTloE/6PhlFNfvY0xMTCjZ/7X/

branches/HeuristicLab.Hive/sources/HeuristicLab.Hive/HeuristicLab.Hive.ExperimentManager/3.3/HeuristicLab.Hive.ExperimentManager-3.3.csproj

@@ -125 +125 @@
     <Compile Include="JobResultPoller.cs" />
     <Compile Include="Exceptions\JobResultPollingException.cs" />
-    <Compile Include="HiveClient.cs" />
+    <Compile Include="HiveExperimentManager.cs" />
     <Compile Include="HiveExperimentList.cs" />
     <Compile Include="HeuristicLabHiveExperimentManagerPlugin.cs" />

branches/HeuristicLab.Hive/sources/HeuristicLab.Hive/HeuristicLab.Hive.Server.LINQDataAccess/3.3/Scripts/prepareHiveDatabase.sql

@@ -1 +1 @@
 /* this script is supposed to be executed after the plain DB is generated by the linq-to-sql schema */
+USE [HeuristicLab.Hive]
+GO
 
 /*
@@ -32 +34 @@
 ALTER TABLE dbo.AssignedResources ALTER COLUMN AssignedRessourcesId ADD ROWGUIDCOL;
 ALTER TABLE dbo.AssignedResources WITH NOCHECK ADD CONSTRAINT [DF_AssignedResources_AssignedRessourcesId] DEFAULT (newid()) FOR AssignedRessourcesId;
+ALTER TABLE [dbo].[AssignedResources]  DROP  CONSTRAINT [Job_AssignedResource]
+ALTER TABLE [dbo].[AssignedResources]  WITH CHECK ADD  CONSTRAINT [Job_AssignedResource] FOREIGN KEY([JobId])
+REFERENCES [dbo].[Job] ([JobId])
+ON UPDATE CASCADE
+ON DELETE CASCADE
+GO
+ALTER TABLE [dbo].[AssignedResources]  DROP  CONSTRAINT [Resource_AssignedResource]
+ALTER TABLE [dbo].[AssignedResources]  WITH CHECK ADD  CONSTRAINT [Resource_AssignedResource] FOREIGN KEY([ResourceId])
+REFERENCES [dbo].[Resource] ([ResourceId])
+ON UPDATE CASCADE
+ON DELETE CASCADE
+GO
 
 ALTER TABLE dbo.Job ALTER COLUMN JobId ADD ROWGUIDCOL;
@@ -51 +65 @@
 ALTER TABLE dbo.RequiredPlugins WITH NOCHECK ADD CONSTRAINT [DF_RequiredPlugins_RequiredPluginId] DEFAULT (newid()) FOR RequiredPluginId;
 
+ALTER TABLE [dbo].[RequiredPlugins]  DROP  CONSTRAINT [Job_RequiredPlugin]
+ALTER TABLE [dbo].[RequiredPlugins]  WITH CHECK ADD  CONSTRAINT [Job_RequiredPlugin] FOREIGN KEY([JobId])
+REFERENCES [dbo].[Job] ([JobId])
+ON UPDATE CASCADE
+ON DELETE CASCADE
+GO
+
+ALTER TABLE [dbo].[RequiredPlugins]  DROP  CONSTRAINT [PluginInfo_RequiredPlugin]
+ALTER TABLE [dbo].[RequiredPlugins]  WITH CHECK ADD  CONSTRAINT [PluginInfo_RequiredPlugin] FOREIGN KEY([PluginId])
+REFERENCES [dbo].[PluginInfo] ([PluginId])
+ON UPDATE CASCADE
+ON DELETE CASCADE
+GO
+
 ALTER TABLE dbo.Resource ALTER COLUMN ResourceId ADD ROWGUIDCOL;
 ALTER TABLE dbo.Resource WITH NOCHECK ADD CONSTRAINT [DF_Resource_ResourceId] DEFAULT (newid()) FOR ResourceId;
@@ -65 +93 @@
 /* create indices */
 CREATE INDEX Index_RequiredPlugins_JobId ON RequiredPlugins(JobId);
+
+/* triggers */
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+-- =============================================
+-- Author:    cneumuel
+-- Create date: 11.11.2010
+-- Description: Deletes the root-job of the experiment when experiment is deleted
+-- =============================================
+CREATE TRIGGER [dbo].[tr_HiveExperimentDeleteCascade] ON [dbo].[HiveExperiment] FOR DELETE AS 
+SET NOCOUNT ON
+DELETE Job FROM deleted, Job WHERE Job.JobId = deleted.RootJobId
+GO
+
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+-- =============================================
+-- Author:    cneumuel
+-- Create date: 11.11.2010
+-- Description: Recursively deletes all child-jobs of a job when it is deleted. (Source: http://devio.wordpress.com/2008/05/23/recursive-delete-in-sql-server/)
+-- =============================================
+CREATE TRIGGER [dbo].[tr_JobDeleteCascade] ON [dbo].[Job] INSTEAD OF DELETE AS 
+BEGIN
+  CREATE TABLE #Table( 
+    JobId uniqueidentifier 
+  )
+  INSERT INTO #Table (JobId)
+  SELECT JobId FROM deleted
+  
+  DECLARE @c INT
+  SET @c = 0
+  
+  WHILE @c <> (SELECT COUNT(JobId) FROM #Table) BEGIN
+    SELECT @c = COUNT(JobId) FROM #Table
+    
+    INSERT INTO #Table (JobId)
+      SELECT Job.JobId
+      FROM Job
+      LEFT OUTER JOIN #Table ON Job.JobId = #Table.JobId
+      WHERE Job.ParentJobId IN (SELECT JobId FROM #Table)
+        AND #Table.JobId IS NULL
+  END
+  
+  DELETE Job FROM Job INNER JOIN #Table ON Job.JobId = #Table.JobId
+END