Changeset 2355 for trunk/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2

Timestamp:

09/15/09 09:47:38 (15 years ago)

Author:

mkommend

Message:

stored model metadata into modeling.database
changed analyzermodel to use dictionary of string, object (ticket #731)

Location:

trunk/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2

Files:

• DataObjects/MetaData.cs (added)
• DataObjects/ModelMetaData.cs (added)
• DatabaseService.cs (modified) (3 diffs)
• HeuristicLab.Modeling.Database.SQLServerCompact-3.2.csproj (modified) (1 diff)
• ModelingDataContext.cs (modified) (1 diff)

trunk/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/DatabaseService.cs

@@ -56 +56 @@
       DataLoadOptions dlo = new DataLoadOptions();
       dlo.LoadWith<ModelResult>(mr => mr.Result);
+      dlo.LoadWith<ModelMetaData>(mmd => mmd.MetaData);
       dlo.LoadWith<InputVariableResult>(ir => ir.Variable);
       dlo.LoadWith<InputVariableResult>(ir => ir.Result);
       dlo.LoadWith<Model>(m => m.TargetVariable);
-      dlo.LoadWith<Model>(m => m.Algorithm);
+      dlo.LoadWith<Model>(m => m.Algorithm);      
       ctx.LoadOptions = dlo;
     }
@@ -117 +118 @@
 
       // code to store meta-information for models (gkronber (8.9.09))
-      //using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
-      //  foreach (KeyValuePair<string, double> pair in model.MetaData) {
-      //    MetaData metaData = GetOrCreateMetaData(pair.Key);
-      //    ctx.ModelMetaData.InsertOnSubmit(new ModelMetaData(m, metaData, pair.Value));
-      //  }
-      //  ctx.SubmitChanges();
-      //}
+      using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
+        foreach (KeyValuePair<string, double> pair in model.MetaData) {
+          MetaData metaData = GetOrCreateMetaData(pair.Key);
+          ctx.ModelMetaData.InsertOnSubmit(new ModelMetaData(m, metaData, pair.Value));
+        }
+        ctx.SubmitChanges();
+      }
 
       using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
@@ -267 +268 @@
     #endregion
 
+    #region ModelMetaData
+    public IEnumerable<IModelMetaData> GetModelMetaData(IModel model) {
+      var metadata = from md in ctx.ModelMetaData
+                     where md.Model == model
+                     select md;
+      return metadata.ToList().Cast<IModelMetaData>();
+    }
+    #endregion
+
+    #region MetaData
+    public IEnumerable<IMetaData> GetAllMetaData() {
+      return ctx.MetaData.ToList().Cast<IMetaData>();
+    }
+
+    public MetaData GetOrCreateMetaData(string name) {
+      MetaData metadata;
+      using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
+        var md = from r in ctx.MetaData
+                      where r.Name == name
+                      select r;
+        if (md.Count() == 0) {
+          metadata = new MetaData(name);
+          ctx.MetaData.InsertOnSubmit(metadata);
+          ctx.SubmitChanges();
+        } else if (md.Count() == 1)
+          metadata = md.Single();
+        else
+          throw new ArgumentException("Could not get metadata. More than one metadata with the name " + name + " are saved in database.");
+      }
+      return metadata;
+    }
+
+    #endregion
+
     #region Model
     public IEnumerable<IModel> GetAllModels() {

trunk/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/HeuristicLab.Modeling.Database.SQLServerCompact-3.2.csproj

@@ -121 +121 @@
     <Compile Include="DataObjects\InputVariable.cs" />
     <Compile Include="DataObjects\InputVariableResult.cs" />
+    <Compile Include="DataObjects\MetaData.cs" />
     <Compile Include="DataObjects\Model.cs" />
     <Compile Include="DataObjects\ModelData.cs" />
+    <Compile Include="DataObjects\ModelMetaData.cs" />
     <Compile Include="HeuristicLabModelingDatabaseSQLServerCompactPlugin.cs" />
     <Compile Include="ModelingDataContext.cs" />

trunk/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/ModelingDataContext.cs

@@ -66 +66 @@
     }
 
+    public Table<ModelMetaData> ModelMetaData {
+      get { return GetTable<ModelMetaData>(); }
+    }
+
+    public Table<MetaData> MetaData {
+      get { return GetTable<MetaData>(); }
+    }
+
     public Table<InputVariable> InputVariables {
       get { return GetTable<InputVariable>(); }