Changeset 2205 for branches/HeuristicLab.Modeling Database Backend

Timestamp:

07/29/09 13:39:43 (15 years ago)

Author:

mkommend

Message:

added functionality in database backend to query inputvariable results (ticket #712)

Location:

branches/HeuristicLab.Modeling Database Backend/sources

Files:

• HeuristicLab.Modeling.Database.SQLServerCompact/3.2/DatabaseService.cs (modified) (2 diffs)
• HeuristicLab.Modeling.Database/3.2/IModelingDatabase.cs (modified) (1 diff)

branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/DatabaseService.cs

@@ -60 +60 @@
       using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
         foreach (string inputVariable in algorithm.Model.InputVariables) {
-          ctx.InputVariables.InsertOnSubmit(new InputVariable(model, variables[inputVariable]));
-        }
+          ctx.InputVariables.InsertOnSubmit(new InputVariable(model, variables[inputVariable]));          
+        }
+        ctx.SubmitChanges();
       }
 
@@ -209 +210 @@
     #endregion
 
+    #region InputVariableResults
+    public IEnumerable<IInputVariableResult> GetInputVariableResults(IModel model) {
+      ModelingDataContext ctx = new ModelingDataContext(connection);
+      DataLoadOptions dlo = new DataLoadOptions();
+      dlo.LoadWith<InputVariableResult>(ir => ir.Variable);
+      dlo.LoadWith<InputVariableResult>(ir => ir.Result);
+      dlo.LoadWith<InputVariableResult>(ir => ir.Model);
+      ctx.LoadOptions = dlo;
+
+      var inputResults = from ir in ctx.InputVariableResults
+                         where ir.Model == model
+                         select ir;
+      return inputResults.ToList().Cast<IInputVariableResult>();
+    }
+
+    #endregion
+
     #region Model
     public IEnumerable<IModel> GetAllModels() {

branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.Database/3.2/IModelingDatabase.cs

@@ -31 +31 @@
     IEnumerable<IResult> GetAllResults();
     IEnumerable<IModelResult> GetModelResults(IModel model);
+    IEnumerable<IInputVariableResult> GetInputVariableResults(IModel model);
   }
 }