Context Navigation

prepareHiveDatabase.sql

Timestamp:

04/12/11 13:43:05 (13 years ago)

Author:

cneumuel

Message:

#1233

changed relationship between Job and HiveExperiment. There is no more HiveExperiment.RootJobId, instead there is Job.HiveExperimentId.
One HiveExperiment can now have multiple Experiments.
TreeView supports multiple root nodes
HiveEngine creates a HiveExperiment for each set of jobs, so jobs cannot be without an parent experiment anymore (no more loose jobs)
updated ExperimentManager binaries

Location:

branches/HeuristicLab.Hive-3.4/sources

Files:

Property svn:ignore

-                      r5955
+                      r6006
 GO
+--ALTER TABLE [dbo].[Job]  DROP  CONSTRAINT [HiveExperiment_Job]
+--ALTER TABLE [dbo].[Job]  WITH CHECK ADD CONSTRAINT [HiveExperiment_Job] FOREIGN KEY([HiveExperimentId])
+--REFERENCES [dbo].[HiveExperiment] ([HiveExperimentId])
+--ON UPDATE CASCADE
+--ON DELETE CASCADE
+--GO
 ALTER TABLE dbo.Plugin ALTER COLUMN PluginId ADD ROWGUIDCOL;
 ALTER TABLE dbo.Plugin WITH NOCHECK ADD CONSTRAINT [DF_Plugin_PluginId] DEFAULT (newid()) FOR PluginId;
 …
 -- =============================================
 -- Author:    cneumuel
+-- Create date: 11.11.2010
+-- Description: Deletes the root-job of the experiment when experiment is deleted
+-- Create date: 11.04.2011
+-- Description: Deletes all associated jobs. This cannot be done with cascading delete,
+--              because the job table defines a INSTEAD OF DELETE trigger itself, which
+--              is not compatible with cascading deletes.
 -- =============================================
 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
+ALTER TRIGGER [dbo].[tr_HiveExperimentDeleteCascade] ON [dbo].[HiveExperiment] INSTEAD OF DELETE AS
+BEGIN
+  DELETE Job FROM Job WHERE Job.HiveExperimentId = HiveExperimentId
+END
 SET ANSI_NULLS ON

Note: See TracChangeset for help on using the changeset viewer.